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.";
}
}
}
}
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 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");
}
}
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";
}
}
}
DataAccessClass dataAccessObject = new DataAccessClass(); // Global Data-Access Object. So that it Bussiness Logic layer can interact with DataAccess layer.
#region AdminLoginMethod
public int AdminLogin(BussinessObjectsClass bussinessObject)
{
if (bussinessObject.UserName == "Admin" && bussinessObject.Password == "123") // Hardcoded Admin login Credentials. This is bad practice. I'll find a better way later.
{
return(1);
}
else
{
return(0);
}
}
public int DeleteDestinationPoints(BussinessObjectsClass bussinessObject)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_deleteDestinationPoint", conn);
cmd.CommandType = CommandType.StoredProcedure; // Stored Procedure to delete Destination Point details by DestinationId(d_id)
cmd.Parameters.AddWithValue("@d_id", bussinessObject.DestinationId);
int isquerySuccessful = cmd.ExecuteNonQuery();
conn.Close();
return(isquerySuccessful);
}
public int UpdateDestinationPoints(BussinessObjectsClass bussinessObject)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_updateDestinationPoints", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@d_id", bussinessObject.DestinationId);
cmd.Parameters.AddWithValue("@d_station", bussinessObject.DestinationLocation);
int isQuerySuccessfull = cmd.ExecuteNonQuery();
return(isQuerySuccessfull);
}
public int DeleteBus(BussinessObjectsClass bussinessObject)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_deleteBus", conn);
cmd.CommandType = CommandType.StoredProcedure; // Stored Procedure to delete Bus details by BusNumber
cmd.Parameters.AddWithValue("@BusNumber", bussinessObject.BusNumber);
int isquerySuccessful = cmd.ExecuteNonQuery(); // returns return value of ExecuteNonQuery() method i.e 1 for success and 0 for failure.
conn.Close();
return(isquerySuccessful);
}
public int AddBusSpecificDestinationPoints(BussinessObjectsClass bussinessObject)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_addBusSpecificDestinationPoints", conn); // proc_addBusSpecificDestinationPoints is a stored procedure that updates values in BusDestination table.
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusNumber", bussinessObject.BusNumber);
cmd.Parameters.AddWithValue("@d_id", bussinessObject.DestinationId);
int isquerySuccessful = cmd.ExecuteNonQuery();
conn.Close();
return(isquerySuccessful);
}
public int AddBusDestinationInfo(BussinessObjectsClass bussinessObject)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_addBusDestinationInfo", conn); // proc_addBusDestinationInfo is a stored procedure that add Destination Id and Locations in Bus table.
cmd.CommandType = CommandType.StoredProcedure;
// Assigning Data to Bus Details properties.
cmd.Parameters.AddWithValue("@d_id", bussinessObject.DestinationId);
cmd.Parameters.AddWithValue("@d_station", bussinessObject.DestinationLocation);
int isquerySuccessful = cmd.ExecuteNonQuery();
conn.Close();
return(isquerySuccessful);
}
public DataSet DestinationPointsBasedOnBusNumber(BussinessObjectsClass bussinessObject)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_getDestinationPointsBasedOnBusNumber", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd); // DataADapter object
cmd.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet(); // DataSet object to store data locally.
cmd.Parameters.AddWithValue("@BusNumber", bussinessObject.BusNumber);
da.Fill(ds); // Fill data from DataAdapter DataSet object.
conn.Close();
return(ds); // return DataSet.
}
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.";
}
}
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 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 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");
}
}
public int AddFare(BussinessObjectsClass bussinessObject)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_addFare", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusNumber", bussinessObject.BusNumber);
cmd.Parameters.AddWithValue("@Start_id", bussinessObject.FromDepartureID);
cmd.Parameters.AddWithValue("@From_depTime", bussinessObject.FromDepartureTime);
cmd.Parameters.AddWithValue("@Destination_id", bussinessObject.ToDestinationID);
cmd.Parameters.AddWithValue("@To_depTime", bussinessObject.ToDepartureTime);
cmd.Parameters.AddWithValue("@Fare", bussinessObject.Fare);
int isquerySuccessful = cmd.ExecuteNonQuery();
conn.Close();
return(isquerySuccessful);
}
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");
}
}
public int EditBusDetails(BussinessObjectsClass bussinessObject) // Edit is similar to add, insted of "insert" we have to "update" the values.
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn_str"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("proc_editBus", conn); // proc_EditBus is a stored procedure that updates values in Bus table.
cmd.CommandType = CommandType.StoredProcedure;
// Assigning Data to Bus Details properties.
cmd.Parameters.AddWithValue("@BusNumber", bussinessObject.BusNumber);
cmd.Parameters.AddWithValue("@StartPoint", bussinessObject.StartPoint);
cmd.Parameters.AddWithValue("@Destination", bussinessObject.Destination);
cmd.Parameters.AddWithValue("@capacity", bussinessObject.Capacity);
cmd.Parameters.AddWithValue("@DepartureTime", bussinessObject.DepartureTime);
cmd.Parameters.AddWithValue("@ArrivalTime", bussinessObject.ArrivalTime);
cmd.Parameters.AddWithValue("@CompanyName", bussinessObject.CompanyName);
cmd.Parameters.AddWithValue("@BusType", bussinessObject.BusType);
int isquerySuccessful = cmd.ExecuteNonQuery();
conn.Close();
return(isquerySuccessful);
}
//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");
}
}
}
public int AddBusSpecificPickupPoint(BussinessObjectsClass bussinessObject)
{
int isBusPickupInfoAddeddSuccessfully = dataAccessObject.AddBusSpecificPickupPoint(bussinessObject);
return(isBusPickupInfoAddeddSuccessfully);
}
public int AddBusSpecificDestinationPoint(BussinessObjectsClass bussinessObject)
{
int isBusDestinatuionAddeddSuccessfully = dataAccessObject.AddBusSpecificDestinationPoints(bussinessObject);
return(isBusDestinatuionAddeddSuccessfully);
}
public DataSet DestinationPointsBasedOnBusNumber(BussinessObjectsClass bussinessObject)
{
DataSet ds = dataAccessObject.DestinationPointsBasedOnBusNumber(bussinessObject); // Store DataSet from DestinationPointsBasedOnBusNumber() method into another DatSet object.
return(ds); // return DataSet.
}
public int AddFare(BussinessObjectsClass bussinessObject)
{
int isFareAdded = dataAccessObject.AddFare(bussinessObject);
return(isFareAdded);
}
public int AddBus(BussinessObjectsClass bussinessObject)
{
int isQuerySuccessful = dataAccessObject.AddBus(bussinessObject); // Addbus() method from DataAccess layer called and return value stored in isQuerySuccessful variable.
return(isQuerySuccessful);
}
public int DeleteBus(BussinessObjectsClass bussinessObject)
{
int isRecordDeleted = dataAccessObject.DeleteBus(bussinessObject); // DeleteBus() method from Data-Access layer
return(isRecordDeleted);
}
public int EditBus(BussinessObjectsClass bussinessObject)
{
int isRecordEdited = dataAccessObject.EditBusDetails(bussinessObject); // EditBusDetails() method from Data-Access layer
return(isRecordEdited); // return this to presentation layer
}
public int AddBusPickupPointInfo(BussinessObjectsClass bussinessObject)
{
int isBusPickupInfoAddedSuccessfully = dataAccessObject.AddBusPickupInfo(bussinessObject); // Calling AddBusPickupInfo() from Data-Access layer.
return(isBusPickupInfoAddedSuccessfully);
}
public int UpdateDestinationPoint(BussinessObjectsClass bussinessObject)
{
int isRecordUpdated = dataAccessObject.UpdateDestinationPoints(bussinessObject);
return(isRecordUpdated);
}
