public ActionResult ConnectionString(ConnectionStringStepModel model)
{
if (!this.IsSetupState())
{
return(this.Redirect("/"));
}
if (!this.ModelState.IsValid)
{
return(this.View(model));
}
string connectionString = model.ConnectionString.Trim().TrimEnd(';') + "; Connection Timeout = 2";
try
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
connection.Close();
}
catch (Exception e)
{
this.ModelState.AddModelError("ConnectionString", e.Message);
return(this.View(model));
}
Configuration configuration = WebConfigurationManager.OpenWebConfiguration("~");
ConnectionStringsSection section = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
section.ConnectionStrings["AspNetDeployEntities"].ConnectionString = ConfigurationManager.ConnectionStrings["AspNetDeployEntitiesTemplate"].ConnectionString.Replace("{connectionString}", model.ConnectionString.Trim().TrimEnd(';'));
section.ConnectionStrings["AspNetDeployEntitiesClean"].ConnectionString = model.ConnectionString.Trim();
configuration.Save();
return(this.RedirectToAction("DatabaseStructure"));
}
public ActionResult ConnectionString()
{
if (!this.IsSetupState())
{
return(this.Redirect("/"));
}
ConnectionStringStepModel model = new ConnectionStringStepModel()
{
ConnectionString = ConfigurationManager.ConnectionStrings["AspNetDeployEntitiesClean"].ConnectionString
};
Configuration configuration = WebConfigurationManager.OpenWebConfiguration("~");
configuration.AppSettings.Settings["Settings.SetupState"].Value = "ConnectionString";
configuration.Save();
return(this.View(model));
}
