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