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();
}
