title: Send Birthday Emails to Employees MVC ASP.net
body: <p>I'm trying to create a function where I send Email to a user when it their birthday. I have all their personal data in my database, so I just wonder like where do i start? Or what do i do? I'm creating this in an MVC app. This is what I've done so far.</p>
  
  <blockquote>
    <p>This is my function in my repository.</p>
  </blockquote>
  
  <pre><code>public List&lt;Employee&gt; GetEmployeesBasesOnBirthDate(int customerId, string birthdate)
      {
          return db.Employees.Where(x =&gt; x.CustomerId == customerId &amp;&amp; x.BirthDate.Contains(birthdate)).ToList();
      }
  </code></pre>
  
  <blockquote>
    <p>And this is what i do in my Controller</p>
  </blockquote>
  
  <pre><code> public ActionResult BirthdayEmail()
  {
      var repository = new SiteRepository();
      var employeebirthday = repository.GetEmployeesBasesOnBirthDate(CommonHelper.CustomerId, DateTime.Now.ToString());
  
      return View();
  }
  </code></pre>
  
  <blockquote>
    <p>What do I do now?</p>
  </blockquote>