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; }