/// <summary>
/// Gets stats row on album.
/// </summary>
/// <param name="mid">
/// The module ID.
/// </param>
/// <param name="userId">
/// The user ID.
/// </param>
/// <param name="albumId">
/// The album Id.
/// </param>
/// <returns>
/// Returns a <see cref="T:System.Int32"/> array with stats row.
/// </returns>
public static int[] album_getstats(
int? mid,
object userId,
object albumId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(
sc.CreateParameter(
DbType.Int32,
"i_UserID",
(userId == null || userId.ToString() == "0") ? null : userId));
sc.Parameters.Add(
sc.CreateParameter(
DbType.Int32,
"i_AlbumID",
(albumId == null || albumId.ToString() == "0") ? null : albumId));
sc.CommandText.AppendObjectQuery("album_getstats", mid);
var strow =
sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true).Rows[0];
return new[] { Convert.ToInt32(strow["AlbumNumber"]), Convert.ToInt32(strow["ImageNumber"]) };
}
}
/// <summary>
/// The get user name by email.
/// </summary>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="email">
/// The email.
/// </param>
/// <returns>
/// </returns>
public DataTable GetUserNameByEmail(string connectionStringName, [NotNull] string appName, [NotNull] string email)
{
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@ApplicationName", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@Email", email));
sc.CommandText.AppendObjectQuery("prov_getusernamebyemail", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
public static DataTable __GetProfiles(string connectionStringName, object appName, object pageIndex, object pageSize, object userNameToMatch, object inactiveSinceDate)
{
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "i_ApplicationName", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageIndex", pageIndex));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageSize", pageSize));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "i_UserNameToMatch", userNameToMatch));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_InactiveSinceDate", inactiveSinceDate));
sc.Parameters.Add(sc.CreateParameter(DbType.Guid, "i_newguid", Guid.NewGuid()));
sc.CommandText.AppendObjectQuery("prov_profile_getprofiles", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// The get user password info.
/// </summary>
/// <param name="connectionString">
/// The connection string.
/// </param>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="username">
/// The username.
/// </param>
/// <param name="updateUser">
/// The update user.
/// </param>
/// <returns>
/// The <see cref="DataTable"/>.
/// </returns>
public DataTable GetUserPasswordInfo(string connectionStringName, string appName, string username, bool updateUser)
{
// connectionStringName = SqlDbAccess.GetConnectionStringNameFromConnectionString(connectionStringName);
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_APPLICATIONNAME", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_USERNAME", username));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_USERKEY", DBNull.Value));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "I_USERISONLINE", updateUser));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "I_UTCTIMESTAMP", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("P_getuser", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// The get all users.
/// </summary>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="pageIndex">
/// The page index.
/// </param>
/// <param name="pageSize">
/// The page size.
/// </param>
/// <returns>
/// </returns>
public DataTable GetAllUsers(string connectionStringName, [NotNull] string appName, int pageIndex, int pageSize)
{
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.CommandText.AppendObjectQuery("prov_getallusers", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// The create user.
/// </summary>
/// <param name="connectionString">
/// The connection string.
/// </param>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="username">
/// The username.
/// </param>
/// <param name="password">
/// The password.
/// </param>
/// <param name="passwordSalt">
/// The password salt.
/// </param>
/// <param name="passwordFormat">
/// The password format.
/// </param>
/// <param name="email">
/// The email.
/// </param>
/// <param name="passwordQuestion">
/// The password question.
/// </param>
/// <param name="passwordAnswer">
/// The password answer.
/// </param>
/// <param name="isApproved">
/// The is approved.
/// </param>
/// <param name="providerUserKey">
/// The provider user key.
/// </param>
public void CreateUser(string connectionStringName, string appName, string username, string password, string passwordSalt, int passwordFormat, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey)
{
// connectionStringName = SqlDbAccess.GetConnectionStringNameFromConnectionString(connectionStringName);
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_APPLICATIONNAME", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_USERNAME", username));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_PASSWORD", password));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_PASSWORDSALT", passwordSalt));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_PASSWORDFORMAT", passwordFormat.ToString()));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_EMAIL", email));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_PASSWORDQUESTION", passwordQuestion));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_PASSWORDANSWER", passwordAnswer));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "I_ISAPPROVED", isApproved));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_USERKEY", providerUserKey));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "I_UTCTIMESTAMP", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("P_CREATEUSER", connectionStringName);
providerUserKey = sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false).Rows[0][0];
}
}
/// <summary>
/// The get all users.
/// </summary>
/// <param name="connectionString">
/// The connection string.
/// </param>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="pageIndex">
/// The page index.
/// </param>
/// <param name="pageSize">
/// The page size.
/// </param>
/// <returns>
/// The <see cref="DataTable"/>.
/// </returns>
public DataTable GetAllUsers(string connectionStringName, string appName, int pageIndex, int pageSize)
{
// connectionStringName = SqlDbAccess.GetConnectionStringNameFromConnectionString(connectionStringName);
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_APPLICATIONNAME", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_pageindex", pageIndex));
// TODO:fix overflow bug
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_pagesize", pageSize == int.MaxValue ? 1 : pageSize));
sc.CommandText.AppendObjectQuery("P_getallusers", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// The post_list.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="topicId">
/// The topic id.
/// </param>
/// <param name="currentUserId">
/// The current user id.
/// </param>
/// <param name="authoruserId">
/// The authoruser id.
/// </param>
/// <param name="updateViewCount">
/// The update view count.
/// </param>
/// <param name="showDeleted">
/// The show deleted.
/// </param>
/// <param name="styledNicks">
/// The styled nicks.
/// </param>
/// <param name="showReputation">
/// The show reputation.
/// </param>
/// <param name="sincePostedDate">
/// The since posted date.
/// </param>
/// <param name="toPostedDate">
/// The to posted date.
/// </param>
/// <param name="sinceEditedDate">
/// The since edited date.
/// </param>
/// <param name="toEditedDate">
/// The to edited date.
/// </param>
/// <param name="pageIndex">
/// The page index.
/// </param>
/// <param name="pageSize">
/// The page size.
/// </param>
/// <param name="sortPosted">
/// The sort posted.
/// </param>
/// <param name="sortEdited">
/// The sort edited.
/// </param>
/// <param name="sortPosition">
/// The sort position.
/// </param>
/// <param name="showThanks">
/// The show thanks.
/// </param>
/// <param name="messagePosition">
/// The message position.
/// </param>
/// <param name="messageId">
/// The message id.
/// </param>
/// <param name="lastRead">
/// The last read.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable post_list(
int? mid,
object topicId,
object currentUserId,
object authoruserId,
object updateViewCount,
bool showDeleted,
bool styledNicks,
bool showReputation,
DateTime sincePostedDate,
DateTime toPostedDate,
DateTime sinceEditedDate,
DateTime toEditedDate,
int pageIndex,
int pageSize,
int sortPosted,
int sortEdited,
int sortPosition,
bool showThanks,
int messagePosition,
int messageId,
DateTime lastRead)
{
using (var sc = new VzfSqlCommand(mid))
{
if (updateViewCount == null)
{
updateViewCount = 1;
}
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_TopicID", topicId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageUserID", currentUserId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_AuthorUserID", authoruserId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int16, "i_UpdateViewCount", updateViewCount));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_ShowDeleted", showDeleted));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_StyledNicks", styledNicks));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_ShowReputation", showReputation));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_SincePostedDate", sincePostedDate));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_ToPostedDate", toPostedDate));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_SinceEditedDate", sinceEditedDate));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_ToEditedDate", toEditedDate));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageIndex", pageIndex));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageSize", pageSize));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_SortPosted", sortPosted));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_SortEdited", sortEdited));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_SortPosition", sortPosition));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_ShowThanks", showThanks));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_MessagePosition", messagePosition));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_MessageID", messageId));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_LastRead", lastRead));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_UTCTIMESTAMP", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("post_list", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The post_list_reverse 10.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="topicId">
/// The topic id.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable post_list_reverse10(int? mid, object topicId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_TopicID", topicId));
// sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_UTCTIMESTAMP", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("post_list", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The pollvote_check.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="pollid">
/// The pollid.
/// </param>
/// <param name="userid">
/// The userid.
/// </param>
/// <param name="remoteip">
/// The remoteip.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable pollvote_check(int? mid, object pollid, object userid, object remoteip)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PolID", pollid));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_UserID", userid));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "i_RemoteIP", remoteip));
sc.CommandText.AppendObjectQuery("pollvote_check", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The post_alluser.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="boardid">
/// The boardid.
/// </param>
/// <param name="userid">
/// The userid.
/// </param>
/// <param name="pageUserId">
/// The page user id.
/// </param>
/// <param name="topCount">
/// The top count.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable post_alluser(
int? mid,
object boardid,
object userid,
object pageUserId,
object topCount)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_BoardID", boardid));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_UserID", userid));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageUserID", pageUserId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_NumberOfMessages", topCount));
sc.CommandText.AppendObjectQuery("post_alluser", mid);
DataTable dt1 = sc.ExecuteDataTableFromReader(
CommandBehavior.Default,
CommandType.StoredProcedure,
true);
foreach (DataRow dr in dt1.Rows)
{
if (dr["ReadAccess"].ToString() == "0")
{
dr.Delete();
}
}
dt1.AcceptChanges();
return dt1;
}
}
/// <summary>
/// The poll group list.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="userId">
/// The user id.
/// </param>
/// <param name="forumId">
/// The forum id.
/// </param>
/// <param name="boardId">
/// The board id.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{T}"/>.
/// </returns>
public static IEnumerable<TypedPollGroup> PollGroupList(int? mid, int userId, int? forumId, int boardId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_UserID", userId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_ForumID", forumId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_BoardID", boardId));
sc.CommandText.AppendObjectQuery("pollgroup_list", mid);
return
sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true)
.AsEnumerable()
.Select(r => new TypedPollGroup(r));
}
}
/// <summary>
/// The pollgroup_stats.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="pollGroupId">
/// The poll group id.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable pollgroup_stats(int? mid, int? pollGroupId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PollGroupID", pollGroupId));
sc.CommandText.AppendObjectQuery("pollgroup_stats", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The poll_stats.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="pollId">
/// The poll id.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable poll_stats(int? mid, int? pollId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PollID", pollId));
sc.CommandText.AppendObjectQuery("poll_stats", mid);
var dt = sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
var dtRet = new DataTable();
foreach (DataColumn dc in dt.Columns)
{
DataColumn dcRet;
dcRet = dc.DataType == typeof(decimal)
? new DataColumn(dc.ColumnName, typeof(int))
: new DataColumn(dc.ColumnName, dc.DataType);
dtRet.Columns.Add(dcRet);
}
dtRet.AcceptChanges();
foreach (DataRow dr in dt.Rows)
{
DataRow drRet = dtRet.NewRow();
foreach (DataColumn dc in dt.Columns)
{
drRet[dc.ColumnName] = dr[dc];
}
dtRet.Rows.Add(drRet);
}
dtRet.AcceptChanges();
return dtRet;
}
}
/// <summary>
/// The shoutbox_getmessages.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="boardId">
/// The board id.
/// </param>
/// <param name="numberOfMessages">
/// The number of messages.
/// </param>
/// <param name="useStyledNicks">
/// The use styled nicks.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable shoutbox_getmessages(int? mid, int boardId, int numberOfMessages, object useStyledNicks)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_BoardId", boardId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_NumberOfMessages", numberOfMessages));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_StyledNicks", useStyledNicks));
sc.CommandText.AppendObjectQuery("shoutbox_getmessages", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The rank_list.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="boardId">
/// The board id.
/// </param>
/// <param name="rankId">
/// The rank id.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static IEnumerable<rank_list_Result> rank_list(int? mid, object boardId, object rankId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_BoardID", boardId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_RankID", rankId));
sc.CommandText.AppendObjectQuery("rank_list", mid);
return
sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true)
.AsEnumerable()
.Select(r => new rank_list_Result(r));
}
}
public DataTable GetProfiles(string connectionStringName, object appName, object pageIndex, object pageSize, object userNameToMatch, object inactiveSinceDate)
{
int TotalCountNew = 0;
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "i_ApplicationName", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageIndex", pageIndex));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageSize", pageSize));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "i_UserNameToMatch", userNameToMatch));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_InactiveSinceDate", inactiveSinceDate));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_TotalCount", TotalCountNew, ParameterDirection.Output));
sc.CommandText.AppendObjectQuery("prov_profile_getprofiles", connectionStringName);
var dt = sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
TotalCountNew = (int)sc.Parameters["i_TotalCount"].Value;
if (dt.Rows.Count > 0) dt.Rows[0]["TotalCount"] = TotalCountNew;
return dt;
}
}
/// <summary>
/// The recent_users.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="boardId">
/// The board id.
/// </param>
/// <param name="timeSinceLastLogin">
/// The time since last login.
/// </param>
/// <param name="styledNicks">
/// The styled nicks.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable recent_users(int? mid, object boardId, int timeSinceLastLogin, object styledNicks)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_BoardID", boardId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_TimeSinceLastLogin", timeSinceLastLogin));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_StyledNicks", styledNicks));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "i_utctimestamp", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("recent_users", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The find users by email.
/// </summary>
/// <param name="connectionString">
/// The connection string.
/// </param>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="emailToMatch">
/// The email to match.
/// </param>
/// <param name="pageIndex">
/// The page index.
/// </param>
/// <param name="pageSize">
/// The page size.
/// </param>
/// <returns>
/// The <see cref="DataTable"/>.
/// </returns>
public DataTable FindUsersByEmail(string connectionStringName, string appName, string emailToMatch, int pageIndex, int pageSize)
{
// connectionStringName = SqlDbAccess.GetConnectionStringNameFromConnectionString(connectionStringName);
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_APPLICATIONNAME", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "i_emailaddress", emailToMatch));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_pageindex", pageIndex));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_pagesize", pageSize));
sc.CommandText.AppendObjectQuery("P_FINDUSERSBYEMAIL", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// The replace_words_list.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="boardId">
/// The board id.
/// </param>
/// <param name="id">
/// The id.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable replace_words_list(int? mid, object boardId, object id)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_BoardID", boardId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_ID", id));
sc.CommandText.AppendObjectQuery("replace_words_list", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The get user.
/// </summary>
/// <param name="connectionString">
/// The connection string.
/// </param>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="providerUserKey">
/// The provider user key.
/// </param>
/// <param name="userName">
/// The user name.
/// </param>
/// <param name="userIsOnline">
/// The user is online.
/// </param>
/// <returns>
/// The <see cref="DataRow"/>.
/// </returns>
public DataRow GetUser(string connectionStringName, string appName, object providerUserKey, string userName, bool userIsOnline)
{
// connectionStringName = SqlDbAccess.GetConnectionStringNameFromConnectionString(connectionStringName);
using (var sc = new VzfSqlCommand(connectionStringName))
{
// sc.DataSource.ProviderName
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_APPLICATIONNAME", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_USERNAME", userName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_USERKEY", providerUserKey));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "I_USERISONLINE", Convert.ToInt32(userIsOnline)));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "I_UTCTIMESTAMP", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("P_GETUSER", connectionStringName);
using (var dt = sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true))
{
var dr = dt.Rows[0];
return dr["UserID"] != DBNull.Value ? dt.Rows[0] : null;
}
}
}
/// <summary>
/// The rss_topic_latest.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="boardId">
/// The board id.
/// </param>
/// <param name="numOfPostsToRetrieve">
/// The num of posts to retrieve.
/// </param>
/// <param name="pageUserId">
/// The page user id.
/// </param>
/// <param name="useStyledNicks">
/// The use styled nicks.
/// </param>
/// <param name="showNoCountPosts">
/// The show no count posts.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable rss_topic_latest(
int? mid,
object boardId,
object numOfPostsToRetrieve,
object pageUserId,
bool useStyledNicks,
bool showNoCountPosts)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_BoardID", boardId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_NumPosts", numOfPostsToRetrieve));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_PageUserID", pageUserId));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_StyledNicks", useStyledNicks));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "i_ShowNoCountPosts", showNoCountPosts));
sc.CommandText.AppendObjectQuery("rss_topic_latest", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The get user name by email.
/// </summary>
/// <param name="connectionString">
/// The connection string.
/// </param>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="email">
/// The email.
/// </param>
/// <returns>
/// The <see cref="DataTable"/>.
/// </returns>
public DataTable GetUserNameByEmail(string connectionStringName, string appName, string email)
{
// connectionStringName = SqlDbAccess.GetConnectionStringNameFromConnectionString(connectionStringName);
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_APPLICATIONNAME", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "I_EMAIL", email));
sc.CommandText.AppendObjectQuery("P_GETUSERNAMEBYEMAL", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// The rsstopic_list.
/// </summary>
/// <param name="mid">
/// The mid.
/// </param>
/// <param name="forumId">
/// The forum id.
/// </param>
/// <param name="topicStart">
/// The topic start.
/// </param>
/// <param name="topicCount">
/// The topic count.
/// </param>
/// <returns>
/// The <see cref="T:System.Data.DataTable"/>.
/// </returns>
public static DataTable rsstopic_list(int? mid, int forumId, int topicStart, int topicCount)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_ForumID", forumId));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_Start", topicStart));
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_Limit", topicCount));
sc.CommandText.AppendObjectQuery("rsstopic_list", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The get user.
/// </summary>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="providerUserKey">
/// The provider user key.
/// </param>
/// <param name="userName">
/// The user name.
/// </param>
/// <param name="userIsOnline">
/// The user is online.
/// </param>
/// <returns>
/// </returns>
public DataRow GetUser(string connectionStringName, [NotNull] string appName, [NotNull] object providerUserKey, [NotNull] string userName, bool userIsOnline)
{
using (var sc = new VzfSqlCommand(connectionStringName))
{
var providerUserKeyNew = providerUserKey != null ? providerUserKey.ToString() : null;
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@ApplicationName", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@UserName", userName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@UserKey", providerUserKeyNew));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "@UserIsOnline", userIsOnline));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "@UTCTIMESTAMP", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("prov_getuser", connectionStringName);
using (var dt = sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true))
{
return dt.Rows.Count > 0 ? dt.Rows[0] : null;
}
}
}
/// <summary>
/// All album images for a user.
/// </summary>
/// <param name="mid">
/// The module ID.
/// </param>
/// <param name="userId">
/// The user ID.
/// </param>
/// <returns>
/// Returns a <see cref="T:System.Data.DataTable"/> with album images for a user.
/// </returns>
public static DataTable album_images_by_user(int? mid, [NotNull] object userId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_UserID", (int)userId));
sc.CommandText.AppendObjectQuery("album_images_by_user", mid);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
}
}
/// <summary>
/// The get user password info.
/// </summary>
/// <param name="appName">
/// The app name.
/// </param>
/// <param name="username">
/// The username.
/// </param>
/// <param name="updateUser">
/// The update user.
/// </param>
/// <returns>
/// </returns>
public DataTable GetUserPasswordInfo(string connectionStringName, [NotNull] string appName, [NotNull] string userName, bool updateUser)
{
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@ApplicationName", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@UserName", userName));
sc.Parameters.Add(sc.CreateParameter(DbType.Boolean, "@UserIsOnline", updateUser));
sc.Parameters.Add(sc.CreateParameter(DbType.DateTime, "@UTCTIMESTAMP", DateTime.UtcNow));
sc.CommandText.AppendObjectQuery("prov_getuser", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// Image list in an album.
/// </summary>
/// <param name="mid">
/// The module ID.
/// </param>
/// <param name="albumId">
/// The album Id.
/// </param>
/// <param name="imageId">
/// The image ID.
/// </param>
/// <returns>
/// Returns a <see cref="T:System.Data.DataTable"/> with album images for an album.
/// </returns>
public static DataTable album_image_list(
int? mid,
object albumId,
object imageId)
{
using (var sc = new VzfSqlCommand(mid))
{
sc.Parameters.Add(sc.CreateParameter(DbType.Int32, "i_AlbumID", albumId));
sc.Parameters.Add(
sc.CreateParameter(
DbType.Int32,
"i_ImageID",
(imageId == null || imageId.ToString() == "0") ? null : imageId));
sc.CommandText.AppendObjectQuery("album_image_list", mid);
DataTable dt = sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, true);
if (dt.Rows.Count <= 0)
{
return dt;
}
if (dt.Rows[0]["ImageID"] != DBNull.Value)
{
return dt;
}
dt.Rows.RemoveAt(0);
dt.AcceptChanges();
return dt;
}
}
/// <summary>
/// Database Action - Add User to Role
/// </summary>
/// <param name="appName">
/// Application Name
/// </param>
/// <param name="userName">
/// User Name
/// </param>
/// <param name="roleName">
/// Role Name
/// </param>
/// <returns>
/// DataTable with user information
/// </returns>
public DataTable IsUserInRole(string connectionStringName, object appName, object userName, object roleName)
{
using (var sc = new VzfSqlCommand(connectionStringName))
{
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@ApplicationName", appName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@UserName", userName));
sc.Parameters.Add(sc.CreateParameter(DbType.String, "@RoleName", roleName));
sc.CommandText.AppendObjectQuery("prov_role_isuserinrole", connectionStringName);
return sc.ExecuteDataTableFromReader(CommandBehavior.Default, CommandType.StoredProcedure, false);
}
}
/// <summary>
/// The poll_save.
/// </summary>
/// <param name="pollList">
/// The poll list.
/// </param>
/// <returns>
/// The <see cref="int?"/>.
/// </returns>
public static int? poll_save(PollGroup pollList)
{
int? pollGroup = null;
// Check if the group already exists or create it.
using (var cmdPg = new VzfSqlCommand(pollList.mid))
{
cmdPg.Parameters.Add(cmdPg.CreateParameter(DbType.Int32, "i_topicid", pollList.TopicId));
cmdPg.Parameters.Add(cmdPg.CreateParameter(DbType.Int32, "i_forumid", pollList.ForumId));
cmdPg.Parameters.Add(cmdPg.CreateParameter(DbType.Int32, "i_categoryid", pollList.CategoryId));
cmdPg.Parameters.Add(cmdPg.CreateParameter(DbType.Int32, "i_userid", pollList.UserId));
cmdPg.Parameters.Add(cmdPg.CreateParameter(DbType.Int32, "i_flags", pollList.Flags.BitValue));
cmdPg.Parameters.Add(cmdPg.CreateParameter(DbType.DateTime, "i_utctimestamp", DateTime.UtcNow));
cmdPg.CommandText.AppendObjectQuery("pollgroup_save", pollList.mid);
var dataTable = cmdPg.ExecuteDataTableFromReader(
CommandBehavior.Default,
CommandType.StoredProcedure,
true);
if (dataTable.Rows[0]["PollGroupID"] != DBNull.Value)
{
pollGroup = Convert.ToInt32(dataTable.Rows[0]["PollGroupID"]);
}
else if (dataTable.Rows[0]["NewPollGroupID"] != DBNull.Value)
{
pollGroup = Convert.ToInt32(dataTable.Rows[0]["NewPollGroupID"]);
}
}
pollList.Polls.ForEach(
poll =>
{
int? currPoll;
using (var cmd = new VzfSqlCommand(pollList.mid))
{
cmd.Parameters.Add(cmd.CreateParameter(DbType.String, "i_question", poll.Question));
if (poll.Closes > DateTimeHelper.SqlDbMinTime())
{
cmd.Parameters.Add(cmd.CreateParameter(DbType.DateTime, "i_closes", poll.Closes));
}
else
{
cmd.Parameters.Add(cmd.CreateParameter(DbType.DateTime, "i_closes", null));
}
cmd.Parameters.Add(cmd.CreateParameter(DbType.Int32, "i_UserID", poll.UserId));
cmd.Parameters.Add(cmd.CreateParameter(DbType.Int32, "i_PollGroupID", pollGroup));
cmd.Parameters.Add(cmd.CreateParameter(DbType.String, "i_ObjectPath", poll.ObjectPath));
cmd.Parameters.Add(cmd.CreateParameter(DbType.String, "i_MimeType", poll.MimeType));
cmd.Parameters.Add(cmd.CreateParameter(DbType.Int32, "i_Flags", poll.Flags.BitValue));
cmd.Parameters.Add(cmd.CreateParameter(DbType.DateTime, "i_UTCTIMESTAMP", DateTime.UtcNow));
cmd.CommandText.AppendObjectQuery("poll_save", pollList.mid);
currPoll = cmd.ExecuteScalar(CommandType.StoredProcedure, true).ToType<int>();
}
// The cycle through poll reply choices
poll.Choices.ForEach(
choice =>
{
if (choice.Choice.Length <= 0)
{
return;
}
using (var cmdChoice = new VzfSqlCommand(pollList.mid))
{
cmdChoice.Parameters.Add(
cmdChoice.CreateParameter(DbType.Int32, "i_pollid", currPoll));
cmdChoice.Parameters.Add(
cmdChoice.CreateParameter(DbType.String, "i_choice", choice.Choice));
cmdChoice.Parameters.Add(cmdChoice.CreateParameter(DbType.Int32, "i_votes", 0));
cmdChoice.Parameters.Add(
cmdChoice.CreateParameter(
DbType.String,
"i_objectpath",
choice.ObjectPath.IsNotSet() ? string.Empty : choice.ObjectPath));
cmdChoice.Parameters.Add(
cmdChoice.CreateParameter(
DbType.String,
"i_mimetype",
choice.MimeType.IsNotSet() ? string.Empty : choice.MimeType));
cmdChoice.Parameters.Add(
cmdChoice.CreateParameter(
DbType.DateTime,
"i_utctimestamp",
DateTime.UtcNow));
cmdChoice.CommandText.AppendObjectQuery("choice_save", pollList.mid);
cmdChoice.ExecuteNonQuery(CommandType.StoredProcedure, true);
}
});
});
// add links to objects
using (var cmd2 = new VzfSqlCommand(pollList.mid))
{
cmd2.Parameters.Add(cmd2.CreateParameter(DbType.Int32, "i_topicid", pollList.TopicId));
cmd2.Parameters.Add(cmd2.CreateParameter(DbType.Int32, "i_forumid", pollList.ForumId));
cmd2.Parameters.Add(cmd2.CreateParameter(DbType.Int32, "i_categoryid", pollList.CategoryId));
cmd2.Parameters.Add(cmd2.CreateParameter(DbType.Int32, "i_pollgroupid", pollGroup));
cmd2.Parameters.Add(cmd2.CreateParameter(DbType.DateTime, "i_UTCTIMESTAMP", DateTime.UtcNow));
cmd2.CommandText.AppendObjectQuery("pollgroup_setlinks", pollList.mid);
cmd2.ExecuteNonQuery(CommandType.StoredProcedure, true);
}
return pollGroup;
}
