public IHttpActionResult AddProduct(AddProductViewModel p)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
PRODUCT pro = new PRODUCT();
pro.MODEL = p.Name;
pro.MANUFACTURE_ID = (int)getIdMan(p.NSX, data);
pro.PRICE = p.Price;
pro.QUANTITY = 100;
pro.MODEL_ID = "MSP_01";
pro.DELETED = 0;
data.PRODUCTs.Add(pro);
data.SaveChanges();
PRODUCT_CATEGORY pc = new PRODUCT_CATEGORY();
PRODUCT newPro = data.PRODUCTs.ToList()[data.PRODUCTs.Count() - 1];
pc.PRODUCT_ID = newPro.PRODUCT_ID;
pc.CATEGORY_ID = getIdCat(p.Category, data);
data.PRODUCT_CATEGORY.Add(pc);
data.SaveChanges();
}
return(Ok());
}
public IHttpActionResult Submit(SubmitOrderModel data)
{
MobileStoreServiceEntities db = new MobileStoreServiceEntities();
try
{
ORDER order = new ORDER();
order.NAME = data.user_info.name;
order.ADDRESS = data.user_info.address;
order.PHONE = data.user_info.phone;
order.USERNAME = data.user_info.username;
order.ORDER_DATE = DateTime.Now;
order.PAID = 0;
order.DELETED = 0;
db.ORDERS.Add(order);
db.SaveChanges();
if (CreateOrder(order, data) == false)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
catch (Exception e)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
return(Ok());
}
public HttpResponseMessage EditCategory(EditCategoryModel model)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
CATEGORY c = data.CATEGORies.FirstOrDefault(cat => cat.CATEGORY_ID == model.ID);
c.CATEGORY_NAME = model.Name;
data.SaveChanges();
}
return(CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Paid(int id)
{
using (MobileStoreServiceEntities db = new MobileStoreServiceEntities())
{
ORDER o = db.ORDERS.FirstOrDefault(or => or.ORDER_ID == id);
o.PAID = 1;
db.SaveChanges();
}
return(CreateResponse(HttpStatusCode.OK));
}
public IHttpActionResult Remove(int id)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
PRODUCT pro = data.PRODUCTs.FirstOrDefault(p => p.PRODUCT_ID == id);
pro.DELETED = 1;
data.SaveChanges();
}
return(Ok());
}
public HttpResponseMessage UploadImg(UploadImgModel model)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
PRODUCT kq = data.PRODUCTs.FirstOrDefault(p => p.PRODUCT_ID == model.ID);
kq.PRODUCT_IMG = model.Link;
data.SaveChanges();
}
return(CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage AddCategory(string name)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
CATEGORY c = new CATEGORY();
c.CATEGORY_NAME = name;
c.HOME_PAGE = 1;
data.CATEGORies.Add(c);
data.SaveChanges();
}
return(CreateResponse(HttpStatusCode.OK));
}
public IHttpActionResult EditProduct(int id, string name, string cat, string man, double price)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
PRODUCT pro = data.PRODUCTs.FirstOrDefault(p => p.PRODUCT_ID == id);
pro.MODEL = name;
pro.MANUFACTURE_ID = (int)getIdMan(man, data);
pro.PRICE = price;
int idCat = getIdCat(cat, data);
PRODUCT_CATEGORY pcd = data.PRODUCT_CATEGORY.FirstOrDefault(pcds => pcds.PRODUCT_ID == id);
data.PRODUCT_CATEGORY.Remove(pcd);
PRODUCT_CATEGORY pc = new PRODUCT_CATEGORY();
pc.PRODUCT_ID = id;
pc.CATEGORY_ID = idCat;
data.PRODUCT_CATEGORY.Add(pc);
data.SaveChanges();
}
return(Ok());
}
private bool CreateOrder(ORDER order, SubmitOrderModel data)
{
MobileStoreServiceEntities db = new MobileStoreServiceEntities();
double orderTotal = 0;
try
{
// Iterate over the items in the cart,
// adding the order details for each
foreach (var item in data.order_info)
{
PRODUCT product = db.PRODUCTs.First(x => x.PRODUCT_ID == item.product_id);
product.QUANTITY -= item.quantity;
var orderDetail = new ORDER_DETAILS
{
PRODUCT_ID = item.product_id,
ORDER_ID = order.ORDER_ID,
UNIT_PRICE = item.unit_price,
QUANTITY = item.quantity
};
// Set the order total of the shopping cart
orderTotal += (item.quantity * item.unit_price);
db.ORDER_DETAILS.Add(orderDetail);
}
// Set the order's total to the orderTotal count
ORDER nOrder = db.ORDERS.First(o => o.ORDER_ID == order.ORDER_ID);
nOrder.TOTAL = orderTotal;
// Save the order
db.SaveChanges();
}
catch
{
return(false);
}
// Return the OrderId as the confirmation number
return(true);
}
