public async Task <IEnumerable <VmProductCostDetails> > Search_VmCostProductInfo([FromBody] VmSearchProductCost vm)
{
List <VmProductCostDetails> VmProductCostDetailData = new List <VmProductCostDetails>();
var dataReceivedFromDatabase = await(from p in db.Product
join pc in db.ProductCostInfo on p.ProductId equals pc.ProductId
join pct in db.ProductCategory on pc.ProductCategoryId equals pct.ProductCategoryId
join b in db.Brand on pc.BrandId equals b.BrandId
join em in db.Employee on pc.EmployeeId equals em.EmployeeId
//where p.ProductName.ToLower().ToString() == vm.ProductName.ToLower().ToString() || pct.ProductCategoryName.ToLower().ToString() == vm.ProductCategoryName.ToLower().ToString() || b.BrandName.ToLower().ToString() == vm.BrandName.ToLower().ToString() || em.EmployeeName.ToLower().ToString() == vm.EmployeeName.ToLower().ToString() || em.EmployeeMobileNo.ToLower().ToString() == vm.EmployeeMobileNo.ToLower().ToString()
where em.EmployeeMobileNo.StartsWith(vm.EmployeeMobileNo) || em.EmployeeMobileNo.Contains(vm.EmployeeMobileNo) || em.EmployeeMobileNo == vm.EmployeeMobileNo
select new { b.BrandId, b.BrandName, em.EmployeeId, em.EmployeeName, em.EmployeeMobileNo, em.EmployeeAddress, p.ProductId, p.ProductName, p.ProductByteImage, p.ProductPicturePath, pct.ProductCategoryId, pct.ProductCategoryName, pc.ProductCostInfoId, pc.ProductSize, pc.UnitPrice, pc.Quantity, pc.TransportCost, pc.Discount, pc.DateOfOrder, pc.Subtotal, pc.GrandTotal, pc.CurrentPayment, pc.DueAmount }
).ToListAsync();
if (dataReceivedFromDatabase.Count() > 0)
{
foreach (var data in dataReceivedFromDatabase)
{
VmProductCostDetails vmData = new VmProductCostDetails();
vmData.BrandId = data.BrandId;
vmData.BrandName = data.BrandName;
vmData.CurrentPayment = data.CurrentPayment;
vmData.DateOfOrder = data.DateOfOrder;
vmData.Discount = data.Discount;
vmData.DueAmount = data.DueAmount;
vmData.EmployeeId = data.EmployeeId;
vmData.EmployeeName = data.EmployeeName;
vmData.EmployeeMobileNo = data.EmployeeMobileNo;
vmData.EmployeeAddress = data.EmployeeAddress;
vmData.GrandTotal = data.GrandTotal;
vmData.ProductCategoryId = data.ProductCategoryId;
vmData.ProductCategoryName = data.ProductCategoryName;
vmData.ProductCostInfoId = data.ProductCostInfoId;
vmData.ProductId = data.ProductId;
vmData.ProductName = data.ProductName;
vmData.ProductByteImage = data.ProductByteImage;
vmData.ProductPicturePath = data.ProductPicturePath;
vmData.ProductSize = data.ProductSize;
vmData.Quantity = data.Quantity;
vmData.Subtotal = data.Subtotal;
vmData.TransportCost = data.TransportCost;
vmData.UnitPrice = data.UnitPrice;
VmProductCostDetailData.Add(vmData);
}
}
return(VmProductCostDetailData);
}
public JsonResult SearchProductCostInfo([FromBody] VmSearchProductCost Vmojb)
{
return(Json(db.Search_VmCostProductInfo(Vmojb)));
}
