protected void btnAdd_Click(object sender, EventArgs e)
{
Validator v = new Validator();
if (!v.isPresent(txtFname))
{
lbl_error_message.Text = "Enter First Name!";
}
else if (!v.isPresent(txtLname))
{
lbl_error_message.Text = "Enter Last Name!";
}
else if (!v.isPresent(txtPhone))
{
lbl_error_message.Text = "Enter Contact No!";
}
else if (!v.isPresent(txtPickUpAddress))
{
lbl_error_message.Text = "Enter Pick Up Address!";
}
else if (!v.isPresent(txtDropAddress))
{
lbl_error_message.Text = "Enter Drop Address!";
}
else if (!v.isPresent(txtPickUpDate))
{
lbl_error_message.Text = "Enter Pick Up Date!";
}
else if (!v.isPresent(txtPickUpTime))
{
lbl_error_message.Text = "Enter Pick Up Time!";
}
else if (!v.isPresent(txtDropDate))
{
lbl_error_message.Text = "Enter Drop Date!";
}
else if (!v.isPresent(txtDropTime))
{
lbl_error_message.Text = "Enter Drop Time!";
}
else if (!v.isPresent(txtDistance))
{
lbl_error_message.Text = "Enter Distance!";
}
else
{
if (v.isPresent(txtEmail))
{
if (!v.isValidEmail(txtEmail.Text))
{
lbl_error_message.Text = "Enter Valid Email!";
}
}
if (!v.isValidPhoneNumber(txtPhone.Text))
{
lbl_error_message.Text = "Enter Valid Contact No!";
}
else
{
try
{
string pickUpAdd = txtPickUpAddress.Text;
string dropAdd = txtDropAddress.Text;
Decimal distance = Convert.ToDecimal(txtDistance.Text);
string dateStart = "";
string dateEnd = "";
dateStart = txtPickUpDate.Text + " " + txtPickUpTime.Text + ":00.000";
dateEnd = txtDropDate.Text + " " + txtDropTime.Text + ":00.000";
DateTime pickDateTime = Convert.ToDateTime(dateStart);
DateTime dropDateTime = Convert.ToDateTime(dateEnd);
string a = pickDateTime.ToString();
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('"+a+"')", true);
string branchLoc = dropDownList_branch.SelectedItem.Text;
int branchID = new Branch().GetBranchID(connString, branchLoc);
int clientID = new Client().GetMaxClientID(connString);
Decimal tot = 0;
if (v.isPresent(txtTot))
{
tot = Convert.ToDecimal(txtTot.Text);
}
Reservation resObj = new Reservation();
Employee em = new Employee();
bool canReserve = true;
int employeeID = 0;
em = resObj.DispatchDriver(connString, pickDateTime, dropDateTime, branchLoc);
if (em != null)
{
employeeID = em.employee_id;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Sorry,Reservation can not be done,becuase no drivers at the moment!')", true);
canReserve = false;
}
Cab c = new Cab();
c = resObj.DispatchCab(connString, pickDateTime, dropDateTime, dropDownList_vehicleType.SelectedItem.Text, branchLoc);
int cabID = 0;
if (c != null)
{
cabID = c.cab_id;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Sorry,Reservation can not be done,becuase no cabs at the moment!')", true);
canReserve = false;
}
if (canReserve == true)
{
//insert client details
string fName = txtFname.Text;
string lName = txtLname.Text;
string conNo = txtPhone.Text;
string email = "";
if (v.isPresent(txtEmail))
{
email = txtEmail.Text;
}
Client cl = new Client(fName, lName, conNo, email);
if (cl.AddClient(connString))
{
Reservation r = new Reservation(pickUpAdd, dropAdd, distance, pickDateTime, dropDateTime, employeeID, branchID, clientID, cabID, tot);
if (r.AddReservationAsClient(connString))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Inserted Successfully!')", true);
int maxReservationID = new Reservation().GetMaxReservationID(connString);
string message = "Your Reference ID:" + maxReservationID + "\n" + "Driver Name:" + em.first_name + " " + em.last_name + "\n" + "Driver Contact No:" + em.contact_number + "\n" + "Cab Registration No:" + c.cab_registration_no;
lbl_error_message.Text = message;
clear();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Sorry,Error Occurred!')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Sorry,Error Occurred!')", true);
}
}
}
catch (Exception ex)
{
lbl_error_message.Text = ex.ToString();
}
}
}
}