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("Отчет сформирован"); } }