public void TestWipeDataDatabase2Ok()
{
//SETUP
var options = this.CreateUniqueMethodOptions <DbContext2>();
using (var context = new DbContext2(options))
{
context.Database.EnsureCreated();
context.Add(new TopClass2 {
Dependents = new List <Dependent2> {
new Dependent2()
}
});
context.SaveChanges();
context.TopClasses.Count().ShouldEqual(1);
context.Dependents.Count().ShouldEqual(1);
//ATTEMPT
context.Database.EnsureClean();
//VERIFY
context.TopClasses.Count().ShouldEqual(0);
context.Dependents.Count().ShouldEqual(0);
}
}
public void TestEnsureDeletedThenCreateDatabase2Ok()
{
//SETUP
var showLog = false;
#pragma warning disable 618
var options = this.CreateUniqueClassOptionsWithLogging <DbContext2>(log =>
#pragma warning restore 618
{
if (showLog)
{
_output.WriteLine(log.Message);
}
});
using (var context = new DbContext2(options))
{
context.Database.EnsureDeleted();
//ATTEMPT
showLog = true;
context.Database.EnsureClean();
showLog = false;
//VERIFY
context.Add(new TopClass2());
context.SaveChanges();
}
}
public static Users GetByEmail(string email)
{
using (var db = new DbContext2())
{
return(db.Users.FirstOrDefault(u => u.Email == email));
}
}
public void TestDatabase1SchemaChangeToDatabase2Ok()
{
//SETUP
var connectionString = this.GetUniqueDatabaseConnectionString();
var builder1 = new DbContextOptionsBuilder <DbContext1>();
using (var context = new DbContext1(builder1.UseSqlServer(connectionString).Options))
using (new TimeThings(_output, "EnsureDeleted/EnsureCreated"))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
}
var builder2 = new DbContextOptionsBuilder <DbContext2>();
using (var context = new DbContext2(builder2.UseSqlServer(connectionString).Options))
{
//ATTEMPT
using (new TimeThings(_output, "EnsureClean"))
{
context.Database.EnsureClean();
}
//VERIFY
context.Add(new TopClass2());
context.SaveChanges();
}
}
public static int GetItemCount(int id)
{
using (var db = new DbContext2())
{
return(db.Items.Count(i => i.CategoryId == id));
}
}
public static Users GetByEmailAndPassword(string email, string password)
{
using (var db = new DbContext2())
{
return(db.Users.FirstOrDefault(u => u.Email == email && u.Password == password));
}
}
public static Categories Get(int id)
{
using (var db = new DbContext2())
{
return(db.Categories.FirstOrDefault(c => c.Id == id));
}
}
public static void Delete(int id)
{
using (var db = new DbContext2())
{
db.Items.Remove(db.Items.Find(id));
db.SaveChanges();
}
}
public static List <Items> GetByCategory(int id)
{
// TODO: realizēt atlasi no DB
using (var db = new DbContext2())
{
//no datubāzes datiem uztaisa List, kas kārtots pēc vārda
return(db.Items.Where(c => c.CategoryId == id).OrderBy(i => i.Price).ToList());
}
}
public static List <Items> GetAll()
{
// TODO: realizēt atlasi no DB
using (var db = new DbContext2())
{
//no datubāzes datiem uztaisa List, kas kārtots pēc vārda
return(db.Items.OrderBy(i => i.CategoryId).ToList());
}
}
public static List <Categories> GetAll()
{
// TODO: realizēt atlasi no DB
using (var db = new DbContext2())
{
//no datubāzes datiem uztaisa List, kas kārtots pēc vārda
return(db.Categories.OrderBy(u => u.Name).ToList());
}
//throw new NotImplementedException();
}
public static void CreateCat(string name, int?parentId)
{
using (var db = new DbContext2())
{
db.Categories.Add(new Categories()
{
Name = name,
ParentId = parentId,
});
db.SaveChanges();
}
}
public static void Create(string name, string email, string password)
{
using (var db = new DbContext2())
{
db.Users.Add(new Users()
{
Email = email,
Name = name,
Password = password,
});
db.SaveChanges();
}
}
public static void Create(string name, string description, string image, int categoryId, decimal price)
{
using (var db = new DbContext2())
{
db.Items.Add(new Items()
{
Name = name,
Description = description,
CategoryId = categoryId,
Image = image,
Price = price,
});
db.SaveChanges();
}
}
public ICollection <Sugerencia> ObtenerSugerencias()
{
try
{
using (var context = new DbContext2())
{
ICollection <Sugerencia> sugerencias = new List <Sugerencia>();
var entidades = context.Sugerencias.ToList();
foreach (var x in entidades)
{
sugerencias.Add(SugerenciaMapper.MapModel(x));
}
return(sugerencias);
}
}
catch (Exception e)
{
throw e;
}
}
public Sugerencia ObtenerSugerencia(int SugerenciaId)
{
try
{
using (var context = new DbContext2())
{
SugerenciaEntity entidad = context.Sugerencias.Find(SugerenciaId);
ICollection <PrendasSugerenciaEntity> prendas = context.PrendasSugerencia.Where(s => s.SugerenciaId == SugerenciaId).ToList();
Sugerencia sugerencia = SugerenciaMapper.MapModel(entidad);
PrendasRepositorio repo = new PrendasRepositorio();
foreach (var x in prendas)
{
sugerencia.Atuendo.Prendas.Add(repo.GetPrenda(x.PrendaId));
}
return(sugerencia);
}
}
catch (Exception e)
{
throw e;
}
}
public void CrearSugerencia(Sugerencia sugerencia)
{
try
{
using (var context = new DbContext2())
{
SugerenciaEntity entidad = SugerenciaMapper.MapEntity(sugerencia);
context.Sugerencias.Add(entidad);
foreach (var x in sugerencia.Atuendo.Prendas)
{
context.PrendasSugerencia.Add(new PrendasSugerenciaEntity()
{
SugerenciaId = sugerencia.SugerenciaId, PrendaId = x.PrendaId
});
}
context.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
public GuardarropaRepositorio()
{
_dbContext = new DbContext2();
}
public UsuarioRepositorio()
{
_dbContext = new DbContext2();
}
public EventosRepositorio()
{
_dbContext = new DbContext2();
}
public void DBTest()
{
using (var context = new DbContext2())
{
GuardarropaRepositorio repo = new GuardarropaRepositorio();
PrendasRepositorio repoPrenda = new PrendasRepositorio();
ICollection <Prenda> prendas = new List <Prenda>();
Prenda prenda = new Prenda()
{
Categoria = Categoria.Piernas,
ColorPrimario = Color.Azul,
GuardarropaId = 1,
Tela = Tela.Cuero,
PrendaId = 1,
Tipo = new TipoDePrenda()
{
Formalidad = Formalidad.Formal,
Nivel = 1,
Posicion = 2,
Temperatura = 10
}
};
prendas.Add(prenda);
Guardarropa guardarropa = new Guardarropa()
{
GuardarropaId = 1,
PrendasMaximas = 100,
Usuarios = { 1, 2, 3, 4, 5 },
Prendas = prendas
};
repo.CrearGuardarropa(guardarropa);
var Prenda = repoPrenda.GetPrenda(1);
//UsuarioRepositorio repo = new UsuarioRepositorio();
//Usuario usuario = new Usuario()
//{
// UsuarioId = 5,
// Username = "******",
// Password = "******",
// Mail = "asd",
// TipoUsuario = new Gratuito(),
// Sensibilidad = new Normal()
//};
// repo.CrearUsuario(usuario);
//Usuario user2 = repo.ObtenerUsuario(5);
//repo.EliminarUsuario(5);
//Evento evento = new Evento()
//{
// EventoId = 1,
// FechaInicio = DateTime.Now,
// Formalidad = Formalidad.Formal,
// Frecuencia = new Frecuencia(7),
// Nombre = "resistance",
// Ubicacion = new Ubicacion() { Latitud = "asd", Longitud = "asd" },
// UsuarioId = 1
//};
// EventosRepositorio eventos = new EventosRepositorio();
//eventos.CrearEvento(evento); //CREAR EVENTO
//evento = eventos.GetEvento(1); //OBTENER EVNTO
//eventos.DeleteEvento(1); //ELIMINAR EVENTO
}
}
public PrendasRepositorio()
{
this.dbContext = new DbContext2();
}
public UserContext(DbContext1 context1, DbContext2 context2)
{
DbContext1 = context1;
DbContext2 = context2;
}
public DonkeyController()
{
this.dbCon = new DbContext2();
}
