public static void SendMail(string clientname, string invoiceno, string senum, DateTime datesubmit, DateTime duedate) { var title = $"{clientname} Invoice Due Notification"; var start = datesubmit; var end = duedate; var servertime = DateTime.Today; var countdowndate = end.AddDays(-2); // if() if (servertime == countdowndate) { var message = $"Your Invoice Due Notification {invoiceno} with Service Entry no: {senum} expires in 3 days"; using (pdInvoiceEntities db = new pdInvoiceEntities()) { List <string> staffsemail = db.Staffs.Select(c => c.Email).ToList(); SendEmailNotif(title, message, staffsemail); } } else if (servertime == end) { var message = $"Your Invoice Due Notification {invoiceno} with Service Entry no: {senum} expires Today"; using (pdInvoiceEntities db = new pdInvoiceEntities()) { List <string> staffsemail = db.Staffs.Select(c => c.Email).ToList(); SendEmailNotif(title, message, staffsemail); } } }
static void Main(string[] args) { using (pdInvoiceEntities db = new pdInvoiceEntities()) { var invoicesdate = db.Nairas.Select(c => new InvoiceDate { ClientName = c.ClientName, InvoiceNum = c.InvoiceNumber, SeNumber = c.SENumber, DateSubmitted = c.DateSubmitted, DueDate = c.DueDate }); foreach (var invoices in invoicesdate) { SendMail(invoices.ClientName, invoices.InvoiceNum, invoices.SeNumber, invoices.DateSubmitted, invoices.DueDate); } } }