protected void btnAddBus_Click(object sender, EventArgs e) { // Assigning data Entered by user to Bussiness Object properties for Bus Details. BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); bussinessObject.BusNumber = TxtBusNumber.Text; bussinessObject.StartPoint = TxtStratingPoint.Text; bussinessObject.Destination = TxtDestination.Text; bussinessObject.Capacity = int.Parse(TxtCapacity.Text); // since Capacity is int-type, user string is parsed back to int. bussinessObject.DepartureTime = TxtDepartureTime.Text; bussinessObject.ArrivalTime = TxtArrivalTime.Text; bussinessObject.CompanyName = TxtCompanyName.Text; bussinessObject.BusType = ListBusType.SelectedItem.Text; BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); int isProcessSucessful = bussinessLogicObject.AddBus(bussinessObject); // Addbus() method from Bussiness logic layer called and return value stored in variable isProcessSuccessful. if (isProcessSucessful == 1) // If return value is 1, display "Bus added Successfully." else display apprpriate error messages. { Response.Write("Bus added Successfully."); } else { Response.Write("Cannot add bus details,please try again!"); // This could also be an actual exception/error message. } }
protected void btnAddBus_Click(object sender, EventArgs e) { if (txtPickupLocation.Text == "") // TextBox validation. Make sure user enters a Pickup Location. { lblPickupLocation.Text = "*Please enter a Pickup Location"; txtPickupLocation.Focus(); } else { lblPickupLocation.Text = ""; BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); bussinessObject.PickupId = txtPickupId.Text; // Pass pickup-Id from front-end to PickupId Property in BussinessObjects. bussinessObject.PickupLocation = txtPickupLocation.Text; // Passing user entered pickup Location PickupLocation Property in BussinessObjects. int isBusPickupInfoAdded = bussinessLogicObject.AddBusPickupPointInfo(bussinessObject); // Send values to Logic layer. From there to DataAccess layer and from there to Database. Return 1 if process succeeded. if (isBusPickupInfoAdded == 1) { lblMessage.Text = txtPickupLocation.Text + " is added to Pickup Points successfully."; // Show message. txtPickupLocation.Text = ""; // Clear TextBox AutoGenPickupIDs(); // Generate new Pickup Id. txtPickupLocation.Focus(); // Focus cursor to Pickup Location to enter Another location. } else { lblMessage.Text = "Failed to add Pickup point info. Please try again"; } } }
protected void gridViewDestinationPoints_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.ToString() == "cmdDelete") { int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); GridViewRow row = (GridViewRow)gridViewDestinationPoints.Rows[rowIndex]; Label destID = (Label)row.FindControl("lblDestinationId"); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); bussinessObject.DestinationId = destID.Text; BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); int isDestinationDeleted = bussinessLogicObject.DelDestinationPoint(bussinessObject); if (isDestinationDeleted == 1) { Response.Write("Destination point deleted successfully"); GetDestinationInfo(); } else { Response.Write("Failed to delete the Destination Point"); } } else if (e.CommandName.ToString() == "cmdUpdate") { int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); GridViewRow row = (GridViewRow)gridViewDestinationPoints.Rows[rowIndex]; Label destID = (Label)row.FindControl("lblDestinationId"); Label destLoc = (Label)row.FindControl("lblDestinationLocation"); BussinessObjectsClass bussinessLogicObject = new BussinessObjectsClass(); bussinessLogicObject.DestinationId = destID.Text; bussinessLogicObject.DestinationLocation = destLoc.Text; Session["d_id"] = destID.Text; Session["d_station"] = destLoc.Text; Response.Redirect("UpdateDestinationPoints.aspx"); } }
public void AutoGenDestinationIDs() { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); string DestinationID = bussinessLogicObject.AutoGenDestinationIDs(); txtDestinationID.Text = DestinationID; }
private void AutoGenPickupIDs() // Pass auto generated values to PickupID TextBox. { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); string pickupId = bussinessLogicObject.AutoGenPickupIDs(); txtPickupId.Text = pickupId; }
protected void btnAdd_Click(object sender, EventArgs e) { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); foreach (GridViewRow row in gridDestinationPoints.Rows) { CheckBox cb = (CheckBox)row.FindControl("checkDestination"); if (cb.Checked) { Label destID = (Label)row.FindControl("lblDestinationID"); bussinessObject.DestinationId = destID.Text.ToString(); string selectedBus = ddlSelectBus.SelectedItem.ToString(); string[] busInfo = selectedBus.Split('/'); // Split the string to extract BusNumber from the String. bussinessObject.BusNumber = busInfo[0].ToString(); int isProcessSuccessfull = bussinessLogicObject.AddBusSpecificDestinationPoint(bussinessObject); // Add values to BusDestination table if (isProcessSuccessfull == 1) { lblMessage.Text = "Destination Points are added Successfully for " + busInfo[0].ToString(); } else { lblMessage.Text = "Failed to add Bus Destination Points. Please try again."; } } } }
//Displays all the Destination Points. private void GetDestinationInfo() { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); DataSet ds = bussinessLogicObject.ViewDestinationPoints(); gridDestinationPoints.DataSource = ds; gridDestinationPoints.DataBind(); }
private void GetBusDetails() // Gets the data from BussinessLogic Layer and binds it with Grid view control(gridBusDetails). { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); DataSet ds = bussinessLogicObject.ViewBus(); // Call view Bus function from Bussiness logic Layer. gridBusDetails.DataSource = ds; // Define the above created dataset as DataSource of the gridBusDetails. gridBusDetails.DataBind(); // Bind data. }
private void BindPickupPoints() // Shows all PickupPoints in Select Pickup Point dropdown-list. { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); // Using same method used for Admin to view Pickup Points. DataSet ds = bussinessLogicObject.ViewPickupPoints(); // Since return type of ViewPickupPoints() method is DataSet, save results in DataSet ds. ddlSelectPickupPoint.DataSource = ds; // Set DataSource for Select PickupPoint List as ds. ddlSelectPickupPoint.DataTextField = "pp_station"; // Show Pickup Location in the list. ddlSelectPickupPoint.DataValueField = "pp_id"; // Save Pickup Id as value. This is used later to add values in BusPickupPoint table. ddlSelectPickupPoint.DataBind(); // DataBind }
protected void userLogin_Authenticate(object sender, AuthenticateEventArgs e) //Login authentication Event. Fired when user clicks loogin { BussinessLogicClass bussinessLogic = new BussinessLogicClass(); // Business logic class object. This allows Presentation Layer to interact with Bussiness logic layer. BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); // Bussiness Objects class object. This allows Presentation Layer to interact with Bussiness Objects layer. bussinessObject.UserName = userLogin.UserName; // Accessing properties defined in Bussiness Object class for username and password. bussinessObject.Password = userLogin.Password; int loginAttempt = bussinessLogic.AdminLogin(bussinessObject); // Call AdminLogin() method fo admin login if (loginAttempt == 1) // Redirect to AdminHime.aspx page if return value = 1. { Response.Redirect("AdminHome.aspx"); } else { userLogin.FailureText = "Either the username or password is incorrect."; } }
private void BindBusInfo() // Shows BusInfo in Select Bus dropdown-list. { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); SqlDataReader dr = bussinessLogicObject.BusInfoForBusPickupPoint(); // Get data reader from Bussiness Logic Layer. if (dr.HasRows) // if the table contain row(s) { while (dr.Read()) { //get BusNumber, StartingPoint and Destination from each row. string busNumber = dr[0].ToString(); string stratingPoint = dr[1].ToString(); string destination = dr[2].ToString(); string info = busNumber + " / " + stratingPoint + " to " + destination; // Show info in form of <busNumber> / <stratingPoint> to <destination> ddlSelectBus.Items.Add(info); } } }
protected void gridBusDetails_RowUpdating(object sender, GridViewUpdateEventArgs e) { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); GridViewRow row = (GridViewRow)gridBusDetails.Rows[e.RowIndex]; // Get the number of rows in the gridview and the index where user clicked edit. TextBox bNum = (TextBox)row.FindControl("txt_bNumber"); // Find the control in which the user has edited the value. bussinessObject.BusNumber = bNum.Text; // Assign the properties in the business-object layer with te user entered values. TextBox sPoint = (TextBox)row.FindControl("txt_sPoint"); bussinessObject.StartPoint = sPoint.Text; TextBox dest = (TextBox)row.FindControl("txt_dest"); bussinessObject.Destination = dest.Text; TextBox cap = (TextBox)row.FindControl("txt_cap"); bussinessObject.Capacity = int.Parse(cap.Text); TextBox dTime = (TextBox)row.FindControl("txt_dTime"); bussinessObject.DepartureTime = dTime.Text; TextBox aTime = (TextBox)row.FindControl("txt_aTime"); bussinessObject.ArrivalTime = aTime.Text; TextBox cName = (TextBox)row.FindControl("txt_cName"); bussinessObject.CompanyName = cName.Text; TextBox bType = (TextBox)row.FindControl("txt_bType"); bussinessObject.BusType = bType.Text; int isEditProcessSuccessfull = bussinessLogicObject.EditBus(bussinessObject); // Passing above values to Edit bus function. if (isEditProcessSuccessfull == 1) // If query execution returns 1, update records and switch back to static view with updated data. { Response.Write("Bus details Edited Successfully"); gridBusDetails.EditIndex = -1; GetBusDetails(); } else { Response.Write("Unable to Edit bus details.Please try again"); GetBusDetails(); } }
protected void gridBusDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); string busNumber = gridBusDetails.DataKeys[e.RowIndex].Value.ToString(); // getting bus number bussinessObject.BusNumber = busNumber; int isDeleteSuccessful = bussinessLogicObject.DeleteBus(bussinessObject); // passing the bus number via bussinessObject's object. if (isDeleteSuccessful == 1) // if deletes successfull { Response.Write("Bus entry is Deleted"); // Show user message GetBusDetails(); // Update gridBusDetails on page for user to see. } else { Response.Write("Could not delete Bus entry. Please try again"); // else show error message. } }
protected void gridViewPickupPoints_RowDeleting(object sender, GridViewDeleteEventArgs e) { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); string pickupID = gridViewPickupPoints.DataKeys[e.RowIndex].Value.ToString(); // getting pickup ID bussinessObject.PickupId = pickupID; int isDeleteSuccessful = bussinessLogicObject.DelPickupPoint(bussinessObject); // passing the pickup ID via bussinessObject's object. if (isDeleteSuccessful == 1) // if deletetion successful { Response.Write("PickupPoint entry is Deleted"); GetPickupPointDetails(); // Update gridViewPickupPoints on page for user to see. } else { Response.Write("Could not delete PickupPoint entry. Please try again"); } }
protected void btnAdd_Click(object sender, EventArgs e) { BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); bussinessObject.PickupId = ddlSelectPickupPoint.SelectedValue.ToString(); // Get PickupId(pp_id) from the list. string selectedBus = ddlSelectBus.SelectedItem.ToString(); // Get Selected Bus from the list. string[] busInfo = selectedBus.Split('/'); // Split the string to extract BusNumber from the String. bussinessObject.BusNumber = busInfo[0].ToString(); int isProcessSuccessfull = bussinessLogicObject.AddBusSpecificPickupPoint(bussinessObject); // Add values to table if (isProcessSuccessfull == 1) { Response.Write("Bus pickup point added Successfully"); } else { Response.Write("Could not add Bus Pickup Point. Please try again"); } }
//Bind the Destination Points when user selects Bus from first DropDownList. private void BindDestinationsPointsBasedOnBusNumber() { //Get Bus Number when Admin Selects bus from Select Bus DropDown List. BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); string selectedBus = ddlBusNumber.SelectedItem.ToString(); string[] busInfo = selectedBus.Split('/'); bussinessObject.BusNumber = busInfo[0]; ViewState["BusNumber"] = bussinessObject.BusNumber; // Save BusNumber for later use when Fare info is added to Fare table in DataBase // Get Destination associated with BusNumber that Admin Selected. DataSet ds = bussinessLogicObject.DestinationPointsBasedOnBusNumber(bussinessObject); ddlFromPlace.DataSource = ds; ddlFromPlace.DataTextField = "d_station"; // Text to show when Data is Binded based on Bus Number. ddlFromPlace.DataValueField = "d_id"; // Value that goes into Database when Admin press Add on Fare Page ddlFromPlace.DataBind(); ddlToPlace.DataSource = ds; ddlToPlace.DataTextField = "d_station"; ddlToPlace.DataValueField = "d_id"; ddlToPlace.DataBind(); }
protected void btnAddFare_Click(object sender, EventArgs e) { //All Textbox Validations. if (txtStartTime.Text == "") { lblStartTime.Text = "Please Enter Starting Time"; } if (txtArrivalTime.Text == "") { lblArrivalTime.Text = "Please Enter Arrival Time"; } if (txtFare.Text == "") { lblFare.Text = "Please enter Fare"; } BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); // Collecting all Data Entered by Admin. NOTE: In Fare table we are Entering ID's not Name of place. bussinessObject.BusNumber = ViewState["BusNumber"].ToString(); bussinessObject.FromDepartureID = ddlFromPlace.SelectedValue.ToString(); bussinessObject.ToDestinationID = ddlToPlace.SelectedValue.ToString(); bussinessObject.FromDepartureTime = txtStartTime.Text.ToString(); bussinessObject.ToDepartureTime = txtArrivalTime.Text.ToString(); bussinessObject.Fare = Convert.ToDouble(txtFare.Text.ToString()); int isFareAddedSuccessfully = bussinessLogicObject.AddFare(bussinessObject); if (isFareAddedSuccessfully == 1) { lblMessage.Text = "Fare added for Bus Number: " + ViewState["BusNumber"].ToString() + " from " + ddlFromPlace.SelectedItem.ToString() + " to " + ddlToPlace.SelectedItem.ToString() + " successfully"; } else { lblMessage.Text = "Failed to add Fare info. Please try Again"; } }
protected void btnUpdate_Click(object sender, EventArgs e) { if (txtDestinationLocation.Text == "") { lblDestinationLocation.Text = "*Please Enter a Destinatoin Location"; } else { lblDestinationLocation.Text = "*"; BussinessObjectsClass bussinessObject = new BussinessObjectsClass(); bussinessObject.DestinationId = txtDestinationID.Text; bussinessObject.DestinationLocation = txtDestinationLocation.Text; BussinessLogicClass bussinessLogicObject = new BussinessLogicClass(); int isLocationUpdated = bussinessLogicObject.UpdateDestinationPoint(bussinessObject); if (isLocationUpdated == 1) { lblMessage.Text = "Destination Lcation Updated Successfully. Click Back to go back to View Page"; } else { Response.Write("Failed to update Destination Location. Please try again"); } } }