Ejemplo n.º 1
0
        public string GetDependentDate(int activityid, int projectplanid, string type)
        {
            string dependency = "";

            string DepDate = "";

            ActivityTemplate activity = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.ActivityID == activityid);

            if (activity != null)
            {
                dependency = activity.Dependency;

                ProjectActivityPlan projectactivityplan = ProjectActivityPlanRepository.GetProjectActivityPlans().FirstOrDefault(c => (c.ProjectPlanID == projectplanid && c.TemplateID == dependency));
                if (projectactivityplan != null)
                {
                    if (type == "StartDate")
                    {
                        DepDate = projectactivityplan.StartDate.Value.ToLongDateString();
                    }
                    if (type == "EndDate")
                    {
                        DepDate = projectactivityplan.EndDate.Value.ToLongDateString();
                    }
                }
            }


            return(DepDate);
        }
Ejemplo n.º 2
0
        private static ActivityTemplate BuildActivityTemplate(XElement element)
        {
            var activityTemplate     = new ActivityTemplate();
            var activityTemplateId   = Convert.ToInt32(element.Attribute("id").Value);
            var activityTemplateName = element.Element("Name").Value;

            activityTemplate.ActivityTemplateId = activityTemplateId;
            activityTemplate.Name         = activityTemplateName;
            activityTemplate.RequiredRole = new ApproverRole()
            {
                Id          = "role123",
                Name        = "测试角色",
                Description = "仅用于测试"
            };
            var actionElements = element.Elements("Actions");

            foreach (var actionElem in actionElements.Elements("Action"))
            {
                var operation = (OperationCode)Enum.Parse(typeof(OperationCode), actionElem.Attribute("operationCode").Value);
                var transitTo = 0;
                if (actionElem.Attribute("transit") != null)
                {
                    transitTo = Convert.ToInt32(actionElem.Attribute("transit").Value);
                }
                var action = new Action(operation, transitTo);
                activityTemplate.Actions.Add(action);
            }
            return(activityTemplate);
        }
        public async Task ActivityTemplate200_PutObject_Can_Add_ActivityTemplate()
        {
            AddParents();
            await RequestSessionAndAssert();

            var handler = _client.Handler <IStoreCustomer>();
            var uri     = ActivityTemplate.GetUri();

            var dataObject = CreateDataObject(uri, ActivityTemplate);

            // Get Object Expecting it Not to Exist
            await GetAndAssert(handler, uri, Energistics.Etp.EtpErrorCodes.NotFound);

            // Put Object
            await PutAndAssert(handler, dataObject);

            // Get Object
            var args = await GetAndAssert(handler, uri);

            // Check Data Object XML
            Assert.IsNotNull(args?.Message.DataObject);
            var xml = args.Message.DataObject.GetString();

            var result = Parse <ActivityTemplate>(xml);

            Assert.IsNotNull(result);
        }
        public async Task <IActionResult> Edit(int id, [Bind("Budget,ID,Name,Description")] ActivityTemplate activityTemplate)
        {
            if (id != activityTemplate.ID)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(activityTemplate);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ActivityTemplateExists(activityTemplate.ID))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(activityTemplate));
        }
Ejemplo n.º 5
0
        protected virtual void SetupView()
        {
            var activity = BindingContext as BotActivity;

            if (activity == null)
            {
                return;
            }
            //var view = (View)Activator.CreateInstance (typeof (MessageView));
            var view = ActivityTemplate?.CreateContent(activity, this) as View ?? new Label();

            var messageView = view as IMessageContext;

            if (messageView != null)
            {
                messageView.IsFromMe = activity.IsFromMe;
            }

            view.BindingContext = activity;

            Frame.Content            = view;
            leftPaddingColumn.Width  = new GridLength(activity.IsFromMe ? LargePadding : SmallPadding);
            rightPaddingColumn.Width = new GridLength(activity.IsFromMe ? SmallPadding : LargePadding);
            Frame.BackgroundColor    = activity.IsFromMe ?  OutgoingColor : IncomingColor;
        }
Ejemplo n.º 6
0
        public IEnumerable <ActivityModel> GetActivitiesbyID(int projectid, int templateid)
        {
            List <ActivityModel> ActivityModelList = new List <ActivityModel>();
            IEnumerable <ProjectActivityPlan> projectactivityplanlist = new List <ProjectActivityPlan>();

            projectactivityplanlist = ProjectActivityPlanRepository.GetProjectActivityPlans().Where(c => c.ProjectID == projectid && c.ParentID == templateid.ToString() && c.Task == null);

            foreach (var projectplan in projectactivityplanlist)
            {
                int    value;
                string strActivity;
                if (int.TryParse(projectplan.Activity, out value))
                {
                    ActivityTemplate activity = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.ActivityID == value);
                    strActivity = activity.Activity;
                }
                else
                {
                    strActivity = projectplan.Activity;
                }

                ActivityModelList.Add(new ActivityModel
                {
                    ActivityID = projectplan.TemplateID,
                    Activity   = strActivity
                });
            }

            return(ActivityModelList);
        }
Ejemplo n.º 7
0
        public async Task <IActionResult> Edit(Guid id, [Bind("Description,KindergarterId,Id")] ActivityTemplate activityTemplate)
        {
            if (id != activityTemplate.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(activityTemplate);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ActivityTemplateExists(activityTemplate.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["KindergarterId"] = new SelectList(_context.Kindergarters, "Id", "Id", activityTemplate.KindergarterId);
            return(View(activityTemplate));
        }
Ejemplo n.º 8
0
        public async Task ActivityTemplate200_PutObject_Can_Add_ActivityTemplate()
        {
            AddParents();
            await RequestSessionAndAssert();

            var handler = _client.Handler <IStoreCustomer>();
            var uri     = ActivityTemplate.GetUri();

            var dataObject = CreateDataObject(uri, ActivityTemplate);

            // Get Object
            var args = await GetAndAssert(handler, uri);

            // Check for message flag indicating No Data
            Assert.IsNotNull(args?.Header);
            Assert.AreEqual((int)MessageFlags.NoData, args.Header.MessageFlags);

            // Put Object
            await PutAndAssert(handler, dataObject);

            // Get Object
            args = await GetAndAssert(handler, uri);

            // Check Data Object XML
            Assert.IsNotNull(args?.Message.DataObject);
            var xml = args.Message.DataObject.GetString();

            var result = Parse <ActivityTemplate>(xml);

            Assert.IsNotNull(result);
        }
Ejemplo n.º 9
0
        public async Task <int> AddProjectActivityPlan(ProjectActivityPlan projectactivityplan)
        {
            string mailSent    = "";
            string MailSubject = "Delay in Activity Completion";
            string MailBody    = "Following Activity is delayed to complete as per plan.";

            int insertedprojectplanid = 0;
            int projectplanid         = 0;

            if (!IsProjectPlanExist(projectactivityplan.ProjectID))
            {
                projectplanid = await ProjectPlanRepository.AddProjectPlan(new ProjectPlan { ProjectID = projectactivityplan.ProjectID, ProjectPlanStatus = "Created", ReopenReason = "", CreatedDate = projectactivityplan.CreatedDate, CreatedBy = projectactivityplan.CreatedBy });
            }
            else
            {
                projectplanid = projectactivityplan.ProjectPlanID;
            }
            if (!IsActivitiesExist(projectplanid, projectactivityplan.Activity))
            {
                if (!IsParentExist(projectplanid, projectactivityplan.ParentID))
                {
                    string strTemplateID = this.GetTemplateID(projectplanid, projectactivityplan.Activity, projectactivityplan.ParentID, true);
                    insertedprojectplanid = await ProjectActivityPlanRepository.AddProjectActivityPlan(new ProjectActivityPlan { ProjectID = projectactivityplan.ProjectID, ProjectPlanID = projectplanid, Activity = ppParentID.ToString(), TemplateID = strTemplateID, ParentID = "0", Dependency = "", StartDate = projectactivityplan.StartDate, EndDate = projectactivityplan.EndDate, ComplitionDate = projectactivityplan.ComplitionDate, Status = projectactivityplan.Status, CreatedDate = projectactivityplan.CreatedDate, CreatedBy = projectactivityplan.CreatedBy });
                }
                insertedprojectplanid = await ProjectActivityPlanRepository.AddProjectActivityPlan(new ProjectActivityPlan { ProjectID = projectactivityplan.ProjectID, ProjectPlanID = projectplanid, Activity = projectactivityplan.Activity, TemplateID = this.GetTemplateID(projectplanid, projectactivityplan.Activity, projectactivityplan.ParentID, false), ParentID = projectactivityplan.ParentID, Dependency = projectactivityplan.Dependency, StartDate = projectactivityplan.StartDate, EndDate = projectactivityplan.EndDate, ComplitionDate = projectactivityplan.ComplitionDate, Status = projectactivityplan.Status, CreatedDate = projectactivityplan.CreatedDate, CreatedBy = projectactivityplan.CreatedBy });

                if (insertedprojectplanid > 0)
                {
                    ProjectActivityPlan objprojectactivityplan = ProjectActivityPlanRepository.GetProjectActivityPlans().FirstOrDefault(c => c.ProjectID == projectactivityplan.ProjectID && c.ProjectPlanID == projectplanid && c.TemplateID == projectactivityplan.ParentID);
                    if (objprojectactivityplan != null)
                    {
                        if (projectactivityplan.EndDate > objprojectactivityplan.EndDate)
                        {
                            objprojectactivityplan.EndDate = projectactivityplan.EndDate;
                            int updateprojectplan = await ProjectActivityPlanRepository.UpdateProjectActivityPlan(objprojectactivityplan);
                        }
                    }

                    if (projectactivityplan.EndDate < DateTime.Now)
                    {
                        int    value;
                        string strActivity;
                        if (int.TryParse(projectactivityplan.Activity, out value))
                        {
                            ActivityTemplate activity = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.ActivityID == value);
                            strActivity = activity.Activity;
                        }
                        else
                        {
                            strActivity = projectactivityplan.Activity;
                        }

                        MailBody = MailBody + "<br/><br/>" + "<b>Activity Name</b> : " + strActivity;
                        mailSent = await Mail.SendMailActivityPlan(projectactivityplan.ProjectID, "Delay", MailSubject, MailBody);
                    }
                }
            }
            return(projectplanid > 0 ? projectplanid : 0);
        }
        public async Task ActivityTemplate200_PutObject_Can_Update_ActivityTemplate()
        {
            AddParents();
            await RequestSessionAndAssert();

            var handler = _client.Handler <IStoreCustomer>();
            var uri     = ActivityTemplate.GetUri();

            // Add a ExtensionNameValue to Data Object
            var envName = "TestPutObject";
            var env     = DevKit.ExtensionNameValue(envName, envName);

            ActivityTemplate.ExtensionNameValue = new List <ExtensionNameValue>()
            {
                env
            };

            var dataObject = CreateDataObject(uri, ActivityTemplate);

            // Get Object Expecting it Not to Exist
            await GetAndAssert(handler, uri, Energistics.Etp.EtpErrorCodes.NotFound);

            // Put Object for Add
            await PutAndAssert(handler, dataObject);

            // Get Added Object
            var args = await GetAndAssert(handler, uri);

            // Check Added Data Object XML
            Assert.IsNotNull(args?.Message.DataObject);
            var xml = args.Message.DataObject.GetString();

            var result = Parse <ActivityTemplate>(xml);

            Assert.IsNotNull(result);
            Assert.IsNotNull(result.ExtensionNameValue.FirstOrDefault(e => e.Name.Equals(envName)));

            // Remove Comment from Data Object
            result.ExtensionNameValue.Clear();

            var updateDataObject = CreateDataObject(uri, result);

            // Put Object for Update
            await PutAndAssert(handler, updateDataObject);

            // Get Updated Object
            args = await GetAndAssert(handler, uri);

            // Check Added Data Object XML
            Assert.IsNotNull(args?.Message.DataObject);
            var updateXml = args.Message.DataObject.GetString();

            result = Parse <ActivityTemplate>(updateXml);
            Assert.IsNotNull(result);

            // Test Data Object overwrite
            Assert.IsNull(result.ExtensionNameValue.FirstOrDefault(e => e.Name.Equals(envName)));
        }
Ejemplo n.º 11
0
        public async Task <int> AddActivity(ActivityTemplate activities)
        {
            db.ActivityTemplates.Add(activities);
            await db.SaveChangesAsync();

            int insertedActivitiesid = activities.ActivityID;

            return(insertedActivitiesid);
        }
 protected override void PrepareData()
 {
     ActivityTemplate = new ActivityTemplate
     {
         SchemaVersion = EtpUris.GetUriFamily(typeof(ActivityTemplate)).Version,
         Uuid          = DevKit.Uid(),
         Citation      = DevKit.Citation("ActivityTemplate")
     };
 }
Ejemplo n.º 13
0
 public IHttpActionResult PostActivity(ActivityTemplate activities)
 {
     if (!ModelState.IsValid)
     {
         return(BadRequest("Invalid data."));
     }
     Task.Run(async() => await _Activities.AddActivity(activities));
     return(Ok());
 }
Ejemplo n.º 14
0
        public async Task <IActionResult> Create([Bind("Budget,ID,Name,Description,TaskTemplateID")] ActivityTemplate activityTemplate)
        {
            if (ModelState.IsValid)
            {
                _context.Add(activityTemplate);
                await _context.SaveChangesAsync();

                return(RedirectToAction("Edit", "TaskTemplates", new { id = activityTemplate.TaskTemplateID }));
            }
            return(View(activityTemplate));
        }
        public async Task ActivityTemplate200_GetResources_Can_Get_All_ActivityTemplate_Resources()
        {
            AddParents();
            DevKit.AddAndAssert(ActivityTemplate);
            await RequestSessionAndAssert();

            var uri       = ActivityTemplate.GetUri();
            var parentUri = uri.Parent;

            var folderUri = parentUri.Append(uri.ObjectType);

            await GetResourcesAndAssert(folderUri);
        }
        private void ActivityInfoManage_DataContextChanged(object sender, DependencyPropertyChangedEventArgs e)
        {
            ActivityTemplate activity = e.NewValue as ActivityTemplate;

            activity.PropertyChanged += (obj, arg) =>
            {
                this.buttonSaveActivity.IsEnabled = true;
            };
            if (activity != null)
            {
                (sender as ActivityInfoManage).textBlockActivityType.Text = CO_IA.Client.Utility.GetActivityTypeName(activity.ActivityType);
            }
            this.buttonSaveActivity.IsEnabled = activity.IsNew;
        }
Ejemplo n.º 17
0
        public string GetTemplateID(int projectplanid, string activity, string ParentID, bool IsParent)
        {
            string TemplateID = "";

            if (IsParent)
            {
                ActivityTemplate activitytemplate = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.TemplateID == ParentID);
                if (activitytemplate != null)
                {
                    TemplateID = activitytemplate.TemplateID;
                    ppParentID = activitytemplate.ActivityID;
                }
            }
            else
            {
                int value;
                if (int.TryParse(activity, out value))
                {
                    ActivityTemplate activitytemplate = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.ActivityID == value);
                    if (activitytemplate != null)
                    {
                        TemplateID = activitytemplate.TemplateID;
                    }
                }
                else
                {
                    int ParentRecordCount             = 0;
                    ActivityTemplate activitytemplate = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.TemplateID == ParentID);

                    if (activitytemplate != null)
                    {
                        if (activitytemplate.Activity != "Others")
                        {
                            ParentRecordCount = ActivitiesRepository.GetActivities().Count(p => p.ParentID.ToString() == ParentID);
                        }
                    }
                    if (ParentRecordCount > 0)
                    {
                        ParentRecordCount = ParentRecordCount - 1;
                    }


                    int RecordCount = ProjectActivityPlanRepository.GetProjectActivityPlans().Count(p => p.ParentID == ParentID && p.ProjectPlanID == projectplanid && isNumber(p.Activity) == false);
                    TemplateID = ParentID + "." + (ParentRecordCount + RecordCount + 1);
                }
            }

            return(TemplateID);
        }
