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