/* ************************************* * ********** Business Logic *********** * ************************************* */ /* ************************************* * ****** DDL Refresh Subroutines ******* * ************************************* */ private void DdlDriverRefresh(string DriverValue = null, int DriverIndex = 0) { DriversTableAdapter driverAdapter = new DriversTableAdapter(); DropDownList ddlDriver = (DropDownList)FvBookingView.FindControl("ddlDriver"); ddlDriver.DataSource = driverAdapter.GetDataBasics(); ddlDriver.DataValueField = "UserID"; ddlDriver.DataTextField = "Driver"; if (DriverValue == "" || DriverValue == null) { ddlDriver.SelectedIndex = DriverIndex; } else { ddlDriver.SelectedValue = DriverValue; } ddlDriver.DataBind(); if (IsBlacklisted()) { Response.Write("<script LANGUAGE='JavaScript' >alert('This Driver has been blacklisted for cancelled appointments. Bookings are now only available in person')</script>"); } }
private void PageDataRefresh() { string dID = txtSearchUserID.Text.Trim(); string dForename = txtSearchForename.Text.Trim(); string dSurname = txtSearchSurname.Text.Trim(); string dAddress1 = txtSearchAddress1.Text.Trim(); string dAddress2 = txtSearchAddress2.Text.Trim(); string dCity = txtSearchCity.Text.Trim(); string dCounty = txtSearchCounty.Text.Trim(); string dPostCode = txtSearchPostCode.Text.Trim(); // Force empty strings to nulls? // Validity checks bool valid_dDobStart = DateTime.TryParse(txtSearchDateOfBirth_Start.Text.Trim(), out DateTime dDobStart); bool valid_dDobEnd = DateTime.TryParse(txtSearchDateOfBirth_End.Text.Trim(), out DateTime dDobEnd); if (!valid_dDobStart) { dDobStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_dDobEnd) { dDobEnd = DateTime.MaxValue; } DriversTableAdapter driverAdapter = new DriversTableAdapter(); LvDriverList.DataSource = driverAdapter.GetDataByParameters(dID, dForename, dSurname, dDobStart, dDobEnd, dAddress1, dAddress2, dCity, dCounty, dPostCode); LvDriverList.DataBind(); }
protected void FvDriverView_CallInsertOrUpdate(string CallCommand) { // Code versions of all controls DropDownList ddlUser = (DropDownList)FvDriverView.FindControl("ddlUser"); TextBox txtForename = (TextBox)FvDriverView.FindControl("txtForename"); TextBox txtSurname = (TextBox)FvDriverView.FindControl("txtSurname"); TextBox txtDateOfBirth = (TextBox)FvDriverView.FindControl("txtDateOfBirth"); TextBox txtAddress1 = (TextBox)FvDriverView.FindControl("txtAddress1"); TextBox txtAddress2 = (TextBox)FvDriverView.FindControl("txtAddress2"); TextBox txtCity = (TextBox)FvDriverView.FindControl("txtCity"); TextBox txtCounty = (TextBox)FvDriverView.FindControl("txtCounty"); TextBox txtPostCode = (TextBox)FvDriverView.FindControl("txtPostCode"); // Assign all text properties of controls to variables // Or skip this and assign straight into INSERT/UPDATE parameters string currentUserID = ddlUser.SelectedValue; string forename = txtForename.Text; string surname = txtSurname.Text; string dateofbirth = txtDateOfBirth.Text; string address1 = txtAddress1.Text; string address2 = txtAddress2.Text; string city = txtCity.Text; string county = txtCounty.Text; string postCode = txtPostCode.Text; DriversTableAdapter DriverAdapter = new DriversTableAdapter(); try { if (CallCommand == "Update") { // Perform Update DriverAdapter.UpdateRecord(forename, surname, dateofbirth, address1, address2, city, county, postCode, currentUserID); //Response.Write("<script LANGUAGE='JavaScript' >alert('Record Edited')</script>"); ClientScript.RegisterStartupScript(GetType(), "text", "AlertTimeout();", true); // Return to Read Only mode FvDriverView.ChangeMode(FormViewMode.ReadOnly); PageDataRefresh(); } else if (CallCommand == "Insert") { //DriverAdapter.InsertRecord(currentUserID, forename, surname, dateofbirth, address1, address2, city, county, postCode); //Response.Write("<script LANGUAGE='JavaScript' >alert('Record Added')</script>"); //FvDriverView.ChangeMode(FormViewMode.ReadOnly); // Perform INSERT string newID = DriverAdapter.InsertAndReturnID(currentUserID, forename, surname, dateofbirth, address1, address2, city, county, postCode).ToString(); // Display message to user ClientScript.RegisterStartupScript(GetType(), "text", "AlertTimeout();", true); // Redirect User Response.Redirect("~/Management/DriverView.aspx?id=" + newID); } } catch (System.Exception ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('An ERROR occurred connecting to the database. " + ex.Message + "')</script>"); } }
private void PageDataRefresh() { string id = Request.QueryString["id"]; if (id == null || id == "0") { id = "0"; FvDriverView.ChangeMode(FormViewMode.Insert); } /* *********** Configure DAL *********** */ DriversTableAdapter driverAdapter = new DriversTableAdapter(); FvDriverView.DataSource = driverAdapter.GetDataById(id); FvDriverView.DataBind(); /* ****** Refresh Drop Down Lists ****** */ if (FvDriverView.CurrentMode == FormViewMode.Insert) { DdlUserRefresh(); } else if (FvDriverView.CurrentMode == FormViewMode.Edit || FvDriverView.CurrentMode == FormViewMode.ReadOnly) { DdlUserRefresh(id); } }
private bool IsDriver() { DriversTableAdapter driverAdapter = new DriversTableAdapter(); DataTable drivers = driverAdapter.GetDataById(User.Identity.GetUserId()); if (drivers.Rows.Count > 0) { return(true); } else { return(false); } }
private void PageDataRefresh() { string id = id = User.Identity.GetUserId(); if (id == null) { Response.Redirect("~/Account/Login.aspx"); } /* *********** Configure DAL *********** */ DriversTableAdapter driverAdapter = new DriversTableAdapter(); FvDriverView.DataSource = driverAdapter.GetDataById(id); FvDriverView.DataBind(); }
private void DdlVehicleRefresh(string VehicleValue = null) { VehiclesTableAdapter vehicleAdapter = new VehiclesTableAdapter(); DriversTableAdapter driverAdapter = new DriversTableAdapter(); // ************************************************ // Determine age from selected driver date of birth DropDownList ddlDriver = (DropDownList)FvBookingView.FindControl("ddlDriver"); DateTime dob = Convert.ToDateTime(driverAdapter.GetDataById(ddlDriver.SelectedValue)[0]["DateOfBirth"]); int age = DateTime.Now.Year - dob.Year; if (DateTime.Now.DayOfYear < dob.DayOfYear) { age = age - 1; } // ************************************************ // Determine date range for vehicle availability TextBox txtDateFrom = (TextBox)FvBookingView.FindControl("txtDateFrom"); TextBox txtDateDue = (TextBox)FvBookingView.FindControl("txtDateDue"); bool isDateFrom = DateTime.TryParse(txtDateFrom.Text, out DateTime dateFrom); bool isDateDue = DateTime.TryParse(txtDateDue.Text, out DateTime dateDue); //if (!isDateFrom) //{ // dateFrom = DateTime.Today; //} //if (!isDateDue) //{ // dateDue = DateTime.Today.AddDays(14); //} //Set end of dateDue dateDue = dateDue.AddMinutes(1439); // ************************************************ TextBox txtBookingID = (TextBox)FvBookingView.FindControl("txtBookingID"); int.TryParse(txtBookingID.Text, out int bookingid); DropDownList ddlVehicle = (DropDownList)FvBookingView.FindControl("ddlVehicle"); if (isDateFrom && isDateDue) { ddlVehicle.DataSource = vehicleAdapter.GetDataByAgeAndRange(Convert.ToByte(age), dateFrom, dateDue, bookingid); } else { ddlVehicle.DataSource = vehicleAdapter.GetDataAboveAge(Convert.ToByte(age)); } ddlVehicle.DataValueField = "ID"; ddlVehicle.DataTextField = "Details"; ddlVehicle.ClearSelection(); ddlVehicle.DataBind(); if ((VehicleValue == "" || VehicleValue == null) && ddlVehicle.Items.Count > 0) { VehicleValue = ddlVehicle.SelectedValue; ddlVehicle.SelectedValue = VehicleValue; ddlVehicle.SelectedIndex = 0; } // Revert DDL if previous SelectedValue in new list (must be done after a DataBind) if (ddlVehicle.Items.FindByValue(VehicleValue) != null) { ddlVehicle.SelectedValue = VehicleValue; } ddlVehicle.DataBind(); // if DailyRateCharged not set (but a value exists in DDL), set it initially TextBox txtDailyRate = (TextBox)FvBookingView.FindControl("txtDailyRateCharged"); if (txtDailyRate.Text == "" && ddlVehicle.SelectedIndex >= 0) { Decimal dailyRate = Convert.ToDecimal(vehicleAdapter.GetDataById(Convert.ToInt32(ddlVehicle.SelectedValue))[0]["DailyRate"].ToString()); txtDailyRate.Text = dailyRate.ToString("C"); } }