protected void btnInitAkcionnieCeny_Click(object sender, EventArgs e) { string ret = ""; SaalutDataClasses1DataContext context = new SaalutDataClasses1DataContext(); //------------------------------- var delStoreInfo = (from d in context.StoreInfos select d).FirstOrDefault(); string jurCo = delStoreInfo.Company; string jurF = delStoreInfo.AddressFact; context.StoreInfos.DeleteOnSubmit(delStoreInfo); context.SubmitChanges(); UKMDataBaseConnects utl = new UKMDataBaseConnects(); utl.InitialStoreInfoIns(); var newStoreInfo = (from d in context.StoreInfos select d).FirstOrDefault(); newStoreInfo.Company = jurCo; newStoreInfo.AddressFact = jurF; context.SubmitChanges(); //--------------------------------- var pricesAkcion = (from p in context.PricesAkcionnies select p).FirstOrDefault(); if (pricesAkcion != null) { return; } var store = (from s in context.StoreInfos where s.Active == true select s).FirstOrDefault(); CommittableTransaction tx = new CommittableTransaction(); // Create a connection object and data adapter MySqlConnection cnx = null; try { cnx = new MySqlConnection(connStr); MySqlDataAdapter adapter = new MySqlDataAdapter(); // = делаем текущий прайс лист магазина // Выбираем магазин string cmdText = "SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ; select item, price, version, deleted from ukmserver.trm_in_pricelist_items where pricelist_id = '" + store.ActPriceList_ID_UKM.ToString() + "' and deleted = 0; SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ; "; MySqlCommand cmd = new MySqlCommand(cmdText, cnx); cmd.CommandTimeout = 30000; // Create a fill a Dataset DataSet ds = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(ds); DataTable pricesAkcionnie = ds.Tables[0]; if (pricesAkcionnie != null) { foreach (DataRow row1 in pricesAkcionnie.Rows) { string artikulA = (string)row1[0]; decimal priceA = (decimal)row1[1]; int version_priceA = (int)row1[2]; bool delete_priceA = (bool)row1[3]; double newPriceA = Double.Parse(priceA.ToString()); var good = (from g in context.Goods where g.Articul == artikulA select g).FirstOrDefault(); if (good == null) { continue; } //+ PricesAkcionnie npr1 = new PricesAkcionnie(); npr1.GoodID = good.ID; npr1.Price = newPriceA; npr1.Version_UKM = version_priceA; npr1.TimeStamp = DateTime.Now; npr1.Active = true; context.PricesAkcionnies.InsertOnSubmit(npr1); context.SubmitChanges(); //- } } tx.Commit(); } catch (MySqlException ex) { ret += "Error: " + ex.ToString(); tx.Rollback(); } finally { if (cnx != null) { cnx.Close(); } } return; }