public ActionResult Login(MstOfficerViewModel dataLogin)
{
var modelUser = serviceOfficer.GetListOfficerForLogin(dataLogin);
if (modelUser.Count == 0)
{
ViewBag.error = "Username atau Password salah";
return(View("Index"));
}
else
{
if (modelUser[0].Actived.ToString() == "True")
{
Session["Username"] = modelUser[0].Username;
Session["Role"] = modelUser[0].Desc;
Session["OfficerCode"] = modelUser[0].OfficerCode;
Session["EmployeeName"] = modelUser[0].Name;
return(Json(new { pesan = "sukses" }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { pesan = "gagal" }, JsonRequestBehavior.AllowGet));
}
public List <MstOfficerViewModel> GetListOfficerForLogin(MstOfficerViewModel datalogin)
{
List <MstOfficerViewModel> result = new List <MstOfficerViewModel>();
result = (from officer in dataContext.mstOfficer
join role in dataContext.mstRole
on officer.RoleId equals role.RoleId
join login in dataContext.trsLogin
on officer.OfficerCode equals login.OfficerCode
where login.Username == datalogin.Username &&
login.Password == datalogin.Password
select new MstOfficerViewModel {
OfficerCode = officer.OfficerCode,
Username = login.Username,
Password = login.Password,
Actived = officer.Actived,
Name = officer.Name,
RoleId = officer.RoleId,
Desc = role.Desc
}).ToList();
return(result);
}
