public void Update(mp_applicant profile)
        {
            var old = _context.mp_applicant.FirstOrDefault(e => e.id == profile.id);

            profile.created_at = old.created_at;

            _context.Entry(old).CurrentValues.SetValues(profile);
            _context.SaveChanges();
        }
        public Guid Add(mp_applicant profile)
        {
            profile.id         = Guid.NewGuid();
            profile.created_at = DateTime.Now;
            _context.mp_applicant.Add(profile);
            _context.SaveChanges();

            return(profile.id);
        }
 public static string GetApplicantFullName(this mp_applicant person)
 {
     return(person.last_name.ToUpper() + ", " + person.first_name);
 }