File manager - Edit - G:/PleskVhosts/indiaminerals.in/vgm.INFOFIXDEVELOPERS.COM/admin/Dashboard.aspx.cs
Back
using DevExpress.Printing.Core.PdfExport.Metafile; using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.IO; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WebApp.LIBS; using static VGM.admin.DetailGridView; namespace VGM.admin { public partial class Dashboard : BasePageClass { string cs = ConfigurationManager.ConnectionStrings["gav"].ConnectionString; private readonly string logFilePath = "~/data/LogData.csv"; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string connectionString = ConfigurationManager.ConnectionStrings["gav"].ConnectionString; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); label1.Text = GetCountFromDatabase(conn, "SELECT COUNT(*) FROM discharge WHERE discharge = 'Transfer to Own Gaushala'").ToString(); label2.Text = GetCountFromDatabase(conn, "SELECT COUNT(*) FROM registration WHERE status IN ('Admitted')").ToString(); label3.Text = GetCountFromDatabase(conn, "SELECT COUNT(*) FROM stock WHERE purchase_stock <= 5").ToString(); label4.Text = GetCountFromDatabase(conn, "SELECT COUNT(*) FROM purchase WHERE DATEDIFF(MONTH, GETDATE(), Expiry_date) = 1").ToString(); string query = "SELECT r.tag_no, r.animal_category FROM registration r " + "WHERE r.status IN ('Own', 'Admitted') " + "AND NOT EXISTS(SELECT 1 FROM observation o WHERE o.Tag_no = r.tag_no AND o.Date = @TodayDate)"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query, con)) { cmd.Parameters.AddWithValue("@TodayDate", DateTime.Now.Date); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt1 = new DataTable(); da.Fill(dt1); Gridview1.DataSource = dt1; Gridview1.DataBind(); } } string query1 = @"SELECT * FROM detailform WHERE MONTH(BirthDate) = @Month AND DAY(BirthDate) = @Day"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query1, con)) { cmd.Parameters.AddWithValue("@Month", DateTime.Now.Month); cmd.Parameters.AddWithValue("@Day", DateTime.Now.Day); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt1 = new DataTable(); da.Fill(dt1); ViewState["TodayBirthdayData"] = dt1; } } string query2 = @"SELECT * FROM detailform WHERE MONTH(AnniversaryDate) = @Month AND DAY(AnniversaryDate) = @Day"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query2, con)) { cmd.Parameters.AddWithValue("@Month", DateTime.Now.Month); cmd.Parameters.AddWithValue("@Day", DateTime.Now.Day); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt1 = new DataTable(); da.Fill(dt1); ViewState["TodayAnnyData"] = dt1; } } string query3 = @"SELECT * FROM detailform WHERE MONTH(BirthDate) = @Month AND DAY(BirthDate) = @Day"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query3, con)) { cmd.Parameters.AddWithValue("@Month", DateTime.Today.AddDays(1).Month); cmd.Parameters.AddWithValue("@Day", DateTime.Today.AddDays(1).Day); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt1 = new DataTable(); da.Fill(dt1); ViewState["TomorrowBirthdayData"] = dt1; } } string query4 = @"SELECT * FROM detailform WHERE MONTH(AnniversaryDate) = @Month AND DAY(AnniversaryDate) = @Day"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query4, con)) { cmd.Parameters.AddWithValue("@Month", DateTime.Today.AddDays(1).Month); cmd.Parameters.AddWithValue("@Day", DateTime.Today.AddDays(1).Day); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt1 = new DataTable(); da.Fill(dt1); ViewState["TomorrowAnnyData"] = dt1; } } DataTable dt = new DataTable(); dt.Columns.Add("Label5"); dt.Columns.Add("Label6"); dt.Columns.Add("Label7"); dt.Columns.Add("Label8"); dt.Columns.Add("Label9"); dt.Columns.Add("Label14"); DataRow row = dt.NewRow(); row["Label5"] = GetCountFromDatabase(conn, "SELECT COUNT(*) FROM registration"); row["Label6"] = GetCountFromDatabase(conn, "SELECT COUNT(*) FROM registration WHERE status IN ('Own', 'Admitted')"); row["Label7"] = GetSumFromDatabase(conn, "SELECT SUM(Quantity) FROM issue"); row["Label8"] = GetSumFromDatabase(conn, "SELECT SUM(Quantity) FROM purchase WHERE Medicine_by = 'Donor'"); row["Label9"] = GetSumFromDatabase(conn, "SELECT SUM(Purchase_stock) FROM stock"); SqlCommand cmdTodayDate = new SqlCommand("SELECT COUNT(*) FROM registration r WHERE r.status IN ('Own', 'Admitted') AND NOT EXISTS(SELECT 1 FROM observation o WHERE o.Tag_no = r.tag_no AND o.Date = @TodayDate)", conn); cmdTodayDate.Parameters.AddWithValue("@TodayDate", DateTime.Now.Date); row["Label14"] = (int)cmdTodayDate.ExecuteScalar(); dt.Rows.Add(row); Gridview2.DataSource = dt; Gridview2.DataBind(); LoadLogData(); } } } public string JavaScriptEncode(object value) { return HttpUtility.JavaScriptStringEncode(value.ToString()); } protected void SendMessage_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(MSGTextArea.Text)) { ShowSweetAlert("Error", "Please enter message for sending", "error"); return; } string contactNo = hiddenContactNo.Value; if (contactNo.Length != 10 || !contactNo.All(char.IsDigit)) { ShowSweetAlert("Error", "Please provide a valid 10-digit number for sending MSG", "error"); return; } string message = MSGTextArea.Text; string whatsappUrl = $"https://wa.me/{contactNo}?text={Uri.EscapeDataString(message)}"; ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenWhatsapp", $@" setTimeout(function() {{ window.location = '{whatsappUrl}'; var timeout = setTimeout(function() {{ alert('The number is not found on WhatsApp!'); showToast('Warning', 'Number not found on WhatsApp!', 'warning'); }}, 3000); }}, 500);", true); } private int GetCountFromDatabase(SqlConnection conn, string query) { int count = 0; using (SqlCommand cmd = new SqlCommand(query, conn)) { count = (int)cmd.ExecuteScalar(); } return count; } private int GetSumFromDatabase(SqlConnection conn, string query) { int sum = 0; using (SqlCommand cmd = new SqlCommand(query, conn)) { object result = cmd.ExecuteScalar(); if (result != DBNull.Value) { sum = (int)result; } } return sum; } private void LoadLogData() { try { DataTable dt = ReadCsvToDataTable(Server.MapPath(logFilePath)); DataView dv = dt.DefaultView; dv.Sort = "Date DESC"; DataTable dtLatest10Records = dv.ToTable().AsEnumerable().Take(10).CopyToDataTable(); GridviewLogData.DataSource = dtLatest10Records; GridviewLogData.DataBind(); } catch (Exception ex) { Response.Write("<script>alert('An error occurred while loading LogData: " + ex.Message + "')</script>"); } } private DataTable ReadCsvToDataTable(string filePath) { DataTable dt = new DataTable(); // Read the lines of the CSV file string[] lines = File.ReadAllLines(filePath); if (lines.Length > 0) { // Assume the first line contains column headers string[] headers = lines[0].Split(','); // Add columns to the DataTable foreach (string header in headers) { dt.Columns.Add(header.Trim('\"')); } // Add data rows to the DataTable for (int i = 1; i < lines.Length; i++) { string[] data = lines[i].Split(','); DataRow row = dt.NewRow(); for (int j = 0; j < headers.Length; j++) { row[j] = data[j].Trim('\"'); } dt.Rows.Add(row); } } return dt; } protected void Gridview2_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e) { } protected void Gridview1_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (e.CommandName == "Observe") { int rowIndex = Convert.ToInt32(e.CommandArgument); GridViewRow row = Gridview1.Rows[rowIndex]; string tagNo = row.Cells[1].Text; Session["ObservationTag"] = tagNo; Response.Redirect($"Observation.aspx?Tag_no={tagNo}"); } } protected void viewall_Click(object sender, EventArgs e) { Response.Redirect("~/admin/Logs_Report.aspx"); } protected void ShowSweetAlert(string title, string message, string icon) { string script = $@" Swal.fire({{ text: '{message}', icon: '{icon}', toast: true, position: 'top-right', showConfirmButton: false, timer: 5000, customClass: {{ popup: 'swal2-small' }} }});"; ScriptManager.RegisterStartupScript(this, GetType(), "alert", script, true); } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.05 |
proxy
|
phpinfo
|
Settings