Exemple #1
0
 public static void checkIfNotificationIsNecessary(int projectId)
 {
     try
     {
         nova_ataEntities db                = new nova_ataEntities();
         string           projectName       = string.Empty;
         string           businessUnit      = string.Empty;
         bool             isAllCompleted    = true;
         bool             needsNotification = false;
         var tasks = from t in db.tasks
                     where t.criticalActivity == "5000"
                     where t.projectId == projectId
                     select new { t.status, t.projects.businessUnit, t.projects.name };
         if (tasks.ToList().Count() > 0)
         {
             businessUnit = tasks.ToList()[0].businessUnit;
             projectName  = tasks.ToList()[0].name;
             foreach (var t in tasks)
             {
                 if (!t.status.ToUpper().Equals("COMPLETO"))
                 {
                     isAllCompleted = false;
                 }
             }
         }
         else
         {
             isAllCompleted = false;
         }
         var notification = (dynamic)null;
         notification = db.notifications.Find(projectId);
         if (notification == null)
         {
             needsNotification      = true;
             notification           = db.notifications.Create();
             notification.projectId = projectId;
             notification.status    = "NOT SENT";
             db.notifications.Add(notification);
             db.SaveChanges();
         }
         else
         {
             if (notification.status.Equals("NOT SENT"))
             {
                 needsNotification = true;
             }
         }
         if (isAllCompleted && needsNotification)
         {
             notification.status = "SENT";
             db.SaveChanges();
             Mail.sendMail(0, UserDAO.instanceByBusinessUnit(businessUnit), projectId, projectName);
         }
         if (!isAllCompleted && !needsNotification)
         {
             notification.status = "NOT SENT";
             db.SaveChanges();
             Mail.sendMail(1, UserDAO.instanceByBusinessUnit(businessUnit), projectId, projectName);
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }