public static Boolean CapNhatTrangThaiChoThanhToan() { var entity = new QuanLyThueXeEntities(); try { var hd = entity.HopDongs.Where(n => n.MaTrangThai == "1"); foreach (var item in hd) { var cthd = entity.CT_HopDongs.Where(n => n.SoHopDong == item.SoHopDong); foreach (var c in cthd) { if (c.NgayVe < DateTime.Now) { HopDong result = entity.HopDongs.SingleOrDefault(n => n.SoHopDong == c.SoHopDong); result.MaTrangThai = "3"; TrangThaiQueries.CapNhatTrangThaiPhuXeRanh(c.SoHopDong); TrangThaiQueries.CapNhatTrangThaiTaiXeRanh(c.SoHopDong); TrangThaiQueries.CapNhatTrangThaiXeRanh(c.SoHopDong); } } } entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// <summary> /// cap nhat lai trang thai hop dong /// </summary> /// <returns>Boolean</returns> public static Boolean CapNhatTrangThai() { var entity = new QuanLyThueXeEntities(); try { //Lay danh sach hop dong dang cho var lstDangCho = entity.HopDongs.Where(n => n.MaTrangThai == "0"); foreach (var dcho in lstDangCho) { TrangThaiQueries.CapNhatTrangThaiDangChay(dcho.SoHopDong); } TrangThaiQueries.CapNhatTrangThaiPhuXeDangChay(); TrangThaiQueries.CapNhatTrangThaiTaiXeDangChay(); TrangThaiQueries.CapNhatTrangThaiXeDangChay(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }