Ejemplo n.º 1
0
 public static List <Response> insertOrUpdate(User requester, Task[] listOfTasks)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         List <Response>  listOfResponses = new List <Response>();
         int projectId = listOfTasks[0].getProjectId();
         var tasks     = from t in db.tasks
                         where t.projectId == projectId
                         where t.activityOrigin.ToUpper().Equals("PROJECT")
                         select t;
         var result = tasks.ToList().Where(x => !listOfTasks.Any(y => x.idProjectTask == y.getIdProjectTask()));
         if (result.Count() > 0)
         {
             foreach (var task in result)
             {
                 listOfResponses.Add(delete(requester, task.taskId));
             }
         }
         foreach (Task task in listOfTasks)
         {
             listOfResponses.Add(insertOrUpdate(requester, task));
         }
         return(listOfResponses);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 2
0
 public static bool isLeaderOrSubmitter(User user, Project project)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         int    projectId    = project.getProjectId();
         int    userId       = user.getUserId();
         string userArea     = user.getArea();
         var    leader       = from p in db.projects
                               where p.leaderOrSubmitter == userId && p.projectId == projectId && userArea == "GP"
                               select new { p.leaderOrSubmitter };
         if (leader.ToList().Count > 0)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 3
0
 public static bool isResponsibleForTask(User user, Task task)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         int    taskId       = task.getTaskId();
         string userArea     = user.getArea();
         var    responsible  = from t in db.tasks
                               where t.taskId == taskId
                               where task.getResponsibleList().Contains(t.responsible)
                               select new { t.responsible };
         if (responsible.ToList().Count > 0)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 4
0
 public static bool isPMO(User user, Project project)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         int    projectId    = project.getProjectId();
         string userAlias    = user.getAlias();
         var    pmo          = from ta in db.team_allocation
                               join p in db.projects on ta.projectId equals p.projectId
                               where ta.users.alias == userAlias && p.projectId == projectId && ta.users.area == "GP"
                               select new { ta.userId };
         if (pmo.ToList().Count > 0)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 5
