public decimal LayTongPhiTreCuaKhachHang(string makhachhang)
{
try
{
NhatKyGhiNo nhatkyghino = db.NhatKyGhiNos.Where(x => x.IDKhachHang == makhachhang).FirstOrDefault();
return(nhatkyghino.SoTienNo);
}
catch (Exception)
{
return(0);
}
}
public bool ThanhToanMuon(string makhachhang)
{
try
{
NhatKyGhiNo nhatkyghino = db.NhatKyGhiNos.Where(x => x.IDKhachHang == makhachhang).FirstOrDefault();
db.NhatKyGhiNos.DeleteOnSubmit(nhatkyghino);
db.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool SuaThongTinNo(eNhatKyGhiNo diary)
{
try
{
NhatKyGhiNo olddiary = db.NhatKyGhiNos.Where(x => x.IDKhachHang == diary.IDKhachHang).FirstOrDefault();
olddiary.SoTienNo = diary.SoTienNo;
db.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool ThemThongTinNo(eNhatKyGhiNo diary)
{
NhatKyGhiNo nhatKy = db.NhatKyGhiNos.Where(x => x.IDKhachHang == diary.IDKhachHang).FirstOrDefault();
if (nhatKy.SoTienNo >= 0)
{
nhatKy.SoTienNo += diary.SoTienNo;
}
else if (nhatKy == null)
{
NhatKyGhiNo nhatKyGhiNo = new NhatKyGhiNo();
nhatKyGhiNo.IDDia = diary.IDDia;
nhatKyGhiNo.IDKhachHang = diary.IDKhachHang;
nhatKyGhiNo.SoTienNo = diary.SoTienNo;
db.NhatKyGhiNos.InsertOnSubmit(nhatKyGhiNo);
db.SubmitChanges();
return(true);
}
return(false);
}
public decimal LayTongPhiTre(int id)
{
NhatKyGhiNo nhatkyghinos = db.NhatKyGhiNos.Where(x => x.ID == id).FirstOrDefault();
return(nhatkyghinos.SoTienNo);
}
