Exemple #1
0
        public Usuario CrearUsuario(Usuario Usuario)
        {
            UsuarioEntity           entidad             = UsuarioMapper.MapEntity(Usuario);
            SensibilidadLocalEntity sensibilidadEntidad = SensibilidadLocalMapper.MapEntity(Usuario.Sensibilidad);

            sensibilidadEntidad.UsuarioId = Usuario.UsuarioId;
            _dbContext.Usuarios.Add(entidad);
            _dbContext.SensibilidadLocal.Add(sensibilidadEntidad);
            _dbContext.SaveChanges();

            return(Usuario);
        }
        //public PrendasRepositorio(QueMePongoDbContext dbContext)
        //{
        //    this.dbContext = dbContext;
        //}

        public void AddPrenda(Prenda prenda)
        {
            try
            {
                var entidad = PrendaMapper.MapEntity(prenda);
                dbContext.Prendas.Add(entidad);
                dbContext.SaveChanges();
            }catch (Exception e)
            {
                throw e;
            }
        }
Exemple #3
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();
            }
        }
Exemple #4
0
        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();
            }
        }
Exemple #5
0
        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 Evento CrearEvento(Evento evento)
        {
            try
            {
                EventoEntity entidad = EventoMapper.MapEntity(evento);
                _dbContext.Eventos.Add(entidad);

                _dbContext.SaveChanges();

                return(evento);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
 public static void Delete(int id)
 {
     using (var db = new DbContext2())
     {
         db.Items.Remove(db.Items.Find(id));
         db.SaveChanges();
     }
 }
Exemple #8
0
 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 Guardarropa CrearGuardarropa(Guardarropa guardarropa)
 {
     try
     {
         GuardarropaEntity entidad = GuardarropaMapper.MapEntity(guardarropa);
         _dbContext.Guardarropas.Add(entidad);
         _dbContext.SaveChanges();
         PrendasRepositorio repo = new PrendasRepositorio();
         foreach (var x in guardarropa.Prendas)
         {
             repo.AddPrenda(x);
         }
         foreach (var x in guardarropa.Usuarios)
         {
             AgregarGuardarropa(x, guardarropa.GuardarropaId);
         }
         return(guardarropa);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 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();
     }
 }
Exemple #12
0
 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;
     }
 }