Exemple #1
0
        private List <ChangesInfo> GetChangedData(tableChanges <modelMobility> changes)
        {
            var changeInfos = new List <ChangesInfo>();

            foreach (long changedid in changes.changedIDs)
            {
                var objacc = local_dataActivity.getMobility(changedid);
                var objsql = sql_dataActivity.getMobility(changedid);

                var varactacc = local_dataProject.getProjectActivityVariation(objacc.ActivityVariation);
                var varactsql = sql_dataProject.getProjectActivityVariation(objsql.ActivityVariation);

                var varacc = local_dataProject.getProjectVariation(varactacc.ProjectVariation);
                var varsql = sql_dataProject.getProjectVariation(varactsql.ProjectVariation);
                var actacc = local_dataProject.getProjectActivity(varactacc.ProjectActivity);
                var actsql = sql_dataProject.getProjectActivity(varactsql.ProjectActivity);
                var prjacc = local_dataProject.getProject(varacc.ProjectID);
                var prjsql = sql_dataProject.getProject(varsql.ProjectID);

                var ctracc = local_dataLOV.getCountry(objacc.CountryOfOrigin);
                var ctrsql = sql_dataLOV.getCountry(objsql.CountryOfOrigin);

                string acc_desc = prjacc.GetTitleInfo() + " / " + actacc.Title + " / " + varacc.Title + " / " + varactacc.CityOfDestination + " - " + varactacc.StudyVisit + " / " + ctracc.Country;
                string sql_desc = prjsql.GetTitleInfo() + " / " + actsql.Title + " / " + varsql.Title + " / " + varactsql.CityOfDestination + " - " + varactsql.StudyVisit + " / " + ctrsql.Country;

                var inf = new ChangesInfo(changedid, "Project Activity Variation Mobility", acc_desc, sql_desc, objacc.UpdatedDate, objsql.UpdatedDate, objacc.UpdatedDate > objsql.UpdatedDate, false, false);
                changeInfos.Add(inf);
            }
            return(changeInfos);
        }
Exemple #2
0
        private List <ChangesInfo> GetChangedData(tableChanges <modelProjectVariationOrganization> changes)
        {
            var changeInfos = new List <ChangesInfo>();

            foreach (long changedid in changes.changedIDs)
            {
                var objacc = local_dataProject.getProjectVariationOrganization(changedid);
                var objsql = sql_dataProject.getProjectVariationOrganization(changedid);

                var orgacc = local_dataOrganization.getOrganization(objacc.Organization);
                var orgsql = sql_dataOrganization.getOrganization(objsql.Organization);

                var varacc = local_dataProject.getProjectVariation(objacc.ProjectVariation);
                var varsql = sql_dataProject.getProjectVariation(objsql.ProjectVariation);
                var prjacc = local_dataProject.getProject(varacc.ProjectID);
                var prjsql = sql_dataProject.getProject(varsql.ProjectID);

                string acc_desc = prjacc.GetTitleInfo() + " / " + varacc.Title + " / " + orgacc.FriendlyName + " - " + objacc.OrganizationOrder;
                string sql_desc = prjsql.GetTitleInfo() + " / " + varsql.Title + " / " + orgsql.FriendlyName + " - " + objsql.OrganizationOrder;

                var inf = new ChangesInfo(changedid, "Project Activity Variation Organization", acc_desc, sql_desc, objacc.UpdatedDate, objsql.UpdatedDate, objacc.UpdatedDate > objsql.UpdatedDate, false, false);
                changeInfos.Add(inf);
            }
            return(changeInfos);
        }
Exemple #3
0
        private void LoadChanges()
        {
            changedLanguages = new tableChanges <modelLanguage>(sql_dataLOV.getLanguages, local_dataLOV.getLanguages);
            ProgressBarAdd();
            changedCountries = new tableChanges <modelCountry>(sql_dataLOV.getCountries, local_dataLOV.getCountries);
            ProgressBarAdd();
            changedDistBands = new tableChanges <modelDistanceBand>(sql_dataLOV.getDistanceBands, local_dataLOV.getDistanceBands);
            ProgressBarAdd();
            changedNatAgencies = new tableChanges <modelNationalAgency>(sql_dataLOV.getNationalAgencies, local_dataLOV.getNationalAgencies);
            ProgressBarAdd();
            changedOrgTypes = new tableChanges <modelOrganizationType>(sql_dataLOV.getOrganizationTypes, local_dataLOV.getOrganizationTypes);
            ProgressBarAdd();
            changedRoles = new tableChanges <modelRole>(sql_dataLOV.getRoles, local_dataLOV.getRoles);
            ProgressBarAdd();
            changedTopics = new tableChanges <modelTopic>(sql_dataLOV.getTopics, local_dataLOV.getTopics);
            ProgressBarAdd();
            changedClients = new tableChanges <modelClient>(sql_dataLOV.getClients, local_dataLOV.getClients);
            ProgressBarAdd();

            changedPerson = new tableChanges <modelPerson>(sql_dataPerson.getPersons, local_dataPerson.getPersons);
            ProgressBarAdd();

            changedOrganization = new tableChanges <modelOrganization>(sql_dataOrganization.getOrganizations, local_dataOrganization.getOrganizations);
            ProgressBarAdd();

            changedProjectActivity = new tableChanges <modelProjectActivity>(sql_dataProject.getProjectActivities, local_dataProject.getProjectActivities);
            ProgressBarAdd();
            changedProjActVariation = new tableChanges <modelProjectActivityVariation>(sql_dataProject.getProjectActivityVariations, local_dataProject.getProjectActivityVariations);
            ProgressBarAdd();
            changedProjects = new tableChanges <modelProject>(sql_dataProject.getProjects, local_dataProject.getProjects);
            ProgressBarAdd();
            changedProjTopics = new tableChanges <modelProjectTopic>(sql_dataProject.getProjectTopics, local_dataProject.getProjectTopics);
            ProgressBarAdd();
            changedProjVariationOrg = new tableChanges <modelProjectVariationOrganization>(sql_dataProject.getProjectVariationOrganizations, local_dataProject.getProjectVariationOrganizations);
            ProgressBarAdd();
            changedProjVariation = new tableChanges <modelProjectVariation>(sql_dataProject.getProjectVariations, local_dataProject.getProjectVariations);
            ProgressBarAdd();

            changedActivityTypes = new tableChanges <modelActivityType>(sql_dataActivity.getActivityTypes, local_dataActivity.getActivityTypes);
            ProgressBarAdd();
            changedMobility = new tableChanges <modelMobility>(sql_dataActivity.getMobilities, local_dataActivity.getMobilities);
            ProgressBarAdd();
        }
Exemple #4
0
        private List <ChangesInfo> GetChangedData(tableChanges <modelProjectVariation> changes)
        {
            var changeInfos = new List <ChangesInfo>();

            foreach (long changedid in changes.changedIDs)
            {
                var objacc = local_dataProject.getProjectVariation(changedid);
                var objsql = sql_dataProject.getProjectVariation(changedid);

                var prjacc = local_dataProject.getProject(objacc.ProjectID);
                var prjsql = sql_dataProject.getProject(objsql.ProjectID);

                string acc_desc = prjacc.GetTitleInfo() + " / " + objacc.Title;
                string sql_desc = prjsql.GetTitleInfo() + " / " + objsql.Title;

                var inf = new ChangesInfo(changedid, "Project Variation", acc_desc, sql_desc, objacc.UpdatedDate, objsql.UpdatedDate, objacc.UpdatedDate > objsql.UpdatedDate, false, false);
                changeInfos.Add(inf);
            }
            return(changeInfos);
        }