private void BtnConsultant_Orders_addNewOrder_Click(object sender, RoutedEventArgs e) { // Extract and assign to variables order_no = txbConsultant_Orders_orderNumber.Text; string orderDate = txbConsultant_Orders_orderdate.Text; // check if the textboxes are empty or the strings associated with the textboxes bool checkEmptyStringBool = GeneralMethods.checkEmptytxtBox(order_no); try { NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); myConnect.Open(); using (var cmd = new NpgsqlCommand($"INSERT INTO orders (quote_no,order_no,datereceived,orderdate) VALUES (@quote_no,@order_no,@datereceived,@orderdate)", myConnect)) { cmd.Parameters.AddWithValue("quote_no", quote_no); cmd.Parameters.AddWithValue("order_no", order_no); cmd.Parameters.AddWithValue("datereceived", DateTime.Today.ToString().Substring(0, 10)); cmd.Parameters.AddWithValue("orderdate", orderDate); cmd.ExecuteNonQuery(); MessageBox.Show("Successfully added into the database."); } } catch (Exception h) { MessageBox.Show(h.ToString()); } // Display data from the database which is belongs to the current quote number // 1. Assign the the data to variables so that it becomes easy to store the database again when creating a new order // 2. Display the data in the textbox // reset the textboxes GeneralMethods.clearTextBoxes(txbConsultant_Orders_orderNumber, txbConsultant_Orders_inputQuote); }
private void BtnNewService_add_Click(object sender, RoutedEventArgs e) { //For insertion Done string name = txbNewService_name.Text; string address = txbNewService_address.Text; string telephone = txbNewService_telephone.Text; string emailadress = txbNewService_email.Text; string fax = txbNewService_fax.Text; string cellphone = txbNewService_cellphone.Text; string service = cbbNewService_entities.SelectionBoxItem.ToString(); string postalcode = txbNewService_areaCode.Text; string agency_ID = GeneralMethods.makeAgency_ID(name, postalcode); //Query for inserting the service provider try { NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); myConnect.Open(); using (var cmd = new NpgsqlCommand($"INSERT INTO agencydetails (agency_id,nameofagency,address,telephone,emailaddress,fax,cellphone,service) VALUES (@agency_id,@nameofagency,@address,@telephone,@emailaddress,@fax,@cellphone,@service)", myConnect)) { cmd.Parameters.AddWithValue("agency_id", agency_ID); cmd.Parameters.AddWithValue("nameofagency", name); cmd.Parameters.AddWithValue("address", address); cmd.Parameters.AddWithValue("telephone", telephone); cmd.Parameters.AddWithValue("emailaddress", emailadress); cmd.Parameters.AddWithValue("fax", fax); cmd.Parameters.AddWithValue("cellphone", cellphone); cmd.Parameters.AddWithValue("service", service); cmd.ExecuteNonQuery(); } MessageBox.Show($"Successfully added into database. Agency_Id is: {agency_ID}"); } catch (Exception h) { MessageBox.Show(h.ToString()); } }
/// <summary> /// Send a message. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnMessage_send_Click(object sender, RoutedEventArgs e) { // extract the value and assign them to variables if (SearchResultComboBox.SelectedIndex < 0) { return; } string staffTo = SearchResultComboBox.SelectedItem.ToString(); string subjectOFmassage = txbMessage_subject.Text; string message = txbMessage_message.Text; // CHECK FOR ERRORS // 1. check if the staff id or name exist in the databse // 2. check empty textboxes/variables // 1. // 2. string[] stringVs = new string[] { subjectOFmassage, message }; bool t_or_f = GeneralMethods.checkEmptytxtBox(stringVs); if (!t_or_f) { // .. todo insertMessage(currentStaffID, staffTo, message); txbMessage_message.Text = ""; // clear the textboxes GeneralMethods.clearTextBoxes(txbMessage_subject, txbMessage_message); } }
private void btnConsultant_Voucher_addNewVoucher_Click(object sender, RoutedEventArgs e) { voucher_no = GeneralMethods.makeVoucher_no(); txbConsultsnt_Vouchers_outputVoucherNumber.Text = voucher_no; //Query for retrieving client_id try { NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); myConnect.Open(); using (var cmd = new NpgsqlCommand($"SELECT client_no FROM orders,client WHERE order_no = '{order_no}' AND orders.quote_no=client.quote_no", myConnect)) { NpgsqlDataReader query = cmd.ExecuteReader(); while (query.Read()) { client_id = query[0].ToString(); } myConnect.Close(); } } catch (Exception h) { MessageBox.Show(h.ToString()); } //Query for retrieving voucher amount try { NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); myConnect.Open(); using (var cmd = new NpgsqlCommand($"SELECT amount FROM orders, quote WHERE order_no = '{order_no}' AND orders.quote_no=quote.quote_no", myConnect)) { NpgsqlDataReader query = cmd.ExecuteReader(); while (query.Read()) { Voucheramount = Convert.ToDouble(query[0].ToString()); } myConnect.Close(); } } catch (Exception h) { MessageBox.Show(h.ToString()); } //Query for retrieving accomm_id //try //{ // NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); // myConnect.Open(); // using (var cmd = new NpgsqlCommand($"SELECT accomm_id FROM orders,accommodation WHERE order_no = '{order_no}' AND orders.quote_no=accommmodation.quote_no", myConnect)) // { // NpgsqlDataReader query = cmd.ExecuteReader(); // while (query.Read()) // { // accomm_ID = query[0].ToString(); // } // myConnect.Close(); // } //} //catch (Exception h) //{ // MessageBox.Show(h.ToString()); //} //Query for retrieving agency_id try { NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); myConnect.Open(); using (var cmd = new NpgsqlCommand($"SELECT agencyids FROM orders,quote WHERE order_no = '{order_no}' AND orders.quote_no=quote.quote_no", myConnect)) { NpgsqlDataReader query = cmd.ExecuteReader(); while (query.Read()) { agency_ID = query[0].ToString(); } myConnect.Close(); } } catch (Exception h) { MessageBox.Show(h.ToString()); } //Query for retrieving staff_id try { NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); myConnect.Open(); using (var cmd = new NpgsqlCommand($"SELECT consultant_no FROM orders,quote WHERE orders.quote_no=quote.quote_no", myConnect)) { NpgsqlDataReader query = cmd.ExecuteReader(); while (query.Read()) { staff_ID = query[0].ToString(); } myConnect.Close(); } } catch (Exception h) { MessageBox.Show(h.ToString()); } try { NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); myConnect.Open(); using (var cmd = new NpgsqlCommand($"INSERT INTO voucher (voucher_no,order_no,client_id,agency_id,staff_id,amount) VALUES (@voucher_no,@order_no,@client_id,@agency_id,@staff_id,@amount)", myConnect)) { cmd.Parameters.AddWithValue("voucher_no", voucher_no); cmd.Parameters.AddWithValue("order_no", order_no); cmd.Parameters.AddWithValue("client_id", client_id); cmd.Parameters.AddWithValue("agency_id", agency_ID); cmd.Parameters.AddWithValue("staff_id", staff_ID); cmd.Parameters.AddWithValue("amount", Voucheramount); cmd.ExecuteNonQuery(); } } catch (Exception h) { MessageBox.Show(h.ToString()); } }
private void validateNumber(object sender, TextChangedEventArgs e) { GeneralMethods.checkPhoneNumber((TextBox)sender); }
private void validateValue(object sender, TextChangedEventArgs e) { GeneralMethods.checkAmountTyped((TextBox)sender); }
//private void LtbConsultant_Search_Results_SelectionChanged(object sender, SelectionChangedEventArgs e) //{ // // get the index of the selected item // int indexPath = lblConsultant_inboxList.SelectedIndex; // if (indexPath >= 0) // { // // the textbox that has the details // TextBlock id = (TextBlock)lblConsultant_inboxList.SelectedItem; // // change the font // id.FontSize = 16; // // get the ID // lblConsultantID.Content = id.Text; // // Assign the new button // lblConsultant_inboxList.Items.RemoveAt(indexPath); // lblConsultant_inboxList.Items.Insert(indexPath, id); // // get the ID of the reciever // string idContent = currentStaffID.ToLower(); // // get the index of the entry // int idNum = Convert.ToInt32(id.Tag); // // read the selected entry // readSelectedID(idContent, idNum); // // enable // composeMessageWindow.txbMessage_message.IsEnabled = true; // composeMessageWindow.btnMessage_send.IsEnabled = true; // } //} /// <summary> /// Going to the Search results window if anything is picked from the list /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void LtbConsultant_Search_Results_SelectionChanged(object sender, SelectionChangedEventArgs e) { string qoviNum = ltbConsultant_Search_Results.SelectedItem.ToString(); //order/quote/invoice/voucher number that has been selected by the user SearchResults searchResultsWindow = new SearchResults(); searchResultsWindow.Owner = this; searchResultsWindow.Show(); searchResultsWindow.tbkSearchResults.Text = ""; NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); //Display quotes try { myConnect.Open(); NpgsqlCommand cmdView = new NpgsqlCommand($"SELECT service FROM quote WHERE quote_no = '{qoviNum}'", myConnect); NpgsqlDataReader drView = cmdView.ExecuteReader(); while (drView.Read()) { searchResultsWindow.tbkSearchResults.Text = GeneralMethods.quoteSummary(qoviNum.Replace(" ", ""), drView[0].ToString()); //Viewing the selected quote's summary in the new window searchResultsWindow.tbkSearchResults.Text += GeneralMethods.quoteSummaryAmounts(qoviNum); } myConnect.Close(); } catch (Exception h) { MessageBox.Show(h.ToString()); } //End display quote //Display order //End display order //Display voucher //End display voucher //Display invoice //End display invoice //Display staff, client or service proivder switch (cbxStatus) { case "Staff": try { myConnect.Open(); NpgsqlCommand cmdStaff = new NpgsqlCommand($"SELECT staff_id, stafffirstnames, stafflastname, staffposition,email,cellphone,telephone,fax,address FROM staff WHERE staff_id = '{ltbConsultant_Search_Results.SelectedItem.ToString().Remove(0, ltbConsultant_Search_Results.SelectedItem.ToString().IndexOf(',') + 1).Replace(" ", "")}'", myConnect); //Removes the name of the staff because I'm seraching it with the staff_id in the databse NpgsqlDataReader drStaff = cmdStaff.ExecuteReader(); while (drStaff.Read()) { searchResultsWindow.tbkSearchResults.Text = $" Staff Id: {drStaff[0]} \n Name: {drStaff[1]} {drStaff[2]} \n Position: {drStaff[3]} \n Email: {drStaff[4]} \n Cellphone: {drStaff[5]} \n Telephone: {drStaff[6]} \n Fax: {drStaff[7]} \n Address: {drStaff[8]}"; //Viewing the selected staff member's summary in the new window } myConnect.Close(); } catch (Exception h) { MessageBox.Show(h.ToString()); } break; case "Clients": try { myConnect.Open(); NpgsqlCommand cmdClients = new NpgsqlCommand($"SELECT client_no,clientname,emailaddress,cellphone,telephone,fax,address FROM client WHERE client_no = '{ltbConsultant_Search_Results.SelectedItem.ToString().Remove(0, ltbConsultant_Search_Results.SelectedItem.ToString().IndexOf(',') + 1).Replace(" ", "")}'", myConnect); //Removes the name of the staff because I'm seraching it with the staff_id in the databse NpgsqlDataReader drClients = cmdClients.ExecuteReader(); while (drClients.Read()) { searchResultsWindow.tbkSearchResults.Text = $" Client No.: {drClients[0]} \n Name: {drClients[1]} \n Email: {drClients[2]} \n Cellphone: {drClients[3]} \n Telephone: {drClients[4]} \n Fax: {drClients[5]} \n Address: {drClients[6]}"; //Viewing the selected staff member's summary in the new window } myConnect.Close(); } catch (Exception h) { MessageBox.Show(h.ToString()); } break; case "Service Providers": try { myConnect.Open(); NpgsqlCommand cmdServiceP = new NpgsqlCommand($"SELECT agency_id, agencyname, emailaddress, cellphone, telephone, fax, address FROM serviceproviders WHERE agency_id = '{ltbConsultant_Search_Results.SelectedItem.ToString().Remove(0, ltbConsultant_Search_Results.SelectedItem.ToString().IndexOf(',') + 1).Replace(" ", "")}'", myConnect); //Removes the name of the staff because I'm seraching it with the staff_id in the databse NpgsqlDataReader drServiceP = cmdServiceP.ExecuteReader(); while (drServiceP.Read()) { searchResultsWindow.tbkSearchResults.Text = $" Agency ID: {drServiceP[0]} \n Name: {drServiceP[1]} \n Email: {drServiceP[2]} \n Cellphone {drServiceP[3]} \n Telephone: {drServiceP[4]} \n Fax: {drServiceP[5]} \n Address: {drServiceP[6]}"; } myConnect.Close(); } catch (Exception h) { MessageBox.Show(h.ToString()); } break; } //End display staff, client or service provider }
private void BtnConsultant_logOut_Click(object sender, RoutedEventArgs e) { GeneralMethods.logOut(this); }
private void Manager_Home1_Closed(object sender, EventArgs e) { GeneralMethods.CloseAllWindows(); }
private void BtnOwner_logOut_Click_1(object sender, RoutedEventArgs e) { GeneralMethods.logOut(this); }
private void BtnNewEmployee_generate_Click(object sender, RoutedEventArgs e) { bool boolValue = GeneralMethods.checkEmptytxtBox(txbNewEmployee_surname.Text, txbNewEmployee_name.Text, txbNewEmployee_address.Text, txbEmployee_cellphone.Text, txbNewEmployee_telephone.Text, txbNewEmployee_fax.Text, txbNewEmployee_email.Text, cmbNewEmployee_position.Text, txbNewEmployee_salary.Text); NpgsqlConnection myConnect = new NpgsqlConnection(MainWindow.ConnectionString); if (!boolValue) //if all the text boxes are fine then this code will execute { //Extracting Informtaion string Surname = txbNewEmployee_surname.Text; string Name = txbNewEmployee_name.Text; string FullAddress = txbNewEmployee_address.Text; string Cellphone = txbEmployee_cellphone.Text; string Telephone = txbNewEmployee_telephone.Text; string Fax = txbNewEmployee_fax.Text; string Email = txbNewEmployee_email.Text; string Position = cmbNewEmployee_position.Text; double Salary = Convert.ToDouble(txbNewEmployee_salary.Text); try { myConnect.Open(); NpgsqlCommand myCommand = new NpgsqlCommand($"INSERT INTO staff (staff_id, stafffirstnames,stafflastname,address,cellphone,telephone,fax,staffposition,salary,dateofhire,emailaddress) " + $"VALUES ('{GeneralMethods.makeStaffID(Surname, Cellphone)}', '{Name}', '{Surname}', '{FullAddress}', '{Cellphone}', '{Telephone}', '{Fax}', '{Position}', '{Salary}', '{dateofhire}','{Email}') ", myConnect); myCommand.ExecuteNonQuery(); GeneralMethods.clearTextBoxes(txbNewEmployee_surname, txbNewEmployee_name, txbNewEmployee_address, txbEmployee_cellphone, txbNewEmployee_telephone, txbNewEmployee_fax, txbNewEmployee_email, txbNewEmployee_salary); myConnect.Close(); } catch (Exception h) { MessageBox.Show(h.ToString()); } //try //{ // myConnect = new NpgsqlConnection(MainWindow.ChatConnectionString); // myConnect.Open(); // using (var cmd = new NpgsqlCommand($"INSERT INTO staff_members (staffid) VALUES (@staffid)", myConnect)) // { // cmd.Parameters.AddWithValue("staffid", GeneralMethods.makeStaffID(Surname, Cellphone)); // cmd.ExecuteNonQuery(); // MessageBox.Show($"Successfully added into the database. New Employee ID is: {GeneralMethods.makeStaffID(Surname, Cellphone)}"); // } //} //catch (Exception h) //{ // MessageBox.Show(h.ToString()); //} //// Creates a table in the database //using (var conn = new NpgsqlConnection(MainWindow.ChatConnectionString)) //{ // // open the connection // conn.Open(); // // create a table // using (var cmd = new NpgsqlCommand()) // { // cmd.Connection = conn; // cmd.CommandText = string.Format("CREATE TABLE {0} (" // + "tb_ID serial NOT NULL," // + "DateSent varchar(30) NOT NULL," // + "sender varchar(30) NOT NULL," // + "reciever varchar(30) NOT NULL," // + "message varchar(500) NOT NULL," // + "PRIMARY KEY(tb_ID)" // + ")", GeneralMethods.makeStaffID(Surname, Cellphone)); // cmd.ExecuteNonQuery(); // MessageBox.Show("Table created", "Attention"); // } //} } }
private void TxbNewEmployee_salary_TextChanged(object sender, TextChangedEventArgs e) { GeneralMethods.checkAmountTyped((TextBox)sender, false); }
private void btnManager_logOut_Click(object sender, RoutedEventArgs e) { GeneralMethods.logOut(this); }
private void Home_Page_Closed(object sender, EventArgs e) { GeneralMethods.closeAllWindows(); }