private void button2_Click(object sender, EventArgs e)
{
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string username = textBox1.Text;
string password = textBox2.Text;
string LoginQuery = "SELECT count(1) FROM Client WHERE Username = '******' AND Password = HASHBYTES('SHA1', '" + password + "')";
SqlDataAdapter sda = new SqlDataAdapter(LoginQuery, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
MessageBox.Show("Login successful!");
Constants.loginClientUser = username;
this.Hide();
new Form2().Show();
}
else
{
MessageBox.Show("Login unsuccessful! Incorrect username and/or password.");
}
}
}
private void button6_Click(object sender, EventArgs e)
{
// this will calculate the payment and display in the payment box
//int oneWayFee;
oneWayFee = 0;
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
if (comboBox2.SelectedItem != null)
{
transportProviderName = comboBox2.SelectedItem.ToString();
Console.WriteLine(transportProviderName);
string getOneWayFee = "select top 1 One_Way_Payment from Transport_Provider where Name = '" + transportProviderName + "' order by One_Way_Payment desc ";
SqlCommand cm3 = new SqlCommand(getOneWayFee, conn);
cm3.CommandText = getOneWayFee;
SqlDataReader drd3 = cm3.ExecuteReader();
while (drd3.Read())
{
Console.WriteLine(drd3["One_Way_Payment"]);
oneWayFee = float.Parse(drd3["One_Way_Payment"].ToString());
}
if (radioButton1.Checked == true) //oneway
{
if (radioButton4.Checked == true) //wheelchair
{
oneWayFee = oneWayFee + 4;
}
else if (radioButton3.Checked == true) //ambulatory
{
oneWayFee = oneWayFee + 8;
}
}
else if (radioButton2.Checked == true) //roundtrip
{
oneWayFee = oneWayFee * 2;
if (radioButton4.Checked == true) //wheelchair
{
oneWayFee = oneWayFee + 4;
}
else if (radioButton3.Checked == true) //ambulatory
{
oneWayFee = oneWayFee + 8;
}
}
}
conn.Close();
}
textBox8.Text = oneWayFee.ToString();
oneWayFee = 0;
}
public static string returnClientID()
{
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string findClientID = "SELECT idClient FROM Client WHERE Username = '******'";
SqlCommand searchcmd = new SqlCommand(findClientID, conn);
searchcmd.CommandText = findClientID;
SqlDataReader data_set = searchcmd.ExecuteReader();
while (data_set.Read())
{
clientID = data_set["idClient"].ToString();
}
conn.Close();
}
return(clientID);
}
public Form4()
{
InitializeComponent();
dateTimePicker2.CustomFormat = " HH' : 'mm ";
dateTimePicker2.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "MM/dd/yyyy";
dateTimePicker3.CustomFormat = " HH' : 'mm ";
dateTimePicker3.Format = DateTimePickerFormat.Custom;
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string SelectAll = "SELECT distinct Name FROM Passenger";
SqlCommand cm = new SqlCommand(SelectAll, conn);
cm.CommandText = SelectAll;
SqlDataReader drd = cm.ExecuteReader();
while (drd.Read())
{
comboBox1.Items.Add(drd["Name"].ToString());
}
conn.Close();
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string SelectTransport = "SELECT distinct Name FROM Transport_Provider";
SqlCommand cm2 = new SqlCommand(SelectTransport, conn);
cm2.CommandText = SelectTransport;
SqlDataReader drd2 = cm2.ExecuteReader();
while (drd2.Read())
{
comboBox2.Items.Add(drd2["Name"].ToString());
}
}
}
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
Constants.returnClientID();
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string name = textBox2.Text;
string phoneNum = textBox4.Text;
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(phoneNum))
{
MessageBox.Show("ERROR! Please enter valid Name and Phone Number.");
}
else
{
string query = "INSERT INTO Passenger VALUES (" + Constants.clientID + ", '" + name + "', '" + phoneNum + "')";
SqlCommand cm = new SqlCommand(query, conn);
cm.ExecuteNonQuery();
MessageBox.Show("Passenger added!");
cm.Dispose();
conn.Close();
}
}
}
public Form6()
{
InitializeComponent();
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string SelectAll = "SELECT * FROM Transport_Provider";
SqlCommand cm = new SqlCommand(SelectAll, conn);
cm.CommandText = SelectAll;
SqlDataReader drd = cm.ExecuteReader();
while (drd.Read())
{
comboBox1.Items.Add(drd["Name"].ToString());
comboBox3.Items.Add(drd["One_Way_Payment"].ToString());
comboBox4.Items.Add(drd["Return_Payment"].ToString());
}
drd.Close();
}
}
public Form5()
{
InitializeComponent();
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string SelectAll = "SELECT * FROM Passenger";
SqlCommand cm = new SqlCommand(SelectAll, conn);
cm.CommandText = SelectAll;
SqlDataReader drd = cm.ExecuteReader();
while (drd.Read())
{
comboBox1.Items.Add(drd["Name"].ToString());
comboBox3.Items.Add(drd["Phone_Number"].ToString());
}
drd.Close();
}
//con.Close();
}
private void button7_Click(object sender, EventArgs e)
{
// Add Order to OrderDetails
if (DateTime.Compare(dateTimePicker2.Value, dateTimePicker3.Value) == 0)
{
MessageBox.Show("Please enter valid Pickup Time.");
}
//Constants.returnClientID();
conn = DBConnection.OpenConnection();
if (conn.State == System.Data.ConnectionState.Open)
{
string passengerName = comboBox1.Text;
string transportProvider = comboBox2.Text;
string orderFor = dateTimePicker1.Value.ToString();
string pickupAddress = textBox2.Text;
string dropoffAddress = textBox3.Text;
if (string.IsNullOrEmpty(passengerName))
{
MessageBox.Show("ERROR! Please select valid Passenger Name.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
if (string.IsNullOrEmpty(transportProvider))
{
MessageBox.Show("ERROR! Please select valid Transport Provider.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
if (string.IsNullOrEmpty(orderFor))
{
MessageBox.Show("ERROR! Please select valid Date.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
if (string.IsNullOrEmpty(pickupAddress))
{
MessageBox.Show("ERROR! Please select valid Pickup Address.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
{
if (string.IsNullOrEmpty(isOneWay))
{
MessageBox.Show("Error! Please select valid Trip Type.");
isReadyToAdd = false;
}
else if (isOneWay == "Round Trip")
{
if (string.IsNullOrEmpty(dropoffAddress))
{
MessageBox.Show("ERROR! Please select valid Dropoff Address.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
if (string.IsNullOrEmpty(returnTime))
{
MessageBox.Show("Error! Please select valid Return Time.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
}
else
{
isReadyToAdd = true;
}
}
if (string.IsNullOrEmpty(type))
{
MessageBox.Show("Error! Please select valid Vehicle Type.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
if (string.IsNullOrEmpty(textBox8.Text.ToString()))
{
MessageBox.Show("Please CALCULATE total payment amount.");
isReadyToAdd = false;
}
else
{
isReadyToAdd = true;
}
if (isReadyToAdd && isOneWay == "Round Trip")
{
string query = "INSERT INTO OrderDetails(Transport_Provider_idTransport_Provider, Passenger_idPassenger, WC_Ambulatory, OrderDate, TotalPayment, isOne_Way, Date_for_Order, Pickup_Time, Pickup_Address, Drop_off_Address, ReturnTime) VALUES ((SELECT distinct idTransport_Provider from Transport_Provider WHERE Name = '" + transportProvider + "'), (SELECT idPassenger from Passenger WHERE Name = '" + passengerName + "'),'" + type + "', (SELECT GETDATE()), '" + totalAmount + "','" + isOneWay + "','" + orderFor + "','" + pickUpTime + "','" + pickupAddress + "','" + dropoffAddress + "','" + returnTime + "' )";
SqlCommand cm = new SqlCommand(query, conn);
cm.ExecuteNonQuery();
MessageBox.Show("Order successfully added!");
cm.Dispose();
conn.Close();
}
else if (isReadyToAdd && isOneWay == "One Way")
{
string query = "INSERT INTO OrderDetails(Transport_Provider_idTransport_Provider, Passenger_idPassenger, WC_Ambulatory, OrderDate, TotalPayment, isOne_Way, Date_for_Order, Pickup_Time, Pickup_Address) VALUES ((SELECT idTransport_Provider from Transport_Provider WHERE Name = '" + transportProvider + "'), (SELECT idPassenger from Passenger WHERE Name = '" + passengerName + "'),'" + type + "', (SELECT GETDATE()), '" + totalAmount + "','" + isOneWay + "','" + orderFor + "','" + pickUpTime + "','" + pickupAddress + "' )";
SqlCommand cm = new SqlCommand(query, conn);
cm.ExecuteNonQuery();
MessageBox.Show("Order successfully added!");
cm.Dispose();
conn.Close();
}
}
}