private List <GRNListBLL> MergeWithClient(List <GRNBLL> list) { //Get Client list. List <GRNListBLL> grnList = new List <GRNListBLL>(); List <ClientBLL> ClientList = new List <ClientBLL>(); ClientList = ClientBLL.GetAllClient(); if (ClientList == null) { throw new ClientInformationException("Can not get Clinet Information"); } else { var q = from GRN in list join client in ClientList on GRN.ClientId equals client.ClientUniqueIdentifier select new { GRN.Id, GRN.GRN_Number, GRN.CommodityId, GRN.CommodityClassId, GRN.CommodityGradeId, GRN.Status, GRN.OriginalQuantity, GRN.DateDeposited, client.ClientName }; foreach (var i in q) { GRNListBLL obj = new GRNListBLL(); obj.Id = i.Id; obj.GRN = i.GRN_Number; obj.CommodityId = i.CommodityId; obj.CommodityClassId = i.CommodityClassId; obj.CommodityGradeId = i.CommodityGradeId; obj.Status = (GRNStatus)i.Status; obj.ClinetName = i.ClientName; obj.OriginalQuantity = i.OriginalQuantity; obj.DateDeposited = Convert.ToDateTime(i.DateDeposited.ToShortDateString()); obj.CommodityGrade = CommodityGradeBLL.GetCommodityGradeNameById(i.CommodityGradeId); grnList.Add(obj); } return(grnList); } }
private static List <CommodityDepositeRequestBLL> MergeWithClient(List <CommodityDepositeRequestBLL> myList) { //Get Client list. List <CommodityDepositeRequestBLL> CDList = new List <CommodityDepositeRequestBLL>(); List <ClientBLL> ClientList = new List <ClientBLL>(); ClientList = ClientBLL.GetAllClient(); List <CommodityGradeBLL> CommGradeList = new List <CommodityGradeBLL>(); CommGradeList = getAllCommodities(); if (ClientList == null) { //throw new ClientInformationException("Can not get Clinet Information"); } else { var q = from CD in myList join client in ClientList on CD.ClientId equals client.ClientUniqueIdentifier select new { CD.Id, CD.TrackingNo, CD.VoucherNo, client.ClientName, CD.CommodityId, CD.DateTimeRecived }; 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.CommodityId = i.CommodityId; obj.DateTimeRecived = i.DateTimeRecived; CDList.Add(obj); } return(CDList); } return(null); }