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); }
/// <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 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"); // } //} } }