private void btnCheck_Click(object sender, EventArgs e)
{
if (checkDataInput() == true)
{
eDiskRental dr = new eDiskRental();
//MessageBox.Show(cmbDiskID.Text);
dr = drbll.getDiskNoRentalByDiskID(Convert.ToInt32(cmbDiskID.Text));
eRental r = new eRental();
r = rbll.getOneRental(dr.RentalID);
eCustomer c = new eCustomer();
c = cbll.getOneCustomer(r.CustomerID);
eDisk ed = new eDisk();
ed = dbll.getOneDisk(dr.DiskID);
eTitle et = new eTitle();
et = tbll.getOneTitle(ed.TitleID);
eLateCharge elc = new eLateCharge();
elc = lcbll.getOneLateCharge(c.CustomerID, ed.DiskID);
lblCustomerName.Text = c.CustomerName;
lblCusTomerID.Text = c.CustomerID.ToString();
lblAddress.Text = c.Address;
lblPhoneNumber.Text = c.PhoneNumber;
lblRentalDate.Text = r.RentalDate.ToString();
lblTitleID.Text = et.TitleName;
lblLateCharge.Text = elc.LateCharge.ToString();
//MessageBox.Show(r.CustomerID.ToString());
}
}
public void addLateCharge(eLateCharge el)
{
var item = db.tbl_LateCharges.Where(x => x.LateChargeID == el.LateChargeID).FirstOrDefault();
item.LateChargeID = el.LateChargeID;
item.CustomerID = Convert.ToInt32(el.CustomerID);
item.DiskID = Convert.ToInt32(el.DiskID);
item.LateCharge = 10000;
db.SubmitChanges();
}
public eLateCharge getLateChargeByDiskID(int did)
{
eLateCharge lc = new eLateCharge();
var temp = db.tbl_LateCharges.Where(x => x.DiskID == did).FirstOrDefault();
lc.LateChargeID = Convert.ToInt32(temp.LateChargeID);
lc.CustomerID = Convert.ToInt32(temp.CustomerID);
lc.DiskID = Convert.ToInt32(temp.DiskID);
lc.LateCharge = Convert.ToInt32(temp.LateCharge);
return(lc);
}
public eLateCharge getOneLateCharge(int cid, int did)
{
eLateCharge e = new eLateCharge();
var item = db.tbl_LateCharges.Where(x => x.CustomerID == cid && x.DiskID == did).FirstOrDefault();
e.LateChargeID = item.LateChargeID;
e.CustomerID = Convert.ToInt32(item.CustomerID);
e.DiskID = Convert.ToInt32(item.DiskID);
e.LateCharge = Convert.ToInt32(item.LateCharge);
return(e);
}
private void btnreturn_Click(object sender, EventArgs e)
{
//rtbll = new ReturnDiskBLL();
//eReturn ert = new eReturn();
//ert.CustomerID = Convert.ToInt32(txtcustomerid.Text);
//ert.DiskID = Convert.ToInt32(cmbDiskID.Text);
//ert.ReturnDate = Convert.ToDateTime(dtreturn.Text);
//int temp = rtbll.ReturnDisk(ert);
//if (temp >= 0 )
// MessageBox.Show("Trễ", "Noti", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
//else
//{
// MessageBox.Show("Trả đĩa thành công!", "Noti!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
//}
//0 la chua tra, 1 la tra roi
eDiskRental dr = new eDiskRental();
//MessageBox.Show(cmbDiskID.Text);
dr = drbll.getDiskNoRentalByDiskID(Convert.ToInt32(cmbDiskID.Text));
//MessageBox.Show(dr.RentalID.ToString());
drbll.updateStatusDiskRental(dr, 1);
eRental er = new eRental();
er = rbll.getOneRental(dr.RentalID);
TimeSpan ts = new TimeSpan();
ts = dr.ReturnDate - er.RentalDate;
eDisk di = new eDisk();
di = dbll.getOneDisk(dr.DiskID);
eLateCharge lc = new eLateCharge();
MessageBox.Show(er.CustomerID.ToString());
MessageBox.Show(di.DiskID.ToString());
lc = lcbll.getOneLateCharge(er.CustomerID, di.DiskID);
MessageBox.Show(lc.LateChargeID.ToString());
//lcbll.addLateCharge(lc);
}
public List <eLateCharge> getAllLateCharge()
{
List <eLateCharge> ls = new List <eLateCharge>();
foreach (tbl_LateCharge item in db.tbl_LateCharges.ToList())
{
eLateCharge temp = new eLateCharge();
temp.LateChargeID = item.LateChargeID;
temp.CustomerID = Convert.ToInt32(item.CustomerID);
temp.DiskID = Convert.ToInt32(item.DiskID);
temp.LateCharge = Convert.ToDecimal(item.LateCharge);
ls.Add(temp);
}
return(ls);
}
public List <eLateCharge> getLateChargeByCustomerID(int cid)
{
List <eLateCharge> ls = new List <eLateCharge>();
var lslate = db.tbl_LateCharges.Where(x => x.CustomerID == cid).ToList();
foreach (tbl_LateCharge item in lslate)
{
eLateCharge temp = new eLateCharge();
temp.LateChargeID = item.LateChargeID;
temp.CustomerID = Convert.ToInt32(item.CustomerID);
temp.DiskID = Convert.ToInt32(item.DiskID);
temp.LateCharge = Convert.ToDecimal(item.LateCharge);
ls.Add(temp);
}
return(ls);
}
public int Add(eLateCharge lcid)
{
var lateid = db.tbl_LateCharges.Where(x => x.LateChargeID == lcid.LateChargeID).FirstOrDefault();
if (lateid != null)
{
return(0);
}
tbl_LateCharge tmplc = new tbl_LateCharge();
tmplc.LateChargeID = lateid.LateChargeID;
tmplc.LateCharge = lateid.LateCharge;
tmplc.DiskID = lateid.DiskID;
tmplc.CustomerID = lateid.CustomerID;
db.tbl_LateCharges.InsertOnSubmit(tmplc);
db.SubmitChanges();
return(1);
}
