public ActionResult OrderHistoryDetails(int id) { List <OrderHistory_ViewModel> ohvmlist = new List <OrderHistory_ViewModel>(); var obj = db.OrderDetail_Table.Where(x => x.Orderid == id).ToList(); Service_Table s = new Service_Table(); User_Table uobj = new User_Table(); foreach (var item in obj) { var service = db.OrderDetail_Table.Where(x => x.Orderid == id).Select(x => x.Serviceid).FirstOrDefault(); // var servicename = db.Service_Table.Where(x => x.ServiceId == service).Select(x => x.ServiceName).FirstOrDefault(); s = db.Service_Table.Where(x => x.ServiceId == service).FirstOrDefault(); uobj = db.User_Table.Where(x => x.UserId == s.ServiceProviderid).FirstOrDefault(); var product_desc = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductDesc).FirstOrDefault(); var product = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductName).FirstOrDefault(); var deliveryadd = db.Order_Table.Where(x => x.OrderId == id).Select(x => x.OrderDeliveryAddress).FirstOrDefault(); var deliverydate = db.Order_Table.Where(x => x.OrderId == id).Select(x => x.OrderDeliveryDate).FirstOrDefault(); var image = db.Image_Table.Where(x => x.Productid == item.Productid).Select(x => x.BinaryImage).FirstOrDefault(); OrderHistory_ViewModel obj1 = new OrderHistory_ViewModel(); obj1.ProductName = product; obj1.ProductDesc = product_desc; obj1.OrderDelivryAddress = deliveryadd; obj1.Amount = (decimal)item.Amount; obj1.OrderDeliveryDate = (DateTime)deliverydate; obj1.ServiceName = uobj.UserName; obj1.BinaryImage = image; ohvmlist.Add(obj1); } return(View(ohvmlist)); }
public ActionResult OrderDetails(int OrderId, int UserId) { List <OrderHistory_ViewModel> ohvmlist = new List <OrderHistory_ViewModel>(); string userName = db.User_Table.Where(x => x.UserId == UserId).Select(x => x.UserName).FirstOrDefault(); string userPhone = db.User_Table.Where(x => x.UserId == UserId).Select(x => x.UserPhno).FirstOrDefault(); var orderList = db.OrderDetail_Table.Where(x => x.Orderid == OrderId).ToList(); List <string> list = new List <string>(); foreach (var item in orderList) { var service = db.OrderDetail_Table.Where(x => x.Orderid == OrderId).Select(x => x.Serviceid).FirstOrDefault(); var product_desc = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductDesc).FirstOrDefault(); var product = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductName).FirstOrDefault(); var deliveryadd = db.Order_Table.Where(x => x.OrderId == OrderId).Select(x => x.OrderDeliveryAddress).FirstOrDefault(); var deliverydate = db.Order_Table.Where(x => x.OrderId == OrderId).Select(x => x.OrderDeliveryDate).FirstOrDefault(); var image = db.Image_Table.Where(x => x.Productid == item.Productid).Select(x => x.BinaryImage).FirstOrDefault(); OrderHistory_ViewModel vm_obj = new OrderHistory_ViewModel(); vm_obj.ProductName = product; vm_obj.ProductDesc = product_desc; vm_obj.OrderDelivryAddress = deliveryadd; vm_obj.Amount = (decimal)item.Amount; vm_obj.OrderDeliveryDate = (DateTime)deliverydate; vm_obj.CustomerName = userName; vm_obj.BinaryImage = image; ohvmlist.Add(vm_obj); list.Add(userName); list.Add(deliveryadd); list.Add(userPhone); } ViewBag.list = list.Distinct(); return(PartialView("_orderDetails", ohvmlist)); }