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