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); }