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);
}
private void btnluudulieu_Click(object sender, EventArgs e)
{
if (rdgood.Checked == true)
{
diadll.CapNhatTinhTrangDia((int)dataGridView1.CurrentRow.Cells[1].Value, "Good");
}
if (rdnotgood.Checked == true)
{
diadll.CapNhatTinhTrangDia((int)dataGridView1.CurrentRow.Cells[1].Value, "Not good");
}
nhatkythuediadll.ChinhTrangThaiThueDia((int)dataGridView1.CurrentRow.Cells[1].Value, "Available");
madia = (int)dataGridView1.CurrentRow.Cells[1].Value;
matua = dataGridView1.CurrentRow.Cells[4].Value.ToString();
nhatkythuediadll.TangSoLuong(dataGridView1.CurrentRow.Cells[4].Value.ToString());
nhatkythuediadll.ChinhSuaTinhTrangTraDia((int)dataGridView1.CurrentRow.Cells[0].Value, "Da tra");
decimal sotienkhongcophitre = ConvertStringToDecimal(lbltongtienquykhachphaitra.Text);
decimal sotiencophitre = (((decimal)0.1 * (decimal)dataGridView1.CurrentRow.Cells[6].Value) + ((decimal)0.2 * ConvertStringToDecimal(lbltiendatcoc.Text)));
if (DateTime.Now > (DateTime)dataGridView1.CurrentRow.Cells[8].Value && sotiencophitre > sotienkhongcophitre)
{
nhatkythuediadll.ThemPhiNoTre(dataGridView1.CurrentRow.Cells[2].Value.ToString(), (decimal)0.1 * (decimal)dataGridView1.CurrentRow.Cells[6].Value);
eNhatKyGhiNo no = new eNhatKyGhiNo();
no.IDDia = (int)dataGridView1.CurrentRow.Cells[1].Value;
no.IDKhachHang = dataGridView1.CurrentRow.Cells[2].Value.ToString();
no.SoTienNo = (decimal)0.1 * (decimal)dataGridView1.CurrentRow.Cells[6].Value;
nhatkyghinodll.ThemThongTinNo(no);
}
if (tuadedll.SoLuongDiaCuaTuaDe(dataGridView1.CurrentRow.Cells[4].Value.ToString()) > 0)
{
grbgiucho.Visible = true;
Load_Basic_Customer_Inf();
}
dataGridView1.DataSource = nhatkythuediadll.GetList();
}
