private void btnViewInquiry_Click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
DataTable InquiryResult = OurSitSchema.SearchInquiry(txtCustomerId.Text.Trim(),txtInquiryDate.Text.Trim());
if (InquiryResult == null)
{
lblViewInquiryStatus.Content = "No Inquiry data found.";
}
else
{
int count = InquiryResult.Rows.Count;
string ext;
if (count > 1)
{
ext = "s";
}
else
{
ext = "";
}
lblViewInquiryStatus.Content = Convert.ToString(count) + " Inquiry" + ext + " found.";
//SearchInquiryDataGrid.AutoGenerateColumns = true;
((DataGridTextColumn)SearchInquiryDataGrid.Columns[0]).Binding = new Binding("Id");
((DataGridTextColumn)SearchInquiryDataGrid.Columns[1]).Binding = new Binding("CustomerId");
((DataGridTextColumn)SearchInquiryDataGrid.Columns[2]).Binding = new Binding("Suject");
((DataGridTextColumn)SearchInquiryDataGrid.Columns[3]).Binding = new Binding("Body");
((DataGridTextColumn)SearchInquiryDataGrid.Columns[4]).Binding = new Binding("CreatedAt");
SearchInquiryDataGrid.AutoGenerateColumns = false;
SearchInquiryDataGrid.ItemsSource = InquiryResult.DefaultView;
}
}
private void btnSearchCustomer_Click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
DataTable CustomerResult = OurSitSchema.GetCustomer(txtId.Text.Trim(),txtFirstName.Text.Trim(),txtLastName.Text.Trim(),txtEmailAddress.Text.Trim());//OurSitSchema.GetCustomer(Convert.ToString(txtId.Text), Convert.ToString(txtFirstName.Text), Convert.ToString(txtLastName.Text), Convert.ToString(txtEmailAddress.Text));
if (CustomerResult == null)
{
lblSearchStatus.Content = "No customer data found.";
}
else
{
int count = CustomerResult.Rows.Count;
string ext;
if (count > 1)
{
ext = "s";
}
else
{
ext = "";
}
lblSearchStatus.Content = Convert.ToString(count) + " customer" + ext + " found.";
//SearchCustomerDataGrid.AutoGenerateColumns = true;
((DataGridTextColumn)SearchCustomerDataGrid.Columns[0]).Binding = new Binding("Id");
((DataGridTextColumn)SearchCustomerDataGrid.Columns[1]).Binding = new Binding("FirstName");
((DataGridTextColumn)SearchCustomerDataGrid.Columns[2]).Binding = new Binding("LastName");
((DataGridTextColumn)SearchCustomerDataGrid.Columns[3]).Binding = new Binding("EmailAddress");
((DataGridTextColumn)SearchCustomerDataGrid.Columns[4]).Binding = new Binding("ContactNumber");
((DataGridTextColumn)SearchCustomerDataGrid.Columns[5]).Binding = new Binding("CreatedAt");
SearchCustomerDataGrid.AutoGenerateColumns = false;
SearchCustomerDataGrid.ItemsSource = CustomerResult.DefaultView;
}
}
private void PostFeedback_click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
OurSitDb OurSitSchema1 = new OurSitDb();
OurSitDb OurSitSchema2 = new OurSitDb();
DataRowView rowBeingSelected = SearchInquiryDataGrid.CurrentItem as DataRowView;
//int CurrentRowIndex = SearchRentalDataGrid.Items.If
if (rowBeingSelected != null)
{
int Id = Convert.ToInt32(rowBeingSelected[0]);
string Message = txtReason.Text;
if (!string.IsNullOrEmpty(Message))
{
if (OurSitSchema1.AddInquiryFeedBack(Id, Message))
{
MessageBox.Show("Inquiry Feedback Posted!", "Success");
}
else
{
}
}
else
{
MessageBox.Show("Inquiry Feedback can not be sent with blank body.", "Invalid Operation");
}
}
}
private void btnSearchDriver_Click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
DataTable DriverResult = OurSitSchema.SearchDriver(txtId.Text.Trim(),txtNis.Text.Trim(),txtTrn.Text.Trim());
if (DriverResult == null)
{
lblSearchStatus.Content = "No Driver data found.";
}
else
{
int count = DriverResult.Rows.Count;
string ext;
if (count > 1)
{
ext = "s";
}
else
{
ext = "";
}
lblSearchStatus.Content = Convert.ToString(count) + " Driver" + ext + " found.";
//SearchDriverDataGrid.AutoGenerateColumns = true;
((DataGridTextColumn)SearchDriverDataGrid.Columns[0]).Binding = new Binding("Id");
((DataGridTextColumn)SearchDriverDataGrid.Columns[1]).Binding = new Binding("FirstName");
((DataGridTextColumn)SearchDriverDataGrid.Columns[2]).Binding = new Binding("LastName");
((DataGridTextColumn)SearchDriverDataGrid.Columns[3]).Binding = new Binding("TRN");
((DataGridTextColumn)SearchDriverDataGrid.Columns[4]).Binding = new Binding("NIS");
((DataGridTextColumn)SearchDriverDataGrid.Columns[5]).Binding = new Binding("District");
((DataGridTextColumn)SearchDriverDataGrid.Columns[6]).Binding = new Binding("Parish");
((DataGridTextColumn)SearchDriverDataGrid.Columns[7]).Binding = new Binding("ContactNumber");
SearchDriverDataGrid.AutoGenerateColumns = false;
SearchDriverDataGrid.ItemsSource = DriverResult.DefaultView;
}
}
private void AcceptRequest_click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
OurSitDb OurSitSchema1 = new OurSitDb();
OurSitDb OurSitSchema2 = new OurSitDb();
OurSitDb OurSitSchema3 = new OurSitDb();
DataRowView rowBeingSelected = SearchCharterDataGrid.CurrentItem as DataRowView;
//int CurrentRowIndex = SearchRentalDataGrid.Items.If
if (rowBeingSelected != null)
{
int Id = Convert.ToInt32(rowBeingSelected[0]);
string Message = txtReason.Text;
if (OurSitSchema.UpdateCharterRequest(Id, 1, Message))
{
//int CustomerId,int DriverId,string VehicleId, int PassengerNum, float Cost, DateTime DispatchTime, DateTime ReturnTime, string DispatchLocation
if (OurSitSchema1.AddCharter(Convert.ToInt32(rowBeingSelected[1]), 0, string.Empty, Convert.ToInt32(rowBeingSelected[3]), 0, DateTime.MaxValue, DateTime.MaxValue, string.Empty))
{
if (OurSitSchema2.DeleteCharterRequest(Id))
{
btnViewCharter_Click(sender, e);
MessageBox.Show("Customer Charter Request Accepted.", "Success!");
}
}
else
{
OurSitSchema3.UpdateRentalRequest(Id, 0, Message);
}
}
}
}
private void btnAddDriver_Click(object sender, RoutedEventArgs e)
{
string FirstName = txtFirstName.Text.Trim();
string LastName = txtLastName.Text.Trim();
string TRN = txtTrn.Text.Trim();
string NIS = txtNis.Text.Trim();
string District = txtDistrictAddress.Text.Trim();
string Parish = txtParishAddress.Text.Trim();
string ContactNumber = txtContactNumber.Text.Trim();
int ParsedTRN;
if(!string.IsNullOrEmpty(FirstName) && !string.IsNullOrEmpty(LastName) && !string.IsNullOrEmpty(TRN) && !string.IsNullOrEmpty(NIS) && !string.IsNullOrEmpty(District) && !string.IsNullOrEmpty(Parish) && !string.IsNullOrEmpty(ContactNumber))
{
if(Int32.TryParse(TRN,out ParsedTRN))
{
OurSitDb OurSitSchema = new OurSitDb();
MessageBoxResult Result;
if (OurSitSchema.AddDriver(FirstName,LastName,NIS,ParsedTRN,District,Parish,ContactNumber))
{
Result = MessageBox.Show(FirstName + " " + LastName + " was added successfully.");
}
else
{
lblAddDriverStatus.Content = "Driver data was not added.";
}
}
}
else
{
lblAddDriverStatus.Content = "All fields must contain data";
}
}
private void btnAddDriver_Click(object sender, RoutedEventArgs e)
{
string VIN = txtVIN.Text.Trim();
string Make = txtMake.Text.Trim();
string Model = txtModel.Text.Trim();
string Color = txtColor.Text.Trim();
string Condition = txtCondition.Text.Trim();
string ServiceType="";
if((bool)rbtnTypeCharter.IsChecked)
{
ServiceType = "charter";
}
else if ((bool)rbtnTypeDelivery.IsChecked)
{
ServiceType = "delivery";
}
else if ((bool)rbtnTypeRental.IsChecked)
{
ServiceType = "rental";
}
string SeatingCapacity = txtSeatingCapacity.Text.Trim();
int ParsedSeatingCapacity;
if (!string.IsNullOrEmpty(VIN) && !string.IsNullOrEmpty(Make) && !string.IsNullOrEmpty(Model) && !string.IsNullOrEmpty(Color) && !string.IsNullOrEmpty(ServiceType) && !string.IsNullOrEmpty(SeatingCapacity) && !string.IsNullOrEmpty(Condition))
{
if (Int32.TryParse(SeatingCapacity, out ParsedSeatingCapacity))
{
OurSitDb OurSitSchema = new OurSitDb();
MessageBoxResult Result;
if (OurSitSchema.AddVehicle(VIN, Make, Model, Color, Condition, ServiceType, ParsedSeatingCapacity))
{
Result = MessageBox.Show("Vehicle was added successfully.","Success");
}
else
{
lblAddVehicleStatus.Content = "Vehicle data was not added.";
}
}
else
{
lblAddVehicleStatus.Content = "Seating Capacity must be numeric.";
}
}
else
{
lblAddVehicleStatus.Content = "All fields must contain data";
}
}
private void btnViewDelivery_Click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
DataTable RequestResult;
if ((bool)chbxViewAll.IsChecked)
{
RequestResult = OurSitSchema.SearchDelivery(string.Empty);
}
else
{
RequestResult = OurSitSchema.SearchDeliveryRequest(txtCustomerId.Text.Trim());
}
if (RequestResult == null)
{
lblViewDeliveryRequest.Content = "No Customer Delivery data found.";
}
else
{
int count = RequestResult.Rows.Count;
string ext;
if (count > 1)
{
ext = "Deliveries";
}
else
{
ext = "Delivery";
}
lblViewDeliveryRequest.Content = Convert.ToString(count) + " Customer " + ext + " found.";
//SearchDeliveryDataGrid.AutoGenerateColumns = true;
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[0]).Binding = new Binding("Id");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[1]).Binding = new Binding("CustomerId");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[2]).Binding = new Binding("DriverId");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[3]).Binding = new Binding("VehicleId");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[4]).Binding = new Binding("ItemDemension");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[5]).Binding = new Binding("ItemQuantity");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[6]).Binding = new Binding("FromLocation");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[7]).Binding = new Binding("Destination");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[8]).Binding = new Binding("Cost");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[9]).Binding = new Binding("DispatchTime");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[10]).Binding = new Binding("ArrivalTime");
((DataGridTextColumn)SearchDeliveryDataGrid.Columns[11]).Binding = new Binding("ReturnTime");
SearchDeliveryDataGrid.AutoGenerateColumns = false;
SearchDeliveryDataGrid.ItemsSource = RequestResult.DefaultView;
}
}
private void btnAddCustomer_Click(object sender, RoutedEventArgs e)
{
string FirstName = txtFirstName.Text.Trim();
string LastName = txtLastName.Text.Trim();
string EmailAddress = txtEmailAddress.Text.Trim();
string ContactNumber = txtContactNumber.Text.Trim();
string Password = "******";
OurSitDb OurSitSchema = new OurSitDb();
MessageBoxResult Result;
if (OurSitSchema.AddCustomer(FirstName, LastName, EmailAddress, Password, ContactNumber))
{
Result = MessageBox.Show(FirstName + " " + LastName + " was added successfully.");
}
else
{
lblAddCustomerStatus.Content = "Customer data was not added.";
}
}
private void btnViewRental_Click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
DataTable RequestResult;
if ((bool)chbxViewAll.IsChecked)
{
RequestResult = OurSitSchema.SearchRental(string.Empty);
}
else
{
RequestResult = OurSitSchema.SearchRental(txtCustomerId.Text.Trim());
}
if (RequestResult == null)
{
lblViewRentalRequest.Content = "No Customer Rental data found.";
}
else
{
int count = RequestResult.Rows.Count;
string ext;
if (count > 1)
{
ext = "s";
}
else
{
ext = "";
}
lblViewRentalRequest.Content = Convert.ToString(count) + " Customer Rental" + ext + " found.";
//SearchDriverDataGrid.AutoGenerateColumns = true;
((DataGridTextColumn)SearchRentalDataGrid.Columns[0]).Binding = new Binding("Id");
((DataGridTextColumn)SearchRentalDataGrid.Columns[1]).Binding = new Binding("CustomerId");
((DataGridTextColumn)SearchRentalDataGrid.Columns[2]).Binding = new Binding("VehicleId");
((DataGridTextColumn)SearchRentalDataGrid.Columns[3]).Binding = new Binding("RentalDate");
((DataGridTextColumn)SearchRentalDataGrid.Columns[4]).Binding = new Binding("ReturnDate");
((DataGridTextColumn)SearchRentalDataGrid.Columns[5]).Binding = new Binding("Cost");
SearchRentalDataGrid.AutoGenerateColumns = false;
SearchRentalDataGrid.ItemsSource = RequestResult.DefaultView;
}
}
private void SearchCustomerDataGrid_CurrentCellChanged(object sender, EventArgs e)
{
if (rowBeingEdited != null)
{
OurSitDb OurSitSchema = new OurSitDb();
MessageBoxResult Result;
if (!string.IsNullOrEmpty(rowBeingEdited[1].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[2].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[3].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[4].ToString()))
{
if (OurSitSchema.UpdateCustomer(Convert.ToInt32(rowBeingEdited[0]), rowBeingEdited[1].ToString(), rowBeingEdited[2].ToString(), rowBeingEdited[3].ToString(), rowBeingEdited[4].ToString()))
{
}
}
else
{
rowBeingEdited.CancelEdit();
Result = MessageBox.Show("\"" + CurrentColumnHeader + "\"" + " must contain data.");
rowBeingEdited[CurrentColumnIndex] = CurrentColumnData;
}
rowBeingEdited.EndEdit();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
DataTable LoginDetail = new DataTable();
string UserName = txtUsername.Text.Trim() ;
string Password = txtPassword.Password;
if (!string.IsNullOrEmpty(UserName) && !string.IsNullOrEmpty(Password))
{
LoginDetail = OurSitSchema.GetOperatorByUsername(UserName);
if (LoginDetail.Rows.Count == 1)
{
string Id = LoginDetail.Rows[0][0].ToString();
string ActualUsername = LoginDetail.Rows[0][1].ToString();
string ActualPassword = LoginDetail.Rows[0][2].ToString();
string UserType = LoginDetail.Rows[0][3].ToString();
if (string.Compare(Password, ActualPassword, false) == 0)
{
//MessageBox.Show("pw: " + ActualPassword + " username: "******" user type: " + UserType);
Application.Current.Properties["Username"] = ActualUsername;
Application.Current.Properties["UserType"] = UserType;
Main MainWindow = new Main();
MainWindow.Show();
Close();
}
else
{
lblLoginStatus.Content = "Username or Password is incorrect.";
}
}
else
{
lblLoginStatus.Content = "Username or Password is incorrect.";
}
}
else
{
lblLoginStatus.Content = string.Empty;
}
}
private void btnSearchVehicle_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult result;
string ServiceType;
if ((bool)rbtnTypeCharter.IsChecked)
{
ServiceType = "charter";
}
else if ((bool)rbtnTypeDelivery.IsChecked)
{
ServiceType = "delivery";
}
else if ((bool)rbtnTypeRental.IsChecked)
{
ServiceType = "rental";
}
else if ((bool)rbtnTypeAll.IsChecked)
{
ServiceType = "all";
}
else
{
ServiceType = string.Empty;
}
if (string.IsNullOrEmpty(txtVIN.Text.Trim()) && string.IsNullOrEmpty(ServiceType.Trim()) && string.IsNullOrEmpty(txtSeatingCapacity.Text.Trim()))
{
result = MessageBox.Show("Enter a search criteria.");
}
else
{
OurSitDb OurSitSchema = new OurSitDb();
DataTable DriverResult = OurSitSchema.SearchVehicle(txtVIN.Text.Trim(), ServiceType.Trim(), txtSeatingCapacity.Text.Trim());
if (DriverResult == null)
{
lblSearchVehicleStatus.Content = "No Driver data found.";
}
else
{
int count = DriverResult.Rows.Count;
string ext;
if (count > 1)
{
ext = "s";
}
else
{
ext = "";
}
lblSearchVehicleStatus.Content = Convert.ToString(count) + " Driver" + ext + " found.";
//SearchVehicleDataGrid.AutoGenerateColumns = true;
((DataGridTextColumn)SearchVehicleDataGrid.Columns[0]).Binding = new Binding("VIN");
((DataGridTextColumn)SearchVehicleDataGrid.Columns[1]).Binding = new Binding("Make");
((DataGridTextColumn)SearchVehicleDataGrid.Columns[2]).Binding = new Binding("Model");
((DataGridTextColumn)SearchVehicleDataGrid.Columns[3]).Binding = new Binding("Color");
((DataGridTextColumn)SearchVehicleDataGrid.Columns[4]).Binding = new Binding("Condition");
((DataGridTextColumn)SearchVehicleDataGrid.Columns[5]).Binding = new Binding("ServiceType");
((DataGridTextColumn)SearchVehicleDataGrid.Columns[6]).Binding = new Binding("SeatingCapacity");
SearchVehicleDataGrid.AutoGenerateColumns = false;
SearchVehicleDataGrid.ItemsSource = DriverResult.DefaultView;
}
}
}
private void SearchDeliveryDataGrid_CurrentCellChanged(object sender, EventArgs e)
{
if (rowBeingEdited != null)
{
OurSitDb OurSitSchema = new OurSitDb();
MessageBoxResult Result;
if (!string.IsNullOrEmpty(rowBeingEdited[1].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[2].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[3].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[5].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[6].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[7].ToString()) && !string.IsNullOrEmpty(rowBeingEdited[8].ToString()))
{
//int Id ,int CustomerId, int DriverId, string VehicleId, string ItemDimension, int ItemQuantity, string FromLocation, string Destination, float Cost, DateTime DispatchTime, DateTime ArrivalTime, DateTime ReturnTime
if (OurSitSchema.UpdateCharter(Convert.ToInt32(rowBeingEdited[0]), Convert.ToInt32(rowBeingEdited[1]), Convert.ToInt32(rowBeingEdited[2]), rowBeingEdited[3].ToString(), Convert.ToInt32(rowBeingEdited[4]), Convert.ToDecimal(rowBeingEdited[5]), Convert.ToDateTime(rowBeingEdited[6]), Convert.ToDateTime(rowBeingEdited[8].ToString()), (string)rowBeingEdited[7]))
{
}
}
else
{
rowBeingEdited.CancelEdit();
Result = MessageBox.Show("\"" + CurrentColumnHeader + "\"" + " must contain data.");
rowBeingEdited[CurrentColumnIndex] = CurrentColumnData;
}
rowBeingEdited.EndEdit();
}
}
private void CancelRequest_click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
DataRowView rowBeingSelected = SearchCharterDataGrid.CurrentItem as DataRowView;
if (rowBeingSelected != null)
{
string Message = txtReason.Text;
int Id = Convert.ToInt32(rowBeingSelected[0]);
if (OurSitSchema.UpdateRentalRequest(Id, 2, Message))
{
rowBeingSelected[4] = "Cancelled";
rowBeingSelected[5] = Message;
MessageBox.Show("Customer Charter Request Cancelled.", "Success!");
}
}
}
private void AcceptRequest_click(object sender, RoutedEventArgs e)
{
OurSitDb OurSitSchema = new OurSitDb();
OurSitDb OurSitSchema1 = new OurSitDb();
OurSitDb OurSitSchema2 = new OurSitDb();
OurSitDb OurSitSchema3 = new OurSitDb();
DataRowView rowBeingSelected = SearchDeliveryDataGrid.CurrentItem as DataRowView;
//int CurrentRowIndex = SearchRentalDataGrid.Items.If
if (rowBeingSelected != null)
{
int Id = Convert.ToInt32(rowBeingSelected[0]);
string Message = txtReason.Text;
if (OurSitSchema.UpdateDeliveryRequest(Id, 1, Message))
{
//int CustomerId, int DriverId, string VehicleId, string ItemDimension, int ItemQuantity, string FromLocation, string Destination,float Cost, DateTime DispatchTime, DateTime ArrivalTime, DateTime ReturnTime)
if (OurSitSchema1.AddDelivery(Convert.ToInt32(rowBeingSelected[1]), 1, "99091", Convert.ToString(rowBeingSelected[3]), Convert.ToInt32(rowBeingSelected[4]), Convert.ToString(rowBeingSelected[5]), Convert.ToString(rowBeingSelected[6]), 0, Convert.ToDateTime(rowBeingSelected[7]), Convert.ToDateTime(rowBeingSelected[8]), DateTime.MaxValue))
{
if (OurSitSchema2.DeleteDeliveryRequest(Id))
{
btnViewDelivery_Click(sender, e);
MessageBox.Show("Customer Delivery Request Accepted.", "Success!");
}
}
else
{
rowBeingSelected[9] = "Pending";
OurSitSchema3.UpdateDeliveryRequest(Id, 0, Message);
}
}
}
}
