public ActionResult Edit([Bind(Include = "CouId,CouName,TeaId")] Course course) { if (ModelState.IsValid) { db.Entry(course).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TeaId = new SelectList(db.Teachers, "TeaId", "TeaUsername", course.TeaId); return(View(course)); }
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()); }