public static string delete_CUS_DOC_FolderCustom(AppEntities db, int ID, string Username)
{
string result = string.Empty;
var dbitem = db.tbl_CUS_DOC_Folder.Find(ID);
if (dbitem != null)
{
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
dbitem.IsDeleted = true;
if (dbitem.IDLinhVuc > 0)
{
result = "Không được xóa thư mục Lĩnh vực";
}
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, dbitem.IDPartner, "DTO_CUS_DOC_Folder", dbitem.ModifiedDate, Username);
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("delete_CUS_DOC_Folder", e);
result = e.InnerException.Message;
}
}
return(result);
}
public static MMenuAccessVM getByIdRole(int id)
{
var data = new MMenuAccessVM();
using (AppEntities db = new AppEntities())
{
var roleAccess = db.m_role.Select(x => new MRoleVM()
{
id = x.id,
name = x.name,
code = x.code,
createdBy = x.created_by,
description = x.description
})
.Where(x => x.id == id)
.FirstOrDefault();
//ambil data menu dengan role id diatas
var menuList = db.m_menu_access
.Where(x => x.m_role_id == id)
.Select(x => new MMenuVM()
{
id = x.m_menu_id,
name = x.m_menu.name,
is_active = x.is_active,
updated_by = x.updated_by,
updated_date = x.updated_date
}).ToList();
//memasukan ke alamat yg telah disiapkan
data.role = roleAccess;
data.listMenu = menuList;
}
return(data);
}
public static bool uploadFileThuyetMinh(AppEntities db, int deTaiId, string path, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_ThuyetMinhDeTai.FirstOrDefault(c => c.IDDeTai == deTaiId);
if (dbitem == null)
{
dbitem = new tbl_PRO_ThuyetMinhDeTai();
dbitem.IDDeTai = deTaiId;
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
db.tbl_PRO_ThuyetMinhDeTai.Add(dbitem);
}
if (dbitem != null)
{
dbitem.FileThuyetMinh = path;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "tbl_PRO_ThuyetMinhDeTai", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("uploadFileThuyetMinh", e);
result = false;
}
}
return(result);
}
public static bool put_PRO_HoiNghiHoiThao_DangKyDeTai(AppEntities db, int ID, DTO_PRO_HoiNghiHoiThao_DangKyDeTai item, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_HoiNghiHoiThao_DangKyDeTai.Find(ID);
if (dbitem != null)
{
dbitem.IDDangKy = item.IDDangKy;
dbitem.IDHoiNghiHoiThao = item.IDHoiNghiHoiThao;
dbitem.IDHinhThucDangKy = item.IDHinhThucDangKy;
dbitem.IDTrangThai = item.IDTrangThai;
dbitem.TenDeTai = item.TenDeTai;
dbitem.BaiAbstract = item.BaiAbstract;
dbitem.BaiFulltext = item.BaiFulltext;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_HoiNghiHoiThao_DangKyDeTai", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_PRO_HoiNghiHoiThao_DangKyDeTai", e);
result = false;
}
}
return(result);
}
public static bool put_SYS_Config(AppEntities db, int ID, DTO_SYS_Config item, string Username)
{
bool result = false;
var dbitem = db.tbl_SYS_Config.Find(ID);
if (dbitem != null)
{
dbitem.Code = item.Code;
dbitem.Name = item.Name;
dbitem.Remark = item.Remark;
dbitem.Sort = item.Sort;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.Value = item.Value;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_SYS_Config", dbitem.ModifiedDate, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_SYS_Config", e);
result = false;
}
}
return(result);
}
public static bool put_WEB_BaiViet_DanhMuc(AppEntities db, int ID, DTO_WEB_BaiViet_DanhMuc item, string Username)
{
bool result = false;
var dbitem = db.tbl_WEB_BaiViet_DanhMuc.Find(ID);
if (dbitem != null)
{
dbitem.IDDanhMuc = item.IDDanhMuc;
dbitem.IDBaiViet = item.IDBaiViet;
dbitem.URL = item.URL;
dbitem.Sort = item.Sort;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_WEB_BaiViet_DanhMuc", dbitem.ModifiedDate, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_WEB_BaiViet_DanhMuc", e);
result = false;
}
}
return(result);
}
public static bool put_PRO_HoiNghiHoiThaoCustom(AppEntities db, int ID, DTO_PRO_HoiNghiHoiThao item, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_HoiNghiHoiThao.Find(ID);
if (dbitem != null)
{
dbitem.ThoiGian = item.ThoiGian;
dbitem.ThoiGianHetHan = item.ThoiGianHetHan;
dbitem.DiaDiem = item.DiaDiem;
dbitem.TenHoiNghi = item.TenHoiNghi;
dbitem.IDSite = item.IDSite;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_HoiNghiHoiThao", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_PRO_HoiNghiHoiThaoCustom", e);
result = false;
}
}
return(result);
}
private async void UpdateCountdown(object sender, PropertyChangedEventArgs e)
{
var timeLeft = _countdownTimer.RemainingTime;
if (timeLeft.TotalMilliseconds == 0)
{
_countdownTimer.Reset();
_model["RemainingTime"] = "∞";
var appEntities = new AppEntities
{
MessageType = MessageType.OutOfTime
};
var dlEntity = new Microsoft.Bot.Connector.DirectLine.Entity();
dlEntity.SetAs(appEntities);
// Send an entity to the bot to tell it that the user has run out of time.
await _botClient.SendMessageToBot(null, new[] { dlEntity });
}
else
{
_model["RemainingTime"] = timeLeft.TotalSeconds.ToString("0.00");
}
}
public static bool put_CAT_Tags(AppEntities db, int ID, DTO_CAT_Tags item, string Username)
{
bool result = false;
var dbitem = db.tbl_CAT_Tags.Find(ID);
if (dbitem != null)
{
dbitem.TenTag = item.TenTag;
dbitem.GhiChu = item.GhiChu;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_CAT_Tags", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_CAT_Tags", e);
result = false;
}
}
return(result);
}
public static bool put_CAT_BangGiaKinhPhi(AppEntities db, int ID, DTO_CAT_BangGiaKinhPhi item, string Username)
{
bool result = false;
var dbitem = db.tbl_CAT_BangGiaKinhPhi.Find(ID);
if (dbitem != null)
{
dbitem.IDKinhPhi = item.IDKinhPhi;
dbitem.NgayHieuLuc = item.NgayHieuLuc;
dbitem.Gia = item.Gia;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_CAT_BangGiaKinhPhi", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_CAT_BangGiaKinhPhi", e);
result = false;
}
}
return(result);
}
public UsuarioTO IsValid(string usuario, string password, string empresaDS, string ipAdd)
{
string password_hash_local = CipherUtil.Encrypt(password);
AppEntities db = new AppEntities(empresaDS);
//inicializando el objeto que devolvera el usuario en base de datos;
UsuarioTO usuarioTO = new UsuarioTO();
usuarioTO.EmpresaDS = empresaDS;
usuarioTO.IPAddress = ipAdd;
usuarioTO.Valid = false;
var usuarioMatch = db.Usuarios.Where(
u => u.usuario == usuario &&
u.password_hash == password_hash_local &&
!u.bloqueo_habilitado &&
!u.eliminado
).DefaultIfEmpty(null).Single();
if (usuarioMatch != null)
{
usuarioTO.Valid = true;
usuarioTO.usuario = usuarioMatch;
//populando roles por usuario
foreach (Roles rol in usuarioMatch.Roles)
{
foreach (Rol_Acciones rolAcciones in rol.Rol_Acciones)
{
usuarioTO.fillPermisions(rol.Aplicaciones.ruta, rolAcciones.Controladores.nombre, rolAcciones.Acciones.nombre);
}
}
}
return(usuarioTO);
}
// GET: Administracion/Rol_Acciones
public ActionResult Index()
{
db = new AppEntities();
var rol_Acciones = db.Rol_Acciones.Include(r => r.Acciones).Include(r => r.Controladores).Include(r => r.Roles);
return(View(rol_Acciones.ToList()));
}
public static bool put_SYS_Var(AppEntities db, int ID, DTO_SYS_Var item, string Username)
{
bool result = false;
var dbitem = db.tbl_SYS_Var.Find(ID);
if (dbitem != null)
{
dbitem.Code = item.Code;
dbitem.ValueOfVar = item.ValueOfVar;
dbitem.TypeOfVar = item.TypeOfVar;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_SYS_Var", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_SYS_Var", e);
result = false;
}
}
return(result);
}
public static bool put_CUS_SYS_PermissionListDetailData(AppEntities db, int PartnerID, int ID, DTO_CUS_SYS_PermissionListDetailData item, string Username)
{
bool result = false;
var dbitem = db.tbl_CUS_SYS_PermissionListDetailData.Find(ID);
if (dbitem != null)
{
dbitem.IDPermission = item.IDPermission;
dbitem.Type = item.Type;
dbitem.Value = item.Value;
dbitem.Sort = item.Sort;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, dbitem.IDPartner, "DTO_CUS_SYS_PermissionListDetailData", dbitem.ModifiedDate, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_CUS_SYS_PermissionListDetailData", e);
result = false;
}
}
return(result);
}
public static bool put_CUS_DOC_File_Permission(AppEntities db, int PartnerID, int ID, DTO_CUS_DOC_File_Permission item, string Username)
{
bool result = false;
var dbitem = db.tbl_CUS_DOC_File_Permission.Find(ID);
if (dbitem != null)
{
dbitem.IDFile = item.IDFile;
dbitem.IDRole = item.IDRole;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.IsCanView = item.IsCanView;
dbitem.IsCanChange = item.IsCanChange;
dbitem.IsCanApprove = item.IsCanApprove;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, dbitem.IDPartner, "DTO_CUS_DOC_File_Permission", dbitem.ModifiedDate, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_CUS_DOC_File_Permission", e);
result = false;
}
}
return(result);
}
public static bool put_PRO_HoiNghiHoiThao_DangKy(AppEntities db, int ID, DTO_PRO_HoiNghiHoiThao_DangKy item, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_HoiNghiHoiThao_DangKy.Find(ID);
if (dbitem != null)
{
dbitem.IDNhanVien = item.IDNhanVien;
dbitem.IDHoiNghiHoiThao = item.IDHoiNghiHoiThao;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_HoiNghiHoiThao_DangKy", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_PRO_HoiNghiHoiThao_DangKy", e);
result = false;
}
}
return(result);
}
public static bool put_PRO_BenhNhan(AppEntities db, int ID, DTO_PRO_BenhNhan item, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_BenhNhan.Find(ID);
if (dbitem != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.IDBenhNhan = item.IDBenhNhan;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BenhNhan", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_PRO_BenhNhan", e);
result = false;
}
}
return(result);
}
public static void PRO_DonXinDanhGiaDaoDuc_Update(AppEntities db, int IDDeTai)
{
var dxdg = db.tbl_PRO_DonXinDanhGiaDaoDuc.FirstOrDefault(c => c.IDDeTai == IDDeTai && c.IsDeleted == false);
if (dxdg != null)
{
var xxdd = db.tbl_PRO_PhieuXemXetDaoDuc.FirstOrDefault(c => c.IDDeTai == IDDeTai && c.IsDeleted == false);
if (xxdd != null)
{
xxdd.DonViChuTri = dxdg.TenDonViChuTri + "<br>Địa chỉ: " + dxdg.DiaChiDonVi + "<br>Điện thoại:" + dxdg.DienThoaiDonVi;
}
var bangkiem = db.tbl_PRO_BangKiemLuaChonQuyTrinhXXDD.FirstOrDefault(c => c.IDDeTai == IDDeTai && c.IsDeleted == false);
if (bangkiem != null)
{
bangkiem.PhanBon_C1_NoiNhanMau = "<br>Địa điểm: " + dxdg.DiaDiemNghienCuu + "<br>" + "Thời gian: " + dxdg.ThoiGianNghienCuu + " tháng. Từ " + dxdg.TuNgay + " đến tháng " + dxdg.DenNgay;
}
var tmdt = db.tbl_PRO_ThuyetMinhDeTai.FirstOrDefault(c => c.IDDeTai == IDDeTai && c.IsDeleted == false);
if (tmdt != null)
{
tmdt.A4_ThoiGianThucHien = "Địa điểm: " + (!string.IsNullOrEmpty(dxdg.DiaDiemNghienCuu) ? dxdg.DiaDiemNghienCuu.Replace("<br>", "<div>") : "") + "<div>" + "Thời gian: " + dxdg.ThoiGianNghienCuu + " tháng. Từ " + dxdg.TuNgay + " đến tháng " + dxdg.DenNgay + "</div>";
tmdt.A7_TenCoQuan = dxdg.TenDonViChuTri;
tmdt.A7_DiaChi = dxdg.DiaChiDonVi;
tmdt.A7_DienThoai = dxdg.DienThoaiDonVi;
}
db.SaveChanges();
}
}
public static bool put_CUS_HRM_LIST_ChucDanh(AppEntities db, int PartnerID, int ID, DTO_CUS_HRM_LIST_ChucDanh item, string Username)
{
bool result = false;
var dbitem = db.tbl_CUS_HRM_LIST_ChucDanh.Find(ID);
if (dbitem != null)
{
dbitem.IDBoPhan = item.IDBoPhan;
dbitem.Code = item.Code;
dbitem.Name = item.Name;
dbitem.Remark = item.Remark;
dbitem.IsDisabled = item.IsDisabled;
dbitem.Sort = item.Sort;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, dbitem.IDPartner, "DTO_CUS_HRM_LIST_ChucDanh", dbitem.ModifiedDate, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_CUS_HRM_LIST_ChucDanh", e);
result = false;
}
}
return(result);
}
public static void STAFF_Info_Update(AppEntities db, int IDNhanSu)
{
var objNhanSu = db.tbl_CUS_HRM_STAFF_NhanSu.FirstOrDefault(c => c.ID == IDNhanSu && c.IsDeleted == false);
if (objNhanSu != null)
{
var queryLLKH = db.tbl_CUS_HRM_STAFF_NhanSu_LLKH.FirstOrDefault(c => c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (queryLLKH != null)
{
queryLLKH.HoTen = objNhanSu.Name;
}
var querySYLL = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.FirstOrDefault(c => c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (querySYLL != null)
{
querySYLL.HoTen = objNhanSu.Name;
}
foreach (var item in db.tbl_PRO_SYLL.Where(c => c.IDNhanSu == IDNhanSu && c.IsDeleted == false))
{
item.HoTen = objNhanSu.Name;
}
foreach (var item in db.tbl_PRO_LLKH.Where(c => c.IDNhanSu == IDNhanSu && c.IsDeleted == false))
{
item.HoTen = objNhanSu.Name;
}
db.SaveChanges();
}
}
public static bool uploadFullText_PRO_HoiNghiHoiThao(AppEntities db, int ID, string path, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_HoiNghiHoiThao.Find(ID);
if (dbitem != null)
{
dbitem.BaiFulltext = path;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_HoiNghiHoiThao", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("uploadFullText_PRO_HoiNghiHoiThao", e);
result = false;
}
}
return(result);
}
public static List <MUserVM> get()
{
List <MUserVM> data = new List <MUserVM>();
using (AppEntities db = new AppEntities())
{
data = db.m_user
.Include("m_employee")
.Include("m_role")
.Select(x => new MUserVM()
{
id = x.id,
mEmployeeId = x.m_employee_id,
username = x.username,
createdDate = x.created_date,
createdBy = x.created_by,
firtsName = x.m_employee.first_name,
lastName = x.m_employee.last_name,
nameRole = x.m_role.name,
isActive = x.is_active,
company = x.m_employee.m_company.name,
fullName = x.m_employee.first_name + x.m_employee.last_name
})
.ToList();
}
return(data);
}
public static bool delete_CUS_HRM_STAFF_NhanSu_HOSREM(AppEntities db, int ID, string Username)
{
bool result = false;
var dbitem = db.tbl_CUS_HRM_STAFF_NhanSu_HOSREM.Find(ID);
if (dbitem != null)
{
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
dbitem.IsDeleted = true;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_CUS_HRM_STAFF_NhanSu_HOSREM", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("delete_CUS_HRM_STAFF_NhanSu_HOSREM", e);
result = false;
}
}
return(result);
}
public static List <MUserVM> search(string user)
{
var data = new List <MUserVM>();
using (AppEntities db = new AppEntities())
{
data = db.m_user.Select(x => new MUserVM()
{
id = x.id,
username = x.username,
password = x.password,
mRoleId = x.m_role_id,
mEmployeeId = x.m_employee_id,
nameRole = x.m_role.name,
isActive = x.is_active,
createdBy = x.created_by,
createdDate = x.created_date,
firtsName = x.m_employee.first_name,
lastName = x.m_employee.last_name
})
.Where(x => x.username.Contains(user.ToLower()))
.ToList();
}
return(data);
}
public static bool delete_PAR_DonHang(AppEntities db, int ID, string Username)
{
bool result = false;
var dbitem = db.tbl_PAR_DonHang.Find(ID);
if (dbitem != null)
{
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
dbitem.IsDeleted = true;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, dbitem.IDPartner, "DTO_PAR_DonHang", dbitem.ModifiedDate, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("delete_PAR_DonHang", e);
result = false;
}
}
return(result);
}
public static bool update(MUserVM model)
{
bool result = false;
using (AppEntities db = new AppEntities())
{
var data = db.m_user.Find(model.id);
data.id = model.id;
data.m_employee_id = model.mEmployeeId;
data.m_role_id = model.mRoleId;
data.username = model.username;
data.password = model.password;
data.updated_by = model.updatedBy;
data.updated_date = DateTime.Now;
data.is_active = true;
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
}
return(result);
}
public static bool insert(MMenuAccessVM model)
{
bool result = false;
using (AppEntities db = new AppEntities())
{
foreach (var item in model.listMenuId)
{
var data = new m_menu_access()
{
m_role_id = model.role.id,
created_by = 2,
is_active = true,
created_date = DateTime.Now,
m_menu_id = item
};
db.m_menu_access.Add(data);
}
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
}
return(result);
}
public static bool insert(MUserVM model)
{
bool result = false;
using (AppEntities db = new AppEntities())
{
model.isActive = true;
m_user data = new m_user()
{
m_employee_id = model.mEmployeeId,
m_role_id = model.mRoleId,
username = model.username,
password = model.password,
created_by = model.createdBy,
created_date = DateTime.Now,
is_active = model.isActive
};
db.m_user.Add(data);
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
}
return(result);
}
public static bool delete_PRO_BangKhaiNhanSu(AppEntities db, int ID, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_BangKhaiNhanSu.Find(ID);
if (dbitem != null)
{
db.tbl_PRO_BangKhaiNhanSu.Remove(dbitem);
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BangKhaiNhanSu", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("delete_PRO_BangKhaiNhanSu", e);
result = false;
}
}
return(result);
}
public static List <DTO_CUS_DOC_RPT_Folder> RPT_FileInFolder(AppEntities db, int PartnerID, Dictionary <string, string> QueryStrings)
{
var query = db.tbl_CUS_DOC_File
.Where(d => d.IsDeleted == false && d.IDPartner == PartnerID)
.Select(s => new {
s.ID,
IDFolder = s.tbl_CUS_DOC_FileInFolder.Any()? s.tbl_CUS_DOC_FileInFolder.FirstOrDefault().IDFolder : null,
s.IsApproved,
s.ApprovedBy
}).ToList();
return
(query.GroupBy(g => g.IDFolder)
.Select(s => new DTO_CUS_DOC_RPT_Folder()
{
ID = s.Key,
CountFile = s.Count(),
CountApproved = s.Count(d => d.IsApproved),
CountWaitApprove = s.Count(d => d.ApprovedBy == "Chờ duyệt"),
}).ToList());
//var results = ctx.Rs.Where(r => r.QK != null)
//.GroupBy(r => r.QK)
//.Select(gr => new { Key = (int)gr.Key, Count = gr.Count() }
//.ToList();
//https://stackoverflow.com/questions/15571878/entity-framework-linq-query-with-order-by-and-group-by
//https://stackoverflow.com/questions/11564311/sql-to-entity-framework-count-group-by
}
