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