예제 #1
0
        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);
            }
        }
예제 #2
0
        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);
            }
        }