public IEnumerable <Cliente> ObterClientes() { using (var contexto = new TesteContext()) { return(contexto.Clientes.Where(x => x.Ativo.Equals("Ativo")).ToList()); } }
static void Main(string[] args) { var ctx = new TesteContext(); ctx.Database.CreateIfNotExists(); Console.ReadKey(); }
public async Task <IHttpActionResult> salvaCampo([FromBody] CampoModel model) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} try { using (TesteContext db = new TesteContext()) { CAMPO campo = new CAMPO(); campo.Nome = model.Nome; campo.Ativo = false; db.Campo.Add(campo); db.SaveChanges(); } } catch (Exception e) { ModelState.AddModelError("Post", "Site temporariamente indisponível. Tente mais tarde."); return(BadRequest(ModelState)); } return(Ok(model)); }
public Cliente ObterCliente(int id) { using (var contexto = new TesteContext()) { return(contexto.Clientes.First(x => x.IdCLiente == id)); } }
public ValuesTestes() { _testeContext = new TesteContext(); mock = new Mock <ICryptoAPIService>(MockBehavior.Strict); mock.Setup(s => s.SearchCoinsToId(ToIdValido)).Returns(() => null); mock.Setup(s => s.SearchCoinsToId(ToIdInValido)).Throws(new Exception("Moeda inexistente")); }
public async Task Transferir() { TransferenciaRequest transferenciaRequest = new TransferenciaRequest(); transferenciaRequest.ContaCorrenteCredito = new ContaCorrente() { Banco = new Banco() { CodigoBanco = 237 }, Agencia = new Agencia() { CodigoAgencia = 1996, DigitoAgencia = 8 }, Conta = 32961, Digito = 4 }; transferenciaRequest.ContaCorrenteDebito = new ContaCorrente() { Banco = new Banco() { CodigoBanco = 341 }, Agencia = new Agencia() { CodigoAgencia = 1234, DigitoAgencia = 5 }, Conta = 32945, Digito = 1 }; transferenciaRequest.Montante = 879.54M; var jsonContent = JsonConvert.SerializeObject(transferenciaRequest); var contentString = new StringContent(jsonContent, Encoding.UTF8, "application/json"); contentString.Headers.ContentType = new MediaTypeHeaderValue("application/json"); string retorno = string.Empty; using (var client = new TesteContext().Client) { var response = await client.PostAsync("/api/solicitacao", contentString); response.EnsureSuccessStatusCode(); response.StatusCode.Should().Be(HttpStatusCode.OK); retorno = response.StatusCode.ToString(); } Assert.Equal("OK", retorno); }
public async Task SeedAsync(TesteContext context, IHostingEnvironment env) { using (context) { context.Database.Migrate(); if (!context.CodigoPostal.Any()) { context.CodigoPostal.AddRange(CarregarCEPsPorArquivo(env.ContentRootPath)); } await context.SaveChangesAsync(); } }
public bool EditarCliente(Cliente cliente) { try { using (var contexto = new TesteContext()) { contexto.Entry(cliente).State = EntityState.Modified; contexto.SaveChanges(); return(true); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public async Task <IHttpActionResult> pesquisaCampo(int Id) { CAMPO campo = new CAMPO(); try { using (var dbEst = new TesteContext()) { campo = dbEst.Campo.Single(x => x.ID == Id); } } catch (Exception e) { ModelState.AddModelError("RestricaoCampo", "Site temporariamente indisponível. Tente mais tarde."); return(BadRequest(ModelState)); } return(Ok(campo)); }
public IHttpActionResult Post(Usuario model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (TesteContext db = new TesteContext()) { db.Usuario.Add(model); db.SaveChanges(); } return(Ok(model)); }
public bool SalvarCliente(Cliente cliente) { try { using (var contexto = new TesteContext()) { contexto.Clientes.Add(cliente); contexto.SaveChanges(); return(true); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public async Task <IHttpActionResult> apagaCampo(int id) { try { CAMPO campo = new CAMPO(); using (TesteContext db = new TesteContext()) { campo = db.Campo.Single(x => x.ID == id); db.Campo.Remove(campo); db.SaveChanges(); } return(Ok(campo)); } catch (Exception e) { ModelState.AddModelError("Post", "Site temporariamente indisponível. Tente mais tarde."); return(BadRequest(ModelState)); } }
private void Dados_Load(object sender, EventArgs e) { dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.AllowUserToAddRows = false; dataGridView1.AllowUserToDeleteRows = false; dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; dataGridView1.Columns.Add("colIDCLiente", "IDCliente"); dataGridView1.Columns.Add("colNome", "Nome"); dataGridView1.Columns.Add("colDD", "DD"); dataGridView1.Columns.Add("colTelefone", "Telefone"); dataGridView1.Columns.Add("colLogradouro", "Logradouro"); dataGridView1.Columns.Add("colBairro", "Bairro"); dataGridView1.Columns.Add("colCidade", "Cidade"); dataGridView1.Columns.Add("colNumero", "Numero"); dataGridView1.Columns.Add("colUF", "UF"); dataGridView1.Columns.Add("colCEP", "CEP"); var contexto = new TesteContext(); var lista = from Clientes in contexto.Clientes select Clientes; }
public async Task <IHttpActionResult> listaCampos() { List <CampoModel> lista = new List <CampoModel>(); try { using (var dbEst = new TesteContext()) { lista = dbEst.Campo.Where(x => x.Ativo == false && x.ID > 30) .Select(C => new CampoModel { Id = C.ID, Nome = C.Nome } ).Take(10).ToList(); } } catch (Exception e) { ModelState.AddModelError("RestricaoCampo", "Site temporariamente indisponível. Tente mais tarde."); return(BadRequest(ModelState)); } return(Ok(lista)); }
public Repository(TesteContext context) { testeContext = context; DbSet = testeContext.Set <TEntity>(); }
public UsuarioRepository(TesteContext context) : base(context) { }
public EnderecoesController(TesteContext context) { _context = context; }
public CidadesController(TesteContext context) { _context = context; }
public CaoController(TesteContext context) { _context = context; }
public SellerService(TesteContext context) { _context = context; }
public LivroRepository(TesteContext dbContext) : base(dbContext) { }
public FornecedoresController(TesteContext contexto) { this.contexto = contexto; }
public SalesRecordService(TesteContext testeContext) { _context = testeContext; }
public UnitOfWork(TesteContext context) { _context = context; }
public SellerService(TesteContext testeContext) { _testeContext = testeContext; }
public HomeController(TesteContext context) { _context = context; }
public DepartmentsController(TesteContext context) { _context = context; }
public RepositoryCategoria(TesteContext context) { _context = context; }
public DepartmentService(TesteContext context) { _context = context; }
public RepositoryUsuario(TesteContext context) { _context = context; }