public ActionResult UserProfileSave(AT_Users usr) { string msg = ""; Session_CRM sess = (Session_CRM)Session["CRM_Session"]; try { var modal = db.AT_Users.AsNoTracking().Where(x => x.UserID == usr.UserID).FirstOrDefault(); // usr.TypeID = modal.TypeID; usr.RoleID = modal.RoleID; usr.UserID = sess.User.UserID; usr.Password = usr.Password != modal.Password ? CRM_Common.Encrypt(usr.Password) : usr.Password; if (usr.upload != null && usr.upload.ContentLength > 0) { usr.PicName = usr.upload.FileName; Guid g; g = Guid.NewGuid(); string targetFolder = Server.MapPath("~/App_Data/Images"); string targetPath = Path.Combine(targetFolder, g.ToString() + Path.GetExtension(usr.upload.FileName)); usr.upload.SaveAs(targetPath); usr.PicName = "/App_Data/Images/" + g.ToString() + Path.GetExtension(usr.upload.FileName); usr.PicGuid = g.ToString(); db.AT_Users.Attach(usr); db.UpdateOnly <AT_Users>(usr, x => x.FirstName, x => x.LastName, x => x.PicName, x => x.PicGuid, x => x.Email, x => x.Phone, x => x.Password); if (sess != null) { sess.User.PicGuid = usr.PicGuid; sess.User.PicName = usr.PicName; } } else { db.AT_Users.Attach(usr); db.UpdateOnly <AT_Users>(usr, x => x.FirstName, x => x.LastName, x => x.Email, x => x.Phone, x => x.Password); } db.SaveChanges(); msg = "Update successfully!"; } catch (Exception ex) { msg = ex.Message; } ViewBag.msg = msg; return(PartialView("UserProfileIndex", db.AT_Users.Where(x => x.UserID == sess.User.UserID).FirstOrDefault())); }
public ActionResult _AgentSave(AT_Users usr) { string msg = ""; Session_CRM sess = (Session_CRM)Session["CRM_Session"]; try { // var UserType = db.AT_UserType.Where(x => x.UserType == "Agent").Select(x => x.TypeID).FirstOrDefault(); //usr.TypeID = UserType; // usr.ClientID = sess.User.ClientID; // AT_Agent det = usr.Agent; usr.Password = CRM_Common.Encrypt(usr.Password); if (usr.UserID > 0) { usr.UpdateBy = sess.User.UserID; usr.UpdateDate = DateTime.Now; db.AT_Users.Attach(usr); db.UpdateExcept <AT_Users>(usr, x => x.CreateBy, x => x.CreateDate); db.SaveChanges(); } else { usr.CreateBy = sess.User.UserID; usr.CreateDate = DateTime.Now; db.Entry(usr).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); } msg = "User saved successfully!"; } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException.ToString().Contains("UNIQUE")) { msg = "Conflict"; } else { msg = ex.Message; } } ViewBag.msg = msg; db = new HRMSEntities(); ViewBag.msg = msg; return(PartialView("_AgentIndex", db.AT_Users.Where(a => a.IsDeleted != true).ToList())); }
public async Task <ActionResult> Index(string email, string password) { bool isTrailExist = false; int dayEnd = 0; int TotalDaysTrail = 0; string encpass = CRM_Common.Encrypt(password); AT_Users userlist = db.AT_Users.Where(x => x.Email == email && x.Password == encpass).FirstOrDefault <AT_Users>(); if (userlist != null) { if (userlist.IsActive) { if (db.AT_Role.Where(x => x.RoleID == userlist.RoleID).Select(x => x.IsActive).FirstOrDefault()) { Session_CRM sess = new Session_CRM(); List <Permissions> pplst = (from P in db.AT_Pages join PP in db.AT_Permission.Include("AT_PermissionActionJunc") on P.PageID equals PP.PageID join M in db.AT_Modules on P.ModuleID equals M.ModuleID join Per in db.AT_RolePermissionJunc on new { PermissionID = PP.PermissionID, IsGroup = false } equals new { PermissionID = Per.PermissionID, IsGroup = Per.IsGroup } where Per.RoleID == userlist.RoleID && P.IsActive == true && PP.IsActive == true select(new Permissions { AT_Pages = P, AT_Permission = PP, AT_Modules = M, AT_RolePermissionJunc = Per, AT_PermissionActionJunc = PP.AT_PermissionActionJunc.ToList() })).OrderBy(x => x.AT_Pages.PageOrder).ToList(); List <Permissions> pplst2 = (from P in db.AT_Pages join PP in db.AT_Permission.Include("AT_PermissionActionJunc") on P.PageID equals PP.PageID join M in db.AT_Modules on P.ModuleID equals M.ModuleID join Pj in db.AT_PermissionGroupJunc on PP.PermissionID equals Pj.PermissionID join Per in db.AT_RolePermissionJunc on new { PermissionID = Pj.PermissionGroupID, IsGroup = true } equals new { PermissionID = Per.PermissionID, IsGroup = Per.IsGroup } where Per.RoleID == userlist.RoleID && P.IsActive == true && PP.IsActive == true select(new Permissions { AT_Pages = P, AT_Permission = PP, AT_Modules = M, AT_RolePermissionJunc = Per, AT_PermissionActionJunc = PP.AT_PermissionActionJunc.ToList() })).OrderBy(x => x.AT_Pages.PageOrder).ToList(); List <Permissions> pplst3 = (from P in db.AT_Pages join PP in db.AT_Permission.Include("AT_PermissionActionJunc") on P.PageID equals PP.PageID join M in db.AT_Modules on P.ModuleID equals M.ModuleID join Pj in db.AT_PermissionGroupJunc on PP.PermissionID equals Pj.PermissionID join Per in db.AT_UserExtraPermissionjunc on new { PermissionGroupID = Pj.PermissionGroupID, IsExtrapermission = true } equals new { PermissionGroupID = Per.PermissionGroupID, IsExtrapermission = Per.AT_PermissionGroup.IsExtrapermission } where Per.UserID == userlist.UserID && P.IsActive == true && PP.IsActive == true select(new Permissions { AT_Pages = P, AT_Permission = PP, AT_Modules = M, AT_UserExtraPermissionjunc = Per, AT_PermissionActionJunc = PP.AT_PermissionActionJunc.ToList() })).OrderBy(x => x.AT_Pages.PageOrder).ToList(); List <Permissions> finallst = pplst.Union(pplst2).Union(pplst3).ToList <Permissions>(); if (finallst.Count() > 0) { sess.AllPermissions = finallst; var result = finallst.Select(z => z.AT_Modules).GroupBy(x => new { x.ModuleID }).Select(z => new AT_Modules { IsActive = z.FirstOrDefault().IsActive, ModuleIcon = z.FirstOrDefault().ModuleIcon, ModuleID = z.Key.ModuleID, ModuleName = z.FirstOrDefault().ModuleName, ModuleOrder = z.FirstOrDefault().ModuleOrder, ParentID = z.FirstOrDefault().ParentID, AT_Pages = z.FirstOrDefault().AT_Pages.ToList() }).ToList(); sess.AT_Modules = result; sess.User = userlist; sess.User.CRM_URL = Request.Url.AbsoluteUri; Session.Add("CRM_Session", sess); return(RedirectToAction("Index", "Home")); } else { ViewBag.msg = "You have not rights for login!"; return(View()); } } else { ViewBag.msg = "User role inactive!"; return(View()); } } else { ViewBag.msg = "User inactive!"; return(View()); } } else { ViewBag.msg = "Login Failed!"; return(View()); } }