public ActionResult employeeLogout(User u) { if (set.id == u.Id && set.pass == u.Password) { List <Details> data = new List <Details>(); // Session["id"] = u.Id; Daily_times d = new Daily_times(); List <Daily_times> dd = e.Daily_times.ToList(); for (int i = dd.Count - 1; i >= 0; i--) { if (dd[i].Id == u.Id) { d = dd[i]; break; } } set.check = true; string o = System.DateTime.Now.DayOfWeek.ToString(); //DateTime myDate = DateTime.Parse(DateTime.Now.TimeOfDay.ToString("hh\\:mm")); //d.start_time = DateTime.Parse(myDate.TimeOfDay.ToString()); d.end_time = DateTime.Now; d.Id = u.Id; //d.Day = o; //Session["LoginAttempt"] = 00; set.breakchecker = 1; d.Status = "Logged-OUT"; Session["LoginAttempt"] = null; d.Day = o; SqlCommand sql = new SqlCommand("LOGOUTENDTIME", connection.getcon()); sql.CommandType = System.Data.CommandType.StoredProcedure; sql.Parameters.AddWithValue("@id", d.DailyTime_id); sql.Parameters.AddWithValue("@endtime", d.end_time); sql.Parameters.AddWithValue("@status", d.Status); sql.ExecuteNonQuery(); set.id = 0; set.pass = null; return(RedirectToAction("details", "Home", new { u.Id })); } else { ViewBag.msg = "its not your id or password"; return(View()); } }
public ActionResult breakStop(User u) { User t = e.Users.Find(u.Id); List <Daily_times> d = e.Daily_times.ToList(); Daily_times dd = d.FindLast(x => x.User == t); e.Entry(dd).State = System.Data.Entity.EntityState.Modified; dd.check = 1; e.SaveChanges(); if (u.Id == t.Id && t.Password == u.Password) { List <Break_Times> g = e.Break_Times.ToList(); Break_Times b = new Break_Times(); for (int i = g.Count - 1; i >= 0; i--) { if (g[i].Id == u.Id) { b = g[i]; break; } } // string a = System.DateTime.Now.DayOfWeek.ToString(); b.endTime = DateTime.Now; //set.breaktimestart = "00"; b.Id = u.Id; SqlCommand sql = new SqlCommand("BREAKSTOP", connection.getcon()); sql.CommandType = System.Data.CommandType.StoredProcedure; sql.Parameters.AddWithValue("@id", b.BreakTimeID); sql.Parameters.AddWithValue("@endtime", b.endTime); sql.ExecuteNonQuery(); b.breakcheck = 00; return(RedirectToAction("details", "Home", new { u.Id })); } else { ViewBag.msg = "wrong id or pass"; } return(View()); }
public ActionResult reports(User u) { Weekly_Reports y = new Weekly_Reports(); List <Weekly_Reports> q = e.Weekly_Reports.ToList(); bool yes = false; foreach (var i in q) { if (i.Day_no == DateTime.Now.Day.ToString()) { yes = true; break; } } if (yes) { } else { List <Daily_times> list = e.Daily_times.ToList(); Daily_times l = list.Find(m => m.Id == u.Id); Weekly_Reports p = new Weekly_Reports(); p.Day_no = (s.IndexOf(l.Day.Trim()) + 1).ToString(); p.Start = DateTime.Parse(l.start_time.ToString()); p.End = DateTime.Parse(l.end_time.ToString()); DateTime date1 = Convert.ToDateTime(l.start_time); DateTime date2 = Convert.ToDateTime(l.end_time); string minutes = (date2.Subtract(date1).TotalMinutes).ToString(); p.Total_Hours = minutes; e.Weekly_Reports.Add(p); e.SaveChanges(); } return(RedirectToAction("showReports", "Home")); }
public ActionResult employeeLogin(User u) { set.breaktimestart = "0"; //SqlCommand sql = new SqlCommand("INSERTTIME", connection.getcon()); //sql.CommandType = System.Data.CommandType.StoredProcedure; //sql.Parameters.AddWithValue("@fk_id", u.Id); //sql.Parameters.AddWithValue("@status", "Logged_IN"); //sql.Parameters.AddWithValue("@startTime", d.start_time ); //sql.Parameters.AddWithValue("@day",o ); //sql.ExecuteNonQuery(); List <User> list = e.Users.ToList(); User r = list.Find(p => p.Id == u.Id); User x = e.Users.Find(r.Id); //DateTime start = new DateTime(2018, 12, 9, 10, 0, 0); //10 o'clock //DateTime end = new DateTime(2009, 12, 10, 12, 0, 0); //12 o'clock //DateTime now = DateTime.Now; List <Daily_times> list1 = e.Daily_times.ToList(); Daily_times l = list1.Find(m => m.Id == u.Id); if (l == null) { l = new Daily_times(); l.Day = DateTime.Now.Day.ToString(); } //Daily_time q = e.Daily_times.Find(l.Id); string o = System.DateTime.Now.DayOfWeek.ToString(); if (l.Day.Trim() == o) { e.Entry(l).State = System.Data.Entity.EntityState.Modified; l.start_time = DateTime.Now; //e.Daily_times. //e.Daily_times.Add(l); e.SaveChanges(); } if (x.Password == u.Password) { set.id = u.Id; //Session["id"] = x.Id; if (l.Status == "Logged-IN") { ViewBag.msg = "User is Already Logged in"; // Session["id"] = x.Id; x.check = x.Id; set.id = x.Id; set.pass = x.Password; Session["LoginAttempt"] = null; RedirectToAction("employeeLogin", "Home"); } //if (z == "Logged-IN") //{ // ViewBag.msg = "User is Already Logged in"; // RedirectToAction("employeeLogin", "Home"); //} else { if (l.User == null) { Session["id"] = x.Id; set.id = x.Id; set.pass = x.Password; Daily_times d = new Daily_times(); string a = System.DateTime.Now.DayOfWeek.ToString(); DateTime myDate = DateTime.Parse(DateTime.Now.TimeOfDay.ToString("hh\\:mm")); d.start_time = DateTime.Parse(myDate.TimeOfDay.ToString()); d.Month = DateTime.Now.ToString("MMM"); //d.end_time = DateTime.Now; d.Day = a; d.Id = u.Id; d.Status = "Logged-IN"; Session["LoginAttempt"] = null; Break_Times b = new Break_Times(); b.breakcheck = 0; e.Daily_times.Add(d); e.SaveChanges(); } } return(RedirectToAction("details", "Home", new { x.Id })); } else { ViewBag.msg = "Wrong password"; } return(View()); }