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