public int ThemBBNT(int idyc)
{
BienBanNghiemThu bbnt = new BienBanNghiemThu();
bbnt.IDYC = idyc;
bbnt.NgayLap = DateTime.Now.Date;
bbnt.Status = true;
bbnt.DoanhThu = 0;
bbnt.Diem = 0;
db.BienBanNghiemThus.Add(bbnt);
db.SaveChanges();
return(bbnt.ID);
}
// GET: KTV/Home
public ActionResult Index(int?lastMonth)
{
string name = HttpContext.User.Identity.Name;
List <BienBanNghiemThu> list = new List <BienBanNghiemThu>();
List <CTBienBanNghiemThu> listct = new List <CTBienBanNghiemThu>();
if (!String.IsNullOrEmpty(name))
{
var ktv = db.NhanViens.SingleOrDefault(x => x.Username.Equals(name) && x.Status == 1);
var ktv_bbnt = db.KTV_BBNT.Where(x => x.IDUser == ktv.ID);
if (lastMonth == null)
{
ktv_bbnt = ktv_bbnt.Where(x => x.BienBanNghiemThu.NgayLap.Value.Month == DateTime.Now.Month);
}
else
{
ktv_bbnt = ktv_bbnt.Where(x => x.IDUser == ktv.ID && x.BienBanNghiemThu.NgayLap.Value.Month == lastMonth);
}
foreach (var item in ktv_bbnt)
{
BienBanNghiemThu bbnt = new BienBanNghiemThu();
bbnt = db.BienBanNghiemThus.Find(item.IDBBNT);
list.Add(bbnt);
}
foreach (BienBanNghiemThu bb in list)
{
var ct = db.CTBienBanNghiemThus.Where(x => x.IDBBNT == bb.ID);
foreach (var item in ct)
{
listct.Add(item);
}
}
ViewBag.BBNT = list;
ViewBag.KTV = ktv_bbnt;
ViewBag.NV = ktv;
}
return(View(listct));
}