0
        public static User instanceByName(string name)
        {
            nova_ataEntities db = new nova_ataEntities();

            name = string.Format("%{0}%", name.Replace(' ', '%'));
            StringBuilder sb        = new StringBuilder();
            var           arrayText = name.Normalize(NormalizationForm.FormD).ToCharArray();

            foreach (char letter in arrayText)
            {
                if (CharUnicodeInfo.GetUnicodeCategory(letter) != UnicodeCategory.NonSpacingMark)
                {
                    sb.Append(letter);
                }
            }
            name = sb.ToString();
            var usr = db.users.Where(x => SqlFunctions.PatIndex(name, x.name) > 0);

            if (usr.Count() > 0)
            {
                User user = new User(usr.ToList()[0].userId, usr.ToList()[0].alias, usr.ToList()[0].name, usr.ToList()[0].exchangeName,
                                     usr.ToList()[0].email, usr.ToList()[0].area, usr.ToList()[0].managerName, usr.ToList()[0].managerLogin,
                                     usr.ToList()[0].managerEmail, usr.ToList()[0].type);
                return(user);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 6
0
 public static List <Task> select(User requester, int projectId)
 {
     try
     {
         nova_ataEntities db          = new nova_ataEntities();
         List <Task>      listOfTasks = new List <Task>();
         var tasks = from t in db.tasks
                     where t.projectId == projectId && t.wasDeleted == "false"
                     select t;
         foreach (var t in tasks)
         {
             Task task = new Task(t.taskId, t.projectId, t.notifyMe, t.meetingDate, t.product, t.pWork, t.criticalActivity,
                                  t.activityTitle, t.activityDescription, t.parent, t.grandParent, t.responsible, t.start, t.finish,
                                  t.status, CommentDAO.selectLastComment(t.taskId), t.activityOrigin, t.idProjectTask, t.idParentProjectTask,
                                  t.ident, t.hash, t.delayReason, t.delayDescription, UserDAO.instanceById((int)t.createdBy),
                                  (int)t.reworkCount, t.actualFinishDate, t.newStart, t.newFinish, t.isFreezed, t.wasDeleted,
                                  t.wasInsertedAfterFreezing);
             listOfTasks.Add(task);
         }
         return(listOfTasks);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 7
0
        public static Response insert(User requester, Comment comment)
        {
            var c = (dynamic)null;

            try
            {
                nova_ataEntities db = new nova_ataEntities();
                c         = db.comments.Create();
                c.taskId  = comment.getTaskId();
                c.comment = comment.getComment();
                c.owner   = requester.getUserId();
                DateTime dateTime = DateTime.Now;
                c.creationDate = string.Format("{0:dd/MM/yyyy}", dateTime);
                c.creationTime = string.Format("{0:hh:mm:ss}", dateTime);
                db.comments.Add(c);
                db.SaveChanges();
                return(new Response(c.taskId, "Created", ""));
            }
            catch (DbEntityValidationException dbEx)
            {
                Exception raise = dbEx;
                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage);
                        raise = new InvalidOperationException(message, raise);
                    }
                }
                throw raise;
            }
        }
Ejemplo n.º 8
0
 public static List <Project> select()
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         List <Project>   lp = new List <Project>();
         var projects        = from pr in db.projects
                               select pr;
         foreach (var p in projects.ToList())
         {
             Project project = new Project(p.projectId, p.name, p.leaderOrSubmitter, p.meaningLevel, p.projectStatus,
                                           p.scheduleStatus, p.businessUnit, p.category, p.subBrand, p.archetype, p.productProjectStage, (int)p.totalSkus,
                                           (int)p.newSkus, p.originalPBFGateAppDate, p.originalBFGateAppDate, p.originalPTGateAppDate,
                                           p.originalVLGateAppDate, p.originalDLGateAppDate, p.originalEXGateAppDate, p.originalEVGateAppDate,
                                           p.originalLaunchYear, p.displayPBFGateAppDate, p.displayBFGateAppDate, p.displayPTGateAppDate,
                                           p.displayVLGateAppDate, p.displayDLGateAppDate, p.displayEXGateAppDate, p.displayEVGateAppDate,
                                           p.displayLaunchCycle, p.displayLaunchYear, p.actualPBFGateAppDate, p.actualBFGateAppDate,
                                           p.actualPTGateAppDate, p.actualVLGateAppDate, p.actualDLGateAppDate, p.actualEXGateAppDate,
                                           p.actualEVGateAppDate, p.lastEstimatedPBFGateAppDate, p.lastEstimatedBFGateAppDate,
                                           p.lastEstimatedPTGateAppDate, p.lastEstimatedVLGateAppDate, p.lastEstimatedDLGateAppDate,
                                           p.lastEstimatedEXGateAppDate, p.lastEstimatedEVGateAppDate, p.creationDate, p.dateLastUpdated,
                                           p.operatingCostCenter, p.prototypePBFGateAppDate, p.prototypeBFGateAppDate, p.prototypePTGateAppDate,
                                           p.prototypeVLGateAppDate, p.prototypeDLGateAppDate, p.prototypeEXGateAppDate, p.prototypeEVGateAppDate,
                                           p.scoreSharedGoalsPBF, p.scoreSharedGoalsBF, p.scoreSharedGoalsPT, p.scoreSharedGoalsVL,
                                           p.scoreSharedGoalsDL, p.scoreSharedGoalsEX, p.scoreSharedGoalsEV, p.parentProgramIDNumber,
                                           p.parentProgramName, p.launchOrMaintenance, p.targetRegions, p.commemorationDate,
                                           p.first12MonthsGrossRevenue, p.first12MonthsIncrementalGrossRevenue, p.description, p.itemType,
                                           p.projectOrganization, p.timeToDelivery, p.timeToMarket, (int)p.consumerSafetyComplexity,
                                           (int)p.dlComplexity, (int)p.fillingComplexity, (int)p.formulationComplexity, (int)p.packagingComplexity,
                                           (int)p.marketingComplexity, (int)p.processComplexity, (int)p.qualityComplexity);
             int projectId = project.getProjectId();
             var team      = from ta in db.team_allocation
                             where ta.projectId == projectId
                             select new { ta.users };
             foreach (var usr in team.ToList())
             {
                 User user = new User(usr.users.userId, usr.users.alias, usr.users.name, usr.users.exchangeName, usr.users.email,
                                      usr.users.area, usr.users.managerName, usr.users.managerLogin, usr.users.managerEmail, usr.users.type);
                 project.addTeamMember(user);
             }
             lp.Add(project);
         }
         return(lp);
     }
     catch (DbEntityValidationException dbEx)
     {
         Exception raise = dbEx;
         foreach (var validationErrors in dbEx.EntityValidationErrors)
         {
             foreach (var validationError in validationErrors.ValidationErrors)
             {
                 string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage);
                 raise = new InvalidOperationException(message, raise);
             }
         }
         throw raise;
     }
 }
