public string UpdateCart(int id, Cart cart)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
//from DB
Cart p = db.Carts.Find(id);
p.ID = cart.ID;
p.Amount = cart.Amount;
p.DatePurchased = cart.DatePurchased;
p.ProductID = cart.ProductID;
p.IsInCart = cart.IsInCart;
p.ClientID = cart.ClientID;
db.SaveChanges();
return(cart.DatePurchased + "was successfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public void InsertUserInformation(UserInformation Info)
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
db.UserInformations.Add(Info);
db.SaveChanges();
}
public void UpdateQuantity(int id, int quantity)
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
Cart cart = db.Carts.Find(id);
cart.Amount = quantity;
db.SaveChanges();
}
public UserInformation GetUserInformation(String guId)
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
UserInformation info = (from x in db.UserInformations
where
x.GUID == guId
select x).FirstOrDefault();
return(info);
}
public List <Cart> GetOrdersInCart(string userId)
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
List <Cart> orders = (from x in db.Carts
where x.ClientID == userId && x.IsInCart
orderby x.DatePurchased
select x).ToList();
return(orders);
}
public List <Product> GetAllProducts()
{
try
{
using (db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities())
{
List <Product> products = (from x in db.Products select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public Product GetProduct(int id)
{
try
{
using (db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities())
{
Product product = db.Products.Find(id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public List <Product> GetProductByType(int typeId)
{
try
{
using (db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities())
{
List <Product> products = (from x in db.Products where x.TypeId == typeId select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public string InsertProduct(Product product)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
db.Products.Add(product);
db.SaveChanges();
return(product.Name + "was successfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertCart(Cart cart)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
db.Carts.Add(cart);
db.SaveChanges();
return(cart.DatePurchased + "was successfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public int GetAmountOfOrders(string userId)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
int amount = (from x in db.Carts
where x.ClientID == userId && x.IsInCart
select x.Amount).Sum();
return(amount);
}
catch
{
return(0);
}
}
public void MarkOrdersAsPaid(List <Cart> carts)
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
if (carts != null)
{
foreach (Cart cart in carts)
{
Cart oldCart = db.Carts.Find(cart.ID);
oldCart.DatePurchased = DateTime.Now;
oldCart.IsInCart = false;
}
db.SaveChanges();
}
}
public string DeleteProduct(int id)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
Product product = db.Products.Find(id);
db.Products.Attach(product);
db.Products.Remove(product);
db.SaveChanges();
return(product.Name + "was successfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteCart(int id)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
Cart cart = db.Carts.Find(id);
db.Carts.Attach(cart);
db.Carts.Remove(cart);
db.SaveChanges();
return(cart.DatePurchased + "was successfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProductType(int id, ProductType productType)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
//from DB
ProductType p = db.ProductTypes.Find(id);
p.Name = productType.Name;
db.SaveChanges();
return(productType.Name + "was successfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProduct(int id, Product product)
{
try
{
db_1526927_1526927_co5025Entities db = new db_1526927_1526927_co5025Entities();
//from DB
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 successfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
