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()); }