static void Main(string[] args)
{
Console.WriteLine("Applying Purchase Applications DB Migrations..");
using var dbContext = new PurchaseApplicationDbContext();
dbContext.Database.Migrate();
Console.WriteLine("Migrations applied.");
}
void PurchaseApplicationRepository.Create(Domain.PurchaseApplication purchaseApplication)
{
using var dbContext = new PurchaseApplicationDbContext();
var dbEntity = BuildDbPurchaseApplication(purchaseApplication);
dbContext.PurchaseApplications.Add(dbEntity);
dbContext.SaveChanges();
}
public ReadOnlyCollection <PurchaseApplicationDto> SearchAll()
{
using var dbContext = new PurchaseApplicationDbContext();
return(dbContext.PurchaseApplications
.Include(x => x.Products)
.Include(x => x.Client)
.ToList()
.Select(BuildPurchaseApplicationDto)
.ToList()
.AsReadOnly());
}
public Option <Domain.PurchaseApplication> SearchBy(Id purchaseApplicationId)
{
using var dbContext = new PurchaseApplicationDbContext();
var id = purchaseApplicationId.State.Value;
return(dbContext.PurchaseApplications
.Include(x => x.Products)
.Include(x => x.Client)
.Where(x => x.Id == id)
.ToList()
.Select(BuildPurchaseApplication)
.FirstOrDefault());
}
public void Update(Domain.PurchaseApplication purchaseApplication)
{
using var dbContext = new PurchaseApplicationDbContext();
var purchaseApplicationPersistenceState = purchaseApplication.PersistenceState;
var id = purchaseApplication.Id.State.Value;
var dbEntity = dbContext.PurchaseApplications.FirstOrDefault(x => x.Id == id);
if (dbEntity == null)
{
return;
}
dbEntity.RejectionDateTime = purchaseApplicationPersistenceState.Rejection.Map(x => x.DateTime).ToNullable();
dbEntity.RejectionReason = purchaseApplicationPersistenceState.Rejection.Map(x => x.Reason.Value).IfNoneUnsafe(() => null);
dbContext.SaveChanges();
}
