/// No CompanyID Provided
        public vmYarn GetYarnBYId(int?yarnId, int?CompanyID)
        {
            vmYarn _yarnCr = null;

            GenericFactory_EF_YarnCR = new RndYarn_EF();
            try
            {
                List <RndYarnCR> _objYarnCr = GenericFactory_EF_YarnCR.FindBy(x => x.IsDeleted == false && x.YarnID == yarnId && x.CompanyID == CompanyID).ToList();
                _yarnCr = (from olt in _objYarnCr
                           orderby olt.YarnID descending
                           select new vmYarn
                {
                    YarnName = olt.YarnCount,
                    YarnRatio = olt.YarnRatio,
                    YarnType = olt.YarnType,
                    Yarn = (int)olt.YarnID,
                    LotName = olt.YarnRatioLot
                }).FirstOrDefault();
            }
            catch (Exception e)
            {
                e.ToString();
            }
            return(_yarnCr);
        }
        public vmYarn GetYarnBYId(int?yarnId, int?CompanyID)
        {
            vmYarn _objYarnCR = null;

            try
            {
                _objYarnCR = _objFinishGood.GetYarnBYId(yarnId, CompanyID);
            }
            catch (Exception e)
            {
                e.ToString();
            }
            return(_objYarnCR);
        }