public ActionResult breakStart(User u) { User t = e.Users.Find(u.Id); if (u.Id == t.Id && t.Password == u.Password) { Break_Times b = new Break_Times(); b.User = t; string a = System.DateTime.Now.DayOfWeek.ToString(); b.breakcheck = 1; b.startTime = DateTime.Now; b.Day = a; b.Id = u.Id; e.Break_Times.Add(b); e.SaveChanges(); return(RedirectToAction("details", "Home", new { u.Id })); } else { ViewBag.msg = "wrong id or pass"; } 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 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()); }