Ejemplo n.º 9
0
        public static User instanceById(int userId)
        {
            nova_ataEntities db = new nova_ataEntities();
            var usr             = (from u in db.users
                                   where u.userId == userId
                                   select u).First();

            if (usr == null)
            {
                throw new Exception("No register was found");
            }
            User user = new User(usr.userId, usr.alias, usr.name, usr.exchangeName, usr.email, usr.area, usr.managerName,
                                 usr.managerLogin, usr.managerEmail, usr.type);

            return(user);
        }
Ejemplo n.º 10
0
        public static List <User> instanceByBusinessUnit(string businessUnit)
        {
            nova_ataEntities db          = new nova_ataEntities();
            List <User>      listOfUsers = new List <User>();
            var users = from u in db.users
                        where u.type == businessUnit
                        select u;

            foreach (var u in users)
            {
                User user = new User(u.userId, u.alias, u.name, u.exchangeName, u.email, u.area, u.managerName,
                                     u.managerLogin, u.managerEmail, u.type);
                listOfUsers.Add(user);
            }
            return(listOfUsers);
        }
Ejemplo n.º 11
0
 public static List <CockpitSAP> select(User requester, int[] projectIdList)
 {
     try
     {
         List <CockpitSAP> listOfCockpitSAPs = new List <CockpitSAP>();
         nova_ataEntities  db = new nova_ataEntities();
         var data             = from cp in db.cockpit
                                join p in db.projects on cp.projectId equals p.projectId
                                from cps in db.cockpit_sap
                                .Where(cps => cps.material == cp.code)
                                .DefaultIfEmpty()
                                where projectIdList.Contains(cp.projectId)
                                select new
         {
             cp.cockpitId,
             cp.projectId,
             p.name,
             cp.description,
             cp.type,
             cp.code,
             cp.dummyCode,
             cp.parentSellCode,
             cp.parentZpac,
             cp.hash,
             cps.sm,
             cps.workItemText,
             cps.currentResponsible,
             cps.generationDate,
             cps.realInDate,
             cps.finished,
             cps.deadline,
             cps.sellCode
         };
         foreach (var t in data)
         {
             CockpitSAP cockpitSAP = new CockpitSAP(t.cockpitId, t.projectId, t.name, t.description, t.type, t.code, t.dummyCode,
                                                    t.parentSellCode, t.parentZpac, t.hash, t.sm, t.workItemText, t.currentResponsible, t.generationDate,
                                                    t.realInDate, t.finished, t.deadline, t.sellCode);
             listOfCockpitSAPs.Add(cockpitSAP);
         }
         return(listOfCockpitSAPs);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 12
0
 public static Response delete(User requester, Cockpit cockpit)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         var cp = db.cockpit.Find(cockpit.getCockpitId());
         if (cp != null)
         {
             db.cockpit.Remove(cp);
             db.SaveChanges();
         }
         return(new Response(cockpit.getCockpitId(), "Deleted", cockpit.getHash()));
     }
     catch
     {
         return(new Response(cockpit.getCockpitId(), "Fail", cockpit.getHash()));
     }
 }
