Esempio n. 1
0
        string functionReturnPlate()
        {
            RetrieveDataDataContext trans = new RetrieveDataDataContext();

            return((from driver in trans.DRIVERs
                    where driver.DriverName == Session["driverName"].ToString()
                    select driver.CarPlateNo).FirstOrDefault());
        }
Esempio n. 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                lblPrice.Text     = (String)Session["price"];
                lblDuration.Text  = (String)Session["duration"];
                lblDepart.Text    = (String)Session["pickUpAddress"];
                lblArrive.Text    = (String)Session["destination"];
                lblName.Text      = (String)Session["Username"];
                lblDriver.Text    = (String)Session["driverName"];
                lblVehicleNo.Text = functionReturnPlate();
                string transactionTime = DateTime.Now.ToString();
                //Label1.Text = transactionTime;

                RetrieveDataDataContext trans = new RetrieveDataDataContext();



                TRANSACTION2 order = new TRANSACTION2
                {
                    price       = Session["price"].ToString(),
                    email       = Session["Email"].ToString(),
                    paymentTime = Convert.ToDateTime(transactionTime)
                };

                RESERVATION reserve = new RESERVATION
                {
                    ReservationStartTime = Convert.ToDateTime(Session["reserveTime"]),
                    ReservationEndTime   = Convert.ToDateTime(Session["reachTime"]),
                    PickUpLocation       = (String)Session["pickUpAddress"],
                    Destination          = (String)Session["destination"],
                    Email    = (String)Session["Email"],
                    DriverID = (String)Session["driver"],
                    Price    = (String)Session["price"]
                };

                trans.RESERVATIONs.InsertOnSubmit(reserve);
                trans.TRANSACTION2s.InsertOnSubmit(order);
                trans.SubmitChanges();
            }
        }