protected void FvBookingView_ItemCommand(object sender, FormViewCommandEventArgs e) { switch (e.CommandName) { case "New": Response.Redirect("~/Management/BookingView.aspx?id=0"); break; case "Cancel": FvBookingView.ChangeMode(FormViewMode.ReadOnly); PageDataRefresh(); break; case "DeleteRecord": try { BookingsTableAdapter BookingAdapter = new BookingsTableAdapter(); TextBox txtBookingID = (TextBox)FvBookingView.FindControl("txtBookingID"); int bookingid = int.Parse(txtBookingID.Text); BookingAdapter.DeleteRecord(bookingid); } catch (System.Exception ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('An ERROR occurred connecting to the database. " + ex.Message + "')</script>"); } Response.Redirect("~/Management/BookingList.aspx"); break; case "ListView": Response.Redirect("~/Management/BookingList.aspx"); break; } }
private void PageDataRefresh() { string queryID = Request.QueryString["id"]; int id = 0; bool idValid = Int32.TryParse(queryID, out id); if (id == 0) { FvBookingView.ChangeMode(FormViewMode.Insert); } /* *********** Configure DAL *********** */ BookingsTableAdapter BookingAdapter = new BookingsTableAdapter(); FvBookingView.DataSource = BookingAdapter.GetDataById(id); FvBookingView.DataBind(); /* ****** Refresh Drop Down Lists ****** */ if (FvBookingView.CurrentMode == FormViewMode.Insert) { DdlDriverRefresh(); DdlVehicleRefresh(); } else if (FvBookingView.CurrentMode == FormViewMode.Edit || FvBookingView.CurrentMode == FormViewMode.ReadOnly) { string userID = DataBinder.Eval(FvBookingView.DataItem, "UserId").ToString(); string vehicleID = DataBinder.Eval(FvBookingView.DataItem, "VehicleId").ToString(); DdlDriverRefresh(userID); DdlVehicleRefresh(vehicleID); } DatePickerRefresh(); }
private void PageDataRefresh() { BookingsTableAdapter bookingAdapter = new BookingsTableAdapter(); LvBookingList.DataSource = bookingAdapter.GetDataByUserID(User.Identity.GetUserId()); LvBookingList.DataBind(); }
private bool IsRepeatCustomer() { BookingsTableAdapter BookingAdapter = new BookingsTableAdapter(); int.TryParse(BookingAdapter.GetCountOfComplete(User.Identity.GetUserId()).ToString(), out int recordsCancelled); if (recordsCancelled > 0) { return(true); } else { return(false); } }
private bool IsBlacklisted() { BookingsTableAdapter BookingAdapter = new BookingsTableAdapter(); int.TryParse(BookingAdapter.GetCountOfDidNotShow(User.Identity.GetUserId()).ToString(), out int recordsCancelled); if (recordsCancelled > 0) { return(true); } else { return(false); } }
private bool IsRepeatCustomer() { DropDownList ddlDriver = (DropDownList)FvBookingView.FindControl("ddlDriver"); BookingsTableAdapter BookingAdapter = new BookingsTableAdapter(); int.TryParse(BookingAdapter.GetCountOfComplete(ddlDriver.SelectedValue).ToString(), out int recordsCancelled); if (recordsCancelled > 0) { return(true); } else { return(false); } }
protected void FvBookingView_CallInsertOrUpdate(string CallCommand) { string queryID = Request.QueryString["id"]; int currentUserID = 0; bool idValid = Int32.TryParse(queryID, out currentUserID); if (currentUserID == 0) { FvBookingView.ChangeMode(FormViewMode.Insert); } // Code versions of all controls TextBox txtBookingID = (TextBox)FvBookingView.FindControl("txtBookingID"); DropDownList ddlDriver = (DropDownList)FvBookingView.FindControl("ddlDriver"); DropDownList ddlVehicle = (DropDownList)FvBookingView.FindControl("ddlVehicle"); TextBox txtDateFrom = (TextBox)FvBookingView.FindControl("txtDateFrom"); TextBox txtTimeFrom = (TextBox)FvBookingView.FindControl("txtTimeFrom"); TextBox txtDatePickup = (TextBox)FvBookingView.FindControl("txtDatePickup"); TextBox txtTimePickup = (TextBox)FvBookingView.FindControl("txtTimePickup"); TextBox txtDateDue = (TextBox)FvBookingView.FindControl("txtDateDue"); TextBox txtTimeDue = (TextBox)FvBookingView.FindControl("txtTimeDue"); TextBox txtDateReturn = (TextBox)FvBookingView.FindControl("txtDateReturn"); TextBox txtTimeReturn = (TextBox)FvBookingView.FindControl("txtTimeReturn"); DropDownList ddlStatus = (DropDownList)FvBookingView.FindControl("ddlStatus"); TextBox txtDailyRateCharged = (TextBox)FvBookingView.FindControl("txtDailyRateCharged"); // Assign all text properties of controls to variables int.TryParse(txtBookingID.Text, out int bookingid); string bUserID = ddlDriver.SelectedValue; bool valid_bVehicleId = int.TryParse(ddlVehicle.SelectedValue, out int bVehicleId); string bStatus = ddlStatus.SelectedValue; bool valid_bDailyRateCharged = Decimal.TryParse(txtDailyRateCharged.Text.Replace("£", String.Empty).Trim(), out Decimal bDailyRateCharged); if (!valid_bDailyRateCharged) { bDailyRateCharged = 999; } // Validity checks DateTime bDateTimeFrom = Convert.ToDateTime("1/1/1753 12:00:00 AM"); DateTime bDateTimeDue = bDateTimeFrom; DateTime bDateTimePickup = bDateTimeFrom; DateTime bDateTimeReturn = bDateTimeFrom; bool valid_bDateTimeFrom = DateTime.TryParse(txtDateFrom.Text.Trim(), out bDateTimeFrom); bool valid_bDateTimeDue = DateTime.TryParse(txtDateDue.Text.Trim(), out bDateTimeDue); bool valid_bDateTimePickup = DateTime.TryParse(txtDatePickup.Text.Trim(), out bDateTimePickup); bool valid_bDateTimeReturn = DateTime.TryParse(txtDateReturn.Text.Trim(), out bDateTimeReturn); if (valid_bDateTimeFrom && txtTimeFrom.Text != "") { TimeSpan timeFrom = TimeToTimeSpan(txtTimeFrom.Text); bDateTimeFrom += timeFrom; } else { valid_bDateTimeFrom = false; } if (valid_bDateTimeDue && txtTimeDue.Text != "") { TimeSpan timeDue = TimeToTimeSpan(txtTimeDue.Text); bDateTimeDue += timeDue; } else { valid_bDateTimeDue = false; } if (valid_bDateTimePickup && txtTimePickup.Text != "") { TimeSpan timePickup = TimeToTimeSpan(txtTimePickup.Text); bDateTimePickup += timePickup; } else { valid_bDateTimePickup = false; } if (valid_bDateTimeReturn && txtTimeReturn.Text != "") { TimeSpan timeReturn = TimeToTimeSpan(txtTimeReturn.Text); bDateTimeReturn += timeReturn; } else { valid_bDateTimeReturn = false; } BookingsTableAdapter BookingAdapter = new BookingsTableAdapter(); try { //Final Validity Check if (!(valid_bVehicleId && valid_bDateTimeFrom && valid_bDateTimeDue && valid_bDailyRateCharged)) { throw new System.MissingFieldException("Not all fields are complete"); } if (CallCommand == "Update") { // Perform Update (only update pickup and return dates if relevant) if (valid_bDateTimeFrom && valid_bDateTimeDue && valid_bDateTimePickup && valid_bDateTimeReturn) { BookingAdapter.UpdateRecord(bUserID, bVehicleId, bDateTimeFrom, bDateTimeDue, bDateTimePickup, bDateTimeReturn, bStatus, bDailyRateCharged, bookingid); } else if (valid_bDateTimeFrom && valid_bDateTimeDue && valid_bDateTimePickup) { BookingAdapter.UpdateRecord(bUserID, bVehicleId, bDateTimeFrom, bDateTimeDue, bDateTimePickup, null, bStatus, bDailyRateCharged, bookingid); } else { BookingAdapter.UpdateRecord(bUserID, bVehicleId, bDateTimeFrom, bDateTimeDue, null, null, bStatus, bDailyRateCharged, bookingid); } //Response.Write("<script LANGUAGE='JavaScript' >alert('Record Edited')</script>"); ClientScript.RegisterStartupScript(GetType(), "text", "AlertTimeout();", true); // Return to Read Only mode FvBookingView.ChangeMode(FormViewMode.ReadOnly); PageDataRefresh(); } else if (CallCommand == "Insert") { // Perform INSERT string newID; if (valid_bDateTimeFrom && valid_bDateTimeDue && valid_bDateTimePickup && valid_bDateTimeReturn) { newID = BookingAdapter.InsertAndReturnID(bUserID, bVehicleId, bDateTimeFrom, bDateTimeDue, bDateTimePickup, bDateTimeReturn, bStatus, bDailyRateCharged).ToString(); } else if (valid_bDateTimeFrom && valid_bDateTimeDue && valid_bDateTimePickup) { newID = BookingAdapter.InsertAndReturnID(bUserID, bVehicleId, bDateTimeFrom, bDateTimeDue, bDateTimePickup, null, bStatus, bDailyRateCharged).ToString(); } else { newID = BookingAdapter.InsertAndReturnID(bUserID, bVehicleId, bDateTimeFrom, bDateTimeDue, null, null, bStatus, bDailyRateCharged).ToString(); } // Display message to user ClientScript.RegisterStartupScript(GetType(), "text", "AlertTimeout();", true); // Redirect User Response.Redirect("~/Management/BookingView.aspx?id=" + newID); } } catch (System.MissingFieldException ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('An ERROR occured. " + ex.Message + "')</script>"); } catch (System.Exception ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('An ERROR occurred connecting to the database. " + ex.Message + "')</script>"); } }
private void PageDataRefresh() { string bUserName = txtSearchUsername.Text.Trim(); string bRegistrationPlate = txtSearchVehiclePlate.Text.Trim(); string bDescription = txtSearchVehicleType.Text.Trim(); string bStatus = txtSearchStatus.Text.Trim(); // Validity checks bool valid_bID = int.TryParse(txtSearchBookingID.Text.Trim(), out int bID); if (!valid_bID || bID < -1) { bID = -1; } bool valid_bDailyRateStart = Decimal.TryParse(txtSearchDailyRateChargedStart.Text.Trim(), out Decimal bDailyRateStart); bool valid_bDailyRateEnd = Decimal.TryParse(txtSearchDailyRateChargedEnd.Text.Trim(), out Decimal bDailyRateEnd); if (!valid_bDailyRateStart) { bDailyRateStart = 0; } if (!valid_bDailyRateEnd) { bDailyRateEnd = Int32.MaxValue; } bool valid_bDateTimeFromStart = DateTime.TryParse(txtSearchDateFromStart.Text.Trim(), out DateTime bDateTimeFromStart); bool valid_bDateTimeFromEnd = DateTime.TryParse(txtSetxtDateFromEnd.Text.Trim(), out DateTime bDateTimeFromEnd); bool valid_bDateTimeDueStart = DateTime.TryParse(txtSearchPickupStart.Text.Trim(), out DateTime bDateTimePickupStart); bool valid_bDateTimeDueEnd = DateTime.TryParse(txtSearchPickupEnd.Text.Trim(), out DateTime bDateTimePickupEnd); bool valid_bDateTimePickupStart = DateTime.TryParse(txtSearchDueStart.Text.Trim(), out DateTime bDateTimeDueStart); bool valid_bDateTimePickupEnd = DateTime.TryParse(txtSearchDueEnd.Text.Trim(), out DateTime bDateTimeDueEnd); bool valid_bDateTimeReturnStart = DateTime.TryParse(txtSearchReturnStart.Text.Trim(), out DateTime bDateTimeReturnStart); bool valid_bDateTimeReturnEnd = DateTime.TryParse(txtSearchReturnEnd.Text.Trim(), out DateTime bDateTimeReturnEnd); if (!valid_bDateTimeFromStart) { bDateTimeFromStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimeFromEnd) { bDateTimeFromEnd = DateTime.MaxValue; } if (!valid_bDateTimeDueStart) { bDateTimeDueStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimeDueEnd) { bDateTimeDueEnd = DateTime.MaxValue; } if (!valid_bDateTimePickupStart) { bDateTimePickupStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimePickupEnd) { bDateTimePickupEnd = DateTime.MaxValue; } if (!valid_bDateTimeReturnStart) { bDateTimeReturnStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimeReturnEnd) { bDateTimeReturnEnd = DateTime.MaxValue; } BookingsTableAdapter bookingAdapter = new BookingsTableAdapter(); LvBookingList.DataSource = bookingAdapter.GetDataByParameters(bID, "", -1, bDateTimeFromStart, bDateTimeFromEnd, bDateTimeDueStart, bDateTimeDueEnd, bDateTimePickupStart, bDateTimePickupEnd, bDateTimeReturnStart, bDateTimeReturnEnd, bStatus, bDailyRateStart, bDailyRateEnd); LvBookingList.DataBind(); }