Ejemplo n.º 13
0
 public static Response delete(User requester, Task task)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         var t = db.tasks.Find(task.getTaskId());
         if (t != null)
         {
             t.wasDeleted = "true";
             db.SaveChanges();
         }
         return(new Response(task.getTaskId(), "Deleted", task.getHash()));
     }
     catch
     {
         return(new Response(task.getTaskId(), "Fail", task.getHash()));
     }
 }
Ejemplo n.º 14
0
 public static Task instanceById(int taskId)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         var  t    = db.tasks.Find(taskId);
         Task task = new Task(t.taskId, t.projectId, t.notifyMe, t.meetingDate, t.product, t.pWork, t.criticalActivity,
                              t.activityTitle, t.activityDescription, t.parent, t.grandParent, t.responsible, t.start, t.finish,
                              t.status, CommentDAO.selectLastComment(t.taskId), t.activityOrigin, t.idProjectTask, t.idParentProjectTask,
                              t.ident, t.hash, t.delayDescription, t.delayDescription, UserDAO.instanceById((int)t.createdBy),
                              (int)t.reworkCount, t.actualFinishDate, t.newStart, t.newFinish, t.isFreezed, t.wasDeleted,
                              t.wasInsertedAfterFreezing);
         return(task);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 15
0
        public static bool isCreatorOfTask(User user, Task task)
        {
            nova_ataEntities db = new nova_ataEntities();
            int taskId          = task.getTaskId();
            int userId          = user.getUserId();
            var creator         = from t in db.tasks
                                  where t.taskId == taskId
                                  where t.createdBy == userId
                                  select new { t.responsible };

            if (creator.ToList().Count > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 16
0
 public static Response finishTask(User requester, Task task)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         var t = db.tasks.Find(task.getTaskId());
         if (t != null)
         {
             t.status           = "Completo";
             t.pWork            = "100";
             t.actualFinishDate = string.Format("{0:dd/MM/yyyy}", DateTime.Now);
             db.SaveChanges();
         }
         return(new Response(task.getTaskId(), "Edited", task.getHash()));
     }
     catch
     {
         return(new Response(task.getTaskId(), "Fail", task.getHash()));
     }
 }
