public void ChinhSuaTinhTrangTraDia(int manhatky, string text) { NhatKyThueDia diary = db.NhatKyThueDias.Where(x => x.ID == manhatky).FirstOrDefault(); diary.tinhtrangtradia = text; db.SubmitChanges(); }
public void ThemPhiNoTre(string makh, decimal phitre) { NhatKyThueDia diary = db.NhatKyThueDias.Where(x => x.MaKH == makh).FirstOrDefault(); diary.PhiTreHen = phitre; db.SubmitChanges(); }
public bool KiemTraMaKhachHangCoThueDiaNayChua(string makh, string matuade) { NhatKyThueDia nhatkithuedia = db.NhatKyThueDias.Where(x => x.MaKH == makh && x.MaTua == matuade && x.tinhtrangtradia == "Chua tra").FirstOrDefault(); if (nhatkithuedia != null) { return(true); } return(false); }
public bool Save_Disc_Hire_Diary(eNhatKyThueDia newdiary) { try { NhatKyThueDia diary = new NhatKyThueDia(); diary.MaDia = newdiary.MaDia.ToString(); diary.MaKH = newdiary.MaKhachHang; diary.MaTua = newdiary.MaTua; diary.NgayChoThue = newdiary.NgayChoThue; diary.NgayTraDia = newdiary.NgayTraDia; diary.PhiTreHen = newdiary.PhiTreHen; diary.SoLuongThue = newdiary.SoLuongThue; diary.TienDatCoc = newdiary.TienDatCoc; ChinhTrangThaiThueDia(newdiary.MaDia, "Not Available"); diary.tinhtrangtradia = "Chua tra"; db.NhatKyThueDias.InsertOnSubmit(diary); db.SubmitChanges(); return(true); } catch (Exception) { return(false); } }