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