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 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 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_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 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_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 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_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_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_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_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_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 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_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_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 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(); } }