Ejemplo n.º 17
0
 public static List <Update> select(int projectId)
 {
     try
     {
         nova_ataEntities db            = new nova_ataEntities();
         List <Update>    listOfUpdates = new List <Update>();
         var tasks = from t in db.tasks
                     where t.projectId == projectId
                     where t.activityOrigin.ToUpper() == "PROJECT" && t.idParentProjectTask != ""
                     select new { t.taskId, t.pWork };
         foreach (var t in tasks)
         {
             listOfUpdates.Add(new Update(t.taskId, t.pWork));
         }
         return(listOfUpdates);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 18
0
 public static List <Comment> select(int taskId)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         List <Comment>   lc = new List <Comment>();
         var com             = from c in db.comments
                               where c.taskId == taskId
                               select new { c.commentId, c.taskId, c.comment, owner = c.users.exchangeName, c.creationDate, c.creationTime };
         foreach (var c in com.ToList())
         {
             Comment comment = new Comment(c.commentId, c.taskId, c.comment, c.owner, c.creationDate, c.creationTime);
             lc.Add(comment);
         }
         return(lc);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 19
0
 public static void insert(Log log)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         var l = db.logs.Create();
         l.controller  = log.getController();
         l.requestType = log.getRequestType();
         l.requester   = log.getRequester().getUserId();
         l.date        = log.getDate();
         l.time        = log.getTime();
         l.attribute1  = log.getAttribute1();
         l.attribute2  = log.getAttribute2();
         l.body        = log.getBody();
         db.logs.Add(l);
         db.SaveChanges();
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 20
0
 public static string selectLastComment(int taskId)
 {
     try
     {
         nova_ataEntities db = new nova_ataEntities();
         try
         {
             var uc = (from c in db.comments
                       where c.taskId == taskId
                       orderby c.commentId descending
                       select c).First();
             return(uc.comment);
         }
         catch
         {
             return(null);
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 21
0
        public static User instanceByAlias(string alias)
        {
            if (alias.Contains('\\'))
            {
                alias = alias.Split('\\')[1].ToUpper();
            }
            if (alias.ToUpper().Equals("RESOURCE"))
            {
                /*
                 * Felipe Maranzato
                 * alias = "FMARAZAT";
                 * Hannah Ralha
                 * alias = "38861097";
                 * Nelis Ortiz
                 * alias = "BR91688";
                 * Clissia Postale
                 * alias = "BR88822";
                 * Emerson Tosco
                 * alias = "ETOSCO";
                 */
                alias = "81971095";
            }
            nova_ataEntities db = new nova_ataEntities();
            var usr             = (from u in db.users
                                   where u.alias == alias
                                   select u).First();

            if (usr == null)
            {
                throw new Exception("No register was found");
            }
            User user = new User(usr.userId, usr.alias, usr.name, usr.exchangeName, usr.email, usr.area, usr.managerName,
                                 usr.managerLogin, usr.managerEmail, usr.type);

            return(user);
        }
Ejemplo n.º 22
0
 public static List <Response> insertOrUpdate(User requester, Cockpit[] listOfCockpits)
 {
     try
     {
         List <Response>  listOfResponses = new List <Response>();
         nova_ataEntities db = new nova_ataEntities();
         foreach (Cockpit cockpit in listOfCockpits)
         {
             if (cockpit.getCockpitId() < 0)
             {
                 int cockpitId = Math.Abs(cockpit.getCockpitId());
                 cockpit.setCockpitId(cockpitId);
                 listOfResponses.Add(CockpitDAO.delete(requester, cockpit));
                 continue;
             }
             bool isNew = false;
             var  cp    = (dynamic)null;
             if (cockpit.getCockpitId() == 0)
             {
                 isNew = true;
                 cp    = db.cockpit.Create();
             }
             else
             {
                 isNew = false;
                 cp    = db.cockpit.Find(cockpit.getCockpitId());
                 if (cp == null)
                 {
                     listOfResponses.Add(new Response(cockpit.getCockpitId(), "Fail. Result not found", cockpit.getHash()));
                 }
             }
             cp.projectId      = cockpit.getProjectId();
             cp.description    = cockpit.getDescription();
             cp.type           = cockpit.getType();
             cp.code           = cockpit.getCode();
             cp.dummyCode      = cockpit.getDummyCode();
             cp.parentSellCode = cockpit.getParentSellCode();
             cp.parentZpac     = cockpit.getParentZpac();
             cp.hash           = cockpit.getHash();
             if (isNew)
             {
                 db.cockpit.Add(cp);
             }
             db.SaveChanges();
             if (isNew)
             {
                 listOfResponses.Add(new Response(cp.cockpitId, "Created", cockpit.getHash()));
             }
             else
             {
                 listOfResponses.Add(new Response(cockpit.getCockpitId(), "Edited", cockpit.getHash()));
             }
         }
         return(listOfResponses);
     }
     catch (DbEntityValidationException dbEx)
     {
         Exception raise = dbEx;
         foreach (var validationErrors in dbEx.EntityValidationErrors)
         {
             foreach (var validationError in validationErrors.ValidationErrors)
             {
                 string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage);
                 raise = new InvalidOperationException(message, raise);
             }
         }
         throw raise;
     }
 }
Ejemplo n.º 23
0
        public static List <Minute> select(User requester, int projectStatus)
        {
            try
            {
                nova_ataEntities db = new nova_ataEntities();
                List <Minute>    lm = new List <Minute>();
                var    proj         = (dynamic)null;
                int    userId       = requester.getUserId();
                string userAlias    = requester.getAlias();
                switch (projectStatus)
                {
                //Retorna todos os projetos
                case 0:
                    proj = from ta in db.team_allocation
                           join p in db.projects on ta.projectId equals p.projectId
                           join u in db.users on ta.userId equals u.userId
                           where (u.alias == userAlias && ta.userId == u.userId) || (p.leaderOrSubmitter == userId)
                           group ta by new { p.projectId, p.name, p.projectStatus, p.productProjectStage, p.parentProgramIDNumber } into g
                    orderby g.Key.projectId ascending
                        select new { idProjetoGensight = g.Key.projectId, nomeProjetoGensight = g.Key.name, statusProjeto = g.Key.projectStatus, estagio = g.Key.productProjectStage, programa = g.Key.parentProgramIDNumber };
                    break;

                //Retorna apenas projetos ativos ou programas
                case 1:
                    proj = from ta in db.team_allocation
                           join p in db.projects on ta.projectId equals p.projectId
                           join u in db.users on ta.userId equals u.userId
                           where p.projectStatus == "ACTIVE" || p.productProjectStage == "LAUNCH EXECUTION" || p.productProjectStage == "PROGRAMA"
                           where (u.alias == userAlias && ta.userId == u.userId) || (p.leaderOrSubmitter == userId)
                           group ta by new { p.projectId, p.name, p.projectStatus, p.productProjectStage, p.parentProgramIDNumber } into g
                    orderby g.Key.projectId ascending
                        select new { idProjetoGensight = g.Key.projectId, nomeProjetoGensight = g.Key.name, statusProjeto = g.Key.projectStatus, estagio = g.Key.productProjectStage, programa = g.Key.parentProgramIDNumber };
                    break;

                default:
                    throw new Exception("Invalid option selected");
                }
                List <int> listAll = new List <int>();
                foreach (var p in proj)
                {
                    try
                    {
                        if (!listAll.Any(y => y == p.idProjetoGensight))
                        {
                            listAll.Add(p.idProjetoGensight);
                        }
                        if (p.programa != "0" && !listAll.Any(x => x == Convert.ToInt32(p.programa)))
                        {
                            listAll.Add(Convert.ToInt32(p.programa));
                        }
                    }
                    catch
                    {
                        continue;
                    }
                }
                proj = from p in db.projects
                       where listAll.Contains(p.projectId)
                       select new { p.projectId, p.name, p.projectStatus, p.productProjectStage, p.parentProgramIDNumber };
                foreach (var p in proj)
                {
                    Minute minute = new Minute(p.projectId, p.name, p.projectStatus, p.productProjectStage);
                    lm.Add(minute);
                }
                return(lm);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Ejemplo n.º 24
0
        public static Response insertOrUpdate(User requester, Task task)
        {
            try
            {
                nova_ataEntities db = new nova_ataEntities();
                if (task.getTaskId() < 0)
                {
                    if (!task.getCriticalActivity().Equals("5000"))
                    {
                        int taskId = Math.Abs(task.getTaskId());
                        task.setTaskId(taskId);
                        return(TaskDAO.delete(requester, task));
                    }
                    else
                    {
                        return(new Response(task.getTaskId(), "Failed. Launch Exetution activity can't be deleted", task.getHash()));
                    }
                }
                bool isNew           = false;
                bool isChangeAllowed = false;
                int  projectId       = task.getProjectId();
                var  project         = (from p in db.projects
                                        where p.projectId == projectId
                                        select p).First();
                if (ProjectDAO.stageCorrespondence(project.productProjectStage) <= 3)
                {
                    isChangeAllowed = true;
                }
                var t = (dynamic)null;
                if (task.getTaskId() == 0)
                {
                    isNew          = true;
                    t              = db.tasks.Create();
                    t.createdBy    = requester.getUserId();
                    t.creationDate = string.Format("{0:dd/MM/yyyy}", DateTime.Now);
                    t.wasDeleted   = "false";
                    t.reworkCount  = 0;
                    if (!isChangeAllowed)
                    {
                        t.wasInsertedAfterFreezing = "true";
                        t.isFreezed = "true";
                    }
                    else
                    {
                        t.wasInsertedAfterFreezing = "false";
                        t.isFreezed = "false";
                    }
                }
                else
                {
                    isNew = false;
                    t     = db.tasks.Find(task.getTaskId());
                    if (t == null)
                    {
                        return(new Response(task.getTaskId(), "Fail. Result not found", task.getHash()));
                    }
                    if (!isChangeAllowed && t.wasInsertedAfterFreezing.Equals("false"))
                    {
                        t.pWork  = task.getPWork();
                        t.status = task.getStatus();
                        t.hash   = task.getHash();
                        if (!task.getStart().Equals(t.start))
                        {
                            t.newStart = task.getStart();
                        }
                        if (!task.getFinish().Equals(t.finish))
                        {
                            t.newFinish = task.getFinish();
                        }
                        t.criticalActivity    = task.getCriticalActivity();
                        t.activityTitle       = task.getActivityTitle();
                        t.activityDescription = task.getActivityDescription();
                        t.parent      = task.getParent();
                        t.grandParent = task.getGrandParent();
                        t.responsible = task.getResponsible();
                        t.ident       = task.getIdent();
                        db.SaveChanges();
                        return(new Response(task.getTaskId(), "Edited", task.getHash()));
                    }
                }
                t.projectId   = task.getProjectId();
                t.notifyMe    = task.getNotifyMe();
                t.meetingDate = task.getMeetingDate();
                t.product     = task.getProduct();

                /*if (task.getPWork().Equals("100") || task.getStatus().ToUpper().Equals("COMPLETO"))
                 * {
                 *  t.status = "Completo";
                 *  t.pWork = "100";
                 *  t.actualFinishDate = string.Format("{0:dd/MM/yyyy}", DateTime.Now);
                 * }
                 * else
                 * {
                 *  if (!isNew)
                 *  {
                 *      if (!task.getStatus().ToUpper().Equals("COMPLETO") && t.status.ToUpper().Equals("COMPLETO"))
                 *      {
                 *          t.reworkCount = Convert.ToInt32(t.reworkCount) + 1;
                 *      }
                 *  }
                 *  else
                 *  {
                 *      t.reworkCount = task.getReworkCount();
                 *  }
                 *  t.status = task.getStatus();
                 *  t.pWork = task.getPWork();
                 *  t.actualFinishDate = task.getActualFinishDate();
                 * }*/
                if (!isNew)
                {
                    if (!task.getStatus().ToUpper().Equals("COMPLETO") && t.status.ToUpper().Equals("COMPLETO"))
                    {
                        t.reworkCount = Convert.ToInt32(t.reworkCount) + 1;
                        t.status      = task.getStatus();
                        t.pWork       = task.getPWork();
                    }
                    else if (task.getActivityOrigin().ToUpper().Equals("PROJECT"))
                    {
                        t.status = task.getStatus();
                        t.pWork  = task.getPWork();
                    }
                }
                else
                {
                    t.status = task.getStatus();
                    t.pWork  = task.getPWork();
                }
                t.criticalActivity    = task.getCriticalActivity();
                t.activityTitle       = task.getActivityTitle();
                t.activityDescription = task.getActivityDescription();
                t.parent              = task.getParent();
                t.grandParent         = task.getGrandParent();
                t.responsible         = task.getResponsible();
                t.start               = task.getStart();
                t.finish              = task.getFinish();
                t.activityOrigin      = task.getActivityOrigin();
                t.idProjectTask       = task.getIdProjectTask();
                t.idParentProjectTask = task.getIdParentProjectTask();
                t.ident               = task.getIdent();
                t.hash      = task.getHash();
                t.newStart  = task.getNewStart();
                t.newFinish = task.getNewFinish();
                if (isNew)
                {
                    db.tasks.Add(t);
                }
                db.SaveChanges();
                if (isNew)
                {
                    return(new Response(task.getTaskId(), "Created", task.getHash()));
                }
                else
                {
                    return(new Response(task.getTaskId(), "Edited", task.getHash()));
                }
            }
            catch (DbEntityValidationException dbEx)
            {
                Exception raise = dbEx;
                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage);
                        raise = new InvalidOperationException(message, raise);
                    }
                }
                throw raise;
            }
        }
Ejemplo n.º 25
0
 public static List <Dashboard> select(User requester, int taskStatus)
 {
     try
     {
         nova_ataEntities db               = new nova_ataEntities();
         int              userId           = requester.getUserId();
         string           userArea         = requester.getArea();
         string           userAlias        = requester.getAlias();
         List <Dashboard> listOfDashboards = new List <Dashboard>();
         var              projects         = from ta in db.team_allocation
                                             join p in db.projects on ta.projectId equals p.projectId
                                             join u in db.users on ta.userId equals u.userId
                                             where (u.alias == userAlias && ta.userId == u.userId) || (p.leaderOrSubmitter == userId)
                                             group ta by new { p.projectId, p.name, p.projectStatus, p.productProjectStage, p.parentProgramIDNumber, p.parentProgramName } into g
         orderby g.Key.projectId ascending
                          select new { g.Key.projectId, g.Key.name, g.Key.projectStatus, g.Key.productProjectStage, g.Key.parentProgramIDNumber, g.Key.parentProgramName };
         List <string>    listOfIds = new List <string>();
         foreach (var project in projects)
         {
             try
             {
                 if (!listOfIds.Any(y => y == string.Format("{0}?{1}", project.projectId, project.name)))
                 {
                     listOfIds.Add(string.Format("{0}?{1}", project.projectId, project.name));
                 }
                 if (project.parentProgramIDNumber != "0" && !listOfIds.Any(x => x == string.Format("{0}?{1}", project.parentProgramIDNumber, project.parentProgramName)))
                 {
                     listOfIds.Add(string.Format("{0}?{1}", project.parentProgramIDNumber, project.parentProgramName));
                 }
             }
             catch
             {
                 continue;
             }
         }
         var tasks = (dynamic)null;
         foreach (string project in listOfIds)
         {
             Dashboard dashboard = new Dashboard(project);
             int       projectId = dashboard.getProjectId();
             //Somente atividades em andamento ou atrasadas
             if (taskStatus == 1)
             {
                 tasks = from t in db.tasks
                         join p in db.projects on t.projectId equals p.projectId
                         where t.projectId == projectId
                         where t.status.ToUpper() == "ANDAMENTO" || t.status.ToUpper() == "ATRASADO"
                         where t.responsible.Contains(userArea)
                         orderby t.finish ascending
                         select new { tarefas = t, projeto = p };
             }
             //Todas as atividades
             else if (taskStatus == 0)
             {
                 tasks = from t in db.tasks
                         join p in db.projects on t.projectId equals p.projectId
                         where t.projectId == projectId
                         where t.responsible.Contains(userArea)
                         orderby t.finish ascending
                         select new { tarefas = t, projeto = p };
             }
             //Somente atividades completas
             else
             {
                 tasks = from t in db.tasks
                         join p in db.projects on t.projectId equals p.projectId
                         where t.projectId == projectId
                         where t.status.ToUpper() == "COMPLETO"
                         where t.responsible.Contains(userArea)
                         orderby t.finish ascending
                         select new { tarefas = t, projeto = p };
             }
             foreach (var task in tasks)
             {
                 Task t = new Task(task.tarefas.taskId, task.tarefas.projectId, task.tarefas.notifyMe, task.tarefas.meetingDate,
                                   task.tarefas.product, task.tarefas.pWork, task.tarefas.criticalActivity, task.tarefas.activityTitle,
                                   task.tarefas.activityDescription, task.tarefas.parent, task.tarefas.grandParent, task.tarefas.responsible,
                                   task.tarefas.start, task.tarefas.finish, task.tarefas.status, CommentDAO.selectLastComment(task.tarefas.taskId),
                                   task.tarefas.activityOrigin, task.tarefas.idProjectTask, task.tarefas.idParentProjectTask, task.tarefas.ident,
                                   task.tarefas.hash, task.tarefas.delayReason, task.tarefas.delayDescription, requester, task.tarefas.reworkCount,
                                   task.tarefas.actualFinishDate);
                 dashboard.addTaskToList(t);
             }
             if (dashboard.listOfTasks.Count() > 0)
             {
                 listOfDashboards.Add(dashboard);
             }
         }
         return(listOfDashboards);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 26
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);
     }
 }