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(); }