public void InsertUserInfo(UserDetail userDetail)
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
db.UserDetails.Add(userDetail);
db.SaveChanges();
}
public UserDetail GetUserDetail(string guId)
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
UserDetail info = (from x in db.UserDetails
where x.GUID == guId
select x).FirstOrDefault();
return(info);
}
public void UpdateQuantity(int ProductID, int quantity)
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
Cart p = db.Carts.Find(ProductID);
p.AmountPurchased = quantity;
db.SaveChanges();
}
public List <Cart> GetOrdersInCart(string CustomerID)
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
List <Cart> orders = (from x in db.Carts
where x.CustomerID == CustomerID &&
x.ProductInCart
orderby x.DatePurchased descending
select x).ToList();
return(orders);
}
public string InsertProductCategory(ProductCat ProductCat)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
db.ProductCats.Add(ProductCat);
db.SaveChanges();
return(ProductCat.ProductCatName + " was succesfully inserted. Please Proceed to Product Page or Insert Another Product Category ");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertShoppingCart(Cart Cart)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
db.Carts.Add(Cart);
db.SaveChanges();
return("Order was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertProduct(Product Product)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
db.Products.Add(Product);
db.SaveChanges();
return(Product.ProductName + " was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public Product GetProduct(int ProductID)
{
try
{
using (db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities())
{
Product product = db.Products.Find(ProductID);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public void MarkOrdersAsPaid(List <Cart> Carts)
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
if (Carts != null)
{
foreach (Cart cart in Carts)
{
Cart oldCart = db.Carts.Find(cart.ShoppingCartID);
oldCart.DatePurchased = DateTime.Now;
oldCart.ProductInCart = false;
}
db.SaveChanges();
}
}
public List <Product> GetAllProducts()
{
try
{
using (db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities())
{
List <Product> products = (from x in db.Products
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public List <Product> GetProductsByCategory(int Category)
{
try
{
using (db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities())
{
List <Product> products = (from x in db.Products
where x.Category == Category
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public int GetAmountOfOrders(string CustomerID)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
int amountPurchased = (from x in db.Carts
where x.CustomerID == CustomerID &&
x.ProductInCart
select x.AmountPurchased).Sum();
return(amountPurchased);
}
catch
{
return(0);
}
}
public string DeleteProductCat(int ProductCatID)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
ProductCat ProductCat = db.ProductCats.Find(ProductCatID);
db.ProductCats.Attach(ProductCat);
db.ProductCats.Remove(ProductCat);
db.SaveChanges();
return(ProductCat.ProductCatName + " was succesfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteShoppingCart(int ShoppingCartID)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
Cart Cart = db.Carts.Find(ShoppingCartID);
db.Carts.Attach(Cart);
db.Carts.Remove(Cart);
db.SaveChanges();
return(Cart.DatePurchased + "was succesfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProductCat(int ProductCatID, ProductCat ProductCat)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
//Fetch object from db
ProductCat p = db.ProductCats.Find(ProductCatID);
p.ProductCatName = ProductCat.ProductCatName;
db.SaveChanges();
return(ProductCat.ProductCatName + " was succesfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProduct(int ProductID, Product Product)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
//Fetch object from db
Product p = db.Products.Find(ProductID);
p.ProductName = Product.ProductName;
p.Price = Product.Price;
p.Category = Product.Category;
p.Description = Product.Description;
p.Image = Product.Image;
db.SaveChanges();
return(Product.ProductName + " was succesfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateShoppingCart(int ShoppingCartID, Cart Cart)
{
try
{
db_1722759_co5027_asgEntities db = new db_1722759_co5027_asgEntities();
//Fetch object from db
Cart p = db.Carts.Find(ShoppingCartID);
p.DatePurchased = Cart.DatePurchased;
p.CustomerID = Cart.CustomerID;
p.ProductID = Cart.ProductID;
p.AmountPurchased = Cart.AmountPurchased;
p.ProductInCart = Cart.ProductInCart;
db.SaveChanges();
return(Cart.DatePurchased + " was succesfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
