public ActionResult Login(UserinfoVm userinfoVm) { ODMSEntities Db = new ODMSEntities(); Session["IpAddress"] = userinfoVm.IpAddress; if (ModelState.IsValid) { var z = Db.DB_User_check(userinfoVm.UserName, userinfoVm.UserPassword).Where(a => a.User_role_id == 8).ToList();//from Procudure for db User if (z.Count() == 1) { foreach (var i in z) { if (i.active == 1) { var dbName = Db.tbld_distribution_house.Where(a => a.DB_Id == i.DistributionId).Select(p => p.DBName).ToList(); Session["User_Name"] = i.login_user_id; Session["user_role_code"] = i.user_role_code; Session["first_name"] = i.Name; Session["User_biz_role_id"] = i.biz_zone_category_id; Session["biz_zone_id"] = i.Zone_id; Session["User_role_id"] = i.User_role_id; Session["DBId"] = i.DistributionId; Session["psrid"] = i.id; Session["dbName"] = dbName[0]; } else { ViewBag.Title = "Login"; ViewBag.alertbox = "error"; ViewBag.alertboxMsg = "Your User is InActive"; return(PartialView()); } } return(RedirectToAction("Index", "AppsActivity")); } } ViewBag.Title = "Login"; ViewBag.alertbox = "error"; ViewBag.alertboxMsg = "Please Enter valid User and Password"; return(PartialView()); }
// GET: Admin public ActionResult Index() { using (InsuranceQuoteEntities db = new InsuranceQuoteEntities()) { var userinfos = db.UserInfoes.ToList(); var userinfoVms = new List <UserinfoVm>(); foreach (var userinfo in userinfos) { var userinfoVm = new UserinfoVm(); userinfoVm.FirstName = userinfo.FirstName; userinfoVm.LastName = userinfo.LastName; userinfoVm.EmailAddress = userinfo.EmailAddress; userinfoVm.Total = Convert.ToInt32(userinfo.Total); userinfoVms.Add(userinfoVm); } return(View(userinfoVms)); } }
public ActionResult Index(UserinfoVm userinfoVm) { Session["IpAddress"] = userinfoVm.IpAddress; if (ModelState.IsValid) { var x = Db.User_check(userinfoVm.UserName, userinfoVm.UserPassword).ToList(); //from Procudure for Zone var z = Db.DB_User_check(userinfoVm.UserName, userinfoVm.UserPassword).Where(a => a.User_role_id == 7).ToList(); //from Procudure for db User if (x.Count() == 1) { foreach (var y in x) { if (y.User_status == 1) { //var a = db.tbl_Manu_Role_mapping.Where(data => data.Roleid == y.User_role_id).ToList(); Session["User_Id"] = y.User_Id; Session["User_Name"] = y.User_Name; Session["user_role_code"] = y.user_role_code; Session["first_name"] = y.first_name; Session["User_biz_role_id"] = y.User_biz_role_id; Session["biz_zone_id"] = y.biz_zone_id; Session["User_role_id"] = y.User_role_id; } else { ViewBag.Title = "Login"; ViewBag.alertbox = "error"; ViewBag.alertboxMsg = "Your User is InActive"; return(PartialView()); } } var userRole = Convert.ToInt32(Session["User_role_id"]); var mainManuid = Db.tbl_Manu_Role_mapping.Where(s => s.Roleid == userRole).Select(s => s.MainMenuid).ToList(); var submenuListid = Db.tbl_Manu_Role_mapping.Where(s => s.Roleid == userRole).Select(s => s.SubMenuid).ToList(); var submenuSecondListid = Db.tbl_Manu_Role_mapping.Where(s => s.Roleid == userRole).Select(s => s.SubMenuSecondid).ToList(); Session["MainMenus"] = Db.tbl_MainMenu.Where(s => mainManuid.Contains(s.Id)).OrderBy(s => s.sl) .ToList(); Session["SubMenu"] = Db.tbl_SubMenu.Where(s => submenuListid.Contains(s.Id)).OrderBy(s => s.sl) .ToList(); Session["SubMenuSecond"] = Db.tbl_SubMenuSecond.Where(s => submenuSecondListid.Contains(s.Id)) .OrderBy(s => s.sl).ToList(); return(RedirectToAction("Index", "Home")); } if (z.Count() == 1) { foreach (var i in z) { if (i.active == 1) { var dbName = Db.tbld_distribution_house.Where(a => a.DB_Id == i.DistributionId).Select(p => p.DBName).ToList(); var systemDate = Db.tblt_System.Where(v => v.DBid == i.DistributionId).Select(s => s.CurrentDate).ToList(); Session["SystemDate"] = systemDate[0]; Session["User_Id"] = i.id; Session["User_Name"] = i.login_user_id; Session["user_role_code"] = i.user_role_code; Session["first_name"] = i.Name; Session["User_biz_role_id"] = i.biz_zone_category_id; Session["biz_zone_id"] = i.Zone_id; Session["User_role_id"] = i.User_role_id; Session["DBId"] = i.DistributionId; Session["DBName"] = dbName[0]; } else { ViewBag.Title = "Login"; ViewBag.alertbox = "error"; ViewBag.alertboxMsg = "Your User is InActive"; return(PartialView()); } } var userRole = Convert.ToInt32(Session["User_role_id"]); var mainManuid = Db.tbl_Manu_Role_mapping.Where(s => s.Roleid == userRole).Select(s => s.MainMenuid).ToList(); var submenuListid = Db.tbl_Manu_Role_mapping.Where(s => s.Roleid == userRole).Select(s => s.SubMenuid).ToList(); var submenuSecondListid = Db.tbl_Manu_Role_mapping.Where(s => s.Roleid == userRole).Select(s => s.SubMenuSecondid).ToList(); Session["MainMenus"] = Db.tbl_MainMenu.Where(s => mainManuid.Contains(s.Id)).OrderBy(s => s.sl) .ToList(); Session["SubMenu"] = Db.tbl_SubMenu.Where(s => submenuListid.Contains(s.Id)).OrderBy(s => s.sl) .ToList(); Session["SubMenuSecond"] = Db.tbl_SubMenuSecond.Where(s => submenuSecondListid.Contains(s.Id)) .OrderBy(s => s.sl).ToList(); return(RedirectToAction("Index", "Home")); } } ViewBag.Title = "Login"; ViewBag.alertbox = "error"; ViewBag.alertboxMsg = "Please Enter valid User and Password"; return(PartialView()); }