Exemplo n.º 1
0
        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();
        }
Exemplo n.º 2
0
        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();
        }
Exemplo n.º 3
0
        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();
        }
Exemplo n.º 4
0
        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();
        }
Exemplo n.º 5
0
        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();
        }
Exemplo n.º 6
0
        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();
        }
Exemplo n.º 7
0
        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();
        }
Exemplo n.º 8
0
        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);
        }
Exemplo n.º 9
0
        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);
        }