public List<Cart> GetOrdersInCart(string clientId)
{
G2Entities db = new G2Entities();
List<Cart> orders = (from x in db.Carts
where x.ClientID == clientId
&& x.IsInChart
orderby x.DatePurchased descending
select x).ToList();
return orders;
}
public string InsertProduct(Product product)
{
try
{
G2Entities db = new G2Entities();
db.Products.Add(product);
db.SaveChanges();
return product.Name + " was succesfully inserted";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string InsertCart(Cart cart)
{
try
{
G2Entities db = new G2Entities();
db.Carts.Add(cart);
db.SaveChanges();
return "Order was succesfully inserted";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public Product GetProduct(int id)
{
try
{
using (G2Entities db = new G2Entities())
{
Product product = db.Products.Find(id);
return product;
}
}
catch (Exception)
{
return null;
}
}
public int GetAmountOfOrders(string clientId)
{
try
{
G2Entities db = new G2Entities();
int amount = (from x in db.Carts
where x.ClientID == clientId
&& x.IsInChart
select x.Amount).Sum();
return amount;
}
catch
{
return 0;
}
}
public string DeleteCart(int id)
{
try
{
G2Entities db = new G2Entities();
Cart cart = db.Carts.Find(id);
db.Carts.Attach(cart);
db.Carts.Remove(cart);
db.SaveChanges();
return cart.DatePurchased + "was succesfully deleted";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string DeleteProduct(int id)
{
try
{
G2Entities db = new G2Entities();
Product product = db.Products.Find(id);
db.Products.Attach(product);
db.Products.Remove(product);
db.SaveChanges();
return product.Name + " was succesfully deleted";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateProductType(int id, ProductType productType)
{
try
{
G2Entities db = new G2Entities();
//Fetch object from db
ProductType p = db.ProductTypes.Find(id);
p.Name = productType.Name;
db.SaveChanges();
return productType.Name + "was succesfully updated";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateProduct(int id, Product product)
{
try
{
G2Entities db = new G2Entities();
Product p = db.Products.Find(id);
p.Name = product.Name;
p.Price = product.Price;
p.TypeId = product.TypeId;
p.Description = product.Description;
p.Image = product.Image;
db.SaveChanges();
return product.Name + " was succesfully updated";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateCart(int id, Cart cart)
{
try
{
G2Entities db = new G2Entities();
//Fetch object from db
Cart p = db.Carts.Find(id);
p.DatePurchased = cart.DatePurchased;
p.ClientID = cart.ClientID;
p.Amount = cart.Amount;
p.IsInChart = cart.IsInChart;
p.ProductID = cart.ProductID;
db.SaveChanges();
return cart.DatePurchased + " was succesfully updated";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public void UpdateQuantity(int id, int quantity)
{
G2Entities db = new G2Entities();
Cart p = db.Carts.Find(id);
p.Amount = quantity;
db.SaveChanges();
}
public List<Product> GetProductsByRank()
{
try
{
using (G2Entities db = new G2Entities())
{
List<Product> products = (from x in db.Products
orderby x.Rank descending
select x).Take(4).ToList();
return products;
}
}
catch (Exception)
{
return null;
}
}
public List<Product> ListNewProducts()
{
G2Entities db = new G2Entities();
List<Product> products = (from x in db.Products orderby x.ProductDate descending select x).Take(4).ToList();
return products;
}
public string GetIdFromName(string ProductName)
{
G2Entities db = new G2Entities();
string productName = (from x in db.Products where x.Name == ProductName select x.Id).ToString();
return productName;
}
public List<string> SearchProduct(string name)
{
G2Entities product = new G2Entities();
return
product.Products.Where(x => x.Name.StartsWith(name, StringComparison.OrdinalIgnoreCase))
.Select(x => x.Name)
.ToList();
}
public void MarkOrdersAsPaid(List<Cart> carts)
{
G2Entities db = new G2Entities();
if (carts != null)
{
foreach (Cart cart in carts)
{
Cart oldCart = db.Carts.Find(cart.ID);
oldCart.DatePurchased = DateTime.Now;
oldCart.IsInChart = false;
}
db.SaveChanges();
}
}
public List<Product> GetAllProducts()
{
try
{
using (G2Entities db = new G2Entities())
{
List<Product> products = (from x in db.Products
select x).ToList();
return products;
}
}
catch (Exception)
{
return null;
}
}
public List<Product> GetProductsByType(int typeId)
{
try
{
using (G2Entities db = new G2Entities())
{
List<Product> products = (from x in db.Products
where x.TypeId == typeId
select x).ToList();
return products;
}
}
catch (Exception)
{
return null;
}
}