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