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 getSelectSlide() { DBShopDataContext db = new DBShopDataContext(); List <slide> Listslide = db.slides.Where(x => x.status == 1).ToList(); return(Listslide.ParserJSon()); }
public string selectproductlevel1(int cate_id) { DBShopDataContext db = new DBShopDataContext(); List <category> Listcate = db.categories.Where(x => x.id_parent == cate_id).ToList(); List <product> Listpro = db.products.ToList(); List <product> Listprokq = new List <product>(); if (Listcate != null) { foreach (category k in Listcate) { foreach (product p in Listpro) { if (k.id == p.id_type) { p.bill_details.Clear(); p.category = null; p.page_url = null; Listprokq.Add(p); } } } } foreach (product p in Listpro) { if (cate_id == p.id_type) { p.bill_details.Clear(); p.category = null; p.page_url = null; Listprokq.Add(p); } } return(Listprokq.ParserJSon()); }
public string GetCusByMail(string email) { DBShopDataContext db = new DBShopDataContext(); customer cus = db.customers.FirstOrDefault(x => x.email.Equals(email)); cus.bills.Clear(); return(cus.ParserJSon()); }
public string GetIdTypeByIdPro(int idpro) { DBShopDataContext db = new DBShopDataContext(); product pro = db.products.FirstOrDefault(x => x.id == idpro); int kq = (int)pro.id_type; return(kq.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 GetCateByUrl(int id_url) { DBShopDataContext db = new DBShopDataContext(); category cate = db.categories.FirstOrDefault(x => x.id_url == id_url); cate.page_url = null; cate.products.Clear(); return(cate.ParserJSon()); }
public string GetBillByToken(string token) { DBShopDataContext db = new DBShopDataContext(); bill bill = db.bills.FirstOrDefault(x => x.token.Equals(token)); bill.bill_details.Clear(); bill.customer = null; return(bill.ParserJSon()); }
public string GetAllCateGories() { DBShopDataContext db = new DBShopDataContext(); List <category> Listcate = db.categories.Where(x => x.id_parent != null).ToList(); foreach (category k in Listcate) { k.products.Clear(); k.page_url = null; } return(Listcate.ParserJSon()); }
public string countProductByCate(int id_cate) { int count = 0; DBShopDataContext db = new DBShopDataContext(); List <product> Listpro = db.products.Where(x => x.id_type == id_cate).ToList(); foreach (product k in Listpro) { count++; } return(count.ParserJSon()); }
public string getMenu() { DBShopDataContext db = new DBShopDataContext(); List <category> Listcate = db.categories.Where(x => x.id_parent == null).ToList(); List <category> Listcatekq = new List <category>(); foreach (category k in Listcate) { category p = new category(); p.name = k.name; Listcatekq.Add(p); } return(Listcatekq.ParserJSon()); }
public string selectBestSellerProduct() { DBShopDataContext db = new DBShopDataContext(); List <product> Listpro = db.products.Where(x => (x.status == 1) && (x.@new == 1)).ToList(); List <product> Listprokq = new List <product>(); foreach (product k in Listpro) { k.category = null; k.bill_details.Clear(); k.page_url = null; Listprokq.Add(k); } return(Listprokq.ParserJSon()); }
public string getProduct(int id) { DBShopDataContext db = new DBShopDataContext(); product pro = db.products.FirstOrDefault(x => x.id == id); product prokq = new product(); prokq.name = pro.name; prokq.image = pro.image; prokq.price = pro.price; prokq.promotion_price = pro.promotion_price; prokq.promotion = pro.promotion; prokq.detail = pro.detail; prokq.id_type = pro.id_type; prokq.@new = pro.@new; return(prokq.ParserJSon()); }
public bool saveCustomer(string Json) { try { JavaScriptSerializer jss = new JavaScriptSerializer(); customer customer = jss.Deserialize <customer>(Json); DBShopDataContext db = new DBShopDataContext(); db.customers.InsertOnSubmit(customer); db.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool saveBillDetail(string Json) { try { JavaScriptSerializer jss = new JavaScriptSerializer(); bill_detail billdt = jss.Deserialize <bill_detail>(Json); DBShopDataContext db = new DBShopDataContext(); db.bill_details.InsertOnSubmit(billdt); db.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } }
public string login(string email, string password) { customer us = new customer(); DBShopDataContext db = new DBShopDataContext(); List <customer> Listus = db.customers.ToList(); foreach (customer k in Listus) { if (String.Compare(k.email, email, true) == 0 && String.Compare(k.password, password, true) == 0) { us.id = k.id; us.password = k.password; us.email = k.email; } } return(us.ParserJSon()); }
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()); }
public string getListProductBySpecial() { DBShopDataContext db = new DBShopDataContext(); List <product> Listprosp = db.products.Where(x => x.status == (byte)1).ToList(); List <product> Listkqsp = new List <product>(); foreach (product k in Listprosp) { product p = new product(); p.name = k.name; p.image = k.image; p.price = k.price; p.promotion_price = k.promotion_price; p.id = k.id; Listkqsp.Add(p); } return(Listkqsp.ParserJSon()); }
public string getListProductByRelated(int id_type) { DBShopDataContext db = new DBShopDataContext(); List <product> Listprore = db.products.Where(x => x.id_type == id_type).ToList(); List <product> Listkqre = new List <product>(); foreach (product k in Listprore) { product p = new product(); p.name = k.name; p.image = k.image; p.price = k.price; p.promotion_price = k.promotion_price; p.id = k.id; Listkqre.Add(p); } return(Listkqre.ParserJSon()); }
public string getListProductByPromotionPrice() { DBShopDataContext db = new DBShopDataContext(); List <product> Listpropr = db.products.Where(x => x.promotion_price > 0).ToList(); List <product> Listkqpr = new List <product>(); foreach (product k in Listpropr) { product p = new product(); p.name = k.name; p.image = k.image; p.price = k.price; p.promotion_price = k.promotion_price; p.id = k.id; Listkqpr.Add(p); } return(Listkqpr.ParserJSon()); }
public string getListProductBySearch(string keyword) { DBShopDataContext db = new DBShopDataContext(); List <product> Listprobs = db.products.Where(x => x.name.Contains(keyword) == true).ToList();//so sánh chuỗi keyword có hiện diện trong name k List <product> Listkqbs = new List <product>(); foreach (product k in Listprobs) { product p = new product(); p.name = k.name; p.image = k.image; p.price = k.price; p.promotion_price = k.promotion_price; p.id = k.id; p.id_type = k.id_type; Listkqbs.Add(p); } return(Listkqbs.ParserJSon()); }
public string getListProductByNew() { DBShopDataContext db = new DBShopDataContext(); List <product> Listpro = db.products.Where(x => x.@new == (byte)1).ToList(); List <product> Listkq = new List <product>(); foreach (product k in Listpro) { product p = new product(); p.id = k.id; p.id_type = k.id_type; p.name = k.name; p.price = k.price; p.image = k.image; p.promotion_price = k.promotion_price; Listkq.Add(p); } return(Listkq.ParserJSon()); }
public string selectProductByType(int id_type, int id) { DBShopDataContext db = new DBShopDataContext(); List <product> Listprokq = new List <product>(); List <product> Listpro = db.products.Where(x => x.id_type == id_type).ToList(); foreach (product k in Listpro) { if (k.id != id) { product p = new product(); p = k; p.page_url = null; p.category = null; p.bill_details.Clear(); Listprokq.Add(p); } } return(Listprokq.ParserJSon()); }
public bool checkMailExist(string email) { try { DBShopDataContext db = new DBShopDataContext(); List <customer> Listuser = db.customers.ToList(); foreach (customer k in Listuser) { if (String.Compare(k.email, email, true) == 0)//so sánh 2 chuỗi không phân biệt hoa thường { return(true); } else { return(false); } } return(true); } catch (Exception ex) { return(false); } }