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 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));
}
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 />";
}
}
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 />";
}
}
/// <summary>
/// Given a <see cref="DatabaseUpdateResponse"/> this will create and return a <see cref="Database"/>
/// object with the fields filled in.
/// </summary>
/// <param name="response">The response to turn into a <see cref="Database"/></param>
/// <returns>a <see cref="Database"/> object.</returns>
private Database CreateDatabaseFromResponse(DatabaseUpdateResponse response)
{
return(this.CreateDatabaseFromResponse(
response.Id,
response.Name,
response.CreationDate,
response.Edition,
response.CollationName,
response.MaximumDatabaseSizeInGB,
response.IsFederationRoot,
response.IsSystemObject,
response.SizeMB,
response.ServiceObjectiveAssignmentErrorCode,
response.ServiceObjectiveAssignmentErrorDescription,
response.ServiceObjectiveAssignmentState,
response.ServiceObjectiveAssignmentStateDescription,
response.ServiceObjectiveAssignmentSuccessDate,
response.ServiceObjectiveId));
}
/// <summary>
/// Update a database on the server.
/// </summary>
/// <param name="databaseName">The name of the database to modify.</param>
/// <param name="newDatabaseName">The new name of the database.</param>
/// <param name="databaseMaxSizeInGB">The new maximum size of the database.</param>
/// <param name="databaseEdition">The new edition of the database.</param>
/// <param name="serviceObjective">The new service objective of the database.</param>
/// <returns>The updated database.</returns>
public Database UpdateDatabase(
string databaseName,
string newDatabaseName,
int?databaseMaxSizeInGB,
DatabaseEdition?databaseEdition,
ServiceObjective serviceObjective)
{
this.clientRequestId = SqlDatabaseCmdletBase.GenerateClientTracingId();
// Get the SQL management client
SqlManagementClient sqlManagementClient = this.subscription.CreateClient <SqlManagementClient>();
this.AddTracingHeaders(sqlManagementClient);
// Retrieve the specified database
DatabaseGetResponse database = sqlManagementClient.Databases.Get(
this.serverName,
databaseName);
// Update the database with the new properties
DatabaseUpdateResponse response = sqlManagementClient.Databases.Update(
this.serverName,
databaseName,
new DatabaseUpdateParameters()
{
Id = database.Id,
Name = !string.IsNullOrEmpty(newDatabaseName) ?
newDatabaseName : database.Name,
Edition = databaseEdition.HasValue && (databaseEdition != DatabaseEdition.None) ?
databaseEdition.ToString() : (database.Edition ?? string.Empty),
CollationName = database.CollationName ?? string.Empty,
MaximumDatabaseSizeInGB = databaseMaxSizeInGB.HasValue ?
databaseMaxSizeInGB.Value : database.MaximumDatabaseSizeInGB,
ServiceObjectiveId = serviceObjective != null ?
serviceObjective.Id.ToString() : null,
});
// Construct the resulting Database object
Database updatedDatabase = CreateDatabaseFromResponse(response);
return(updatedDatabase);
}
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 />";
}
}
