private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
GenericHelper genericHelper = new GenericHelper();
ActivitySelectorHelper activityHelper = new ActivitySelectorHelper();
if (activityHelper.TableExists("Region"))
{
regionTable = genericHelper.GetList("Region");
}
if (activityHelper.TableExists("Zonne"))
{
zoneTable = genericHelper.GetList("Zonne");
}
if (activityHelper.TableExists("Woreda"))
{
woredaTable = genericHelper.GetList("Woreda");
}
if (activityHelper.TableExists("Kebele"))
{
kebeleTable = genericHelper.GetList("Kebele");
}
if (activityHelper.TableExists("Kebele"))
{
kebeleTable2 = genericHelper.GetList("Kebele");
}
}
private void GetData(string tableName)
{
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
if (activitySelectorHelper.TableExists(tableName))
{
//MessageBox.Show("Table exists");
activityListItem = activitySelectorHelper.GetActivityList(tableName);
//dataGridView1.DataSource = activityList;
for (int i = 0; i < activityListItem.Count; i++)
{
string[] row = { activityListItem[i].LocalTimeStamp.ToString(), activityListItem[i].Title };
dataGridView1.Rows.Add(row);
}
}
}
private void PopulateComboBox(int index)
{
ActivitySelectorHelper activitySelectorHelper = new ActivitySelectorHelper();
tableExists = activitySelectorHelper.TableExists(tableNames[index]);
if (tableExists)
{
//EnableFields(true);
//MessageBox.Show(Properties.Settings.Default.USERORGANIZATION + " : " + Properties.Settings.Default.USERPARTNER);
List <string> activityAsString = new List <string>();
ActivityHelper activityHelper = new ActivityHelper();
activity0List = activityHelper.GetActivityListByPartner(tableNames[index], Properties.Settings.Default.USERORGANIZATION, Properties.Settings.Default.USERPARTNER);
if (activity0List != null)
{
if (activity0List.Count > 0)
{
EnableFields(true);
for (int i = 0; i < activity0List.Count; i++)
{
Activity0 activity = activity0List[i];
string activityString = "[Activity " + index + " ~ ID: " + activity.RemoteId + "] ~ On " + activity.ActivityDate + ": " + activity.Region + ", " + activity.Zone + ", " + activity.Woreda + ", " + activity.Kebele;
activityAsString.Add(activityString);
activityIds.Add(activity.RemoteId);
}
comboBox2.DataSource = activityAsString;
}
else
{
EnableFields(false);
}
}
}
else
{
MessageBox.Show("Table does not exist!");
EnableFields(false);
}
}