/// <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;
                    }
                }
            }
        }
예제 #2
0
        // 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);
                }

            }
        }
예제 #3
0
        /// <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);
                }

            }
        }
        // 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);
                    }
                }
        }
예제 #5
0
        //כפתור כניסה
        /// <summary>
        /// Handles the Click event of the button1 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 button1_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (client.Equals(true)) // if this is a remote computer.
                {
                    serverip = this.Host_textBox.Text;
                    Connectionstring = "Server=" + serverip + "; Database=project; UId=root;Password=1234;";
                   // MessageBox.Show("" + Connectionstring +"");
                }
                else if (client.Equals(false)) // // if this is the host computer (the one with the SQL DataBase on it).
                {
                    Connectionstring = "Server=localhost;Database=project; UId=root;Password=1234;";
                }
               // string Connectionstring = " Server=localhost;Database=project; UId=root;Password=1234;";
                MySqlConnection objc = new MySqlConnection(Connectionstring);
                try
                {
                   // MessageBox.Show("ניסיון התחברות");
                    objc.Open();
                   // MessageBox.Show("התחברות הצליחה");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                CheckSingleQuotationMark CSQ = new CheckSingleQuotationMark();
                string pass = this.textBox2.Password;
                Console.WriteLine(pass);
                pass = CSQ.checkForSingleQuotationMark(pass);
                Console.WriteLine("לאחר בדיקת ציטוט בסיסמה");
                Console.WriteLine(pass);
                string Query = "select * from project.users where empid='" + CSQ.checkForSingleQuotationMark(this.textBox1.Text) + "'and password='******'";
                Console.WriteLine("השאילתה הנשלחת בכניסה:");
                Console.WriteLine(Query);
                MySqlCommand crcommand = new MySqlCommand(Query, objc);
                crcommand.ExecuteNonQuery();
                MySqlDataReader dr = crcommand.ExecuteReader();
                int count = 0;
                while (dr.Read())
                {
                    count++;
                    user_role = dr.GetString(2);
                }
                if (count == 1)
                {
                  //  string Connectionstring1 = " Server=localhost;Database=project; UId=root;Password=1234;";
                 //   MySqlConnection objc1 = new MySqlConnection(Connectionstring1);
                    MySqlConnection objc1 = new MySqlConnection(Connectionstring);
                    try
                    {
                        //MessageBox.Show(" 1 ניסיון התחברות");
                        objc1.Open();
                       // MessageBox.Show("התחברות הצליחה 1");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    string Query1 = "SELECT  employees.emp_firstname, employees.emp_lastname, users.connected, users.email FROM project.users, project.employees WHERE users.empid=employees.empid and users.empid='" + this.textBox1.Text + "'and users.password='******'";
                    //MySqlCommand crcommand1 = new MySqlCommand(Query1, objc);
                    MySqlCommand crcommand1 = new MySqlCommand(Query1, objc1);
                    crcommand1.ExecuteNonQuery();
                    MySqlDataReader dr1 = crcommand1.ExecuteReader();
                    int count1 = 0;
                    while (dr1.Read())
                    {
                        count1++;
                        first_name = dr1.GetString(0);
                        first_name1 = first_name;
                        first_name = CSQ.checkForSingleQuotationMark(first_name);
                        last_name = dr1.GetString(1);
                        last_name1 = last_name;
                        last_name = CSQ.checkForSingleQuotationMark(last_name);
                        connected = dr1.GetString(2);
                        useremail = dr1.GetString(3);
                    }
                    //MessageBox.Show(""+connected+"");
                    if (count1 == 1)
                    {
                        if (connected != "מחובר" && connected != "לא מחובר")
                        {
                            MessageBox.Show("קיימת בעיה במצב החיבור שלך, יש לפנות למנהל המערכת  ", " שגיאה", MessageBoxButton.OK,MessageBoxImage.Error);
                        }

                        if (connected.Equals("מחובר"))
                        {
                            MessageBox.Show("אתה כבר מחובר למערכת  ", " שגיאה", MessageBoxButton.OK,MessageBoxImage.Error);
                        }

                        if (connected.Equals("לא מחובר"))
                        {
                            MessageBox.Show("      ברוכ/ה הבא/ה " + Login.last_name1 + " " + Login.first_name1 + "", "!ההתחברות למערכת בוצעה בהצלחה", MessageBoxButton.OK,MessageBoxImage.Information);
                            empid = this.textBox1.Text;
                            string user_connected = "מחובר";
                            //string user_connected = "לא מחובר";

                            if (user_role.Equals("מנהל"))
                            {
                                DBConnection conn = new DBConnection();
                                Console.WriteLine(my_host_name);
                                string query2 = "UPDATE users SET connected='" + user_connected + "',last_log_in_date='" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + "'  ,last_location='" + my_host_name + "' WHERE empid= '" + this.textBox1.Text + "' and password ='******' ";
                                conn.LogIn(query2, Connectionstring);
                                //conn.LogIn(query2);
                                ManagerGui MG = new ManagerGui();
                                MG.Show();
                            }

                            if (user_role.Equals("מזכירה"))
                            {
                                DBConnection conn = new DBConnection();
                                string query2 = "UPDATE users SET connected='" + user_connected + "',last_log_in_date='" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + "' ,last_location='" + my_host_name + "' WHERE empid= '" + this.textBox1.Text + "' and password ='******'";
                                //conn.LogIn(query2);
                                conn.LogIn(query2, Connectionstring);
                                SecretaryGui SG = new SecretaryGui();
                                SG.Show();
                            }

                            if (user_role.Equals("איכות"))
                            {
                                DBConnection conn = new DBConnection();
                                string query2 = "UPDATE users SET connected='" + user_connected + "',last_log_in_date='" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + "' ,last_location='" + my_host_name + "' WHERE empid= '" + this.textBox1.Text + "' and password ='******'";
                               // conn.LogIn(query2);
                                conn.LogIn(query2, Connectionstring);
                                QualityGui QG = new QualityGui();
                                QG.Show();
                            }

                              this.Close();
                          //    MGui.ShowDialog();
                           // this.Close();
                        }

                   //     else
                   //     {
                  //          MessageBox.Show("קיימת בעיה במצב החיבור שלך, יש לפנות למנהל המערכת  ", " שגיאה", MessageBoxButton.OK);
                   //     }
                    }
                    else
                    {
                        MessageBox.Show("!אינך משתמש פעיל במערכת, אנא פנה למנהל", "!ההתחברות למערכת נכשלה", MessageBoxButton.OK,MessageBoxImage.Error);
                        textBox1.Clear();
                        textBox2.Clear();
                    }
                    objc1.Close();
                }
                if (count < 1)
                {
                    MessageBox.Show("שם משתמש ו/או סיסמא שגויים! אנא נסה שנית", "!ההתחברות למערכת נכשלה", MessageBoxButton.OK,MessageBoxImage.Error);
                  //  textBox1.Clear();
                  //  textBox2.Clear();
                }
                objc.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }