public List <ProductD> allProducts() { var product = (from p in db.Products where p.ACTIVE.Equals("T") select p); if (product != null) { List <ProductD> pro = new List <ProductD>(); foreach (Product prop in product) { ProductD prod = new ProductD { ID = prop.Product_Id, name = prop.Name, description = prop.Description, price = (Double)prop.Price, quantity = prop.Quantity, category = prop.Category, brand = prop.Brand, manufacture = prop.manufacture, discount = (Decimal)prop.Discount, image_url = prop.Image_url, active = (Char)prop.ACTIVE }; pro.Add(prod); } return(pro); } else { return(null); } }
public ProductD productinfor_retrieval_Name(string name) { dynamic prod = (from p in db.Products where p.Name.Equals(name) select p).FirstOrDefault(); if (prod != null) { ProductD product = new ProductD { ID = prod.Product_Id, name = prod.Name, description = prod.Description, price = Convert.ToDouble(prod.Price), quantity = prod.Quantity, category = prod.Category, active = prod.ACTIVE, brand = prod.Brand, manufacture = prod.manufacture, discount = Convert.ToDecimal(prod.Discount), image_url = prod.Image_url }; return(product); } else { return(null); } }
public ProductD productinfor_retrieval_ID(int ID) { var prod = (from p in db.Products where p.Product_Id.Equals(ID) select p).FirstOrDefault(); if (prod != null) { ProductD product = new ProductD { ID = prod.Product_Id, name = prod.Name, description = prod.Description, price = (Double)prod.Price, quantity = prod.Quantity, category = prod.Category, manufacture = prod.manufacture, brand = prod.Brand, discount = (Decimal)prod.Discount, image_url = prod.Image_url, active = (Char)prod.ACTIVE }; return(product); } else { return(null); } }
public int AddProduct(ProductD addP) { Product pro = new Product { Name = addP.name, Description = addP.description, Price = (Decimal)addP.price, Quantity = addP.quantity, Category = addP.category, ACTIVE = addP.active, Brand = addP.brand, manufacture = addP.manufacture, Discount = (Decimal)addP.discount, Image_url = addP.image_url }; db.Products.InsertOnSubmit(pro); try { db.SubmitChanges(); return(0); } catch (Exception ex) { ex.GetBaseException(); return(-1); } }
//line divider added //************************************************************************************************************* //should also pass the instance you want to add //noted changes made //line divider added //************************************************************************************************************* public int EditProduct(ProductD pr, int ID) { var item = (from p in db.Products where p.Product_Id.Equals(ID) select p).FirstOrDefault(); item.Name = pr.name; item.Description = pr.description; item.Price = Convert.ToDecimal(pr.price); item.Quantity = pr.quantity; item.Category = pr.category; item.ACTIVE = pr.active; item.Brand = pr.brand; item.manufacture = pr.manufacture; item.Discount = pr.discount; item.Image_url = pr.image_url; try { db.SubmitChanges(); return(0); } catch (Exception ex) { ex.GetBaseException(); return(-1); } }
public bool Add_to_Cart(ProductD product, int userID, int Qty) { var existpro = (from e in db.Carts where e.Product_Name.Equals(product.name) && e.user_Id.Equals(userID) select e).FirstOrDefault(); if (existpro == null) { Cart cart = new Cart { user_Id = userID, product_Id = product.ID, Quantity = Qty, Product_Name = product.name, Product_Description = product.description, img_url = product.image_url, Total = Convert.ToDecimal(product.price) * Qty, Unit_Price = Convert.ToDecimal(product.price), }; db.Carts.InsertOnSubmit(cart); try { db.SubmitChanges(); return(true); } catch (Exception ex) { ex.GetBaseException(); return(false); } } else { existpro.Quantity += Qty; existpro.Total = Convert.ToDecimal(product.price * existpro.Quantity); try { db.SubmitChanges(); return(true); }catch (Exception e) { e.GetBaseException(); return(false); } } }
public List <ProductD> price_by_DESC(String category) { dynamic Product = null; if (!category.Equals("ALL")) { Product = (from p in db.Products where p.Category.Equals(category) && p.ACTIVE.Equals("T") orderby p.Price descending select p); } else if (category.Equals("ALL")) { Product = (from p in db.Products where p.ACTIVE.Equals("T") orderby p.Price descending select p); } List <ProductD> pro = new List <ProductD>(); foreach (Product prop in Product) { ProductD desc = new ProductD { ID = prop.Product_Id, name = prop.Name, description = prop.Description, price = (Double)prop.Price, quantity = prop.Quantity, category = prop.Category, brand = prop.Brand, manufacture = prop.manufacture, discount = (Decimal)prop.Discount, active = (Char)prop.ACTIVE, image_url = prop.Image_url }; pro.Add(desc); } return(pro); }
//line divider added //************************************************************************************************************* public List <ProductD> search_by_price(Decimal Low, Decimal high, String cat) { dynamic productlist = null; if (!cat.Equals("ALL")) { productlist = (from p in db.Products where p.Price >= Low && p.Price <= high && p.Category.Equals(cat) select p); } else { productlist = (from p in db.Products where p.Price >= Low && p.Price <= high select p); } List <ProductD> priceP = new List <ProductD>(); foreach (Product prop in productlist) { ProductD fprp = new ProductD { ID = prop.Product_Id, name = prop.Name, description = prop.Description, price = (Double)prop.Price, quantity = prop.Quantity, category = prop.Category, brand = prop.Brand, manufacture = prop.manufacture, discount = (Decimal)prop.Discount, active = (Char)prop.ACTIVE, image_url = prop.Image_url }; priceP.Add(fprp); } return(priceP); }
//line divider added //************************************************************************************************************* public List <ProductD> search_by_cat(string category) { var product = (from p in db.Products where p.Category.Equals(category) select p); List <ProductD> catProducts = new List <ProductD>(); if (product != null) { foreach (Product prop in product) { ProductD Fproduct = new ProductD { ID = prop.Product_Id, name = prop.Name, description = prop.Description, price = (Double)prop.Price, quantity = prop.Quantity, category = prop.Category, brand = prop.Brand, manufacture = prop.manufacture, discount = (Decimal)prop.Discount, image_url = prop.Image_url, active = (Char)prop.ACTIVE }; catProducts.Add(Fproduct); } return(catProducts); } else { return(null); } }