protected void Page_Load(object sender, EventArgs e)
{
DatabaseUpdate du = new DatabaseUpdate();
if (!string.IsNullOrEmpty(Request.QueryString["signout"])) {
FormsAuthentication.SignOut();
}
List<DatabaseUpdateMessage> lst = new List<DatabaseUpdateMessage>();
btnLogin.Visible = false;
btnCreate.Visible = false;
if (DatabaseUpdate.LastSQLError != null) {
du.HandleResponse(lst, DatabaseUpdate.LastSQLError);
DatabaseUpdate.LastSQLError = null;
} else {
bool bUpdate = true;
if (!du.DoCMSTablesExist()) {
bUpdate = false;
}
bUpdate = du.DatabaseNeedsUpdate();
if (bUpdate) {
DatabaseUpdateStatus status = du.PerformUpdates();
lst = du.MergeMessages(lst, status.Messages);
} else {
DataInfo ver = DatabaseUpdate.GetDbSchemaVersion();
du.HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
bUpdate = du.DatabaseNeedsUpdate();
if (!bUpdate && DatabaseUpdate.LastSQLError == null) {
if (du.UsersExist) {
btnLogin.Visible = true;
} else {
btnCreate.Visible = true;
}
}
}
if (DatabaseUpdate.LastSQLError != null) {
du.HandleResponse(lst, DatabaseUpdate.LastSQLError);
}
if (lst.Where(x => !string.IsNullOrEmpty(x.ExceptionText)).Count() > 0) {
bOK = false;
} else {
bOK = true;
}
GeneralUtilities.BindRepeater(rpMessages, lst.OrderBy(x => x.Order));
using (CMSConfigHelper cmsHelper = new CMSConfigHelper()) {
cmsHelper.ResetConfigs();
}
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
DatabaseUpdate du = new DatabaseUpdate();
if (du.UsersExist) {
createWizard.Visible = false;
lblLogon.Visible = true;
} else {
createWizard.Visible = true;
lblLogon.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
DatabaseUpdate du = new DatabaseUpdate();
divMsg.Visible = false;
lnkForgot.HRef = SiteFilename.ForgotPasswordURL;
if (DatabaseUpdate.FailedSQL || du.DatabaseNeedsUpdate() || !du.UsersExist) {
FormsAuthentication.SignOut();
Response.Redirect(SiteFilename.DatabaseSetupURL);
}
if (Page.User.Identity.IsAuthenticated) {
Response.Redirect(SiteFilename.DashboardURL);
}
}
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 DatabaseSetup(string signout) {
DatabaseSetupModel model = new DatabaseSetupModel();
DatabaseUpdate du = new DatabaseUpdate(true);
if (!String.IsNullOrEmpty(signout)) {
SignOut();
}
List<DatabaseUpdateMessage> lst = new List<DatabaseUpdateMessage>();
model.Messages = lst;
if (DatabaseUpdate.LastSQLError != null) {
du.HandleResponse(lst, DatabaseUpdate.LastSQLError);
DatabaseUpdate.LastSQLError = null;
} else {
bool bUpdate = true;
if (!du.DoCMSTablesExist()) {
bUpdate = false;
}
bUpdate = du.DatabaseNeedsUpdate();
try {
model.CreateUser = !DatabaseUpdate.UsersExist;
} catch { }
if (bUpdate) {
DatabaseUpdateStatus status = du.PerformUpdates();
lst = du.MergeMessages(lst, status.Messages);
} else {
DataInfo ver = DatabaseUpdate.GetDbSchemaVersion();
du.HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
bUpdate = du.DatabaseNeedsUpdate();
if (!bUpdate && DatabaseUpdate.LastSQLError == null) {
model.CreateUser = !DatabaseUpdate.UsersExist;
}
}
if (DatabaseUpdate.LastSQLError != null) {
du.HandleResponse(lst, DatabaseUpdate.LastSQLError);
}
model.HasExceptions = lst.Where(x => !String.IsNullOrEmpty(x.ExceptionText)).Any();
model.Messages = lst;
using (CMSConfigHelper cmsHelper = new CMSConfigHelper()) {
cmsHelper.ResetConfigs();
}
return View(model);
}
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 ActionResult CreateFirstAdmin(RegisterViewModel model) {
DatabaseUpdate du = new DatabaseUpdate();
if (du.UsersExist) {
return RedirectToLocal("Index");
}
if (ModelState.IsValid) {
SecurityData sd = new SecurityData();
ApplicationUser user = new ApplicationUser { UserName = model.UserName, Email = model.Email };
ExtendedUserData exUser = null;
var result = sd.CreateApplicationUser(user, model.Password, out exUser);
if (result.Succeeded) {
SecurityData.AddUserToRole(model.UserName, SecurityData.CMSGroup_Admins);
SecurityData.AddUserToRole(model.UserName, SecurityData.CMSGroup_Users);
return RedirectToAction("Index");
}
AddErrors(result);
}
Helper.HandleErrorDict(ModelState);
return View(model);
}
public ActionResult CreateFirstAdmin(string returnUrl) {
securityHelper.AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
DatabaseUpdate du = new DatabaseUpdate();
if (du.UsersExist) {
return RedirectToLocal("Index");
}
RegisterViewModel model = new RegisterViewModel();
return View(model);
}
