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