public bool Write_ToChangeTab(StructDataDeal deal)
{
bool resalt = true;
int id_productName = readDB.GetID_BYNumber(deal.Number);
int id_typeCount = readDB.Get_TypeOfCountID_ByName(deal.TypeCount);
try
{
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO change_t(id_product_name,count_value,id_type_count,price,data_wrote,name_document,number_document,data_document,wherehouser)" +
" VALUES('" + id_productName + "','" + deal.Count + "','" + id_typeCount + "','" + deal.Price + "','" + deal.DateWrote + "','" + deal.NameDoc + "','" + deal.NumberDoc + "','" + deal.DateDocCreated + "','" + deal.Warhouser + "')";
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception)
{
resalt = false;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(resalt);
}
private void UpdateDB(bool AddData)
{
bool resalt = true;
if (AddData)
{
foreach (StructDataDeal deal in _DataForInsert)
{
int id_product = readDB.GetID_BYNumber(deal.Number);
int countForInsert = readDB.GetCount_BYiD(id_product) + Convert.ToInt32(deal.Count);
deal.ID = id_product;
deal.Count = Convert.ToInt32(countForInsert.ToString());
data_ForDB.Add(deal);
}
}
else
{
foreach (StructDataDeal deal in _DataForInsert)
{
int id_product = readDB.GetID_BYNumber(deal.Number);
int countForInsert = readDB.GetCount_BYiD(id_product) - Convert.ToInt32(deal.Count);
deal.ID = id_product;
deal.Count = Convert.ToInt32(countForInsert.ToString());
data_ForDB.Add(deal);
}
}
foreach (StructDataDeal deal in data_ForDB)
{
resalt = write.UpdateCount_ExistPruduct(deal);
resalt = write.Write_ToChangeTab(deal);
}
if (resalt)
{
MessageBox.Show("Отчет сформирован");
}
}
