/// <summary>
/// The delete profiles.
/// </summary>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="userNames">
/// The user names.
/// </param>
/// <returns>
/// The delete profiles.
/// </returns>
public int DeleteProfiles([NotNull] object appName, [NotNull] object userNames)
{
using (SqlCommand cmd = MsSqlDbAccess.GetCommand("prov_profile_deleteprofiles"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ApplicationName", appName);
cmd.Parameters.AddWithValue("UserNames", userNames);
return(Convert.ToInt32(this._msSqlDbAccess.ExecuteScalar(cmd)));
}
}
/// <summary>
/// The get number inactive profiles.
/// </summary>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="inactiveSinceDate">
/// The inactive since date.
/// </param>
/// <returns>
/// The get number inactive profiles.
/// </returns>
public int GetNumberInactiveProfiles([NotNull] object appName, [NotNull] object inactiveSinceDate)
{
using (SqlCommand cmd = MsSqlDbAccess.GetCommand("prov_profile_getnumberinactiveprofiles"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ApplicationName", appName);
cmd.Parameters.AddWithValue("InactiveSinceDate", inactiveSinceDate);
return(Convert.ToInt32(this._msSqlDbAccess.ExecuteScalar(cmd)));
}
}
/// <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([NotNull] object appName, [NotNull] object pageIndex, [NotNull] object pageSize, [NotNull] object userNameToMatch, [NotNull] object inactiveSinceDate)
{
using (SqlCommand cmd = MsSqlDbAccess.GetCommand("prov_profile_getprofiles"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ApplicationName", appName);
cmd.Parameters.AddWithValue("PageIndex", pageIndex);
cmd.Parameters.AddWithValue("PageSize", pageSize);
cmd.Parameters.AddWithValue("UserNameToMatch", userNameToMatch);
cmd.Parameters.AddWithValue("InactiveSinceDate", inactiveSinceDate);
return(this._msSqlDbAccess.GetDataset(cmd));
}
}
public static DataTable post_list(
object topicId,
object authorUserID,
object updateViewCount,
bool showDeleted,
bool styledNicks,
DateTime sincePostedDate,
DateTime toPostedDate,
DateTime sinceEditedDate,
DateTime toEditedDate,
int pageIndex,
int pageSize,
int sortPosted,
int sortEdited,
int sortPosition,
bool showThanks,
int messagePosition)
{
using (var cmd = MsSqlDbAccess.GetCommand("sueetie_post_list"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("TopicID", topicId);
cmd.Parameters.AddWithValue("AuthorUserID", authorUserID);
cmd.Parameters.AddWithValue("UpdateViewCount", updateViewCount);
cmd.Parameters.AddWithValue("ShowDeleted", showDeleted);
cmd.Parameters.AddWithValue("StyledNicks", styledNicks);
cmd.Parameters.AddWithValue("SincePostedDate", sincePostedDate);
cmd.Parameters.AddWithValue("ToPostedDate", toPostedDate);
cmd.Parameters.AddWithValue("SinceEditedDate", sinceEditedDate);
cmd.Parameters.AddWithValue("ToEditedDate", toEditedDate);
cmd.Parameters.AddWithValue("PageIndex", pageIndex);
cmd.Parameters.AddWithValue("PageSize", pageSize);
cmd.Parameters.AddWithValue("SortPosted", sortPosted);
cmd.Parameters.AddWithValue("SortEdited", sortEdited);
cmd.Parameters.AddWithValue("SortPosition", sortPosition);
cmd.Parameters.AddWithValue("ShowThanks", showThanks);
cmd.Parameters.AddWithValue("MessagePosition", messagePosition);
return(MsSqlDbAccess.Current.GetData(cmd));
}
}
