public UserObject GetUserByLogin(string login)
        {
            UserObject   user = new UserObject();
            QueryBuilder builder;

            try
            {
                builder = new QueryBuilder();
                builder.Append(this.BaseQuery(false, 0));
                builder.AppendWhereString(UserObject.LOGIN, DBFunctions.FixStringValue(login), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
                user = UserConvertor.UserRowToObject(DBFunctions.FillDataRow(builder.Query
                                                                             , true, "Generic", 30));
            }
            catch (Exception exception1)
            {
                Exception innerException = exception1;
                throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
            }
            return(user);
        }