Ejemplo n.º 18
0
        public async Task <IActionResult> Create([Bind("Description,KindergarterId,Id")] ActivityTemplate activityTemplate)
        {
            if (ModelState.IsValid)
            {
                activityTemplate.Id = Guid.NewGuid();
                _context.Add(activityTemplate);
                await _context.SaveChangesAsync();

                TempData["SuccessfulMessage"] = "La plantilla se ha creado satisfactoriamente";

                return(RedirectToAction(nameof(Details), activityTemplate));
            }
            ViewData["KindergarterId"] = new SelectList(_context.Kindergarters, "Id", "Id", activityTemplate.KindergarterId);
            return(View(activityTemplate));
        }
Ejemplo n.º 19
0
        public async Task <Rating> CreateAsync(RatingStatus ratingStatus, ActivityTemplate activityTemplate, User owner)
        {
            var rating = activityTemplate.Ratings.FirstOrDefault(r => r.OwnerId == owner.Id && r.AbstractActivityId == activityTemplate.Id);

            if (rating != null)
            {
                rating.EditRating(ratingStatus, owner.Id);
            }
            else
            {
                rating = await CreateAsync(Rating.Create(ratingStatus, activityTemplate, owner));
            }

            return(rating);
        }
Ejemplo n.º 20
0
        public void EditDescriptions(ActivityTemplate activityTemplate, long[] descriptionIds, long editUserId)
        {
            var activityTemplateDescriptions = activityTemplate.Descriptions;

            foreach (var activityTemplateDescription in activityTemplateDescriptions)
            {
                for (var i = 0; i < descriptionIds.Length; i++)
                {
                    if (descriptionIds[i] == activityTemplateDescription.Id)
                    {
                        activityTemplateDescription.EditPriority(i, editUserId);
                    }
                }
            }
        }
