private void Button_Click(object sender, RoutedEventArgs e) { try { if (txt_name.Text.Trim() != "" && cbx_owner.SelectedItem != null && txt_phone.Text.Trim() != "" && dp_date.SelectedDate != null && txt_number.Text.Trim() != "") { if (howform) { WorkSQL.sql_p = "select add_company('" + txt_name.Text.Trim() + "','" + cbx_owner.SelectedItem + "','" + txt_phone.Text.Trim() + "','" + ((DateTime)dp_date.SelectedDate).ToString("dd-MM-yyyy") + "','" + txt_number.Text.Trim() + "');"; WorkSQL.ExecuteSQL(); } else { WorkSQL.sql_p = "select update_company('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + txt_name.Text.Trim() + "','" + cbx_owner.SelectedItem + "','" + txt_phone.Text.Trim() + "','" + ((DateTime)dp_date.SelectedDate).ToString("dd-MM-yyyy") + "','" + txt_number.Text.Trim() + "');"; WorkSQL.ExecuteSQL(); } this.Close(); } else { MessageBox.Show("Заполните все поля!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { if (cbx_employee.SelectedItem != null && cbx_department.SelectedItem != null) { if (howform) { WorkSQL.sql_p = "select add_cross('" + cbx_department.SelectedItem + "','" + cbx_employee.SelectedItem + "');"; WorkSQL.ExecuteSQL(); } else { WorkSQL.sql_p = "select update_cross('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + cbx_department.SelectedItem + "','" + cbx_employee.SelectedItem + "');"; WorkSQL.ExecuteSQL(); } this.Close(); } else { MessageBox.Show("Заполните все поля!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Button_Click(object sender, RoutedEventArgs e) { if (cbx_login.SelectedItem != null) { WorkSQL.sql_p = "select drop_user('" + cbx_login.SelectedItem + "')"; WorkSQL.ExecuteSQL(); this.Close(); } else { MessageBox.Show("Заполните все поля!"); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { if (txt_login.Text.Trim() != "" && txt_password.Text.Trim() != "") { if (temp) { if (who) { WorkSQL.sql_p = "select create_user('" + txt_login.Text.Trim().ToLower() + "','" + txt_password.Text.Trim() + "','Tax_Employee');"; WorkSQL.ExecuteSQL(); WorkSQL.sql_p = "select add_users_employee('" + txt_login.Text.Trim().ToLower() + "');"; WorkSQL.ExecuteSQL(); } else { WorkSQL.sql_p = "select create_user('" + txt_login.Text.Trim().ToLower() + "','" + txt_password.Text.Trim() + "','Tax_SuperVisor');"; WorkSQL.ExecuteSQL(); } } else { } temp = false; this.Close(); } else { MessageBox.Show("Заполните все поля!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { if (txt_first.Text.Trim() != "" && txt_second.Text.Trim() != "" && txt_middle.Text.Trim() != "" && dp_date.SelectedDate != null && txt_position.Text.Trim() != "" && txt_salary.Text.Trim() != "" && cbx_education.SelectedItem != null) { if (howform) { WorkSQL.sql_p = "select add_employee('" + txt_first.Text.Trim() + "','" + txt_second.Text.Trim() + "','" + txt_middle.Text.Trim() + "','" + ((DateTime)dp_date.SelectedDate).ToString("dd-MM-yyyy") + "','" + txt_position.Text.Trim() + "','" + txt_salary.Text.Trim() + "','" + cbx_education.SelectedItem + "');"; WorkSQL.ExecuteSQL(); AddUsers au = new AddUsers(true, true); au.ShowDialog(); } else { WorkSQL.sql_p = "select update_employee('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + txt_first.Text.Trim() + "','" + txt_second.Text.Trim() + "','" + txt_middle.Text.Trim() + "','" + ((DateTime)dp_date.SelectedDate).ToString("dd-MM-yyyy") + "','" + txt_position.Text.Trim() + "','" + txt_salary.Text.Trim() + "','" + cbx_education.SelectedItem + "');"; WorkSQL.ExecuteSQL(); } this.Close(); } else { MessageBox.Show("Заполните все поля!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { if (txt_name.Text.Trim() != "") { if (howform) { switch (howhelper) { case 1: WorkSQL.sql_p = "select add_education('" + txt_name.Text.Trim() + "');"; break; case 2: WorkSQL.sql_p = "select add_type('" + txt_name.Text.Trim() + "');"; break; case 3: WorkSQL.sql_p = "select add_title('" + txt_name.Text.Trim() + "');"; break; case 4: WorkSQL.sql_p = "select add_kind('" + txt_name.Text.Trim() + "');"; break; case 5: WorkSQL.sql_p = "select add_owner_ship('" + txt_name.Text.Trim() + "');"; break; } WorkSQL.ExecuteSQL(); } else { switch (howhelper) { case 1: WorkSQL.sql_p = "select update_education('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + txt_name.Text.Trim() + "');"; break; case 2: WorkSQL.sql_p = "select update_type('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + txt_name.Text.Trim() + "');"; break; case 3: WorkSQL.sql_p = "select update_title('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + txt_name.Text.Trim() + "');"; break; case 4: WorkSQL.sql_p = "select update_kind('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + txt_name.Text.Trim() + "');"; break; case 5: WorkSQL.sql_p = "select update_owner_ship('" + WorkSQL.drv_p.Row.ItemArray[0] + "','" + txt_name.Text.Trim() + "');"; break; } WorkSQL.ExecuteSQL(); } this.Close(); } else { MessageBox.Show("Заполните все поля!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }