public NHANVIEN Login(string email, string password) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { //kiểm tra tồn tại string sqlString = "SELECT * FROM NHANVIEN WHERE Email='" + email + "' AND Password='******'"; List <NHANVIEN> result = context.NHANVIENs.SqlQuery(sqlString).ToList <NHANVIEN>(); if (result.Count > 0) { //tạo session C_SESSION session = new C_SESSION(); session.C_Status = 1; session.LoginTime = DateTime.Now; session.MaNV = result[0].MaNV; try { C_SESSION resultSession = context.C_SESSION.Add(session); context.SaveChanges(); HttpContext.Current.Session[GlobalConstant.SESSION_ID] = resultSession; } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } HttpContext.Current.Session[GlobalConstant.USER] = result[0]; return(result[0]); } else { return(null); } } }
//public IList<NHANVIEN> Search(string input) //{ // using (QLXeKhachEntities context = new QLXeKhachEntities()) // { // return context.NHANVIENs.Where(x => x.isDeleted!=1 &&(x.TenNV.Contains(input) || input == "")).ToList(); // } //} public void LogOut() { var session = HttpContext.Current.Session[GlobalConstant.SESSION_ID]; if (session != null) { C_SESSION mySession = (C_SESSION)session; mySession.LogoutTime = DateTime.Now; using (QLXeKhachEntities context = new QLXeKhachEntities()) { try { var entity = context.C_SESSION.Find(mySession.MaSession); if (entity == null) { return; } context.Entry(entity).CurrentValues.SetValues(session); context.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } } HttpContext.Current.Session.Clear(); } else { return; } }
public ActionResult DeleteConfirmed(int id) { C_SESSION c_SESSION = db.C_SESSION.Find(id); db.C_SESSION.Remove(c_SESSION); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MaNV,LoginTime,LogoutTime,C_Status")] C_SESSION c_SESSION) { if (ModelState.IsValid) { db.Entry(c_SESSION).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(c_SESSION)); }
public ActionResult Create([Bind(Include = "MaNV,LoginTime,LogoutTime,C_Status")] C_SESSION c_SESSION) { if (ModelState.IsValid) { db.C_SESSION.Add(c_SESSION); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(c_SESSION)); }
// GET: C_SESSION/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } C_SESSION c_SESSION = db.C_SESSION.Find(id); if (c_SESSION == null) { return(HttpNotFound()); } return(View(c_SESSION)); }