public IEnumerable <ChecksViewModel> GetChecks(string filter, string schoolCode) { try { db = new CheckDatabase(); Check[] checks; if (filter != string.Empty) { checks = db.Checks.Where(c => c.Bank.Contains(filter) || c.Deliverer.Contains(filter) || c.Number.Contains(filter) || c.PayCode.Contains(filter) || c.StudentName.Contains(filter)).ToArray(); } else { checks = db.Checks.ToArray(); } if (schoolCode != string.Empty) { checks = checks.Where(c => c.SchoolCode == schoolCode).ToArray(); } return(Array.ConvertAll(checks, c => (ChecksViewModel)c)); } catch (Exception ex) { return(new ChecksViewModel[1]); } }
public void ConfigureServices(IServiceCollection services) { services.AddControllers(); string conexao = Configuration.GetConnectionString("DefaultConnection"); services.AddDbContext <testeimdbContext>(a => a.UseSqlServer(conexao)); // Checa se o Banco existe/Cria antes de executar as Migrations CheckDatabase.DatabaseExist(conexao); // configuração do Identity services.AddIdentityConfig(Configuration); // Injeção de dependencias services.AddDependenciasConfig(); // Adiciona as instancias de alguns serviços services.AddIntanciaServiceConfig(); //Rodas as Migraçoes do Identity InicializaDatabase.ExecutaIdentityMigrations(); // Roda os Migrations MigrationsDataBase.RunMigration(conexao); services.AddCors(o => o.AddPolicy("EnableCors", builder => { builder.AllowAnyOrigin() .AllowAnyMethod() .AllowAnyHeader(); })); //Swagger services.ConfiguraSwagger(); services.AddMvc(); services.AddControllers() .AddNewtonsoftJson(); }