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);
}
}
