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