private void btn_view_Click(object sender, RoutedEventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = db.getData("select Cus_ID as 'CUSTOMER ID', Customer.F_name as 'FIRST NAME', Customer.S_name as'SURENAME', Customer.Cus_address as 'ADDRESS', Customer.Cus_Tel as 'TELEPHONE', Customer.NIC as 'NIC', Car_Booking.BNO as 'BOOKING ID'" +
" from Car_Booking,Booking,Vehicle,Driver,Customer" +
" where BK_No = BNO and CNO = Cus_ID and VNO = L_Plate and DNO = D_ID;");
dg_owners.ItemsSource = dt.DefaultView;
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void txt_milge_TextChanged(object sender, TextChangedEventArgs e)
{
try
{
txt_nxt.Text = (Int32.Parse(txt_milge.Text) + 2500).ToString();
}
catch (System.OverflowException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Number too large");
msg.Show();
txt_milge.Clear();
txt_nxt.Clear();
}
catch (System.FormatException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please input a number");
msg.Show();
txt_milge.Clear();
txt_nxt.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_Delete_Click(object sender, RoutedEventArgs e)
{
Messagebox msg = new Messagebox();
string a = " Delete from Driver where D_ID = '" + cbox_did.Text + "'";
int line = obj.save_update_delete(a);
if (line == 1)
{
msg.informationMsg("Data deleted successfully");
msg.Show();
}
else
{
msg.errorMsg("Sorry, couldn't delete your data.Please try again");
msg.Show();
}
cbox_did.Items.Clear();
txt_Lnum.Clear();
txt_Name.Clear();
txt_Tp.Clear();
txt_Address.Clear();
img.Source = null;
}
private void btn_upload_Click(object sender, RoutedEventArgs e)
{
try
{
OpenFileDialog open = new OpenFileDialog();
open.Multiselect = false;
open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
bool?result = open.ShowDialog();
if (result == true)
{
path = open.FileName; // Stores Original Path in Textbox
BitmapImage image = new BitmapImage();
image.BeginInit();
image.CacheOption = BitmapCacheOption.OnLoad;
image.UriSource = new Uri(path);
image.EndInit();
img_vehicle.Source = image;
}
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
private void cmb_bid_DropDownClosed(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = db.getData("exec booking_vehicle '" + cmb_bid.Text + "'");
if (cmb_did.Text != "")
{
date_book.Text = dt.Rows[0][1].ToString();
date_pick.Text = dt.Rows[0][2].ToString();
date_lend.Text = dt.Rows[0][3].ToString();
cmb_cid.Text = dt.Rows[0][4].ToString();
txt_fname.Text = dt.Rows[0][5].ToString();
txt_lname.Text = dt.Rows[0][6].ToString();
cmb_vid.Text = dt.Rows[0][7].ToString();
txt_make.Text = dt.Rows[0][8].ToString();
txt_model.Text = dt.Rows[0][9].ToString();
cmb_did.Text = dt.Rows[0][10].ToString();
txt_dname.Text = dt.Rows[0][11].ToString();
}
}
catch (IndexOutOfRangeException)
{
Messagebox obj = new Messagebox();
obj.errorMsg("Database Error");
obj.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
string query = "Insert into Insurance values ('" + txt_iid.Text + "','" + txt_org.Text + "','" + txt_address.Text + "','" + txt_tel.Text + "')";
int i = db.save_update_delete(query);
if (i == 1)
{
Messagebox msg = new Messagebox();
Add_Insurance_Form_Loaded(this, null);
msg.Show();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void cmb_vid_DropDownClosed(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
if (cmb_vid.Text != "")
{
dt = db.getData("select * from Vehicle where L_Plate='" + cmb_vid.Text + "'");
txt_make.Text = dt.Rows[0][2].ToString();
txt_model.Text = dt.Rows[0][3].ToString();
}
}
catch (IndexOutOfRangeException)
{
Messagebox obj = new Messagebox();
obj.errorMsg("Database Error");
obj.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
private void cmb_cusid_DropDownClosed(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = db.getData("select * from Customer where Cus_ID='" + cmb_cusid.Text + "'");
if (cmb_cusid.Text != "")
{
txt_cusFname.Text = dt.Rows[0][1].ToString();
txt_cusLname.Text = dt.Rows[0][2].ToString();
}
}
catch (IndexOutOfRangeException)
{
Messagebox obj = new Messagebox();
obj.errorMsg("Database Error");
obj.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
if (String.IsNullOrEmpty(error_msg.Text))
{
string name = System.IO.Path.GetFileName(filepath);
string destinationPath = GetDestinationPath(name);
File.Copy(filepath, destinationPath, true);
string a = "insert into Driver values ('" + txt_Did.Text + "','" + txt_Lnum.Text + "','" + txt_Name.Text + "','" + txt_Tp.Text + "','" + txt_Address.Text + "','" + filepath + "')";
File.Copy(filepath, destinationPath, true);
int line = db.save_update_delete(a);
if (line == 1)
{
Messagebox msg = new Messagebox();
add_driver1_Loaded(this, null);
msg.Show();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Unable to save data. Please try again");
msg.Show();
}
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form properly");
msg.Show();
}
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_mic_on_Click(object sender, RoutedEventArgs e)
{
Messagebox msg = new Messagebox();
btn_mic_on.Visibility = Visibility.Hidden;
btn_mic_off.Visibility = Visibility.Visible;
vc.stopVoice();
msg.informationMsg("Voice Command Disabled");
msg.Show();
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
if (cmb_type.SelectedIndex == 0)
{
string query = "Insert into Maintenance values ('" + txt_rid.Text + "','" + cmb_vid.Text + "','" + txt_details.Text + "','" + txt_date.Text + "','" + txt_cost.Text + "');";
int i = db.save_update_delete(query);
if (i == 1 || i == -1)
{
Messagebox msg = new Messagebox();
add_repair_form_Loaded(this, null);
msg.Show();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
else if (cmb_type.SelectedIndex == 1)
{
string query = "Insert into Acc_repair values ('" + txt_rid.Text + "','" + cmb_vid.Text + "','" + txt_details.Text + "','" + txt_date.Text + "','" + txt_cost.Text + "','" + txt_claim.Text + "');";
int i = db.save_update_delete(query);
if (i == 1 || i == -1)
{
Messagebox msg = new Messagebox();
add_repair_form_Loaded(this, null);
msg.Show();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_update_Click(object sender, RoutedEventArgs e)
{
try
{
if (cmb_type.SelectedIndex == 0)
{
string a = " update Acc_repair set VNO= '" + TXT_VID.Text + "', R_details = '" + txt_details.Text + "', " +
" R_date= '" + txt_date.Text + "', cost= '" + txt_cost.Text + "',Claim_amt= '" + txt_claim + "' where R_ID = '" + cmb_RID.Text + "'";
int line = db.save_update_delete(a);
if (line == 1)
{
MessageBox.Show("Data save Successfully", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Data cannot save", "error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else if (cmb_type.SelectedIndex == 1)
{
string a = " update Acc_repair set VNO= '" + TXT_VID.Text + "', R_details = '" + txt_details.Text + "', " +
" R_date= '" + txt_date.Text + "', cost= '" + txt_cost.Text + "',Claim_amt= '" + txt_claim + "' where R_ID = '" + cmb_RID.Text + "'";
int line = db.save_update_delete(a);
if (line == 1)
{
MessageBox.Show("Data save Successfully", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Data cannot save", "error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
string name = System.IO.Path.GetFileName(filepath);
string destinationPath = GetDestinationPath(name);
File.Copy(filepath, destinationPath, true);
string query = "Insert into Vehicle values ('" + txt_lno.Text + "','" + cbox_year.Text + "','" + cbox_make.Text + "','" + txt_model.Text + "','" + cbox_category.Text + "','" + txt_cpmonth.Text + "','" + txt_cpweek.Text + "','" + txt_extra.Text + "','" + cbox_oid.Text + "','" + txt_lndate.Text + "','" + cbox_ins.Text + "','" + txt_sdate.Text + "','" + txt_exdate.Text + "','" + destinationPath + "')";
if (string.IsNullOrEmpty(error_msg.Text))
{
int i = db.save_update_delete(query);
if (i == 2)
{
Messagebox msg = new Messagebox();
Vehicle_Setup_Form_Loaded(this, null);
msg.Show();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again. ");
msg.Show();
}
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill out the form properly");
msg.Show();
}
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_delete_Click(object sender, RoutedEventArgs e)
{
if (cmb_type.SelectedIndex == 0)
{
string a = " Delete from Maintenance where R_id = '" + cmb_RID.Text + "'";
int line = db.save_update_delete(a);
if (line == 1)
{
Messagebox msg = new Messagebox();
msg.Show();
cmb_RID.ItemsSource = null;
cmb_RID.Items.Clear();
cmb_type.SelectedIndex = -1;
TXT_VID.Clear();
txt_details.Clear();
txt_date.Text = null;
txt_cost.Clear();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
else if (cmb_type.SelectedIndex == 1)
{
string a = " Delete from Acc_repair where R_ID = '" + cmb_RID.Text + "'";
int line = db.save_update_delete(a);
if (line == 1)
{
Messagebox msg = new Messagebox();
msg.Show();
cmb_RID.ItemsSource = null;
cmb_RID.Items.Clear();
cmb_type.SelectedIndex = -1;
TXT_VID.Clear();
txt_details.Clear();
txt_date.Text = null;
txt_cost.Clear();
txt_claim.Clear();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
}
private void btn_submit_Click(object sender, RoutedEventArgs e)
{
Messagebox msg = new Messagebox();
int i = db.save_update_delete("insert into User_Login (Uname,Upass,Fname,Lname) values ('" + txt_uname.Text + "','" + hc.PassHash(pbox_pass.Password) + "','" + txt_fname.Text + "','" + txt_lname.Text + "')");
if (i == 1)
{
msg.informationMsg("Account Successfully Registered!");
msg.Show();
}
else
{
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
private void BTN_UPDATE_Click(object sender, RoutedEventArgs e)
{
try
{
string name = System.IO.Path.GetFileName(filepath);
string destinationPath = GetDestinationPath(name);
File.Copy(filepath, destinationPath, true);
string a = " update Customer set F_name= '" + TXT_FIRSTNAME.Text + "', S_name = '" + TXT_LASTNAME.Text + "', " +
"Cus_address= '" + TXT_ADDRESS.Text + "', L_Num= '" + TXT_LICENNUM.Text + "',NIC= '" + TXT_NIC.Text + "',Cus_Path = '" + filepath + "' where Cus_ID = '" + CMB_UPDATE.Text + "'";
File.Copy(filepath, destinationPath, true);
int line = db.save_update_delete(a);
if (line == 1)
{
MessageBox.Show("Data save Successfully", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Data cannot save", "error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_mic_off_Click(object sender, RoutedEventArgs e)
{
Messagebox msg = new Messagebox();
try
{
btn_mic_on.Visibility = Visibility.Visible;
btn_mic_off.Visibility = Visibility.Hidden;
msg.informationMsg("Voice Command Activated");
vc.startVoice();
msg.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
Messagebox msg = new Messagebox();
string name = System.IO.Path.GetFileName(path);
string destinationPath = GetDestinationPath(name);
File.Copy(path, destinationPath, true);
string q = "update Vehicle set L_Plate='" + cbox_lplate.Text + "',Year='" + cbox_year.Text + "',Make='" + cbox_make.Text + "',Model='" + txt_model.Text + "',Category='" + cbox_category.Text + "'" +
",Cost_Per_Month='" + txt_cpmonth.Text + "',Cost_Per_Week='" + txt_cpweek.Text + "',Extra_Cost='" + txt_extra.Text + "',O_ID='" + cbox_oid.Text + "',Lend_Date='" + txt_lndate.Text + "'," +
"S_date='" + txt_sdate.Text + "',E_date='" + txt_exdate.Text + "', V_Path = '" + destinationPath + "' where L_Plate = '" + old_id + "'";
int i = db.save_update_delete(q);
if (i == 1)
{
msg.informationMsg("Data Updated Successfully!");
msg.Show();
}
else
{
msg.errorMsg("Unable to Update Data.Please check again");
msg.Show();
}
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_submit_Click(object sender, RoutedEventArgs e)
{
try
{
string name = System.IO.Path.GetFileName(filepath);
string destinationPath = GetDestinationPath(name);
File.Copy(filepath, destinationPath, true);
string query = "Insert into Customer (Cus_ID,F_Name,S_name,Cus_address,Cus_Tel,L_Num,NIC,Cus_Path) values ('" + txt_id.Text + "','" + txt_fName.Text + "','" + txt_lName.Text + "','" + txt_address.Text + "','" + txt_contact.Text + "','" + txt_LicNum.Text + "','" + txt_NIC.Text + "','" + destinationPath + "')";
int i = db.save_update_delete(query);
if (i == 1)
{
Messagebox msg = new Messagebox();
Add_Customer_Loaded(this, null);
msg.Show();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
Messagebox msg = new Messagebox();
string a = "update Owner set O_ID='" + cmb_oid.Text + "' , O_NIC = '" + txt_nic.Text + "' , O_path = '" + path + "' , O_Tel = " + txt_contact.Text + " ,O_Name = '" + txt_name.Text + "', O_Address = '" + txt_address.Text + "' where O_ID = '" + cmb_oid.Text + "' ";
string name = System.IO.Path.GetFileName(path);
string destinationPath = GetDestinationPath(name);
File.Copy(path, destinationPath, true);
// txt_did.Text = System.IO.Path.GetDirectoryName(Process.GetCurrentProcess().MainModule.FileName);
int line = db.save_update_delete(a);
if (line == 1)
{
msg.informationMsg("Data Updated Successfully!");
msg.Show();
}
else
{
msg.errorMsg("Unable to Update Data.Please check again");
msg.Show();
}
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void cmb_RID_DropDownClosed(object sender, EventArgs e)
{
DataTable dt = new DataTable();
try
{
if (cmb_type.SelectedIndex == 0)
{
dt = db.getData("select * from Maintenance where R_id='" + cmb_RID.Text + "'");
TXT_VID.Text = dt.Rows[0][1].ToString();
txt_details.Text = dt.Rows[0][2].ToString();
txt_date.Text = dt.Rows[0][3].ToString();
txt_cost.Text = dt.Rows[0][4].ToString();
txt_error.Text = "";
}
else if (cmb_type.SelectedIndex == 1)
{
dt = db.getData("select * from Acc_repair where R_ID='" + cmb_RID.Text + "'");
TXT_VID.Text = dt.Rows[0][1].ToString();
txt_details.Text = dt.Rows[0][2].ToString();
txt_date.Text = dt.Rows[0][3].ToString();
txt_cost.Text = dt.Rows[0][4].ToString();
txt_claim.Text = dt.Rows[0][5].ToString();
txt_error.Text = "";
}
else
{
txt_error.Text = "Please select a Repair ID";
}
}
catch (IndexOutOfRangeException)
{
Messagebox obj = new Messagebox();
obj.errorMsg("Database Error");
obj.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
public void labelData()
{
string path;
DataTable dt = new DataTable();
dt = db.getData("select COUNT(L_Plate) from Vehicle");
label_vehicle.Content = dt.Rows[0][0].ToString();
dt = db.getData("select COUNT(D_ID) from Driver");
label_driver.Content = dt.Rows[0][0].ToString();
dt = db.getData("select COUNT(Cus_ID) from Customer");
label_customer.Content = dt.Rows[0][0].ToString();
try
{
string lnum;
dt = db.getData("select L_Plate,COUNT(L_Plate) from Car_Booking,Vehicle where L_Plate = VNO group by L_Plate");
lnum = dt.Rows[0][0].ToString();
dt = db.getData("select * from Vehicle where L_Plate = '" + lnum + "'");
lbl_year.Content = dt.Rows[0][1].ToString();
lbl_make.Content = dt.Rows[0][2].ToString();
lbl_model.Content = dt.Rows[0][3].ToString();
lbl_cat.Content = dt.Rows[0][4].ToString();
path = dt.Rows[0][13].ToString();
BitmapImage image = new BitmapImage();
image.BeginInit();
image.CacheOption = BitmapCacheOption.OnLoad;
image.UriSource = new Uri(path);
image.EndInit();
img_vehicle.Source = image;
}
catch (IndexOutOfRangeException)
{
Messagebox obj = new Messagebox();
obj.errorMsg("Database Error");
obj.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
string query = "Insert into Service values ('" + cmb_vid.Text + "','" + txt_Sid.Text + "','" + txt_Sdetails.Text + "','" + txt_milge.Text + "','" + txt_nxt.Text + "')";
int i = db.save_update_delete(query);
if (i == 1)
{
Messagebox msg = new Messagebox();
msg.Show();
add_service_form_Loaded(this, null);
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
private void btn_Update_Click(object sender, RoutedEventArgs e)
{
try
{
string name = System.IO.Path.GetFileName(filepath);
string destinationPath = GetDestinationPath(name);
string a = " update Driver set L_num= '" + txt_Lnum.Text + "', D_name = '" + txt_Name.Text + "', " +
" Tel= '" + txt_Tp.Text + "', Address= '" + txt_Address.Text + "',D_Path = '" + destinationPath + "' where D_ID = '" + cbox_did.Text + "'";
File.Copy(filepath, destinationPath, true);
int line = obj.save_update_delete(a);
if (line == 1)
{
MessageBox.Show("Data save Successfully", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Data cannot save", "error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (ArgumentNullException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please upload a photo");
msg.Show();
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void btn_submit_Click(object sender, RoutedEventArgs e)
{
try
{
string query1 = "Insert into Booking values ('" + txt_bid.Text + "','" + date_book.Text + "','" + date_pick.Text + "','" + date_lend.Text + "')";
string query2 = "Insert into Car_Booking values ('" + cmb_cusid.Text + "','" + cmb_vid.Text + "','" + cmb_did.Text + "','" + txt_bid.Text + "')";
int i = db.save_update_delete(query1);
int j = db.save_update_delete(query2);
if (i == 1 && j == 1)
{
Messagebox msg = new Messagebox();
form_booking_Loaded(this, null);
btn_bill.Visibility = Visibility.Visible;
msg.Show();
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Sorry, couldn't save your data.Please try again");
msg.Show();
}
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
private void BTN_UPLOAD_Click(object sender, RoutedEventArgs e)
{
try
{
OpenFileDialog open = new OpenFileDialog();
open.Multiselect = false;
open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
bool?result = open.ShowDialog();
if (result == true)
{
filepath = open.FileName;
ImageSource imgsource = new BitmapImage(new Uri(filepath));
IMG_UPDATECUS.Source = imgsource;
}
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
private void btn_upload_Click(object sender, RoutedEventArgs e)
{
try
{
OpenFileDialog open = new OpenFileDialog();
open.Multiselect = false;
open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
bool?result = open.ShowDialog();
if (result == true)
{
filepath = open.FileName; // Stores Original Path in Textbox
ImageSource imgsource = new BitmapImage(new Uri(filepath)); // Just show The File In Image when we browse It
img_vehicle.Source = imgsource;
}
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops soomething went worng. " + ex.Message);
msg.Show();
}
}
private void btn_update_Click(object sender, RoutedEventArgs e)
{
try
{
string a = " update Booking set BK_date = '" + date_book.Text + "', S_date='" + date_pick.Text + "', L_date='" + date_lend.Text + "' where BK_No = '" + cmb_bid.Text + "'";
string b = " update Car_Booking set VNO='" + cmb_vid.Text + "' , DNO = '" + cmb_did.Text + "' , BNO = '" + cmb_bid.Text + "' where CNO = '" + cmb_cid.Text + "'";
int x = db.save_update_delete(a);
int y = db.save_update_delete(b);
if (x == 1 && y == 1)
{
Messagebox msg = new Messagebox();
msg.informationMsg("Data Updated Successfully!");
msg.Show();
btn_bill.Visibility = Visibility.Visible;
}
else
{
Messagebox msg = new Messagebox();
msg.errorMsg("Unable to Update Data.Please check again");
msg.Show();
}
}
catch (System.Data.SqlClient.SqlException)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Please fill the form correctly. Database Error");
msg.Show();
}
catch (Exception ex)
{
Messagebox msg = new Messagebox();
msg.errorMsg("Oops something went worng. " + ex.Message);
msg.Show();
}
}
