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 TraineeRepository(MTContext context)
{
_context = context;
}
public MentorRepository(MTContext context)
{
_context = context;
}
public Uow()
{
_context = new MTContext();
Trainee = new TraineeRepository(_context);
Mentor = new MentorRepository(_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();
}
public MentorRepository(MTContext context)
{
_context = context;
}
