Example #1
0
File: DB.cs Project: vzrus/VZF
    /// <summary>
    /// The get profiles.
    /// </summary>
    /// <param name="appName">
    /// The app name.
    /// </param>
    /// <param name="pageIndex">
    /// The page index.
    /// </param>
    /// <param name="pageSize">
    /// The page size.
    /// </param>
    /// <param name="userNameToMatch">
    /// The user name to match.
    /// </param>
    /// <param name="inactiveSinceDate">
    /// The inactive since date.
    /// </param>
    /// <returns>
    /// </returns>
    public DataSet GetProfiles(string connectionStringName, [NotNull] object appName, [NotNull] object pageIndex, [NotNull] object pageSize, [NotNull] object userNameToMatch, [NotNull] object inactiveSinceDate)
    {
      using (var sc = new VzfSqlCommand(connectionStringName))
      {
          sc.Parameters.Add(sc.CreateParameter(DbType.String, "@ApplicationName", appName));
          sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "@PageIndex", pageIndex));
          sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "@PageSize", pageSize));
          sc.Parameters.Add(sc.CreateParameter(DbType.String, "@UserNameToMatch", userNameToMatch));
          sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "@InactiveSinceDate", inactiveSinceDate));     

          sc.CommandText.AppendObjectQuery("prov_profile_getprofiles", connectionStringName);
          return sc.ExecuteDataSet(CommandType.StoredProcedure);
      }
    }