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 ForumThreadGetPost(int postId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ForumPosts_SelectOne", 1); sph.DefineSqlParameter("@PostID", SqlDbType.Int, ParameterDirection.Input, postId); return(sph.ExecuteReader()); }
public static IDataReader GetThreadsForSiteMap(int siteId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ForumThreads_SelectForSiteMap", 1); sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId); return(sph.ExecuteReader()); }
public static IDataReader GetForumSubscription(Guid subGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ForumSubscriptions_SelectOne", 1); sph.DefineSqlParameter("@SubGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, subGuid); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with one row from the mp_ContentRating table. /// </summary> /// <param name="contentGuid"> contentGuid </param> public static IDataReader GetStatsByContent(Guid contentGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ContentRating_GetStatsByContent", 1); sph.DefineSqlParameter("@ContentGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, contentGuid); return(sph.ExecuteReader()); }
public static IDataReader SelectBySite(int siteId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_WebParts_SelectBySite", 1); sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId); return(sph.ExecuteReader()); }
public static IDataReader ForumThreadGetPostsReverseSorted(int threadId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ForumPosts_SelectAllByThreadRevereSorted", 1); sph.DefineSqlParameter("@ThreadID", SqlDbType.Int, ParameterDirection.Input, threadId); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with all rows in the mp_Letter table. /// </summary> public static IDataReader GetAll(Guid letterInfoGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Letter_SelectAll", 1); sph.DefineSqlParameter("@LetterInfoGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, letterInfoGuid); return(sph.ExecuteReader()); }
public static IDataReader SelectByUser(Guid userGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_UserPages_SelectByUser", 1); sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with one row from the mp_GeoZone table. /// </summary> /// <param name="guid"> guid </param> public static IDataReader GetByCode(Guid countryGuid, string code) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_GeoZone_SelectByCode", 2); sph.DefineSqlParameter("@CountryGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, countryGuid); sph.DefineSqlParameter("@Code", SqlDbType.NVarChar, 255, ParameterDirection.Input, code); return sph.ExecuteReader(); }
/// <summary> /// Gets an IDataReader with one row from the mp_SurveyQuestionAnswers table. /// </summary> /// <param name="answerGuid"> answerGuid </param> public static IDataReader GetOne(Guid responseGuid, Guid questionGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_SurveyQuestionAnswers_SelectOne", 2); sph.DefineSqlParameter("@ResponseGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, responseGuid); sph.DefineSqlParameter("@QuestionGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, questionGuid); return sph.ExecuteReader(); }
public static IDataReader Find(string loginProvider, string providerKey) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_UserLogins_Find", 2); sph.DefineSqlParameter("@LoginProvider", SqlDbType.NVarChar, 128, ParameterDirection.Input, loginProvider); sph.DefineSqlParameter("@ProviderKey", SqlDbType.NVarChar, 128, ParameterDirection.Input, providerKey); return sph.ExecuteReader(); }
/// <summary> /// Gets an IDataReader with all rows in the mp_Currency table. /// </summary> public static IDataReader GetSpecificSettingAllModulesWithTheDefinition(string srcPath, string settingName) { SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "mp_ModulePagePath_SelectByControlSrcPathSnippet", 2); sph.DefineSqlParameter("@FeaturePath", SqlDbType.UniqueIdentifier, ParameterDirection.Input, srcPath); sph.DefineSqlParameter("@SettingName", SqlDbType.NVarChar, ParameterDirection.Input, settingName); return sph.ExecuteReader(); }
public static IDataReader Get(int projectId, int blockId, int workId, int groupId, int itemId, int subItemId) { StringBuilder sb = new StringBuilder(); string prefix = DBHelper.Instance.TablePrefix; sb.Append("SELECT s.IdProyecto ProjectId, "); sb.Append("s.IdBloque BlockId, "); sb.Append("s.IdObra WorkId, "); sb.Append("s.IdGrupo GroupId, "); sb.Append("s.IdItem ItemId, "); sb.Append("s.Id SubItemId, "); sb.Append("s.Nombre Name,"); sb.Append("s.Cantidad Quantity "); sb.AppendFormat("FROM {0}SubItem s ", prefix); sb.AppendFormat("WHERE s.IdProyecto={0} ", projectId); sb.AppendFormat("AND s.IdBloque={0} ", blockId); sb.AppendFormat("AND s.IdObra={0} ", workId); sb.AppendFormat("AND s.IdGrupo={0} ", groupId); sb.AppendFormat("AND s.IdItem={0} ", itemId); sb.AppendFormat("AND s.Id={0} ", subItemId); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader GetAllByPage(Guid pageQuestionGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_SurveyQuestions_SelectAllByPage", 1); sph.DefineSqlParameter("@PageGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, pageQuestionGuid); 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 static IDataReader GetPage( int siteId, int pageNumber, int pageSize, out int totalPages) { 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(ConnectionString.GetReadConnectionString(), "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()); }
/// <summary> /// Gets an IDataReader with all incomplete tasks in the mp_TaskQueue table. /// </summary> /// <param name="siteGuid"> guid </param> public static IDataReader GetUnfinished(Guid siteGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "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 static IDataReader GetPageUnfinished( int pageNumber, int pageSize, out int totalPages) { 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(ConnectionString.GetReadConnectionString(), "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 rows from the mp_AuthorizeNetLog table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader GetByCart(Guid cartGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_AuthorizeNetLog_SelectByCart", 1); sph.DefineSqlParameter("@CartGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, cartGuid); return(sph.ExecuteReader()); }
/// <summary> /// Gets a page of data from the mp_ContentHistory table. /// </summary> /// <param name="pageNumber">The page number.</param> /// <param name="pageSize">Size of the page.</param> /// <param name="totalPages">total pages</param> public static IDataReader GetPage( Guid contentGuid, int pageNumber, int pageSize, out int totalPages) { totalPages = 1; int totalRows = GetCount(contentGuid); 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(), "mp_ContentHistory_SelectPage", 3); sph.DefineSqlParameter("@ContentGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, contentGuid); sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber); sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with rows from the mp_Comments table. /// </summary> /// <param name="guid"> guid </param> public static IDataReader GetByParentDesc(Guid parentGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Comments_SelectByParentDesc", 1); sph.DefineSqlParameter("@ParentGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, parentGuid); return(sph.ExecuteReader()); }
public static IDataReader GetHtmlForMetaWeblogApi(int siteId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_HtmlContent_SelectForMetaWeblogApi", 1); sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId); return(sph.ExecuteReader()); }
public static IDataReader GetHtmlContent(int moduleId, int itemId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_HtmlContent_SelectOne", 1); sph.DefineSqlParameter("@ItemID", SqlDbType.Int, ParameterDirection.Input, itemId); return(sph.ExecuteReader()); }
public static IDataReader PageModuleGetReaderByPage(int pageId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_PageModule_SelectByPage", 1); sph.DefineSqlParameter("@PageID", SqlDbType.Int, ParameterDirection.Input, pageId); return(sph.ExecuteReader()); }
public static IDataReader GetSite(string hostName) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Sites_SelectOneByHost", 1); sph.DefineSqlParameter("@HostName", SqlDbType.NVarChar, 50, ParameterDirection.Input, hostName); return(sph.ExecuteReader()); }
public static IDataReader GetModule(int moduleId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Modules_SelectOne", 1); sph.DefineSqlParameter("@ModuleID", SqlDbType.Int, ParameterDirection.Input, moduleId); return(sph.ExecuteReader()); }
public static IDataReader GetPageListForAdmin(int siteId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Pages_SelectList", 1); sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with one row from the mp_RedirectList table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader GetOne(Guid rowGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_RedirectList_SelectOne", 1); sph.DefineSqlParameter("@RowGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, rowGuid); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with one row from the ws_GoogleCheckoutLog table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader GetMostRecentByOrder(string googleOrderId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_GoogleCheckoutLog_SelectMostRecentByOrder", 1); sph.DefineSqlParameter("@OrderNumber", SqlDbType.NVarChar, 50, ParameterDirection.Input, googleOrderId); return(sph.ExecuteReader()); }
public static IDataReader GetWebPart(Guid webPartId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_WebParts_SelectOne", 1); sph.DefineSqlParameter("@WebPartID", SqlDbType.UniqueIdentifier, ParameterDirection.Input, webPartId); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with all rows in the mp_GeoZone table. /// </summary> public static IDataReader GetByCountry(Guid countryGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_GeoZone_SelectByCountry", 1); sph.DefineSqlParameter("@CountryGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, countryGuid); return(sph.ExecuteReader()); }
public static IDataReader GetByModule(Guid moduleGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Category_SelectByModule", 1); sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid); return(sph.ExecuteReader()); }
public static IDataReader GetHistoryFile(int id) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_SharedFilesHistory_SelectOne", 1); sph.DefineSqlParameter("@ID", SqlDbType.Int, ParameterDirection.Input, id); return(sph.ExecuteReader()); }
/// <summary> /// Gets an IDataReader with one row from the mp_PayPalLog table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader GetSetExpressCheckout(string token) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_PayPalLog_SelectSetExpressCheckoutByToken", 1); sph.DefineSqlParameter("@Token", SqlDbType.NVarChar, 50, ParameterDirection.Input, token); return(sph.ExecuteReader()); }
public static IDataReader GetSharedFileFolder(int folderId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_SharedFileFolders_SelectOne", 1); sph.DefineSqlParameter("@FolderID", SqlDbType.Int, ParameterDirection.Input, folderId); return(sph.ExecuteReader()); }
public static IDataReader GetByName(int siteId, string roleName) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Roles_SelectOneByName", 2); sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId); sph.DefineSqlParameter("@RoleName", SqlDbType.NVarChar, 50, ParameterDirection.Input, roleName); return sph.ExecuteReader(); }
public static IDataReader GetBySite(Guid siteGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_SiteFolders_SelectBySite", 1); sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid); return(sph.ExecuteReader()); }
public static IDataReader GetGlobalContent(int siteId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Modules_SelectGlobalContent", 1); sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId); return(sph.ExecuteReader()); }
public static IDataReader Get(int projectId, int blockId) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT Nombre Name "); sb.AppendFormat("FROM {0}Bloque ", DBHelper.Instance.TablePrefix); sb.AppendFormat("WHERE IdProyecto={0} AND Id={1}", projectId, blockId); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
//public static IDataReader Get(int projectId, int blockId, int workId, int groupId) //{ // string prefix = DBHelper.Instance.TablePrefix; // StringBuilder sb = new StringBuilder(); // sb.Append("SELECT g.Id GroupId,"); // sb.Append("l.Nombre Name "); // sb.AppendFormat("FROM {0}Grupo g INNER JOIN {0}ListaGrupo l ON g.IdListaGrupo=l.Id ", prefix); // sb.AppendFormat("WHERE g.IdProyecto={0} ", projectId); // sb.AppendFormat("AND g.IdBloque={0} ", blockId); // sb.AppendFormat("AND g.IdObra={0} ", workId); // sb.AppendFormat("AND g.Id={0}", groupId); // SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); // return sph.ExecuteReader(); //} public static IDataReader GetAll() { StringBuilder sb = new StringBuilder(); sb.Append("SELECT * "); sb.AppendFormat("FROM uListaGrupo "); sb.Append("ORDER BY Nombre"); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader GetAll(int projectId, int blockId) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT Id AS WorkId,"); sb.Append("Nombre AS Name "); sb.AppendFormat("FROM {0}Obra ", DBHelper.Instance.TablePrefix); sb.AppendFormat("WHERE IdProyecto={0} AND ", projectId); sb.AppendFormat("IdBloque={0} ", blockId); sb.Append("ORDER BY Nombre"); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader GetAll() { SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, "SELECT Id AS ProjectId," + "Nombre AS Name," + "FechaCreacion AS DateCreated," + "FechaModificacion AS DateModified," + "Usuario AS CreatedBy," + "UsuarioModificador AS ModifiedBy " + "FROM uProyecto " + "ORDER BY Nombre", CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader GetAll(int projectId, int blockId, int workId) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT g.Id AS GroupId,"); sb.Append("l.Nombre AS Name "); sb.AppendFormat("FROM {0}Grupo g INNER JOIN {0}ListaGrupo l ON g.IdListaGrupo=l.Id ", DBHelper.Instance.TablePrefix); sb.AppendFormat("WHERE g.IdProyecto={0} AND ", projectId); sb.AppendFormat("g.IdBloque={0} AND ", blockId); sb.AppendFormat("g.IdObra={0} ", workId); sb.Append("ORDER BY l.Nombre"); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader Get(int projectId) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT Id AS ProjectId,"); sb.Append("Nombre AS Name,"); sb.Append("FechaCreacion AS DateCreated,"); sb.Append("FechaModificacion AS DateModified,"); sb.Append("Usuario AS CreatedBy,"); sb.Append("UsuarioModificador AS ModifiedBy "); sb.AppendFormat("FROM {0}Proyecto ", DBHelper.Instance.TablePrefix); sb.AppendFormat("WHERE Id={0}", projectId); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader Get(int projectId, int blockId, int workId, int groupId, int itemId) { string prefix = DBHelper.Instance.TablePrefix; StringBuilder sb = new StringBuilder(); sb.Append("SELECT i.Id ItemId,"); sb.Append("l.Nombre Name "); sb.AppendFormat("FROM {0}Item i INNER JOIN {0}ListaItem l ON i.IdListaItem=l.Id ", prefix); sb.AppendFormat("WHERE i.IdProyecto={0} ", projectId); sb.AppendFormat("AND i.IdBloque={0} ", blockId); sb.AppendFormat("AND i.IdObra={0} ", workId); sb.AppendFormat("AND i.IdGrupo={0} ", groupId); sb.AppendFormat("AND i.Id={0}", itemId); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader Get(int projectId, int blockId, int workId, int groupId, int itemId, int subItemId, string currencyCode) { StringBuilder sb = new StringBuilder(); string prefix = DBHelper.Instance.TablePrefix; sb.Append("SELECT s.IdProyecto ProjectId, "); sb.Append("s.IdBloque BlockId, "); sb.Append("s.IdObra WorkId, "); sb.Append("s.IdGrupo GroupId, "); sb.Append("s.IdItem ItemId, "); sb.Append("s.Id SubItemId, "); sb.Append("s.Nombre Name, "); sb.Append("l.Unidad Unit, "); sb.Append("s.Cantidad Quantity, "); if (currencyCode.Contains("$us")) { sb.Append("l.PrecioSus UnitPrice, "); sb.Append("l.PrecioSus*s.Cantidad TotalPrice "); } else { sb.Append("l.PrecioBs UnitPrice, "); sb.Append("l.PrecioBs*s.Cantidad TotalPrice "); } sb.AppendFormat("FROM {0}SubItem s INNER JOIN ", prefix); sb.AppendFormat("({0}Item i INNER JOIN {0}ListaItem l ON i.IdListaItem=l.Id) ", prefix); sb.AppendFormat("ON (s.IdProyecto=i.IdProyecto AND s.IdBloque=i.IdBloque AND s.IdObra=i.IdObra AND s.IdGrupo=i.IdGrupo AND s.IdItem=i.Id) "); sb.AppendFormat("WHERE s.IdProyecto={0} ", projectId); sb.AppendFormat("AND s.IdBloque={0} ", blockId); sb.AppendFormat("AND s.IdObra={0} ", workId); sb.AppendFormat("AND s.IdGrupo={0} ", groupId); sb.AppendFormat("AND s.IdItem={0} ", itemId); sb.AppendFormat("AND s.Id={0} ", subItemId); SqlParameterHelper sph = new SqlParameterHelper(DBHelper.Instance.ConnectionString, sb.ToString(), CommandType.Text, 0); return sph.ExecuteReader(); }
public static IDataReader GetWorkInProgress(Guid moduleGuid, string status) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ContentWorkflow_SelectWorkInProgressByStatus", 2); sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid); sph.DefineSqlParameter("@Status", SqlDbType.NVarChar, 20, ParameterDirection.Input, status); return sph.ExecuteReader(); }
public static IDataReader GetPage( Guid siteGuid, string status, int pageNumber, int pageSize, out int totalPages) { totalPages = 1; int totalRows = GetCount(siteGuid, status); 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(), "mp_ContentWorkflow_SelectPage", 4); sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid); sph.DefineSqlParameter("@Status", SqlDbType.NVarChar, ParameterDirection.Input, status); sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber); sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize); return sph.ExecuteReader(); }
public static IDataReader GetPageInfoForPage( Guid siteGuid, string status, int pageNumber, int pageSize) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ContentWorkflow_SelectPageInfoForPage", 4); sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid); sph.DefineSqlParameter("@Status", SqlDbType.NVarChar, ParameterDirection.Input, status); 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 ws_GoogleCheckoutLog table. /// </summary> /// <param name="storeGuid">The storeGuid</param> /// <param name="pageNumber">The page number.</param> /// <param name="pageSize">Size of the page.</param> /// <param name="totalPages">total pages</param> public static IDataReader GetPageByStore( Guid storeGuid, int pageNumber, int pageSize, out int totalPages) { totalPages = 1; int totalRows = GetCountByStore(storeGuid); 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(), "mp_GoogleCheckoutLog_SelectPage", 3); sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid); sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber); sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize); return sph.ExecuteReader(); }
public static Guid GetDraftSubmitter(Guid contentWorkflowGuid) { Guid result = Guid.Empty; SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_ContentWorkflowAuditHistory_GetDraftSubmitter", 1); sph.DefineSqlParameter("@ContentWorkflowGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, contentWorkflowGuid); using (IDataReader reader = sph.ExecuteReader()) { if (reader.Read()) { result = new Guid(reader[0].ToString()); } } return result; }
/// <summary> /// Gets an IDataReader with one row from the ws_GoogleCheckoutLog table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader GetMostRecentByOrder(string googleOrderId) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_GoogleCheckoutLog_SelectMostRecentByOrder", 1); sph.DefineSqlParameter("@OrderNumber", SqlDbType.NVarChar, 50, ParameterDirection.Input, googleOrderId); return sph.ExecuteReader(); }
/// <summary> /// Gets an IDataReader with one row from the mp_GoogleCheckoutLog table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader GetOne(Guid rowGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_GoogleCheckoutLog_SelectOne", 1); sph.DefineSqlParameter("@RowGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, rowGuid); return sph.ExecuteReader(); }
/// <summary> /// Gets an IDataReader with rows from the mp_FileAttachment table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader SelectBySpecial2(Guid specialGuid2) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_FileAttachment_SelectBySpecial2", 1); sph.DefineSqlParameter("@SpecialGuid2", SqlDbType.UniqueIdentifier, ParameterDirection.Input, specialGuid2); return sph.ExecuteReader(); }
public static IDataReader GetPoll(Guid pollGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Polls_SelectOne", 1); sph.DefineSqlParameter("@PollGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, pollGuid); return sph.ExecuteReader(); }
public static IDataReader GetPollByModuleID(int moduleID) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Polls_SelectOneByModuleID", 1); sph.DefineSqlParameter("@ModuleID", SqlDbType.Int, ParameterDirection.Input, moduleID); return sph.ExecuteReader(); }
public static IDataReader GetByModule(Guid moduleGuid) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_Tag_SelectByModule", 1); sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid); return sph.ExecuteReader(); }
/// <summary> /// Gets an IDataReader with rows from the mp_EmailSendQueue table where DateToSend >= CurrentTime. /// </summary> /// <param name="currentTime"> currentTime </param> public static IDataReader GetEmailToSend(DateTime currentTime) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "mp_EmailSendQueue_SelectForSending", 1); sph.DefineSqlParameter("@CurrentTime", SqlDbType.DateTime, ParameterDirection.Input, currentTime); return sph.ExecuteReader(); }
public static IDataReader GetFullfillDownloadTermsPage( Guid storeGuid, int pageNumber, int pageSize) { SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_FullfillDownloadTerms_SelectPage", 3); sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid); sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber); sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize); return sph.ExecuteReader(); }
public static IDataReader GetAll(Guid storeGuid) { SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_FullfillDownloadTerms_SelectAll", 1); sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid); return sph.ExecuteReader(); }