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);
}
}
