// this will decline the trip
private void btn_Create_Click(object sender, EventArgs e)
{
//checks if textbox id null/blank
if (string.IsNullOrEmpty(cb_Trip.Text) || string.IsNullOrWhiteSpace(cb_Trip.Text))
{
MessageBox.Show("Please ensure all information is provided");
}
else
{
db.closeConnection();
db.DeclineTripRequest(TripID);
cb_Trip.ResetText();
tb_SenderName.ResetText();
tb_SenderSA.ResetText();
tb_SenderCity.ResetText();
tb_senderPC.ResetText();
tb_SendersProv.ResetText();
tb_SenderPhone.ResetText();
tb_RName.ResetText();
R_SAddress.ResetText();
tb_RTown.ResetText();
tb_RPostcode.ResetText();
tb_RProv.ResetText();
tb_RPhone.ResetText();
tb_RDesc.ResetText();
MessageBox.Show("Please inform customer that their trip has not been accepted");
}
}
// approve trip request
private void btn_Approve_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cb_Trip.Text) || string.IsNullOrWhiteSpace(cb_Trip.Text))
{
MessageBox.Show("Please ensure all information is provided");
}
else
{
db.closeConnection();
db.ChangeRequest(TripID);
cb_Trip.ResetText();
tb_SenderName.ResetText();
tb_SenderSA.ResetText();
tb_SenderCity.ResetText();
tb_senderPC.ResetText();
tb_SendersProv.ResetText();
tb_SenderPhone.ResetText();
tb_RName.ResetText();
R_SAddress.ResetText();
tb_RTown.ResetText();
tb_RPostcode.ResetText();
tb_RProv.ResetText();
tb_RPhone.ResetText();
tb_RDesc.ResetText();
}
}
private void R_SAddress_TextChanged(object sender, EventArgs e)
{
R_SAddress.MaxLength = 255;
badchar = inputMask(R_SAddress.Text);
if (badchar == "1")
{
R_SAddress.ResetText();
MessageBox.Show("Sorry but you have entered Street Address incorrectly . We do not comply to symbols ");
}
}
private void btn_Create_Click_1(object sender, EventArgs e)
{
//checks if textbox id null/blank
if (tb_SenderName.Text == "" || tb_SenderSA.Text == "" || tb_SenderCity.Text == "" || tb_senderPC.Text == "" || cb_SProv.SelectedItem.ToString() == "--Select Porovince--" || tb_SenderPhone.Text == "" ||
tb_RName.Text == "" || R_SAddress.Text == "" || tb_RTown.Text == "" || tb_RPostcode.Text == "" || cb_RProv.SelectedItem.ToString() == "--Select Porovince--" || tb_RPhone.Text == "" || tb_RDesc.Text == "")
{
MessageBox.Show("Please ensure all information is provided");
}
else
{
db.closeConnection();
// this will save the trip to the db
SqlCommand cmd = db.createTrip();
cmd.Parameters.Add("@S_Name", tb_SenderName.Text);
cmd.Parameters.Add("@S_StreetAddress", tb_SenderSA.Text);
cmd.Parameters.Add("@S_City", tb_SenderCity.Text);
cmd.Parameters.Add("@S_Postcode", tb_senderPC.Text);
cmd.Parameters.Add("@S_Province", cb_SProv.SelectedItem.ToString());
cmd.Parameters.Add("@S_Phone", tb_SenderPhone.Text);
cmd.Parameters.Add("@R_Name", tb_RName.Text);
cmd.Parameters.Add("@R_StreetAddress", R_SAddress.Text);
cmd.Parameters.Add("@R_City", tb_RTown.Text);
cmd.Parameters.Add("@R_Postcode", tb_RPostcode.Text);
cmd.Parameters.Add("@R_Province", cb_RProv.SelectedItem.ToString());
cmd.Parameters.Add("@R_Phone", tb_RPhone.Text);
cmd.Parameters.Add("@R_Description", tb_RDesc.Text);
cmd.ExecuteNonQuery();
//this will reset the textbox
tb_SenderName.ResetText();
tb_SenderSA.ResetText();
tb_SenderCity.ResetText();
tb_senderPC.ResetText();
cb_SProv.ResetText();
tb_SenderPhone.ResetText();
tb_RName.ResetText();
R_SAddress.ResetText();
tb_RTown.ResetText();
tb_RPostcode.ResetText();
cb_RProv.ResetText();
tb_RPhone.ResetText();
tb_RDesc.ResetText();
}
}
