public void InsertFctEbayGrabberOneItem(GetMultipleItemsResponseItem item, string section) { if (item != null) { try { InsertEbay(item, section); } catch (Exception ex) { throw new Exception("MySql error: " + ex.Message, ex); } } }
public bool InsertEbay(GetMultipleItemsResponseItem item, string section) { const string sql = @" insert into fct_grabber_ebay (id_resource_list, ebay_id,url, title, author, price, city,country, ebay_section, user_section, description,curr_code,is_auction,bid,transformated) Values(@index,@idEbay,@url,@title,@seller,@price,@city,@country,@subcategory,@section,@desc,@currency,@is_auction,@bid,@transformated)"; var index = "null"; decimal? price = null; decimal? bid = null; var trans = 0; var is_auction = false; try { index = Convert.ToString(Convert.ToInt32(ResourceListIDEbay()) + 1); is_auction = item.MinimumToBid != null; if (is_auction) trans = 4; var cmd = new MySqlCommand(); cmd.Connection = mySqlConnection; cmd.CommandText = sql; cmd.Prepare(); //Параметры для вставки типа в теле @phone тут мы list[PartsPage.Phone].First<string>() // и тд if (is_auction) bid = item.CurrentPrice.Value; else price = item.CurrentPrice.Value; cmd.Parameters.AddWithValue("@index", index); cmd.Parameters.AddWithValue("@idEbay", item.ItemID); cmd.Parameters.AddWithValue("@url", item.ViewItemURLForNaturalSearch); cmd.Parameters.AddWithValue("@title", item.Title); cmd.Parameters.AddWithValue("@seller", item.Seller.UserID); cmd.Parameters.AddWithValue("@price", price); cmd.Parameters.AddWithValue("@city", item.Location); cmd.Parameters.AddWithValue("@country", item.Country); cmd.Parameters.AddWithValue("@subcategory", item.PrimaryCategoryName); cmd.Parameters.AddWithValue("@section", section); cmd.Parameters.AddWithValue("@desc", item.Description); cmd.Parameters.AddWithValue("@currency", item.CurrentPrice.currencyID); cmd.Parameters.AddWithValue("@is_auction", is_auction); cmd.Parameters.AddWithValue("@transformated", trans); cmd.Parameters.AddWithValue("@bid", bid); var result = cmd.ExecuteNonQuery(); return is_auction; } catch (Exception ex) { throw new Exception("MySql error: [" + sql + "] [index = " + index + "] [idEbay = " + item.ItemID + "] [url = " + item.ViewItemURLForNaturalSearch + "] [title = " + item.Title + "] [seller = " + item.Seller.UserID + "] [price = " + price + "] [city = " + item.Location + "] [country = " + item.Country + "] [subcategory = " + item.PrimaryCategoryName + "] [section = " + section + "] [desc = " + item.Description + "] [currency = " + item.CurrentPrice.currencyID + "] [is_auction = " + is_auction + "] [transformated = " + trans + "] [bid = " + bid + "]: " + ex.Message, ex); } }