public bool UpdateUser(UserDetails userDetails) { bool result = true; using (var context = new AdminAppEntities()) { UserDetail details = context.UserDetails.Where(x => x.UserID == userDetails.UserId).FirstOrDefault(); UserDetail updatedetails = new UserDetail { CompanyID = userDetails.CompanyID, RoleId = userDetails.RoleId, FirstName = userDetails.FirstName, LastName = userDetails.LastName, PrimaryEmailID = userDetails.PrimaryEmailID, PhoneNumber = userDetails.PhoneNumber, EmployeeCode = userDetails.EmployeeCode, Address = userDetails.Address, Address1 = userDetails.Address1, City = userDetails.City, State = userDetails.State, Country = userDetails.Country, Pincode = userDetails.Pincode, Active = true, UserID = userDetails.UserId }; context.Entry(details).CurrentValues.SetValues(updatedetails); context.SaveChanges(); UserAuthentication userAuth = context.UserAuthentications.Where(x => x.UserID == userDetails.UserId).FirstOrDefault(); context.UserAuthentications.Remove(userAuth); context.SaveChanges(); UserAuthentication userAuthNew = new UserAuthentication { UserID = userDetails.UserId, UserName = userDetails.UserName, Password = userDetails.Password }; context.UserAuthentications.Add(userAuthNew); context.SaveChanges(); return(result); } }
public int SaveUser(UserDetails userDetails) { using (var context = new AdminAppEntities()) { UserDetail details = new UserDetail { CompanyID = userDetails.CompanyID, RoleId = userDetails.RoleId, FirstName = userDetails.FirstName, LastName = userDetails.LastName, PrimaryEmailID = userDetails.PrimaryEmailID, PhoneNumber = userDetails.PhoneNumber, EmployeeCode = userDetails.EmployeeCode, Address = userDetails.Address, Address1 = userDetails.Address1, City = userDetails.City, State = userDetails.State, Country = userDetails.Country, Pincode = userDetails.Pincode, Active = true }; context.UserDetails.Add(details); context.SaveChanges(); if (details.UserID > 0) { UserAuthentication userAuth = new UserAuthentication { UserID = details.UserID, UserName = userDetails.UserName, Password = userDetails.Password }; context.UserAuthentications.Add(userAuth); context.SaveChanges(); } return(details.UserID); } }
public bool SavePrivilege(MenuPermission priv) { bool result = false; using (var context = new AdminAppEntities()) { var privilege = context.MenuPrivileges.ToList(); MenuPrivilege menuPriv = new MenuPrivilege(); menuPriv = privilege.Where(x => x.RoleID == priv.RoleID && x.MenuID == priv.MenuID).FirstOrDefault(); if (menuPriv != null) { context.MenuPrivileges.Remove(menuPriv); context.SaveChanges(); } MenuPrivilege menu = new MenuPrivilege { MenuID = priv.MenuID, RoleID = priv.RoleID, CanCreate = priv.CanCreate, CanEdit = priv.CanEdit, CanView = priv.CanView, CanDelete = priv.CanDelete }; context.MenuPrivileges.Add(menu); context.SaveChanges(); if (menu.PrivilegeID > 0) { result = true; } else { result = false; } } return(result); }
public bool UpdateRole(RoleDetails roleDetails) { bool res = false; using (var context = new AdminAppEntities()) { Role roleDet = new Role { Name = roleDetails.Name, Active = true, RoleId = roleDetails.RoleId }; Role updateRole = context.Roles.Where(x => x.RoleId == roleDetails.RoleId).FirstOrDefault(); context.Entry(updateRole).CurrentValues.SetValues(roleDet); context.SaveChanges(); res = true; } return(res); }
public bool SaveRole(RoleDetails roleDetails) { bool res = false; using (var context = new AdminAppEntities()) { Role roleDet = new Role { Name = roleDetails.Name, Active = true, RoleId = roleDetails.RoleId }; context.Roles.Add(roleDet); context.SaveChanges(); res = true; } return(res); }