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 SaveResult Delete(VanBanResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var cv = context.VanBans.Single(x => x.Id == entity.Id && x.IsDeleted == false); cv.DeleteToDb(context, entity.LastUpdatedBy); return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult DeleteBy(int id) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var tt = context.LinhVucThuTucs.Single(x => x.Id == id && x.IsDeleted == false); tt.DeleteToDb(context); return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Update(LinhVucThuTucResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.LinhVucThuTucs.Single(x => x.Id == entity.Id && x.IsDeleted == false); update.UpdateToDb(entity, context); return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
/// <summary> /// Deletes the by. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public SaveResult DeleteBy(int id) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var assembly = context.Users.Single(x => x.Id == id && x.IsDeleted == false); assembly.IsDeleted = true; context.Entry(assembly).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
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 DeleteBy(int id) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var cv = context.CongViec_PhoiHop.Single(x => x.Id == id && x.IsDeleted == false); cv.IsDeleted = true; cv.LastUpdated = DateTime.Now; context.Entry(cv).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
/// <summary> /// Resets the password. /// </summary> /// <param name="id">The identifier.</param> /// <param name="newPassword">The new password.</param> /// <returns></returns> public SaveResult ResetPassword(int id, string newPassword) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.Users.Single(x => x.Id == id && x.IsDeleted == false && x.IsLocked == false); update.Password = AppCipher.EncryptCipher(newPassword); context.Entry(update).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult AddRange(IEnumerable <LinhVucThuTucResult> entities) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { foreach (var entity in entities) { entity.AddToDb(context); } return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
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 SaveResult ReplyYKien(NoiDungTraLoiInfo reply) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.TacNghiep_YKienCoQuan.Single(x => x.Id == reply.Id && x.IsDeleted == false); update.NoiDungTraLoi = reply.NoiDung; update.UserIdTraLoi = reply.UserId; context.Entry(update).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Delete(MucDoHoanThanhResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var ht = context.MucDoHoanThanhs.Single(x => x.Id == entity.Id && x.IsDeleted == false); ht.IsDeleted = true; ht.LastUpdatedBy = entity.LastUpdatedBy; ht.LastUpdated = DateTime.Now; context.Entry(ht).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Delete(TapTinThuTucResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var cv = context.TapTinThuTucs.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 SaveResult Delete(LoaiVanBanResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var vb = context.LoaiVanBans.Single(x => x.Id == entity.Id && x.IsDeleted == false); vb.IsDeleted = true; vb.LastUpdatedBy = entity.LastUpdatedBy; vb.LastUpdated = DateTime.Now; context.Entry(vb).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Add(VanBanResult entity) { return(ExecuteDbWithHandle(_logService, () => { var result = SaveResult.FAILURE; using (var context = new TechOfficeEntities()) { var data = entity.AddToDb(context); result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; entity.Id = data.Id; return result; } })); }
/// <summary> /// Updates the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Update(RoleResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var role = context.Roles.Single(x => x.Id == entity.Id && x.IsDeleted == false); role.Name = entity.Ten; role.IsDeleted = entity.IsDeleted; role.Display = entity.MoTa; role.LastUpdatedBy = entity.LastUpdatedBy; role.LastUpdated = DateTime.Now; context.Entry(role).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Add(ChucVuResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var add = context.ChucVus.Create(); add.Ten = entity.Ten; add.MoTa = entity.MoTa; add.IsDeleted = entity.IsDeleted; add.CreatedBy = entity.CreatedBy; add.CreateDate = DateTime.Now; context.Entry(add).State = EntityState.Added; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult UpdateIncrementMucDoHoanThanh(int tacNghiepId, int coQuanId, string userName, EnumMucDoHoanThanh status) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.TacNghiep_TinhHinhThucHien.Where(x => x.TacNghiepId == tacNghiepId && x.CoQuanId == coQuanId && x.IsDeleted == false).FirstOrDefault(); if (update == null)//case not yet record data then insert { update = new TacNghiep_TinhHinhThucHien { CoQuanId = coQuanId, TacNghiepId = tacNghiepId, CreatedBy = userName, CreateDate = DateTime.Now, IsDeleted = false, MucDoHoanThanhId = (int)status, }; context.Entry(update).State = EntityState.Added; } else { if (update.MucDoHoanThanhId <= (int)status) { return SaveResult.SUCCESS; } update.MucDoHoanThanhId = (int)status; update.LastUpdatedBy = userName; update.LastUpdated = DateTime.Now; context.Entry(update).State = EntityState.Modified; } return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
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 Update(NhomCoQuanResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.NhomCoQuans.Single(x => x.Id == entity.Id && x.IsDeleted == false); update.Ten = entity.Ten; update.MoTa = entity.MoTa; update.IsDeleted = entity.IsDeleted; update.LastUpdatedBy = entity.LastUpdatedBy; update.LastUpdated = DateTime.Now; context.Entry(update).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Add(CongViecPhoiHopResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var add = context.CongViec_PhoiHop.Create(); add.HoSoCongViecId = entity.HoSoCongViecId; add.UserId = entity.UserId; add.IsDeleted = entity.IsDeleted; add.CreatedBy = entity.CreatedBy; add.CreateDate = DateTime.Now; context.Entry(add).State = EntityState.Added; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Add(TapTinThuTucResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var add = context.TapTinThuTucs.Create(); add.Url = entity.Url; add.UserUploadId = entity.UserUploadId; add.ThuTucId = entity.ThuTucId; add.IsDeleted = entity.IsDeleted; add.CreatedBy = entity.CreatedBy; add.CreateDate = DateTime.Now; context.Entry(add).State = EntityState.Added; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Update(TapTinYKienCoQuanResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.TapTinYKienCoQuans.Single(x => x.Id == entity.Id && x.IsDeleted == false); update.Url = entity.Url; update.UserUploadId = entity.UserUploadId; update.YKiencoQuanTacNghiepId = entity.YKienCoQuanId; update.IsDeleted = entity.IsDeleted; update.LastUpdatedBy = entity.LastUpdatedBy; update.LastUpdated = DateTime.Now; context.Entry(update).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Update(CongViecPhoiHopResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.CongViec_PhoiHop .Single(x => x.Id == entity.Id && x.IsDeleted == false); update.UserId = entity.UserId; update.HoSoCongViecId = entity.HoSoCongViecId; update.IsDeleted = entity.IsDeleted; update.LastUpdatedBy = entity.LastUpdatedBy; update.LastUpdated = DateTime.Now; context.Entry(update).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
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 Add(TacNghiepTinhHinhThucHienResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var add = context.TacNghiep_TinhHinhThucHien.Create(); add.ThoiGian = entity.ThoiGian; add.MucDoHoanThanhId = entity.MucDoHoanThanhId; add.TacNghiepId = entity.TacNghiepId; add.CoQuanId = entity.CoQuanId; add.IsDeleted = entity.IsDeleted; add.CreatedBy = entity.CreatedBy; add.CreateDate = DateTime.Now; context.Entry(add).State = EntityState.Added; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
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 AddOrUpdate(int congViecId, IEnumerable <CongViecPhoiHopResult> entities, string userName) { if (entities != null && entities.Any()) { //get all phoi hop by hosocongviecid using (var context = new TechOfficeEntities()) { var listPhoihop = context.CongViec_PhoiHop.Where(x => x.HoSoCongViecId == congViecId).Select(x => new { x.UserId, x.HoSoCongViecId }).ToList(); var listEntities = entities.Select(x => new { x.UserId, x.HoSoCongViecId }); //cac phan tu ton tai trong listPhoiHop nhun ko ton tai trong entites var left = listPhoihop.Except(listEntities); //lay ra cac phan tu ton tain trong entities nhung ko ton tai trong listPhoihop var right = listEntities.Except(listPhoihop); foreach (var item in left) { //remove var remove = context.CongViec_PhoiHop.Where(x => x.HoSoCongViecId == item.HoSoCongViecId && x.UserId == item.UserId).Single(); remove.IsDeleted = true; remove.LastUpdated = DateTime.Now; remove.LastUpdatedBy = userName; context.Entry(remove).State = EntityState.Modified; } foreach (var item in right) { //add var add = context.CongViec_PhoiHop.Create(); add.HoSoCongViecId = item.HoSoCongViecId; add.UserId = item.UserId; add.CreatedBy = userName; add.CreateDate = DateTime.Now; add.IsDeleted = false; context.Entry(add).State = EntityState.Added; } return(context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE); } } return(SaveResult.SUCCESS); }
public SaveResult Update(TacNghiepTinhHinhThucHienResult entity) { return(ExecuteDbWithHandle(_logService, () => { using (var context = new TechOfficeEntities()) { var update = context.TacNghiep_TinhHinhThucHien.Single(x => x.Id == entity.Id && x.IsDeleted == false); update.ThoiGian = entity.ThoiGian; update.MucDoHoanThanhId = entity.MucDoHoanThanhId; update.TacNghiepId = entity.TacNghiepId; update.CoQuanId = entity.CoQuanId; update.IsDeleted = entity.IsDeleted; update.LastUpdatedBy = entity.LastUpdatedBy; update.LastUpdated = DateTime.Now; context.Entry(update).State = EntityState.Modified; return context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }
public SaveResult Update(TacNghiepResult entity) { return(ExecuteDbWithHandle(_logService, () => { 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 context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } })); }