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;
}