Ejemplo n.º 21
0
        public void TestSetUp()
        {
            Logger.Debug($"Executing {TestContext.TestName}");
            DevKit = new DevKit200Aspect(TestContext);

            ActivityTemplate = new ActivityTemplate
            {
                SchemaVersion = EtpUris.GetUriFamily(typeof(ActivityTemplate)).Version,

                Uuid     = DevKit.Uid(),
                Citation = DevKit.Citation("ActivityTemplate")
            };

            BeforeEachTest();
            OnTestSetUp();
        }
Ejemplo n.º 22
0
        public async Task <ActivityTemplate> CreateAsync(ActivityTemplate activityTemplate)
        {
            if (activityTemplate.ReferenceId != null)
            {
                var activityTemplateWithReferenceId = await _abstractActivityRepository.GetAll().OfType <ActivityTemplate>().FirstOrDefaultAsync(at => at.ReferenceId == activityTemplate.ReferenceId);

                if (activityTemplateWithReferenceId != null)
                {
                    return(activityTemplateWithReferenceId);
                }
            }

            activityTemplate.Id = await _abstractActivityRepository.InsertAndGetIdAsync(activityTemplate);

            return(activityTemplate);
        }
        public async Task <EntityDto <Guid> > CreateActivityTemplate(CreateActivityTemplateInput input)
        {
            var currentUser = await GetCurrentUserAsync();

            var location = input.LocationId.HasValue ? await _locationManager.GetLocationAsync(input.LocationId.Value) : null;

            var tags = await _tagManager.GetTags(input.TagTexts);

            var activityTemplate = await _activityTemplateManager.CreateAsync(ActivityTemplate.Create(
                                                                                  input.Name,
                                                                                  location,
                                                                                  input.ReferenceTimeSlots.Select(timeSlot => ActivityTemplateReferenceTimeSlot.Create(timeSlot.StartTime, timeSlot.EndTime)).ToList(),
                                                                                  tags,
                                                                                  currentUser,
                                                                                  input.ReferenceId
                                                                                  ));

            return(new EntityDto <Guid>(activityTemplate.Id));
        }
        private void CheckIfInSyncWithDd(ActivityTemplate activityTemplateService, int count)
        {
            ActivityTemplateDO[] templates;

            using (var uow = ObjectFactory.GetInstance <IUnitOfWork>())
            {
                templates = uow.ActivityTemplateRepository.GetAll().ToArray();
            }

            var templatesFromServices = activityTemplateService.GetAll();

            foreach (var templatesFromService in templatesFromServices)
            {
                CheckIntegrity(templatesFromService);
            }

            Assert.AreEqual(count, templatesFromServices.Length);

            CompareCollections(templates, templatesFromServices);
        }
