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 AddCart(customer_cart_time ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.customer_cart_times.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return(true);
}
public bool AddCate(cat catss)
{
LQDataContext ctxs = new LQDataContext();
ctxs.cats.InsertOnSubmit(catss);
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 bool AddProduct(prod pr)
{
LQDataContext ctxs = new LQDataContext();
ctxs.prods.InsertOnSubmit(pr);
ctxs.SubmitChanges();
return(true);
}
public bool AddCustomer(cust ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.custs.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return(true);
}
public bool AddimgProd(img_prod imp)
{
LQDataContext ctxs = new LQDataContext();
ctxs.img_prods.InsertOnSubmit(imp);
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 AddimgProd(product_image imp)
{
LQDataContext ctxs = new LQDataContext();
ctxs.product_images.InsertOnSubmit(imp);
ctxs.SubmitChanges();
return(true);
}
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 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 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 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 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 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 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 UpdateProduct(prod pr)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.prods.Where(d => d.id_pro == pr.id_pro).SingleOrDefault();
q.id_cat = pr.id_cat;
q.pro_name = pr.pro_name;
q.pro_price = pr.pro_price;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public bool DeleteProduct(int id)
{
try
{
LQDataContext dm = new LQDataContext();
var q = (from a in dm.category_product_details
where a.id_pro == id
select a).SingleOrDefault();
dm.category_product_details.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 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 void UpdateUser(user_detail un)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.user_details.Where(d => d.user_id == un.user_id).SingleOrDefault();
q.user_name = un.user_name;
q.user_fullname = un.user_fullname;
q.user_pro_image = un.user_pro_image;
q.user_age = un.user_age;
q.user_email = un.user_email;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
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 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 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 bool AdddtCart(detail_cart ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.detail_carts.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return true;
}
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 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 bool AddimgProd(img_prod imp)
{
LQDataContext ctxs = new LQDataContext();
ctxs.img_prods.InsertOnSubmit(imp);
ctxs.SubmitChanges();
return true;
}
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 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 void UpdateProduct(prod pr)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.prods.Where(d => d.id_pro == pr.id_pro).SingleOrDefault();
q.id_cat = pr.id_cat;
q.pro_name = pr.pro_name;
q.pro_price = pr.pro_price;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public bool AddProduct(prod pr)
{
LQDataContext ctxs = new LQDataContext();
ctxs.prods.InsertOnSubmit(pr);
ctxs.SubmitChanges();
return true;
}
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;
}
}