public static double GetTotalInvestido() { using (var ctx = new ClienteContext()) { return(ctx.Cliente.Sum(a => a.Valor)); } }
public IEnumerable <Conta> BuscarPorCliente(Guid clienteID) { using (var context = new ClienteContext()) { return(context.Contas.Where(x => x.ClienteID == clienteID).Select(x => x).ToList()); } }
public static ClienteContext DataInMemory() { var options = new DbContextOptionsBuilder <ClienteContext>() .EnableSensitiveDataLogging() .UseInMemoryDatabase(Guid .NewGuid().ToString()).Options; var context = new ClienteContext(options); context.Clientes.AddRange(new List <ClienteModel>() { new ClienteModel { Id = 1, Nome = "Erick Henrique de Oliveira", Cpf = "44243792801", Rg = "460743181", DataNascimento = new DateTime(1994, 03, 19) }, new ClienteModel { Id = 2, Nome = "Paulo Rodrigo de Oliveira", Cpf = "52406000079", Rg = "195756551", DataNascimento = new DateTime(1990, 11, 19) }, new ClienteModel { Id = 3, Nome = "Maria de Fatima Santos Oliveira", Cpf = "72711992098", Rg = "371240955", DataNascimento = new DateTime(1969, 07, 01) }, }); context.SaveChanges(); 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, ClienteContext clienteContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseDatabaseErrorPage(); //Populando dados fake nas tabelas DbInitializer.Initialize(clienteContext); } else { app.UseExceptionHandler("/Home/Error"); // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseCookiePolicy(); app.UseAuthentication(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); }
public ActionResult RegistraCliente(Cliente c) { if (!ModelState.IsValid) { return(View("MenuAdministracionVenta")); } try { using (var db = new ClienteContext()) { var existe = db.Cliente.ToList().Exists(x => x.dni == c.dni); if (!existe) { //verifica en la BD si el cliente esta registrado o no db.Cliente.Add(c); db.SaveChanges(); return(RedirectToAction("MenuAdministracionVenta", new { message = "Cliente Registrado Satisfactoriamente. Su ID es: 11" })); } else { return(RedirectToAction("MenuAdministracionVenta", new { message = "Cliente ya Registrado" })); } } } catch (Exception ex) { ModelState.AddModelError("", "Error al registrar un Cliente -" + ex.Message); return(View()); } }
private void CadastrarClienteClick(object sender, EventArgs e) { try { var cliente = new Cliente { Nome = txtNome.Text, Email = txtEmail.Text, Telefone = txtTelefone.Text }; if (cliente.Validate()) { var verificaCliente = ClienteContext.GetClientId(cliente.Nome); if (verificaCliente > 0) { MessageBox.Show("Já existe um cliente cadastrado com este nome"); txtNome.Focus(); } else { var result = ClienteContext.Gravar(cliente); MessageBox.Show("Cliente Cadastrado com Sucesso"); Close(); } } else { MessageBox.Show("Os campos não foram preenchidos corretamente"); } } catch (Exception ex) { MessageBox.Show("Erro reportado : " + ex.Message); } }
/// <summary> /// This is the entry point of the service host process. /// </summary> private static void Main() { try { // The ServiceManifest.XML file defines one or more service type names. // Registering a service maps a service type name to a .NET type. // When Service Fabric creates an instance of this service type, // an instance of the class is created in this host process. ClienteContext.Initialize(); ContaContext.Initialize(); ServiceRuntime.RegisterServiceAsync("Sciensa.Desafio.API.ClienteType", context => new ServiceCliente(context)).GetAwaiter().GetResult(); ServiceEventSource.Current.ServiceTypeRegistered(Process.GetCurrentProcess().Id, typeof(ServiceCliente).Name); // Prevents this host process from terminating so services keeps running. Thread.Sleep(Timeout.Infinite); } catch (Exception e) { ServiceEventSource.Current.ServiceHostInitializationFailed(e.ToString()); throw; } }
public IEnumerable <Cliente> Listar() { using (var context = new ClienteContext()) { return(context.Clientes.ToList()); } }
public static List <Cliente> pesquisar(Cliente cli, bool Receber) { cli.Nome = cli.Nome == null ? "" : cli.Nome; cli.Email = cli.Email == null ? "" : cli.Email; cli.Cidade = cli.Cidade == null ? "" : cli.Cidade; string CPF = cli.CPF.ToString(); CPF = CPF == null ? "" : CPF; using (var ctx = new ClienteContext()) { if (Receber) { if (CPF != "0") { return(ctx.Cliente.Where((t => t.Nome.Contains(cli.Nome) && t.Email.Contains(cli.Email) && t.Cidade.Contains(cli.Cidade) && t.ReceberNoticiasEmail == cli.ReceberNoticiasEmail && t.CPF.ToString().Contains(CPF))).ToList()); } else { return(ctx.Cliente.Where((t => t.Nome.Contains(cli.Nome) && t.Email.Contains(cli.Email) && t.Cidade.Contains(cli.Cidade) && t.ReceberNoticiasEmail == cli.ReceberNoticiasEmail)).ToList()); } } else { if (CPF != "0") { return(ctx.Cliente.Where((t => t.Nome.Contains(cli.Nome) && t.Email.Contains(cli.Email) && t.Cidade.Contains(cli.Cidade) && t.CPF.ToString().Contains(CPF))).ToList()); } else { return(ctx.Cliente.Where((t => t.Nome.Contains(cli.Nome) && t.Email.Contains(cli.Email) && t.Cidade.Contains(cli.Cidade))).ToList()); } } } }
public static Cliente pesquisarPorID(int id) { using (var ctx = new ClienteContext()) { return(ctx.Cliente.Find(id)); } }
public async Task <List <Models.Cliente> > Obter() { using (var context = new ClienteContext()) { return(await context.Clientes.Select(s => s).ToListAsync()); } }
public async Task <Models.Cliente> Obter(Guid id) { using (var context = new ClienteContext()) { return(await context.Clientes.FirstAsync(f => f.Id == id)); } }
public static void Initialize(ClienteContext context) { context.Database.EnsureCreated(); if (context.Clientes.Any()) { return; } var clientes = new ClienteModel[] { new ClienteModel { Nome = "Erick Henrique de Oliveira", Cpf = "44243792801", Rg = "460743181", DataNascimento = new DateTime(1994, 03, 19) }, new ClienteModel { Nome = "Paulo Rodrigo de Oliveira", Cpf = "52406000079", Rg = "195756551", DataNascimento = new DateTime(1990, 11, 19) }, new ClienteModel { Nome = "Maria de Fatima Santos Oliveira", Cpf = "72711992098", Rg = "371240955", DataNascimento = new DateTime(1969, 07, 01) }, }; foreach (ClienteModel cliente in clientes) { context.Clientes.Add(cliente); } context.SaveChanges(); }
public BaseFormConfig() { ProdutoContext = new ProdutoContext(Conn); ClienteContext = new ClienteContext(Conn); VendasContext = new VendasContext(Conn); InitializeComponent(); }
public PartialViewResult MostrarClientes() { using (ClienteContext db = new ClienteContext()) { return(PartialView("_Mostrar", db.Clientes.ToList())); } }
// GET: Cliente public ActionResult Index() { using (ClienteContext clienteContext = new ClienteContext()) { List <Cliente> clientes = clienteContext.clientes.ToList(); return(View(clientes)); } }
// GET: Cliente public ActionResult Index() { //libera o recurso quando terminar de usar using (ClienteContext clienteContext = new ClienteContext()) { List <Cliente> clientes = clienteContext.clientes.ToList(); return(View(clientes)); }; }
public int Adicionar(Cliente cliente) { using (var context = new ClienteContext()) { context.Clientes.Add(cliente); return(context.SaveChanges()); } }
// GET: TipoCliente public ActionResult Index() { using (ClienteContext clienteContext = new ClienteContext()) { List<Tipo> tiposCliente = clienteContext.Tipos.ToList(); return View(tiposCliente); } }
public ActionResult Detalhes(int id) { using (ClienteContext clienteContext = new ClienteContext()) { Cliente cliente = clienteContext.clientes.Single(cli => cli.ClienteId == id); return(View(cliente)); } }
public ActionResult Detalhes(int id) { using (ClienteContext cc = new ClienteContext()) { Cliente cliente = cc.clientes.Include("Tipo").SingleOrDefault(c => c.Id == id); return(View(cliente)); } }
// // GET: /Tipo/ public ActionResult Index() { using (ClienteContext context = new ClienteContext()) { List <TipoCliente> tipos = context.tipos.ToList(); return(View(tipos)); } }
public ActionResult Eliminar(int id) { using (ClienteContext db = new ClienteContext()) { var obj = db.Clientes.Where(x => x.ID.Equals(id)).FirstOrDefault(); return(View(obj)); } }
public void AddCliente(ICliente cliente) { using (var db = new ClienteContext(ConnectionStrings)) { db.Clientes.Add((Cliente)cliente); db.SaveChanges(); } }
public static void cadastrar(Cliente cliente) { using (var ctx = new ClienteContext()) { ctx.Cliente.Add(cliente); ctx.SaveChanges(); } }
public static void deletar(int id) { using (var ctx = new ClienteContext()) { ctx.Cliente.Remove(ctx.Cliente.Find(id)); ctx.SaveChanges(); } }
public static ClienteDAO getInstance() { if (instance == null) { instance = new ClienteDAO(ClienteContext.getInstance()); } return(instance); }
public int Editar(Conta conta) { using (var context = new ClienteContext()) { context.Contas.Attach(conta); context.Entry(conta).State = EntityState.Modified; return(context.SaveChanges()); } }
// GET: Cliente public ActionResult Index(int TipoId) { using (ClienteContext clienteContext = new ClienteContext()) { List <Cliente> clientes = clienteContext.Clientes.Where(cli => cli.TipoId == TipoId).ToList(); return(View(clientes)); } }
// // GET: /Cliente/ public ActionResult Index(int tipoId) { using (ClienteContext cc = new ClienteContext()) { List <Cliente> lista = new List <Cliente>(); lista = cc.clientes.Where(c => c.TipoId == tipoId).ToList(); return(View(lista)); } }