/// <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(); }