Ejemplo n.º 25
0
        internal void Reload()
        {
            ActivityTemplate template = this.DataContext as ActivityTemplate;

            if (template != null)
            {
                PT_BS_Service.Client.Framework.BeOperationInvoker.Invoke <I_CO_IA.PlanDatabase.I_CO_IA_Template>(channel =>
                {
                    var organizations = channel.GetOrganizations(template.Guid);
                    var orgTreeView   = TreeNode <OrganizationTemplate> .CreateTreeNodes(organizations, org => string.IsNullOrWhiteSpace(org.ParentGuid), (org, node) =>
                    {
                        return(org.ParentGuid == node.Value.Guid);
                    });
                    this.treeViewOrg.ItemsSource = orgTreeView;
                    if (orgTreeView.Count > 0)
                    {
                        orgTreeView[0].IsSelected = true;
                    }
                });
            }
        }
Ejemplo n.º 26
0
        public int ValidateActivity(int projectplanid, int activityid)
        {
            string dependency   = "";
            int    activityStat = 0;

            if (activityid == 0)
            {
                return(activityStat);
            }

            ProjectActivityPlan projectactivityplan = new ProjectActivityPlan();

            projectactivityplan = ProjectActivityPlanRepository.GetProjectActivityPlans().FirstOrDefault(c => (c.ProjectPlanID == projectplanid && c.Activity == activityid.ToString()));
            if (projectactivityplan != null)
            {
                activityStat = 1;
            }

            //activityid = activityid - 1;

            ActivityTemplate activity = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.ActivityID == activityid);

            if (activity != null)
            {
                dependency = activity.Dependency;
            }
            if (dependency != "")
            {
                projectactivityplan = ProjectActivityPlanRepository.GetProjectActivityPlans().FirstOrDefault(c => (c.ProjectPlanID == projectplanid && c.TemplateID == dependency));
                if (projectactivityplan == null)
                {
                    activityStat = 2;
                }
            }

            return(activityStat);
        }
