public void insertReservationTitle(eReservationTitle e)
{
tbl_ReservationTitle temp = new tbl_ReservationTitle();
temp.ReservationID = e.ReservationID;
temp.TitleID = e.TitleID;
db.tbl_ReservationTitles.InsertOnSubmit(temp);
db.SubmitChanges();
}
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();
}
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 void insertReservation(eReservation e)
{
tbl_Reservation temp = new tbl_Reservation();
temp.ReservationDate = e.ReservationDate;
temp.CustomerID = e.CustomerID;
db.tbl_Reservations.InsertOnSubmit(temp);
db.SubmitChanges();
}
public void insertDiskRental(eDiskRental e)
{
tbl_DiskRental temp = new tbl_DiskRental();
temp.RentalID = e.RentalID;
temp.DiskID = e.DiskID;
temp.Status = e.Status;
temp.ReturnDate = e.ReturnDate;
db.tbl_DiskRentals.InsertOnSubmit(temp);
db.SubmitChanges();
}
public void insertDisk(eDisk disk)
{
tbl_Disk temp = new tbl_Disk();
temp.TitleID = disk.TitleID;
temp.DiskStatus = disk.DiskStatus;
temp.DiskCode = disk.DiskCode;
db.tbl_Disks.InsertOnSubmit(temp);
db.SubmitChanges();
}
public void insertTitle(eTitle title)
{
tbl_Title temp = new tbl_Title();
temp.TitleName = title.TitleName;
temp.RentalPeriod = title.RentalPeriod;
temp.RentalCharge = title.RentalCharge;
temp.TitleStatus = title.TitleStatus;
temp.Quantity = title.Quantity;
db.tbl_Titles.InsertOnSubmit(temp);
db.SubmitChanges();
}
public int AddCustomer(eCustomer kh)
{
var customerid = DB.tbl_Customers.Where(x => x.CustomerID == kh.CustomerID).FirstOrDefault();
if (customerid != null)
{
return(0);
}
tbl_Customer khTmp = new tbl_Customer();
khTmp.CustomerID = kh.CustomerID;
khTmp.CustomerName = kh.CustomerName;
khTmp.Address = kh.Address;
khTmp.PhoneNumber = kh.PhoneNumber;
DB.tbl_Customers.InsertOnSubmit(khTmp);
DB.SubmitChanges();
return(1);
}
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);
}
