/// <summary> /// Gets a page of data from the cy_PayPalLog 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 pageNumber, int pageSize, out int totalPages) { int pageLowerBound = (pageSize * pageNumber) - pageSize; totalPages = 1; int totalRows = GetCount(); 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; } } StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_PayPalLog "); //sqlCommand.Append("WHERE "); //sqlCommand.Append("ORDER BY "); //sqlCommand.Append(" "); sqlCommand.Append("LIMIT :PageSize, :OffsetRows "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[2]; arParams[0] = new SqliteParameter(":PageSize", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = pageSize; arParams[1] = new SqliteParameter(":OffsetRows", DbType.Int32); arParams[1].Direction = ParameterDirection.Input; arParams[1].Value = pageLowerBound; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
public static IDataReader Search(Guid letterInfoGuid, string emailOrIpAddress) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT "); sqlCommand.Append("ls.Guid AS Guid, "); sqlCommand.Append("ls.SiteGuid AS SiteGuid, "); sqlCommand.Append("ls.LetterInfoGuid AS LetterInfoGuid, "); sqlCommand.Append("ls.UserGuid AS UserGuid, "); sqlCommand.Append("ls.IsVerified AS IsVerified, "); sqlCommand.Append("ls.VerifyGuid AS VerifyGuid, "); sqlCommand.Append("ls.BeginUtc AS BeginUtc, "); sqlCommand.Append("ls.UseHtml AS UseHtml, "); sqlCommand.Append("ls.IpAddress AS IpAddress, "); sqlCommand.Append("COALESCE(u.Email, ls.Email) As Email, "); sqlCommand.Append("u.Email AS UserEmail, "); sqlCommand.Append("COALESCE(u.Name, ls.Email) AS Name "); sqlCommand.Append("FROM cy_LetterSubscribe ls "); sqlCommand.Append("LEFT OUTER JOIN cy_Users u "); sqlCommand.Append("ON "); sqlCommand.Append("u.UserGuid = ls.UserGuid "); sqlCommand.Append("WHERE "); sqlCommand.Append("ls.LetterInfoGuid = :LetterInfoGuid "); sqlCommand.Append(" AND "); sqlCommand.Append("("); sqlCommand.Append(" (ls.Email LIKE :EmailOrIpAddress) "); sqlCommand.Append(" OR "); sqlCommand.Append(" (u.Email LIKE :EmailOrIpAddress) "); sqlCommand.Append(" OR "); sqlCommand.Append(" (ls.IpAddress LIKE :EmailOrIpAddress) "); sqlCommand.Append(")"); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[2]; arParams[0] = new SqliteParameter(":LetterInfoGuid", DbType.String, 36); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = letterInfoGuid.ToString(); arParams[1] = new SqliteParameter(":EmailOrIpAddress", DbType.String, 36); arParams[1].Direction = ParameterDirection.Input; arParams[1].Value = emailOrIpAddress; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets a page of data from the cy_LetterHtmlTemplate 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 siteGuid, int pageNumber, int pageSize, out int totalPages) { int pageLowerBound = (pageSize * pageNumber) - pageSize; totalPages = 1; int totalRows = GetCount(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; } } StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_LetterHtmlTemplate "); sqlCommand.Append("WHERE "); sqlCommand.Append("SiteGuid = :SiteGuid "); sqlCommand.Append("LIMIT " + pageLowerBound.ToString() + ", :PageSize ; "); SqliteParameter[] arParams = new SqliteParameter[2]; arParams[0] = new SqliteParameter(":SiteGuid", DbType.String, 36); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = siteGuid.ToString(); arParams[1] = new SqliteParameter(":PageSize", DbType.Int32); arParams[1].Direction = ParameterDirection.Input; arParams[1].Value = pageSize; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with all rows in the cy_BannedIPAddresses table. /// </summary> public static IDataReader GetAll() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_BannedIPAddresses ;"); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null)); }
/// <summary> /// Gets an IDataReader with all rows in the cy_GoogleCheckoutLog table. /// </summary> public static IDataReader GetAll() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_GoogleCheckoutLog "); sqlCommand.Append(";"); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null)); }
/// <summary> /// Gets a page of data from the cy_TaskQueue 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 GetPageUnfinished( int pageNumber, int pageSize, out int totalPages) { int pageLowerBound = (pageSize * pageNumber) - 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; } } StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_TaskQueue "); sqlCommand.Append("WHERE "); sqlCommand.Append("CompleteUTC IS NULL "); sqlCommand.Append("ORDER BY "); sqlCommand.Append("QueuedUTC DESC "); sqlCommand.Append("LIMIT " + pageLowerBound.ToString() + ", :PageSize "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":PageSize", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = pageSize; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with all rows in the cy_Language table. /// </summary> public static IDataReader GetAll() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_Language "); sqlCommand.Append("ORDER BY [Sort] "); sqlCommand.Append(";"); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null)); }
public static IDataReader GetSharedFiles(int moduleId, int folderId) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT "); sqlCommand.Append("sf.ItemID, "); sqlCommand.Append("sf.ModuleID, "); sqlCommand.Append("sf.UploadUserID, "); sqlCommand.Append("sf.FriendlyName, "); sqlCommand.Append("sf.OriginalFileName, "); sqlCommand.Append("sf.ServerFileName, "); sqlCommand.Append("sf.SizeInKB, "); sqlCommand.Append("sf.UploadDate, "); sqlCommand.Append("sf.FolderID, "); sqlCommand.Append("sf.ItemGuid, "); sqlCommand.Append("sf.FolderGuid, "); sqlCommand.Append("sf.UserGuid, "); sqlCommand.Append("sf.ModuleGuid, "); sqlCommand.Append("sf.Description, "); sqlCommand.Append("sf.DownloadCount, "); sqlCommand.Append("u.Name As UserName "); sqlCommand.Append("FROM cy_SharedFiles sf "); sqlCommand.Append("LEFT OUTER JOIN cy_Users u "); sqlCommand.Append("ON sf.UploadUserID = u.UserID "); sqlCommand.Append("WHERE "); sqlCommand.Append("sf.ModuleID = :ModuleID "); sqlCommand.Append("AND sf.FolderID = :FolderID "); sqlCommand.Append("ORDER BY "); sqlCommand.Append("sf.FriendlyName "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[2]; arParams[0] = new SqliteParameter(":ModuleID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = moduleId; arParams[1] = new SqliteParameter(":FolderID", DbType.Int32); arParams[1].Direction = ParameterDirection.Input; arParams[1].Value = folderId; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
public static IDataReader DatabaseHelperGetReader( string connectionString, string query ) { if (string.IsNullOrEmpty(connectionString)) { connectionString = GetConnectionString(); } return(SqliteHelper.ExecuteReader( connectionString, query)); }
public static Guid GetSiteGuid(string folderName) { StringBuilder sqlCommand = new StringBuilder(); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":FolderName", DbType.String, 255); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = folderName; Guid siteGuid = Guid.Empty; sqlCommand.Append("SELECT SiteGuid "); sqlCommand.Append("FROM cy_SiteFolders "); sqlCommand.Append("WHERE FolderName = :FolderName ;"); using (IDataReader reader = SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)) { if (reader.Read()) { siteGuid = new Guid(reader["SiteGuid"].ToString()); } } if (siteGuid == Guid.Empty) { sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT SiteGuid "); sqlCommand.Append("FROM cy_Sites "); sqlCommand.Append("ORDER BY SiteID "); sqlCommand.Append("LIMIT 1 ;"); using (IDataReader reader = SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null)) { if (reader.Read()) { siteGuid = new Guid(reader["SiteGuid"].ToString()); } } } return(siteGuid); }
public static IDataReader GetByUrl(string hostName, string friendlyUrl) { int siteId = 1; StringBuilder sqlCommand = new StringBuilder(); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":HostName", DbType.String, 255); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = hostName; sqlCommand.Append("SELECT cy_SiteHosts.SiteID As SiteID "); sqlCommand.Append("FROM cy_SiteHosts "); sqlCommand.Append("WHERE cy_SiteHosts.HostName = :HostName ;"); using (IDataReader reader = SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)) { if (reader.Read()) { siteId = Convert.ToInt32(reader["SiteID"]); } } sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_FriendlyUrls "); sqlCommand.Append("WHERE "); sqlCommand.Append("SiteID = :SiteID "); sqlCommand.Append("AND FriendlyUrl = :FriendlyUrl ;"); arParams = new SqliteParameter[2]; arParams[0] = new SqliteParameter(":SiteID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = siteId; arParams[1] = new SqliteParameter(":FriendlyUrl", DbType.String, 255); arParams[1].Direction = ParameterDirection.Input; arParams[1].Value = friendlyUrl; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with all rows in the cy_TaskQueue table. /// </summary> public static IDataReader GetUnfinished() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_TaskQueue "); sqlCommand.Append("WHERE "); sqlCommand.Append("CompleteUTC IS NULL "); sqlCommand.Append(";"); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null)); }
public static IDataReader DatabaseHelperGetReader( String connectionString, String tableName, String whereClause) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM " + tableName + " "); sqlCommand.Append(whereClause); sqlCommand.Append(" ; "); return(SqliteHelper.ExecuteReader( connectionString, sqlCommand.ToString())); }
/// <summary> /// Gets an IDataReader with all rows in the cy_IndexingQueue table. /// </summary> public static DataTable GetIndexPaths() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT DISTINCT IndexPath "); sqlCommand.Append("FROM cy_IndexingQueue "); sqlCommand.Append("ORDER BY IndexPath "); sqlCommand.Append(";"); IDataReader reader = SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null); return(DBPortal.GetTableFromDataReader(reader)); }
public static IDataReader GetHtmlContentByPage(int siteId, int pageId) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT ce.*, "); sqlCommand.Append("m.ModuleTitle As ModuleTitle, "); sqlCommand.Append("m.ViewRoles As ViewRoles, "); sqlCommand.Append("md.FeatureName As FeatureName "); sqlCommand.Append("FROM cy_HtmlContent ce "); sqlCommand.Append("JOIN cy_Modules m "); sqlCommand.Append("ON ce.ModuleID = m.ModuleID "); sqlCommand.Append("JOIN cy_ModuleDefinitions md "); sqlCommand.Append("ON m.ModuleDefID = md.ModuleDefID "); sqlCommand.Append("JOIN cy_PageModules pm "); sqlCommand.Append("ON m.ModuleID = pm.ModuleID "); sqlCommand.Append("JOIN cy_Pages p "); sqlCommand.Append("ON p.PageID = pm.PageID "); sqlCommand.Append("WHERE "); sqlCommand.Append("p.SiteID = :SiteID "); sqlCommand.Append("AND pm.PageID = :PageID "); //sqlCommand.Append("AND pm.PublishBeginDate < datetime('now','localtime') "); //sqlCommand.Append("AND (pm.PublishEndDate IS NULL OR pm.PublishEndDate > datetime('now','localtime')) ;"); sqlCommand.Append(" ; "); SqliteParameter[] arParams = new SqliteParameter[2]; arParams[0] = new SqliteParameter(":SiteID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = siteId; arParams[1] = new SqliteParameter(":PageID", DbType.Int32); arParams[1].Direction = ParameterDirection.Input; arParams[1].Value = pageId; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
public static IDataReader SchemaVersionGetNonCore() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_SchemaVersion "); sqlCommand.Append("WHERE "); sqlCommand.Append("ApplicationID <> '077E4857-F583-488E-836E-34A4B04BE855' "); sqlCommand.Append("ORDER BY ApplicationName "); sqlCommand.Append(";"); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null)); }
/// <summary> /// Gets an IDataReader with all tasks in the cy_TaskQueue table that have completed but not yet sent notification. /// </summary> public static IDataReader GetTasksForNotification() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_TaskQueue "); sqlCommand.Append("WHERE "); sqlCommand.Append("NotifyOnCompletion = 1 "); sqlCommand.Append("AND CompleteUTC IS NOT NULL "); sqlCommand.Append("AND NotificationSentUTC IS NULL "); sqlCommand.Append(";"); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null)); }
/// <summary> /// Gets an DataTable with rows from the cy_IndexingQueue table with the passed path. /// </summary> public static DataTable GetByPath(string indexPath) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_IndexingQueue "); sqlCommand.Append("WHERE "); sqlCommand.Append("IndexPath = :IndexPath "); sqlCommand.Append("ORDER BY RowId "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":IndexPath", DbType.String, 255); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = indexPath; DataTable dt = new DataTable(); dt.Columns.Add("RowId", typeof(int)); dt.Columns.Add("IndexPath", typeof(String)); dt.Columns.Add("SerializedItem", typeof(String)); dt.Columns.Add("ItemKey", typeof(String)); dt.Columns.Add("RemoveOnly", typeof(bool)); using (IDataReader reader = SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)) { while (reader.Read()) { DataRow row = dt.NewRow(); row["RowId"] = reader["RowId"]; row["IndexPath"] = reader["IndexPath"]; row["SerializedItem"] = reader["SerializedItem"]; row["ItemKey"] = reader["ItemKey"]; row["RemoveOnly"] = Convert.ToBoolean(reader["RemoveOnly"]); dt.Rows.Add(row); } } return(dt); }
public static IDataReader GetById(int roleId) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_Roles "); sqlCommand.Append("WHERE RoleID = :RoleID ; "); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":RoleID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = roleId; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
public static IDataReader GetHtmlContent(int moduleId, int itemId) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_HtmlContent "); sqlCommand.Append("WHERE ItemID = :ItemID ;"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":ItemID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = itemId; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
public static DataTable GetModuleDefinitionsBySite(int siteId) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT md.* "); sqlCommand.Append("FROM cy_ModuleDefinitions md "); sqlCommand.Append("JOIN cy_SiteModuleDefinitions smd "); sqlCommand.Append("ON md.ModuleDefID = smd.ModuleDefID "); sqlCommand.Append("WHERE smd.SiteID = :SiteID "); sqlCommand.Append("ORDER BY md.SortOrder, md.FeatureName ;"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":SiteID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = siteId; DataTable dt = new DataTable(); dt.Columns.Add("ModuleDefID", typeof(int)); dt.Columns.Add("FeatureName", typeof(String)); dt.Columns.Add("ControlSrc", typeof(String)); using (IDataReader reader = SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)) { while (reader.Read()) { DataRow row = dt.NewRow(); row["ModuleDefID"] = reader["ModuleDefID"]; row["FeatureName"] = reader["FeatureName"]; row["ControlSrc"] = reader["ControlSrc"]; dt.Rows.Add(row); } } return(dt); }
public static IDataReader GetHistoryFile(int id) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_SharedFilesHistory "); sqlCommand.Append("WHERE "); sqlCommand.Append("ID = :ID ;"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":ID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = id; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with rows from the cy_BannedIPAddresses table. /// </summary> /// <param name="ipAddress"> ipAddress </param> public static IDataReader GeByIpAddress(string ipAddress) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_BannedIPAddresses "); sqlCommand.Append("WHERE "); sqlCommand.Append("BannedIP = :BannedIP ;"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":BannedIP", DbType.String, 50); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = ipAddress; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with all rows in the cy_LetterSendLog table. /// </summary> public static IDataReader GetByLetter(Guid letterGuid) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_LetterSendLog "); sqlCommand.Append("WHERE "); sqlCommand.Append("LetterGuid = :LetterGuid ;"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":LetterGuid", DbType.String, 36); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = letterGuid.ToString(); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
public static IDataReader GetUserPage(Guid userPageId) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_UserPages "); sqlCommand.Append("WHERE "); sqlCommand.Append("UserPageID = :UserPageID ;"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":UserPageID", DbType.String, 36); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = userPageId.ToString(); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with one row from the cy_ContentRating table. /// </summary> /// <param name="rowGuid"> rowGuid </param> public static IDataReader GetOne(Guid rowGuid) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_ContentRating "); sqlCommand.Append("WHERE "); sqlCommand.Append("RowGuid = :RowGuid "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":RowGuid", DbType.String, 36); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = rowGuid.ToString(); return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with one row from the cy_SavedQuery table. /// </summary> /// <param name="name"> name </param> public static IDataReader GetOne(string name) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_SavedQuery "); sqlCommand.Append("WHERE "); sqlCommand.Append("Name = :Name "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":Name", DbType.String, 36); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = name; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
public static IDataReader GetLinks(int moduleId) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_Links "); sqlCommand.Append("WHERE ModuleID = :ModuleID "); sqlCommand.Append("ORDER BY ViewOrder, Title ;"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":ModuleID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = moduleId; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with rows from the cy_EmailSendQueue table where DateToSend >= CurrentTime. /// </summary> /// <param name="currentTime"> currentTime </param> public static IDataReader GetEmailToSend(DateTime currentTime) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_EmailSendQueue "); sqlCommand.Append("WHERE "); sqlCommand.Append("DateToSend >= :CurrentTime "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":CurrentTime", DbType.DateTime); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = currentTime; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }
/// <summary> /// Gets an IDataReader with one row from the cy_GeoCountry table. /// </summary> /// <param name="countryISOCode2"> countryISOCode2 </param> public static IDataReader GetByISOCode2(string countryISOCode2) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT * "); sqlCommand.Append("FROM cy_GeoCountry "); sqlCommand.Append("WHERE "); sqlCommand.Append("ISOCode2 = :ISOCode2 "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":ISOCode2", DbType.String, 2); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = countryISOCode2; return(SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), arParams)); }