protected BaseDataProviderManager(DataSettings settings)
{
if (settings == null)
throw new ArgumentNullException("settings");
Settings = settings;
}
protected virtual string ComposeSettings(DataSettings settings)
{
if (settings == null)
return "";
return string.Format("DataProvider: {0}{2}DataConnectionString: {1}{2}",
settings.DataProvider,
settings.DataConnectionString,
Environment.NewLine);
}
protected virtual DataSettings ParseSettings(string text)
{
var shellSettings = new DataSettings();
if (String.IsNullOrEmpty(text))
return shellSettings;
//Manera antigua de lectura. Esto permite un inesperado comportamiento cuando los usuarios de FTP transfieren archivos como ASCII (\r\n becomes \n)
//var settings = text.Split(new[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
var settings = new List<string>();
using (var reader = new StringReader(text))
{
string str;
while ((str = reader.ReadLine()) != null)
settings.Add(str);
}
foreach (var setting in settings)
{
var separatorIndex = setting.IndexOf(SEPARATOR);
if (separatorIndex == -1)
{
continue;
}
var key = setting.Substring(0, separatorIndex).Trim();
var value = setting.Substring(separatorIndex + 1).Trim();
switch (key)
{
case "DataProvider":
shellSettings.DataProvider = value;
break;
case "DataConnectionString":
shellSettings.DataConnectionString = value;
break;
default:
shellSettings.RawDataSettings.Add(key, value);
break;
}
}
return shellSettings;
}
public EfDataProviderManager(DataSettings settings)
: base(settings)
{
}
public virtual void SaveSettings(DataSettings settings)
{
if (settings == null)
throw new ArgumentNullException("settings");
//use webHelper.MapPath instead of HostingEnvironment.MapPath which is not available in unit tests
var filePath = Path.Combine(MapPath("~/App_Data/"), FILENAME);
if (!File.Exists(filePath))
{
using (File.Create(filePath))
{
//Se usa 'using' para cerrar el archivo despues de haberse creado
}
}
var text = ComposeSettings(settings);
File.WriteAllText(filePath, text);
}
public ActionResult Index(InstallModel model)
{
if (DataSettingsHelper.DatabaseIsInstalled())
return RedirectToRoute("HomePage");
//Establece el tiempo de espera a 5 minutos
Server.ScriptTimeout = 300;
if (model.DatabaseConnectionString != null)
model.DatabaseConnectionString = model.DatabaseConnectionString.Trim();
model.DisableSqlCompact =
!String.IsNullOrEmpty(ConfigurationManager.AppSettings["UseFastInstallationService"]) &&
Convert.ToBoolean(ConfigurationManager.AppSettings["UseFastInstallationService"]);
model.DisableSampleDataOption =
!String.IsNullOrEmpty(ConfigurationManager.AppSettings["DisableSampleDataDuringInstallation"]) &&
Convert.ToBoolean(ConfigurationManager.AppSettings["DisableSampleDataDuringInstallation"]);
//SQL Server
if (model.DataProvider.Equals("sqlserver", StringComparison.InvariantCultureIgnoreCase))
{
if (model.SqlConnectionInfo.Equals("sqlconnectioninfo_raw", StringComparison.InvariantCultureIgnoreCase))
{
//raw connection string
if (string.IsNullOrEmpty(model.DatabaseConnectionString))
ModelState.AddModelError("", "Una cadena de conexión SQL se requiere");
try
{
//try to create connection string
new SqlConnectionStringBuilder(model.DatabaseConnectionString);
}
catch
{
ModelState.AddModelError("", "Mala conexión de SQL cadena de formato");
}
}
else
{
//Valores
if (string.IsNullOrEmpty(model.SqlServerName))
ModelState.AddModelError("", "Nombre de SQL Server se requiere");
if (string.IsNullOrEmpty(model.SqlDatabaseName))
ModelState.AddModelError("", "Nombre de la base de datos se requiere");
//Tipo de autenticacion
if (model.SqlAuthenticationType.Equals("sqlauthentication", StringComparison.InvariantCultureIgnoreCase))
{
//Autenticacion de SQL
if (string.IsNullOrEmpty(model.SqlServerUsername))
ModelState.AddModelError("", "Nombre de usuario SQL es necesario");
if (string.IsNullOrEmpty(model.SqlServerPassword))
ModelState.AddModelError("", "SQL Contraseña del es necesario");
}
}
}
//Consider granting access rights to the resource to the ASP.NET request identity.
//ASP.NET has a base process identity
//(typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6 and IIS 7,
//and the configured application pool identity on IIS 7.5) that is used if the application is not impersonating.
//If the application is impersonating via <identity impersonate="true"/>,
//the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
var webHelper = EngineContext.Current.Resolve<IWebHelper>();
//Validar permisos
var dirsToCheck = FilePermissionHelper.GetDirectoriesWrite(webHelper);
foreach (var dir in dirsToCheck)
if (!FilePermissionHelper.CheckPermissions(dir, false, true, true, false))
ModelState.AddModelError("", string.Format("El '{0}' cuenta no se concede permiso para modificar la carpeta '{1}'. Por favor, configurar estos permisos", WindowsIdentity.GetCurrent().Name, dir));
var filesToCheck = FilePermissionHelper.GetFilesWrite(webHelper);
foreach (var file in filesToCheck)
if (!FilePermissionHelper.CheckPermissions(file, false, true, true, true))
ModelState.AddModelError("", string.Format("El '{0}' cuenta no se concede permiso para modificar el archivo '{1}'. Por favor, configurar estos permisos", WindowsIdentity.GetCurrent().Name, file));
if (ModelState.IsValid)
{
var settingsManager = new DataSettingsManager();
try
{
string connectionString;
if (model.DataProvider.Equals("sqlserver", StringComparison.InvariantCultureIgnoreCase))
{
//SQL Server
if (model.SqlConnectionInfo.Equals("sqlconnectioninfo_raw", StringComparison.InvariantCultureIgnoreCase))
{
//Cadena de conexion en bruto
//Sabemos que la opcion MARS es requerida cuando se usa entity framework
//nos aseguraremos que este especificada
var sqlCsb = new SqlConnectionStringBuilder(model.DatabaseConnectionString);
if (UseMars)
{
sqlCsb.MultipleActiveResultSets = true;
}
connectionString = sqlCsb.ToString();
}
else
{
//values
connectionString = CreateConnectionString(model.SqlAuthenticationType == "windowsauthentication",
model.SqlServerName, model.SqlDatabaseName,
model.SqlServerUsername, model.SqlServerPassword);
}
if (model.SqlServerCreateDatabase)
{
if (!SqlServerDatabaseExists(connectionString))
{
//create database
var collation = model.UseCustomCollation ? model.Collation : "";
var errorCreatingDatabase = CreateDatabase(connectionString, collation);
if (!String.IsNullOrEmpty(errorCreatingDatabase))
throw new Exception(errorCreatingDatabase);
//La base de datos no ha podido ser creada.
//RARO! Parece ser un tema de Entity Framework
//Esperamos 10 segundos
Thread.Sleep(10000);
}
}
else
{
//Verificamos que la base de datos exista
if (!SqlServerDatabaseExists(connectionString))
throw new Exception("Base de datos no existe o no tiene permisos para conectarse a ella");
}
}
else
{
//SQL CE
const string DATABASE_FILE_NAME = "ViccosLite.Db.sdf";
const string DATABASE_PATH = @"|DataDirectory|\" + DATABASE_FILE_NAME;
connectionString = "Data Source=" + DATABASE_PATH + ";Persist Security Info=False";
//drop database if exists
var databaseFullPath = HostingEnvironment.MapPath("~/App_Data/") + DATABASE_FILE_NAME;
if (System.IO.File.Exists(databaseFullPath))
{
System.IO.File.Delete(databaseFullPath);
}
}
//save settings
var dataProvider = model.DataProvider;
var settings = new DataSettings
{
DataProvider = dataProvider,
DataConnectionString = connectionString
};
settingsManager.SaveSettings(settings);
//Inicia proveedor de la Data
var dataProviderInstance = EngineContext.Current.Resolve<BaseDataProviderManager>().LoadDataProvider();
dataProviderInstance.InitDatabase();
//Resolvemos el servicio de instalacion
var installationService = EngineContext.Current.Resolve<IInstallationService>();
installationService.InstallData(model.AdminEmail, model.AdminPassword, model.InstallSampleData);
//Reseteamos la cache
DataSettingsHelper.ResetCache();
//Registro de los permisos por default
var permissionProviders = new List<Type>();
permissionProviders.Add(typeof(StandardPermissionProvider));
foreach (var providerType in permissionProviders)
{
dynamic provider = Activator.CreateInstance(providerType);
EngineContext.Current.Resolve<IPermissionService>().InstallPermissions(provider);
}
//Reinicia la aplicacion
webHelper.RestartAppDomain();
//Redireccion a Home
return RedirectToRoute("HomePage");
}
catch (Exception exception)
{
//reset cache
DataSettingsHelper.ResetCache();
//clear provider settings if something got wrong
settingsManager.SaveSettings(new DataSettings
{
DataProvider = null,
DataConnectionString = null
});
ModelState.AddModelError("",
string.Format("Error de instalación: {0}", exception.Message));
}
}
return View(model);
}