public HttpResponseMessage Delete(int id) { try { using (MTContext entities = new MTContext()) { var entity = entities.Veiculos.FirstOrDefault(e => e.IdVeiculo == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Veiculo com o ID = " + id.ToString() + " não encontrado para deletar.")); } else { entities.Veiculos.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <Status> GetAll() { using (MTContext db = new MTContext()) { return(db.Status.ToList()); } }
public IEnumerable <Login> GetAll() { using (MTContext db = new MTContext()) { return(db.Acesso.ToList()); } }
public IEnumerable <Veiculo> GetAll() { using (MTContext db = new MTContext()) { return(db.Veiculos.ToList()); } }
public IEnumerable <ContaBancaria> GetAll() { using (MTContext db = new MTContext()) { return(db.ContaBancarias.ToList()); } }
public HttpResponseMessage GetLoginTeste(string email, string senha) { using (MTContext entities = new MTContext()) { entities.Database.Connection.Open(); var entity = entities.Acesso.FirstOrDefault(e => e.Email == email); if (entity != null) { if (entity.Senha == senha) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Senha incorreta.")); //return Request.CreateResponse(HttpStatusCode.OK, entity); } } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Email não encontrado.")); } } }
public IEnumerable <TipoVeiculo> GetAll() { using (MTContext db = new MTContext()) { return(db.TiposVeiculo.ToList()); } }
private static void AddCategories(MTContext context) { context.AddRange( new Category { Name = "Salary", Icon = "<i class=\"fas fa-briefcase fa-2x\" style=\"color: blue\"></i>" }, new Category { Name = "Car", Icon = "<i class=\"fas fa-car fa-2x\" style=\"color: red\"></i>" }, new Category { Name = "Clothing", Icon = "<i class=\"fas fa-tshirt fa-2x\" style=\"color: green\"></i>" }, new Category { Name = "Food", Icon = "<i class=\"fas fa-hamburger fa-2x\" style=\"color: orange\"></i>" }, new Category { Name = "Leisure", Icon = "<i class=\"fas fa-cocktail fa-2x\" style=\"color: red\"></i>" }, new Category { Name = "Living", Icon = "<i class=\"fas fa-home fa-2x\" style=\"color: black\"></i>" }, new Category { Name = "Others", Icon = "<i class=\"fas fa-file fa-2x\" style=\"color: black\"></i>" } ); context.SaveChanges(); }
public IEnumerable <Motorista> GetAll() { using (MTContext db = new MTContext()) { return(db.Motoristas.ToList()); } }
public IHttpActionResult Post([FromBody] Motorista motorista) { using (MTContext entities = new MTContext()) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } entities.Motoristas.Add(motorista); entities.SaveChanges(); return(CreatedAtRoute("Default", new { id = motorista.IdMotorista }, motorista)); } }
public IHttpActionResult Post([FromBody] ContaBancaria conta) { using (MTContext entities = new MTContext()) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } entities.ContaBancarias.Add(conta); entities.SaveChanges(); return(CreatedAtRoute("Default", new { id = conta.IdContaBancaria }, conta)); } }
public IHttpActionResult Post([FromBody] Status status) { using (MTContext entities = new MTContext()) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } entities.Status.Add(status); entities.SaveChanges(); return(CreatedAtRoute("Default", new { id = status.IdStatus }, status)); } }
public static void Seed(IApplicationBuilder app) { using (var serviceScope = app.ApplicationServices.GetRequiredService <IServiceScopeFactory>().CreateScope()) { MTContext context = new MTContext(); context.Database.Migrate(); if (context.Categories.Any() || context.Transactions.Any()) { return; } AddCategories(context); AddTransactions(context); } }
public HttpResponseMessage GetMotoristaCliente(int id) { using (MTContext entities = new MTContext()) { entities.Database.Connection.Open(); var entity = entities.Motoristas.FirstOrDefault(e => e.IdCliente == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Motorista com o Id = " + id.ToString() + " nao encontrado.")); } } }
public HttpResponseMessage GetTipoVeiculo(int id) { using (MTContext entities = new MTContext()) { entities.Database.Connection.Open(); var entity = entities.TiposVeiculo.FirstOrDefault(e => e.IdTipoVeiculo == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Tipo de veículo com o Id = " + id.ToString() + " não encontrado!")); } } }
public HttpResponseMessage GetStatus(string status) { using (MTContext entities = new MTContext()) { entities.Database.Connection.Open(); var entity = entities.Status.FirstOrDefault(e => e.DescricaoStatus == status); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity, "Status deletado com sucesso")); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Status '" + status.ToString() + "' não encontrado.")); } } }
public HttpResponseMessage GetLogin(string cpf) { using (MTContext entities = new MTContext()) { entities.Database.Connection.Open(); var entity = entities.Acesso.FirstOrDefault(e => e.Ccpf == cpf); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Usuário com o CPF = " + cpf.ToString() + " não encontrado.")); } } }
public HttpResponseMessage GetCartaoCpf(string cpf) { using (MTContext entities = new MTContext()) { entities.Database.Connection.Open(); var entity = entities.Cartao.FirstOrDefault(e => e.Ccpf == cpf); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Cpf não encontrado.")); } } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/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(); } var optionsBuilder = new DbContextOptionsBuilder <MTContext>(); optionsBuilder.UseSqlServer(Configuration.GetConnectionString("MTContext")); using (var context = new MTContext(optionsBuilder.Options)) { context.Database.Migrate(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseSpaStaticFiles(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller}/{action=Index}/{id?}"); }); app.UseSpa(spa => { // To learn more about options for serving an Angular SPA from ASP.NET Core, // see https://go.microsoft.com/fwlink/?linkid=864501 spa.Options.SourcePath = "ClientApp"; if (env.IsDevelopment()) { spa.UseAngularCliServer(npmScript: "start"); } }); }
public TraineeRepository(MTContext context) { _context = context; }
public Uow() { _context = new MTContext(); Trainee = new TraineeRepository(_context); Mentor = new MentorRepository(_context); }
public static MTObject Deserialize(BinaryReader reader) { uint constructor = reader.ReadUInt32(); MTObject obj; Type t = null; try { t = MTContext.GetType(constructor); obj = (MTObject)Activator.CreateInstance(t); } catch (Exception ex) { throw new InvalidDataException("MTObject deserialization failed: invalid constructor", ex); } var fieldsToDeserialize = obj.GetType().GetProperties() .Where(x => x.GetCustomAttribute <MTParameterAttribute>() != null) .Select(x => { var attrib = x.GetCustomAttribute <MTParameterAttribute>(); return(new Field { IsFlag = attrib.IsFlag, FlagType = attrib.FlagType, FlagBitId = attrib.FlagBitId, BigIntegerBytesCount = attrib.BigIntegerBytesCount != -1 ? attrib.BigIntegerBytesCount : (int?)null, Order = attrib.Order, Info = x, Type = x.PropertyType }); }); fieldsToDeserialize.OrderBy(x => x.Order); int flags = 0; foreach (var field in fieldsToDeserialize) { var value = SerializationContext.Deserialize(reader, field.Type, field.BigIntegerBytesCount); if (field.FlagBitId != -1) { if (field.FlagType == FlagType.Null) { if (!IsFlagActive(flags, field.FlagBitId)) { field.Info.SetValue(obj, null); continue; } } else if (field.FlagType == FlagType.True) { field.Info.SetValue(obj, IsFlagActive(flags, field.FlagBitId)); continue; } } field.Info.SetValue(obj, value); if (field.IsFlag) { flags = (int)value; } } return(obj); }
public MentorRepository(MTContext context) { _context = context; }
private static void AddTransactions(MTContext context) { foreach (var item in context.Categories.ToList()) { switch (item.Name) { case "Salary": context.Add(new Transaction { CategoryId = item.Id, Amount = 4000, Date = DateTime.Now, Description = "July", TransactionType = true }); context.SaveChanges(); break; case "Car": context.Add(new Transaction { CategoryId = item.Id, Amount = 300, Date = DateTime.Now, Description = "Repair", TransactionType = false }); context.SaveChanges(); break; case "Food": context.Add(new Transaction { CategoryId = item.Id, Amount = 120, Date = DateTime.Now, Description = "McDonalds", TransactionType = false }); context.SaveChanges(); break; case "Living": context.Add(new Transaction { CategoryId = item.Id, Amount = 1200, Date = DateTime.Now, Description = "Rent", TransactionType = false }); context.SaveChanges(); break; case "Others": context.Add(new Transaction { CategoryId = item.Id, Amount = 550, Date = DateTime.Now, Description = "Gift", TransactionType = false }); context.SaveChanges(); break; case "Clothing": context.Add(new Transaction { CategoryId = item.Id, Amount = 550, Date = DateTime.Now, Description = "New shoes", TransactionType = false }); context.SaveChanges(); break; case "Leisure": context.Add(new Transaction { CategoryId = item.Id, Amount = 220, Date = DateTime.Now, Description = "Lent Ahmet money", TransactionType = false }); context.SaveChanges(); break; default: break; } } ; //context.AddRange( //new Transaction { CategoryId = 9, Amount = 4000, Date = DateTime.Now, Description = "July", TransactionType = true }, //new Transaction { CategoryId = 10, Amount = 300, Date = DateTime.Now, Description = "Repair", TransactionType = false }, //new Transaction { CategoryId = 11, Amount = 550, Date = DateTime.Now, Description = "New shoes", TransactionType = false }, //new Transaction { CategoryId = 12, Amount = 120, Date = DateTime.Now, Description = "McDonalds", TransactionType = false }, //new Transaction { CategoryId = 13, Amount = 220, Date = DateTime.Now, Description = "Lent Ahmet money", TransactionType = false }, //new Transaction { CategoryId = 14, Amount = 1200, Date = DateTime.Now, Description = "Rent", TransactionType = false }, //new Transaction { CategoryId = 15, Amount = 550, Date = DateTime.Now, Description = "Gift", TransactionType = false } //); context.SaveChanges(); }