public string UpdateCart(int id, Cart cart)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
//fetch from db
Cart c = dbo.Carts.Find(id);
c.DatePurchased = cart.DatePurchased;
c.ClientID = cart.ClientID;
c.Amount = cart.Amount;
c.IsInCart = cart.IsInCart;
c.ProductID = cart.ProductID;
c.OrderID = cart.OrderID;
dbo.SaveChanges();
return(cart.DatePurchased + " was succesfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string UpdateProduct(int id, Order order)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
//fetch from db
Order o = dbo.Orders.Find(id);
o.UserID = order.UserID;
o.PaymentID = order.PaymentID;
o.OrderDate = order.OrderDate;
o.ShipDate = order.ShipDate;
o.ShipperID = order.ShipperID;
o.Timestamp = order.Timestamp;
o.TransactStatus = order.TransactStatus;
o.ErrorLoc = order.ErrorLoc;
o.ErrorMsg = order.ErrorMsg;
o.IsFullfilled = order.IsFullfilled;
o.IsDeleted = order.IsDeleted;
o.IsPaid = order.IsPaid;
o.PaymentDate = order.PaymentDate;
dbo.SaveChanges();
return(order.OrderId + " was succesfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public void InsertUserInformation(UserInformation info)
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
dbo.UserInformations.Add(info);
dbo.SaveChanges();
}
public string UpdateProduct(int id, Product product)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
//fetch from db
Product p = dbo.Products.Find(id);
p.Name = product.Name;
p.Price = product.Price;
p.TypeId = product.TypeId;
p.Description = product.Description;
p.Image = product.Image;
p.isVisible = product.isVisible;
p.isAvailable = product.isAvailable;
p.Quantity = product.Quantity;
dbo.SaveChanges();
return(product.Name + " was succesfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public UserInformation GetUserInformation(string guId)
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
UserInformation info = (from x in dbo.UserInformations where x.GUID == guId select x).FirstOrDefault();
return(info);
}
// overloading previous function
public List <Product> GetAllProducts(String [] arguments)
{
try
{
/*
* TODO
* select products from db where criteria matches
* function needed for Search.aspx to work
* */
// parse arguments
String argument = "";
using (WatchDBv2Entities dbo = new WatchDBv2Entities())
{
// a really simple and dumb search
// TODO improve
List <Product> products = (from x in dbo.Products
where (x.Name == argument)
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public List <Cart> GetOrdersInCart(string userId)
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
List <Cart> orders = (from x in dbo.Carts where x.ClientID == userId && x.IsInCart orderby x.DatePurchased select x).ToList();
return(orders);
}
public void UpdateQuantity(int id, int quantity)
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
Cart cart = dbo.Carts.Find(id);
cart.Amount = quantity;
dbo.SaveChanges();
}
public Product GetProduct(int id)
{
try {
using (WatchDBv2Entities dbo = new WatchDBv2Entities()) {
Product product = dbo.Products.Find(id);
return(product);
}
}
catch (Exception) {
return(null);
}
}
public string InsertProduct(Product product)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
dbo.Products.Add(product);
dbo.SaveChanges();
return(product.Name + " was succesfully inserted");
}
catch (Exception e) {
return("Error: " + e);
}
}
public List <Product> GetAllProducts()
{
try
{
using (WatchDBv2Entities dbo = new WatchDBv2Entities())
{
List <Product> products = (from x in dbo.Products select x).ToList();
return(products);
}
}
catch (Exception) {
return(null);
}
}
public int GetAmountOfOrders(string userId)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
int amount = (from x in dbo.Carts
where x.ClientID == userId && x.IsInCart
select x.Amount).Sum();
return(amount);
}
catch {
return(0);
}
}
public List <Product> GetProductsByType(int typeId)
{
try
{
using (WatchDBv2Entities dbo = new WatchDBv2Entities())
{
List <Product> products = (from x in dbo.Products where x.TypeId == typeId select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public string InsertCart(Cart cart)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
dbo.Carts.Add(cart);
dbo.SaveChanges();
return(cart.DatePurchased + " was succesfully inserted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string InsertModel(Order order)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
dbo.Orders.Add(order);
dbo.SaveChanges();
return(order.OrderId + " was succesfully inserted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string DeleteProduct(int id)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
Product product = dbo.Products.Find(id);
dbo.Products.Attach(product);
dbo.Products.Remove(product);
dbo.SaveChanges();
return(product.Name + " was succesfully deleted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string DeleteCart(int id)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
Cart cart = dbo.Carts.Find(id);
dbo.Carts.Attach(cart);
dbo.Carts.Remove(cart);
dbo.SaveChanges();
return(cart.DatePurchased + " was succesfully deleted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string DeleteProduct(int id)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
Order order = dbo.Orders.Find(id);
dbo.Orders.Attach(order);
dbo.Orders.Remove(order);
dbo.SaveChanges();
return(order.OrderId + " was succesfully deleted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string UpdateProductType(int id, ProductType productType)
{
try
{
WatchDBv2Entities dbo = new WatchDBv2Entities();
//fetch from db
ProductType p = dbo.ProductTypes.Find(id);
p.Name = productType.Name;
dbo.SaveChanges();
return(productType.Name + " was succesfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public void MarkOrdersAsPaid(List <Cart> carts)
{
// payment...?
WatchDBv2Entities dbo = new WatchDBv2Entities();
if (carts != null)
{
foreach (Cart cart in carts)
{
Cart oldCart = dbo.Carts.Find(cart.ID);
oldCart.DatePurchased = DateTime.Now;
oldCart.IsInCart = false;
// TODO
// could use some improvement code with table "Order"
}
dbo.SaveChanges();
}
}