Ejemplo n.º 27
0
        public bool IsParentExist(int projectplanid, string ParentID)
        {
            bool   IsParentExist = false;
            string templateID    = "";

            ActivityTemplate activitytemplate = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.TemplateID == ParentID);

            if (activitytemplate != null)
            {
                templateID = activitytemplate.TemplateID;
            }
            ProjectActivityPlan projectactivityplan = ProjectActivityPlanRepository.GetProjectActivityPlans().FirstOrDefault(c => (c.ProjectPlanID == projectplanid && c.TemplateID == templateID));

            if (projectactivityplan != null)
            {
                IsParentExist = true;
            }
            else
            {
                ppParentID = Convert.ToInt32(templateID);
            }

            return(IsParentExist);
        }
Ejemplo n.º 28
0
        //Navrhovane hodnotenie/ Zapisane hodnotenie v databaze
        // nakolko, to co navrhuje system sa moze/nemusi lisit od reality
        private void LoadTextBoxes()
        {
            try
            {
                MaxPtsBox.Text    = 0.ToString();
                SemPtsBox.Text    = 0.ToString();
                LecPtsBox.Text    = 0.ToString();
                TotalPtsBox.Text  = 0.ToString();
                MissedLecBox.Text = 0.ToString();
                MissedSemBox.Text = 0.ToString();

                using (StudentDBDataContext con = new StudentDBDataContext(conn_str))
                {
                    double maxPoints      = 0;
                    double?acquiredPoints = 0;
                    double?bonusSem       = 0;
                    double?bonusLec       = 0;
                    if (StudentGrid.Rows.Count <= 0)
                    {
                        MessageBox.Show("Nenašiel sa žiaden študent.");
                        this.Close();
                    }

                    var selectedStudentId = (int)StudentGrid.CurrentRow.Cells[0].Value;

                    if (materialRadioButton1.Checked)
                    {
                        IQueryable <Activity> allActivities       = null;
                        ActivityTemplate      bonusPtsLectureTemp = null;
                        ActivityTemplate      bonusPtsSeminarTemp = null;;
                        IQueryable <Activity> bonusPtsSeminar     = null;
                        IQueryable <Activity> bonusPtsLecture     = null;

                        if (currentUser.PointsForActSem.HasValue)
                        {
                            bonusPtsSeminarTemp = con.GetTable <ActivityTemplate>().FirstOrDefault(x => x.Id == currentUser.PointsForActSem);
                            bonusPtsSeminar     = con.GetTable <Activity>().Where(x => x.ActivityName == bonusPtsSeminarTemp.ActivityName && x.IdSkupina == group.Id && x.IdStudent == selectedStudentId).DefaultIfEmpty();
                        }
                        if (currentUser.PointsForActLec.HasValue)
                        {
                            bonusPtsLectureTemp = con.GetTable <ActivityTemplate>().FirstOrDefault(x => x.Id == currentUser.PointsForActLec);
                            bonusPtsLecture     = con.GetTable <Activity>().Where(x => x.ActivityName == bonusPtsLectureTemp.ActivityName && x.IdSkupina == group.Id && x.IdStudent == selectedStudentId).DefaultIfEmpty();
                        }

                        var totalAttendance = con.GetTable <TotalAttendance>().Where(x => x.IdStudent == selectedStudentId).FirstOrDefault();

                        if (bonusPtsSeminarTemp == null)
                        {
                            allActivities = con.GetTable <Activity>().Where(x => x.ActivityName != bonusPtsLectureTemp.ActivityName && x.IdStudent == selectedStudentId);
                        }

                        if (bonusPtsLectureTemp == null)
                        {
                            allActivities = con.GetTable <Activity>().Where(x => x.ActivityName != bonusPtsSeminarTemp.ActivityName && x.IdStudent == selectedStudentId);
                        }
                        if (bonusPtsSeminarTemp == null && bonusPtsLectureTemp == null)
                        {
                            allActivities = con.GetTable <Activity>().Where(x => x.IdStudent == selectedStudentId);
                        }
                        if (bonusPtsSeminarTemp != null && bonusPtsLectureTemp != null)
                        {
                            allActivities = con.GetTable <Activity>().Where(x => x.ActivityName != bonusPtsSeminarTemp.ActivityName && x.ActivityName != bonusPtsLectureTemp.ActivityName &&
                                                                            x.IdStudent == selectedStudentId);
                        }

                        if (allActivities.Count() <= 0 || allActivities == null)
                        {
                            if (bonusPtsSeminar != null || bonusPtsSeminar.Count() > 0)
                            {
                                foreach (var seminar in bonusPtsSeminar)
                                {
                                    bonusSem += seminar.Hodnotenie;
                                }
                            }
                            else
                            {
                                bonusSem += 0;
                            }

                            if (bonusPtsLecture != null && bonusPtsLecture.Count() > 0)
                            {
                                foreach (var lecture in bonusPtsLecture)
                                {
                                    bonusLec += lecture.Hodnotenie;
                                }
                            }
                            else
                            {
                                bonusLec += 0;
                            }

                            SemPtsBox.Text   = bonusSem.ToString();
                            LecPtsBox.Text   = bonusLec.ToString();
                            TotalPtsBox.Text = (bonusSem + bonusLec).ToString();
                            return;
                        }

                        foreach (var activity in allActivities)
                        {
                            maxPoints      += activity.MaxPoints;
                            acquiredPoints += activity.Hodnotenie;
                        }

                        if (bonusPtsSeminar != null || bonusPtsSeminar.Count() > 0)
                        {
                            foreach (var seminar in bonusPtsSeminar)
                            {
                                bonusSem += seminar.Hodnotenie;
                            }
                        }
                        else
                        {
                            bonusSem += 0;
                        }

                        if (bonusPtsLecture != null && bonusPtsLecture.Count() > 0)
                        {
                            foreach (var lecture in bonusPtsLecture)
                            {
                                bonusLec += lecture.Hodnotenie;
                            }
                        }
                        else
                        {
                            bonusLec += 0;
                        }

                        double?totalPoints = acquiredPoints + bonusSem + bonusLec;

                        MaxPtsBox.Text    = maxPoints.ToString();
                        SemPtsBox.Text    = bonusSem.ToString();
                        LecPtsBox.Text    = bonusLec.ToString();
                        TotalPtsBox.Text  = totalPoints.ToString();
                        MissedLecBox.Text = totalAttendance.TotalAbsentLecture.ToString();
                        MissedSemBox.Text = totalAttendance.TotalAbsentSeminar.ToString();

                        Grade(totalPoints, currentUser);
                    }
                    else
                    {
                        var finalGrade = con.GetTable <FinalGrade>().Where(x => x.IdSkupina == group.Id && x.IdStudent == selectedStudentId).FirstOrDefault();

                        MaxPtsBox.Text     = finalGrade.MaxPts.ToString();
                        SemPtsBox.Text     = finalGrade.ActivitySemPoints.ToString();
                        LecPtsBox.Text     = finalGrade.ActivityLectPoints.ToString();
                        TotalPtsBox.Text   = finalGrade.GotPoints.ToString();
                        FinalGradeBox.Text = finalGrade.Grade;
                    }
                }
            }
            catch (Exception ex)
            {
                // MessageBox.Show(ex.ToString());
                Logger newLog = new Logger();
                newLog.LogError(ex);
            }
        }
