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 HttpResponseMessage index()
{
List <ProductofCategory> pc = new List <ProductofCategory>();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
List <CATEGORY> lst_cat = new List <CATEGORY>();
lst_cat = (from e in data.CATEGORies
select e).ToList();
foreach (var item in lst_cat)
{
ProductofCategory temp = new ProductofCategory();
temp.category = item;
int cat_id = temp.category.CATEGORY_ID;
List <PRODUCT> listProduct = new List <PRODUCT>();
temp.listProduct = (from e in data.PRODUCTs
join f in data.PRODUCT_CATEGORY on e.PRODUCT_ID equals f.PRODUCT_ID
where f.CATEGORY_ID == cat_id && e.DELETED == 0
select e).Take(5).ToList();
pc.Add(temp);
}
}
//string json = JsonConvert.SerializeObject(pc);
return(CreateResponse(HttpStatusCode.OK, pc));
}
public HttpResponseMessage GetProduct(int id)
{
FullProductInfo ProductDetail = new FullProductInfo();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
List <MANUFACTURE> list = data.MANUFACTUREs.ToList();
ProductDetail.product = (from e in data.PRODUCTs
where e.PRODUCT_ID == id
select e).FirstOrDefault();
MANUFACTURE m = list.SingleOrDefault(x => x.MANUFACTURE_ID == ProductDetail.product.MANUFACTURE_ID);
ProductDetail.NSX = m.MANUFACTURE_NAME;
ProductDetail.description = (from e in data.PRODUCT_DESCRIPTION
where e.PRODUCT_ID == id
select e).FirstOrDefault();
ProductDetail.attribute = (from e in data.ATTRIBUTEs
where e.PRODUCT_ID == id
select e).ToList();
}
string json = JsonConvert.SerializeObject(ProductDetail);
return(CreateResponse(HttpStatusCode.OK, ProductDetail));
}
public HttpResponseMessage GetAll()
{
ProductAdminViewModel kq = new ProductAdminViewModel();
List <ProductSModel> products = new List <ProductSModel>();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
List <PRODUCT> pro = data.PRODUCTs.ToList();
kq.Mans = data.MANUFACTUREs.ToList();
kq.Cats = data.CATEGORies.ToList();
foreach (var item in pro)
{
ProductSModel s = new ProductSModel();
s.ID = item.PRODUCT_ID;
s.Name = item.MODEL;
s.Image = item.PRODUCT_IMG;
s.Price = item.PRICE;
s.Category = getNameOfCategory(item.PRODUCT_ID, data);
s.NSX = getNameOfNXS((int)item.MANUFACTURE_ID, data);
s.Editing = false;
s.Delete = item.DELETED == 1;
products.Add(s);
}
kq.Products = products;
}
string json = JsonConvert.SerializeObject(products);
return(CreateResponse(HttpStatusCode.OK, kq));
}
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 SearchPage(string keyword)
{
MobileStoreServiceEntities sv = new MobileStoreServiceEntities();
List <PRODUCT> lstProduct = sv.PRODUCTs.Where(x => x.MODEL.Contains(keyword)).ToList();
return(CreateResponse(HttpStatusCode.OK, lstProduct));
}
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 HttpResponseMessage Get(int id)
{
PRODUCT kq = new PRODUCT();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
kq = data.PRODUCTs.FirstOrDefault(p => p.PRODUCT_ID == id);
}
return(CreateResponse(HttpStatusCode.OK, kq));
}
public IHttpActionResult Get()
{
List <ORDER> OrderList = new List <ORDER>();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
OrderList = (from e in data.ORDERS
select e).ToList();
}
return(Ok(OrderList));
}
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 IHttpActionResult GetUserOrder()
{
List <ORDER> OrderList = new List <ORDER>();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
OrderList = (from e in data.ORDERS
where e.USERNAME == User.Identity.Name
select e).ToList();
}
return(Ok(OrderList));
}
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));
}
private string getNameOfNXS(int manId, MobileStoreServiceEntities data)
{
List <MANUFACTURE> mans = data.MANUFACTUREs.ToList();
foreach (var item in mans)
{
if (item.MANUFACTURE_ID == manId)
{
return(item.MANUFACTURE_NAME);
}
}
return("");
}
public HttpResponseMessage Search(string keyword, int?page)
{
int pageSize = 10;
int pageNumber = (page ?? 1);
MobileStoreServiceEntities sv = new MobileStoreServiceEntities();
List <PRODUCT> lstProduct = sv.PRODUCTs.Where(x => x.MODEL.Contains(keyword) && x.DELETED == 0).ToList();
int totalPages = lstProduct.Count / pageSize + 1;
var result = new
{
TotalPages = totalPages,
Products = lstProduct.ToPagedList(pageNumber, pageSize)
};
return(CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage OrderDetail(int id)
{
List <OrderDetailViewModel> kq = new List <OrderDetailViewModel>();
using (MobileStoreServiceEntities db = new MobileStoreServiceEntities())
{
List <ORDER_DETAILS> ords = db.ORDER_DETAILS.Where(o => o.ORDER_ID == id).ToList();
foreach (var item in ords)
{
OrderDetailViewModel ord = new OrderDetailViewModel();
ord.Name = getProductName(item.PRODUCT_ID, db);
ord.Quantity = item.QUANTITY;
ord.Price = item.UNIT_PRICE;
kq.Add(ord);
}
}
return(CreateResponse(HttpStatusCode.OK, kq));
}
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());
}
public HttpResponseMessage GetAll()
{
List <CategoryViewModel> kq = new List <CategoryViewModel>();
List <CATEGORY> list = new List <CATEGORY>();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
list = data.CATEGORies.ToList();
foreach (var item in list)
{
CategoryViewModel cat = new CategoryViewModel();
cat.ID = item.CATEGORY_ID;
cat.Name = item.CATEGORY_NAME;
cat.Editing = false;
kq.Add(cat);
}
}
return(CreateResponse(HttpStatusCode.OK, kq));
}
private string getNameOfCategory(int proId, MobileStoreServiceEntities data)
{
List <PRODUCT_CATEGORY> proCats = data.PRODUCT_CATEGORY.ToList();
List <CATEGORY> cats = data.CATEGORies.ToList();
foreach (var item in proCats)
{
if (item.PRODUCT_ID == proId)
{
foreach (var cat in cats)
{
if (cat.CATEGORY_ID == item.CATEGORY_ID)
{
return(cat.CATEGORY_NAME);
}
}
}
}
return("");
}
public HttpResponseMessage GetProductOfCategory(int id)
{
ProductofCategory kq = new ProductofCategory();
CATEGORY cat = new CATEGORY();
CATEGORY category = new CATEGORY();
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
kq.listProduct = (from e in data.PRODUCT_CATEGORY
join f in data.PRODUCTs on e.PRODUCT_ID equals f.PRODUCT_ID
where e.CATEGORY_ID == id && f.DELETED == 0
select f).Take(10).ToList();
kq.category = (from c in data.CATEGORies
where c.CATEGORY_ID == id
select c).FirstOrDefault();
}
//string json = JsonConvert.SerializeObject(listProduct);
return(CreateResponse(HttpStatusCode.OK, kq));
}
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);
}
private int getIdCat(string cat, MobileStoreServiceEntities data)
{
CATEGORY c = data.CATEGORies.FirstOrDefault(ca => ca.CATEGORY_NAME == cat);
return(c.CATEGORY_ID);
}
private string getProductName(int id, MobileStoreServiceEntities db)
{
PRODUCT p = db.PRODUCTs.FirstOrDefault(s => s.PRODUCT_ID == id);
return(p.MODEL);
}
private int getIdMan(string man, MobileStoreServiceEntities data)
{
MANUFACTURE mans = data.MANUFACTUREs.FirstOrDefault(m => m.MANUFACTURE_NAME == man);
return(mans.MANUFACTURE_ID);
}
