// 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));
}
}
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));
}
}
//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));
}
}
// 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));
}
}
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));
}
}
// 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));
}
}
//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 Product Find(string id)
{
int intId = int.Parse(id);
var product = new Product();
using (var context = new EShopEntities())
{
product = context.Products.Where(p => p.Id == intId).First();
}
return(product);
}
//Find customer
private Customer FinCustomer(int id)
{
try
{
eShop = new EShopEntities();
return(eShop.Customers.Find(id));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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 List <Customer> GetCustomerByAddress(string address)
{
using (EShopEntities db = new EShopEntities())
{
List <Customer> listcus = new List <Customer>();
listcus = db.Customers.Where(s => s.Address.Contains(address)).ToList();
return(listcus);
}
}
// GET: api/Category
public HttpResponseMessage Get()
{
try
{
eShop = new EShopEntities();
return(Request.CreateResponse(HttpStatusCode.OK, eShop.Categories));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
/// <summary>
/// Return all images of specific product
/// </summary>
/// <param name="productId"></param>
/// <returns></returns>
public ProductImage GetImages(int productId)
{
var images = new ProductImage();
using (var context = new EShopEntities())
{
images = (from p in context.Products
where p.Id == productId
select p.ProductImage).First();
}
return(images);
}
private OrderDetail FindOrderDeatail(int orderID, int productID)
{
try
{
eShop = new EShopEntities();
return(eShop.OrderDetails.SingleOrDefault(dt => dt.OrderID == orderID && dt.ProductID == productID));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private List <OrderDetail> getDetails(int idOrder)
{
try
{
eShop = new EShopEntities();
return(eShop.OrderDetails.Where(dt => dt.OrderID == idOrder).ToList());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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();
}
}
public User Find(string id)
{
User user;
using (var context = new EShopEntities())
{
//Searching for user with same id
user = context.Users.FirstOrDefault(u => u.Id == id);
}
//Do not return password
user.Password = string.Empty;
return(user);
}
private Order FindOrder(int id)
{
try
{
eShop = new EShopEntities();
Order order = eShop.Orders.Find(id);
return(order);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//Search
public HttpResponseMessage GetCustomerByAddress(string address)
{
try
{
eshopentities = new EShopEntities();
IQueryable <Customer> result = eshopentities.Customers.Where(cus => cus.Address.ToLower().IndexOf(address.ToLower()) >= 0);
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
private Category FindCategory(int categoryID)
{
try
{
eShop = new EShopEntities();
Category cate = eShop.Categories.Find(categoryID);
return(cate);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// POST: api/Category
public HttpResponseMessage Post([FromBody] Category category)
{
try
{
eShop = new EShopEntities();
eShop.Categories.Add(category);
eShop.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, eShop.Categories));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
//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));
}
}
// GET: api/GetOrderByID/5
public HttpResponseMessage GetOrderByID(int id)
{
using (EShopEntities db = new EShopEntities())
{
Order o = db.Orders.SingleOrDefault(x => x.OrderID == id);
if (o != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, o));
}
else
{
return(null);
}
}
}
// GET: api/GetCustomerByID/5
public HttpResponseMessage GetCustomerByID(int id)
{
using (EShopEntities db = new EShopEntities())
{
Customer c = db.Customers.SingleOrDefault(x => x.CustomerID == id);
if (c != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, c));
}
else
{
return(null);
}
}
}
// GET: api/Category/5
public CategoryDTO Get(int id)
{
using (EShopEntities db = new EShopEntities())
{
Category c = db.Categories.SingleOrDefault(x => x.CategoryID == id);
if (c != null)
{
return(new CategoryDTO(c.CategoryID, c.CategoryName, c.Description));
}
else
{
return(null);
}
}
}
// GET: api/Category
public HttpResponseMessage Get()
{
using (EShopEntities db = new EShopEntities())
{
var result = db.Categories.ToList();
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result.ToList()));
}
else
{
return(null);
}
}
}
// GET: api/Product/5
public ProductDTO Get(int id)
{
using (EShopEntities db = new EShopEntities())
{
Product c = db.Products.SingleOrDefault(x => x.ProductID == id);
if (c != null)
{
return(new ProductDTO(c.ProductID, c.CategoryID, c.ProductName, c.UnitPrice, c.Quantity));
}
else
{
return(null);
}
}
}
// 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));
}
}
// 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));
}
}
public static bool Login(string user, string pass)
{
using (EShopEntities db = new EShopEntities())
{
var account = db.Accounts.SingleOrDefault(u => u.Username == user &&
u.Password == pass);
if (account != null)
{
return(true);
}
else
{
return(false);
}
}
}
