/// <summary>
/// Gets an IDataReader with all rows in the i7_sflexi_items table.
/// </summary>
public static IDataReader GetAll(Guid siteGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_items_SelectAll", 1);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
return(sph.ExecuteReader());
}
/// <summary> Gets the reservation. </summary>
/// <param name="itemId"> The item identifier. </param>
/// <returns> IDataReader. </returns>
public static IDataReader GetReservation(int itemId)
{
var sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Reservation_SelectOne", 1);
sph.DefineSqlParameter("@ItemID", SqlDbType.Int, ParameterDirection.Input, itemId);
return(sph.ExecuteReader());
}
/// <summary>
/// Selects all Tracks for a particular player instance from the doan_MediaTracks table.
/// </summary>
/// <param name="playerID">The ID of the player.</param>
/// <returns>An IDataReader containing the MediaTrack(s) data.</returns>
public static IDataReader SelectByPlayer(int playerId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_MediaTrack_SelectByPlayer", 1);
sph.DefineSqlParameter("@PlayerID", SqlDbType.Int, ParameterDirection.Input, playerId);
return(sph.ExecuteReader());
}
public static IDataReader GetByOffer(Guid offerGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_OfferAvailability_SelectByOffer", 1);
sph.DefineSqlParameter("@OfferGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, offerGuid);
return(sph.ExecuteReader());
}
public static IDataReader GetNewsComments(int newsId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_NewsComment_Select", 1);
sph.DefineSqlParameter("@NewsID", SqlDbType.Int, ParameterDirection.Input, newsId);
return(sph.ExecuteReader());
}
public static IDataReader GetPageNewsComments(
int newsId,
int pageNumber,
int pageSize,
out int totalPages)
{
totalPages = 1;
int totalRows = GetCountNewsComment(newsId);
if (pageSize > 0)
{
totalPages = totalRows / pageSize;
}
if (totalRows <= pageSize)
{
totalPages = 1;
}
else
{
int remainder;
Math.DivRem(totalRows, pageSize, out remainder);
if (remainder > 0)
{
totalPages += 1;
}
}
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_NewsComment_SelectPage", 3);
sph.DefineSqlParameter("@NewsID", SqlDbType.Int, ParameterDirection.Input, newsId);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return(sph.ExecuteReader());
}
public static IDataReader GetByCart(Guid cartGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_CartOffers_SelectByCart", 1);
sph.DefineSqlParameter("@CartGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, cartGuid);
return(sph.ExecuteReader());
}
public static IDataReader Get(Guid guid)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_OrderOfferProduct_SelectOne", 1);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
return(sph.ExecuteReader());
}
/// <summary>
/// Selects all Files for a Track from the mp_MediaFile table.
/// </summary>
/// <param name="trackID">The ID of the Track.</param>
/// <returns>An IDataReader containing the Media File(s) data.</returns>
public static IDataReader SelectByTrack(int trackId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_MediaFile_SelectByTrack", 1);
sph.DefineSqlParameter("@TrackID", SqlDbType.Int, ParameterDirection.Input, trackId);
return(sph.ExecuteReader());
}
public static IDataReader GetByOrder(Guid orderGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_FullfillDownloadTicket_SelectByOrder", 1);
sph.DefineSqlParameter("@OrderGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, orderGuid);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets a page of data from the mp_TaskQueue table.
/// </summary>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
public DbDataReader GetPageUnfinished(
int pageNumber,
int pageSize)
{
//totalPages = 1;
//int totalRows
// = GetCountUnfinished();
//if (pageSize > 0) totalPages = totalRows / pageSize;
//if (totalRows <= pageSize)
//{
// totalPages = 1;
//}
//else
//{
// int remainder;
// Math.DivRem(totalRows, pageSize, out remainder);
// if (remainder > 0)
// {
// totalPages += 1;
// }
//}
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_TaskQueue_SelectPageIncomplete",
2);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets an IDataReader with the row from the doan_MediaPlayers table that exists for a Module.
/// </summary>
/// <param name="moduleID">The ID of the Module.</param>
/// <returns>The data for the Medai Player as an IDataReader object.</returns>
public static IDataReader SelectByModule(int moduleId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_MediaPlayer_SelectByModule", 1);
sph.DefineSqlParameter("@ModuleID", SqlDbType.Int, ParameterDirection.Input, moduleId);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets an IDataReader with all items for module.
/// </summary>
/// <param name="itemID"> itemID </param>
public static IDataReader GetModuleItems(int moduleId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_items_SelectAllForModule", 1);
sph.DefineSqlParameter("@ModuleID", SqlDbType.Int, ParameterDirection.Input, moduleId);
return(sph.ExecuteReader());
}
public static IDataReader GetOne(Guid guid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_searchdefs_SelectOne", 1);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
return(sph.ExecuteReader());
}
/// <summary>
/// Deletes items and values used by definition guid. Returns true if rows deleted.
/// </summary>
/// <param name="definitionGuid"> guid </param>
/// <returns>bool</returns>
//public static bool DeleteByDefinition(Guid definitionGuid)
//{
// SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "i7_sflexi_items_DeleteByDefinition", 1);
// sph.DefineSqlParameter("@DefinitionGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, definitionGuid);
// int rowsAffected = sph.ExecuteNonQuery();
// return (rowsAffected > 0);
//}
/// <summary>
/// Gets an IDataReader with one row from the i7_sflexi_items table.
/// </summary>
public static IDataReader GetOne(int itemID)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_items_SelectOne", 1);
sph.DefineSqlParameter("@ItemID", SqlDbType.Int, ParameterDirection.Input, itemID);
return(sph.ExecuteReader());
}
public static IDataReader GetByZone(int siteId, int zoneId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_Product_SelectByZone", 2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@ZoneID", SqlDbType.Int, ParameterDirection.Input, zoneId);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets value by ItemGuid and FieldGuid
/// </summary>
/// <param name="itemGuid"></param>
/// <param name="fieldGuid"></param>
/// <returns></returns>
public static IDataReader GetByItemField(Guid itemGuid, Guid fieldGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_values_SelectOneByItemField", 2);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
sph.DefineSqlParameter("@FieldGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, fieldGuid);
return(sph.ExecuteReader());
}
public static IDataReader GetByGuidForModule(Guid fieldGuid, int moduleId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_values_SelectByGuidForModuleById", 2);
sph.DefineSqlParameter("@FieldGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, fieldGuid);
sph.DefineSqlParameter("@ModuleId", SqlDbType.Int, ParameterDirection.Input, moduleId);
return(sph.ExecuteReader());
}
public static IDataReader GetPropertiesByProduct(int productId, int languageId)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_ProductProperties_SelectByProduct", 2);
sph.DefineSqlParameter("@ProductID", SqlDbType.Int, ParameterDirection.Input, productId);
sph.DefineSqlParameter("@LanguageID", SqlDbType.Int, ParameterDirection.Input, languageId);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets an IDataReader with one row from the gb_KLGratitude table.
/// </summary>
/// <param name="guestID"> guestID </param>
public static IDataReader GetOne(
int guestID)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_KLGratitude_SelectOne", 1);
sph.DefineSqlParameter("@GuestID", SqlDbType.Int, ParameterDirection.Input, guestID);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets an IDataReader from the mp_SurveyQuestionAnswers table.
/// </summary>
/// <param name="answerGuid"> answerGuid </param>
public static IDataReader GetResults(Guid surveyGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_SurveyQuestionAnswers_SelectBySurvey", 1);
sph.DefineSqlParameter("@SurveyGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, surveyGuid);
return(sph.ExecuteReader());
}
public static IDataReader GetOne(int tagID, int languageID)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_Tag_SelectOne", 2);
sph.DefineSqlParameter("@TagID", SqlDbType.Int, ParameterDirection.Input, tagID);
sph.DefineSqlParameter("@LanguageID", SqlDbType.Int, ParameterDirection.Input, languageID);
return(sph.ExecuteReader());
}
public static IDataReader GetOneByUserID(
int authorID)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_KLAuthor_SelectOneByUserID", 1);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, authorID);
return(sph.ExecuteReader());
}
public static IDataReader GetActivePolls(Guid siteGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Polls_SelectActive", 2);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@CurrentTime", SqlDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow);
return(sph.ExecuteReader());
}
public static IDataReader GetOneByCode(int siteID, string couponCode)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_Coupon_SelectOneByCode", 2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteID);
sph.DefineSqlParameter("@CouponCode", SqlDbType.NVarChar, 50, ParameterDirection.Input, couponCode);
return(sph.ExecuteReader());
}
public static IDataReader GetAllForDefinition(Guid definitionGuid, bool includeDeleted = false)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_fields_SelectAllForDefinition", 2);
sph.DefineSqlParameter("@DefinitionGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, definitionGuid);
sph.DefineSqlParameter("@IncludeDeleted", SqlDbType.Bit, ParameterDirection.Input, includeDeleted);
return(sph.ExecuteReader());
}
public static IDataReader GetForSiteMap(Guid siteGuid, Guid storeGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_Product_SelectForSiteMap", 2);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid);
return(sph.ExecuteReader());
}
public static IDataReader GetProductByPage(int siteId, int pageId)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_Product_SelectByPage", 2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@PageID", SqlDbType.Int, ParameterDirection.Input, pageId);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets an IDataReader with one row from the gb_KLViewHistory table.
/// </summary>
/// <param name="id"> id </param>
public static IDataReader GetOne(
int id)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_KLViewHistory_SelectOne", 1);
sph.DefineSqlParameter("@ID", SqlDbType.Int, ParameterDirection.Input, id);
return(sph.ExecuteReader());
}
/// <summary>
/// Gets an IDataReader with one row from the mp_SurveyResponses table.
/// </summary>
/// <param name="responseGuid"> responseGuid </param>
public static IDataReader GetOne(
Guid responseGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_SurveyResponses_SelectOne", 1);
sph.DefineSqlParameter("@ResponseGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, responseGuid);
return(sph.ExecuteReader());
}
public DbDataReader GetSiteSettingsExList(int siteId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_SiteSettingsEx_SelectAll",
1);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
return sph.ExecuteReader();
}
public DbDataReader GetUserCountByYearMonth(int siteId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_GetCountByMonthYear",
1);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
return sph.ExecuteReader();
}
//public DbDataReader GetSmartDropDownData(int siteId, string query, int rowsToGet)
//{
// SqlParameterHelper sph = new SqlParameterHelper(
// logFactory,
// readConnectionString,
// "mp_Users_SmartDropDown",
// 3);
// sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
// sph.DefineSqlParameter("@Query", SqlDbType.NVarChar, 50, ParameterDirection.Input, query);
// sph.DefineSqlParameter("@RowsToGet", SqlDbType.Int, ParameterDirection.Input, rowsToGet);
// return sph.ExecuteReader();
//}
public DbDataReader EmailLookup(int siteId, string query, int rowsToGet)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_EmailLookup",
3);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@Query", SqlDbType.NVarChar, 50, ParameterDirection.Input, query);
sph.DefineSqlParameter("@RowsToGet", SqlDbType.Int, ParameterDirection.Input, rowsToGet);
return sph.ExecuteReader();
}
public DbDataReader GetSiteNonAsync(Guid siteGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Sites_SelectOneByGuid",
1);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
return sph.ExecuteReader();
}
public DbDataReader GetSingleUserByLoginNameNonAsync(int siteId, string loginName, bool allowEmailFallback)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_SelectByLoginName",
3);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@LoginName", SqlDbType.NVarChar, 50, ParameterDirection.Input, loginName);
sph.DefineSqlParameter("@AllowEmailFallback", SqlDbType.Bit, ParameterDirection.Input, allowEmailFallback);
return sph.ExecuteReader();
}
/// <summary>
/// Gets an DbDataReader with one row from the mp_RedirectList table.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
public DbDataReader GetBySiteAndUrl(int siteId, string oldUrl)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_RedirectList_SelectBySiteAndUrl",
3);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@OldUrl", SqlDbType.NVarChar, 255, ParameterDirection.Input, oldUrl);
sph.DefineSqlParameter("@CurrentTime", SqlDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow);
return sph.ExecuteReader();
}
public DbDataReader GetSiteNonAsync(string hostName)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Sites_SelectOneByHost",
1);
sph.DefineSqlParameter("@HostName", SqlDbType.NVarChar, 50, ParameterDirection.Input, hostName);
return sph.ExecuteReader();
}
/// <summary>
/// Gets a page of data from the mp_UserLocation table.
/// </summary>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
/// <param name="totalPages">total pages</param>
public DbDataReader GetPageBySite(
Guid siteGuid,
int pageNumber,
int pageSize)
{
//totalPages = 1;
//int totalRows
// = GetCountBySite(siteGuid);
//if (pageSize > 0) totalPages = totalRows / pageSize;
//if (totalRows <= pageSize)
//{
// totalPages = 1;
//}
//else
//{
// int remainder;
// Math.DivRem(totalRows, pageSize, out remainder);
// if (remainder > 0)
// {
// totalPages += 1;
// }
//}
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_UserLocation_SelectPageBySite",
3);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return sph.ExecuteReader();
}
/// <summary>
/// Gets a page of data from the mp_RedirectList table.
/// </summary>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
/// <param name="totalPages">total pages</param>
public DbDataReader GetPage(
int siteId,
int pageNumber,
int pageSize)
{
//totalPages = 1;
//int totalRows = GetCount(siteId);
//if (pageSize > 0) totalPages = totalRows / pageSize;
//if (totalRows <= pageSize)
//{
// totalPages = 1;
//}
//else
//{
// int remainder;
// Math.DivRem(totalRows, pageSize, out remainder);
// if (remainder > 0)
// {
// totalPages += 1;
// }
//}
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_RedirectList_SelectPage",
3);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return sph.ExecuteReader();
}
public DbDataReader GetRolesUserIsNotIn(
int siteId,
int userId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Roles_SelectRolesUserIsNotIn",
2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userId);
return sph.ExecuteReader();
}
public DbDataReader GetTop50UsersOnlineSince(int siteId, DateTime sinceTime)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_SelectTop50UsersOnlineSinceTime",
2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@SinceTime", SqlDbType.DateTime, ParameterDirection.Input, sinceTime);
return sph.ExecuteReader();
}
/// <summary>
/// Gets an IDataReader with one row from the mp_BannedIPAddresses table.
/// </summary>
/// <param name="rowID"> rowID </param>
public DbDataReader GetOne(int rowId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_BannedIPAddresses_SelectOne",
1);
sph.DefineSqlParameter("@RowID", SqlDbType.Int, ParameterDirection.Input, rowId);
return sph.ExecuteReader();
}
public DbDataReader GetDefaultExpandoSettings()
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_SiteSettingsExDef_SelectAll",
0);
return sph.ExecuteReader();
}
/// <summary>
/// Gets an IDataReader with one row from the mp_UserLocation table.
/// </summary>
/// <param name="userGuid"> userGuid </param>
public DbDataReader GetByUser(Guid userGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_UserLocation_SelectByUser",
1);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
return sph.ExecuteReader();
}
/// <summary>
/// Gets a page of data from the mp_UserLocation table.
/// </summary>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
/// <param name="totalPages">total pages</param>
public DbDataReader GetPageBySite(
Guid siteGuid,
int pageNumber,
int pageSize)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_UserLocation_SelectPageBySite",
3);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return sph.ExecuteReader();
}
/// <summary>
/// Gets an DbDataReader with one row from the mp_RedirectList table.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
public DbDataReader GetOne(Guid rowGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_RedirectList_SelectOne",
1);
sph.DefineSqlParameter("@RowGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, rowGuid);
return sph.ExecuteReader();
}
public Guid GetUserGuidFromWindowsLiveId(
int siteId,
string windowsLiveId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_SelectGuidByWindowsLiveID",
2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@WindowsLiveID", SqlDbType.NVarChar, 100, ParameterDirection.Input, windowsLiveId);
Guid userGuid = Guid.Empty;
using (DbDataReader reader = sph.ExecuteReader())
{
if (reader.Read())
{
userGuid = new Guid(reader["UserGuid"].ToString());
}
}
return userGuid;
}
public DbDataReader GetRoleMembers(int roleId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_UserRoles_SelectByRoleID",
1);
sph.DefineSqlParameter("@RoleID", SqlDbType.Int, ParameterDirection.Input, roleId);
return sph.ExecuteReader();
}
//public DataTable GetNonLazyLoadedPropertiesForUser(Guid userGuid)
//{
// SqlParameterHelper sph = new SqlParameterHelper(
// logFactory,
// readConnectionString,
// "mp_UserProperties_SelectByUser",
// 1);
// sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
// DataTable dataTable = new DataTable();
// dataTable.Columns.Add("UserGuid", typeof(String));
// dataTable.Columns.Add("PropertyName", typeof(String));
// dataTable.Columns.Add("PropertyValueString", typeof(String));
// // dataTable.Columns.Add("PropertyValueBinary", typeof(object));
// using (DbDataReader reader = sph.ExecuteReader())
// {
// while (reader.Read())
// {
// DataRow row = dataTable.NewRow();
// row["UserGuid"] = reader["UserGuid"].ToString();
// row["PropertyName"] = reader["PropertyName"].ToString();
// row["PropertyValueString"] = reader["PropertyValueString"].ToString();
// //row["PropertyValueBinary"] = reader["PropertyValueBinary"];
// dataTable.Rows.Add(row);
// }
// }
// return dataTable;
//}
public DbDataReader GetLazyLoadedProperty(Guid userGuid, String propertyName)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_UserProperties_SelectOne",
2);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@PropertyName", SqlDbType.NVarChar, 255, ParameterDirection.Input, propertyName);
return sph.ExecuteReader();
}
private DbDataReader GetSchemaVersionFromGuid(Guid applicationId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_SchemaVersion_SelectOne",
1);
sph.DefineSqlParameter("@ApplicationID", SqlDbType.UniqueIdentifier, ParameterDirection.Input, applicationId);
return sph.ExecuteReader();
}
/// <summary>
/// Gets an IDataReader with all incomplete tasks in the mp_TaskQueue table.
/// </summary>
/// <param name="siteGuid"> guid </param>
public DbDataReader GetUnfinished(Guid siteGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_TaskQueue_SelectIncompleteBySite",
1);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
return sph.ExecuteReader();
}
/// <summary>
/// Gets a page of data from the mp_TaskQueue table.
/// </summary>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
public DbDataReader GetPageUnfinished(
int pageNumber,
int pageSize)
{
//totalPages = 1;
//int totalRows
// = GetCountUnfinished();
//if (pageSize > 0) totalPages = totalRows / pageSize;
//if (totalRows <= pageSize)
//{
// totalPages = 1;
//}
//else
//{
// int remainder;
// Math.DivRem(totalRows, pageSize, out remainder);
// if (remainder > 0)
// {
// totalPages += 1;
// }
//}
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_TaskQueue_SelectPageIncomplete",
2);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return sph.ExecuteReader();
}
/// <summary>
/// Gets an IDataReader with one row from the mp_UserLocation table.
/// </summary>
/// <param name="userGuid"> userGuid </param>
/// <param name="iPAddress"> iPAddress </param>
public DbDataReader GetOne(Guid userGuid, long iPAddressLong)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_UserLocation_SelectOneByUserAndIP",
2);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@IPAddressLong", SqlDbType.BigInt, ParameterDirection.Input, iPAddressLong);
return sph.ExecuteReader();
}
/// <summary>
/// Gets an IDataReader with rows from the mp_BannedIPAddresses table.
/// </summary>
/// <param name="ipAddress"> ipAddress </param>
public DbDataReader GeByIpAddress(string ipAddress)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_BannedIPAddresses_SelectByIP",
1);
sph.DefineSqlParameter("@BannedIP", SqlDbType.NVarChar, 50, ParameterDirection.Input, ipAddress);
return sph.ExecuteReader();
}
