public DatabaseUpdateResponse CreateCMSDatabase()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
if (!DatabaseUpdate.FailedSQL)
{
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("DoCMSTablesExist");
if (!bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.CREATE01.sql", false);
res.Response = "Created Database";
res.RanUpdate = true;
// change version key when the DB creation is rescripted
SetDbSchemaVersion(DatabaseUpdate.DbVersion12);
return(res);
}
res.Response = "Database Already Created";
return(res);
}
res.Response = "*** Database Access Failed ***";
return(res);
}
public ActionResult CalendarDatabase() {
List<string> lst = new List<string>();
DatabaseUpdate du = new DatabaseUpdate();
DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse();
string sqlUpdate = String.Empty;
string sqlTest = String.Empty;
try {
sqlUpdate = WebHelper.ReadEmbededScript("CarrotCake.CMS.Plugins.CalendarModule.tblCalendar.sql");
sqlTest = "select * from [INFORMATION_SCHEMA].[COLUMNS] where table_name in('tblCalendar')";
dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false);
if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) {
lst.Add(dbRes.LastException.Message);
} else {
lst.Add(dbRes.Response);
}
} catch (Exception ex) {
lst.Add(ex.ToString());
}
return View(lst);
}
public DatabaseUpdateResponse AlterStep01()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep01");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER01.sql", false);
res.Response = "Update comment view";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion01);
return(res);
}
else
{
// if the db version is off, check leading tidbit against current and immediate prior
DataInfo ver = GetDbSchemaVersion();
if (DatabaseUpdate.DbVersion00.Substring(0, 6) == ver.DataValue.Substring(0, 6) ||
"201510" == ver.DataValue.Substring(0, 6) || "201509" == ver.DataValue.Substring(0, 6) || "201508" == ver.DataValue.Substring(0, 6) ||
DatabaseUpdate.DbVersion01.Substring(0, 6) == ver.DataValue.Substring(0, 6))
{
SetDbSchemaVersion(DatabaseUpdate.DbVersion01);
}
}
res.Response = "Comment view update already applied";
return(res);
}
public DatabaseUpdateResponse AlterStep13()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep13");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER13.sql", false);
res.Response = "Update timezone sproc";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion13);
return(res);
}
else
{
// if the db version is off, check leading tidbit against current and immediate prior
DataInfo ver = GetDbSchemaVersion();
if (DatabaseUpdate.DbVersion12.Substring(0, 6) == ver.DataValue.Substring(0, 6))
{
SetDbSchemaVersion(DatabaseUpdate.DbVersion13);
}
}
res.Response = "Timezone sproc update already applied";
return(res);
}
public List <DatabaseUpdateMessage> HandleResponse(List <DatabaseUpdateMessage> lstMsgs, Exception ex)
{
if (lstMsgs == null)
{
lstMsgs = new List <DatabaseUpdateMessage>();
}
DatabaseUpdateResponse execMessage = new DatabaseUpdateResponse();
execMessage.LastException = ex;
execMessage.Response = "An error occurred.";
HandleResponse(lstMsgs, "Error: ", execMessage);
return(lstMsgs);
}
public DatabaseUpdateResponse ApplyUpdateIfFound(string testQuery, string updateStatement, bool bIgnore)
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
DataTable table1 = GetTestData(testQuery);
if (table1.Rows.Count > 0)
{
res.LastException = ExecScriptContents(updateStatement, bIgnore);
res.Response = "Applied update";
res.RanUpdate = true;
return(res);
}
res.Response = "Did not apply any updates";
return(res);
}
public DatabaseUpdateResponse AlterStep01()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep01");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER01.sql", false);
res.Response = "Created Content MetaKeyword and MetaDescription";
res.RanUpdate = true;
return(res);
}
res.Response = "Content MetaKeyword and MetaDescription Already Exists";
return(res);
}
public DatabaseUpdateResponse AlterStep03()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep03");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER03.sql", false);
res.Response = "RootContent CreateDate Created";
res.RanUpdate = true;
return(res);
}
res.Response = "RootContent CreateDate Already Exists";
return(res);
}
public DatabaseUpdateResponse AlterStep04()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep04");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER04.sql", false);
res.Response = "CMS Table Names Changed";
res.RanUpdate = true;
return(res);
}
res.Response = "CMS Tables Already Changed";
return(res);
}
public DatabaseUpdateResponse AlterStep06()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep06");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER06.sql", false);
res.Response = "CMS DB created carrot_ContentType, carrot_ContentTag, carrot_ContentCategory";
res.RanUpdate = true;
return(res);
}
res.Response = "CMS DB carrot_ContentType, carrot_ContentTag, carrot_ContentCategory already exist";
return(res);
}
public DatabaseUpdateResponse AlterStep07()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep07");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER07.sql", false);
res.Response = "CMS DB created cols RetireDate, GoLiveDate, and GoLiveDateLocal in carrot_RootContent";
res.RanUpdate = true;
return(res);
}
res.Response = "CMS DB cols RetireDate, GoLiveDate, and GoLiveDateLocal in carrot_RootContent already exist";
return(res);
}
public DatabaseUpdateResponse AlterStep09()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep09");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER09.sql", false);
res.Response = "CMS DB created vw_carrot_ContentChild and ShowInSiteNav";
res.RanUpdate = true;
return(res);
}
res.Response = "CMS DB vw_carrot_ContentChild and ShowInSiteNav already exist";
return(res);
}
public DatabaseUpdateResponse AlterStep10()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep10");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER10.sql", false);
res.Response = "CMS DB created TextWidget and Content Snippet, updated edit history";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion10);
return(res);
}
res.Response = "CMS DB TextWidget and Content Snippet already exist";
return(res);
}
public DatabaseUpdateResponse AlterStep12()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep12");
if (bTestResult)
{
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER12.sql", false);
res.Response = "CMS DB Updated time zone sproc and tallies";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion12);
return(res);
}
res.Response = "CMS DB time zone sproc already updated";
return(res);
}
protected void Page_Load(object sender, EventArgs e) {
DatabaseUpdate du = new DatabaseUpdate();
DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse();
string sqlUpdate = "";
string sqlTest = "";
int iCt = 0;
litMsg.Text = "";
sqlUpdate = ReadEmbededScript("Carrotware.CMS.UI.Plugins.EventCalendarModule.carrot_CalendarEvent.sql");
sqlTest = "select * from information_schema.columns where table_name = 'carrot_CalendarEventProfile' and column_name = 'RecursEvery'";
dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false);
iCt++;
if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) {
litMsg.Text += iCt.ToString() + ") " + dbRes.LastException.Message + "<br />";
} else {
litMsg.Text += iCt.ToString() + ") " + dbRes.Response + "<br />";
}
}
protected void Page_Load(object sender, EventArgs e)
{
DatabaseUpdate du = new DatabaseUpdate();
DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse();
string sqlUpdate = "";
string sqlTest = "";
int iCt = 0;
litMsg.Text = "";
sqlUpdate = ReadEmbededScript("Carrotware.CMS.UI.Plugins.FAQ2Module.carrot_FaqItem.sql");
sqlTest = "select * from [INFORMATION_SCHEMA].[COLUMNS] where table_name in('carrot_FaqItem')";
dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false);
iCt++;
if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) {
litMsg.Text += iCt.ToString() + ") " + dbRes.LastException.Message + "<br />";
} else {
litMsg.Text += iCt.ToString() + ") " + dbRes.Response + "<br />";
}
}
protected void Page_Load(object sender, EventArgs e) {
DatabaseUpdate du = new DatabaseUpdate();
DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse();
string sqlUpdate = "";
string sqlTest = "";
int iCt = 0;
litMsg.Text = "";
sqlUpdate = ReadEmbededScript("Carrotware.CMS.UI.Plugins.PhotoGallery.tblGallery.sql");
sqlTest = "select * from [information_schema].[columns] where table_name in('tblGalleryImageMeta')";
dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false);
iCt++;
if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) {
litMsg.Text += iCt.ToString() + ") " + dbRes.LastException.Message + "<br />";
} else {
litMsg.Text += iCt.ToString() + ") " + dbRes.Response + "<br />";
}
}
public ActionResult GalleryDatabase()
{
List<string> lst = new List<string>();
DatabaseUpdate du = new DatabaseUpdate();
DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse();
string sqlUpdate = "";
string sqlTest = "";
try {
sqlUpdate = GalleryHelper.ReadEmbededScript("CarrotCake.CMS.Plugins.PhotoGallery.tblGallery.sql");
sqlTest = "select * from [information_schema].[columns] where table_name in('tblGalleryImageMeta')";
dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false);
if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) {
lst.Add(dbRes.LastException.Message);
} else {
lst.Add(dbRes.Response);
}
} catch (Exception ex) {
lst.Add(ex.ToString());
}
return View(lst);
}
public DatabaseUpdateResponse AlterStep01()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep01");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER01.sql", false);
res.Response = "Created Content MetaKeyword and MetaDescription";
res.RanUpdate = true;
return res;
}
res.Response = "Content MetaKeyword and MetaDescription Already Exists";
return res;
}
public DatabaseUpdateResponse AlterStep03()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep03");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER03.sql", false);
res.Response = "RootContent CreateDate Created";
res.RanUpdate = true;
return res;
}
res.Response = "RootContent CreateDate Already Exists";
return res;
}
public DatabaseUpdateResponse AlterStep04()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep04");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER04.sql", false);
res.Response = "CMS Table Names Changed";
res.RanUpdate = true;
return res;
}
res.Response = "CMS Tables Already Changed";
return res;
}
public DatabaseUpdateResponse AlterStep06()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep06");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER06.sql", false);
res.Response = "CMS DB created carrot_ContentType, carrot_ContentTag, carrot_ContentCategory";
res.RanUpdate = true;
return res;
}
res.Response = "CMS DB carrot_ContentType, carrot_ContentTag, carrot_ContentCategory already exist";
return res;
}
public DatabaseUpdateResponse AlterStep07()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep07");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER07.sql", false);
res.Response = "CMS DB created cols RetireDate, GoLiveDate, and GoLiveDateLocal in carrot_RootContent";
res.RanUpdate = true;
return res;
}
res.Response = "CMS DB cols RetireDate, GoLiveDate, and GoLiveDateLocal in carrot_RootContent already exist";
return res;
}
public DatabaseUpdateResponse AlterStep01()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep01");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER01.sql", false);
res.Response = "Update comment view";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion01);
return res;
}
res.Response = "Comment view update already applied";
return res;
}
public DatabaseUpdateResponse AlterStep10()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep10");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER10.sql", false);
res.Response = "CMS DB created TextWidget and Content Snippet, updated edit history";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion10);
return res;
}
res.Response = "CMS DB TextWidget and Content Snippet already exist";
return res;
}
public List <DatabaseUpdateMessage> HandleResponse(List <DatabaseUpdateMessage> lstMsgs, string sMsg, DatabaseUpdateResponse execMessage)
{
if (lstMsgs == null)
{
lstMsgs = new List <DatabaseUpdateMessage>();
}
DatabaseUpdateMessage item = new DatabaseUpdateMessage();
if (!string.IsNullOrEmpty(sMsg))
{
item.Message = sMsg;
if (execMessage != null)
{
item.AlteredData = execMessage.RanUpdate;
item.Response = execMessage.Response;
if (execMessage.LastException != null && !string.IsNullOrEmpty(execMessage.LastException.Message))
{
item.HasException = true;
item.ExceptionText = execMessage.LastException.Message;
if (execMessage.LastException.InnerException != null && !string.IsNullOrEmpty(execMessage.LastException.InnerException.Message))
{
item.InnerExceptionText = execMessage.LastException.InnerException.Message;
}
}
}
}
item.Order = lstMsgs.Count + 1;
lstMsgs.Add(item);
return(lstMsgs);
}
public DatabaseUpdateResponse AlterStep11()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep11");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER11.sql", false);
res.Response = "CMS DB Updated archive tally";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion11);
return res;
}
res.Response = "CMS DB archive tally already updated";
return res;
}
public DatabaseUpdateResponse AlterStep12()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep12");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER12.sql", false);
res.Response = "CMS DB Updated time zone sproc and tallies";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion12);
return res;
}
res.Response = "CMS DB time zone sproc already updated";
return res;
}
public List<DatabaseUpdateMessage> HandleResponse(List<DatabaseUpdateMessage> lstMsgs, string sMsg, DatabaseUpdateResponse execMessage)
{
if (lstMsgs == null) {
lstMsgs = new List<DatabaseUpdateMessage>();
}
DatabaseUpdateMessage item = new DatabaseUpdateMessage();
if (!String.IsNullOrEmpty(sMsg)) {
item.Message = sMsg;
if (execMessage != null) {
item.AlteredData = execMessage.RanUpdate;
item.Response = execMessage.Response;
if (execMessage.LastException != null && !String.IsNullOrEmpty(execMessage.LastException.Message)) {
item.HasException = true;
item.ExceptionText = execMessage.LastException.Message;
if (execMessage.LastException.InnerException != null && !String.IsNullOrEmpty(execMessage.LastException.InnerException.Message)) {
item.InnerExceptionText = execMessage.LastException.InnerException.Message;
}
}
}
}
item.Order = lstMsgs.Count + 1;
lstMsgs.Add(item);
return lstMsgs;
}
public List<DatabaseUpdateMessage> HandleResponse(List<DatabaseUpdateMessage> lstMsgs, Exception ex)
{
if (lstMsgs == null) {
lstMsgs = new List<DatabaseUpdateMessage>();
}
DatabaseUpdateResponse execMessage = new DatabaseUpdateResponse();
execMessage.LastException = ex;
execMessage.Response = "An error occurred.";
HandleResponse(lstMsgs, "Error: ", execMessage);
return lstMsgs;
}
public DatabaseUpdateResponse CreateCMSDatabase()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
if (!DatabaseUpdate.FailedSQL) {
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("DoCMSTablesExist");
if (!bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.CREATE01.sql", false);
res.Response = "Created Database";
res.RanUpdate = true;
// change version key when the DB creation is re-scripted
SetDbSchemaVersion(DatabaseUpdate.DbVersion01);
return res;
}
res.Response = "Database Already Created";
return res;
}
res.Response = "*** Database Access Failed ***";
return res;
}
public DatabaseUpdateResponse AlterStep09()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep09");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER09.sql", false);
res.Response = "CMS DB created vw_carrot_ContentChild and ShowInSiteNav";
res.RanUpdate = true;
return res;
}
res.Response = "CMS DB vw_carrot_ContentChild and ShowInSiteNav already exist";
return res;
}
public DatabaseUpdateResponse ApplyUpdateIfNotFound(string testQuery, string updateStatement, bool bIgnore)
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
DataTable table1 = GetTestData(testQuery);
if (table1.Rows.Count < 1) {
res.LastException = ExecScriptContents(updateStatement, bIgnore);
res.Response = "Applied update";
res.RanUpdate = true;
return res;
}
res.Response = "Did not apply any updates";
return res;
}
public DatabaseUpdateResponse AlterStep01()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("AlterStep01");
if (bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.ALTER01.sql", false);
res.Response = "Update comment view";
res.RanUpdate = true;
SetDbSchemaVersion(DatabaseUpdate.DbVersion01);
return res;
} else {
// if the db version is off, check leading tidbit against current and immediate prior
DataInfo ver = GetDbSchemaVersion();
if (DatabaseUpdate.DbVersion00.Substring(0, 6) == ver.DataValue.Substring(0, 6)
|| "201510" == ver.DataValue.Substring(0, 6) || "201509" == ver.DataValue.Substring(0, 6) || "201508" == ver.DataValue.Substring(0, 6)
|| DatabaseUpdate.DbVersion01.Substring(0, 6) == ver.DataValue.Substring(0, 6)) {
SetDbSchemaVersion(DatabaseUpdate.DbVersion01);
}
}
res.Response = "Comment view update already applied";
return res;
}
