private void button5_Click(object sender, EventArgs e)
{
var row = dataGridList.SelectedRows.Count > 0 ? dataGridList.SelectedRows[0] : null;
if (row == null)
{
MessageBox.Show("Сначала выбирете строку", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var form = new ParametrProduct();
form.name_product.Text = row.Cells["name"].Value.ToString();
form.textBox_kol.Text = row.Cells["kol"].Value.ToString();
var res = form.ShowDialog();
if (res == DialogResult.OK)
{
var name = form.name_product.Text;
var Koll = form.textBox_kol.Text;
//var delta = (ish - Convert.ToInt32(Koll)).ToString();
//Kol = Kol + Convert.ToInt32(koll);
if (Convert.ToInt32(Koll) > Convert.ToInt32(ish))
{
MessageBox.Show("Превышено количество товара на складе", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var id = row.Cells["id"].Value.ToString();
var connection = new SqlConnection(connectionString);
connection.Open();
var request = @"UPDATE help_prod SET name='" + name + "',kol='" + Koll + "' WHERE Id='" + id + "'";
//var request1 = @"UPDATE Product SET Quantity='" + delta + "' WHERE NameOfItem='" + name + "'";
var command = new SqlCommand(request, connection);
//var command1 = new SqlCommand(request1, connection);
command.ExecuteNonQuery();
//command1.ExecuteNonQuery();
connection.Close();
updateListDGV();
updateScladDGV();
}
}
}
private void button2_Click(object sender, EventArgs e)
{
var row = dataGrid_Sclad.SelectedRows.Count > 0 ? dataGrid_Sclad.SelectedRows[0] : null;
if (row == null)
{
MessageBox.Show("Сначала выбирете строку", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var form = new ParametrProduct();
form.name_product.Text = row.Cells["NameOfItem"].Value.ToString();
var res = form.ShowDialog();
var NName = row.Cells["NameOfItem"].Value.ToString();
var Query = @"SELECT Id FROM Product WHERE NameOfItem='" + NName + "'";
SqlDataAdapter AORder = new SqlDataAdapter(Query, connectionString);
DataTable Ttable = new DataTable();
AORder.Fill(Ttable);
string Res1 = "";
foreach (DataRow Row in Ttable.Rows)
{
Res1 = Row["Id"].ToString();
if (Res1 != "")
{
break;
}
}
//var nomer = row.Cells["Id"].Value.ToString();
if (res == DialogResult.OK)
{
string resName = "";
if (i != 1)
{
var que = @"SELECT name FROM help_prod WHERE Id=(SELECT MAX(Id) FROM help_prod)";
SqlDataAdapter rder = new SqlDataAdapter(que, connectionString);
DataTable taBle = new DataTable();
rder.Fill(taBle);
foreach (DataRow Roww in taBle.Rows)
{
resName += Roww["name"].ToString();
if (NName == resName)
{
MessageBox.Show("Вы уже добавили данный товар. Измените его количество или удалите.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
if (NName != resName)
{
var query = @"SELECT Id FROM help_prod WHERE Id=(SELECT MAX(Id) FROM help_prod)";
SqlDataAdapter aOrder = new SqlDataAdapter(query, connectionString);
DataTable table = new DataTable();
aOrder.Fill(table);
string res1 = "";
foreach (DataRow Row in table.Rows)
{
res1 += Row["Id"].ToString();
}
if (res1 == "")
{
int m = 1;
res1 = m.ToString();
}
else
{
int m = Convert.ToInt32(res1);
m++;
res1 = m.ToString();
// Kol = 0;
}
var quer = @"SELECT Id FROM InfoTovar WHERE Id=(SELECT MAX(Id) FROM InfoTovar)";
SqlDataAdapter AOrder = new SqlDataAdapter(quer, connectionString);
DataTable Table = new DataTable();
AOrder.Fill(Table);
string ress = "";
foreach (DataRow Row in Table.Rows)
{
ress += Row["Id"].ToString();
}
if (ress == "")
{
int m = 1;
ress = m.ToString();
}
else
{
int m = Convert.ToInt32(ress);
m++;
ress = m.ToString();
}
var query1 = @"SELECT Product.NameOfItem,Buhgalteria.price FROM Product JOIN Product_has_Price
ON Product.Id=Product_has_Price.product_id
JOIN Buhgalteria
ON Buhgalteria.Id=Product_has_Price.price_id
WHERE Product.Id='" + Res1 + "'";
SqlDataAdapter aOrder1 = new SqlDataAdapter(query1, connectionString);
DataTable table1 = new DataTable();
aOrder1.Fill(table1);
var res2 = "";
foreach (DataRow Row1 in table1.Rows)
{
res2 += Row1["price"].ToString();
}
var max_kol = row.Cells["KolVo"].Value.ToString();
var koll = form.textBox_kol.Text;
Kol = Kol + Convert.ToInt32(koll);
if (Convert.ToInt32(koll) > Convert.ToInt32(max_kol))
{
MessageBox.Show("Превышено количество товара на складе", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
ish = 0;
ish = Convert.ToInt32(max_kol);
max_kol = (Convert.ToInt32(max_kol) - Kol).ToString();
var Price = res2;
itogo += Convert.ToInt32(koll) * Convert.ToInt32(Price);
// var menh_kol = (Convert.ToInt32(max_kol) - Convert.ToInt32(koll)).ToString();
var nname = form.name_product.Text;
var id = res1;
var idd = /*row.Cells["id"].Value.ToString();*/ Res1;
var time = DateTime.Today;
nums[Convert.ToInt32(id)] = Convert.ToInt32(idd);
numsss[Convert.ToInt32(ress)] = Convert.ToInt32(ress);
var connection = new SqlConnection(connectionString);
connection.Open();
var request = @"INSERT INTO help_prod (name, kol,Id,price)
VALUES ('" + nname + "','" + koll + "','" + id + "','" + Price + "')";
//var request1 = @"SELECT NameOfItem, SUM(Quantity) AS KolVo FROM Product
//WHERE Product.ValidUntil > '" + time.ToString("yyyy-MM-dd") + "' AND NameOfItem!= '" + nname + "' GROUP BY NameOfItem ORDER BY KolVo DESC";
var request2 = @"INSERT INTO InfoTovar (Nazvanie, kol,Id,Price)
VALUES ('" + nname + "','" + koll + "','" + ress + "','" + Price + "')";
var command = new SqlCommand(request, connection);
command.ExecuteNonQuery();
//var command1 = new SqlCommand(request1, connection);
//command1.ExecuteNonQuery();
var command3 = new SqlCommand(request2, connection);
command3.ExecuteNonQuery();
connection.Close();
updateListDGV();
updateScladDGV();
i++;
}
}
}
}
