public void addrental()
{
eRental rental = new eRental();
rental.CustomerID = Convert.ToInt32(cmbCustomerID.Text);
rental.RentalDate = Convert.ToDateTime(dtpRental.Text);
rentalbll.insertRental(rental);
//LoadDataGridView(dgvRental, rentalbll.getAllRental());
LoadDataGridView(dgvRental, rentalbll.getRentalByCustomerID(Convert.ToInt32(cmbCustomerID.Text)));
eRental ren1 = new eRental();
ren1.RentalID = rentalbll.maxRentalID();
frmDiskRental child = new frmDiskRental();
child.Rentalid = Convert.ToInt32(rentalbll.maxRentalID().ToString());
child.Status = true;
child.Show();
}
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 updateRental(eRental e)
{
tbl_Rental temp = db.tbl_Rentals.Where(x => x.RentalID == e.RentalID).FirstOrDefault();
temp.RentalDate = e.RentalDate;
temp.CustomerID = e.CustomerID;
db.SubmitChanges();
}
public eRental getOneRental(int rid)
{
eRental e = new eRental();
var item = db.tbl_Rentals.Where(x => x.RentalID == rid).FirstOrDefault();
e.RentalID = item.RentalID;
e.RentalDate = Convert.ToDateTime( item.RentalDate);
e.CustomerID = Convert.ToInt32( item.CustomerID);
return e;
}
public void insertRental(eRental e)
{
tbl_Rental temp = new tbl_Rental();
temp.RentalDate = e.RentalDate;
temp.CustomerID = e.CustomerID;
db.tbl_Rentals.InsertOnSubmit(temp);
db.SubmitChanges();
}
private void btnCheck_Click(object sender, EventArgs e)
{
if (checkInput1() == true)
{
eRental rental = new eRental();
rental.CustomerID = Convert.ToInt32(cmbCustomerID.Text);
rental.RentalDate = Convert.ToDateTime(dtpRental.Text);
frmDiskRental child = new frmDiskRental();
child.Rentalid = Convert.ToInt32(lblRentalID.Text);
child.Status = false;
child.Show();
}
}
public List<eRental> getRentalByCustomerID(int cid)
{
List<eRental> ls = new List<eRental>();
var list = db.tbl_Rentals.Where(x => x.CustomerID == cid).ToList();
foreach (tbl_Rental item in list)
{
eRental temp = new eRental();
temp.RentalID = item.RentalID;
temp.RentalDate = Convert.ToDateTime(item.RentalDate);
temp.CustomerID = Convert.ToInt32(item.CustomerID);
ls.Add(temp);
}
return ls;
}
public List<eRental> getAllRental()
{
List<eRental> ls = new List<eRental>();
foreach (tbl_Rental item in db.tbl_Rentals.ToList())
{
eRental temp = new eRental();
temp.RentalID = item.RentalID;
temp.RentalDate = Convert.ToDateTime(item.RentalDate);
temp.CustomerID = Convert.ToInt32( item.CustomerID);
ls.Add(temp);
}
return ls;
}
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);
}
