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 }