private void ingr_s_sklad_Load()
{
_PB.Set_Connection();
_PB.Connection.Open();
_Viv.vivod_ingr_s_sklada();
dataGridView1.DataSource = Program.VivodSkladSIngr;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
_PB.Connection.Close();
}
private void rekvizit_load()
{
_PB.Set_Connection();
_PB.Connection.Open();
_Viv.vivod_rekvizit();
dataGridView1.DataSource = Program.VivodRekvizit;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
_PB.Connection.Close();
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
_PB.Set_Connection();
_PB.Connection.Open();
_Viv.vivod_pizza();
dataGridView1.DataSource = Program.VivodPizzaVEda;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
zakaz_vibor = 1;
dataGridView1.Columns[0].Visible = false;
_PB.Connection.Close();
}
public void Vhod(string password_BD)
{
try
{
_PB = new Podkl_Bazi();
_PB.Set_Connection();
_ComandaSQL = new SqlCommand(id_identificator + password_BD + "'", _PB.Connection);
_PB.Connection.Open();
Program.identificator = Convert.ToInt32(_ComandaSQL.ExecuteScalar().ToString());
switch (Program.identificator)
{
case (0):
MessageBox.Show("У вас нет доступа к этой системе!");
break;
default:
_PB = new Podkl_Bazi();
_PB.Set_Connection();
_PB.Connection.Open();
Program.Systemaccess = Convert.ToInt32(_ComandaSQL.ExecuteScalar().ToString());
SqlCommand PassSotrCmd = new SqlCommand(Password + Program.identificator, _PB.Connection);
SqlCommand ProgAccessCmd = new SqlCommand(Prog_access + Program.identificator, _PB.Connection);
SqlCommand IngridientsAccessCmd = new SqlCommand(Ingridients_access + Program.identificator, _PB.Connection);
SqlCommand EdaAccessCmd = new SqlCommand(Eda_access + Program.identificator, _PB.Connection);
SqlCommand SotrudnikiAccessCmd = new SqlCommand(Sotrudniki_access + Program.identificator, _PB.Connection);;
SqlCommand KlientsAccessCmd = new SqlCommand(Klients_access + Program.identificator, _PB.Connection);;
SqlCommand RekvizitAccessCmd = new SqlCommand(Rekvezit_access + Program.identificator, _PB.Connection);;
SqlCommand ZakazVZaleCmd = new SqlCommand(Zakaz_V_Zale_access + Program.identificator, _PB.Connection);;
SqlCommand ZakazNaDostCmd = new SqlCommand(Zakaz_Na_dost_access + Program.identificator, _PB.Connection);
SqlCommand AdminAccessCmd = new SqlCommand(Admin_access + Program.identificator, _PB.Connection);
Program.ProgAccess = Convert.ToInt32(ProgAccessCmd.ExecuteScalar().ToString());
Program.IngridientsAccess = Convert.ToInt32(IngridientsAccessCmd.ExecuteScalar().ToString());
Program.EdaAccess = Convert.ToInt32(EdaAccessCmd.ExecuteScalar().ToString());
Program.SotrudnikiAccess = Convert.ToInt32(SotrudnikiAccessCmd.ExecuteScalar().ToString());
Program.KlientsAccess = Convert.ToInt32(KlientsAccessCmd.ExecuteScalar().ToString());
Program.RekvizitAccess = Convert.ToInt32(RekvizitAccessCmd.ExecuteScalar().ToString());
Program.ZakazVZale = Convert.ToInt32(ZakazVZaleCmd.ExecuteScalar().ToString());
Program.ZakazNaDost = Convert.ToInt32(ZakazNaDostCmd.ExecuteScalar().ToString());
Program.AdminAccess = Convert.ToInt32(AdminAccessCmd.ExecuteScalar().ToString());
Program.Value = true;
_PB.Connection.Close();
break;
}
_PB.Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Sotrudnikik_load()
{
_PB.Set_Connection();
_PB.Connection.Open();
_Viv.vivod_sotrudnik_obj();
dataGridView1.DataSource = Program.VivodSotrobj;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView1.Columns[0].Visible = false;
if (Program.AdminAccess == 1)
{
dataGridView1.Columns[5].Visible = true;
dataGridView1.Columns[6].Visible = true;
dataGridView1.Columns[7].Visible = true;
dataGridView1.Columns[8].Visible = true;
dataGridView1.Columns[9].Visible = true;
dataGridView1.Columns[10].Visible = true;
dataGridView1.Columns[11].Visible = true;
dataGridView1.Columns[12].Visible = true;
dataGridView1.Columns[13].Visible = true;
dataGridView1.Columns[14].Visible = true;
}
else
{
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[11].Visible = false;
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[13].Visible = false;
dataGridView1.Columns[14].Visible = false;
}
_PB.Connection.Close();
}
private void grid_Load()
{
_PB.Set_Connection();
_PB.Connection.Open();
_V.vivod_sotr();
dataGridView1.DataSource = Program.Vivodklients;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView1.Columns[0].Visible = false;
_PB.Connection.Close();
if (Program.AdminAccess == 1)
{
button2.Enabled = true;
}
}
private void button1_Click(object sender, EventArgs e)
{
_PB.Set_Connection();
_PB.Connection.Open();
_V.vivod_eda();
dataGridView1.DataSource = Program.VivodEdaVEda;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView1.Columns[0].Visible = false;
eda_vibor = 1;
_PB.Connection.Close();
}
public void Klient_add(string FamValue, string ImValue, string OtchValue, string TelValue, string AdresValue)
{
_PB.Set_Connection();
_PB.Connection.Open();
SqlCommand Klient_add = new SqlCommand("Klient_add", _PB.Connection);
Klient_add.CommandType = CommandType.StoredProcedure;
Klient_add.Parameters.AddWithValue("@Fam_Klient", FamValue);
Klient_add.Parameters.AddWithValue("@Im_Klient", ImValue);
Klient_add.Parameters.AddWithValue("@Otch_Klient", OtchValue);
Klient_add.Parameters.AddWithValue("@Tel_Klient", TelValue);
Klient_add.Parameters.AddWithValue("@Adres_Klient", AdresValue);
Klient_add.ExecuteNonQuery();
_PB.Connection.Close();
}
public void vivod_sotr()
{
_PB.Set_Connection();
_PB.Connection.Open();
SqlCommand pizza1 = new SqlCommand("Select id_Klient,Fam_Klient as 'Фамилия клиента', Im_Klient as 'Имя клиента', Otch_Klient as 'Отчество клиента', Tel_Klient as 'Телефон клиента', Adres_Klient as 'Адрес клиента' from [dbo].[Klient]", _PB.Connection);
SqlDataReader TableReader = pizza1.ExecuteReader();
DataTable Table = new DataTable();
Table.Load(TableReader);
Program.Vivodklients = Table;
_PB.Connection.Close();
}