/// <summary> /// Handles the Click event of the Add_button control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> private void Add_button_Click(object sender, RoutedEventArgs e) { hpcusid_W_label.Visibility = Visibility.Hidden; internalcusid_W_label.Visibility = Visibility.Hidden; cusname_W_label.Visibility = Visibility.Hidden; cusaddress_W_label.Visibility = Visibility.Hidden; name_W_label.Visibility = Visibility.Hidden; mail_W_label.Visibility = Visibility.Hidden; phone_W_label.Visibility = Visibility.Hidden; both_W_label.Visibility = Visibility.Hidden; cell_W_label.Visibility = Visibility.Hidden; dep_W_label.Visibility = Visibility.Hidden; bool f1 = false, f2 = false, f3 = false, f4 = false, f5 = false, f6 = false, f7 = false, f8 = false, f9 = false, f10 = false, f11 = false, f12 = false; if (!string.IsNullOrWhiteSpace(hpcusid_textBox.Text)) { try { int hpcustideCheck = Convert.ToInt32(hpcusid_textBox.Text); hpcusid = hpcusid_textBox.Text; f1 = true; } catch { hpcusid_W_label.Content = "ח.פ. הלקוח חייב להכיל מספרים בלבד!"; hpcusid_W_label.Visibility = Visibility.Visible; //MessageBox.Show("!ח.פ. הלקוח חייב להכיל מספרים בלבד"); } } else { hpcusid_W_label.Content = "אנא הכנס חפ לקוח"; hpcusid_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס חפ לקוח "); } if (!string.IsNullOrWhiteSpace(internalcusid_textBox.Text)) { try { int hpcustideCheck = Convert.ToInt32(internalcusid_textBox.Text); internalcusid = internalcusid_textBox.Text; f8 = true; } catch { internalcusid_W_label.Content = "מספר הלקוח חייב להכיל מספרים בלבד!"; internalcusid_W_label.Visibility = Visibility.Visible; //MessageBox.Show("!מספר הלקוח חייב להכיל מספרים בלבד"); } } else { internalcusid = "לא הוזן"; f8 = true; // internalcusid_W_label.Content = "אנא הכנס מס לקוח"; // internalcusid_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס מס לקוח "); } // if (firstname_textBox.Text != null) if (!string.IsNullOrWhiteSpace(custname_textBox.Text)) { /* bool instring = false; instring = custname_textBox.Text.Contains("'"); if (instring) { MessageBox.Show("אסור להשתמש בגרש"); return; } */ CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); custname = CSQ.checkForSingleQuotationMark(custname_textBox.Text); //custname = custname_textBox.Text; f2 = true; // MessageBox.Show("" + username + ""); } else { cusname_W_label.Content = "אנא הכנס שם לקוח"; cusname_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס שם לקוח"); } // if (address_textBox != null) if (!string.IsNullOrWhiteSpace(address_textBox.Text)) { //cusaddress = address_textBox.Text; CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); cusaddress = CSQ.checkForSingleQuotationMark(address_textBox.Text); f3 = true; } else { cusaddress_W_label.Content = "אנא הכנס כתובת לקוח"; cusaddress_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס כתובת לקוח "); } // if (email_textBox1.Text != null) if (!string.IsNullOrWhiteSpace(email_textBox1.Text)) { if ((Regex.IsMatch(this.email_textBox1.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))) { contact_email = email_textBox1.Text; // MessageBox.Show("" + email + ""); f4 = true; } else { mail_W_label.Content = "אנא בדוק תקינות כתובת האימייל"; mail_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא בדוק תקינות כתובת האימייל"); } } else { contact_email = "לא הוזן"; f4 = true; // mail_W_label.Content = "אנא הכנס כתובת אימייל"; // mail_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס כתובת אימייל"); } if (!string.IsNullOrWhiteSpace(contact_name_textBox.Text)) { //contact_name = contact_name_textBox.Text; CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); contact_name = CSQ.checkForSingleQuotationMark(contact_name_textBox.Text); f5 = true; } else { name_W_label.Content = "אנא הכנס שם איש קשר"; name_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס שם איש קשר "); } if (!string.IsNullOrWhiteSpace(cont_phone_text.Text)) { try { int phoneCheck = Convert.ToInt32(cont_phone_text.Text); contact_phone = cont_phone_text.Text; f10 = true; //phone } catch { f11 = true; phone_W_label.Content = "מספר הטלפון חייב להכיל מספרים בלבד!"; phone_W_label.Visibility = Visibility.Visible; //MessageBox.Show("!מספר הטלפון חייב להכיל מספרים בלבד"); } } if (!string.IsNullOrWhiteSpace(cell_textBox.Text)) { try { int cellphoneCheck = Convert.ToInt32(cell_textBox.Text); contact_cellphone = cell_textBox.Text; f9 = true; //cell } catch { f12 = true; cell_W_label.Content = "מספר נייד חייב להכיל מספרים בלבד!"; cell_W_label.Visibility = Visibility.Visible; //MessageBox.Show("!מספר הטלפון נייד חייב להכיל מספרים בלבד"); } } if (f9 || f10) //user enterd phone and/or cellphone correctly. { if (!f11 && !f12) // if non was wrong. { f6 = true; } } //user did not enterd cellphone and/or phone. if (string.IsNullOrWhiteSpace(cont_phone_text.Text) && string.IsNullOrWhiteSpace(cell_textBox.Text)) { both_W_label.Content = "אנא הכנס מספר טלפון ו/או נייד עבור איש הקשר"; both_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס מספר טלפון ו/או נייד עבור איש הקשר "); } if (!string.IsNullOrWhiteSpace(cont_dep_text.Text)) { //contact_dep = cont_dep_text.Text; CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); contact_dep = CSQ.checkForSingleQuotationMark(cont_dep_text.Text); f7 = true; } else { contact_dep = "לא הוזן"; f7 = true; // dep_W_label.Content = "אנא הכנס מחלקת איש קשר"; // dep_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס מחלקת איש קשר "); } // if all is ok then add new user to the DB. if (f1 && f2 && f3 && f4 && f5 && f6 && f7 && f8) { int hp = 0; int count = 0; //string not = "לא מחובר"; // string query = ("insert into project.costumers (costumerid, costumerName, contactName , contactEmail,contactPhone,costumerAddress,contactDepartment) values ('" + hpcusid + "','" + custname + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + cusaddress + "','" + contact_dep + "')"); try { MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string query1 = ("select costumerid from costumers where costumerid='" + hpcusid + "'"); MySqlCommand MSQLcrcommand1 = new MySqlCommand(query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); MySqlDataReader dr = MSQLcrcommand1.ExecuteReader(); while (dr.Read()) { hp++; } MySqlConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } if (internalcusid != "לא הוזן") { try { MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string query2 = ("select costumer_insideNum from costumers where costumer_insideNum='" + internalcusid + "' AND costumer_insideNum !='לא הוזן` "); MySqlCommand MSQLcrcommand2 = new MySqlCommand(query2, MySqlConn); MSQLcrcommand2.ExecuteNonQuery(); MySqlDataReader dr2 = MSQLcrcommand2.ExecuteReader(); while (dr2.Read()) { count++; } MySqlConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } else { count=0; } //MessageBox.Show("" + count + ""); if (hp == 0 && count == 0) { // if only phone string query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactPhone,costumerAddress,contactDepartment,costumer_insideNum) values ('" + hpcusid + "','1','" + custname + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + cusaddress + "','" + contact_dep + "','" + internalcusid + "')"); if (!f10 && f9) // if only cell { query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactCellPhone,costumerAddress,contactDepartment,costumer_insideNum) values ('" + hpcusid + "','1','" + custname + "','" + contact_name + "','" + contact_email + "','" + contact_cellphone + "','" + cusaddress + "','" + contact_dep + "','" + internalcusid + "')"); } if (f9 && f10) // if both { query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactPhone,contactCellPhone,costumerAddress,contactDepartment,costumer_insideNum) values ('" + hpcusid + "','1','" + custname + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + contact_cellphone + "','" + cusaddress + "','" + contact_dep + "','" + internalcusid + "')"); } //string query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactPhone,costumerAddress,contactDepartment) values ('" + hpcusid + "',' 1 ','" + custname + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + cusaddress + "','" + contact_dep + "')"); DBConnection DBC = new DBConnection(); Console.WriteLine("שאילתת ההוספה"); Console.WriteLine(query); DBC.InsertDataIntoDB(Login.Connectionstring, query); hpcusid_textBox.Clear(); internalcusid_textBox.Clear(); custname_textBox.Clear(); address_textBox.Clear(); contact_name_textBox.Clear(); email_textBox1.Clear(); cont_phone_text.Clear(); cell_textBox.Clear(); cont_dep_text.Clear(); try { MySqlConnection MySqlConn1 = new MySqlConnection(Login.Connectionstring); MySqlConn1.Open(); string Query1 = ("SELECT costumerid as `חפ לקוח`,costumerName as `שם לקוח` ,costumer_insideNum as `מספר לקוח`,costumerAddress as `כתובת לקוח`,costumerDesc as `הערות בקשר ללקוח` from project.costumers group by costumerid"); MySqlCommand MSQLcrcommand11 = new MySqlCommand(Query1, MySqlConn1); MSQLcrcommand11.ExecuteNonQuery(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand11); // DataTable dt = new DataTable("custumers"); ManagerCusGui.dt.Clear(); mysqlDAdp.Fill(ManagerCusGui.dt); //dataGrid1.ItemsSource = ManagerCusGui.dt.DefaultView; mysqlDAdp.Update(ManagerCusGui.dt); MySqlConn1.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { if (hp > 0 && count > 0) { MessageBox.Show("מספר ח.פ. ומספר לקוח שהוזנו כבר קיימים במערכת", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (hp > 0) { MessageBox.Show("מספר ח.פ. שהוזן כבר קיים במערכת", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); return; } else { MessageBox.Show("מספר לקוח כבר קיים במערכת ", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); return; } } } }
// This func will check and add the new user to the DB if all is ok. /// <summary> /// Handles the Click event of the Add_button control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> private void Add_button_Click(object sender, RoutedEventArgs e) { try { Console.WriteLine("נכנס לטראי"); DataRowView row1 = (DataRowView)dataGrid1.SelectedItems[0]; } catch { MessageBox.Show("אנא בחר עובד", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); return; } DataRowView row = (DataRowView)dataGrid1.SelectedItems[0]; string empid = row["תעודת זהות"].ToString(); Console.WriteLine(empid); bool f1 = false, f2 = false, f3 = false, f4 = false; // if (Password_textBox != null) if (Password_textBox != null && !string.IsNullOrWhiteSpace(Password_textBox.Password)) { password = Password_textBox.Password; f1 = true; } else { MessageBox.Show("אנא הכנס סיסמא", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); } // if (Email_textBox.Text != null) if (Email_textBox != null && !string.IsNullOrWhiteSpace(Email_textBox.Text)) { if ((Regex.IsMatch(this.Email_textBox.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))) { email = Email_textBox.Text; // MessageBox.Show("" + email + ""); f2 = true; } else { MessageBox.Show("אנא בדוק תקינות כתובת האימייל", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("אנא הכנס כתובת אימייל", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); } if (!string.IsNullOrWhiteSpace(school_textBox.Text)) { school = school_textBox.Text; f4 = true; } else { MessageBox.Show("אנא הכנס שם בית ספר יסודי", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); } if (Role_comboBox.SelectedValue != null) { role = Role_comboBox.SelectedValue.ToString(); f3 = true; } else { MessageBox.Show("אנא בחר תפקיד", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); } // if all is ok then add new user to the DB. if (f1 && f2 && f3 & f4) { DateTime yesterday = DateTime.Today.AddDays(-1); string date = Convert.ToDateTime(yesterday).ToString("yyyy-MM-dd"); Console.WriteLine(date); //string not = "לא מחובר"; CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); string query = ("insert into project.users (empid, password, role , email , last_email_sent_date , rec_answer) values ('" + empid + "','" + CSQ.checkForSingleQuotationMark(password) + "','" + role + "','" + email + "','" + date + "','" + CSQ.checkForSingleQuotationMark(school) + "')"); DBConnection DBC = new DBConnection(); DBC.InsertDataIntoDB(Login.Connectionstring, query); try { MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string Query1 = ("SELECT empid as `תעודת זהות`,emp_firstname as `שם פרטי` ,emp_lastname as `שם משפחה` , emp_insidenum as `מספר עובד` ,emp_address as `כתובת` ,emp_phone as `מספר טלפון`, emp_cellphone as `טלפון נייד`, emp_start_date as `תאריך התחלת עבודה` FROM project.employees WHERE employees.empid not in (SELECT users.empid FROM project.users)"); MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1); dt.Clear(); mysqlDAdp.Fill(dt); dataGrid1.ItemsSource = dt.DefaultView; mysqlDAdp.Update(dt); MySqlConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
// This func will check and add the new user to the DB if all is ok. /// <summary> /// Handles the Click event of the Add_button control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> private void Add_button_Click(object sender, RoutedEventArgs e) { bool f1 = false, f2 = false, f3 = false, f4 = false, f5 = false, f6 = false; phone_W_label.Visibility = Visibility.Hidden; id_W_label.Visibility = Visibility.Hidden; first_W_label.Visibility = Visibility.Hidden; address_W_label.Visibility = Visibility.Hidden; last_W_label.Visibility = Visibility.Hidden; cell_W_label.Visibility = Visibility.Hidden; empnum_W_label.Visibility = Visibility.Hidden; // if (id_textBox.Text != null) if (id_textBox != null && !string.IsNullOrWhiteSpace(id_textBox.Text)) { try { int idnumbersCheck = Convert.ToInt32(id_textBox.Text); } catch { id_W_label.Content = "ת.ז. חייבת להכיל מספרים בלבד!"; id_W_label.Visibility = Visibility.Visible; return; } try { //to see if the empid already in the system. MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string Query1 = ("SELECT COUNT(empid) FROM employees WHERE empid='" + id_textBox.Text + "' "); MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); int empidtimes = Convert.ToInt32(MSQLcrcommand1.ExecuteScalar()); MySqlDataReader dr = MSQLcrcommand1.ExecuteReader(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1); MySqlConn.Close(); if (empidtimes != 0) { MessageBox.Show("כבר קיים עובד בעל תעודת זהות זו - " + id_textBox.Text , "!שים לב" ,MessageBoxButton.OK ,MessageBoxImage.Error); id_W_label.Content = "ת.ז. זו כבר קיימת"; id_W_label.Visibility = Visibility.Visible; return; } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } empid = id_textBox.Text; f1 = true; } else { id_W_label.Content = "אנא הכנס תעודת זהות"; id_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס תעודת זהות"); } if (firstname_textBox != null && !string.IsNullOrWhiteSpace(firstname_textBox.Text)) { CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); firstname = CSQ.checkForSingleQuotationMark(firstname_textBox.Text); // firstname = firstname_textBox.Text; f2 = true; } else { first_W_label.Visibility = Visibility.Visible; // MessageBox.Show("אנא הכנס שם פרטי "); } if (lastname_textBox != null && !string.IsNullOrWhiteSpace(lastname_textBox.Text)) { CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); lastname = CSQ.checkForSingleQuotationMark(lastname_textBox.Text); // lastname = lastname_textBox.Text; f3 = true; } else { last_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס שם משפחה "); } if (emp_num_textBox != null && !string.IsNullOrWhiteSpace(emp_num_textBox.Text)) { try { int idnumbersCheck = Convert.ToInt32(emp_num_textBox.Text); } catch { empnum_W_label.Content = "מספר עובד חייב להכיל מספרים בלבד!"; empnum_W_label.Visibility = Visibility.Visible; return; } try { //to see if the emp_insidenum already in the system. MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string Query1 = ("SELECT COUNT(emp_insidenum) FROM employees WHERE emp_insidenum='" + emp_num_textBox.Text + "' "); MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); int times = Convert.ToInt32(MSQLcrcommand1.ExecuteScalar()); MySqlDataReader dr = MSQLcrcommand1.ExecuteReader(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1); MySqlConn.Close(); if (times != 0) { MessageBox.Show("כבר קיים מספר עובד - " + emp_num_textBox.Text, "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); empnum_W_label.Content = "מספר עובד זה כבר קיים"; empnum_W_label.Visibility = Visibility.Visible; return; } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } emp_num = emp_num_textBox.Text; f4 = true; } else { empnum_W_label.Content = "אנא הכנס מספר עובד"; empnum_W_label.Visibility = Visibility.Visible; // MessageBox.Show("אנא הכנס מספר עובד"); } if (phone_textBox1 != null && !string.IsNullOrWhiteSpace(phone_textBox1.Text)) { try { int phoneCheck = Convert.ToInt32(phone_textBox1.Text); } catch { phone_W_label.Visibility = Visibility.Visible; // MessageBox.Show("!מספר הטלפון חייב להכיל מספרים בלבד"); return; } phone = phone_textBox1.Text; } if (startdatePicker != null && !string.IsNullOrWhiteSpace(startdatePicker.Text)) { try { start = Convert.ToDateTime(startdatePicker.Text).ToString("yyyy-MM-dd"); f6 = true; } catch { MessageBox.Show("תאריך התחלה אינו תקין", "!שים לב", MessageBoxButton.OK, MessageBoxImage.Error); return; } } if (cell_textBox != null && !string.IsNullOrWhiteSpace(cell_textBox.Text)) { try { int cellphoneCheck = Convert.ToInt32(cell_textBox.Text); } catch { cell_W_label.Visibility = Visibility.Visible; // MessageBox.Show("!מספר הנייד חייב להכיל מספרים בלבד"); return; } cellphone = cell_textBox.Text; } if (address_textBox1 != null && !string.IsNullOrWhiteSpace(address_textBox1.Text)) { address = address_textBox1.Text; CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); address = CSQ.checkForSingleQuotationMark(address); f5 = true; } else { address_W_label.Visibility = Visibility.Visible; // MessageBox.Show("אנא הכנס כתובת"); } // if all is ok then add new user to the DB. if (f1 && f2 && f3 && f4 && f5 && f6) { try { string query = ("insert into project.employees (empid, emp_firstname, emp_lastname, emp_address , emp_phone,emp_cellphone,emp_start_date,emp_insidenum) values ('" + empid + "','" + firstname + "','" + lastname + "','" + address + "','" + phone + "','" + cellphone + "','" + start + "','" + emp_num + "')"); DBConnection DBC = new DBConnection(); DBC.InsertDataIntoDB(Login.Connectionstring, query); //MessageBox.Show("העובד התווסף למערכת"); MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string Query1 = ("SELECT empid as `תעודת זהות`,emp_firstname as `שם פרטי` ,emp_lastname as `שם משפחה` , emp_insidenum as `מספר עובד` ,emp_address as `כתובת` ,emp_phone as `מספר טלפון`, emp_cellphone as `טלפון נייד`, emp_start_date as `תאריך התחלת עבודה` from project.employees "); MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1); // DataTable dt = new DataTable("employess"); ManagerEMPGui.dt.Clear(); mysqlDAdp.Fill(ManagerEMPGui.dt); // ManagerEMPGui.dataGrid1.ItemsSource = ManagerEMPGui.dt.DefaultView; mysqlDAdp.Update(ManagerEMPGui.dt); MySqlConn.Close(); id_textBox.Clear(); firstname_textBox.Clear(); lastname_textBox.Clear(); emp_num_textBox.Clear(); phone_textBox1.Clear(); startdatePicker.SelectedDate = null; cell_textBox.Clear(); address_textBox1.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } if (f1 && f2 && f3 && f4 && f5 && !f6) { try { string query = ("insert into project.employees (empid, emp_firstname, emp_lastname, emp_address , emp_phone,emp_cellphone,emp_insidenum) values ('" + empid + "','" + firstname + "','" + lastname + "','" + address + "','" + phone + "','" + cellphone + "','" + emp_num + "')"); DBConnection DBC = new DBConnection(); DBC.InsertDataIntoDB(Login.Connectionstring, query); //MessageBox.Show("העובד התווסף למערכת"); MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string Query1 = ("SELECT empid as `תעודת זהות`,emp_firstname as `שם פרטי` ,emp_lastname as `שם משפחה` , emp_insidenum as `מספר עובד` ,emp_address as `כתובת` ,emp_phone as `מספר טלפון`, emp_cellphone as `טלפון נייד`, emp_start_date as `תאריך התחלת עבודה` FROM project.employees "); MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1); SecEMPGui.dt.Clear(); mysqlDAdp.Fill(SecEMPGui.dt); mysqlDAdp.Update(SecEMPGui.dt); MySqlConn.Close(); id_textBox.Clear(); firstname_textBox.Clear(); lastname_textBox.Clear(); emp_num_textBox.Clear(); phone_textBox1.Clear(); startdatePicker.SelectedDate = null; cell_textBox.Clear(); address_textBox1.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
/// <summary> /// Handles the Click event of the Add_button control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> private void Add_button_Click(object sender, RoutedEventArgs e) { name_W_label.Visibility = Visibility.Hidden; mail_W_label.Visibility = Visibility.Hidden; phone_W_label.Visibility = Visibility.Hidden; both_W_label.Visibility = Visibility.Hidden; cell_W_label.Visibility = Visibility.Hidden; dep_W_label.Visibility = Visibility.Hidden; bool f1 = false, f2 = false, f3 = false, f4 = false, f5 = false, f6 = false, f7 = false, f8 = false; // if (email_textBox1.Text != null) if (!string.IsNullOrWhiteSpace(email_textBox1.Text)) { if ((Regex.IsMatch(this.email_textBox1.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))) { contact_email = email_textBox1.Text; f1 = true; } else { mail_W_label.Content = "אנא בדוק תקינות כתובת האימייל"; mail_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא בדוק תקינות כתובת האימייל"); } } else { contact_email = "לא הוזן"; f1 = true; // mail_W_label.Content = "אנא הכנס כתובת אימייל"; // mail_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס כתובת אימייל"); } if (!string.IsNullOrWhiteSpace(contact_name_textBox.Text)) { contact_name = contact_name_textBox.Text; CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); contact_name = CSQ.checkForSingleQuotationMark(contact_name); f2 = true; } else { name_W_label.Content = "אנא הכנס שם איש קשר"; name_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס שם איש קשר "); } if (!string.IsNullOrWhiteSpace(cont_phone_text.Text)) { try { int phoneCheck = Convert.ToInt32(cont_phone_text.Text); contact_phone = cont_phone_text.Text; f5 = true; } catch { f7 = true; phone_W_label.Content = "מספר הטלפון חייב להכיל מספרים בלבד!"; phone_W_label.Visibility = Visibility.Visible; //MessageBox.Show("!מספר הטלפון חייב להכיל מספרים בלבד"); } } if (!string.IsNullOrWhiteSpace(cell_textBox.Text)) { try { int cellphoneCheck = Convert.ToInt32(cell_textBox.Text); contact_cellphone = cell_textBox.Text; f6 = true; } catch { f8 = true; cell_W_label.Content = "מספר הטלפון נייד חייב להכיל מספרים בלבד!"; cell_W_label.Visibility = Visibility.Visible; //MessageBox.Show("!מספר הטלפון נייד חייב להכיל מספרים בלבד"); } } if (f5 || f6) //user enterd phone and/or cellphone correctly. { if (!f7 && !f8) // if non was wrong. { f3 = true; } } //user did not enterd cellphone and/or phone. if (string.IsNullOrWhiteSpace(cont_phone_text.Text) && string.IsNullOrWhiteSpace(cell_textBox.Text)) { both_W_label.Content = "אנא הכנס מספר טלפון ו/או נייד עבור איש הקשר"; both_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס מספר טלפון ו/או נייד עבור איש הקשר "); } if (!string.IsNullOrWhiteSpace(cont_dep_text.Text)) { contact_dep = cont_dep_text.Text; CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); contact_dep = CSQ.checkForSingleQuotationMark(contact_dep); f4 = true; } else { contact_dep = "לא הוזן"; f4 = true; // dep_W_label.Content = "אנא הכנס מחלקת איש קשר"; // dep_W_label.Visibility = Visibility.Visible; //MessageBox.Show("אנא הכנס מחלקת איש קשר "); } // if all is ok then add new user to the DB. if (f1 && f2 && f3 && f4) { // string query = ("insert into project.costumers (costumerid, costumerName, contactName , contactEmail,contactPhone,costumerAddress,contactDepartment) values ('" + cusid + "','" + custname + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + cusaddress + "','" + contact_dep + "')"); try { MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark(); //MessageBox.Show("" + CostNum_label.Content + ""); string query1 = ("select MAX(contactid) from costumers where costumerid='" + CostNum_label.Content + "'"); MySqlCommand MSQLcrcommand1 = new MySqlCommand(query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); int max = Convert.ToInt32(MSQLcrcommand1.ExecuteScalar()); max++; string name = CostName_label.Content.ToString(); Console.WriteLine(CostName_label.Content); Console.WriteLine(name); // if only phone string query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactPhone,costumerAddress,contactDepartment,costumer_insideNum) values ('" + CostNum_label.Content + "','" + max + "','" + CSQ.checkForSingleQuotationMark(name) + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + CSQ.checkForSingleQuotationMark(cosADDs) + "','" + contact_dep + "','" + cos_num_label.Content + "')"); Console.WriteLine(query); if (!f5 && f6) // if only cell { query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactCellPhone,costumerAddress,contactDepartment,costumer_insideNum) values ('" + CostNum_label.Content + "','" + max + "','" + CSQ.checkForSingleQuotationMark(name) + "','" + contact_name + "','" + contact_email + "','" + contact_cellphone + "','" + CSQ.checkForSingleQuotationMark(cosADDs) + "','" + contact_dep + "','" + cos_num_label.Content + "')"); } if (f5 && f6) // if both { query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactPhone,contactCellPhone,costumerAddress,contactDepartment,costumer_insideNum) values ('" + CostNum_label.Content + "','" + max + "','" + CSQ.checkForSingleQuotationMark(name) + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + contact_cellphone + "','" + CSQ.checkForSingleQuotationMark(cosADDs) + "','" + contact_dep + "','" + cos_num_label.Content + "')"); } //string query = ("insert into project.costumers (costumerid, contactid, costumerName, contactName , contactEmail,contactPhone,costumerAddress,contactDepartment) values ('" + CostNum_label.Content + "','" + max + "','" + CostName_label.Content + "','" + contact_name + "','" + contact_email + "','" + contact_phone + "','" + cosADDs + "','" + contact_dep + "')"); DBConnection DBC = new DBConnection(); DBC.InsertDataIntoDB(Login.Connectionstring, query); contact_name_textBox.Clear(); email_textBox1.Clear(); cont_phone_text.Clear(); cell_textBox.Clear(); cont_dep_text.Clear(); try { MySqlConnection MySqlConn1 = new MySqlConnection(Login.Connectionstring); MySqlConn1.Open(); string Query1 = ("select contactid as `מספר איש קשר`,contactName as `שם איש קשר` ,contactEmail as `אימייל איש קשר` ,contactPhone as `טלפון איש קשר`,contactCellPhone as `טלפון נייד של איש הקשר` ,contactDepartment as `מחלקת איש קשר`, contactDesc as `הערות לגבי איש הקשר` from costumers where costumerid='" + CostNum_label.Content + "'"); MySqlCommand MSQLcrcommand11 = new MySqlCommand(Query1, MySqlConn1); MSQLcrcommand11.ExecuteNonQuery(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand11); SecContactsGUI.dt.Clear(); mysqlDAdp.Fill(SecContactsGUI.dt); mysqlDAdp.Update(SecContactsGUI.dt); MySqlConn1.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }