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)); }