public void DeleteTablesThenPopulate()
{
DataClasses1DataContext context = new DataClasses1DataContext();
List<tblItem> items= (from i in context.tblItems select i).ToList<tblItem>();
List<tblCategory> categories = (from i in context.tblCategories select i).ToList<tblCategory>();
try
{
context.tblCategories.DeleteAllOnSubmit(categories);
context.tblItems.DeleteAllOnSubmit(items);
context.SubmitChanges();
}
catch (Exception e)
{
string er = e.ToString();
}
this.EbayTopLevelCategories();
List<string> cats = this.GetCategories();
for (int i = 0; i <= 30; i++)
{
this.FindByCategory(new string[] { cats[i] });
}
}
public List<tblItem> FindByKeyWord(String items)
{
List<tblItem> prodlist = new List<tblItem> { };
FindItemsAdvancedRequest request = new FindItemsAdvancedRequest();
//request.affiliate.trackingId = null;
//request.affiliate.networkId = "9";
// Set request parameters
request.keywords = items;
ItemFilter filter1 = new ItemFilter();
ItemFilter filter2 = new ItemFilter();
ItemFilter filter3 = new ItemFilter();
filter3.name = ItemFilterType.Condition;
filter3.value = new string[] { "1000" };
ItemFilter[] filters = { filter3/*, filter2, filter3*/ };
request.itemFilter = filters;
//request.categoryId = items;
if (request.keywords == null)
{
request.keywords = "ipod";
}
PaginationInput pi = new PaginationInput();
pi.entriesPerPage = 100;
pi.entriesPerPageSpecified = true;
request.paginationInput = pi;
// Call the service
FindItemsAdvancedResponse response = m_client.findItemsAdvanced(request);
SearchItem[] listing = response.searchResult.item;
if (listing != null)
{
foreach (SearchItem i in listing)
{
tblItem items_tbl = new tblItem();
items_tbl.item_category = i.primaryCategory.categoryId;
items_tbl.item_title = i.title;
items_tbl.item_id = i.itemId;
items_tbl.gallery_url = i.galleryURL;
items_tbl.listing_url = i.viewItemURL;
prodlist.Add(items_tbl);
try
{
DataClasses1DataContext context = new DataClasses1DataContext();
context.tblItems.InsertOnSubmit(items_tbl);
context.SubmitChanges();
}
catch (Exception e)
{
string s = e.Message;
}
}
return prodlist;
}
return prodlist;
}
//get categories from item table
//count number of occurances for each
//insert into table vaules category - category count
//return ordered list in decending order
public void SetCategoryCount()
{
DataClasses1DataContext context = new DataClasses1DataContext();
var result = from i in context.tblItems select i.item_category;
var d = result.Distinct();
List<string> dlist = d.ToList<string>();
foreach (string s in d)
{
//update
var query= from update in context.cat_counts
where update.category_id==s
select update;
m_log.Add(query.ToString());
var cnt = context.tblItems.Count(p => p.item_category == s);
foreach(cat_count up in query)
{
dlist.Remove(up.category_id);
up.category_count = cnt;
}//update
try
{
context.SubmitChanges();
m_log.Add(context.Log.ToString());
}
catch (Exception e)
{
string er = e.Message;
}
}
foreach (string s in dlist)
{
var cnt = context.tblItems.Count(p => p.item_category == s);
cat_count catcnt = new cat_count();
catcnt.category_id = s;
catcnt.category_count = cnt;
try
{
context.cat_counts.InsertOnSubmit(catcnt);
context.SubmitChanges();
m_log.Add(context.Log.ToString());
}
catch (Exception e)
{
string er = e.Message;
}
}
}
public void EbayTopLevelCategories()
{
GetCategoriesCall Categories = new GetCategoriesCall(m_api);
Categories.LevelLimit = 2;
Categories.DetailLevelList.Add(DetailLevelCodeType.ReturnAll);
CategoryTypeCollection cats =Categories.GetCategories();
foreach (CategoryType category in cats)
{
m_cats = new tblCategory();
m_cats.category_id= category.CategoryID;
m_cats.category_level = category.CategoryLevel.ToString();
m_cats.category_name = category.CategoryName;
m_cats.category_parent = category.CategoryParentID[0].ToString();
DataClasses1DataContext db = new DataClasses1DataContext();
try
{
DataClasses1DataContext context = new DataClasses1DataContext();
// context.Connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EbayFactoryConnectionString"].ConnectionString;
context.tblCategories.InsertOnSubmit(m_cats);
context.SubmitChanges();
}
catch(Exception e)
{
string er = e.Message;
}
}
}