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