public List <tblBuy> GetPaddyInfo() { var data = context.sp_GetPaddyBuyInfo(); List <tblBuy> buys = new List <tblBuy>(); foreach (var item in data) { tblBuy buyobj = new tblBuy(); buyobj.ID = item.ID; buyobj.date = item.date; buyobj.partyId = item.partyId; buyobj.partyName = item.partyName; buyobj.productId = item.productId; buyobj.productName = item.productName; buyobj.noOfBag = item.noOfBag; buyobj.stockId = item.stockId; buyobj.stockName = item.stockName; buyobj.unit = item.unit; buyobj.price = item.price; buyobj.transportCost = item.transportCost; buyobj.truckNumber = item.truckNumber; buyobj.labourCostPerBag = item.labourCostPerBag; buyobj.quantityPerBag = item.quantityPerBag; buyobj.amount = item.amount ?? 0; //buyobj.comRcvBag = Convert.ToInt32(item.comRcvBag); //buyobj.noOfSackRcvd = Convert.ToInt32(item.noOfSackRcvd); buyobj.bagPrice = item.rcvPrice; buys.Add(buyobj); } return(buys); }