private void BtSave_Click(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Employee_Insert = new ArrayList();
if (gridwork.NullCheck(tbs) == 0)
{
if (tbPassword.Text == tbConfernPassword.Text)
{
Cyphering cyph = new Cyphering();
string logCyph = Cyphering.Code_Message(tbLogin.Text);
string passCyph = Cyphering.Code_Message(tbPassword.Text);
Employee_Insert.Add(logCyph);
Employee_Insert.Add(passCyph);
Employee_Insert.Add(tbName.Text);
Employee_Insert.Add(tbMiddle_Name.Text);
Employee_Insert.Add(tbFirst_Name.Text);
Employee_Insert.Add(Convert.ToInt32(tbPosition.SelectedValue));
procedure.procedure_Execution("Employee_Insert", Employee_Insert);
}
else
{
MessageBox.Show("Не верный пароль", "", MessageBoxButtons.OK);
}
}
tbConfernPassword.Clear();
tbPassword.Clear();
MessageBox.Show("Успешная регистрация", "", MessageBoxButtons.OK);
this.Close();
}
private void BtSave_Click(object sender, EventArgs e)
{
//Объявление экземпляра класса работы с хранимыми процедурами
Procedure_Class procedure = new Procedure_Class();
//Объявляем не типизированный лист
ArrayList Employee_Update = new ArrayList();
Employee_Update.Add(Program.intID);
//Проверка заполнения плей ввода данных
if (gridwork.NullCheck(tbs) == 0)
{
if (tbPassword.Text == tbConfernPassword.Text)
{
Cyphering cyph = new Cyphering();
string logCyph = Cyphering.Code_Message(tbLogin.Text);
string passCyph = Cyphering.Code_Message(tbPassword.Text);
Employee_Update.Add(logCyph);
Employee_Update.Add(passCyph);
Employee_Update.Add(tbName.Text);
Employee_Update.Add(tbMiddle_Name.Text);
Employee_Update.Add(tbFirst_Name.Text);
Employee_Update.Add(Convert.ToInt32(tbPosition.SelectedValue));
procedure.procedure_Execution("Employee_Update", Employee_Update);
}
else
{
MessageBox.Show("Не правильный пароль", "", MessageBoxButtons.OK);
}
}
tbConfernPassword.Clear();
tbPassword.Clear();
}
private void Button2_Click(object sender, EventArgs e)
{
ArrayList ar = new ArrayList();
int ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
ar.Add(ID);
Procedure_Class proc = new Procedure_Class();
proc.procedure_Execution("Storage_Delete", ar);
dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
gridFill();
}
private void Button4_Click_1(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Logical_delete_Klient = new ArrayList();
Program.intID = dataGridView1.CurrentCell.RowIndex.ToString();
Logical_delete_Klient.Add(Program.intID);
Logical_delete_Klient.Add(textBoxDelete.Text);
procedure.procedure_Execution("Logical_delete_Klient", Logical_delete_Klient);
DgFill();
}
private void Button1_Click(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Insert = new ArrayList();
if (gridwork.NullCheck(tbs) == 0)
{
Insert.Add(tbType.Text);
procedure.procedure_Execution("Type_of_Product_Insert", Insert);
gridFill();
}
}
private void Button1_Click(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Insert = new ArrayList();
if (gridwork.NullCheck(tbs) == 0)
{
Insert.Add(Convert.ToInt32(cbClient.SelectedValue));
Insert.Add(Convert.ToInt32(cbEmployee.SelectedValue));
procedure.procedure_Execution("Work_Client_Insert", Insert);
gridFill();
}
}
private void Button1_Click(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Insert = new ArrayList();
if (gridwork.NullCheck(tbs) == 0)
{
Insert.Add(tbName.Text);
Insert.Add(tbMiddlename.Text);
Insert.Add(tbLastname.Text);
Insert.Add(Convert.ToInt32(tbDiscount.Text));
procedure.procedure_Execution("Client_Insert", Insert);
gridFill();
}
}
private void Button4_Click(object sender, EventArgs e)
{
ArrayList ar = new ArrayList();
int ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
ar.Add(ID);
Procedure_Class proc = new Procedure_Class();
if (gridwork.NullCheck(tbs) == 0)
{
ar.Add(tbType.Text);
proc.procedure_Execution("Type_of_Product_Update", ar);
}
gridFill();
}
private void Button1_Click(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Position_Insert = new ArrayList();
if (gridwork.NullCheck(tbs) == 1)
{
Position_Insert.Add(tbName.Text);
Position_Insert.Add(tbAmount.Text);
Position_Insert.Add(tbPrice.Text);
Position_Insert.Add(Convert.ToInt32(cbType.SelectedValue));
Position_Insert.Add(tbName.Text);
procedure.procedure_Execution("Product_Insert", Position_Insert);
gridFill();
}
}
private void Button1_Click(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Insert = new ArrayList();
if (gridwork.NullCheck(tbs) == 0)
{
Insert.Add(tbAmount.Text);
Insert.Add(Convert.ToInt32(tbCheck.Text));
Insert.Add(Convert.ToInt32(tbCash.Text));
Insert.Add(Convert.ToInt32(cbProduct.SelectedValue));
Insert.Add(Convert.ToInt32(cbClient.SelectedValue));
procedure.procedure_Execution("Purchase_Insert", Insert);
gridFill();
}
}
private void Button1_Click(object sender, EventArgs e)
{
Procedure_Class procedure = new Procedure_Class();
ArrayList Position_Insert = new ArrayList();
if (textBox1.Text != "")
{
Position_Insert.Add(textBox1.Text);
procedure.procedure_Execution("Position_Insert", Position_Insert);
gridFill();
}
else
{
textBox1.BackColor = Color.Red;
}
}
private void Button4_Click(object sender, EventArgs e)
{
ArrayList ar = new ArrayList();
int ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
ar.Add(ID);
Procedure_Class proc = new Procedure_Class();
if (gridwork.NullCheck(tbs) == 0)
{
ar.Add(Convert.ToInt32(cbClient.SelectedValue));
ar.Add(Convert.ToInt32(cbEmployee.SelectedValue));
proc.procedure_Execution("Work_Client_Update", ar);
}
gridFill();
}
