private static PositionR GetPositionRFromReader(IDataReader dataReader)
        {
            PositionR objItem = new PositionR();

            objItem.PositionID  = SqlHelper.GetInt(dataReader, "PositionID");
            objItem.PostionName = SqlHelper.GetString(dataReader, "PostionName");
            objItem.MinSalary   = SqlHelper.GetDecimal(dataReader, "MinSalary");
            objItem.MaxSalary   = SqlHelper.GetDecimal(dataReader, "MaxSalary");
            return(objItem);
        }
        public static PositionRCollection GetPostionRangesalary(int EntityID)
        {
            PositionRCollection collection = new PositionRCollection();
            var sqlParams = new SqlParameter[1];

            sqlParams[0] = new SqlParameter("@EntityID", EntityID);
            using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Position_Range", sqlParams))
            {
                while (reader.Read())
                {
                    PositionR obj = new PositionR();
                    obj = GetPositionRFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }