public async Task <SaveResult> AddAsync(TacNghiepResult entity)
{
return(await ExecuteDbWithHandleAsync(_logService, async() =>
{
using (var context = new TechOfficeEntities())
{
entity.AddToDb(context);
return await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}));
}
public SaveResult Add(TacNghiepResult entity)
{
return(ExecuteDbWithHandle(_logService, () =>
{
using (var context = new TechOfficeEntities())
{
entity.AddToDb(context);
return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}));
}
public static TacNghiepInfo ToDataInfo(this TacNghiepResult entity)
{
return(new TacNghiepInfo
{
Id = entity.Id,
NoiDung = entity.NoiDung,
NgayTao = entity.NgayTao,
NgayHoanThanh = entity.NgayHoanThanh,
NgayHetHan = entity.NgayHetHan,
LinhVucTacNghiepInfo = entity.LinhVucTacNghiepInfo
});
}
public SaveResult Delete(TacNghiepResult entity)
{
return(ExecuteDbWithHandle(_logService, () =>
{
using (var context = new TechOfficeEntities())
{
var cv = context.TacNghieps.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 context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}));
}
public static void AddToDb(this TacNghiepResult entity, TechOfficeEntities context)
{
var add = context.TacNghieps.Create();
add.LinhVucTacNghiepId = entity.LinhVucTacNghiepId;
add.NgayHetHan = entity.NgayHetHan;
add.NgayHoanThanh = entity.NgayHoanThanh;
add.NoiDung = entity.NoiDung;
add.NoiDungTraoDoi = entity.NoiDungTraoDoi;
add.MucDoHoanThanhId = entity.MucDoHoanThanhId;
add.NgayTao = entity.NgayTao;
add.IsDeleted = entity.IsDeleted;
add.CreatedBy = entity.CreatedBy;
add.CreateDate = DateTime.Now;
context.Entry(add).State = EntityState.Added;
}
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 async Task <SaveResult> UpdateAsync(TacNghiepResult entity)
{
return(await ExecuteDbWithHandleAsync(_logService, async() =>
{
using (var context = new TechOfficeEntities())
{
var update = context.TacNghieps.Single(x => x.Id == entity.Id && x.IsDeleted == false);
update.NgayHetHan = entity.NgayHetHan;
update.NgayHoanThanh = entity.NgayHoanThanh;
update.NoiDung = entity.NoiDung;
update.NoiDungTraoDoi = entity.NoiDungTraoDoi;
update.MucDoHoanThanhId = entity.MucDoHoanThanhId;
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;
}
}));
}
public static TacNghiepInfo ToIfNotNullDataInfo(this TacNghiepResult entity)
{
return(entity?.ToDataInfo());
}
