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