public bool AddCate(cat catss)
{
LQDataContext ctxs = new LQDataContext();
ctxs.cats.InsertOnSubmit(catss);
ctxs.SubmitChanges();
return true;
}
public void UpdateCate(cat ca)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.cats.Where(d => d.id_cat == ca.id_cat).SingleOrDefault();
q.cat_name = ca.cat_name;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public bool AddimgProd(img_prod imp)
{
LQDataContext ctxs = new LQDataContext();
ctxs.img_prods.InsertOnSubmit(imp);
ctxs.SubmitChanges();
return(true);
}
public user_name getUserbyID(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.user_names
where a.id_user == id
select a).SingleOrDefault();
return q;
}
public cat getCate(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.cats
where a.id_cat == id
select a).SingleOrDefault();
return q;
}
public bool AddCate(cat catss)
{
LQDataContext ctxs = new LQDataContext();
ctxs.cats.InsertOnSubmit(catss);
ctxs.SubmitChanges();
return(true);
}
public bool AddCart(customer_cart_time ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.customer_cart_times.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return(true);
}
public bool AddCustomer(cust ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.custs.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return(true);
}
public bool AddimgProd(product_image imp)
{
LQDataContext ctxs = new LQDataContext();
ctxs.product_images.InsertOnSubmit(imp);
ctxs.SubmitChanges();
return(true);
}
public bool AddProduct(prod pr)
{
LQDataContext ctxs = new LQDataContext();
ctxs.prods.InsertOnSubmit(pr);
ctxs.SubmitChanges();
return(true);
}
public bool AdddtCart(detail_cart ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.detail_carts.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return(true);
}
public bool AddProduct(category_product_detail pr)
{
LQDataContext ctxs = new LQDataContext();
ctxs.category_product_details.InsertOnSubmit(pr);
ctxs.SubmitChanges();
return(true);
}
public List <prod> getTopProduct(int top)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.prods
orderby t.pro_price
select t).Take(top);
return(list.ToList());
}
public List <prod> getCateProduct(int cate)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.prods
where t.id_cat == cate
select t);
return(list.ToList());
}
public List <img_prod> getProdImage(int idprod)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.img_prods
where t.id_prod == idprod
select t);
return(list.ToList());
}
public cust getCusbyID(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.custs
where a.id_cus == id
select a).SingleOrDefault();
return(q);
}
public List <cart> getCustomerCart(int idcus)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.carts
where t.id_cus == idcus
select t);
return(list.ToList());
}
public List <detail_cart> getDetailCartID(int idcart)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.detail_carts
where t.id_cart == idcart
select t);
return(list.ToList());
}
public detail_cart getdtCart(int id_Cart)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.detail_carts
where a.id_cart == id_Cart
select a).SingleOrDefault();
return(q);
}
public void updatedtCart(detail_cart dtc)
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.detail_carts.Where(d => d.id_dtcart == dtc.id_dtcart).SingleOrDefault();
q.id_pro = dtc.id_pro;
q.quanlity = dtc.quanlity;
ctxx.SubmitChanges();
}
public user_detail getUserbyID(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.user_details
where a.user_id == id
select a).SingleOrDefault();
return(q);
}
public prod getProduct(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.prods
where a.id_pro == id
select a).SingleOrDefault();
return(q);
}
public user_name getUserbyID(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.user_names
where a.id_user == id
select a).SingleOrDefault();
return(q);
}
public img_prod getImage(int id)
{
LQDataContext ctx = new LQDataContext();
var n = (from t in ctx.img_prods
where t.id_img == id
select t).SingleOrDefault();
return(n);
}
public cat getCate(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.cats
where a.id_cat == id
select a).SingleOrDefault();
return(q);
}
public category_product_detail getProduct(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.category_product_details
where a.id_pro == id
select a).SingleOrDefault();
return(q);
}
public List <category_product_detail> getCateProduct(int cate)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.category_product_details
where t.id_cat == cate
select t);
return(list.ToList());
}
public img_prod getMainimg(int idprod)
{
LQDataContext ctx = new LQDataContext();
var azz = (from t in ctx.img_prods
where t.id_prod == idprod
where t.stt_img == 1
select t).SingleOrDefault();
return(azz);
}
public void UpdateCate(category_name ca)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.category_names.Where(d => d.id_cat == ca.id_cat).SingleOrDefault();
q.cat_name = ca.cat_name;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public void UpdateCate(cart ca)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.carts.Where(d => d.id_cart == ca.id_cart).SingleOrDefault();
q.time_cart = ca.time_cart;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public void SetSttImage(img_prod imp, int mstt)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.img_prods.Where(d => d.id_img == imp.id_img).SingleOrDefault();
q.stt_img = mstt;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public void UpdateimgProd(img_prod imp)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.img_prods.Where(d => d.id_img == imp.id_img).SingleOrDefault();
q.img_url = imp.img_url;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public void UpdateUserPass(user_detail un)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.user_details.Where(d => d.user_id == un.user_id).SingleOrDefault();
q.user_password = un.user_password;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public void UpdateUserPass(user_name un)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.user_names.Where(d => d.id_user == un.id_user).SingleOrDefault();
q.password = un.password;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public void UpdateUserPass(user_name un)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.user_names.Where(d => d.id_user == un.id_user).SingleOrDefault();
q.password = un.password;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public int getUser(string name, string pass)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.user_names
where a.user_name1 == name
where a.password == pass
where a.id_usrole == 1
select a).SingleOrDefault();
if (q == null)
{
return -1;
}
else
{
return q.id_user;
}
}
public void UpdateUser(user_name un)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.user_names.Where(d => d.id_user == un.id_user).SingleOrDefault();
q.user_name1 = un.user_name1;
q.usFulname = un.usFulname;
q.usImg = un.usImg;
q.usAge = un.usAge;
q.email = un.email;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public List<cart> getCustomerCart(int idcus)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.carts
where t.id_cus == idcus
select t);
return list.ToList();
}
public bool checkalcate(string name)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.cats
where a.cat_name == name
select a).SingleOrDefault();
if (q == null)
{
return true;
}
else
{
return false;
}
}
public img_prod getMainimg(int idprod)
{
LQDataContext ctx = new LQDataContext();
var azz = (from t in ctx.img_prods
where t.id_prod == idprod
where t.stt_img == 1
select t).SingleOrDefault();
return azz;
}
//all about detail cart
public List<detail_cart> getAlldtCart()
{
LQDataContext ctx = new LQDataContext();
return ctx.detail_carts.ToList();
}
public bool DeleteCustomer(int id)
{
try
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.custs
where a.id_cus == id
select a).SingleOrDefault();
dm.custs.DeleteOnSubmit(q);
dm.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
public bool DeleteImgProd(int id)
{
try
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.img_prods
where a.id_img == id
select a).SingleOrDefault();
dm.img_prods.DeleteOnSubmit(q);
dm.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
public void UpdateCustomer(cust ca)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.custs.Where(d => d.id_cus == ca.id_cus).SingleOrDefault();
q.cus_name = ca.cus_name;
q.email = ca.email;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public bool AddCustomer(cust ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.custs.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return true;
}
public bool DeletedtCart(int id_dtCart)
{
try
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.detail_carts
where a.id_dtcart == id_dtCart
select a).SingleOrDefault();
dm.detail_carts.DeleteOnSubmit(q);
dm.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
public void updatedtCart(detail_cart dtc)
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.detail_carts.Where(d => d.id_dtcart == dtc.id_dtcart).SingleOrDefault();
q.id_pro = dtc.id_pro;
q.quanlity = dtc.quanlity;
ctxx.SubmitChanges();
}
//all about image
public List<img_prod> getAllimgpro()
{
LQDataContext ctx = new LQDataContext();
return ctx.img_prods.ToList();
}
public List<img_prod> getProdImage(int idprod)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.img_prods
where t.id_prod == idprod
select t);
return list.ToList();
}
public img_prod getImage(int id)
{
LQDataContext ctx = new LQDataContext();
var n = (from t in ctx.img_prods
where t.id_img == id
select t).SingleOrDefault();
return n;
}
public cust getCusbyID(int id)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.custs
where a.id_cus == id
select a).SingleOrDefault();
return q;
}
public bool AdddtCart(detail_cart ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.detail_carts.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return true;
}
public int checkCus(string name, string email)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.custs
where a.cus_name == name
where a.email == email
select a).SingleOrDefault();
if (q == null)
{
return -1;
}
else
{
return q.id_cus;
}
}
public void SetSttImage(img_prod imp, int mstt)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.img_prods.Where(d => d.id_img == imp.id_img).SingleOrDefault();
q.stt_img = mstt;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public void UpdateimgProd(img_prod imp)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.img_prods.Where(d => d.id_img == imp.id_img).SingleOrDefault();
q.img_url = imp.img_url;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public List<detail_cart> getDetailCartID(int idcart)
{
LQDataContext ctx = new LQDataContext();
var list = (from t in ctx.detail_carts
where t.id_cart == idcart
select t);
return list.ToList();
}
public bool checkdtCart(int id_dtCart, int id_proz)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.detail_carts
where a.id_dtcart == id_dtCart
where a.id_pro == id_proz
select a).SingleOrDefault();
if (q != null)
{
return true;
}
else
{
return false;
}
}
public bool AddimgProd(img_prod imp)
{
LQDataContext ctxs = new LQDataContext();
ctxs.img_prods.InsertOnSubmit(imp);
ctxs.SubmitChanges();
return true;
}
public detail_cart getdtCart(int id_Cart)
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.detail_carts
where a.id_cart == id_Cart
select a).SingleOrDefault();
return q;
}
//all about category
public List<cat> getAllCate()
{
LQDataContext ctx = new LQDataContext();
return ctx.cats.ToList();
}
