public ActionResult XemChiTiet(int?quan, String tuyen, String month, String year) { TuyenDuocChot duocChot = db.TuyenDuocChots.FirstOrDefault(p => p.Thang.ToString() == month && p.Nam.ToString() == year && p.TuyenKHID.ToString() == tuyen); DateTime prevDatabaseBackupDate = new DateTime(Convert.ToInt32(year), Convert.ToInt32(month), 1); if (prevDatabaseBackupDate < new DateTime(2017, 7, 1)) { updateAllHoaDon(quan, tuyen, Convert.ToInt32(month), Convert.ToInt32(year)); } else { if (duocChot != null) { updateAllHoaDon(quan, tuyen, Convert.ToInt32(month), Convert.ToInt32(year)); } } //Cập nhật trạng thái tính tiền int tuyenInt = Convert.ToInt32(tuyen); int monthInt = Convert.ToInt32(month); int yearInt = Convert.ToInt32(year); List <TuyenTinhTien> hoadons = getDanhSachHoaDonDuocIn(tuyen, monthInt, yearInt); TuyenDuocChot chotTuyen = db.TuyenDuocChots.FirstOrDefault(p => p.TuyenKHID == tuyenInt && p.Thang == monthInt && p.Nam == yearInt); if (chotTuyen != null) { chotTuyen.TrangThaiTinhTien = true; db.Entry(chotTuyen).State = EntityState.Modified; db.SaveChanges(); } #region ViewBag ViewBag.dsachKH = hoadons; ViewBag.selectedTuyen = tuyen; #endregion return(View()); }
public void capNhatTrangThaiChotTuyen(int tuyenKHID, int month, int year) { DateTime thangNamGanNhat = getThangNamGanNhatThuocHoaDon(tuyenKHID, month, year); DateTime thangNamHienTai = new DateTime(year, month, 1); DateTime[] monthsYears = time.getMonthYearBetweenDates(thangNamGanNhat, thangNamHienTai); foreach (var monthYear in monthsYears) { var isChot = db.TuyenDuocChots.FirstOrDefault(p => p.TuyenKHID == tuyenKHID && p.Thang == monthYear.Month && p.Nam == monthYear.Year); if (isChot == null) { TuyenDuocChot tuyenChot = new TuyenDuocChot(); tuyenChot.TuyenKHID = tuyenKHID; tuyenChot.Nam = year; tuyenChot.Thang = month; tuyenChot.TrangThaiChot = true; tuyenChot.TrangThaiTinhTien = false; tuyenChot.NgayChot = DateTime.Now; db.TuyenDuocChots.Add(tuyenChot); db.SaveChanges(); } } }