public string selectUrlByUrl(string url)
{
DBShopDataContext db = new DBShopDataContext();
page_url pageurl = db.page_urls.FirstOrDefault(x => x.url.Equals(url));
return(pageurl.id.ParserJSon());
}
public string selectUrlByIdCate(int id_cate)
{
DBShopDataContext db = new DBShopDataContext();
category cate = db.categories.FirstOrDefault(x => x.id == id_cate);
page_url pageurl = db.page_urls.FirstOrDefault(x => x.id == cate.id_url);
string url = pageurl.url;
return(url);
}
public string selectUrlByIdPro(int id)
{
DBShopDataContext db = new DBShopDataContext();
product pro = db.products.FirstOrDefault(x => x.id == id);
page_url pageurl = db.page_urls.FirstOrDefault(x => x.id == pro.id_url);
string url = pageurl.url;
return(url);
}
public string getNameType(string url)
{
DBShopDataContext db = new DBShopDataContext();
category cate = new category();
page_url pageurl = db.page_urls.FirstOrDefault(x => Equals(x.url, url));
List <category> Listcate = db.categories.ToList();
foreach (category k in Listcate)
{
if (pageurl.id == k.id_url)
{
cate = k;
}
}
cate.products.Clear();
cate.page_url = null;
return(cate.ParserJSon());
}
