private void AddCustomerButton_Click(object sender, EventArgs e)
{
try
{
// If any of the fields is empty
if (main.isEmpty(CustomerIDBox.Text) || main.isEmpty(DriversLicenseBox.Text) || main.isEmpty(NameBox.Text) ||
main.isEmpty(PhoneNumberBox.Text) || main.isEmpty(AddressBox.Text) || main.isEmpty(CityBox.Text) ||
main.isEmpty(ProvinceBox.Text) || main.isEmpty(PostalCodeBox.Text))
{
MessageBox.Show("Please fill in all fields");
return;
}
string command = "INSERT INTO Customer VALUES('" + CustomerIDBox.Text + "','" + DriversLicenseBox.Text.ToUpper() + "','" + text.ToTitleCase(NameBox.Text) + "','" +
PhoneNumberBox.Text + "','" + text.ToTitleCase(AddressBox.Text) + "','" + text.ToTitleCase(CityBox.Text) + "','" +
text.ToTitleCase(ProvinceBox.Text) + "','" + PostalCodeBox.Text.ToUpper() + "')";
datab.insert(command);
main.CustomersDGV_LoadAll(datab);
this.Close();
}
catch (Exception e2)
{
// MessageBox.Show("VIN already exists in the system", "VIN Error");
MessageBox.Show(e2.ToString(), "Error");
}
}
private void SubmitChangesButton_Click(object sender, EventArgs e)
{
if (!main.isMakeValid(MakeBox.Text) && MakeBox.Text != "")
{
MessageBox.Show(MakeBox.Text + " is not a valid make", "Car Make Error");
return;
}
/* Compare the corresponding input text to the value of the cell selected. If they are different update. If not, dont do anything*/
try
{
// converts the string into something "System.Globalization" can manipulate?
TextInfo text = CultureInfo.CurrentCulture.TextInfo;
// Ensure the input text is not empty and different from the original value
if (VINBox.Text != this.getVINValue() && !main.isEmpty(VINBox.Text))
{
string updateVIN = "UPDATE Car SET VIN = '" + VINBox.Text.ToUpper() + "' WHERE VIN = '" + this.getVINValue() + "'";
datab.insert(updateVIN);
}
if (MakeBox.Text != this.getMakeValue() && !main.isEmpty(MakeBox.Text))
{
string updateMake = "UPDATE Car SET make = '" + main.ProperMakeFormat(MakeBox) + "' WHERE make = '" + this.getMakeValue() + "' AND VIN ='" + VINBox.Text + "'";
datab.insert(updateMake);
}
if (ModelBox.Text != this.getModelValue() && !main.isEmpty(ModelBox.Text))
{
string updateModel = "UPDATE Car SET model = '" + text.ToTitleCase(ModelBox.Text) + "' WHERE model = '" + this.getModelValue() + "' AND VIN ='" + VINBox.Text + "'";
datab.insert(updateModel);
}
if (ColorBox.Text != this.getColorValue() && !main.isEmpty(ColorBox.Text))
{
string updateColor = "UPDATE Car SET color = '" + text.ToTitleCase(ColorBox.Text) + "' WHERE color = '" + this.getColorValue() + "' AND VIN ='" + VINBox.Text + "'";
datab.insert(updateColor);
}
if (CarTypeDropBox.Text != this.getcTypeValue() && !main.isEmpty(CarTypeDropBox.Text))
{
string updatecType = "UPDATE Car SET cType = '" + main.ProperCarTypeFormat(CarTypeDropBox) + "' WHERE cType = '" + this.getcTypeValue() + "' AND VIN ='" + VINBox.Text + "'";
datab.insert(updatecType);
}
if (BranchIDDropBox.Text != this.getbIDValue() && !main.isEmpty(BranchIDDropBox.Text))
{
string updatebID = "UPDATE Car SET branchID = '" + BranchIDDropBox.Text + "' WHERE branchID = '" + this.getbIDValue() + "' AND VIN ='" + VINBox.Text + "'";
datab.insert(updatebID);
}
main.CarsDGV_LoadAll(datab);
this.Close();
}
catch (Exception e2)
{
MessageBox.Show(e2.ToString(), "Error");
}
}
private void AddCarButton_Click(object sender, EventArgs e)
{
// Error message if inputted text is not found in the ModelsList array
if (!main.isMakeValid(MakeBox.Text) && MakeBox.Text != "")
{
MessageBox.Show(text.ToTitleCase(MakeBox.Text) + " is not a valid make", "Car Make Error");
return;
}
try
{
// If any of the fields is empty
if (main.isEmpty(VINBox.Text) || main.isEmpty(MakeBox.Text) || main.isEmpty(ModelBox.Text) ||
main.isEmpty(ColorBox.Text) || main.isEmpty(CarTypeDropBox.Text) || main.isEmpty(BranchIDDropBox.Text))
{
MessageBox.Show("Please fill in all fields");
return;
}
// Proper make format variable
string Make;
// if 'bmw', 'gmc', or 'srt' is entered, make them all upper case
if (MakeBox.Text.ToLower() == "bmw" || MakeBox.Text.ToLower() == "gmc" || MakeBox.Text.ToLower() == "srt")
{
Make = MakeBox.Text.ToUpper();
}
else
{
Make = text.ToTitleCase(MakeBox.Text);
}
string command = "INSERT INTO Car VALUES('" + VINBox.Text.ToUpper() + "','" + main.ProperMakeFormat(MakeBox) + "','" + text.ToTitleCase(ModelBox.Text) + "','" +
text.ToTitleCase(ColorBox.Text) + "','" + main.ProperCarTypeFormat(CarTypeDropBox) + "'," + BranchIDDropBox.Text + ")";
datab.insert(command);
main.CarsDGV_LoadAll(datab);
this.Close();
}
catch (Exception e2)
{
// MessageBox.Show("VIN already exists in the system", "VIN Error");
MessageBox.Show(e2.ToString(), "Error");
}
}
private void AddTransactionButton_Click(object sender, EventArgs e)
//20190610TAG
//TODO need to be able to add transaction and still have branchIn and employeeIn boxes empty
{
if (TransactionIDBox.Text == "" || main.isEmpty(TransactionIDBox.Text) ||
CustomerIDDropBox.Text == "" || main.isEmpty(CustomerIDDropBox.Text) ||
VINDropBox.Text == "" || main.isEmpty(VINDropBox.Text) ||
OutBranchIDDropBox.Text == "" || main.isEmpty(OutBranchIDDropBox.Text) ||
//InBranchIDDropBox.Text == "" || main.isEmpty(InBranchIDDropBox.Text) ||
OutEmployeeIDDropBox.Text == "" || main.isEmpty(OutEmployeeIDDropBox.Text) ||
//InEmployeeIDDropBox.Text == "" || main.isEmpty(InEmployeeIDDropBox.Text) ||
PaymentInformationBox.Text == "" || main.isEmpty(PaymentInformationBox.Text)) //||
//TotalBalanceBox.Text == "" || main.isEmpty(TotalBalanceBox.Text))
{
MessageBox.Show("Please ensure all fields are filled", "Empty Field!");
return;
}
if (VINDropBox.Text == "No cars available - try different dates")
{
MessageBox.Show("Please change date range to select an available car", "Message");
return;
}
try
{
string command = "INSERT INTO RentalTransaction VALUES('" + TransactionIDBox.Text + "', (SELECT cID FROM Customer WHERE name = '" + CustomerIDDropBox.Text + "'),'" + VINDropBox.Text + "','" +
DateOutPicker.Value.ToString("yyyy-MM-dd") + "'," + "NULL" + ",'" + DateExpectedInPicker.Value.ToString("yyyy-MM-dd") +
"', (SELECT branchID FROM Branch WHERE branchName = '" + OutBranchIDDropBox.Text + "'), (SELECT branchID FROM Branch WHERE branchName = '" + InBranchIDDropBox.Text + "')," +
"(SELECT eID FROM Employee WHERE name = '" + OutEmployeeIDDropBox.Text + "'), (SELECT eID FROM Employee WHERE name = '" + InEmployeeIDDropBox.Text + "'),'" +
PaymentInformationBox.Text + "','" + TotalBalanceBox.Text + "')";
datab.insert(command);
main.TransactionDGV_LoadAll(datab);
this.Close();
}
catch (Exception e2)
{
MessageBox.Show(e2.ToString(), "Error");
}
}
private void button1_Click(object sender, EventArgs e)
{
//Check
if (Check_Input() == 0)
{
return;
}
string Customer_ID = Convert.ToString(Get_NewCID(localDB));
//Commit new customer
string Customer_Name = (TextFirstName.Text + TextLastName.Text);
string Customer_License = TextLicenseNum.Text;
string Customer_address = TextAddress1.Text;
string Customer_city = TextCity.Text;
string Customer_Province = ComboProvince.Text;
string Customer_PostalCode = TextPostalCode.Text;
string Customer_PhoneNum = TextPhoneNum.Text;
string Insert_String = @"insert into Customer values " + "('" + Customer_ID + "','" +
Customer_License + "','" + Customer_Name + "','" + Customer_PhoneNum + "','" +
Customer_address + "','" + Customer_city + "','" + Customer_Province + "','" + Customer_PostalCode + "')";
localDB.insert(Insert_String);
//string test = "SELECT cID FROM Customer WHERE cID = " + Customer_ID;
//localDB.query(test);
//int custID = localDB.myReader.Read().
//string MemberStatus_Update = @"INSERT INTO MemberStatus(cID, sinceDate) VALUES
// ((SELECT cID FROM Customer WHERE cID = " + Customer_ID + "), " + DateTime.Now.ToString("yyyy-MM-dd") + ")";
//localDB.insert(MemberStatus_Update);
this.Close();
}
private void EditTransactionButton_Click(object sender, EventArgs e)
//20190610TAG
//20190611TAG
{
try
{
string command = "UPDATE RentalTransaction " +
"SET rID = " + TransactionIDBox.Text + ", " +
"customerID = (SELECT cID FROM Customer WHERE name = '" + CustomerIDDropBox.Text + "'), " +
"carID = '" + VINDropBox.Text + "', " +
"dateOut = '" + DateOutPicker.Value.ToString("yyyy-MM-dd") + "', " +
"dateIn = '" + DateInPicker.Value.ToString("yyyy-MM-dd") + "', " +
"dateExpectedIn = '" + DateExpectedInPicker.Value.ToString("yyyy-MM-dd") + "', " +
"branchOutID = (SELECT branchID FROM Branch WHERE branchName = '" + OutBranchIDDropBox.Text + "'), " +
"branchInID = (SELECT branchID FROM Branch WHERE branchName = '" + InBranchIDDropBox.Text + "'), " +
"employeeOutID = (SELECT eID FROM Employee WHERE name = '" + OutEmployeeIDDropBox.Text + "'), " +
"employeeInID = (SELECT eID FROM Employee WHERE name = '" + InEmployeeIDDropBox.Text + "'), " +
"paymentInformation = '" + PaymentInformationBox.Text + "' " +
//"totalBalance = " + TotalBalanceBox.Text +
"WHERE rID = '" + TransactionIDBox.Text + "';";
//calculate the regular daily rate
command = command + "UPDATE RentalTransaction " +
"SET totalBalance = (SELECT DATEDIFF(day, dateOut, dateIn)) *dailyRate " +
"FROM RentalTransaction " +
"JOIN Car ON RentalTransaction.carID = Car.VIN " +
"JOIN CarType ON Car.cType = CarType.cType " +
"JOIN Customer ON RentalTransaction.customerID = Customer.cID " +
"LEFT JOIN MemberStatus on Customer.cID = MemberStatus.cID " +
"WHERE rID = '" + TransactionIDBox.Text + "';";
//
//calculate the late fee if returned after expected date
command = command + "UPDATE RentalTransaction " +
"SET totalBalance = totalBalance + ((SELECT DATEDIFF(day, dateExpectedIn, dateIn)) *lateDailyRate) " +
"FROM RentalTransaction " +
"JOIN Car ON RentalTransaction.carID = Car.VIN " +
"JOIN CarType ON Car.cType = CarType.cType " +
"JOIN Customer ON RentalTransaction.customerID = Customer.cID " +
"LEFT JOIN MemberStatus on Customer.cID = MemberStatus.cID " +
"WHERE dateIn > dateExpectedIn " +
"and rID = '" + TransactionIDBox.Text + "';";
//
//apply location penalty if returned at different location and not gold member
command = command + "UPDATE RentalTransaction " +
"SET totalBalance = totalBalance + penaltyRate " +
"FROM RentalTransaction " +
"JOIN Car ON RentalTransaction.carID = Car.VIN " +
"JOIN CarType ON Car.cType = CarType.cType " +
"JOIN Customer ON RentalTransaction.customerID = Customer.cID " +
"WHERE NOT EXISTS(SELECT * FROM MemberStatus WHERE MemberStatus.cID = Customer.cID) and " +
"RentalTransaction.branchInID != RentalTransaction.branchOutID " +
"and rID = '" + TransactionIDBox.Text + "';";
datab.insert(command);
main.TransactionDGV_LoadAll(datab);
this.Close();
}
catch (Exception e2)
{
MessageBox.Show(e2.ToString(), "Error");
}
}
private void SubmitChangesButton_Click(object sender, EventArgs e)
{
/* Compare the corresponding input text to the value of the cell selected. If they are different update. If not, dont do anything*/
try
{
// converts the string into something "System.Globalization" can manipulate?
TextInfo text = CultureInfo.CurrentCulture.TextInfo;
// Ensure the input text is not empty and different from the original value
if (CustomerIDBox.Text != this.getCustomerIDValue() && !main.isEmpty(CustomerIDBox.Text))
{
string updatecID = "UPDATE Customer SET cID = '" + CustomerIDBox.Text + "' WHERE cID = '" + this.getCustomerIDValue() + "'";
datab.insert(updatecID);
}
if (DriversLicenseBox.Text != this.getDriverLicenseValue() && !main.isEmpty(DriversLicenseBox.Text))
{
string updateDriversLicense = "UPDATE Customer SET driverLicense = '" + DriversLicenseBox.Text + "' WHERE driverLicense = '" + this.getDriverLicenseValue() + "' AND cID ='" + getCustomerIDValue() + "'";
datab.insert(updateDriversLicense);
}
if (NameBox.Text != this.getNameValue() && !main.isEmpty(NameBox.Text))
{
string updateName = "UPDATE Customer SET name = '" + NameBox.Text + "' WHERE name = '" + this.getNameValue() + "' AND cID ='" + getCustomerIDValue() + "'";
datab.insert(updateName);
}
if (PhoneNumberBox.Text != this.getPhoneNumberValue() && !main.isEmpty(PhoneNumberBox.Text))
{
string updatePhoneNumber = "UPDATE Customer SET phoneNumber = '" + PhoneNumberBox.Text + "' WHERE phoneNumber = '" + this.getPhoneNumberValue() + "' AND cID ='" + getCustomerIDValue() + "'";
datab.insert(updatePhoneNumber);
}
if (AddressBox.Text != this.getAddressValue() && !main.isEmpty(AddressBox.Text))
{
string updateAddress = "UPDATE Customer SET address1 = '" + AddressBox.Text + "' WHERE address1 = '" + this.getAddressValue() + "' AND cID ='" + getCustomerIDValue() + "'";
datab.insert(updateAddress);
}
if (CityBox.Text != this.getCityValue() && !main.isEmpty(CityBox.Text))
{
string updateCity = "UPDATE Customer SET city = '" + CityBox.Text + "' WHERE city = '" + this.getCityValue() + "' AND cID ='" + getCustomerIDValue() + "'";
datab.insert(updateCity);
}
if (ProvinceBox.Text != this.getProvinceValue() && !main.isEmpty(ProvinceBox.Text))
{
string updateProvince = "UPDATE Customer SET province = '" + ProvinceBox.Text + "' WHERE province = '" + this.getProvinceValue() + "' AND cID ='" + getCustomerIDValue() + "'";
datab.insert(updateProvince);
}
if (PostalCodeBox.Text != this.getPostalCodeValue() && !main.isEmpty(PostalCodeBox.Text))
{
string updatePostalCode = "UPDATE Customer SET postCode = '" + PostalCodeBox.Text + "' WHERE postCode = '" + this.getPostalCodeValue() + "' AND cID ='" + getCustomerIDValue() + "'";
datab.insert(updatePostalCode);
}
main.CustomersDGV_LoadAll(datab);
this.Close();
}
catch (Exception e2)
{
MessageBox.Show(e2.ToString(), "Error");
}
}
