public bool InsertOrderDetail(OrderDetail newOrderDetail)
{
try
{
WebShopEntities db = new WebShopEntities();
OrderDetail orderDetail = new OrderDetail();
orderDetail.idProduct = newOrderDetail.idProduct;
orderDetail.quantity = newOrderDetail.quantity;
orderDetail.price = newOrderDetail.price;
orderDetail.totalPrice = newOrderDetail.totalPrice;
orderDetail.id = (from c in db.OrderDetails orderby c.id descending select c.id).First() + 1;
if (orderDetail.id < 10)
{
orderDetail.code = "ORDT00" + orderDetail.id;
}
else if (orderDetail.id >= 10 && orderDetail.id < 100)
{
orderDetail.code = "ORDT0" + orderDetail.id;
}
else
{
orderDetail.code = "ORDT" + orderDetail.id;
}
db.OrderDetails.Add(orderDetail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool InsertImportBillDetail(ImportBillDetail newImportBillDetail)
{
try
{
WebShopEntities db = new WebShopEntities();
ImportBillDetail importBillDetail = new ImportBillDetail();
importBillDetail.quantity = newImportBillDetail.quantity;
importBillDetail.price = newImportBillDetail.price;
importBillDetail.totalPrice = newImportBillDetail.totalPrice;
importBillDetail.id = (from c in db.ImportBillDetails orderby c.id descending select c.id).First() + 1;
if (importBillDetail.id < 10)
{
importBillDetail.code = "IMTDT00" + importBillDetail.id;
}
else if (importBillDetail.id >= 10 && importBillDetail.id < 100)
{
importBillDetail.code = "IMTDT0" + importBillDetail.id;
}
else
{
importBillDetail.code = "IMTDT" + importBillDetail.id;
}
db.ImportBillDetails.Add(importBillDetail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool InsertOrder(Order newOrder)
{
try
{
WebShopEntities db = new WebShopEntities();
Order order = new Order();
order.email = newOrder.email;
order.userId = newOrder.userId;
order.address = newOrder.address;
order.total = newOrder.total;
order.status = newOrder.status;
order.id = (from c in db.Orders orderby c.id descending select c.id).First() + 1;
if (order.id < 10)
{
order.code = "OR00" + order.id;
}
else if (order.id >= 10 && order.id < 100)
{
order.code = "OR0" + order.id;
}
else
{
order.code = "OR" + order.id;
}
db.Orders.Add(order);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool InsertImportBill(ImportBill newImportBill)
{
try
{
WebShopEntities db = new WebShopEntities();
ImportBill importBill = new ImportBill();
importBill.agencyName = newImportBill.agencyName;
importBill.address = newImportBill.address;
importBill.phone = newImportBill.phone;
importBill.total = newImportBill.total;
importBill.id = (from c in db.ImportBills orderby c.id descending select c.id).First() + 1;
if (importBill.id < 10)
{
importBill.code = "IMT00" + importBill.id;
}
else if (importBill.id >= 10 && importBill.id < 100)
{
importBill.code = "IMT0" + importBill.id;
}
else
{
importBill.code = "IMT" + importBill.id;
}
db.ImportBills.Add(importBill);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateProduct(int id, Product newProduct)
{
try
{
WebShopEntities db = new WebShopEntities();
Product product = db.Products.FirstOrDefault(x => x.id == id);
if (product == null)
{
return(false);
}
product.code = newProduct.code;
product.name = newProduct.name;
product.description = newProduct.description;
product.detail = newProduct.detail;
product.idCategory = newProduct.idCategory;
product.price = newProduct.price;
product.quantity = newProduct.quantity;
product.image = newProduct.image;
product.discount = newProduct.discount;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool InsertCategory(Category newCategory)
{
try
{
WebShopEntities db = new WebShopEntities();
Category category = new Category();
category.name = newCategory.name;
category.description = newCategory.description;
category.id = (from c in db.Categories orderby c.id descending select c.id).First() + 1;
if (category.id < 10)
{
category.code = "CAT00" + category.id;
}
else if (category.id >= 10 && category.id < 100)
{
category.code = "CAT0" + category.id;
}
else
{
category.code = "CAT" + category.id;
}
db.Categories.Add(category);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteOrderDetail(int id)
{
try
{
WebShopEntities db = new WebShopEntities();
OrderDetail orderDetail = db.OrderDetails.FirstOrDefault(x => x.id == id);
if (orderDetail == null)
{
return(false);
}
db.OrderDetails.Remove(orderDetail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteImportBill(int id)
{
try
{
WebShopEntities db = new WebShopEntities();
ImportBill importBill = db.ImportBills.FirstOrDefault(x => x.id == id);
if (importBill == null)
{
return(false);
}
db.ImportBills.Remove(importBill);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteCategory(int id)
{
try
{
WebShopEntities db = new WebShopEntities();
Category category = db.Categories.FirstOrDefault(x => x.id == id);
if (category == null)
{
return(false);
}
db.Categories.Remove(category);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteProduct(int id)
{
try
{
WebShopEntities db = new WebShopEntities();
Product product = db.Products.FirstOrDefault(x => x.id == id);
if (product == null)
{
return(false);
}
db.Products.Remove(product);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateCategory(int id, Category newCategory)
{
try
{
WebShopEntities db = new WebShopEntities();
Category category = db.Categories.FirstOrDefault(x => x.id == id);
if (category == null)
{
return(false);
}
category.code = newCategory.code;
category.name = newCategory.name;
category.description = newCategory.description;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateImportBillDetail(int id, ImportBillDetail newImportBillDetail)
{
try
{
WebShopEntities db = new WebShopEntities();
ImportBillDetail importBillDetail = db.ImportBillDetails.FirstOrDefault(x => x.id == id);
if (importBillDetail == null)
{
return(false);
}
importBillDetail.quantity = newImportBillDetail.quantity;
importBillDetail.price = newImportBillDetail.price;
importBillDetail.totalPrice = newImportBillDetail.totalPrice;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateOrderDetail(int id, OrderDetail newOrderDetail)
{
try
{
WebShopEntities db = new WebShopEntities();
OrderDetail orderDetail = db.OrderDetails.FirstOrDefault(x => x.id == id);
if (orderDetail == null)
{
return(false);
}
orderDetail.idProduct = newOrderDetail.idProduct;
orderDetail.quantity = newOrderDetail.quantity;
orderDetail.price = newOrderDetail.price;
orderDetail.totalPrice = newOrderDetail.totalPrice;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateOrder(int id, Order newOrder)
{
try
{
WebShopEntities db = new WebShopEntities();
Order order = db.Orders.FirstOrDefault(x => x.id == id);
if (order == null)
{
return(false);
}
order.email = newOrder.email;
order.userId = newOrder.userId;
order.address = newOrder.address;
order.total = newOrder.total;
order.status = newOrder.status;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateImportBill(int id, ImportBill newImportBill)
{
try
{
WebShopEntities db = new WebShopEntities();
ImportBill importBill = db.ImportBills.FirstOrDefault(x => x.id == id);
if (importBill == null)
{
return(false);
}
importBill.agencyName = newImportBill.agencyName;
importBill.code = newImportBill.code;
importBill.address = newImportBill.address;
importBill.phone = newImportBill.phone;
importBill.total = newImportBill.total;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool InsertProduct(Product newProduct)
{
try
{
WebShopEntities db = new WebShopEntities();
Product product = new Product();
product.name = newProduct.name;
product.description = newProduct.description;
product.id = (from c in db.Products orderby c.id descending select c.id).First() + 1;
if (product.id < 10)
{
product.code = "PRO00" + product.id;
}
else if (product.id >= 10 && product.id < 100)
{
product.code = "PRO0" + product.id;
}
else
{
product.code = "PRO" + product.id;
}
product.detail = newProduct.detail;
product.idCategory = newProduct.idCategory;
product.price = newProduct.price;
product.quantity = newProduct.quantity;
product.image = newProduct.image;
product.discount = newProduct.discount;
db.Products.Add(product);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//[Route("api/category")]
public List <Category> GetCategoryList()
{
WebShopEntities db = new WebShopEntities();
return(db.Categories.ToList());
}
public List <User> GetUserList()
{
WebShopEntities db = new WebShopEntities();
return(db.Users.ToList());
}
public Product GetProduct(int id)
{
WebShopEntities db = new WebShopEntities();
return(db.Products.FirstOrDefault(x => x.id == id));
}
public List <Product> GetProductList()
{
WebShopEntities db = new WebShopEntities();
return(db.Products.ToList());
}
public List <Order> GetOrderList()
{
WebShopEntities db = new WebShopEntities();
return(db.Orders.ToList());
}
public ImportBill GetImportBill(int id)
{
WebShopEntities db = new WebShopEntities();
return(db.ImportBills.FirstOrDefault(x => x.id == id));
}
public List <ImportBill> GetImportBillList()
{
WebShopEntities db = new WebShopEntities();
return(db.ImportBills.ToList());
}
public List <OrderDetail> GetOrderDetailList()
{
WebShopEntities db = new WebShopEntities();
return(db.OrderDetails.ToList());
}
//[Route("api/category/{id}")]
public Category GetCategory(int id)
{
WebShopEntities db = new WebShopEntities();
return(db.Categories.FirstOrDefault(x => x.id == id));
}
public OrderDetail GetOrderDetail(int id)
{
WebShopEntities db = new WebShopEntities();
return(db.OrderDetails.FirstOrDefault(x => x.id == id));
}
