public void DeleteUser(User user)
{
if (user.Id == 0)
return;
user.FirstName = "DeletedUser" + user.Id.ToString();
user.LastName = null;
user.Institute = null;
user.Password = Encryption.EncryptPassword(DateTime.Now.ToString());
var perm = new Permission {Id = 1};
user.Permission = perm;
user.PermissionPermissionId = perm.Id;
user.Picture = null;
user.PhoneNumber = null;
user.Email = null;
using (var db = new TSPDSContext())
{
db.Entry(user).State = EntityState.Modified;
db.User.AddOrUpdate(user);
db.SaveChanges();
}
}
private void ValidatePermission(Permission perm)
{
using (var db = new TSPDSContext())
{
var query = from b in db.Permission where b.Id == perm.Id select b;
if (!query.Any())
throw new DALOutOfRangeException("Permission id is out of range");
}
}
public void UpdateUserPermission(User user, Permission perm)
{
ValidateUser(user);
ValidatePermission(perm);
if (perm == null)
throw new DALInfoNotSpecifiedException("User permission was not specified");
if (perm.Id == 0)
throw new DALInfoNotSpecifiedException("Permission id was not speciified");
if (user.Id == 0)
throw new DALInfoNotSpecifiedException("User id was not speciified");
var param = new ParametersForUsers();
param.Email = user.Email;
var temp = GetUsers(param)[0];
if (temp.Email != user.Email)
{
throw new DALInfoNotSpecifiedException("The user was not found in the databse");
}
using (var db = new TSPDSContext())
{
user.Permission = perm;
user.PermissionPermissionId = perm.Id;
db.User.AddOrUpdate(user);
db.SaveChanges();
}
}
public void InsertUser(User user, Permission perm)
{
ValidateUser(user);
ValidatePermission(perm);
using (var db = new TSPDSContext())
{
var query = from s in db.User where s.Email.ToLower() == user.Email.ToLower() select s;
if (query.Any())
throw new DALAlreadyExistsException("User already exists");
user.Permission = perm;
user.PermissionPermissionId = perm.Id;
db.Entry(user).State = EntityState.Modified;
db.User.Add(user);
db.SaveChanges();
}
}