public SaveResult EditUserWtithRoles(UserResult entity)
{
return(ExecuteDbWithHandle(_logService, () =>
{
var result = SaveResult.FAILURE;
using (var context = new TechOfficeEntities())
{
using (var transaction = context.BeginTransaction())
{
var update = context.Users.Where(x => x.Id == entity.Id).Single();
update.UserName = entity.UserName;
update.IsLocked = entity.IsLocked;
update.HoVaTen = entity.HoVaTen;
update.ChucVuId = entity.ChucVuId;
update.CoQuanId = entity.CoQuanId;
update.IsDeleted = entity.IsDeleted;
update.LastUpdatedBy = entity.LastUpdatedBy;
update.LastUpdated = DateTime.Now;
context.Entry(update).State = EntityState.Modified;
//Remove all roles of user
RemoveAllRolesOfUser(context, entity.Id);
UserRole role;
foreach (var item in entity.UserRoles)
{
role = context.UserRoles.Create();
role.RoleId = item.RoleInfo.Id;
role.UserId = update.Id;
role.IsDeleted = entity.IsDeleted;
role.CreatedBy = update.CreatedBy;
role.CreateDate = update.CreateDate;
context.Entry(role).State = EntityState.Added;
}
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
transaction.Commit();
}
}
return result;
}));
}
public SaveResult AddUserWithRoles(UserResult entity)
{
return(ExecuteDbWithHandle(_logService, () =>
{
var result = SaveResult.FAILURE;
using (var context = new TechOfficeEntities())
{
using (var transaction = context.BeginTransaction())
{
var add = context.Users.Create();
add.UserName = entity.UserName;
add.Password = AppCipher.EncryptCipher(entity.Password);
add.IsLocked = entity.IsLocked;
add.HoVaTen = entity.HoVaTen;
add.ChucVuId = entity.ChucVuId;
add.CoQuanId = entity.CoQuanId;
add.IsDeleted = entity.IsDeleted;
add.CreatedBy = entity.CreatedBy;
add.CreateDate = DateTime.Now;
context.Entry(add).State = EntityState.Added;
UserRole role;
foreach (var item in entity.UserRoles)
{
role = context.UserRoles.Create();
role.RoleId = item.RoleInfo.Id;
role.UserId = add.Id;
role.IsDeleted = entity.IsDeleted;
role.CreatedBy = add.CreatedBy;
role.CreateDate = add.CreateDate;
context.Entry(role).State = EntityState.Added;
}
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
transaction.Commit();
}
}
return result;
}));
}
public async Task <SaveResult> AddAsync(ThuTucResult entity)
{
return(await ExecuteDbWithHandleAsync(_logService, async() =>
{
using (var context = new TechOfficeEntities())
{
using (var transaction = context.BeginTransaction())
{
entity.AddToDb(context);
var result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
transaction.Commit();
return result;
}
}
}));
}
public SaveResult Add(ThuTucResult entity)
{
return(ExecuteDbWithHandle(_logService, () =>
{
using (var context = new TechOfficeEntities())
{
using (var transaction = context.BeginTransaction())
{
var add = entity.AddToDb(context);
var result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
transaction.Commit();
entity.Id = add.Id;
return result;
}
}
}));
}
public SaveResult AddTacNghiepWithTinhHinhThucHien(TacNghiepResult entity)
{
return(ExecuteDbWithHandle(_logService, () =>
{
var result = SaveResult.FAILURE;
using (var context = new TechOfficeEntities())
{
using (var transaction = context.BeginTransaction())
{
entity.AddToDb(context);
var tt = context.TacNghieps.Local.FirstOrDefault();
if (tt != null)
{
foreach (var item in entity.CoQuanInfos)
{
var co = context.TacNghiep_TinhHinhThucHien.Create();
co.CoQuanId = item.Id;
co.TacNghiepId = tt.Id;
co.MucDoHoanThanhId = (int)EnumMucDoHoanThanh.CHUATHUHIEN;
co.IsDeleted = tt.IsDeleted;
co.CreatedBy = tt.CreatedBy;
co.CreateDate = tt.CreateDate;
context.Entry(co).State = EntityState.Added;
}
}
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
transaction.Commit();
entity.Id = tt.Id;
}
}
return result;
}));
}
public SaveResult AddRange(IEnumerable <ThuTucResult> entities)
{
return(ExecuteDbWithHandle(_logService, () =>
{
using (var context = new TechOfficeEntities())
{
using (var transaction = context.BeginTransaction())
{
foreach (var entity in entities)
{
entity.AddToDb(context);
}
var result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
transaction.Commit();
return result;
}
}
}));
}
public SaveResult AddCongViecWithChildren(HoSoCongViecResult entity)
{
return(ExecuteDbWithHandle(_logService, () =>
{
var saveResult = SaveResult.FAILURE;
using (var context = new TechOfficeEntities())
{
using (var transaction = context.BeginTransaction())
{
entity.AddWithChildrenToDb(context);
var cv = context.HoSoCongViecs.Local.FirstOrDefault();
saveResult = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
transaction.Commit();
entity.Id = cv != null ? cv.Id : 0;
return saveResult;
}
}
}));
}