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