public async Task <SaveResult> DeleteAsync(CongViecVanBanResult entity)
{
return(await ExecuteDbWithHandleAsync(_logService, async() =>
{
using (var context = new TechOfficeEntities())
{
var cv = context.CongViec_VanBan.Single(x => x.Id == entity.Id && x.IsDeleted == false);
cv.IsDeleted = true;
cv.LastUpdatedBy = entity.LastUpdatedBy;
cv.LastUpdated = DateTime.Now;
context.Entry(cv).State = EntityState.Modified;
return await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}));
}
public async Task <SaveResult> AddAsync(CongViecVanBanResult entity)
{
return(await ExecuteDbWithHandleAsync(_logService, async() =>
{
using (var context = new TechOfficeEntities())
{
var add = context.CongViec_VanBan.Create();
add.HoSoCongViecId = entity.HoSoCongViecId;
add.NgayBanHanh = entity.NgayBanHanh;
add.NoiDung = entity.NoiDung;
add.SoVanBan = entity.SoVanBan;
add.CoQuanId = entity.CoQuanId;
add.IsDeleted = entity.IsDeleted;
add.CreatedBy = entity.CreatedBy;
add.CreateDate = DateTime.Now;
context.Entry(add).State = EntityState.Added;
return await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}));
}
public async Task <SaveResult> UpdateAsync(CongViecVanBanResult entity)
{
return(await ExecuteDbWithHandle(_logService, async() =>
{
using (var context = new TechOfficeEntities())
{
var update = context.CongViec_VanBan
.Single(x => x.Id == entity.Id && x.IsDeleted == false);
update.SoVanBan = entity.SoVanBan;
update.CoQuanId = entity.CoQuanId;
update.NoiDung = entity.NoiDung;
update.NgayBanHanh = entity.NgayBanHanh;
update.HoSoCongViecId = entity.HoSoCongViecId;
update.IsDeleted = entity.IsDeleted;
update.LastUpdatedBy = entity.LastUpdatedBy;
update.LastUpdated = DateTime.Now;
context.Entry(update).State = EntityState.Modified;
return await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}));
}
