private void WriteNewToAccess() { WriteNewItems(changedLanguages.newSQLIDs, sql_dataLOV.getLanguages, (toInsert => { local_dataLOV.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedCountries.newSQLIDs, sql_dataLOV.getCountries, (toInsert => { local_dataLOV.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedDistBands.newSQLIDs, sql_dataLOV.getDistanceBands, (toInsert => { local_dataLOV.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedNatAgencies.newSQLIDs, sql_dataLOV.getNationalAgencies, (toInsert => { local_dataLOV.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedOrgTypes.newSQLIDs, sql_dataLOV.getOrganizationTypes, (toInsert => { local_dataLOV.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedRoles.newSQLIDs, sql_dataLOV.getRoles, (toInsert => { local_dataLOV.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedTopics.newSQLIDs, sql_dataLOV.getTopics, (toInsert => { local_dataLOV.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedClients.newSQLIDs, sql_dataLOV.getClients, (toInsert => { local_dataLOV.Insert(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedPerson.newSQLIDs, sql_dataPerson.getPersons, (toInsert => { local_dataPerson.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedOrganization.newSQLIDs, sql_dataOrganization.getOrganizations, (toInsert => { local_dataOrganization.Insert(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedProjectActivity.newSQLIDs, sql_dataProject.getProjectActivities, (toInsert => { local_dataProject.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedProjActVariation.newSQLIDs, sql_dataProject.getProjectActivityVariations, (toInsert => { local_dataProject.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedProjects.newSQLIDs, sql_dataProject.getProjects, (toInsert => { local_dataProject.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedProjTopics.newSQLIDs, sql_dataProject.getProjectTopics, (toInsert => { local_dataProject.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedProjVariationOrg.newSQLIDs, sql_dataProject.getProjectVariationOrganizations, (toInsert => { local_dataProject.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedProjVariation.newSQLIDs, sql_dataProject.getProjectVariations, (toInsert => { local_dataProject.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedActivityTypes.newSQLIDs, sql_dataActivity.getActivityTypes, (toInsert => { local_dataActivity.Write(toInsert, false); })); ProgressBarAdd(); WriteNewItems(changedMobility.newSQLIDs, sql_dataActivity.getMobilities, (toInsert => { local_dataActivity.Write(toInsert, false); })); ProgressBarAdd(); }
private void ibuttonWriteChanges_Click(object sender, EventArgs e) { foreach (var change in allChanges.Where(c => c.newSQL == false && c.newAccess == false)) { if (change.Abbrev == "modelCountry") { if (change.syncAccessToSQL) { var country = local_dataLOV.getCountry(change.ID); sql_dataLOV.Write(country, false); } else { var country = sql_dataLOV.getCountry(change.ID); local_dataLOV.Write(country, false); } } if (change.Abbrev == "modelLanguage") { if (change.syncAccessToSQL) { var lang = local_dataLOV.getLanguage(change.ID); sql_dataLOV.Write(lang, false); } else { var lang = sql_dataLOV.getLanguage(change.ID); local_dataLOV.Write(lang, false); } } if (change.Abbrev == "modelNationalAgency") { if (change.syncAccessToSQL) { var natagency = local_dataLOV.getNationalAgency(change.ID); sql_dataLOV.Write(natagency, false); } else { var natagency = sql_dataLOV.getNationalAgency(change.ID); local_dataLOV.Write(natagency, false); } } if (change.Abbrev == "modelDistanceBand") { if (change.syncAccessToSQL) { var distband = local_dataLOV.getDistanceBand(change.ID); sql_dataLOV.Write(distband, false); } else { var distband = sql_dataLOV.getDistanceBand(change.ID); local_dataLOV.Write(distband, false); } } if (change.Abbrev == "modelPerson") { if (change.syncAccessToSQL) { var pers = local_dataPerson.getPerson(change.ID); sql_dataPerson.Write(pers, false); } else { var pers = sql_dataPerson.getPerson(change.ID); local_dataPerson.Write(pers, false); } } if (change.Abbrev == "modelRole") { if (change.syncAccessToSQL) { var role = local_dataLOV.getRole(change.ID); sql_dataLOV.Write(role, false); } else { var role = sql_dataLOV.getRole(change.ID); local_dataLOV.Write(role, false); } } if (change.Abbrev == "modelTopic") { if (change.syncAccessToSQL) { var topic = local_dataLOV.getTopic(change.ID); sql_dataLOV.Write(topic, false); } else { var topic = sql_dataLOV.getTopic(change.ID); local_dataLOV.Write(topic, false); } } if (change.Abbrev == "modelClient") { if (change.syncAccessToSQL) { var client = local_dataLOV.getClient(change.ID); sql_dataLOV.Write(client, false); } else { var client = sql_dataLOV.getClient(change.ID); local_dataLOV.Write(client, false); } } if (change.Abbrev == "modelOrganization") { if (change.syncAccessToSQL) { var pers = local_dataOrganization.getOrganization(change.ID); sql_dataOrganization.Write(pers, false); } else { var pers = sql_dataOrganization.getOrganization(change.ID); local_dataOrganization.Write(pers, false); } } if (change.Abbrev == "modelOrganizationType") { if (change.syncAccessToSQL) { var orgtype = local_dataLOV.getOrganizationType(change.ID); sql_dataLOV.Write(orgtype, false); } else { var orgtype = sql_dataLOV.getOrganizationType(change.ID); local_dataLOV.Write(orgtype, false); } } if (change.Abbrev == "modelActivityType") { if (change.syncAccessToSQL) { var acttype = local_dataActivity.getActivityType(change.ID); sql_dataActivity.Write(acttype, false); } else { var acttype = sql_dataActivity.getActivityType(change.ID); local_dataActivity.Write(acttype, false); } } if (change.Abbrev == "modelProject") { if (change.syncAccessToSQL) { var prj = local_dataProject.getProject(change.ID); sql_dataProject.Write(prj, false); } else { var prj = sql_dataProject.getProject(change.ID); local_dataProject.Write(prj, false); } } if (change.Abbrev == "Project Activity") { if (change.syncAccessToSQL) { var prjact = local_dataProject.getProjectActivity(change.ID); sql_dataProject.Write(prjact, false); } else { var prjact = sql_dataProject.getProjectActivity(change.ID); local_dataProject.Write(prjact, false); } } if (change.Abbrev == "Project Variation") { if (change.syncAccessToSQL) { var prjvar = local_dataProject.getProjectVariation(change.ID); sql_dataProject.Write(prjvar, false); } else { var prjvar = sql_dataProject.getProjectVariation(change.ID); local_dataProject.Write(prjvar, false); } } if (change.Abbrev == "Project Activity Variation") { if (change.syncAccessToSQL) { var prjactvar = local_dataProject.getProjectActivityVariation(change.ID); sql_dataProject.Write(prjactvar, false); } else { var prjactvar = sql_dataProject.getProjectActivityVariation(change.ID); local_dataProject.Write(prjactvar, false); } } if (change.Abbrev == "Project Activity Variation Organization") { if (change.syncAccessToSQL) { var prjactvarorg = local_dataProject.getProjectVariationOrganization(change.ID); sql_dataProject.Write(prjactvarorg, false); } else { var prjactvarorg = sql_dataProject.getProjectVariationOrganization(change.ID); local_dataProject.Write(prjactvarorg, false); } } if (change.Abbrev == "Project Activity Variation Mobility") { if (change.syncAccessToSQL) { var mob = local_dataActivity.getMobility(change.ID); sql_dataActivity.Write(mob, false); } else { var mob = sql_dataActivity.getMobility(change.ID); local_dataActivity.Write(mob, false); } } } local_dataLOV.LoadData(); sql_dataLOV.LoadData(); }