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();
}
protected void FvBookingView_DataBound(object sender, EventArgs e)
{
if (FvBookingView.DataItemCount == 0)
{
FvBookingView.ChangeMode(FormViewMode.Insert);
}
else
{
FvBookingView.ChangeMode(FormViewMode.Edit);
}
}
protected void FvBookingView_ItemCommand(object sender, FormViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "New":
Response.Redirect("~/RegisteredUser/BookingView.aspx?id=0");
break;
case "Cancel":
FvBookingView.ChangeMode(FormViewMode.ReadOnly);
PageDataRefresh();
break;
case "ListView":
Response.Redirect("~/RegisteredUser/BookingList.aspx");
break;
}
}
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>");
}
}
protected void FvBookingView_ModeChanging(object sender, FormViewModeEventArgs e)
{
// Enable a FormView mode change (Read-Only, Edit/Update, New/Insert, Empty)
FvBookingView.ChangeMode((FormViewMode)e.NewMode);
PageDataRefresh();
}
