Example #1
0
 private void UpdateEmailSend(int EmailsSendLineId, int EmailsQueueLineId)
 {
     try
     {
         EmailsSend row = _context.EmailsSends.Where(x => x.LineId == EmailsSendLineId).FirstOrDefault();
         row.SendDt = DateTime.Now;
         EmailsQueue item = _context.EmailsQueues.Where(x => x.LineId == EmailsQueueLineId).FirstOrDefault();
         item.Done = true;
         _context.SaveChanges();
     }
     catch (Exception ex)
     {
         WriteToFile("EX-UpdateEmailSend: " + ex.Message);
     }
 }
Example #2
0
        private int InsertNewEmail(int ActivityId, int ActivityJBI)
        {
            EmailsSend newObj;

            try
            {
                EmailsSend row = new EmailsSend();
                row.ActivityId    = ActivityId;
                row.ActivityJBI   = ActivityJBI;
                row.ClickedAnswer = 0;
                row.IsOpen        = false;
                row.SendDt        = new DateTime(2000, 1, 1, 0, 0, 0);
                newObj            = _context.EmailsSends.Add(row);
                _context.SaveChanges();
            }
            catch (Exception ex)
            {
                WriteToFile("EX-InsertNewEmail: " + ex.Message + ex.InnerException.Message);
                throw;
            }

            return(newObj.LineId);
        }