public void DeleteOrder(string id)
{
try
{
int orderWithIdToDelete = 0;
if (int.TryParse(id, out orderWithIdToDelete))
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedOrderToDelete = context.Orders.Where(o => o.orderID == orderWithIdToDelete).FirstOrDefault();
if (fetchedOrderToDelete != null)
{
context.Orders.Remove(fetchedOrderToDelete);
context.SaveChanges();
}
else
{
throw new WebFaultException <Error>(new Error("Order with ID " + id + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
}
catch (WebFaultException <Error> ex)
{
throw ex;
}
catch (Exception ex)
{
throw new WebFaultException <Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void UpdateCustomer(Customer customer)
{
try
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedCustomerToUpdate = context.Customers.Where(o => o.custID == customer.custID).FirstOrDefault();
if (fetchedCustomerToUpdate != null)
{
fetchedCustomerToUpdate.firstName = customer.firstName;
fetchedCustomerToUpdate.lastName = customer.lastName;
fetchedCustomerToUpdate.phoneNumber = customer.phoneNumber;
context.SaveChanges();
}
else
{
throw new WebFaultException <Error>(new Error("Customer with ID " + customer.custID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
catch (Exception ex)
{
throw new WebFaultException <Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void DeleteCart(string orderId, string prodId)
{
try
{
int orderIdToDelete = 0;
int prodIdToDelete = 0;
if (int.TryParse(orderId, out orderIdToDelete) && int.TryParse(prodId, out prodIdToDelete))
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedCartToDelete = context.Carts.Where(o => o.orderID == orderIdToDelete && o.prodID == prodIdToDelete).FirstOrDefault();
if (fetchedCartToDelete != null)
{
context.Carts.Remove(fetchedCartToDelete);
context.SaveChanges();
}
else
{
throw new WebFaultException <Error>(new Error("Cart with order ID " + orderId + " and product ID " + prodId + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
}
catch (WebFaultException <Error> ex)
{
throw ex;
}
catch (Exception ex)
{
throw new WebFaultException <Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void AddProduct(Product product)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
context.Products.Add(product.GenerateDbModel());
context.SaveChanges();
}
}
public void AddOrder(Order order)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
context.Orders.Add(order.GenerateDbModel());
context.SaveChanges();
}
}
public void AddOrder(Order order)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
context.Orders.Add(order.GenerateDbModel());
context.SaveChanges();
}
}
public void AddCustomer(Customer customer)
{
try
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
context.Customers.Add(customer.GenerateDbModel());
context.SaveChanges();
}
}
catch (Exception ex)
{
throw new WebFaultException<Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void AddCustomer(Customer customer)
{
try
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
context.Customers.Add(customer.GenerateDbModel());
context.SaveChanges();
}
}
catch (Exception ex)
{
throw new WebFaultException <Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void UpdateCart(Cart cart)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedCartToUpdate = context.Carts.Where(o => o.orderID == cart.orderID && o.prodID == cart.prodID).FirstOrDefault();
if (fetchedCartToUpdate != null)
{
fetchedCartToUpdate.quantity = cart.quantity;
context.SaveChanges();
}
else
{
throw new WebFaultException <Error>(new Error("Cart with order ID " + cart.orderID + " and product ID " + cart.prodID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
public void UpdateOrder(Order order)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedOrderToUpdate = context.Orders.Where(o => o.orderID == order.orderID).FirstOrDefault();
if (fetchedOrderToUpdate != null)
{
fetchedOrderToUpdate.custID = order.custID;
fetchedOrderToUpdate.orderDate = order.orderDate;
fetchedOrderToUpdate.poNumber = order.poNumber;
context.SaveChanges();
}
else
{
throw new WebFaultException <Error>(new Error("Order with ID " + order.orderID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
public void UpdateProduct(Product product)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedProductToUpdate = context.Products.Where(o => o.prodID == product.prodID).FirstOrDefault();
if (fetchedProductToUpdate != null)
{
fetchedProductToUpdate.prodName = product.prodName;
fetchedProductToUpdate.price = product.price;
fetchedProductToUpdate.prodWeight = product.prodWeight;
fetchedProductToUpdate.inStock = product.inStock;
context.SaveChanges();
}
else
{
throw new WebFaultException <Error>(new Error("Product with ID " + product.prodID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
public void AddCart(Cart cart)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var product = context.Products.Where(o => o.prodID == cart.prodID).FirstOrDefault();
if (product == null)
{
throw new WebFaultException <Error>(new Error("Product with ID " + cart.prodID + " does not exist.", ""), System.Net.HttpStatusCode.BadRequest);
}
else if (product.inStock == false)
{
throw new WebFaultException <Error>(new Error("Product with ID " + cart.prodID + " not in stock.", ""), System.Net.HttpStatusCode.BadRequest);
}
else
{
context.Carts.Add(cart.GenerateDbModel());
context.SaveChanges();
}
}
}
public void AddCart(Cart cart)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var product = context.Products.Where(o => o.prodID == cart.prodID).FirstOrDefault();
if (product == null)
{
throw new WebFaultException<Error>(new Error("Product with ID " + cart.prodID + " does not exist.",""), System.Net.HttpStatusCode.BadRequest);
}
else if (product.inStock == false)
{
throw new WebFaultException<Error>(new Error("Product with ID " + cart.prodID + " not in stock.", ""), System.Net.HttpStatusCode.BadRequest);
}
else
{
context.Carts.Add(cart.GenerateDbModel());
context.SaveChanges();
}
}
}
public void DeleteOrder(string id)
{
try
{
int orderWithIdToDelete = 0;
if (int.TryParse(id, out orderWithIdToDelete))
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedOrderToDelete = context.Orders.Where(o => o.orderID == orderWithIdToDelete).FirstOrDefault();
if (fetchedOrderToDelete != null)
{
context.Orders.Remove(fetchedOrderToDelete);
context.SaveChanges();
}
else
{
throw new WebFaultException<Error>(new Error("Order with ID " + id + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
}
catch (WebFaultException<Error> ex)
{
throw ex;
}
catch (Exception ex)
{
throw new WebFaultException<Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void UpdateCart(Cart cart)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedCartToUpdate = context.Carts.Where(o => o.orderID == cart.orderID && o.prodID == cart.prodID).FirstOrDefault();
if (fetchedCartToUpdate != null)
{
fetchedCartToUpdate.quantity = cart.quantity;
context.SaveChanges();
}
else
{
throw new WebFaultException<Error>(new Error("Cart with order ID " + cart.orderID + " and product ID " + cart.prodID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
public void UpdateCustomer(Customer customer)
{
try
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedCustomerToUpdate = context.Customers.Where(o => o.custID == customer.custID).FirstOrDefault();
if (fetchedCustomerToUpdate != null)
{
fetchedCustomerToUpdate.firstName = customer.firstName;
fetchedCustomerToUpdate.lastName = customer.lastName;
fetchedCustomerToUpdate.phoneNumber = customer.phoneNumber;
context.SaveChanges();
}
else
{
throw new WebFaultException<Error>(new Error("Customer with ID " + customer.custID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
catch (Exception ex)
{
throw new WebFaultException<Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void UpdateOrder(Order order)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedOrderToUpdate = context.Orders.Where(o => o.orderID == order.orderID).FirstOrDefault();
if (fetchedOrderToUpdate != null)
{
fetchedOrderToUpdate.custID = order.custID;
fetchedOrderToUpdate.orderDate = order.orderDate;
fetchedOrderToUpdate.poNumber = order.poNumber;
context.SaveChanges();
}
else
{
throw new WebFaultException<Error>(new Error("Order with ID " + order.orderID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
public void UpdateProduct(Product product)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedProductToUpdate = context.Products.Where(o => o.prodID == product.prodID).FirstOrDefault();
if (fetchedProductToUpdate != null)
{
fetchedProductToUpdate.prodName = product.prodName;
fetchedProductToUpdate.price = product.price;
fetchedProductToUpdate.prodWeight = product.prodWeight;
fetchedProductToUpdate.inStock = product.inStock;
context.SaveChanges();
}
else
{
throw new WebFaultException<Error>(new Error("Product with ID " + product.prodID + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
public void DeleteCart(string orderId, string prodId)
{
try
{
int orderIdToDelete = 0;
int prodIdToDelete = 0;
if (int.TryParse(orderId, out orderIdToDelete) && int.TryParse(prodId, out prodIdToDelete))
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
var fetchedCartToDelete = context.Carts.Where(o => o.orderID == orderIdToDelete && o.prodID == prodIdToDelete).FirstOrDefault();
if (fetchedCartToDelete != null)
{
context.Carts.Remove(fetchedCartToDelete);
context.SaveChanges();
}
else
{
throw new WebFaultException<Error>(new Error("Cart with order ID " + orderId + " and product ID " + prodId + " not found.", ""), System.Net.HttpStatusCode.NotFound);
}
}
}
}
catch (WebFaultException<Error> ex)
{
throw ex;
}
catch (Exception ex)
{
throw new WebFaultException<Error>(new Error("Unexpected exception!", ex.Message), System.Net.HttpStatusCode.InternalServerError);
}
}
public void AddProduct(Product product)
{
using (var context = new Models.CrazyMelvinsShoppingEmporiumDbEntities())
{
context.Products.Add(product.GenerateDbModel());
context.SaveChanges();
}
}
