public string UpdateNombreInterprete()
{
var result = new StringBuilder();
var db = new BiodanzaEntities();
var list = db.tempMusicas;
foreach (var tempMusica in list)
{
var musica =
db.Musicas.FirstOrDefault(
x => x.NroCd == tempMusica.NroCd && x.NroPista == tempMusica.NroPista && x.IdColeccion == 3);
if (musica == null)
{
result.AppendLine($"{tempMusica.NroCd};{tempMusica.NroPista}");
continue;
}
var arr = tempMusica.texto.Split(';');
if (arr.Length < 4)
{
result.AppendLine($"{tempMusica.NroCd};{tempMusica.NroPista};{tempMusica.texto}");
continue;
}
musica.Nombre = arr[1].Trim();
if (arr[2].IndexOf("(") > -1)
{
arr[2] = arr[2].Substring(0, arr[2].IndexOf("(") - 1);
}
musica.Interprete = arr[2].Trim();
TimeSpan ts;
if (TimeSpan.TryParse("00:" + arr[3], out ts))
{
musica.Duracion = ts;
}
}
var musica1 = db.Musicas.First(x => x.NroCd == 15 && x.NroPista == 4 && x.IdColeccion == 3);
musica1.Nombre = "Oikan Ayns Bethlehem (Birth In Bethlehem)";
musica1.Interprete = "Christian, Emma";
musica1.Duracion = new TimeSpan(0, 5, 14);
musica1 = db.Musicas.First(x => x.NroCd == 16 && x.NroPista == 20 && x.IdColeccion == 3);
musica1.Nombre = "Andante - Sinfonia in Si bemolle Maggiore";
musica1.Interprete = "Salieri, Francesco";
musica1.Duracion = new TimeSpan(0, 3, 44);
musica1 = db.Musicas.First(x => x.NroCd == 18 && x.NroPista == 1 && x.IdColeccion == 3);
musica1.Nombre = "I wish you were here (parte 1)";
musica1.Interprete = "Pink Floyd";
musica1.Duracion = new TimeSpan(0, 3, 54);
musica1 = db.Musicas.First(x => x.NroCd == 18 && x.NroPista == 13 && x.IdColeccion == 3);
musica1.Nombre = "I wish you were here (parte 1)";
musica1.Interprete = "Pink Floyd";
musica1.Duracion = new TimeSpan(0, 3, 54);
db.SaveChanges();
return(result.ToString());
}
public string importarTodosEjercicios()
{
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandText =
@" UPDATE Ejercicios SET Observaciones = REPLACE(Observaciones,'DANZAS DE SHIVA, DE VISHNU Y DE BRAHMA','DANZAS DE SHIVA DE VISHNU Y DE BRAHMA')
where Observaciones like '%DANZAS DE SHIVA, DE VISHNU Y DE BRAHMA%'
";
cmd.CommandType = CommandType.Text;
db.Database.Connection.Open();
cmd.ExecuteNonQuery();
var ejercicios = db.Ejercicios.Where(x => x.Observaciones.StartsWith("IBF,"));
var errores = new StringBuilder();
foreach (var ejercicio in ejercicios)
{
errores.Append(importarEjercicio(ejercicio));
}
db.SaveChanges();
return(errores.ToString());
}
public string importarIBF(string path)
{
var db = new BiodanzaEntities();
db.Database.ExecuteSqlCommand("DELETE FROM Musica WHERE IdColeccion = 3");
var result = new StringBuilder();
foreach (var folder in Directory.GetDirectories(path, "IBF*"))
{
foreach (var filename in Directory.GetFiles(folder))
{
var musica = GetMusicaFromFilename(Path.GetFileName(filename));
if (musica == null)
{
result.AppendFormat("{0}; no reconocido", filename);
continue;
}
musica.Carpeta = Directory.GetParent(filename).Name;
if (db.Musicas.FirstOrDefault(x => x.NroCd == musica.NroCd && x.NroPista == musica.NroPista && x.IdColeccion == 3) != null)
{
continue;
}
db.Musicas.Add(musica);
}
}
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
var errorMessages = e.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
Console.WriteLine(errorMessages);
throw;
}
return(result.ToString());
}