public OrderProductVM UpdateOrderProduct(OrderProductVM orderProductVM)
{
mergedEntities db = new mergedEntities();
OrderProduct orderProduct = db.OrderProducts.Where(o => o.orderNumber == orderProductVM.OrderNumber &&
o.productID == orderProductVM.ProductId).FirstOrDefault();
orderProduct.productID = orderProductVM.ProductId;
orderProduct.quantity = orderProductVM.Quantity;
db.SaveChanges();
return orderProductVM;
}
public OrderDetails UpdateOrder(OrderDetails orderDetails)
{
mergedEntities db = new mergedEntities();
OrderDetail orderDetail = db.OrderDetails.Where(o => o.orderNumber == orderDetails.OrderNumber).FirstOrDefault();
orderDetail.orderNumber = orderDetails.OrderNumber;
orderDetail.orderDate = orderDetails.OrderDate;
orderDetail.deliveryTime = orderDetails.OrderDelivery;
orderDetail.deliveryStatus = orderDetails.DeliveryStatus;
db.SaveChanges();
return orderDetails;
}
public AspNetUser UpdateUser(string phone, string userName)
{
mergedEntities db = new mergedEntities();
AspNetUser aspNetUser = db.AspNetUsers.Where(a => a.UserName == userName)
.FirstOrDefault();
aspNetUser.PhoneNumber = phone;
aspNetUser.UserName = userName;
db.SaveChanges();
return aspNetUser;
}
public void DeleteOrderProduct(int orderNumber, int productId)
{
mergedEntities db = new mergedEntities();
var selected = db.OrderProducts.Single(o => o.orderNumber == orderNumber &&
o.productID == productId);
db.OrderProducts.Remove(selected);
db.SaveChanges();
}
public ProductVM UpdateProduct(ProductVM productVM)
{
mergedEntities db = new mergedEntities();
Product product = db.Products.Where(p => p.productID == productVM.ProductId &&
p.supplierID == productVM.SupplierId).FirstOrDefault();
product.productID = productVM.ProductId;
product.productName = productVM.ProductName;
product.productName = productVM.ProductType;
product.supplierID = productVM.SupplierId;
product.price = productVM.Price;
product.unit = productVM.Unit;
db.SaveChanges();
return productVM;
}