private void button1_Click(object sender, EventArgs e) { dashboard dash = new dashboard(); //go to login form dash.Show(); //show login form this.Hide(); //hide app form }
public ActionResult Approve(int id) { dashboard data = context.dashboards.Find(id); data.BookingStatus = "Approved"; int ID = (int)data.EmpID; var employee = context.employees.FirstOrDefault(x => x.EmpID == ID); var Email = employee.Email; MailMessage mailcontext = new MailMessage("*****@*****.**", Email); mailcontext.Subject = "Booking Status"; mailcontext.Body = "Your Booking has benn confirmed"; mailcontext.IsBodyHtml = false; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; NetworkCredential nc = new NetworkCredential("*****@*****.**", "DXCGREADMIN"); smtp.UseDefaultCredentials = true; smtp.Credentials = nc; smtp.Send(mailcontext); context.SaveChanges(); return(RedirectToAction("Dashboard")); }
public void DailyFeesUpdate() { dashboard db = new dashboard(); dashboardMain dmain = new dashboardMain(); Task t1, t2, t3, t4; t1 = Task.Factory.StartNew(() => db.bank_received = dmain.bank_received()); t2 = Task.Factory.StartNew(() => db.cash_received = dmain.cash_received()); t3 = Task.Factory.StartNew(() => db.total_bank_received = dmain.total_bank_received()); t4 = Task.Factory.StartNew(() => db.total_cash_received = dmain.total_cash_received()); var tasklist = new List <Task> { t1, t2, t3, t4 }; Task.WaitAll(tasklist.ToArray()); db.fees_received = db.bank_received + db.cash_received; db.total_cash_bank_received = db.total_bank_received + db.total_cash_received; decimal[] fees = { db.fees_received, db.cash_received, db.bank_received, db.total_cash_bank_received, db.total_cash_received, db.total_bank_received }; var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>(); Task.Factory.StartNew(() => context.Clients.All.DashBoadDailyFeesUpdate(fees)); DashboardClassWiseDuesChart(); }
private void bunifuThinButton21_Click(object sender, EventArgs e) { try { string con = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database\DB.mdf;Integrated Security=True"; SqlConnection sqlConn = new SqlConnection(con); String query = "SELECT * FROM dbo.[User] WHERE Username ='******' AND Password ='******'"; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query, sqlConn); DataTable data = new DataTable(); sqlDataAdapter.Fill(data); if (data.Rows.Count == 1) { dashboard dash = new dashboard(); dash.Show(); this.Hide(); } else { MessageBox.Show("Wrong username/ password !!"); } } catch (Exception ex) { MessageBox.Show("Please Connect To The database"); } }
public IActionResult Continue() { if (!_db.Person.Any(c => c.UserId == User.Claims.First().Value)) { try { return(RedirectToAction("CompleteRegistration")); } catch (Exception) { throw; } } ViewData.Add("Title", "dashbaord"); dashboard d = new dashboard(_db); d.init(User.Claims.First().Value); if (d.CurrentUser == null) { return(RedirectToAction("CompleteRegistration")); } return(View(d)); }
private void button1_Click(object sender, EventArgs e) { this.Hide(); dashboard dashhhh = new dashboard(); dashhhh.Show(); }
private void Button2_Click(object sender, EventArgs e) { if (dash.IsDisposed == true) { dash = new dashboard(); } dash.Show(); }
private void button1_Click(object sender, EventArgs e) { dashboard dash = new dashboard(); //next to app form dash = new dashboard(); dash.Show(); //show app form this.Hide(); //login form hide }
public ActionResult RemoveBooking(int id) { dashboard data = context.dashboards.Find(id); context.dashboards.Remove(data); context.SaveChanges(); return(RedirectToAction("ServicesBooked")); }
private void button1_Click(object sender, EventArgs e) { //Application.Exit(); // this is not good for this dashboard dash = new dashboard(); //next to app form dash = new dashboard(); dash.Show(); //show app form this.Hide(); //login form hide }
public ActionResult In() { var myrole = new Class1(); var userID = User.Identity.GetUserId(); ViewBag.currentrole = myrole.a(userID); var users = from u in context.Users from ur in u.Roles join r in context.Roles on ur.RoleId equals r.Id select new { UserId = u.Id, Name = u.UserName, Email = u.Email, Role = r.Name }; int counterAdmin = 0, counterUser = 0, counterPending = 0, counterBanned = 0; foreach (var item in users) { if (item.Role == "Admin") { counterAdmin = counterAdmin + 1; } else if (item.Role == "User") { counterUser = counterUser + 1; } else if (item.Role == "Pending") { counterPending = counterPending + 1; } else if (item.Role == "Banned") { counterBanned = counterBanned + 1; } } ViewBag.counterAdmin = counterAdmin; ViewBag.counterUser = counterUser; ViewBag.counterPending = counterPending; ViewBag.counterBanned = counterBanned; //dashboard mod1 = new dashboard(); //var ann = from m in db.announcements select m; //ann = ann.OrderByDescending(ca => ca.date).Take(4); //var pcprob= from m in db.PcProblems select m; //pcprob = pcprob.OrderByDescending(ca => ca.date).Take(4); var cm = new dashboard { announcements = db.announcements.OrderByDescending(ca => ca.date).Take(4).ToList(), PcProblems = db.PcProblems.OrderByDescending(ca => ca.date).Take(4).ToList() }; //mod1.announcements = ann.ToList(); //mod1.PcProblems = pcprob.ToList(); return(View(cm)); }
private void loginloginlogin() { try { if (bunifuMaterialTextbox1.Text == string.Empty && bunifuMaterialTextbox2.Text == string.Empty) { bunifuCustomLabel8.Visible = true; bunifuCustomLabel6.Visible = true; bunifuCustomLabel7.Visible = true; timer1.Start(); } else { //bunifuCircleProgressbar1.Visible = true; string stringcon = System.Configuration.ConfigurationManager.ConnectionStrings["residenceBDcon"].ConnectionString; SqlConnection con = new SqlConnection(stringcon); SqlCommand cmd = new SqlCommand("select * from echipa where email=@LEMAIL and parola=@LPAROLA", con); cmd.Parameters.AddWithValue("@LEMAIL", bunifuMaterialTextbox1.Text); cmd.Parameters.AddWithValue("@LPAROLA", bunifuMaterialTextbox2.Text); Email = bunifuMaterialTextbox1.Text; SqlDataAdapter dt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); dt.Fill(ds); int count = ds.Tables[0].Rows.Count; if (count == 1) { bunifuCircleProgressbar1.Visible = true; dashboard dash = new dashboard(); //next to app form dash = new dashboard(); dash.Show(); //show app form this.Hide(); //login form hide //bunifuCircleProgressbar1.Visible = false; } else { bunifuCustomLabel8.Visible = true; bunifuCustomLabel6.Visible = true; bunifuCustomLabel7.Visible = true; bunifuCircleProgressbar1.Visible = false; timer1.Start(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button_Click(object sender, RoutedEventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\muhammad\Documents\data.mdf;Integrated Security=True;Connect Timeout=30"); SqlDataAdapter sda = new SqlDataAdapter("select count(*) from logic where username= "******"and password" + textBox1.Text + "'", con); this.Hide(); dashboard ss = new dashboard(); ss.Show(); }
public App() { InitializeComponent(); if (App.Current.Properties.ContainsKey("username") && App.Current.Properties.ContainsKey("password")) { MainPage = new dashboard(); //dashboard } else { MainPage = new login(); //login } }
private void button2_Click(object sender, EventArgs e) { DBConnect db = new DBConnect(); db.insertBatch(eventname.Text); MessageBox.Show("EVENT HAS BEEN ADDED SUCCESSFULLY"); this.Hide(); barscanner b = new barscanner(); b.BringToFront(); dashboard d = new dashboard(); d.Reset(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { if (ConfigurationManager.AppSettings["token"] != null) // Si tenemos guardado un token de inicio de sesion { ConfigurationHandler Config = new ConfigurationHandler(); String host = Config.getSetting("host", "Connection"); String port = Config.getSetting("port", "Connection"); String database = Config.getSetting("database", "Connection"); String user = Config.getSetting("username", "Connection"); String pass = Config.getSetting("password", "Connection"); String ruta = "Data Source=" + host + ";port=" + port + ";Database=" + database + ";Uid=" + user + ";Password="******"SELECT token from users where username= ?username;"; MySqlCommand cmd; MySqlConnection con = null; try { con = new MySqlConnection(ruta); con.Open(); cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?username", ConfigurationManager.AppSettings["username"]); System.Data.IDataReader dr; dr = cmd.ExecuteReader(); if (dr.Read()) { String token = dr.GetString(0); if (token == ConfigurationManager.AppSettings["token"]) { dashboard form = new dashboard(); this.Hide(); form.ShowDialog(); } else { var configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); var settings = configFile.AppSettings.Settings; settings.Remove("token"); configFile.Save(ConfigurationSaveMode.Modified); ConfigurationManager.RefreshSection(configFile.AppSettings.SectionInformation.Name); } } } catch (Exception exc) { MessageBox.Show("Ups! Ha habido un error de conexión con la base de datos:\n" + exc.Message.ToString(), "Error de conexión", MessageBoxButton.OK, MessageBoxImage.Exclamation); } finally { if (con != null) { con.Close(); } } } }
private void button1_Click(object sender, EventArgs e) { DBConnect db = new DBConnect(); db.insertColor(color.Text); MessageBox.Show("COLOUR HAS BEEN ADDED SUCCESSFULLY"); this.Hide(); barscanner b = new barscanner(); b.BringToFront(); dashboard d = new dashboard(); d.Reset(); }
public IActionResult success() { if (UserSession == null) { return(RedirectToAction("Index")); } User user = dbContext.Users.FirstOrDefault(q => q.UserId == UserSession); List <Wedding> allW = dbContext.Weddings.Include(w => w.CreatedRsvp).Include(q => q.Creator).ToList(); dashboard model = new dashboard(); model.userLogged = user; model.weddingList = allW; return(View(model)); }
public void refreshCB() { dashboard db = new dashboard(); db.access_prisoner.IsChecked = false; db.access_visitor.IsChecked = false; db.access_cell.IsChecked = false; db.access_case.IsChecked = false; db.access_escort.IsChecked = false; db.access_prisonerreport.IsChecked = false; db.access_visitorreport.IsChecked = false; db.access_cellreport.IsChecked = false; db.access_casereport.IsChecked = false; db.access_jailofficerreport.IsChecked = false; }
public ActionResult CleaningServices(dashboard data, FormCollection form) { ViewBag.Rooms = Rooms(); ViewBag.ServiceType = ServiceType(); dashboard dbdata = new dashboard(); dbdata.EmpID = ID; dbdata.RoomName = form["RoomName"].ToString(); dbdata.BookingType = form["BookingType"].ToString(); dbdata.BookingStatus = "Pending"; dbdata.DateTo = data.DateFrom; dbdata.DateFrom = data.DateFrom; context.dashboards.Add(dbdata); context.SaveChanges(); return(RedirectToAction("EmployeeDashboard")); }
public void DashboardClassWiseDuesChart() { dashboard db = new dashboard(); dashboardMain dmain = new dashboardMain(); Task t1, t2, t3; // Dashboard dues chart live update t1 = Task.Factory.StartNew(() => db.name = dmain.school_class()); t2 = Task.Factory.StartNew(() => db.dues = dmain.dues()); t3 = Task.Factory.StartNew(() => db.recovered = dmain.recovered()); var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>(); Task.Factory.StartNew(() => context.Clients.All.DashboardClassWiseDuesChart(db.name, db.dues, db.recovered)); }
public void DashboardSchoolStrength() { dashboard db = new dashboard(); dashboardMain dmain = new dashboardMain(); Task t1, t2, t3, t4, t5, t6, t7, t8; t1 = Task.Factory.StartNew(() => db.school_strength = dmain.school_strength()); t2 = Task.Factory.StartNew(() => db.male_std = dmain.school_Male_std()); t3 = Task.Factory.StartNew(() => db.female_std = dmain.school_Female_std()); t4 = Task.Factory.StartNew(() => db.newAdmission = dmain.new_admission()); t5 = Task.Factory.StartNew(() => db.newAdmission_male = dmain.new_admission_male_std()); t6 = Task.Factory.StartNew(() => db.newAdmission_female = dmain.new_admission_female_std()); t7 = Task.Factory.StartNew(() => db.transport_male_std = dmain.transport_Male_std()); t8 = Task.Factory.StartNew(() => db.transport_female_std = dmain.transport_Female_std()); var tasklist = new List <Task> { t1, t2, t3, t4, t5, t6, t7, t8 }; Task.WaitAll(tasklist.ToArray()); db.transport_std = db.transport_male_std + db.transport_female_std; var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>(); int[] strength = { db.school_strength, db.male_std, db.female_std, db.newAdmission, db.newAdmission_male, db.newAdmission_female, db.transport_std, db.transport_male_std, db.transport_female_std }; Task.Factory.StartNew(() => context.Clients.All.DashboardSchoolStrength(strength)); }
private void button1_Click(object sender, EventArgs e) { DBConnect db = new DBConnect(); string eventname = this.eventid.Text.ToString(); string colorname = this.colorid.Text.ToString(); string no = this.nooftickets.Text; int n = db.CountTickets(); for (int i = 0; i < Convert.ToInt32(no); i++) { db.InsertTickets(eventname, "101" + n + i, colorname); } MessageBox.Show("TICKETS HAVE BEEN SAVED SUCCESSFULLY"); this.Hide(); barscanner b = new barscanner(); b.BringToFront(); dashboard d = new dashboard(); d.Reset(); d.Notifier("TICKETS HAVE BEEN SAVED SUCCESSFULLY"); }
public void SMSCreditLeft() { dashboard db = new dashboard(); dashboardMain dmain = new dashboardMain(); Task t1, t2; t1 = Task.Factory.StartNew(() => db.sms_credit_left = dmain.SMSCredit()); t2 = Task.Factory.StartNew(() => db.today_consumption = dmain.today_consumption().ToString()); var tasklist = new List <Task> { t1, t2 }; Task.WaitAll(tasklist.ToArray()); var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>(); string[] sms = { db.sms_credit_left, db.today_consumption }; Task.Factory.StartNew(() => context.Clients.All.DashBoadSMSCreditLeft(sms)); }
// GET: Home //[Authorize(Roles = "superadmin,admin,principal,faculty")] public ActionResult Dashboard() { string wedget = Request.Cookies["wedget"].Value.ToString(); var list = wedget.Split(','); dashboard db = new dashboard(); dashboardMain dmain = new dashboardMain(); //Task t1, t2 ,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21,t22,t23,t24; Task t1 = Task.FromResult <object>(null); Task t2 = Task.FromResult <object>(null); Task t3 = Task.FromResult <object>(null); Task t4 = Task.FromResult <object>(null); Task t5 = Task.FromResult <object>(null); Task t6 = Task.FromResult <object>(null); Task t7 = Task.FromResult <object>(null); Task t8 = Task.FromResult <object>(null); Task t9 = Task.FromResult <object>(null); Task t10 = Task.FromResult <object>(null); Task t11 = Task.FromResult <object>(null); Task t12 = Task.FromResult <object>(null); Task t13 = Task.FromResult <object>(null); Task t14 = Task.FromResult <object>(null); Task t15 = Task.FromResult <object>(null); Task t16 = Task.FromResult <object>(null); Task t17 = Task.FromResult <object>(null); Task t18 = Task.FromResult <object>(null); Task t19 = Task.FromResult <object>(null); Task t20 = Task.FromResult <object>(null); Task t21 = Task.FromResult <object>(null); Task t22 = Task.FromResult <object>(null); Task t23 = Task.FromResult <object>(null); Task t24 = Task.FromResult <object>(null); Task t25 = Task.FromResult <object>(null); Task t26 = Task.FromResult <object>(null); Task t27 = Task.FromResult <object>(null); Task t28 = Task.FromResult <object>(null); Task t29 = Task.FromResult <object>(null); if (list.Contains("fees_received") || User.IsInRole("superadmin")) { t1 = Task.Factory.StartNew(() => db.bank_received = dmain.bank_received()); t2 = Task.Factory.StartNew(() => db.cash_received = dmain.cash_received()); } if (list.Contains("school_strength") || User.IsInRole("superadmin")) { t3 = Task.Factory.StartNew(() => db.school_strength = dmain.school_strength()); t4 = Task.Factory.StartNew(() => db.male_std = dmain.school_Male_std()); t5 = Task.Factory.StartNew(() => db.female_std = dmain.school_Female_std()); } if (list.Contains("transport_std") || User.IsInRole("superadmin")) { t5 = Task.Factory.StartNew(() => db.transport_male_std = dmain.transport_Male_std()); t6 = Task.Factory.StartNew(() => db.transport_female_std = dmain.transport_Female_std()); } if (list.Contains("newAdmission") || User.IsInRole("superadmin")) { t7 = Task.Factory.StartNew(() => db.newAdmission = dmain.new_admission()); t8 = Task.Factory.StartNew(() => db.newAdmission_male = dmain.new_admission_male_std()); t9 = Task.Factory.StartNew(() => db.newAdmission_female = dmain.new_admission_female_std()); } if (list.Contains("class_wise_dues_chart") || User.IsInRole("superadmin")) { t10 = Task.Factory.StartNew(() => db.name = dmain.school_class()); } else { db.name = new string[] { "" }; } if (list.Contains("class_wise_dues_chart") || list.Contains("total_recovery") || User.IsInRole("superadmin")) { t11 = Task.Factory.StartNew(() => db.dues = dmain.dues()); t12 = Task.Factory.StartNew(() => db.recovered = dmain.recovered()); } else { db.dues = new decimal[] { 0 }; db.recovered = new decimal[] { 0 }; db.total_dues = db.dues.Sum(); db.total_recovered = db.recovered.Sum(); } if (list.Contains("sms_credit_left") || User.IsInRole("superadmin")) { t13 = Task.Factory.StartNew(() => db.sms_credit_left = dmain.SMSCredit()); t14 = Task.Factory.StartNew(() => db.today_consumption = dmain.today_consumption().ToString()); } if (list.Contains("class_wise_attendance_chart") || list.Contains("attendance_summary") || User.IsInRole("superadmin")) { if (User.IsInRole("superadmin") || User.IsInRole("principal")) { t15 = Task.Factory.StartNew(() => db.name_attendance = dmain.school_class_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); t16 = Task.Factory.StartNew(() => db.present = dmain.present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); t17 = Task.Factory.StartNew(() => db.absent = dmain.absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); } else { t15 = Task.Factory.StartNew(() => db.name_attendance = dmain.school_class_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); t16 = Task.Factory.StartNew(() => db.present = dmain.present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); t17 = Task.Factory.StartNew(() => db.absent = dmain.absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); } } else { db.name_attendance = new string[] { "" }; db.present = new int[] { 0 }; db.absent = new int[] { 0 }; } if (list.Contains("date_wise_attendance_chart") || User.IsInRole("superadmin")) { if (User.IsInRole("superadmin") || User.IsInRole("principal")) { t18 = Task.Factory.StartNew(() => db.date_list = dmain.date_list_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); t19 = Task.Factory.StartNew(() => db.thirty_day_present = dmain.thirty_day_present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); t20 = Task.Factory.StartNew(() => db.thirty_day_absent = dmain.thirty_day_absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); } else { t18 = Task.Factory.StartNew(() => db.date_list = dmain.date_list_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); t19 = Task.Factory.StartNew(() => db.thirty_day_present = dmain.thirty_day_present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); t20 = Task.Factory.StartNew(() => db.thirty_day_absent = dmain.thirty_day_absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); } } else { db.date_list = new string[] { "" }; db.thirty_day_present = new int[] { 0 }; db.thirty_day_absent = new int[] { 0 }; } if (list.Contains("finalize_list") || User.IsInRole("superadmin")) { if (User.IsInRole("superadmin") || User.IsInRole("principal")) { t21 = Task.Factory.StartNew(() => db.finalize_list = dmain.finalizer_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); } else { t21 = Task.Factory.StartNew(() => db.finalize_list = dmain.finalizer_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); } } if (list.Contains("list_att_left_class") || User.IsInRole("superadmin")) { if (User.IsInRole("superadmin") || User.IsInRole("principal")) { t22 = Task.Factory.StartNew(() => db.list_att_left_class = dmain.att_left_classess(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); } else { t22 = Task.Factory.StartNew(() => db.list_att_left_class = dmain.att_left_classess(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); } } if (list.Contains("total_cash_bank_received") || User.IsInRole("superadmin")) { t23 = Task.Factory.StartNew(() => db.total_bank_received = dmain.total_bank_received()); t24 = Task.Factory.StartNew(() => db.total_cash_received = dmain.total_cash_received()); } if (list.Contains("std_birthday_list") || User.IsInRole("superadmin")) { if (User.IsInRole("superadmin") || User.IsInRole("principal")) { t25 = Task.Factory.StartNew(() => db.std_birthday_list = dmain.std_birthday_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true)); } else { t26 = Task.Factory.StartNew(() => db.std_birthday_list = dmain.std_birthday_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false)); } } if (list.Contains("staff_birthday_list") || User.IsInRole("superadmin")) { t27 = Task.Factory.StartNew(() => db.staff_birthday_list = dmain.staff_birthday()); } if (list.Contains("session_wise_dues_chart") || User.IsInRole("superadmin")) { t28 = Task.Factory.StartNew(() => db.session = dmain.session()); t29 = Task.Factory.StartNew(() => db.session_dues = dmain.session_dues()); } else { db.session = new string[] { "" }; db.session_dues = new decimal[] { 0 }; } var tasklist = new List <Task> { t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23, t24, t25, t26, t27, t28, t29 }; Task.WaitAll(tasklist.ToArray()); if (list.Contains("fees_received") || User.IsInRole("superadmin")) { db.fees_received = db.bank_received + db.cash_received; } if (list.Contains("transport_std") || User.IsInRole("superadmin")) { db.transport_std = db.transport_male_std + db.transport_female_std; } if (list.Contains("class_wise_dues_chart") || list.Contains("total_recovery") || User.IsInRole("superadmin")) { db.total_dues = db.dues.Sum(); db.total_recovered = db.recovered.Sum(); } else { db.total_dues = db.dues.Sum(); db.total_recovered = db.recovered.Sum(); } if (list.Contains("class_wise_attendance_chart") || list.Contains("attendance_summary") || User.IsInRole("superadmin")) { db.daily_absent = db.absent.Sum(); db.daily_present = db.present.Sum(); } else { db.name_attendance = new string[] { "" }; db.present = new int[] { 0 }; db.absent = new int[] { 0 }; } if (list.Contains("finalize_list") || User.IsInRole("superadmin")) { foreach (var item in db.finalize_list) { item.absent = dmain.absent_finalizer(item.session, item.att_date.ToString("yyyy-MM-dd"), item.section_id); item.present = dmain.present_finalizer(item.session, item.att_date.ToString("yyyy-MM-dd"), item.section_id); } } if (list.Contains("list_att_left_class") || User.IsInRole("superadmin")) { foreach (var item in db.list_att_left_class) { item.class_teacher = dmain.class_teacher(item.class_id, item.section_id); item.finalizer = dmain.finalizer(item.class_id, item.section_id); } } if (list.Contains("total_cash_bank_received") || User.IsInRole("superadmin")) { db.total_cash_bank_received = db.total_bank_received + db.total_cash_received; } return(View("Dashboard", db)); }
private void editbutton_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(stringcon); MemoryStream ms = new MemoryStream(); pictureBox2.Image.Save(ms, pictureBox2.Image.RawFormat); byte[] a = ms.GetBuffer(); ms.Close(); MemoryStream ms1 = new MemoryStream(); pictureBox3.Image.Save(ms1, pictureBox3.Image.RawFormat); byte[] a2 = ms1.GetBuffer(); ms1.Close(); MemoryStream ms2 = new MemoryStream(); pictureBox4.Image.Save(ms2, pictureBox4.Image.RawFormat); byte[] a3 = ms2.GetBuffer(); ms2.Close(); cmd.Parameters.Clear(); cmd.Connection = con; cmd.CommandText = "Insert into proprietati(numeproiect,numeproprietate,pretlista,moneda,data_ora,suprafatatotala,clasaenergetica,tipproprietate,numarbai,suprafataconstruita,suprafatautila,suprafatabalcon ,numarapartament,etaj,finisaje,compartimente,parcare,utilitati,descriere,img1,img2,img3,numeagent,id_proiecte) values(@numeproiect,@numeproprietate,@pretlista,@moneda,@data_ora,@suprafatatotala,@clasaenergetica,@tipproprietate,@numarbai,@suprafataconstruita,@suprafatautila,@suprafatabalcon,@numarapartament,@etaj,@finisaje,@compartimente,@parcare,@utilitati,@descriere, @img1, @img2, @img3,(select CONCAT(nume,' ',prenume) from echipa where email=@EMAIL),(select proiecte.id_proiecte from proiecte inner join proprietati on proiecte.numeproiect = proprietati.numeproiect where proprietati.numeproiect = @b group by proiecte.id_proiecte))"; cmd.Parameters.AddWithValue("@numeproiect", bunifuDropdown2.selectedValue); cmd.Parameters.AddWithValue("@numeproprietate", nameofproject.Text); cmd.Parameters.AddWithValue("@pretlista", bunifuMaterialTextbox1.Text); cmd.Parameters.AddWithValue("@suprafatatotala", bunifuMaterialTextbox2.Text); cmd.Parameters.AddWithValue("@clasaenergetica", bunifuMaterialTextbox3.Text); cmd.Parameters.AddWithValue("@tipproprietate", bunifuDropdown1.selectedValue); cmd.Parameters.AddWithValue("@numarbai", bunifuDropdown3.selectedValue); cmd.Parameters.AddWithValue("@suprafataconstruita", bunifuMaterialTextbox6.Text); cmd.Parameters.AddWithValue("@suprafatautila", bunifuMaterialTextbox5.Text); cmd.Parameters.AddWithValue("@suprafatabalcon", bunifuMaterialTextbox4.Text); cmd.Parameters.AddWithValue("@etaj", bunifuDropdown5.selectedValue); cmd.Parameters.AddWithValue("@finisaje", bunifuDropdown4.selectedValue); cmd.Parameters.AddWithValue("@compartimente", bunifuDropdown6.selectedValue); cmd.Parameters.AddWithValue("@parcare", bunifuDropdown7.selectedValue); cmd.Parameters.AddWithValue("@utilitati", bunifuDropdown8.selectedValue); cmd.Parameters.AddWithValue("@descriere", richTextBox2.Text); cmd.Parameters.AddWithValue("@data_ora", DateTime.Now.ToString("yyyy-MM-dd HH: mm:ss")); cmd.Parameters.AddWithValue("@numarapartament", bunifuMaterialTextbox7.Text); cmd.Parameters.AddWithValue("@EMAIL", loginform.Email); cmd.Parameters.AddWithValue("@b", bunifuDropdown2.selectedValue); cmd.Parameters.AddWithValue("@moneda", bunifuDropdown9.selectedValue); cmd.Parameters.AddWithValue("@img1", a); cmd.Parameters.AddWithValue("@img2", a2); cmd.Parameters.AddWithValue("@img3", a3); con.Open(); cmd.ExecuteNonQuery(); con.Close(); //Application.Exit(); // this is not good for this dashboard dash = new dashboard(); //next to app form dash = new dashboard(); dash.Show(); //show app form this.Hide(); //login form hide dash.bunifuCustomLabel6.Visible = true; dash.popupsuccesdatainsert.Start(); }
public ActionResult TrainingRooms(dashboard data, FormCollection form) { ViewBag.Rooms = Rooms(); data.EmpID = ID; data.BookingStatus = "Pending"; data.BookingType = "Training Room"; int daysdifference = ((TimeSpan)(data.DateTo - data.DateFrom)).Days; if (data.DateTo >= data.DateFrom && daysdifference <= 93) { bool svalid = context.dashboards.Any(x => x.RoomName == data.RoomName); if (svalid) { if (data.DateFrom == data.DateTo) { bool evalid = context.dashboards.Any(x => x.DateFrom == data.DateFrom); if (!evalid) { context.dashboards.Add(data); context.SaveChanges(); return(RedirectToAction("EmployeeDashboard")); } } bool zcalid = context.dashboards.Any(x => x.DateFrom == data.DateFrom || x.DateFrom == data.DateTo || x.DateTo == data.DateFrom || x.DateTo == data.DateTo); if (zcalid) { ModelState.AddModelError("RoomName", " training room " + data.RoomName + " has already been booked on " + data.DateFrom + " or " + data.DateTo); } else { bool fvalid = context.dashboards.Any(x => x.DateFrom <data.DateFrom && x.DateTo> data.DateFrom || x.DateFrom <data.DateTo && x.DateTo> data.DateTo); bool dvalid = context.dashboards.Any(x => x.DateFrom > data.DateFrom && x.DateFrom <data.DateTo && x.DateTo> data.DateFrom && x.DateTo < data.DateTo); if (dvalid) { ModelState.AddModelError("RoomName", "Training Room " + data.RoomName + "already been booked in between the given dates"); return(View()); } else if (fvalid) { ModelState.AddModelError("RoomName", "Training Room " + data.RoomName + "already been booked in between the given dates"); } else { context.dashboards.Add(data); context.SaveChanges(); return(RedirectToAction("EmployeeDashboard")); } } } else { context.dashboards.Add(data); context.SaveChanges(); return(RedirectToAction("EmployeeDashboard")); } } else { ModelState.AddModelError("RoomName", "*Invalid Dates OR Booking Period Must Be Less Than 3 Months"); } return(View()); }
public ActionResult Index() { ViewBag.Message = "Welcome to Safety Patrol Management System!"; ViewBag.pagename = "Dashboard"; if (HttpContext.Session.Count > 0) { var islogin = HttpContext.Session["islogin"].ToString(); if (islogin == "1") { ViewBag.currentuser = HttpContext.Session["fname"]; ViewBag.Message = ""; if (HttpContext.Session["userlevel"].ToString() == "0") { return(RedirectToAction("Index", "Findings")); } else { int y; int month; string smonth; if (HttpContext.Request["year"] != null && HttpContext.Request["year"] != "") { y = int.Parse(HttpContext.Request["year"]); } else { y = 0; } if (HttpContext.Request["month"] != null && HttpContext.Request["month"] != "") { smonth = HttpContext.Request["month"].ToString(); if (CheckDate(smonth)) { month = Convert.ToDateTime(HttpContext.Request["month"].ToString() + "01, 1900").Month; } else { ViewBag.Message = "Invalid Month Selection!"; month = 0; smonth = ""; } } else { month = 0; smonth = ""; } if (y == 0 && month > 0) { ViewBag.Message = "Please Select Year!"; } List <string> lDept = db.dept.Select(s => s.department).Distinct().ToList(); List <BarChartValue> bc = new List <BarChartValue>(); List <catcount> c3 = new List <catcount>(); dashboard d = new dashboard(); if (y == 0) { ViewBag.syear = ""; //DateTime.Today.Year; ViewBag.smonth = ""; foreach (string l in lDept) { var temp = db.dataFindings.Where(s => s.department == l).Where(s => s.ignore == 0).ToList(); var c = db.dataFindings.Where(s => s.status == 3).Where(s => s.department == l).Where(s => s.ignore == 0).ToList(); var r = db.dataFindings.Where(s => s.status == 2).Where(s => s.department == l).Where(s => s.ignore == 0).ToList(); var p = db.dataFindings.Where(s => s.status == 1).Where(s => s.department == l).Where(s => s.ignore == 0).ToList(); BarChartValue x = new BarChartValue(); x.ChartValue = temp.Count; x.completed = c.Count; x.review = r.Count; x.pending = p.Count; x.DeptName = l; bc.Add(x); } } else { ViewBag.syear = y; ViewBag.smonth = smonth; if (month > 0) { foreach (string l in lDept) { var temp = db.dataFindings.Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList(); var c = db.dataFindings.Where(s => s.status == 3).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList(); var r = db.dataFindings.Where(s => s.status == 2).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList(); var p = db.dataFindings.Where(s => s.status == 1).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList(); BarChartValue x = new BarChartValue(); x.ChartValue = temp.Count; x.completed = c.Count; x.review = r.Count; x.pending = p.Count; x.DeptName = l; bc.Add(x); } } else { foreach (string l in lDept) { var temp = db.dataFindings.Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList(); var c = db.dataFindings.Where(s => s.status == 3).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList(); var r = db.dataFindings.Where(s => s.status == 2).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList(); var p = db.dataFindings.Where(s => s.status == 1).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList(); BarChartValue x = new BarChartValue(); x.ChartValue = temp.Count; x.completed = c.Count; x.review = r.Count; x.pending = p.Count; x.DeptName = l; bc.Add(x); } } } List <tbl_classification> categories = db.classification.ToList(); foreach (var cat in categories) { //d.cc.count.Add(db.dataFindings.Where(e => e.classification == cat.classification).Count()); int cnt = db.dataFindings.Where(e => e.classification == cat.classification).Count(); string c1 = cat.classification.ToString(); catcount cat1 = new catcount(); cat1.categories = c1; cat1.count1 = cnt; c3.Add(cat1); } d.bcv = bc; d.bcc = c3; ViewBag.noOfFindings = db.dataFindings.Where(m => m.ignore == 0).Count(); ViewBag.F_pending = db.dataFindings.Where(m => m.status == 1).Where(m => m.ignore == 0).Count(); ViewBag.F_review = db.dataFindings.Where(m => m.status == 2).Where(m => m.ignore == 0).Count(); ViewBag.F_completed = db.dataFindings.Where(m => m.status == 3).Where(m => m.ignore == 0).Count(); return(View(d)); } } } return(RedirectToAction("Index", "Login")); }
public dashboard Admin() { dashboard d = new dashboard(); //Purchase and Sale d.LastMonthSales = context.Order.OrderBy(x => x.Date).Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products != null? x.Products.Select(t => t.price).Sum(): 0); d.LastMonthPurchasing = context.Purchasings.OrderBy(x => x.Date).Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount); d.TotalSalesCount = context.Order.Count(); d.TotalPurchasingCount = context.Purchasings.Count(); d.TotalSales = context.Order.Sum(x => x.Products.Select(p => p.price).Sum()); d.TotalPurchasing = context.Purchasings.Sum(x => x.Amount); d.MonthlyProfit = d.LastMonthSales - d.LastMonthPurchasing; d.TotalProfit = d.TotalSales - d.TotalPurchasing; #region Recent Orders and Purchase //Recent Orders var result = (from v in context.Order join c in context.Customer on v.cus_id equals c.cus_id join s in context.Stores on v.store_id equals s.store_id select new OrderViewModel() { order_id = v.order_id, Date = v.Date, StoreName = s.StoreName + s.Ref_No, cus_id = v.cus_id, cus_name = c.cus_name, orderStatus = v.status, TakenBy = v.TakenBy, CustRef = c.CustRef, Products = (from p in context.Products where p.order_id == v.order_id select new Products() { id = p.id, modelId = p.modelId, model_name = p.BrandModel.model_name, Phoneid = p.BrandModel.PhoneId, com_Name = p.BrandModel.model.Com_name, price = p.price, Quantity = p.Quantity }).ToList() }).OrderBy(x => x.Date).Take(10).ToList(); d.Orders = result; //Recent Purchase var Purchase = (from p in context.Purchasings join b in context.BrandModel on p.modelId equals b.modelId join v in context.Vendor on p.vendor_id equals v.ven_id join c in context.CompanyModel on b.PhoneId equals c.Phoneid join s in context.Stores on p.store_id equals s.store_id select new PurchasingViewModel() { purchase_id = p.purchase_id, Date = p.Date, Quantity = p.Quantity, Amount = p.Amount, modelId = p.modelId, modelName = b.model_name, Com_name = c.Com_name, vendor_id = p.vendor_id, VendorName = v.ven_name, store_id = s.store_id, StoreName = s.StoreName + '#' + s.Ref_No, takenBy = p.user.FullName, }).OrderBy(x => x.Date).Take(10).ToList(); d.Purchasing = Purchase; #endregion //Graphs var DailyGraphSale = context.Order.Select(x => new { x.Date, x.Products }).Where(x => (x.Date - DateTime.Now).TotalDays <= 30).ToList() .GroupBy(x => x.Date.ToString("yyyy/MM/dd")) .Select(pr => new Graph() { Day = pr.Key.ToString(), Amount = pr.Select(x => x.Products.Select(t => t.price).Sum()).Sum() }); // var json = JsonConvert.SerializeObject(DailyGraphSale); //d.Sales = json; d.Sales = DailyGraphSale.ToList(); var DailyGraphPurchasing = context.Purchasings.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).ToList() .GroupBy(x => x.Date.ToString("yyyy/MM/dd")) .Select(pr => new Graph() { Day = pr.Key.ToString(), Amount = pr.Sum(x => x.Amount) }); //d.Purchasings= JsonConvert.SerializeObject(DailyGraphPurchasing); d.Purchasings = DailyGraphPurchasing.ToList(); //Brands d.CompaniesData = context.BrandModel .GroupBy(x => x.PhoneId) .Select(pr => new GroupByCompany() { PhoneID = pr.Key, ComapanyName = pr.Select(x => new { x.PhoneId, x.model.Com_name }).FirstOrDefault(r => r.PhoneId == pr.Key).Com_name, BrandsTotal = pr.Where(x => x.PhoneId == pr.Key).Count() }).ToList(); //Users d.User = userManager.Users.Take(5).ToList(); d.TotalUsers = userManager.Users.Count(); d.Employees = userManager.Users.Where(x => x.store_id != null && x.isactive == true).Select(x => new RegisterEmployeeViewModel() { id = x.Id, Email = x.Email, StoreName = x.Store.StoreName, }).Take(5).ToList(); d.TotalEmployees = userManager.Users.Where(x => x.store_id != null && x.isactive == true).Count(); //Store Statistics var stats = context.Stores.Select(s => new StoreStats() { StoreID = s.store_id, StoreName = s.StoreName + s.Ref_No, RefNo = s.Ref_No, MonthPurchasing = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount) : 0, MonthPurchasingCount = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Count() : 0, AverageMonthlyPurchasing = s.Purchasing != null ? Math.Round((double)s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount) / 30, 2) : 0, MonthSales = s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products.Select(t => t.price).Sum()) : 0, MonthSalesCount = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Count() : 0, AverageMonthlySale = s.Order != null ? Math.Round(s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products.Select(t => t.price).Sum()) / 30, 2): 0, MonthlyProfit = (s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount) : 0) - (s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products.Select(t => t.price).Sum()) : 0), AnnualPurchasing = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Amount) : 0, AnnualSales = s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Products.Select(t => t.price).Sum()) : 0, AnnualProfit = (s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Amount) : 0) - (s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Products.Select(t => t.price).Sum()) : 0), CompletedOrders = s.Order != null ? s.Order.Where(x => x.status == Model.Order.Status.Completed).Count() : 0, ProcessOrders = s.Order != null ? s.Order.Where(x => x.status == Model.Order.Status.Processing).Count() : 0, PendingOrders = s.Order != null ? s.Order.Where(x => x.status == Model.Order.Status.Pending).Count() : 0, TotalEmployees = s.Employees != null ? userManager.Users.Where(x => x.store_id != null && x.store_id == s.store_id).Count() : 0, TotalBrands = s.Stock != null ? s.Stock.Where(x => x.store_id == s.store_id).Count() : 0, }).ToList(); d.Stores = stats; d.Stores = stats; return(d); }
private void editbutton_Click(object sender, EventArgs e) { dashboard dh = new dashboard(); SqlConnection con = new SqlConnection(stringcon); if (pictureBox1.Image != null) { MemoryStream ms = new MemoryStream(); pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat); byte[] a = ms.GetBuffer(); ms.Close(); MemoryStream ms1 = new MemoryStream(); pictureBox2.Image.Save(ms1, pictureBox2.Image.RawFormat); byte[] a2 = ms1.GetBuffer(); ms1.Close(); MemoryStream ms2 = new MemoryStream(); pictureBox3.Image.Save(ms2, pictureBox3.Image.RawFormat); byte[] a3 = ms2.GetBuffer(); ms2.Close(); MemoryStream ms3 = new MemoryStream(); pictureBox4.Image.Save(ms3, pictureBox4.Image.RawFormat); byte[] a4 = ms3.GetBuffer(); ms3.Close(); cmd.Parameters.Clear(); cmd.Connection = con; cmd.CommandText = "Insert into proiecte(numeproiect,judet,oras,strada,data_ora,numaretajeimobil,clasaenergetica,parcare,mezanin,demisol,mansarda ,descriereproiect ,img1,img2,img3,img4,id_echipa,numeagent) values(@numeproiect , @judet , @oras , @strada , @data_ora , @numaretajeimobil, @clasaenergetica, @parcare , @mezanin , @demisol , @mansarda , @descriereproiect , @img1 , @img2 , @img3 , @img4,(select id_echipa from echipa where email=@email),(select CONCAT(nume,' ',prenume) from echipa where email=@email))"; cmd.Parameters.AddWithValue("@numeproiect", nameofproject.Text); cmd.Parameters.AddWithValue("@judet", district_text.Text); cmd.Parameters.AddWithValue("@oras", city_text.Text); cmd.Parameters.AddWithValue("@strada", street_text.Text); cmd.Parameters.AddWithValue("@data_ora", DateTime.Now.ToString("yyyy-MM-dd HH: mm:ss")); cmd.Parameters.AddWithValue("@numaretajeimobil", bunifuDropdown2.selectedValue); cmd.Parameters.AddWithValue("@clasaenergetica", bunifuMaterialTextbox1.Text); cmd.Parameters.AddWithValue("@parcare", bunifuMaterialTextbox1.Text); cmd.Parameters.AddWithValue("@mezanin", mezanine); cmd.Parameters.AddWithValue("@demisol", semibasement); cmd.Parameters.AddWithValue("@mansarda", mansard); cmd.Parameters.AddWithValue("@descriereproiect", richTextBox1.Text); cmd.Parameters.AddWithValue("@img1", a); cmd.Parameters.AddWithValue("@img2", a2); cmd.Parameters.AddWithValue("@img3", a3); cmd.Parameters.AddWithValue("@img4", a4); cmd.Parameters.AddWithValue("@EMAIL", loginform.Email); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } //Application.Exit(); // this is not good for this dashboard dash = new dashboard(); //next to app form dash = new dashboard(); dash.Show(); //show app form this.Hide(); //login form hide dash.bunifuCustomLabel6.Visible = true; dash.popupsuccesdatainsert.Start(); }