public List <GradingResultBLL> Search(string trackingNo, string gradingCode) { List <GradingResultBLL> list; try { list = new List <GradingResultBLL>(); list = GradingResultDAL.GetGradingResultSearch(trackingNo, gradingCode); if (list != null) { if (list.Count > 0) { foreach (GradingResultBLL i in list) { i.CommodityGradeName = CommodityGradeBLL.GetCommodityGradeNameById(i.CommodityGradeId); } } } return(list); } catch (Exception ex) { throw new Exception("An error has occured please try again.If the error persists contact the administrator.", ex); } }
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); } }