public datatable <User> get_user_pagesize(int pagesize, int pageindex, string search)
{
datatable <User> dv = new datatable <User>();
List <User> ds = new List <User>();
int role_ = 0;
using (sql_NCKHContext db = new sql_NCKHContext())
{
int index = (pageindex - 1) * pagesize;
if (!string.IsNullOrEmpty(search))
{
if (search.ToUpper() == "CÁN BỘ")
{
role_ = 3;
}
if (search.ToUpper() == "ADMIN")
{
role_ = 1;
}
if (search.ToUpper() == "NHÂN VIÊN")
{
role_ = 2;
}
ds = db.Users.Where(x => x.Taikhoan.IndexOf(search) >= 0 || x.Idrole == role_).Skip(index).Take(pagesize).ToList();
dv.total = db.Users.Where(x => x.Taikhoan.IndexOf(search) >= 0 || x.Idrole == role_).Count();
}
else
{
ds = db.Users.Skip(index).Take(pagesize).ToList();
dv.total = db.Users.Count();
}
dv.result = ds;
}
return(dv);
}
public List <Tblhoso> get_hoso_iddetai(int iddetai)
{
datatable <Tblhoso> dv = new datatable <Tblhoso>();
List <Tblhoso> ds = new List <Tblhoso>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
return(db.Tblhosos.Where(x => x.Iddetai == iddetai).ToList());
}
}
private void SetTextboxes(datatable DT)
{
//Clear the previous textboxes
pnlLayoutExpenses.Controls.clear();
//loop through table and create new textboxes
foreach (DataRow row in DT.Rows)
{
formAddTextbox(row("dataTableColumnWhichHoldsTextboxText"));
}
}
public List <Tblphanhoi> get_phanhoi_pagesize(int iddetai)
{
datatable <Tblphanhoi> dv = new datatable <Tblphanhoi>();
List <Tblphanhoi> ds = new List <Tblphanhoi>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
return(db.Tblphanhois.Where(x => x.Iddetai == iddetai).ToList());
}
}
public datatable<Tblsohuudetai> get_sohuudetai_pagesize(int pagesize, int pageindex, string search)
{
datatable<Tblsohuudetai> dv = new datatable<Tblsohuudetai>();
List<Tblsohuudetai> ds = new List<Tblsohuudetai>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
int index = (pageindex - 1) * pagesize;
ds = db.Tblsohuudetais.Skip(pageindex).Take(pagesize).ToList();
dv.total = db.Tblsohuudetais.Count();
dv.result = ds;
}
return dv;
}
public datatable <nhanvien> get_nhanvien_pagesize(int pagesize, int pageindex, string search)
{
datatable <nhanvien> dv = new datatable <nhanvien>();
List <nhanvien> ds = new List <nhanvien>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
int index = (pageindex - 1) * pagesize;
if (!string.IsNullOrEmpty(search))
{
ds = db.Tblnhanviens.Join(db.Tblphongbans, nv => nv.Idpban, pb => pb.Id, (nv, pb) => new nhanvien
{
Id = nv.Id,
Hoten = nv.Hoten,
Gioitinh = nv.Gioitinh,
Dienthoai = nv.Dienthoai,
Email = nv.Email,
Idpban = nv.Idpban,
pban = pb.Tenphongban
}).Where(x => x.Hoten.IndexOf(search) >= 0 || x.Dienthoai.IndexOf(search) >= 0 || x.pban.IndexOf(search) >= 0).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblnhanviens.Join(db.Tblphongbans, nv => nv.Idpban, pb => pb.Id, (nv, pb) => new nhanvien
{
Id = nv.Id,
Hoten = nv.Hoten,
Gioitinh = nv.Gioitinh,
Dienthoai = nv.Dienthoai,
Email = nv.Email,
Idpban = nv.Idpban,
pban = pb.Tenphongban
}).Where(x => x.Hoten.IndexOf(search) >= 0 || x.Dienthoai.IndexOf(search) >= 0 || x.pban.IndexOf(search) >= 0).Count();
}
else
{
ds = db.Tblnhanviens.Join(db.Tblphongbans, nv => nv.Idpban, pb => pb.Id, (nv, pb) => new nhanvien
{
Id = nv.Id,
Hoten = nv.Hoten,
Gioitinh = nv.Gioitinh,
Dienthoai = nv.Dienthoai,
Email = nv.Email,
Idpban = nv.Idpban,
pban = pb.Tenphongban
}).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblnhanviens.Count();
}
dv.result = ds;
}
return(dv);
}
public datatable <Tbltintuc> get_tintuc_idloai(int pagesize, int pageindex, int idloai)
{
datatable <Tbltintuc> dv = new datatable <Tbltintuc>();
List <Tbltintuc> ds = new List <Tbltintuc>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
ds = db.Tbltintucs.Where(x => x.Idloai == idloai).Skip(pageindex).Take(pagesize).ToList();
foreach (Tbltintuc tt in ds)
{
tt.IdloaiNavigation.Tenloaitt = db.Tblloaitts.SingleOrDefault(x => x.Id == tt.Idloai).Tenloaitt;
}
dv.total = db.Tbltintucs.Where(x => x.Idloai == idloai).Count();
}
return(dv);
}
public datatable <Tblloainghiencuu> get_loainghiencuu_pagesize(int pagesize, int pageindex, string search)
{
datatable <Tblloainghiencuu> dv = new datatable <Tblloainghiencuu>();
int index = (pageindex - 1) * pagesize;
using (sql_NCKHContext db = new sql_NCKHContext())
{
if (!string.IsNullOrEmpty(search))
{
dv.result = db.Tblloainghiencuus.Where(x => x.Tenloai.IndexOf(search) >= 0).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblloainghiencuus.Where(x => x.Tenloai.IndexOf(search) >= 0).Count();
}
else
{
dv.result = db.Tblloainghiencuus.Skip(index).Take(pagesize).ToList();
dv.total = db.Tblloainghiencuus.Count();
}
}
return(dv);
}
public datatable <tintucloai> get_tintuc_pagesize(int pagesize, int pageindex, string search)
{
datatable <tintucloai> dv = new datatable <tintucloai>();
int index = (pageindex - 1) * pagesize;
using (sql_NCKHContext db = new sql_NCKHContext())
{
if (!string.IsNullOrEmpty(search))
{
dv.result = db.Tbltintucs.Join(db.Tblloaitts, tt => tt.Idloai, ltt => ltt.Id, (tt, ltt) => new tintucloai
{
Id = tt.Id,
Tieude = tt.Tieude,
Hinhanh = tt.Hinhanh,
Idloai = tt.Idloai,
Noidung = tt.Noidung,
Luotem = tt.Luotem,
Ngaydang = tt.Ngaydang,
Tenloaitt = ltt.Tenloaitt
}).Where(x => x.Tieude.IndexOf(search) >= 0).Skip(index).Take(pagesize).ToList();
dv.total = db.Tbltintucs.Where(x => x.Tieude.IndexOf(search) >= 0).Count();
}
else
{
dv.result = db.Tbltintucs.Join(db.Tblloaitts, tt => tt.Idloai, ltt => ltt.Id, (tt, ltt) => new tintucloai
{
Id = tt.Id,
Tieude = tt.Tieude,
Hinhanh = tt.Hinhanh,
Idloai = tt.Idloai,
Noidung = tt.Noidung,
Luotem = tt.Luotem,
Ngaydang = tt.Ngaydang,
Tenloaitt = ltt.Tenloaitt
}).Skip(index).Take(pagesize).ToList();
dv.total = db.Tbltintucs.Count();
}
}
return(dv);
}
public datatable <Tblphongban> get_phongban_pagesize(int pagesize, int pageindex, string search)
{
datatable <Tblphongban> dv = new datatable <Tblphongban>();
List <Tblphongban> ds = new List <Tblphongban>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
int index = (pageindex - 1) * pagesize;
if (!string.IsNullOrEmpty(search))
{
ds = db.Tblphongbans.Where(x => x.Tenphongban.IndexOf(search) >= 0).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblphongbans.Where(x => x.Tenphongban.IndexOf(search) >= 0).Count();
}
else
{
ds = db.Tblphongbans.Skip(index).Take(pagesize).ToList();
dv.total = db.Tblphongbans.Count();
}
dv.result = ds;
}
return(dv);
}
public datatable <Tblloaitt> get_loaitintuc_pagesize(int pagesize, int pageindex, string search)
{
datatable <Tblloaitt> dv = new datatable <Tblloaitt>();
List <Tblloaitt> ds = new List <Tblloaitt>();
int index = (pageindex - 1) * pagesize;
using (sql_NCKHContext db = new sql_NCKHContext())
{
if (!string.IsNullOrEmpty(search))
{
ds = db.Tblloaitts.OrderByDescending(x => x.Id).Where(x => x.Tenloaitt.IndexOf(search) >= 0).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblloaitts.Where(x => x.Tenloaitt.IndexOf(search) >= 0).Count();
}
else
{
ds = db.Tblloaitts.OrderByDescending(x => x.Id).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblloaitts.Count();
}
dv.result = ds;
}
return(dv);
}
public datatable <hoadongnc> get_hoatdongnckh_pagesize(int pagesize, int pageindex, string search)
{
datatable <hoadongnc> dv = new datatable <hoadongnc>();
List <hoadongnc> ds = new List <hoadongnc>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
int index = (pageindex - 1) * pagesize;
if (!string.IsNullOrEmpty(search))
{
ds = db.Tblhoatdongnckhs.Join(db.Tblloaihoatdongs, hd => hd.Idloaihd, lhd => lhd.Id, (hd, lhd) => new hoadongnc
{
Id = hd.Id,
Tenhdnckh = hd.Tenhdnckh,
Dinhmuc = hd.Dinhmuc,
Dmhtkinhphi = hd.Dmhtkinhphi,
Ghichu = hd.Ghichu,
Tenkhoahoc = lhd.Tenloaihd
}).Where(x => x.Tenhdnckh.IndexOf(search) >= 0).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblhoatdongnckhs.Where(x => x.Tenhdnckh.IndexOf(search) >= 0).Count();
}
else
{
ds = db.Tblhoatdongnckhs.Join(db.Tblloaihoatdongs, hd => hd.Idloaihd, lhd => lhd.Id, (hd, lhd) => new hoadongnc
{
Id = hd.Id,
Tenhdnckh = hd.Tenhdnckh,
Dinhmuc = hd.Dinhmuc,
Dmhtkinhphi = hd.Dmhtkinhphi,
Ghichu = hd.Ghichu,
Tenkhoahoc = lhd.Tenloaihd
}).Skip(index).Take(pagesize).ToList();
dv.total = db.Tblhoatdongnckhs.Count();
}
dv.result = ds;
}
return(dv);
}
public datatable <detai> get_detai_pagesize(int pagesize, int pageindex, string search)
{
datatable <detai> dv = new datatable <detai>();
List <detai> ds = new List <detai>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
//int index = (pageindex - 1) * pagesize;
if (!string.IsNullOrEmpty(search))
{
ds = (from dt in db.Tbldetais
join hd in db.Tblhoatdongnckhs on dt.Idhdnckh equals hd.Id
join lv in db.Tbllinhvucs on dt.Idlinhvuc equals lv.Id
join lnv in db.Tblloainhiemvus on dt.Idloainv equals lnv.Id
join nv in db.Tblloaihoatdongs on hd.Idloaihd equals nv.Id
select new detai
{
Id = dt.Id,
Tendetai = dt.Tendetai,
Idnv = dt.Idnv,
Idlsp = dt.Idlsp,
Tentc = dt.Tentc,
Sohieu = dt.Sohieu,
Namsx = dt.Namsx,
Tap = dt.Tap,
So = dt.So,
Trang = dt.Trang,
Soif = dt.Soif,
Minhchung = dt.Minhchung,
Tinhtrang = dt.Tinhtrang,
Ghichu = dt.Ghichu,
Idlinhvuc = dt.Idlinhvuc,
Idloainv = dt.Idloainv,
Idhdnckh = dt.Idhdnckh,
Uytin = dt.Uytin,
Thoigianbd = dt.Thoigianbd,
Thoigiankt = dt.Thoigiankt,
Thoigiannt = dt.Thoigiannt,
Thoigiangiahan = dt.Thoigiangiahan,
Kqbv = dt.Kqbv,
Capbv = dt.Capbv,
Noidang = dt.Noidang,
Namdang = dt.Namdang,
Tenhdnckh = nv.Tenloaihd,
Tenlinhvuc = lv.Tenlinhvuc,
Tenloainv = lnv.Tenloainv
}).Where(x => x.Tendetai.IndexOf(search) >= 0 && (x.Tinhtrang != -1 && x.Tinhtrang != 6)).Skip(pageindex).Take(pagesize).ToList();
//ds = db.Tbldetais.Where(x => x.Tendetai.IndexOf(search) >= 0).Skip(pageindex).Take(pagesize).ToList();
dv.total = db.Tbldetais.Where(x => x.Tendetai.IndexOf(search) >= 0 && (x.Tinhtrang != -1 && x.Tinhtrang != 6)).Count();
}
else
{
ds = (from dt in db.Tbldetais
join hd in db.Tblhoatdongnckhs on dt.Idhdnckh equals hd.Id
join lv in db.Tbllinhvucs on dt.Idlinhvuc equals lv.Id
join lnv in db.Tblloainhiemvus on dt.Idloainv equals lnv.Id
join nv in db.Tblloaihoatdongs on hd.Idloaihd equals nv.Id
select new detai
{
Id = dt.Id,
Tendetai = dt.Tendetai,
Idnv = dt.Idnv,
Idlsp = dt.Idlsp,
Tentc = dt.Tentc,
Sohieu = dt.Sohieu,
Namsx = dt.Namsx,
Tap = dt.Tap,
So = dt.So,
Trang = dt.Trang,
Soif = dt.Soif,
Minhchung = dt.Minhchung,
Tinhtrang = dt.Tinhtrang,
Ghichu = dt.Ghichu,
Idlinhvuc = dt.Idlinhvuc,
Idloainv = dt.Idloainv,
Idhdnckh = dt.Idhdnckh,
Uytin = dt.Uytin,
Thoigianbd = dt.Thoigianbd,
Thoigiankt = dt.Thoigiankt,
Thoigiannt = dt.Thoigiannt,
Thoigiangiahan = dt.Thoigiangiahan,
Kqbv = dt.Kqbv,
Capbv = dt.Capbv,
Noidang = dt.Noidang,
Namdang = dt.Namdang,
Tenhdnckh = nv.Tenloaihd,
Tenlinhvuc = lv.Tenlinhvuc,
Tenloainv = lnv.Tenloainv
}).Where(x => x.Tinhtrang != -1 && x.Tinhtrang != 6).Skip(pageindex).Take(pagesize).ToList();
dv.total = db.Tbldetais.Where(x => x.Tinhtrang != -1 && x.Tinhtrang != 6).Count();
}
dv.result = ds;
}
return(dv);
}
