public static void DatabaseHelperDoVersion2320PostUpgradeTasks(
String overrideConnectionInfo)
{
string connectionString;
if (
(overrideConnectionInfo != null) &&
(overrideConnectionInfo.Length > 0)
)
{
connectionString = overrideConnectionInfo;
}
else
{
connectionString = GetConnectionString();
}
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT ");
sqlCommand.Append("u.SiteGuid, ");
sqlCommand.Append("ls.LetterInfoGuid, ");
sqlCommand.Append("ls.UserGuid, ");
sqlCommand.Append("u.Email, ");
sqlCommand.Append("ls.BeginUTC, ");
sqlCommand.Append("ls.UseHtml ");
sqlCommand.Append("FROM ");
sqlCommand.Append("cy_LetterSubscriber ls ");
sqlCommand.Append("JOIN ");
sqlCommand.Append("cy_Users u ");
sqlCommand.Append("ON ");
sqlCommand.Append("u.UserGuid = ls.UserGuid ");
sqlCommand.Append(" ; ");
DataSet ds = SqliteHelper.ExecuteDataset(
connectionString,
sqlCommand.ToString());
DataTable dataTable = ds.Tables[0];
foreach (DataRow row in dataTable.Rows)
{
DBLetterSubscription.Create(
Guid.NewGuid(),
new Guid(row["SiteGuid"].ToString()),
new Guid(row["LetterInfoGuid"].ToString()),
new Guid(row["UserGuid"].ToString()),
row["Email"].ToString().ToLower(),
true,
new Guid("00000000-0000-0000-0000-000000000000"),
Convert.ToDateTime(row["BeginUTC"]),
Convert.ToBoolean(row["UseHtml"])
);
}
}
public static DataTable DatabaseHelperGetTable(
String connectionString,
String tableName,
String whereClause)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM " + tableName + " ");
sqlCommand.Append(whereClause);
sqlCommand.Append(" ; ");
DataSet ds = SqliteHelper.ExecuteDataset(
connectionString,
sqlCommand.ToString());
return(ds.Tables[0]);
}
public static DataSet GetEvents(
int moduleId,
DateTime beginDate,
DateTime endDate)
{
StringBuilder sqlCommand = new StringBuilder();
SqliteParameter[] arParams = new SqliteParameter[3];
arParams[0] = new SqliteParameter(":ModuleID", DbType.Int32);
arParams[1] = new SqliteParameter(":BeginDate", DbType.DateTime);
arParams[2] = new SqliteParameter(":EndDate", DbType.DateTime);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = moduleId;
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM cy_CalendarEvents ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("ModuleID = :ModuleID ");
sqlCommand.Append("AND EventDate >= :BeginDate ");
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = beginDate;
sqlCommand.Append("AND EventDate <= :EndDate ");
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = endDate;
sqlCommand.Append(" ;");
return(SqliteHelper.ExecuteDataset(
GetConnectionString(),
sqlCommand.ToString(),
arParams));
}
