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));
}
