public HttpResponseMessage EditOrder(int id, [FromBody] OrderDTO orderDTO)
{
try
{
eShop = new EShopEntities();
Order order = FindOrder(id);
if (order != null)
{
order.OrderDate = orderDTO.OrderDate;
order.ShipAddress = orderDTO.ShipAddress;
eShop.SaveChanges();
foreach (OrderDetail od in orderDTO.Details)
{
OrderDetail item = FindOrderDeatail(order.OrderID, od.ProductID);
item.Quantity = od.Quantity;
item.Discount = od.Discount;
eShop.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.Accepted, eShop.Orders));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage AddOrder([FromBody] OrderDTO orderDTO)
{
try
{
eShop = new EShopEntities();
Order order = new Order();
order.OrderID = orderDTO.OrderID;
order.CustomerID = orderDTO.CustomerID;
order.OrderDate = orderDTO.OrderDate;
order.ShipAddress = orderDTO.ShipAddress;
eShop.Orders.Add(order);
eShop.SaveChanges();
foreach (OrderDetail od in orderDTO.Details)
{
OrderDetail item = new OrderDetail();
item.OrderID = orderDTO.OrderID;
item.ProductID = od.ProductID;
item.Quantity = od.Quantity;
item.Discount = od.Discount;
eShop.OrderDetails.Add(item);
eShop.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.Created, eShop.Orders));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// POST: api/Customer
public HttpResponseMessage Post([FromBody] Customer customer)
{
try
{
Customer cus = eshopentities.Customers.Add(customer);
eshopentities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, cus));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// POST: api/Category
public HttpResponseMessage Post([FromBody] Category category)
{
try
{
Category cate = eshopentities.Categories.Add(category);
eshopentities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, cate));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// POST: api/Product
public HttpResponseMessage Post([FromBody] Product product)
{
try
{
Product pro = eshopentities.Products.Add(product);
eshopentities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, pro));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// PUT: api/Product/5
public HttpResponseMessage Put(int id, [FromBody] Product value)
{
try
{
using (EShopEntities db = new EShopEntities())
{
Product s = db.Products.SingleOrDefault(b => b.ProductID == id);
if (s != null)
{
s.ProductID = id;
s.CategoryID = value.CategoryID;
s.UnitPrice = value.UnitPrice;
s.ProductName = value.ProductName;
s.Quantity = value.Quantity;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// PUT: api/EditOrder/5
public HttpResponseMessage EditOrder(int id, [FromBody] Order order)
{
try
{
using (EShopEntities db = new EShopEntities())
{
Order s = db.Orders.SingleOrDefault(b => b.OrderID == id);
if (s != null)
{
s.OrderID = id;
s.CustomerID = order.CustomerID;
s.OrderDate = order.OrderDate;
s.ShipAddress = order.ShipAddress;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// PUT: api/Category/5
public HttpResponseMessage Put(int id, [FromBody] Category value)
{
try
{
using (EShopEntities db = new EShopEntities())
{
Category s = db.Categories.SingleOrDefault(b => b.CategoryID == id);
if (s != null)
{
s.CategoryID = id;
s.CategoryName = value.CategoryName;
s.Description = value.Description;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
//Update customer
public HttpResponseMessage EditCustomer(int id, [FromBody] Customer cus)
{
try
{
eShop = new EShopEntities();
Customer customer = FinCustomer(id);
if (customer != null)
{
customer.Fullname = cus.Fullname;
customer.Gender = cus.Gender;
customer.Birthday = cus.Birthday;
customer.Address = cus.Address;
customer.Email = cus.Email;
customer.PhoneNumber = cus.PhoneNumber;
eShop.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Accepted, eShop.Customers));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
//Remove product by id
public void RemoveProduct(int productId)
{
using (var context = new EShopEntities())
{
context.Products.Remove(context.Products.First(p => p.Id == productId));
context.SaveChanges();
}
}
public void Update(User newUser)
{
//Replacing the plain password with the encrypted
newUser.Password = hashing.EncryptPass(newUser.Password);
using (var context = new EShopEntities())
{
var user = context.Users.First(u => u.Id == newUser.Id);
//Update row
context.Entry(user).CurrentValues.SetValues(newUser);
context.SaveChanges();
}
}
public void AddProduct(Product product, byte[] image1, byte[] image2, byte[] image3)
{
product.ProductImage = new ProductImage();
product.ProductImage.Picture1 = image1;
product.ProductImage.Picture2 = image2;
product.ProductImage.Picture3 = image3;
using (var context = new EShopEntities())
{
context.Products.Add(product);
context.SaveChanges();
}
}
//Add Customer
public HttpResponseMessage AddCustomer([FromBody] Customer cus)
{
try
{
eShop = new EShopEntities();
eShop.Customers.Add(cus);
eShop.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, eShop.Customers));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// POST: api/Category
public HttpResponseMessage Post([FromBody] Category cate)
{
try
{
using (EShopEntities db = new EShopEntities())
{
db.Categories.Add(cate);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public void Save()
{
using (var trans = _context.Database.BeginTransaction())
{
try
{
_context.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message);
}
}
}
// POST: api/AddCustomer
public HttpResponseMessage AddCustomer([FromBody] Customer cus)
{
try
{
using (EShopEntities db = new EShopEntities())
{
db.Customers.Add(cus);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// DELETE: api/Category/5
public HttpResponseMessage Delete(int id)
{
try
{
using (EShopEntities db = new EShopEntities())
{
Category s = db.Categories.SingleOrDefault(x => x.CategoryID == id);
db.Categories.Remove(s);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public bool TryRegister(User user)
{
//Replacing the plain password with the encrypted
user.Password = hashing.EncryptPass(user.Password);
using (var context = new EShopEntities())
{
var isExist = context.Users.Any(u => u.Id == user.Id);
if (isExist)
{
return(false);
}
context.Users.Add(user);
context.SaveChanges();
}
return(true);
}
// DELETE: api/Category/5
public HttpResponseMessage Delete(int id)
{
try
{
eShop = new EShopEntities();
Category cate = FindCategory(id);
if (cate != null)
{
eShop.Categories.Remove(cate);
eShop.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, eShop.Categories));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage DeleteOrder(int id)
{
try
{
eShop = new EShopEntities();
Order order = FindOrder(id);
if (order != null)
{
eShop.Orders.Remove(order);
eShop.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, eShop.Orders));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// PUT: api/Category/5
public HttpResponseMessage Put(int id, [FromBody] Category category)
{
try
{
eShop = new EShopEntities();
Category cate = FindCategory(id);
if (cate != null)
{
cate.CategoryName = category.CategoryName;
cate.Description = category.Description;
eShop.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Accepted, eShop.Categories));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
