using BuddyFinance.Integration; using BuddyFinance.Integration.Models.Enums; using BuddyFinance.Model; using System; using System.Collections.Generic; using System.Configuration; using System.Linq; namespace BuddyFinanceExpireLoanRequests { public class Program { public static void Main(string[] args) { try { using (var db = new BuddyFinanceDBEntities()) { Console.WriteLine("Test"); var loanRequests = db.LoanRequests.Where(m => m.LoanRequestStatusId == (int)LoanRequestStatusEnum.New).ToList(); foreach (var x in loanRequests) { // x.LoanRequestOffers.All(k => k.OfferStausId != (int)OfferStatusEnum.OfferAccepted); var dates = (DateTime.Now - x.RequestedDate).TotalDays; if (dates >= 30) { x.LoanRequestStatusId = (int)LoanRequestStatusEnum.Expired; db.SaveChanges(); } } } } catch (Exception) { // Console.WriteLine("Test" + ex.Message); } } } }