protected void btnAlreadyBookedCars_OnClick(object sender, EventArgs e)
 {
     if (Session["LoggedInUser"] != null)
     {
         if (ddlAirbus.SelectedValue != null)
         {
             CarRentalBL abl = new CarRentalBL();
             DataTable dt = (DataTable)Session["LoggedInUser"];
             gvBookedCars.DataSource = abl.GetBookedCars(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString(), int.Parse(ddlCars.SelectedValue), DateTime.Parse(txtCarBookDate.Text));
             gvBookedCars.DataBind();
         }
     }
 }
 protected void btnCarBookedSearch_OnClick(object sender, EventArgs e)
 {
     if (Session["LoggedInUser"] != null)
     {
         if (ddlAirbus.SelectedValue != null)
         {
             CarRentalBL cbl = new CarRentalBL();
             DataTable dt = (DataTable)Session["LoggedInUser"];
             ddlAvailableCars.DataSource = cbl.GetAvailableCars(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString(), int.Parse(ddlCars.SelectedValue), DateTime.Parse(txtCarBookDate.Text));
             ddlAvailableCars.DataValueField = "id";
             ddlAvailableCars.DataTextField = "car_number";
             ddlAvailableCars.DataBind();
         }
     }
 }
 private void CarRentalBinding()
 {
     if (Session["LoggedInUser"] != null)
     {
         CarRentalBL cbl = new CarRentalBL();
         DataTable dt = (DataTable)Session["LoggedInUser"];
         ddlCarRentals.DataSource = cbl.GetCarRentals(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString());
         ddlCarRentals.DataValueField = "car_rental_id";
         ddlCarRentals.DataTextField = "car_rental_name";
         ddlCarRentals.DataBind();
     }
 }
 private void CarBinding()
 {
     if (Session["LoggedInUser"] != null)
     {
         if (ddlCarRentals.Items.Count > 0 && ddlCarRentals.SelectedValue != null && ddlCarRentals.SelectedValue != "")
         {
             CarRentalBL cbl = new CarRentalBL();
             DataTable dt = (DataTable)Session["LoggedInUser"];
             ddlCars.DataSource = cbl.GetCars(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString(), int.Parse(ddlCarRentals.SelectedValue));
             ddlCars.DataValueField = "id";
             ddlCars.DataTextField = "car_number";
             ddlCars.DataBind();
         }
     }
 }
        protected void gvBookedCars_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int id = int.Parse(e.CommandArgument.ToString());
            if (e.CommandName.Equals("Update CarBId") && e.CommandArgument != null)
            {
                if (txtCarBookDate.Text.Length == 0)
                {
                    lblCarError.Text = "Please select date.";
                    return;
                }
                if (ddlAvailableCars.SelectedValue == null || ddlAvailableCars.SelectedValue == "")
                {
                    lblCarError.Text = "Please select Available Car.";
                    return;
                }
                if (ddlCars.SelectedValue == null || ddlCars.SelectedValue == "")
                {
                    lblCarError.Text = "Please select Car.";
                    return;
                }
                CarRentalBL abl = new CarRentalBL();
                DataTable dt = (DataTable)Session["LoggedInUser"];

                abl.UpdateSlot(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString(), id, int.Parse(ddlAvailableCars.SelectedValue), DateTime.Parse(txtCarBookDate.Text));
            }
            else if (e.CommandName.Equals("Delete CarBId") && e.CommandArgument != null)
            {
                CarRentalBL abl = new CarRentalBL();
                DataTable dt = (DataTable)Session["LoggedInUser"];
                abl.DeleteSlot(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString(), id);
            }
            else if (e.CommandName.Equals("Confirm") && e.CommandArgument != null)
            {
                if (txtCarAmountPaid.Text.Length == 0)
                {
                    lblCarError.Text = "Please enter amount.";
                    return;
                }
                int amt = 0;
                int.TryParse(txtCarAmountPaid.Text, out amt);
                if (amt == 0)
                {
                    lblCarError.Text = "Please enter correct amount.";
                    return;
                }
                CarRentalBL abl = new CarRentalBL();
                DataTable dt = (DataTable)Session["LoggedInUser"];
                abl.ConfirmSlot(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString(), id, Decimal.Parse(txtCarAmountPaid.Text));
            }
            btnAlreadyBookedCars_OnClick(null, null);
        }
 protected void btnCarBook_OnClick(object sender, EventArgs e)
 {
     if (Session["LoggedInUser"] != null)
     {
         if (ddlAirbus.SelectedValue != null)
         {
             CarRentalBL cbl = new CarRentalBL();
             DataTable dt = (DataTable)Session["LoggedInUser"];
             lblTicketNumber.Text = "Booking Refeence Number" + cbl.BookCar(dt.Rows[0]["car_user_name"].ToString(), dt.Rows[0]["car_password"].ToString(), int.Parse(ddlCars.SelectedValue), ddlCars.SelectedItem.Text.Split("-".ToCharArray()).GetValue(0).ToString(), DateTime.Parse(txtCarBookDate.Text), false, txtPassSSNCar.Text, dt.Rows[0]["car_user_name"].ToString()).ToString();
             btnCarBookedSearch_OnClick(null, null);
             btnAlreadyBookedCars_OnClick(null, null);
         }
     }
 }