public void insertUsers(User user) { using (var context = new ManageUsersEntities()) { context.Users.Add(user); context.SaveChanges(); } }
public void updateUserLock(Int32 Iduser) { using (var context = new ManageUsersEntities()) { User user = (from s in context.Users where s.Id == Iduser select s).Single(); user.LockoutEnabled = !user.LockoutEnabled; context.SaveChanges(); } }
public void updateUserPassword(String idLogIn, String password) { using (var context = new ManageUsersEntities()) { User user = (from s in context.Users where s.Id_Login == idLogIn select s).Single(); user.Password = password; context.SaveChanges(); } }
public void deleteUsers(Int64 Iduser) { using (var context = new ManageUsersEntities()) { User user = (from s in context.Users where s.Id == Iduser select s).Single(); context.Users.Remove(user); context.SaveChanges(); } }
public void deleteRoles(Int32 IDrole) { using (var context = new ManageUsersEntities()) { Role roleItem = (from s in context.Roles where s.Id == IDrole select s).Single(); context.Roles.Remove(roleItem); context.SaveChanges(); } }
public void updateRoles(Int32 IDrole, String Name, String moTa) { using (var context = new ManageUsersEntities()) { Role roleItem = (from s in context.Roles where s.Id == IDrole select s).Single(); roleItem.Name = Name; roleItem.Description = moTa; context.SaveChanges(); } }
public void insertRoles(String Name, String moTa) { using (var context = new ManageUsersEntities()) { Role itemRole = new Role(); itemRole.Name = Name; itemRole.Description = moTa; itemRole.DateCreate = DateTime.Now; context.Roles.Add(itemRole); context.SaveChanges(); } }
public void updateUsers(Int64 Iduser, User user) { using (var context = new ManageUsersEntities()) { User userDb = (from s in context.Users where s.Id == Iduser select s).Single(); userDb.Id_Login = user.Id_Login; userDb.Email = user.Email; userDb.PhoneNumber = user.PhoneNumber; userDb.UserName = user.UserName; userDb.Department = user.Department; userDb.Position = user.Position; if (!String.IsNullOrEmpty(user.Password)) { userDb.Password = Utils.Encrypt(user.Password); } context.SaveChanges(); } }