public ActionResult Login(LoginModel model) { string err = ""; if (!ModelState.IsValid) { return(View(model)); } using (CommunityOneEntities n = new CommunityOneEntities()) { var io = (from i in n.tblUsrInfoes join d in n.tblUsrDetails on i.UsrInfoID equals d.UsrInfoID where i.UsrName == model.UsrName && i.UsrPass == model.UsrPass select new { i.UsrName, i.UsrIsLog, i.UsrStatus, d.UsrFName, d.UsrLName, d.UsrEmpCode }); var usrDetails = io.FirstOrDefault(); if (io != null && io.Count() > 0) { if (usrDetails.UsrStatus == false) { err = "User is locked"; } else { LoginModel m = new LoginModel() { UsrName = usrDetails.UsrName, UsrFname = usrDetails.UsrFName, UsrLName = usrDetails.UsrLName, UsrIsLog = usrDetails.UsrIsLog, UsrStatus = usrDetails.UsrStatus }; SignInUser(m, false); return(RedirectToAction("Index", "Home")); } } else { err = "Incorrect username or password."; } } ModelState.AddModelError("", err); return(View(model)); }
public JsonResult loadPoHeader() { CommunityOneEntities db = new CommunityOneEntities(); List <POHDRshrt_ViewModel> polist = db.vw_POHeaderShort.Where(x => x.PO_Buyer_Init == "CLA").Select(x => new POHDRshrt_ViewModel { ponumb = (int)x.PO_No, postat = x.PO_Stat + " - " + x.PO_Status_Des, vendor = x.PO_Vendor_No.ToString() + " - " + x.PO_Vendor_Name, poedat = x.PO_Entry_Date, pocost = x.PO_Cost, pomalw = x.PO_SKU_Level_Allowance, povalw = x.PO_Vendor_Level_Allowance, buyer = x.PO_Buyer_Init + " - " + x.PO_Buyer_Name }).ToList(); return(Json(polist, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { CommunityOneEntities db = new CommunityOneEntities(); IEnumerable <POHDRshrt_ViewModel> polist = db.vw_POHeaderShort.Where(x => x.PO_Buyer_Init == "CLA").Select(x => new POHDRshrt_ViewModel { ponumb = (int)x.PO_No, postat = x.PO_Stat + " - " + x.PO_Status_Des, vendor = x.PO_Vendor_No.ToString() + " - " + x.PO_Vendor_Name, poedat = x.PO_Entry_Date, pocost = x.PO_Cost, pomalw = x.PO_SKU_Level_Allowance, povalw = x.PO_Vendor_Level_Allowance, buyer = x.PO_Buyer_Init + " - " + x.PO_Buyer_Name }).OrderByDescending(x => x.ponumb).Take(10).ToList(); return(View(polist)); }