public void SaveGuideChanges(NewGuideModel model)
{
var guide = _db.guide.FirstOrDefault(e => e.Id == model.Id);
if (guide == null)
{
throw new MyException(Errors.UserNotFound);
}
model.CopyTo(ref guide);
//editor.user.Password = StringTransformationProvider.Md5(model.Password);
guide.user.Email = StringTransformationProvider.TransformEmail(model.Email);
guide.user.Deleted = model.Deleted;
//сохранение новых прав
_db.country_permission.RemoveRange(guide.user.country_permission);
_db.city_permission.RemoveRange(guide.user.city_permission);
//_db.region_permission.RemoveRange(guide.user.region_permission);
_db.country_permission.AddRange(
model.PermittedCountries.Select(c => new country_permission {
CountryId = c, UserId = guide.UserId
}));
_db.city_permission.AddRange(
model.PermittedCities.Select(c => new city_permission {
CityId = c, UserId = guide.UserId
}));
// _db.region_permission.AddRange(
// model.PermittedRegions.Select(c => new region_permission { RegionId = c, UserId = guide.UserId }));
_db.SaveChanges();
}
public void AddNewAdmin(NewAdminModel model)
{
model.Email = StringTransformationProvider.TransformEmail(model.Email);
if (_db.user.Any(u => u.Email == model.Email))
{
throw new MyException(Errors.UserExists);
}
var trans = _db.Database.BeginTransaction();
try
{
var newUser = new user
{
Guid = Guid.NewGuid().ToString(),
Password = StringTransformationProvider.Md5(model.Password),
Email = model.Email,
UserTypeId = GetUserTypeByTag(UserTypes.Admin),
Deleted = false
};
_db.user.Add(newUser);
_db.SaveChanges();
var admin = new admin();
model.CopyTo(ref admin);
admin.UserId = newUser.Id;
_db.admin.Add(admin);
_db.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
public user GetUserByLoginAndPassword(string email, string password)
{
var md5Pass = StringTransformationProvider.Md5(password);
email = StringTransformationProvider.TransformEmail(email);
var user = _db.user.FirstOrDefault(u => u.Email == email && md5Pass == u.Password);
if (user == null)
{
throw new MyException(Errors.UserNotFound);
}
return(user);
}
public void SaveTenantChanges(NewTenantModel model)
{
var tenant = _db.tenant.FirstOrDefault(e => e.Id == model.Id);
if (tenant == null)
{
throw new MyException(Errors.UserNotFound);
}
model.CopyTo(ref tenant);
//editor.user.Password = StringTransformationProvider.Md5(model.Password);
tenant.user.Email = StringTransformationProvider.TransformEmail(model.Email);
tenant.user.Deleted = model.Deleted;
_db.SaveChanges();
}
public void AddNewEditor(NewEditorModel model)
{
model.Email = StringTransformationProvider.TransformEmail(model.Email);
if (_db.user.Any(u => u.Email == model.Email))
{
throw new MyException(Errors.UserExists);
}
var trans = _db.Database.BeginTransaction();
try
{
var newUser = new user
{
Guid = Guid.NewGuid().ToString(),
Password = StringTransformationProvider.Md5(model.Password),
Email = model.Email,
UserTypeId = GetUserTypeByTag(UserTypes.Editor),
Deleted = model.Deleted
};
_db.user.Add(newUser);
_db.SaveChanges();
var newEditor = new editor();
model.CopyTo(ref newEditor);
newEditor.UserId = newUser.Id;
_db.editor.Add(newEditor);
_db.country_permission.AddRange(
model.PermittedCountries.Select(c => new country_permission {
CountryId = c, UserId = newUser.Id
}));
_db.city_permission.AddRange(
model.PermittedCities.Select(c => new city_permission {
CityId = c, UserId = newUser.Id
}));
/* _db.region_permission.AddRange(
* model.PermittedRegions.Select(c => new region_permission {RegionId = c, UserId = newUser.Id}));*/
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
