public AddCompany(bool temp)
{
try
{
InitializeComponent();
howform = temp;
WorkSQL.sql_p = "select \"Форма собственности\" from show_owner_ship";
cbx_owner.ItemsSource = WorkSQL.ConvertQueryToComboBox();
if (howform)
{
mainwin.Title = "Добавить предприятие";
btn_add.Content = "Добавить";
}
else
{
mainwin.Title = "Изменить предприятие";
btn_add.Content = "Изменить";
txt_name.Text = WorkSQL.drv_p.Row.ItemArray[1].ToString();
cbx_owner.SelectedItem = WorkSQL.drv_p.Row.ItemArray[2];
txt_phone.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString();
dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[4];
txt_number.Text = WorkSQL.drv_p.Row.ItemArray[5].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public AddCross(bool temp)
{
try
{
InitializeComponent();
howform = temp;
WorkSQL.sql_p = "select Номер from show_department";
cbx_department.ItemsSource = WorkSQL.ConvertQueryToComboBox();
WorkSQL.sql_p = "select Номер from show_employee";
cbx_employee.ItemsSource = WorkSQL.ConvertQueryToComboBox();
if (howform)
{
mainwin.Title = "Добавить распределение";
btn_add.Content = "Добавить";
}
else
{
mainwin.Title = "Изменить распределение";
btn_add.Content = "Изменить";
cbx_department.Text = WorkSQL.drv_p.Row.ItemArray[1].ToString();
cbx_employee.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public AddEmployee(bool temp)
{
try
{
InitializeComponent();
howform = temp;
WorkSQL.sql_p = "select Образование from show_education";
cbx_education.ItemsSource = WorkSQL.ConvertQueryToComboBox();
if (howform)
{
mainwin.Title = "Добавить сотрудника";
btn_add.Content = "Добавить";
}
else
{
mainwin.Title = "Изменить сотрудника";
btn_add.Content = "Изменить";
txt_first.Text = WorkSQL.drv_p.Row.ItemArray[1].ToString();
txt_second.Text = WorkSQL.drv_p.Row.ItemArray[2].ToString();
txt_middle.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString();
dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[4];
txt_position.Text = WorkSQL.drv_p.Row.ItemArray[5].ToString();
txt_salary.Text = WorkSQL.drv_p.Row.ItemArray[6].ToString();
cbx_education.SelectedItem = WorkSQL.drv_p.Row.ItemArray[7];
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public AddDepartment(bool temp)
{
try
{
InitializeComponent();
howform = temp;
WorkSQL.sql_p = "select Название from show_title";
cbx_title.ItemsSource = WorkSQL.ConvertQueryToComboBox();
WorkSQL.sql_p = "select Тип from show_type";
cbx_type.ItemsSource = WorkSQL.ConvertQueryToComboBox();
if (howform)
{
mainwin.Title = "Добавить отделение";
btn_add.Content = "Добавить";
}
else
{
mainwin.Title = "Изменить отделение";
btn_add.Content = "Изменить";
cbx_title.SelectedItem = WorkSQL.drv_p.Row.ItemArray[1];
cbx_type.SelectedItem = WorkSQL.drv_p.Row.ItemArray[2];
dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[3];
txt_phone.Text = WorkSQL.drv_p.Row.ItemArray[4].ToString();
txt_address.Text = WorkSQL.drv_p.Row.ItemArray[5].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public AddPayment(bool temp)
{
try
{
InitializeComponent();
howform = temp;
WorkSQL.sql_p = "select Вид from show_kind";
cbx_kind.ItemsSource = WorkSQL.ConvertQueryToComboBox();
WorkSQL.sql_p = "select Номер from show_company";
cbx_company.ItemsSource = WorkSQL.ConvertQueryToComboBox();
WorkSQL.sql_p = "select department_code from show_available('" + WorkSQL.login_p + "');";
cbx_department.ItemsSource = WorkSQL.ConvertQueryToComboBox();
if (howform)
{
mainwin.Title = "Добавить платёж";
btn_add.Content = "Добавить";
}
else
{
mainwin.Title = "Изменить платёж";
btn_add.Content = "Изменить";
cbx_kind.SelectedItem = WorkSQL.drv_p.Row.ItemArray[1];
dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[2];
txt_amount.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString();
cbx_company.SelectedItem = WorkSQL.drv_p.Row.ItemArray[6].ToString();
cbx_department.SelectedItem = WorkSQL.drv_p.Row.ItemArray[5].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DeleteUsers()
{
InitializeComponent();
WorkSQL.sql_p = "select select_all_users_from_group('Tax_SuperVisor')";
cbx_login.ItemsSource = WorkSQL.ConvertQueryToComboBox();
}
