private static List <CommodityGradeBLL> getAllCommodities()
{
List <CommodityGradeBLL> myList = new List <CommodityGradeBLL>();
myList = CommodityGradeBLL.GetAllCommodity();
return(myList);
}
private static List <CommodityDepositeRequestBLL> MergeWithCommodity(List <CommodityDepositeRequestBLL> myList)
{
List <CommodityDepositeRequestBLL> CDList = new List <CommodityDepositeRequestBLL>();
List <CommodityGradeBLL> CList = new List <CommodityGradeBLL>();
CList = CommodityGradeBLL.GetAllCommodity();
var q = from CD in myList
join c in CList on CD.CommodityId equals c.CommodityId
select new { CD.Id, CD.TrackingNo, CD.VoucherNo, CD.ClientId, CD.ClientName, CD.CommodityId, CD.DateTimeRecived, c.Commodity };
foreach (var i in q)
{
CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL();
obj.Id = i.Id;
obj.TrackingNo = i.TrackingNo;
obj.VoucherNo = i.VoucherNo;
obj.ClientName = i.ClientName;
obj.ClientId = i.ClientId;
obj.CommodityId = i.CommodityId;
obj.DateTimeRecived = i.DateTimeRecived;
obj.CommodityName = i.Commodity;
CDList.Add(obj);
}
return(CDList);
}