Ejemplo n.º 29
0
        public IEnumerable <ProjectActivityPlanModel> GetProjectActivityPlansbyID(int projectid)
        {
            IEnumerable <ProjectActivityPlan> projectactivityplanlist = new List <ProjectActivityPlan>();
            List <ProjectActivityPlanModel>   ProjectPlanModelList    = new List <ProjectActivityPlanModel>();

            projectactivityplanlist = ProjectActivityPlanRepository.GetProjectActivityPlans().Where(c => c.ProjectID == projectid);
            foreach (ProjectActivityPlan projectplan in projectactivityplanlist)
            {
                if (projectplan.Activity != "")
                {
                    ActivityTemplate activitytemplate = ActivitiesRepository.GetActivities().FirstOrDefault(c => c.ActivityID.ToString() == projectplan.Activity);
                    if (activitytemplate != null)
                    {
                        string strActivity = "";
                        int    value;
                        if (int.TryParse(projectplan.Activity, out value))
                        {
                            strActivity = activitytemplate.Activity;
                        }
                        else
                        {
                            strActivity = projectplan.Activity;
                        }
                        DateTime?SDate     = null;
                        DateTime?EDate     = null;
                        DateTime?CompDate  = null;
                        string   strStatus = "";
                        if (activitytemplate.TemplateID != "13")
                        {
                            SDate     = projectplan.StartDate;
                            EDate     = projectplan.EndDate;
                            CompDate  = projectplan.ComplitionDate;
                            strStatus = projectplan.Status;
                        }

                        ProjectPlanModelList.Add(new ProjectActivityPlanModel
                        {
                            ProjectActivityPlanID = projectplan.ProjectActivityPlanID,
                            ProjectPlanID         = projectplan.ProjectPlanID,
                            Activity       = strActivity,
                            SrNo           = activitytemplate.TemplateID,
                            ParentID       = activitytemplate.ParentID.ToString(),
                            Dependency     = projectplan.Dependency,
                            StartDate      = SDate,
                            EndDate        = EDate,
                            ComplitionDate = CompDate,
                            Status         = strStatus
                        });
                    }
                    else
                    {
                        ProjectPlanModelList.Add(new ProjectActivityPlanModel
                        {
                            ProjectActivityPlanID = projectplan.ProjectActivityPlanID,
                            ProjectPlanID         = projectplan.ProjectPlanID,
                            Activity       = projectplan.Activity,
                            SrNo           = projectplan.TemplateID,
                            Task           = projectplan.Task,
                            ParentID       = projectplan.ParentID,
                            Dependency     = projectplan.Dependency,
                            StartDate      = projectplan.StartDate,
                            EndDate        = projectplan.EndDate,
                            ComplitionDate = projectplan.ComplitionDate,
                            Status         = projectplan.Status
                        });
                    }
                }
            }
            return(ProjectPlanModelList.OrderBy(c => decimal.Parse(c.SrNo)));
        }
Ejemplo n.º 30
0
        public async Task <ActivityTemplate> FetchbyDocumentById(int activitiesid)
        {
            ActivityTemplate Activities = await db.ActivityTemplates.FindAsync(activitiesid);

            return(Activities);
        }