private void button1_Click(object sender, EventArgs e)
{
if (
(textBox1.Text != "") && (textBox2.Text != "") &&
(textBox3.Text != "") && (textBox4.Text != "") &&
(textBox5.Text != "") && (textBox6.Text != "") &&
(comboBoxForTariffNetNum.Text != "") && (comboBoxForKindPay.Text != "")
)
{
AddTarrif addTarif2 = new AddTarrif();
DataTable dt2 = new DataTable();
double a1 = double.Parse(textBox1.Text);
double a2 = double.Parse(textBox2.Text);
double a3 = double.Parse(textBox3.Text);
double a4 = double.Parse(textBox4.Text);
double a5 = double.Parse(textBox5.Text);
double a6 = double.Parse(textBox6.Text);
string variableForTariffNetNum = comboBoxForTariffNetNum.Text;
string variableForKindPay = comboBoxForKindPay.Text;
ObrabotkaTarrif ot = new ObrabotkaTarrif(); //создаем обект для работы с класом который все делает
dt2 = ot.NewTariff(a1, a2, a3, a4, a5, a6, variableForTariffNetNum, variableForKindPay); //в дататейбл заносим новую тарифную сетку
deleteFromBD(variableForTariffNetNum, variableForKindPay); //удаляем старое с бд
writteToBD(dt2); //записываем все в бд
dataGridViewTariffVuvod.DataSource = dt2;
DataTable tempDT = new DataTable();
tempDT = addTarif2.ReturnDataTable(@"SELECT * FROM infTariff");
dataGridViewTariff.DataSource = tempDT;
labelTariff.Text = tempDT.Rows.Count.ToString();
labelTariffVuvod.Text = dt2.Rows.Count.ToString();
}
else
{
MessageBox.Show("заполните все поля");
}
}
private void button4_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog().ToString() == "OK")
{
string tarifFile = openFileDialog1.FileName;
AddTarrif at = new AddTarrif();
DataTable tarifKind = at.ReturnDataTable(tarifFile, @"SELECT DISTINCT TariffNetNum, KindPay FROM infTariff ORDER BY TariffNetNum, KindPay");
for (int i = 0; i < tarifKind.Rows.Count; i++)
{
DataTable tarifNet = new DataTable();
tarifNet = at.ReturnDataTable(tarifFile, @"SELECT * FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "' ORDER BY TariffNetNum, KindPay, WorkerRate");
ObrabotkaTarrif ot = new ObrabotkaTarrif();
tarifNet = ot.NewTariff
(
double.Parse(tarifNet.Rows[0]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[1]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[2]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[3]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[4]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[5]["HourCost"].ToString()),
tarifNet.Rows[0]["TariffNetNum"].ToString(),
tarifNet.Rows[0]["KindPay"].ToString()
);//в дататейбл заносим новую тарифную сетку
at.deleteFromDB(@"DELETE FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "'");
// at.deleteFromDB(tarifFile, @"DELETE FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "'");
writteToBD(tarifNet);//записываем все в бд
dataGridViewTariffVuvod.DataSource = tarifNet;
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog().ToString() == "OK")
{
string tarifFile = openFileDialog1.FileName;
AddTarrif at = new AddTarrif();
DataTable tarifKind = at.ReturnDataTable(tarifFile, @"SELECT DISTINCT TariffNetNum, KindPay FROM infTariff ORDER BY TariffNetNum, KindPay");
for (int i = 0; i < tarifKind.Rows.Count; i++)
{
DataTable tarifNet = new DataTable();
tarifNet = at.ReturnDataTable(tarifFile, @"SELECT * FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "' ORDER BY TariffNetNum, KindPay, WorkerRate");
ObrabotkaTarrif ot = new ObrabotkaTarrif();
tarifNet = ot.NewTariff
(
double.Parse(tarifNet.Rows[0]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[1]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[2]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[3]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[4]["HourCost"].ToString()),
double.Parse(tarifNet.Rows[5]["HourCost"].ToString()),
tarifNet.Rows[0]["TariffNetNum"].ToString(),
tarifNet.Rows[0]["KindPay"].ToString()
);//в дататейбл заносим новую тарифную сетку
at.deleteFromDB(@"DELETE FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "'");
// at.deleteFromDB(tarifFile, @"DELETE FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "'");
writteToBD(tarifNet);//записываем все в бд
dataGridViewTariffVuvod.DataSource = tarifNet;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (
(textBox1.Text != "") && (textBox2.Text != "")
&& (textBox3.Text != "") && (textBox4.Text != "")
&& (textBox5.Text != "") && (textBox6.Text != "")
&& (comboBoxForTariffNetNum.Text != "") && (comboBoxForKindPay.Text != "")
)
{
AddTarrif addTarif2 = new AddTarrif();
DataTable dt2 = new DataTable();
double a1 =double.Parse(textBox1.Text);
double a2 =double.Parse(textBox2.Text);
double a3 =double.Parse(textBox3.Text);
double a4 =double.Parse(textBox4.Text);
double a5 =double.Parse(textBox5.Text);
double a6 = double.Parse(textBox6.Text);
string variableForTariffNetNum = comboBoxForTariffNetNum.Text;
string variableForKindPay = comboBoxForKindPay.Text;
ObrabotkaTarrif ot = new ObrabotkaTarrif(); //создаем обект для работы с класом который все делает
dt2 = ot.NewTariff(a1, a2, a3, a4, a5, a6, variableForTariffNetNum, variableForKindPay);//в дататейбл заносим новую тарифную сетку
deleteFromBD(variableForTariffNetNum, variableForKindPay); //удаляем старое с бд
writteToBD(dt2);//записываем все в бд
dataGridViewTariffVuvod.DataSource = dt2;
DataTable tempDT = new DataTable();
tempDT = addTarif2.ReturnDataTable(@"SELECT * FROM infTariff");
dataGridViewTariff.DataSource = tempDT;
labelTariff.Text = tempDT.Rows.Count.ToString();
labelTariffVuvod.Text = dt2.Rows.Count.ToString();
}
else
MessageBox.Show("заполните все поля");
}
