public string InsertCart(Cart cart)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
db.Carts.Add(cart);
db.SaveChanges();
return(cart.DatePurchased + " was successfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public Product GetProduct(int id)
{
try
{
using (YWC_StorageEntities db = new YWC_StorageEntities())
{
Product product = db.Products.Find(id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public string InsertProduct(Product product)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
db.Products.Add(product);
db.SaveChanges();
return(product.Name + " was successfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public Product FindProduct(int id)
{
YWC_StorageEntities db = new YWC_StorageEntities();
ProductModel model = new ProductModel();
Product product = new Product();
foreach (Cart cart in db.Carts)
{
if (cart.ProductID == id)
{
return(cart.Product);
}
}
return(product);
}
public List <ProductType> GetAllProductTypes()
{
try
{
using (YWC_StorageEntities db = new YWC_StorageEntities())
{
List <ProductType> products = (from x in db.ProductTypes
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public void MarkOrdersAsPaid(List <Cart> carts)
{
YWC_StorageEntities db = new YWC_StorageEntities();
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 List <PurchasedProduct> GetAllPurchasedProducts()
{
try
{
using (YWC_StorageEntities db = new YWC_StorageEntities())
{
List <PurchasedProduct> purchasedProducts = (from x in db.PurchasedProducts
select x).ToList();
return(purchasedProducts);
}
}
catch (Exception)
{
return(null);
}
}
public string[] GetAllProductNames()
{
try
{
using (YWC_StorageEntities db = new YWC_StorageEntities())
{
string[] products = (from x in db.ProductTypes
select x.Name).ToArray();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public List <Product> GetAllProductsByType(int typeId)
{
try
{
using (YWC_StorageEntities db = new YWC_StorageEntities())
{
List <Product> products = (from x in db.Products
where x.TypeId == typeId
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public int GetAmountOfOrders(string userId)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
int amount = (from x in db.Carts
where x.ClientID == userId &&
x.IsInCart
select x.Amount).Sum();
return(amount);
}
catch
{
return(0);
}
}
public string DeleteCart(int id)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
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 DeletePurchasedProduct(int id)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
PurchasedProduct purchasedProduct = db.PurchasedProducts.Find(id);
db.PurchasedProducts.Attach(purchasedProduct);
db.PurchasedProducts.Remove(purchasedProduct);
db.SaveChanges();
return(purchasedProduct.Name + " was successfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteProductType(int id)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
ProductType productType = db.ProductTypes.Find(id);
db.ProductTypes.Attach(productType);
db.ProductTypes.Remove(productType);
db.SaveChanges();
return(productType.Name + " was successfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteOrder(int id)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
OrderDetail order = db.OrderDetails.Find(id);
db.OrderDetails.Attach(order);
db.OrderDetails.Remove(order);
db.SaveChanges();
return(order.DatePurchased + " was successfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProductType(int id, ProductType productType)
{
try
{
YWC_StorageEntities db = new YWC_StorageEntities();
//Fetch an object from db
ProductType p = db.ProductTypes.Find(id);
//Replace the data in db
p.Name = productType.Name;
db.SaveChanges();
return(productType.Name + " was successfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public PageContent GetPageContent()
{
YWC_StorageEntities db = new YWC_StorageEntities();
return(db.PageContents.Find(0));
}
private void GetAllOrders()
{
YWC_StorageEntities db = new YWC_StorageEntities();
OrderModel orderModel = new OrderModel();
CartModel cartModel = new CartModel();
List <PurchasedProduct> purchasedList = new List <PurchasedProduct>();
List <Cart> cartList = new List <Cart>();
if (!String.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
int id = Convert.ToInt32(Request.QueryString["id"]);
OrderDetail order = orderModel.GetOrder(id);
foreach (PurchasedProduct purchasedProduct in db.PurchasedProducts)
{
if (purchasedProduct.ClientID == order.ClientID && order.DatePurchased == purchasedProduct.DatePurchased)
{
purchasedList.Add(purchasedProduct);
Cart cart = new Cart();
cart.DatePurchased = purchasedProduct.DatePurchased;
cart.ClientID = purchasedProduct.ClientID;
cart.IsInCart = true;
cart.ProductID = purchasedProduct.TypeId;
cart.Amount = purchasedProduct.Amount;
cartList.Add(cart);
}
}
double subTotal = 0;
CreateOrderTable(cartList, out subTotal);
//Add totals to webpage
double vat = subTotal * tax / 100;
double totalAmount = subTotal + vat;
litTotal.Text = "$" + subTotal;
litVat.Text = vat.ToString("C", new CultureInfo("en-US"));
litTotalAmount.Text = totalAmount.ToString("C", new CultureInfo("en-US"));
litClientName.Text = order.ClientName.ToString();
litClientEmail.Text = order.ClientEmail;
litClientAddress.Text = order.ClientAddress;
litPurchaseDate.Text = order.DatePurchased.ToString();
if (order.Status == "PENDING")
{
lblOrderStatus.Text = "Order Pending";
lblOrderStatusDesc.Text = "Order not yet completed. Please press this button once the food has been made or delivered.";
lnkDeleteOrder.Visible = false;
lnkDeleteOrder.Enabled = false;
buttonSend.Visible = true;
textBoxTracking.Visible = false;
}
else
{
lblOrderStatus.Text = "Order Completed";
lblOrderStatusDesc.Text = "Order is completed. No further action is required.";
lnkDeleteOrder.Visible = true;
lnkDeleteOrder.Enabled = true;
buttonSend.Visible = false;
textBoxTracking.Visible = false;
}
}
}
private void GetAllOrders()
{
YWC_StorageEntities db = new YWC_StorageEntities();
OrderModel orderModel = new OrderModel();
CartModel cartModel = new CartModel();
List <Cart> cartList = new List <Cart>();
if (!String.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
int id = Convert.ToInt32(Request.QueryString["id"]);
OrderDetail order = orderModel.GetOrder(id);
string cartDate = "";
foreach (Cart cart in db.Carts)
{
cartDate = cart.DatePurchased.ToString();
if (cart.ClientID == order.ClientID && order.DatePurchased.ToString() == cartDate)
{
cartList.Add(cart);
}
}
double subTotal = 0;
CreateOrderTable(cartList, out subTotal);
//Add totals to webpage
double vat = subTotal * tax / 100;
double totalAmount = subTotal + shipping + vat;
litTotal.Text = "$ " + subTotal;
litVat.Text = "$ " + vat;
litTotalAmount.Text = "$ " + totalAmount;
litShipping.Text = "$ " + shipping;
litClientName.Text = order.ClientName.ToString();
litClientEmail.Text = order.ClientEmail;
litClientAddress.Text = order.ClientAddress;
litPurchaseDate.Text = order.DatePurchased.ToString();
if (order.Status == "PENDING")
{
lblOrderStatus.Text = "Confirmation Pending";
lblOrderStatusDesc.Text = "Order not yet confirmerd. Please enter the tracking ID number provided by the post office to send delivery confirmation to client.";
lnkDeleteOrder.Visible = false;
lnkDeleteOrder.Enabled = false;
textBoxTracking.Visible = true;
buttonSend.Visible = true;
}
else
{
lblOrderStatus.Text = "Order Confirmed";
lblOrderStatusDesc.Text = "Order is confirmed. No further action is required.";
lnkDeleteOrder.Visible = true;
lnkDeleteOrder.Enabled = true;
textBoxTracking.Visible = false;
buttonSend.Visible = false;
}
}
}
public TaxShipping GetTaxShipping()
{
YWC_StorageEntities db = new YWC_StorageEntities();
return(db.TaxShippings.Find(0));
}