public AplicationContext Create()
{
var builder = new DbContextOptionsBuilder <AplicationContext>();
if (this.useSqlite)
{
builder.UseSqlite("DataSource=:memory:", x => { });
}
else
{
// In Memory does not suport relational database
builder.UseInMemoryDatabase(Guid.NewGuid().ToString());
}
var context = new AplicationContext(builder.Options);
if (this.useSqlite)
{
// Sqlite needs to open connection to DB
context.Database.OpenConnection();
}
context.Database.EnsureCreated();
return(context);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, AplicationContext context)
{
InitializeDatabase(context);
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Start}/{id?}");
});
}
private static void CadastrarPedido()
{
using var db = new AplicationContext();
var cliente = db.Clientes.FirstOrDefault();
var produto = db.Produtos.FirstOrDefault();
var pedido = new Pedido
{
ClienteId = cliente.Id,
IniciadoEm = DateTime.Now,
FinalizadoEm = DateTime.Now,
Observacao = "Pedido Teste",
Status = StatusPedido.Analise,
TipoFrete = TipoFrete.SemFrete,
Items = new List <PedidoItem>
{
new PedidoItem
{
ProdutoId = produto.Id,
Desconto = 0,
Quantidade = 1,
Valor = 10
}
}
};
db.Pedidos.Add(pedido);
db.SaveChanges();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, AplicationContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseHsts();
}
if (!context.Countries.Any())
{
context.Countries.AddRange(
new List <Country>()
{
new Country()
{
Name = "c", CountryID = 1
},
new Country()
{
Name = "b", CountryID = 2
},
}
);
context.SaveChanges();
}
app.UseHttpsRedirection();
app.UseMvc();
}
public static void Initialize(AplicationContext context)
{
if (!context.Users.Any())
{
context.Users.AddRange(
new User
{
Id = 1,
Login = "******",
Email = "*****@*****.**",
Password = "******"
},
new User
{
Id = 2,
Login = "******",
Email = "*****@*****.**",
Password = "******"
},
new User
{
Id = 3,
Login = "******",
Email = "*****@*****.**",
Password = "******"
}
);
context.SaveChanges();
}
}
private static void InserirDadosEmMassa()
{
var produto = new Produto
{
Descricao = "Produto Teste",
CodigoBarras = "1234567891231",
Valor = 10m,
TipoProduto = TipoProduto.MercadoriaParaVenda,
Ativo = true
};
var Cliente = new Cliente
{
Nome = "Rafael Almeida",
CEP = "99999000",
Cidade = "Itabaiana",
Estado = "SE",
Telefone = "99000001111"
};
using var db = new AplicationContext();
db.AddRange(produto, Cliente);
var registros = db.SaveChanges();
Console.WriteLine($"Total de registros(s): {registros}");
}
private static void InitializeDatabase(AplicationContext context)
{
context.Database.Migrate();
using (var seed = new ApplicationDbInitializer(context))
{
seed.SeedDataAsync().GetAwaiter().GetResult();
}
}
private static void ConsultaDados()
{
using var db = new AplicationContext();
var consultaPorSintaxe = (from c in db.Clientes where c.Id > 0 select c).ToList();
var consultaPorSintaxe2 = db.Clientes.Where(p => p.Id > 0).ToList();
string id = "1";
var consultaPorSintaxe3 = db.Clientes.FromSqlRaw("select * from [dbo].[Clientes] where id = @id", new SqlParameter("id", id)).ToList();
}
public UnitOfWork(AplicationContext context)
{
this.context = context;
Cars = new CarRepository(this.context);
CarsUsers = new CarUserRepository(this.context);
Chassiss = new ChassisRepository(this.context);
Engines = new EngineRepository(this.context);
Users = new UserRepository(this.context);
}
private static void ConsultarPedidoCarregamentoAdiantado()
{
using var db = new AplicationContext();
var pedidos = db.Pedidos
.Include(p => p.Items)
.ThenInclude(p => p.Produto)
.ToList();
Console.WriteLine(pedidos.Count);
}
public UnitOfWork()
{
db = new AplicationContext();
userManager = new ApplicationUserManager(new UserStore <ApplicationUser>(db));
roleManager = new ApplicationRoleManager(new RoleStore <ApplicationRole>(db));
taskListRepository = new TaskListRepository(db);
userRepository = new ClientRepository(db);
boardRepository = new BoardRepository(db);
cardRepository = new CardRepository(db);
}
private static void RemoverRegistro()
{
using var db = new AplicationContext();
var cliente = db.Clientes.Find(2);
//db.Clientes.Remove(cliente);
//db.Remove(cliente);
db.Entry(cliente).State = EntityState.Deleted;
db.SaveChanges();
}
public RedisController(IRedisService redisService, AplicationContext context)
{
_redisService = redisService;
_redisStringDb = _redisService.GetDatabase(RedisDbType.String);
_redisListDb = _redisService.GetDatabase(RedisDbType.List);
_redisSetDb = _redisService.GetDatabase(RedisDbType.Set);
_redisHashDb = _redisService.GetDatabase(RedisDbType.Hash);
_context = context;
}
private static void AtualizarDados()
{
using var db = new AplicationContext();
var cliente = db.Clientes.Find(1);
//cliente.Nome = "Cliente Alterado Passo1";
var clienteDesconectado = new Cliente
{
Nome = "Cliente Desconectado",
Telefone = "7966669999"
};
db.Entry(cliente).CurrentValues.SetValues(clienteDesconectado);
//db.Clientes.Update(cliente);
db.SaveChanges();
}
static void Main(string[] args)
{
var db = new AplicationContext();
//Executa a migração
// db.Database.Migrate();
//verifica se existe migrações pendentes
var existeMigrationsPendentes = db.Database.GetPendingMigrations().Any();
//InserirDados();
//InserirDadosEmMassa();
//ConsultaDados();
//CadastrarPedido();
//ConsultarPedidoCarregamentoAdiantado();
//AtualizarDados();
}
private static void InserirDados()
{
var produto = new Produto
{
Descricao = "Produto Teste",
CodigoBarras = "1234567891231",
Valor = 10m,
TipoProduto = TipoProduto.MercadoriaParaVenda,
Ativo = true
};
using var db = new AplicationContext();
//db.Produtos.Add(produto);
//db.Set<Produto>().Add(produto);
//db.Entry(produto).State = EntityState.Added;
db.Add(produto);
var registros = db.SaveChanges();
Console.WriteLine($"Total de registros(s): {registros}");
}
public ItemPedidoRepository(AplicationContext context) : base(context)
{
}
public ClientRepository(AplicationContext db)
{
Database = db;
}
public UsuarioController(AplicationContext context)
{
_context = context;
}
public DistrictController(AplicationContext context)
{
db = context;
}
public StatisticController(AplicationContext context)
{
db = context;
}
public CadastroRepository(AplicationContext contexto) : base(contexto)
{
}
public static void Initialize(AplicationContext context)
{
User user1 = new User
{
Id = 1,
FirstName = "Anton",
LastName = "Totbin",
PIN = 1234567890123,
// BirthDate = new DateTime(1976, 8, 11),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user2 = new User
{
Id = 2,
FirstName = "Alex",
LastName = "Toto",
PIN = 1111111111111,
// BirthDate = new DateTime(1996, 6, 10),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user3 = new User
{
Id = 3,
FirstName = "Ivan",
LastName = "Lopert",
PIN = 1111111111112,
// BirthDate = new DateTime(1996, 6, 10),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user4 = new User
{
Id = 4,
FirstName = "Olena",
LastName = "Varneva",
PIN = 1111111111113,
// BirthDate = new DateTime(1983, 5, 07),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user5 = new User
{
Id = 5,
FirstName = "Vika",
LastName = "Petrenko",
PIN = 1111111111114,
// BirthDate = new DateTime(1973, 1, 12),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user6 = new User
{
Id = 6,
FirstName = "Yulia",
LastName = "Stahiv",
PIN = 1111111111115,
// BirthDate = new DateTime(2000, 13, 03),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user7 = new User
{
Id = 7,
FirstName = "Oleg",
LastName = "Lesiv",
PIN = 1111111111116,
// BirthDate = new DateTime(1968, 15, 03),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user8 = new User
{
Id = 8,
FirstName = "Vadim",
LastName = "Pushka",
PIN = 1111111111117,
// BirthDate = new DateTime(1989, 19, 02),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user9 = new User
{
Id = 9,
FirstName = "Andrii",
LastName = "Virt",
PIN = 1111111111118,
// BirthDate = new DateTime(1959, 10, 09),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
User user10 = new User
{
Id = 10,
FirstName = "Oksana",
LastName = "Virtlaeva",
PIN = 1111111111119,
// BirthDate = new DateTime(1980, 12, 05),
Login = "******",
Email = "*****@*****.**",
Password = "******"
};
context.Users.AddRange(
user1,
user2,
user3,
user4,
user5,
user6,
user7,
user8,
user9,
user10
);
context.SaveChanges();
}
static void Main(string[] args)
{
AplicationContext app = new AplicationContext();
//inserting data to db.
for (int i = 0; i < 10; i++)
{
Person person = new Person();
person.name = "Ankit" + i;
person.email = "Ankit" + i + "@gmail.com";
person.isActive = (i % 5 == 0 || i % 3 == 0) ? 1 : 0;
app.persons.Add(person);
app.SaveChanges();
}
//extracting persion detail by id
Console.WriteLine("Enter the id to search");
int userId = Convert.ToInt32(Console.ReadLine());
var getPerson = app.persons.Where(a => a.id == userId).FirstOrDefault();
if (getPerson != null)
{
Console.WriteLine(getPerson.id + "\t" + getPerson.name + "\t" + getPerson.email + "\t" + getPerson.isActive);
}
else
{
Console.WriteLine("Not found");
}
//get active users
Console.WriteLine("Enter any key to see active users");
Console.ReadLine();
var activeUsers = app.persons.Where(a => a.isActive == 1).ToList();
if (activeUsers.Any())
{
foreach (Person item in activeUsers)
{
Console.WriteLine(item.id + "\t" + item.name + "\t" + item.isActive);
}
}
else
{
Console.WriteLine("No active users.");
}
//delete based on id
Console.WriteLine("Enter the id to delete");
int newId = Convert.ToInt32(Console.ReadLine());
var resultantList = app.persons.Where(a => a.id == newId).FirstOrDefault();
if (resultantList != null)
{
app.persons.Remove(resultantList);
app.SaveChanges();
}
else
{
Console.WriteLine("no such id is found");
}
}
public CardRepository(AplicationContext context) : base(context)
{
}
public ElectionController(AplicationContext context)
{
db = context;
}
public TipoUsuarioServices(AplicationContext context)
{
_context = context;
}
public CoursesController(AplicationContext context)
{
_context = context;
}
public Dtservice(AplicationContext aplicationContext)
{
this.aplicationContext = aplicationContext;
}
public ReviewController(AplicationContext context)
{
_context = context;
}
