public OrderProductVM GetOrderProductDetail(int orderNumber,int productId)
{
mergedEntities db = new mergedEntities();
OrderProductVM orderProductVM = new OrderProductVM();
var query =
from o in db.OrderDetails
where (o.orderNumber == orderNumber)
from op in o.OrderProducts
where (op.productID == productId)
select new OrderProductVM()
//select new
{
OrderNumber = o.orderNumber,
ProductId = op.productID,
ProductName = op.Product.productName,
Quantity = (decimal)op.quantity
};
foreach (var item in query)
{
orderProductVM.OrderNumber = item.OrderNumber;
orderProductVM.ProductId = item.ProductId;
orderProductVM.ProductName = item.ProductName;
orderProductVM.Quantity = item.Quantity;
}
return orderProductVM;
}
//public OrderDetail UpdateOrderDetail(string id,DateTime deliveryTime, int )
//{
// mergedEntities db = new mergedEntities();
// OrderDetail orderDetail = db.OrderDetails.Where(o => o.Id == id)
// .FirstOrDefault();
// orderDetail.orderNumber = productID;
// orderDetail.deliveryTime = deliveryTime;
// db.SaveChanges();
// return orderDetail;
//}
//Get profile details
// change public AspNetUser to public RegisteredUser
public RegisteredUser GetProfileDetail(Login login)
{
UserStore<IdentityUser> userStore = new UserStore<IdentityUser>();
UserManager<IdentityUser> manager = new UserManager<IdentityUser>(userStore);
IdentityUser identityUser = manager.Find(login.UserName, login.Password);
mergedEntities db = new mergedEntities();
RegisteredUser USER = new RegisteredUser();
var query =
from a in db.AspNetUsers
where (a.Id == identityUser.Id)
select new
{
ID = a.Id,
UserName = a.UserName,
PhoneNumber = a.PhoneNumber,
Email = a.Email,
};
foreach (var item in query)
{
USER.Id = item.ID;
USER.UserName = item.UserName;
USER.TelNumber = item.PhoneNumber;
USER.Email = item.Email;
}
return USER;
}
// for admin area
public OrderDetails GetOrderDetail(int orderNumber)
{
mergedEntities db = new mergedEntities();
OrderDetails orderDetails = new OrderDetails();
var query =
from o in db.OrderDetails
where (o.orderNumber == orderNumber)
select new OrderDetails()
//select new
{
OrderNumber = o.orderNumber,
OrderDate = (DateTime)o.orderDate,
OrderDelivery = (DateTime)o.deliveryTime,
DeliveryStatus = (bool)o.deliveryStatus
};
foreach (var item in query)
{
orderDetails.OrderNumber = item.OrderNumber;
orderDetails.OrderDate = item.OrderDate;
orderDetails.OrderDelivery = item.OrderDelivery;
orderDetails.DeliveryStatus = item.DeliveryStatus;
}
return orderDetails;
}
//Get order details
public OrderDetail GetOrderDetail()
{
mergedEntities db = new mergedEntities();
OrderDetails repo = new OrderDetails();
OrderDetail order = new OrderDetail();
var query =
from a in db.OrderDetails
where (a.orderNumber == repo.OrderNumber)
select new
{
OrderNumber = a.orderNumber,
OrderDate = a.orderDate,
Delivery = a.deliveryStatus,
};
foreach (var item in query)
{
order.orderNumber = item.OrderNumber;
order.orderDate = item.OrderDate;
order.deliveryStatus = item.Delivery;
}
return order;
}
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 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 IEnumerable<OrderProductVM> GetDetail(int orderNumber)
{
mergedEntities db = new mergedEntities();
IEnumerable<OrderProductVM> orderProductVM;
orderProductVM =
from o in db.OrderDetails
where (o.orderNumber == orderNumber)
from op in o.OrderProducts
select new OrderProductVM()
//select new
{
OrderNumber = o.orderNumber,
ProductId = op.productID,
ProductName = op.Product.productName,
Quantity = (decimal)op.quantity
};
return orderProductVM;
}
public ProductVM GetProductDetail(int id)
{
mergedEntities db = new mergedEntities();
ProductVM productVM = new ProductVM();
var query =
from p in db.Products
where (p.productID == id)
select new ProductVM()
//select new
{
ProductId = p.productID,
ProductName = p.productName,
Unit = p.unit,
ProductType = p.producType,
SupplierId = (int)p.supplierID,
Price = (decimal)p.price
};
foreach (var item in query)
{
productVM.ProductId = item.ProductId;
productVM.ProductName = item.ProductName;
productVM.Unit = item.Unit;
productVM.ProductType = item.ProductType;
productVM.SupplierId = item.SupplierId;
productVM.Price = item.Price;
}
return productVM;
}
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;
}
