86 lines
3.1 KiB
C#
86 lines
3.1 KiB
C#
using DeliveryWebApi.Model;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Internal;
|
|
|
|
var builder = WebApplication.CreateBuilder(args);
|
|
|
|
builder.Services.AddEndpointsApiExplorer();
|
|
builder.Services.AddSwaggerGen();
|
|
|
|
// storage setup
|
|
// either use in-memory storage or postgres depending on cfg
|
|
builder.Services.AddDbContext<DeliveryDbContext>(options =>
|
|
{
|
|
if (builder.Configuration.GetValue<bool>("UseInMemoryDatabase"))
|
|
options.UseInMemoryDatabase("Delivery");
|
|
else
|
|
{
|
|
var connectionString = builder.Configuration.GetConnectionString("DatabaseConnection");
|
|
options.UseNpgsql(connectionString);
|
|
}
|
|
});
|
|
|
|
var app = builder.Build();
|
|
|
|
if (app.Environment.IsDevelopment())
|
|
{
|
|
// swagger setup
|
|
app.UseSwagger();
|
|
app.UseSwaggerUI();
|
|
|
|
// migrate model to seed random test values for developers
|
|
app.Services.CreateScope().ServiceProvider.GetRequiredService<DeliveryDbContext>().Database.EnsureCreated();
|
|
}
|
|
|
|
app.UseHttpsRedirection();
|
|
|
|
app.MapPut("/addDistrict", (DeliveryDbContext context, string name) =>
|
|
{
|
|
if (context.Districts.Any(d => d.Name == name))
|
|
return Results.BadRequest(new { Error = "District with the same name already exists" });
|
|
var district = new District{ Name = name };
|
|
context.Districts.Add(district);
|
|
var updated = context.SaveChanges();
|
|
if (updated <= 0)
|
|
return Results.Json(new { Error = "Something went wrong while adding a new district" }, statusCode: 500);
|
|
return Results.Ok(new { district.Id });
|
|
});
|
|
|
|
app.MapGet("/getDistrict/{id:long}", (DeliveryDbContext context, long id) =>
|
|
{
|
|
var district = context.Districts.FirstOrDefault(d => d.Id == id);
|
|
if (district == null)
|
|
return Results.NotFound(new { Error = "District with the given id does not exist" });
|
|
return Results.Ok(new { district.Id, district.Name });
|
|
});
|
|
|
|
app.MapPut("/addOrder", (DeliveryDbContext context, long districtId, float weight, DateTime deliveryDate) =>
|
|
{
|
|
var order = new Order{ DistrictId = districtId, Weight = weight, DeliveryDate = deliveryDate };
|
|
context.Orders.Add(order);
|
|
var updated = context.SaveChanges();
|
|
if (updated <= 0)
|
|
return Results.Json(new { Error = "Something went wrong while adding a new order" }, statusCode: 500);
|
|
return Results.Ok(new { order.Id });
|
|
});
|
|
|
|
app.MapGet("/getOrder/{id:long}", (DeliveryDbContext context, long id) =>
|
|
{
|
|
var order = context.Orders.FirstOrDefault(o => o.Id == id);
|
|
if (order == null)
|
|
return Results.NotFound(new { Error = "Order with the given id does not exist" });
|
|
return Results.Ok(new { order.Id, order.DistrictId, order.Weight, order.DeliveryDate });
|
|
});
|
|
|
|
app.MapGet("/getOrders", (DeliveryDbContext context, string? districtName, DateTime? firstDeliveryDate) =>
|
|
{
|
|
var orders = context.Districts
|
|
.Where(d => districtName == null || d.Name == districtName)
|
|
.SelectMany(d => d.Orders)
|
|
.Where(o => firstDeliveryDate == null || o.DeliveryDate >= firstDeliveryDate)
|
|
.OrderBy(o => o.DeliveryDate)
|
|
.Select(o => new { o.Id, o.District.Name, o.DeliveryDate, o.Weight });
|
|
return Results.Ok(orders);
|
|
});
|
|
|
|
app.Run();
|