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);
}
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);
}
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();
}
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);
}