private void btnDel_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Вы дeйствительно хотите удалить данные?", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
ConnectSDO sdo = new ConnectSDO();
sqlcom = new SqlCommand("spDelYearPlan", sdo.getConnectSDO());
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.AddWithValue("@Id", SqlDbType.Int).Value = Convert.ToInt32(dgvPlanEvent.Rows[dgvPlanEvent.CurrentRow.Index].Cells[0].Value);
sdo.OpenConnection();
sqlcom.ExecuteNonQuery();
MessageBox.Show("Мероприятие удалено!");
sdo.CloseConnection();
vwEvent();
}
catch (Exception)
{
MessageBox.Show("Не удалось удалить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Отмена", "Отмена удаления", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void spUnit(int Id, string Categ)
{
ConnectSDO sdo = new ConnectSDO();
SqlCommand sqlcom2 = new SqlCommand("spAddYearUnit", sdo.getConnectSDO());
sqlcom2.CommandType = CommandType.StoredProcedure;
sqlcom2.Parameters.AddWithValue("@CategoryU", SqlDbType.NVarChar).Value = Categ;
sqlcom2.Parameters.AddWithValue("@IdE", SqlDbType.Int).Value = Id;
sdo.OpenConnection();
sqlcom2.ExecuteNonQuery();
sdo.CloseConnection();
}
private void btnSearch_Click(object sender, EventArgs e)
{
btnList.Visible = true;
ConnectSDO sdo = new ConnectSDO();
sdo.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT * FROM vwEventt WHERE [Дата проведения] = ' " + dtpEvent.Value.ToString("yyy-MM-dd") + "'", sdo.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
sdo.CloseConnection();
dgvEvent.DataSource = datTab;
}
public void spQtyUnit(int Id, int Qty, string NameUnit, string Name, string Categ)
{
ConnectSDO sdo = new ConnectSDO();
SqlCommand sqlcom2 = new SqlCommand("spAddAssignQty", sdo.getConnectSDO());
sqlcom2.CommandType = CommandType.StoredProcedure;
sqlcom2.Parameters.AddWithValue("@IdU", SqlDbType.Int).Value = Id;
sqlcom2.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = Name;
sqlcom2.Parameters.AddWithValue("@NameUnit", SqlDbType.NVarChar).Value = NameUnit;
sqlcom2.Parameters.AddWithValue("@Qty", SqlDbType.Int).Value = Qty;
sqlcom2.Parameters.AddWithValue("@Category", SqlDbType.NVarChar).Value = Categ;
sdo.OpenConnection();
sqlcom2.ExecuteNonQuery();
sdo.CloseConnection();
}
public void vwInfEventt2(int a)
{
try
{
dgvInfYP.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvInfYP.AllowUserToAddRows = false;
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT * FROM vwYearPlan1 WHERE IdE = " + a, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
dgvInfYP.DataSource = datTab;
dgvInfYP.Columns[0].Visible = false;
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public int vwIdUnit()
{
ConnectSDO sdo = new ConnectSDO();
sdo.OpenConnection();
sqlcom = new SqlCommand("SELECT MAXId FROM vwMaxIdUn", sdo.getConnectSDO());
sqlcom.ExecuteNonQuery();
SqlDataAdapter adap = new SqlDataAdapter(sqlcom);
datTab = new DataTable();
adap.Fill(datTab);
int a = 0;
foreach (DataRow DR in datTab.Rows)
{
a = Convert.ToInt32(DR["MAXId"].ToString());
}
sdo.CloseConnection();
return(a);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (tbNameEvent.Text.Length > 0 && cmbStatusEvent.Text != "")
{
try
{
if (tbNameEvent.Text.Length > 0 && cmbStatusEvent.Text.Length > 0)
{
ConnectSDO sdo = new ConnectSDO();
SqlCommand sqlcom2 = new SqlCommand("spAddEventt", sdo.getConnectSDO());
sqlcom2.CommandType = CommandType.StoredProcedure;
sqlcom2.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = tbNameEvent.Text.Trim();
sqlcom2.Parameters.AddWithValue("@Status", SqlDbType.NVarChar).Value = cmbStatusEvent.Text.Trim();
sqlcom2.Parameters.AddWithValue("@DataFirst", SqlDbType.DateTime).Value = mcEvent.SelectionRange.Start;
sqlcom2.Parameters.AddWithValue("@IdYP", SqlDbType.Int).Value = Idyp;
sdo.OpenConnection();
sqlcom2.ExecuteNonQuery();
sdo.CloseConnection();
}
else
{
MessageBox.Show("Не удалось добавить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
int Event = vwIdEvent();
if (cmbStatusQtyEvent1.Text.Length > 0)
{
string CategU = cmbStatusQtyEvent1.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEventAllP.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEventAllP.Text);
string NameUnit = cmbStatusQtyEvent1.Text;
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEventAllB.Text);
string NameUnit1 = cmbStatusQtyEvent1.Text;
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1);
int Qty2 = Int32.Parse(tbUnitAllP.Text);
string NameUnit2 = cmbStatusQtyEvent1.Text;
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2);
int Qty3 = Int32.Parse(tbUnitAllB.Text);
string NameUnit3 = cmbStatusQtyEvent1.Text;
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3);
int Qty6 = Int32.Parse(tbAllPlayer.Text);
string NameUnit6 = cmbStatusQtyEvent1.Text;
string Name6 = lblParticial.Text;
string Category6 = lblB.Text;
spQtyUnit(IdU, Qty6, NameUnit6, Name6, Category6);
}
}
if (cmbgr1.Text.Length > 0)
{
//string CategU = cmbgr1.Text;
int EventU = Event;
//spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP1.Text.Length >= 0 && tbEvB1.Text.Length >= 0 && tbpgr1.Text.Length >= 0 && tbPBgr1.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP1.Text);
string NameUnit = cmbgr1.Text;
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB1.Text);
string NameUnit1 = cmbgr1.Text;
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr1.Text);
string NameUnit2 = cmbgr1.Text;
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr1.Text);
string NameUnit3 = cmbgr1.Text;
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3);
int Qty6 = Int32.Parse(tbPlayer1.Text);
string NameUnit4 = cmbgr1.Text;
string Name6 = lblParticial.Text;
string Category6 = lblB.Text;
spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr2.Text.Length > 0)
{
//string CategU = cmbgr2.Text;
int EventU = Event;
//spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP2.Text.Length >= 0 && tbEvB2.Text.Length >= 0 && tbpgr2.Text.Length >= 0 && tbPBgr2.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP2.Text);
string NameUnit = cmbgr2.Text;
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB2.Text);
string NameUnit1 = cmbgr2.Text;
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr2.Text);
string NameUnit2 = cmbgr2.Text;
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr2.Text);
string NameUnit3 = cmbgr2.Text;
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3);
int Qty6 = Int32.Parse(tbPlayer2.Text);
string NameUnit4 = cmbgr2.Text;
string Name6 = lblParticial.Text;
string Category6 = lblB.Text;
spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr3.Text.Length > 0)
{
//string CategU = cmbgr3.Text;
int EventU = Event;
//spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP3.Text.Length >= 0 && tbEvB3.Text.Length >= 0 && tbpgr3.Text.Length >= 0 && tbPBgr3.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP3.Text);
string NameUnit = cmbgr3.Text;
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB3.Text);
string NameUnit1 = cmbgr3.Text;
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr3.Text);
string NameUnit2 = cmbgr3.Text;
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr3.Text);
string NameUnit3 = cmbgr3.Text;
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3);
int Qty6 = Int32.Parse(tbPlayer3.Text);
string NameUnit4 = cmbgr3.Text;
string Name6 = lblParticial.Text;
string Category6 = lblB.Text;
spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr4.Text.Length > 0)
{
//string CategU = cmbgr4.Text;
int EventU = Event;
//spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP4.Text.Length >= 0 && tbEvB4.Text.Length >= 0 && tbpgr4.Text.Length >= 0 && tbPBgr4.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP4.Text);
string NameUnit = cmbgr4.Text;
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB4.Text);
string NameUnit1 = cmbgr4.Text;
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr4.Text);
string NameUnit2 = cmbgr4.Text;
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr4.Text);
string NameUnit3 = cmbgr4.Text;
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3);
int Qty6 = Int32.Parse(tbPlayer4.Text);
string NameUnit4 = cmbgr4.Text;
string Name6 = lblParticial.Text;
string Category6 = lblB.Text;
spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr5.Text.Length > 0)
{
//string CategU = cmbgr5.Text;
int EventU = Event;
//spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP5.Text.Length >= 0 && tbEvB5.Text.Length >= 0 && tbpgr5.Text.Length >= 0 && tbPBgr5.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP5.Text);
string NameUnit = cmbgr5.Text;
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB5.Text);
string NameUnit1 = cmbgr5.Text;
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr5.Text);
string NameUnit2 = cmbgr5.Text;
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr5.Text);
string NameUnit3 = cmbgr5.Text;
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3);
int Qty6 = Int32.Parse(tbPlayer5.Text);
string NameUnit4 = cmbgr5.Text;
string Name6 = lblParticial.Text;
string Category6 = lblB.Text;
spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
MessageBox.Show(" Mероприятие добавлено!");
}
catch (Exception)
{
MessageBox.Show("Не удалось добавить мероприятие!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ClearTB();
}
else
{
MessageBox.Show("Заполните название мероприятия или выберите статус!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (Int32.Parse(tbEventSUM.Text) > 0 && Int32.Parse(tbUnitSUM.Text) > 0)
{
try
{
if (tbEvent.Text.Length > 0 && cmbStatusEvent.Text.Length > 0)
{
ConnectSDO sdo = new ConnectSDO();
SqlCommand sqlcom2 = new SqlCommand("spAddYearPlan", sdo.getConnectSDO());
sqlcom2.CommandType = CommandType.StoredProcedure;
sqlcom2.Parameters.AddWithValue("@DataEnd", SqlDbType.DateTime).Value = mcEndEvent.SelectionRange.Start;
sqlcom2.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = tbEvent.Text.Trim();
sqlcom2.Parameters.AddWithValue("@Status", SqlDbType.NVarChar).Value = cmbStatusEvent.Text.Trim();
sqlcom2.Parameters.AddWithValue("@DataFirst", SqlDbType.DateTime).Value = mcDataEvent.SelectionRange.Start;
sdo.OpenConnection();
sqlcom2.ExecuteNonQuery();
sdo.CloseConnection();
}
else
{
MessageBox.Show("Не удалось добавить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
int Event = vwIdEvent();
if (cmbStatusQtyEvent1.Text.Length > 0)
{
string CategU = cmbStatusQtyEvent1.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEventAllP.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEventAllP.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEventAllB.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbUnitAllP.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbUnitAllB.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr1.Text.Length > 0)
{
string CategU = cmbgr1.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP1.Text.Length >= 0 && tbEvB1.Text.Length >= 0 && tbpgr1.Text.Length >= 0 && tbPBgr1.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP1.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB1.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr1.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr1.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr2.Text.Length > 0)
{
string CategU = cmbgr2.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP2.Text.Length >= 0 && tbEvB2.Text.Length >= 0 && tbpgr2.Text.Length >= 0 && tbPBgr2.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP2.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB2.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr2.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr2.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr3.Text.Length > 0)
{
string CategU = cmbgr3.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP3.Text.Length >= 0 && tbEvB3.Text.Length >= 0 && tbpgr3.Text.Length >= 0 && tbPBgr3.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP3.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB3.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr3.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr3.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbgr4.Text.Length > 0)
{
string CategU = cmbgr4.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEvP4.Text.Length >= 0 && tbEvB4.Text.Length >= 0 && tbpgr4.Text.Length >= 0 && tbPBgr4.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEvP4.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEvB4.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbpgr4.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr4.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbStatusQtyEventt2.Text.Length > 0)
{
string CategU = cmbStatusQtyEventt2.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEventAllP2.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEventAllP2.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEventAllB2.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbUnitAllP2.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbUnitAllB2.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbGR21.Text.Length > 0)
{
string CategU = cmbGR21.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEventP21.Text.Length >= 0 && tbEventB21.Text.Length >= 0 && tbPgr21.Text.Length >= 0 && tbPBgr21.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEventP21.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEventB21.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbPgr21.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr21.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbGR22.Text.Length > 0)
{
string CategU = cmbGR22.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEventP22.Text.Length >= 0 && tbEventB22.Text.Length >= 0 && tbPgr22.Text.Length >= 0 && tbPBgr22.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEventP22.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEventB22.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbPgr22.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr22.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbGR23.Text.Length > 0)
{
string CategU = cmbGR23.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEventP23.Text.Length >= 0 && tbEventB23.Text.Length >= 0 && tbPgr23.Text.Length >= 0 && tbPBgr23.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEventP23.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEventB23.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbPgr23.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr23.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (cmbGR24.Text.Length > 0)
{
string CategU = cmbGR24.Text;
int EventU = Event;
spUnit(Event, CategU);
int Iduu = vwIdUnit();
if (tbEventP24.Text.Length >= 0 && tbEventB24.Text.Length >= 0 && tbPgr24.Text.Length >= 0 && tbPBgr24.Text.Length >= 0)
{
int IdU = Iduu;
int QtyU = Int32.Parse(tbEventP24.Text);
string NameU = lblEvent.Text;
string CategoryU = lblP.Text;
spQtyUnit(IdU, QtyU, NameU, CategoryU);
int Qty1 = Int32.Parse(tbEventB24.Text);
string Name1 = lblEvent.Text;
string Category1 = lblB.Text;
spQtyUnit(IdU, Qty1, Name1, Category1);
int Qty2 = Int32.Parse(tbPgr24.Text);
string Name2 = lblPeople.Text;
string Category2 = lblP.Text;
spQtyUnit(IdU, Qty2, Name2, Category2);
int Qty3 = Int32.Parse(tbPBgr24.Text);
string Name3 = lblPeople.Text;
string Category3 = lblB.Text;
spQtyUnit(IdU, Qty3, Name3, Category3);
}
else
{
MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
MessageBox.Show("Годовое мероприятие добавлено!");
this.Hide();
MainForm m = new MainForm();
m.Show();
}
catch (Exception)
{
MessageBox.Show("Не удалось добавить мероприятие!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void SumEvent(int IdYP)
{
int Id = IdYP;
int[] Event;
int sum = 0;
Event = new int[dgvEvent.RowCount];
for (int i = 0; i < dgvEvent.RowCount; i++)
{
Event[i] = Convert.ToInt32(dgvEvent[6, i].Value.ToString());
//MessageBox.Show(dgvEventt3[1, i].Value.ToString());
}
foreach (var num in Event)
{
sum += num;
}
tbPassedEvent.Text = Convert.ToString(sum);
if (tbPassedEvent.Text != "")
{
int a = Convert.ToInt32(tbTotalEvent.Text);
int b = Convert.ToInt32(tbPassedEvent.Text);
int d = SUMTotal(a, b);
lblEvFull.Text = Convert.ToString(d);
}
int[] EventPeop;
int sum2 = 0;
EventPeop = new int[dgvEvent.RowCount];
for (int i = 0; i < dgvEvent.RowCount; i++)
{
EventPeop[i] = Convert.ToInt32(dgvEvent[7, i].Value.ToString());
//MessageBox.Show(dgvEventt3[1, i].Value.ToString());
}
foreach (var num1 in EventPeop)
{
sum2 += num1;
}
tbPassedPeople.Text = Convert.ToString(sum2);
if (tbPassedPeople.Text != "")
{
int a = Convert.ToInt32(tbTotalPeople.Text);
int b = Convert.ToInt32(tbPassedPeople.Text);
int d = SUMTotal(a, b);
lblPepFull.Text = Convert.ToString(d);
}
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwEventP WHERE YearPlanId =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbEventPPas.Text = (DR["SUMALL"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwEventB WHERE YearPlanId =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbEventBPas.Text = (DR["SUMALL"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwPeopP WHERE YearPlanId =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbPepPPas.Text = (DR["SUMALL"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwPeopB WHERE YearPlanId =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbPepPasB.Text = (DR["SUMALL"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwPalyear WHERE YearPlanId =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbPlayer.Text = (DR["SUMALL"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void TBSet(int [] EventYear1, int [] EventYear2)
{
int IPEventP = EventYear2[0];
int IPEventB = EventYear2[1];
int IPPeopP = EventYear2[2];
int IPPeopB = EventYear2[3];
int KDEventP = EventYear2[4];
int KDEventB = EventYear2[5];
int KDPeopP = EventYear2[6];
int KDPeopB = EventYear2[7];
tbIPEventAllP.Text = Convert.ToString(IPEventP);
tbIPEventAllB.Text = Convert.ToString(IPEventB);
tbIPPeopAllP.Text = Convert.ToString(IPPeopP);
tbIPPeopAllB.Text = Convert.ToString(IPPeopB);
tbKDEventtAllP.Text = Convert.ToString(KDEventP);
tbKDEventtAllB.Text = Convert.ToString(KDEventB);
tbKDPeopP.Text = Convert.ToString(KDPeopP);
tbKDPeopB.Text = Convert.ToString(KDPeopB);
int P1 = EventYear1[0];
int B1 = EventYear1[1];
int P2 = EventYear1[2];
int B2 = EventYear1[3];
int P3 = EventYear1[4];
int B3 = EventYear1[5];
int P4 = EventYear1[6];
int B4 = EventYear1[7];
int P5 = EventYear1[8];
int B5 = EventYear1[9];
int P6 = EventYear1[10];
int B6 = EventYear1[11];
int P7 = EventYear1[12];
int B7 = EventYear1[13];
int P8 = EventYear1[14];
int B8 = EventYear1[15];
tbP1.Text = Convert.ToString(P1);
tbB1.Text = Convert.ToString(B1);
tbP2.Text = Convert.ToString(P2);
tbB2.Text = Convert.ToString(B2);
tbP3.Text = Convert.ToString(P3);
tbB3.Text = Convert.ToString(B3);
tbP4.Text = Convert.ToString(P4);
tbB4.Text = Convert.ToString(B4);
tbP5.Text = Convert.ToString(P5);
tbB5.Text = Convert.ToString(B5);
tbP6.Text = Convert.ToString(P6);
tbB6.Text = Convert.ToString(B6);
tbP7.Text = Convert.ToString(P7);
tbB7.Text = Convert.ToString(B7);
tbP8.Text = Convert.ToString(P8);
tbB8.Text = Convert.ToString(B8);
int P9 = EventYear1[16];
int B9 = EventYear1[17];
int P10 = EventYear1[18];
int B10 = EventYear1[19];
int P11 = EventYear1[20];
int B11 = EventYear1[21];
int P12 = EventYear1[22];
int B12 = EventYear1[23];
int P13 = EventYear1[24];
int B13 = EventYear1[25];
int P14 = EventYear1[26];
int B14 = EventYear1[27];
int P15 = EventYear1[28];
int B15 = EventYear1[29];
int P16 = EventYear1[30];
int B16 = EventYear1[31];
tbPP1.Text = Convert.ToString(P9);
tbPPB1.Text = Convert.ToString(B9);
tbPP2.Text = Convert.ToString(P10);
tbPPB2.Text = Convert.ToString(B10);
tbPP3.Text = Convert.ToString(P11);
tbPPB3.Text = Convert.ToString(B11);
tbPP4.Text = Convert.ToString(P12);
tbPPB4.Text = Convert.ToString(B12);
tbPP5.Text = Convert.ToString(P13);
tbPPB5.Text = Convert.ToString(B13);
tbPP6.Text = Convert.ToString(P14);
tbPPB6.Text = Convert.ToString(B14);
tbPP7.Text = Convert.ToString(P15);
tbPPB7.Text = Convert.ToString(B15);
tbPP8.Text = Convert.ToString(P16);
tbPPB8.Text = Convert.ToString(B16);
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT QtyIPP,QtyIPB,QtyKDP,QtyKDB,QtyIPPeopP,QtyIPPeopB,QtyKDPeopP,QtyKDPeopB FROM vwAllUnit WHERE Id =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbIPEventtAllPD.Text = (DR["QtyIPP"].ToString());
tbIPEventAllBD.Text = (DR["QtyIPB"].ToString());
tbKDEventtAllPD.Text = (DR["QtyKDP"].ToString());
tbKDEventtAllBD.Text = (DR["QtyKDB"].ToString());
tbIPPeopAllPD.Text = (DR["QtyIPPeopP"].ToString());
tbIPPeopAllBD.Text = (DR["QtyIPPeopB"].ToString());
tbKDPeopPD.Text = (DR["QtyKDPeopP"].ToString());
tbKDPeopBD.Text = (DR["QtyKDPeopB"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT QtyIP14P,QtyIP14B,QtyIP25P,QtyIP25B,QtyIP55P,QtyIP55B,QtyIP55PP,QtyIP55PB,QtyKD14P,QtyKD14B,QtyKD25P,QtyKD25B,QtyKD55P,QtyKD55B,QtyKDPP,QtyKDPB FROM vwAllEventtIPKD WHERE Id =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbP1Dd.Text = (DR["QtyIP14P"].ToString());
tbB1D.Text = (DR["QtyIP14B"].ToString());
tbP2D.Text = (DR["QtyIP25P"].ToString());
tbB2D.Text = (DR["QtyIP25B"].ToString());
tbP3D.Text = (DR["QtyIP55P"].ToString());
tbB3D.Text = (DR["QtyIP55B"].ToString());
tbP4D.Text = (DR["QtyIP55PP"].ToString());
tbB4D.Text = (DR["QtyIP55PB"].ToString());
tbPP1D.Text = (DR["QtyKD14P"].ToString());
tbBB1D.Text = (DR["QtyKD14B"].ToString());
tbPP2D.Text = (DR["QtyKD25P"].ToString());
tbBB2D.Text = (DR["QtyKD25B"].ToString());
tbPP3D.Text = (DR["QtyKD55P"].ToString());
tbBB3D.Text = (DR["QtyKD55B"].ToString());
tbPP4D.Text = (DR["QtyKDPP"].ToString());
tbBB4D.Text = (DR["QtyKDPB"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
ConnectSDO ConSDO = new ConnectSDO();
ConSDO.OpenConnection();
SqlCommand comSPM = new SqlCommand("SELECT QtyIP14P,QtyIP14B,QtyIP25P,QtyIP25B,QtyIP55P,QtyIP55B,QtyIP55PP,QtyIP55PB,QtyKD14P,QtyKD14B,QtyKD25P,QtyKD25B,QtyKD55P,QtyKD55B,QtyKDPP,QtyKDPB FROM vwAllPeopleIPKD WHERE Id =" + Id, ConSDO.getConnectSDO());
adapter = new SqlDataAdapter(comSPM);
datTab = new DataTable();
adapter.Fill(datTab);
ConSDO.CloseConnection();
foreach (DataRow DR in datTab.Rows)
{
tbPep1PD.Text = (DR["QtyIP14P"].ToString());
tbPep1BD.Text = (DR["QtyIP14B"].ToString());
tbPep2PD.Text = (DR["QtyIP25P"].ToString());
tbPep2BD.Text = (DR["QtyIP25B"].ToString());
tbPep3PD.Text = (DR["QtyIP55P"].ToString());
tbPep3BD.Text = (DR["QtyIP55B"].ToString());
tbPep4PD.Text = (DR["QtyIP55PP"].ToString());
tbPep4BD.Text = (DR["QtyIP55PB"].ToString());
tbPep1PPD.Text = (DR["QtyKD14P"].ToString());
tbPep1BBD.Text = (DR["QtyKD14B"].ToString());
tbPep2PPD.Text = (DR["QtyKD25P"].ToString());
tbPep2BBD.Text = (DR["QtyKD25B"].ToString());
tbPep3PPD.Text = (DR["QtyKD55P"].ToString());
tbPep3BBD.Text = (DR["QtyKD55B"].ToString());
tbPep4PPD.Text = (DR["QtyKDPP"].ToString());
tbPep4BBD.Text = (DR["QtyKDPB"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
int a1 = Convert.ToInt32(tbIPEventAllP.Text);
int a2 = Convert.ToInt32(tbIPEventtAllPD.Text);
int s1 = RetLbl(a1, a2);
lbl1.Text = Convert.ToString(s1);
int a3 = Convert.ToInt32(tbIPEventAllB.Text);
int a4 = Convert.ToInt32(tbIPEventAllBD.Text);
int s2 = RetLbl(a3, a4);
lbl2.Text = Convert.ToString(s2);
int a5 = Convert.ToInt32(tbP1.Text);
int a6 = Convert.ToInt32(tbP1Dd.Text);
int s3 = RetLbl(a5, a6);
lbl3.Text = Convert.ToString(s3);
int a7 = Convert.ToInt32(tbP3.Text);
int a8 = Convert.ToInt32(tbP2D.Text);
int s4 = RetLbl(a7, a8);
lbl4.Text = Convert.ToString(s4);
int a9 = Convert.ToInt32(tbP5.Text);
int a10 = Convert.ToInt32(tbP3D.Text);
int s5 = RetLbl(a9, a10);
lbl5.Text = Convert.ToString(s5);
int a11 = Convert.ToInt32(tbP7.Text);
int a12 = Convert.ToInt32(tbP4D.Text);
int s6 = RetLbl(a11, a12);
lbl6.Text = Convert.ToString(s6);
int a13 = Convert.ToInt32(tbB1.Text);
int a14 = Convert.ToInt32(tbB1D.Text);
int s7 = RetLbl(a13, a14);
lbl7.Text = Convert.ToString(s7);
int a15 = Convert.ToInt32(tbB3.Text);
int a16 = Convert.ToInt32(tbB2D.Text);
int s8 = RetLbl(a15, a16);
lbl8.Text = Convert.ToString(s8);
int a17 = Convert.ToInt32(tbB5.Text);
int a18 = Convert.ToInt32(tbB3D.Text);
int s9 = RetLbl(a17, a18);
lbl9.Text = Convert.ToString(s9);
int a19 = Convert.ToInt32(tbB7.Text);
int a20 = Convert.ToInt32(tbB4D.Text);
int s10 = RetLbl(a19, a20);
lbl10.Text = Convert.ToString(s10);
int a21 = Convert.ToInt32(tbIPPeopAllP.Text);
int a22 = Convert.ToInt32(tbIPPeopAllPD.Text);
int s11 = RetLbl(a21, a22);
lbl11.Text = Convert.ToString(s11);
int a23 = Convert.ToInt32(tbIPPeopAllB.Text);
int a24 = Convert.ToInt32(tbIPPeopAllBD.Text);
int s12 = RetLbl(a23, a24);
lbl12.Text = Convert.ToString(s12);
int a25 = Convert.ToInt32(tbP2.Text);
int a26 = Convert.ToInt32(tbPep1PD.Text);
int s13 = RetLbl(a25, a26);
lbl13.Text = Convert.ToString(s13);
int a27 = Convert.ToInt32(tbP4.Text);
int a28 = Convert.ToInt32(tbPep2PD.Text);
int s14 = RetLbl(a27, a28);
lbl14.Text = Convert.ToString(s14);
int a29 = Convert.ToInt32(tbP6.Text);
int a30 = Convert.ToInt32(tbPep3PD.Text);
int s15 = RetLbl(a29, a30);
lbl15.Text = Convert.ToString(s15);
int a31 = Convert.ToInt32(tbP8.Text);
int a32 = Convert.ToInt32(tbPep4PD.Text);
int s16 = RetLbl(a31, a32);
lbl16.Text = Convert.ToString(s16);
int a33 = Convert.ToInt32(tbB2.Text);
int a34 = Convert.ToInt32(tbPep1BD.Text);
int s17 = RetLbl(a33, a34);
lbl17.Text = Convert.ToString(s17);
int a35 = Convert.ToInt32(tbB4.Text);
int a36 = Convert.ToInt32(tbPep2BD.Text);
int s18 = RetLbl(a35, a36);
lbl18.Text = Convert.ToString(s18);
int a37 = Convert.ToInt32(tbB6.Text);
int a38 = Convert.ToInt32(tbPep3BD.Text);
int s19 = RetLbl(a37, a38);
lbl19.Text = Convert.ToString(s19);
int a39 = Convert.ToInt32(tbB8.Text);
int a40 = Convert.ToInt32(tbPep4BD.Text);
int s20 = RetLbl(a39, a40);
lbl20.Text = Convert.ToString(s20);
int b1 = Convert.ToInt32(tbKDEventtAllP.Text);
int b2 = Convert.ToInt32(tbKDEventtAllPD.Text);
int s21 = RetLbl(b1, b2);
lbl21.Text = Convert.ToString(s21);
int b3 = Convert.ToInt32(tbKDEventtAllB.Text);
int b4 = Convert.ToInt32(tbKDEventtAllBD.Text);
int s22 = RetLbl(b3, b4);
lbl22.Text = Convert.ToString(s22);
int b5 = Convert.ToInt32(tbPP1.Text);
int b6 = Convert.ToInt32(tbPP1D.Text);
int s23 = RetLbl(b5, b6);
lbl23.Text = Convert.ToString(s23);
int b7 = Convert.ToInt32(tbPP3.Text);
int b8 = Convert.ToInt32(tbPP2D.Text);
int s24 = RetLbl(b7, b8);
lbl24.Text = Convert.ToString(s24);
int b9 = Convert.ToInt32(tbPP5.Text);
int b10 = Convert.ToInt32(tbPP3D.Text);
int s25 = RetLbl(b9, b10);
lbl25.Text = Convert.ToString(s25);
int b11 = Convert.ToInt32(tbPP7.Text);
int b12 = Convert.ToInt32(tbPP4D.Text);
int s26 = RetLbl(b11, b12);
lbl26.Text = Convert.ToString(s26);
int b13 = Convert.ToInt32(tbPPB1.Text);
int b14 = Convert.ToInt32(tbBB1D.Text);
int s27 = RetLbl(b13, b14);
lbl27.Text = Convert.ToString(27);
int b15 = Convert.ToInt32(tbPPB3.Text);
int b16 = Convert.ToInt32(tbBB2D.Text);
int s28 = RetLbl(b15, b16);
lbl28.Text = Convert.ToString(s28);
int b17 = Convert.ToInt32(tbPPB5.Text);
int b18 = Convert.ToInt32(tbBB3D.Text);
int s29 = RetLbl(b17, b18);
lbl29.Text = Convert.ToString(s29);
int b19 = Convert.ToInt32(tbPPB7.Text);
int b20 = Convert.ToInt32(tbBB4D.Text);
int s30 = RetLbl(b19, b20);
lbl30.Text = Convert.ToString(s30);
int b21 = Convert.ToInt32(tbKDPeopP.Text);
int b22 = Convert.ToInt32(tbKDPeopPD.Text);
int s31 = RetLbl(b21, b22);
lbl31.Text = Convert.ToString(s31);
int b23 = Convert.ToInt32(tbKDPeopB.Text);
int b24 = Convert.ToInt32(tbKDPeopBD.Text);
int s32 = RetLbl(b23, b24);
lbl32.Text = Convert.ToString(s32);
int b25 = Convert.ToInt32(tbPP2.Text);
int b26 = Convert.ToInt32(tbPep1PPD.Text);
int s33 = RetLbl(b25, b26);
lbl33.Text = Convert.ToString(s33);
int b27 = Convert.ToInt32(tbPP4.Text);
int b28 = Convert.ToInt32(tbPep2PPD.Text);
int s34 = RetLbl(b27, b28);
lbl34.Text = Convert.ToString(s34);
int b29 = Convert.ToInt32(tbPP6.Text);
int b30 = Convert.ToInt32(tbPep3PPD.Text);
int s35 = RetLbl(b29, b30);
lbl35.Text = Convert.ToString(s35);
int b31 = Convert.ToInt32(tbPP8.Text);
int b32 = Convert.ToInt32(tbPep4PPD.Text);
int s36 = RetLbl(b31, b32);
lbl36.Text = Convert.ToString(s36);
int b33 = Convert.ToInt32(tbPPB2.Text);
int b34 = Convert.ToInt32(tbPep1BBD.Text);
int s37 = RetLbl(b33, b34);
lbl37.Text = Convert.ToString(s37);
int b35 = Convert.ToInt32(tbPPB4.Text);
int b36 = Convert.ToInt32(tbPep2BBD.Text);
int s38 = RetLbl(b35, b36);
lbl38.Text = Convert.ToString(s38);
int b37 = Convert.ToInt32(tbPPB6.Text);
int b38 = Convert.ToInt32(tbPep3BBD.Text);
int s39 = RetLbl(b37, b38);
lbl39.Text = Convert.ToString(s39);
int b39 = Convert.ToInt32(tbPPB8.Text);
int b40 = Convert.ToInt32(tbPep4BBD.Text);
int s40 = RetLbl(b39, b40);
lbl40.Text = Convert.ToString(s40);
}
public void btnOk(int IdE, int[] EventUnit1, int[] EventQty1, int[] EventQty2)
{
if (cmbStatusEvent.Text != "" && cmbgr1.Text != "" && cmbgr2.Text != "" && cmbgr3.Text != "" && cmbgr4.Text != "" && cmbgr5.Text != "")
{
try
{
int IdU = EventUnit1[1];
int IdQ0 = Convert.ToInt32(EventQty1[0].ToString());
int IdQ1 = Convert.ToInt32(EventQty1[1].ToString());
int IdQ2 = Convert.ToInt32(EventQty1[2].ToString());
int IdQ3 = Convert.ToInt32(EventQty1[3].ToString());
int IdQ4 = Convert.ToInt32(EventQty1[4].ToString());
int IdQ5 = Convert.ToInt32(EventQty2[0].ToString());
int IdQ6 = Convert.ToInt32(EventQty2[1].ToString());
int IdQ7 = Convert.ToInt32(EventQty2[2].ToString());
int IdQ8 = Convert.ToInt32(EventQty2[3].ToString());
int IdQ9 = Convert.ToInt32(EventQty2[4].ToString());
int IdQ10 = Convert.ToInt32(EventQty2[5].ToString());
int IdQ11 = Convert.ToInt32(EventQty2[6].ToString());
int IdQ12 = Convert.ToInt32(EventQty2[7].ToString());
int IdQ13 = Convert.ToInt32(EventQty2[8].ToString());
int IdQ14 = Convert.ToInt32(EventQty2[9].ToString());
int IdQ15 = Convert.ToInt32(EventQty2[10].ToString());
int IdQ16 = Convert.ToInt32(EventQty2[11].ToString());
int IdQ17 = Convert.ToInt32(EventQty2[12].ToString());
int IdQ18 = Convert.ToInt32(EventQty2[13].ToString());
int IdQ19 = Convert.ToInt32(EventQty2[14].ToString());
int IdQ20 = Convert.ToInt32(EventQty2[15].ToString());
int IdQ21 = Convert.ToInt32(EventQty2[16].ToString());
int IdQ22 = Convert.ToInt32(EventQty2[17].ToString());
int IdQ23 = Convert.ToInt32(EventQty2[18].ToString());
int IdQ24 = Convert.ToInt32(EventQty2[19].ToString());
int IdQ25 = Convert.ToInt32(EventQty2[20].ToString());
int IdQ26 = Convert.ToInt32(EventQty2[21].ToString());
int IdQ27 = Convert.ToInt32(EventQty2[22].ToString());
int IdQ28 = Convert.ToInt32(EventQty2[23].ToString());
int IdQ29 = Convert.ToInt32(EventQty2[24].ToString());
if (cmbStatusEvent.Text.Length > 0)
{
ConnectSDO sdo = new ConnectSDO();
sqlcom = new SqlCommand("spUppEventt", sdo.getConnectSDO());
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = tbNameEvent.Text.Trim();
sqlcom.Parameters.AddWithValue("@Status", SqlDbType.Int).Value = cmbStatusEvent.Text.Trim();
sqlcom.Parameters.AddWithValue("@DateFirst", SqlDbType.Int).Value = mcEvent.SelectionRange.Start;
sqlcom.Parameters.AddWithValue("@IdE", SqlDbType.Int).Value = IdE;
sdo.OpenConnection();
sqlcom.ExecuteNonQuery();
sdo.CloseConnection();
}
if (cmbStatusQtyEvent1.Text.Length > 0)
{
string NameU = cmbStatusQtyEvent1.Text.Trim();
int Idu = IdU;
int Ide = IdE;
spUnit(NameU, Idu, Ide);
if (tbEventAllP.Text.Length >= 0)
{
string Name1 = lblEvent.Text;
string NameCateg1 = cmbStatusQtyEvent1.Text.Trim();
string NameE1 = lblP.Text;
int Qty1 = Int32.Parse(tbEventAllP.Text);
int IdU1 = IdU;
int Id0 = IdQ0;
spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id0);
string Name2 = lblEvent.Text;
string NameCateg2 = cmbStatusQtyEvent1.Text.Trim();
string NameE2 = lblB.Text;
int Qty2 = Int32.Parse(tbEventAllB.Text);
int IdU2 = IdU;
int Id1 = IdQ1;
spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id1);
string Name3 = lblPeople.Text;
string NameCateg3 = cmbStatusQtyEvent1.Text.Trim();
string NameE3 = lblP.Text;
int Qty3 = Int32.Parse(tbUnitAllP.Text);
int IdU3 = IdU;
int Id3 = IdQ2;
spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3);
string Name4 = lblPeople.Text;
string NameCateg4 = cmbStatusQtyEvent1.Text.Trim();
string NameE4 = lblB.Text;
int Qty4 = Int32.Parse(tbUnitAllB.Text);
int IdU4 = IdU;
int Id4 = IdQ3;
spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4);
string Name5 = lblParticial.Text;
string NameCateg5 = cmbStatusQtyEvent1.Text.Trim();
string NameE5 = lblB.Text;
int Qty5 = Int32.Parse(tbAllPlayer.Text);
int IdU5 = IdU;
int Id5 = IdQ4;
spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5);
}
}
if (cmbgr1.Text.Length > 0)
{
//string NameU2 = cmbgr1.Text.Trim();
int Idu = IdU;
int Ide = IdE;
//spUnit(NameU2, IdU, Ide);
if (tbEvP1.Text.Length >= 0 && tbEvB1.Text.Length >= 0 && tbpgr1.Text.Length >= 0 && tbPBgr1.Text.Length >= 0)
{
string Name1 = lblEvent.Text;
string NameCateg1 = cmbgr1.Text.Trim();
string NameE1 = lblP.Text;
int Qty1 = Int32.Parse(tbEvP1.Text);
int IdU1 = IdU;
int Id1 = IdQ5;
spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1);
string Name2 = lblEvent.Text;
string NameCateg2 = cmbgr1.Text.Trim();
string NameE2 = lblB.Text;
int Qty2 = Int32.Parse(tbEvB1.Text);
int IdU2 = IdU;
int Id2 = IdQ6;
spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2);
string Name3 = lblPeople.Text;
string NameCateg3 = cmbgr1.Text.Trim();
string NameE3 = lblP.Text;
int Qty3 = Int32.Parse(tbpgr1.Text);
int IdU3 = IdU;
int Id3 = IdQ7;
spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3);
string Name4 = lblPeople.Text;
string NameCateg4 = cmbgr1.Text.Trim();
string NameE4 = lblB.Text;
int Qty4 = Int32.Parse(tbPBgr1.Text);
int IdU4 = IdU;
int Id4 = IdQ8;
spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4);
string Name5 = lblParticial.Text;
string NameCateg5 = cmbgr1.Text.Trim();
string NameE5 = lblB.Text;
int Qty5 = Int32.Parse(tbPlayer1.Text);
int IdU5 = IdU;
int Id5 = IdQ9;
spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5);
}
}
if (cmbgr2.Text.Length > 0)
{
//string NameU3 = cmbgr2.Text.Trim();
int Idu = IdU;
int Ide = IdE;
//spUnit(NameU3, IdU, Ide);
if (tbEvP2.Text.Length >= 0 && tbEvB2.Text.Length >= 0 && tbpgr2.Text.Length >= 0 && tbPBgr2.Text.Length >= 0)
{
string Name1 = lblEvent.Text;
string NameCateg1 = cmbgr2.Text.Trim();
string NameE1 = lblP.Text;
int Qty1 = Int32.Parse(tbEvP2.Text);
int IdU1 = IdU;
int Id1 = IdQ10;
spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1);
string Name2 = lblEvent.Text;
string NameCateg2 = cmbgr2.Text.Trim();
string NameE2 = lblB.Text;
int Qty2 = Int32.Parse(tbEvB2.Text);
int IdU2 = IdU;
int Id2 = IdQ11;
spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2);
string Name3 = lblPeople.Text;
string NameCateg3 = cmbgr2.Text.Trim();
string NameE3 = lblP.Text;
int Qty3 = Int32.Parse(tbpgr2.Text);
int IdU3 = IdU;
int Id3 = IdQ12;
spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3);
string Name4 = lblPeople.Text;
string NameCateg4 = cmbgr2.Text.Trim();
string NameE4 = lblB.Text;
int Qty4 = Int32.Parse(tbPBgr2.Text);
int IdU4 = IdU;
int Id4 = IdQ13;
spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4);
string Name5 = lblParticial.Text;
string NameCateg5 = cmbgr2.Text.Trim();
string NameE5 = lblB.Text;
int Qty5 = Int32.Parse(tbPlayer2.Text);
int IdU5 = IdU;
int Id5 = IdQ14;
spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5);
}
}
if (cmbgr3.Text.Length > 0)
{
//string NameU4 = cmbgr3.Text.Trim();
int Idu = IdU;
int Ide = IdE;
//spUnit(NameU4, IdU, Ide);
if (tbEvP3.Text.Length >= 0 && tbEvB3.Text.Length >= 0 && tbpgr3.Text.Length >= 0 && tbPBgr3.Text.Length >= 0)
{
string Name1 = lblEvent.Text;
string NameCateg1 = cmbgr3.Text.Trim();
string NameE1 = lblP.Text;
int Qty1 = Int32.Parse(tbEvP3.Text);
int IdU1 = IdU;
int Id1 = IdQ15;
spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1);
string Name2 = lblEvent.Text;
string NameCateg2 = cmbgr3.Text.Trim();
string NameE2 = lblB.Text;
int Qty2 = Int32.Parse(tbEvB3.Text);
int IdU2 = IdU;
int Id2 = IdQ16;
spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2);
string Name3 = lblPeople.Text;
string NameCateg3 = cmbgr3.Text.Trim();
string NameE3 = lblP.Text;
int Qty3 = Int32.Parse(tbpgr3.Text);
int IdU3 = IdU;
int Id3 = IdQ17;
spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3);
string Name4 = lblPeople.Text;
string NameCateg4 = cmbgr3.Text.Trim();
string NameE4 = lblB.Text;
int Qty4 = Int32.Parse(tbPBgr3.Text);
int IdU4 = IdU;
int Id4 = IdQ18;
spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4);
string Name5 = lblParticial.Text;
string NameCateg5 = cmbgr3.Text.Trim();
string NameE5 = lblB.Text;
int Qty5 = Int32.Parse(tbPlayer3.Text);
int IdU5 = IdU;
int Id5 = IdQ19;
spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5);
}
}
if (cmbgr4.Text.Length > 0)
{
//string NameU5 = cmbgr4.Text.Trim();
int Idu = IdU;
int Ide = IdE;
//spUnit(NameU5, IdU, Ide);
if (tbEvP4.Text.Length >= 0 && tbEvB4.Text.Length >= 0 && tbpgr4.Text.Length >= 0 && tbPBgr4.Text.Length >= 0)
{
string Name1 = lblEvent.Text;
string NameCateg1 = cmbgr4.Text.Trim();
string NameE1 = lblP.Text;
int Qty1 = Int32.Parse(tbEvP4.Text);
int IdU1 = IdU;
int Id1 = IdQ20;
spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1);
string Name2 = lblEvent.Text;
string NameCateg2 = cmbgr4.Text.Trim();
string NameE2 = lblB.Text;
int Qty2 = Int32.Parse(tbEvB4.Text);
int IdU2 = IdU;
int Id2 = IdQ21;
spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2);
string Name3 = lblPeople.Text;
string NameCateg3 = cmbgr4.Text.Trim();
string NameE3 = lblP.Text;
int Qty3 = Int32.Parse(tbpgr4.Text);
int IdU3 = IdU;
int Id3 = IdQ22;
spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3);
string Name4 = lblPeople.Text;
string NameCateg4 = cmbgr4.Text.Trim();
string NameE4 = lblB.Text;
int Qty4 = Int32.Parse(tbPBgr4.Text);
int IdU4 = IdU;
int Id4 = IdQ23;
spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4);
string Name5 = lblParticial.Text;
string NameCateg5 = cmbgr4.Text.Trim();
string NameE5 = lblB.Text;
int Qty5 = Int32.Parse(tbPlayer4.Text);
int IdU5 = IdU;
int Id5 = IdQ24;
spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5);
}
}
if (cmbgr5.Text.Length > 0)
{
//string NameU5 = cmbgr5.Text.Trim();
int Idu = IdU;
int Ide = IdE;
//spUnit(NameU5, IdU, Ide);
if (tbEvP5.Text.Length >= 0 && tbEvB5.Text.Length >= 0 && tbpgr5.Text.Length >= 0 && tbPBgr5.Text.Length >= 0)
{
string Name1 = lblEvent.Text;
string NameCateg1 = cmbgr5.Text.Trim();
string NameE1 = lblP.Text;
int Qty1 = Int32.Parse(tbEvP5.Text);
int IdU1 = IdU;
int Id1 = IdQ25;
spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1);
string Name2 = lblEvent.Text;
string NameCateg2 = cmbgr5.Text.Trim();
string NameE2 = lblB.Text;
int Qty2 = Int32.Parse(tbEvB5.Text);
int IdU2 = IdU;
int Id2 = IdQ26;
spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2);
string Name3 = lblPeople.Text;
string NameCateg3 = cmbgr5.Text.Trim();
string NameE3 = lblP.Text;
int Qty3 = Int32.Parse(tbpgr5.Text);
int IdU3 = IdU;
int Id3 = IdQ27;
spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3);
string Name4 = lblPeople.Text;
string NameCateg4 = cmbgr5.Text.Trim();
string NameE4 = lblB.Text;
int Qty4 = Int32.Parse(tbPBgr5.Text);
int IdU4 = IdU;
int Id4 = IdQ28;
spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4);
string Name5 = lblParticial.Text;
string NameCateg5 = cmbgr5.Text.Trim();
string NameE5 = lblB.Text;
int Qty5 = Int32.Parse(tbPlayer5.Text);
int IdU5 = IdU;
int Id5 = IdQ29;
spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5);
}
}
MessageBox.Show("Mероприятие изменено!");
this.Hide();
}
catch (Exception)
{
MessageBox.Show("Не удалось обновить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
