public List <nhanvien2> DanhSach()
{
List <nhanvien> list = db.nhanvien.ToList();
List <nhanvien2> list2 = new List <nhanvien2>();
for (int i = 0; i < list.Count; i++)
{
var id_nhanvien = list[i].id;
string ngach = "";
string bac = "";
var query2 = (from b in db.nhanvien_ngach
join c in db.ngach on b.id_ngach equals c.id
where b.id_nhanvien == id_nhanvien
select new
{
ngach = c.ngach1,
bac = b.bac,
ngay = b.ngay
}).OrderByDescending(x => x.ngay);
if (query2.Count() != 0)
{
ngach = query2.FirstOrDefault().ngach;
bac = query2.FirstOrDefault().bac;
}
//
string[] list_chucvu = new string[10];
var MaxDate = (from d in db.nhanvien_chucvu
where d.id_nhanvien == id_nhanvien
select d.ngay).Max();
var query3 = from b in db.nhanvien_chucvu
join c in db.chucvu on b.id_chucvu equals c.id
where b.id_nhanvien == id_nhanvien && b.ngay == MaxDate
select new
{
ten = c.chuc_vu
};
int v = 0;
//
if (query3 != null)
{
foreach (var item in query3)
{
list_chucvu[v] = item.ten;
v++;
}
}
nhanvien2 h = new nhanvien2(id_nhanvien, list[i].ma, list[i].ten, list[i].gioi_tinh, list[i].ngay_sinh, list[i].dan_toc, list[i].ngay_vao_lam, list[i].dia_chi, list[i].so_cmnd, list_chucvu, ngach, bac);
list2.Add(h);
}
return(list2);
}
public JsonResult TakeData(string ma, string ten, int page, string row_perpage)
{
var query = from b in db.nhanvien
where b.ma.Contains(ma) && b.ten.Contains(ten)
select b;
List <nhanvien> list = query.ToList <nhanvien>();
List <nhanvien2> list2 = new List <nhanvien2>();
for (int i = 0; i < list.Count; i++)
{
var id_nhanvien = list[i].id;
string ngach = "";
string bac = "";
var query2 = (from b in db.nhanvien_ngach
join c in db.ngach on b.id_ngach equals c.id
where b.id_nhanvien == id_nhanvien
select new
{
ngach = c.ngach1,
bac = b.bac,
ngay = b.ngay
}).OrderByDescending(x => x.ngay);
if (query2.Count() != 0)
{
ngach = query2.FirstOrDefault().ngach;
bac = query2.FirstOrDefault().bac;
}
//
string[] list_chucvu = new string[10];
var MaxDate = (from d in db.nhanvien_chucvu
where d.id_nhanvien == id_nhanvien
select d.ngay).Max();
var query3 = from b in db.nhanvien_chucvu
join c in db.chucvu on b.id_chucvu equals c.id
where b.id_nhanvien == id_nhanvien && b.ngay == MaxDate
select new
{
ten = c.chuc_vu
};
int v = 0;
//
if (query3.Count() != 0)
{
foreach (var item in query3)
{
list_chucvu[v] = item.ten;
v++;
}
}
nhanvien2 h = new nhanvien2(id_nhanvien, list[i].ma, list[i].ten, list[i].gioi_tinh, list[i].ngay_sinh, list[i].dan_toc, list[i].ngay_vao_lam, list[i].dia_chi, list[i].so_cmnd, list_chucvu, ngach, bac);
list2.Add(h);
}
int rowperpage = Int32.Parse(row_perpage);
int offset = (page - 1) * rowperpage;
var data = list2.Skip(offset).Take(rowperpage);
var count = list2.Count();
var result = new { data = data, count = count };
return(Json(result, JsonRequestBehavior.AllowGet));
}
