private void PopulateFields(int activityId)
{
Activity0Helper helper = new Activity0Helper();
Activity0 activity0 = helper.GetActivityData(4, activityId);
Activity4 activity = (Activity4)activity0;
if (activity != null)
{
comboBox1.Text = activity.Region;
comboBox2.Text = activity.Zone;
comboBox3.Text = activity.Woreda;
comboBox5.Text = activity.Kebele;
textBox1.Text = activity.Stage;
textBox2.Text = activity.Ccfacilitatorname;
dateTimePicker1.Value = activity.ActivityDate;
textBox10.Text = activity.Duration;
textBox3.Text = activity.IssuesRaised;
textBox4.Text = activity.AgreedActionPoints;
textBox7.Text = activity.FacilitatorName;
textBox6.Text = activity.Position;
}
List <Participant> participantsList = helper.GetParticpantData(4, activityId);
for (int i = 0; i < participantsList.Count; i++)
{
Participant participant0 = participantsList[i];
Participant4 participant = (Participant4)participant0;
string[] row = { dataGridView2.RowCount + "", participant.Name, participant.Role, participant.Kebele, participant.Sex, participant.Age.ToString() };
dataGridView2.Rows.Add(row);
}
}
private void PopulateFields(int activityId)
{
Activity0Helper helper = new Activity0Helper();
Activity0 activity0 = helper.GetActivityData(ACTIVITY_TYPE, activityId);
Activity9 activity = (Activity9)activity0;
if (activity != null)
{
comboBox1.Text = activity.Region;
comboBox2.Text = activity.Zone;
comboBox3.Text = activity.Woreda;
comboBox5.Text = activity.Kebele;
dateTimePicker1.Value = activity.ActivityDate;
textBox3.Text = activity.IssuesRaised;
textBox4.Text = activity.AgreedActionPoints;
textBox7.Text = activity.FacilitatorName;
textBox6.Text = activity.Position;
}
List <Participant> participantsList = helper.GetParticpantData(ACTIVITY_TYPE, activityId);
for (int i = 0; i < participantsList.Count; i++)
{
Participant participant0 = participantsList[i];
Participant9 participant = (Participant9)participant0;
string[] row = { dataGridView2.RowCount + "", participant.Name, participant.Kebele, GetStringFromInt(participant.Disabled), participant.Noofadolescent.ToString(), participant.Noofwomen.ToString(), participant.Typeofmaterial, participant.Unit, participant.Quantity.ToString() };
dataGridView2.Rows.Add(row);
}
}
private void PopulateFields(int activityId)
{
Activity0Helper helper = new Activity0Helper();
Activity0 activity0 = helper.GetActivityData(ACTIVITY_TYPE, activityId);
Activity7 activity = (Activity7)activity0;
if (activity != null)
{
comboBox1.Text = activity.Region;
comboBox2.Text = activity.Zone;
comboBox3.Text = activity.Woreda;
comboBox5.Text = activity.Kebele;
dateTimePicker1.Value = activity.ActivityDate;
numericUpDown2.Value = activity.Totalnumberofmembers;
textBox3.Text = activity.IssuesRaised;
textBox4.Text = activity.AgreedActionPoints;
textBox7.Text = activity.FacilitatorName;
textBox6.Text = activity.Position;
}
List <Participant> participantsList = helper.GetParticpantData(ACTIVITY_TYPE, activityId);
for (int i = 0; i < participantsList.Count; i++)
{
Participant participant0 = participantsList[i];
Participant7 participant = (Participant7)participant0;
string[] row = { dataGridView2.RowCount + "", participant.Groupname, GetStringFromInt(participant.Disabled), participant.Kebele, participant.Noofadolescent.ToString(), participant.Noofadolescent.ToString(), participant.Typeoftraining, participant.Capital, participant.Typeofiga, participant.Statusofiga, participant.Amountofsaving, participant.Remark };
dataGridView2.Rows.Add(row);
}
}
private void PopulateFields(int activityId)
{
Activity0Helper helper = new Activity0Helper();
Activity0 activity0 = helper.GetActivityData(3, activityId);
Activity3 activity = (Activity3)activity0;
if (activity != null)
{
comboBox1.Text = activity.Region;
comboBox2.Text = activity.Zone;
textBox1.Text = activity.Trainingtitle;
textBox2.Text = activity.Trainingfacilitator;
comboBox3.Text = activity.Woreda;
dateTimePicker1.Value = activity.ActivityDate;
textBox3.Text = activity.IssuesRaised;
textBox4.Text = activity.AgreedActionPoints;
textBox7.Text = activity.FacilitatorName;
textBox6.Text = activity.Position;
}
List <Participant> participantsList = helper.GetParticpantData(3, activityId);
for (int i = 0; i < participantsList.Count; i++)
{
Participant participant0 = participantsList[i];
Participant3 participant = (Participant3)participant0;
string[] row = { dataGridView2.RowCount + "", participant.Name, participant.Sex, participant.Organization, participant.Position, participant.Woreda, participant.Kebele };
dataGridView2.Rows.Add(row);
}
}
private void PopulateFields(int activityId)
{
Activity0Helper helper = new Activity0Helper();
Activity0 activity0 = helper.GetActivityData(ACTIVITY_TYPE, activityId);
Activity8 activity = (Activity8)activity0;
if (activity != null)
{
comboBox1.Text = activity.Region;
comboBox2.Text = activity.Zone;
comboBox3.Text = activity.Woreda;
textBox11.Text = activity.Schoolname;
DateTime newDateTime = new DateTime(Convert.ToInt32(activity.Year), 1, 1);
dateTimePicker1.Value = newDateTime;
dateTimePicker2.Value = activity.ActivityDate;
textBox3.Text = activity.IssuesRaised;
textBox4.Text = activity.AgreedActionPoints;
textBox7.Text = activity.FacilitatorName;
textBox6.Text = activity.Position;
}
List <Participant> participantsList = helper.GetParticpantData(ACTIVITY_TYPE, activityId);
for (int i = 0; i < participantsList.Count; i++)
{
Participant participant0 = participantsList[i];
Participant8 participant = (Participant8)participant0;
string[] row = { dataGridView2.RowCount + "", participant.Name, participant.Age.ToString(), GetStringFromInt(participant.Disabled), participant.Gradelevel, participant.Statusofretention, participant.Remark };
dataGridView2.Rows.Add(row);
}
}
private void DeleteActivity()
{
Activity0Helper helper = new Activity0Helper();
int result = helper.DeleteActivity(ACTIVITY_TYPE, activityId);
if (result > 0)
{
MessageBox.Show("Activity data deleted successfully!", "Successfully Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("Activity data deletetion failed!", "Uh oh!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void syncBackgroundWorker_DoWork(object sender, DoWorkEventArgs e)
{
syncHelper = new Activity0Helper();
activityList = syncHelper.GetUnsyncedActivityList(ACTIVITY_TYPE);
participantsList = syncHelper.GetUnsyncedParticpansList(ACTIVITY_TYPE);
if (activityList.Count > 0)
{
//sync data
syncStatus = syncHelper.SendActivityListToServer(ACTIVITY_TYPE, activityList);
}
if (participantsList.Count > 0)
{
//sync data
participantsSyncStatus = syncHelper.SendParticipantsListToServer(ACTIVITY_TYPE, participantsList);
}
}
private void PopulateFields(int activityId)
{
Activity0Helper helper = new Activity0Helper();
Activity0 activity0 = helper.GetActivityData(2, activityId);
Activity2 activity = (Activity2)activity0;
if (activity != null)
{
comboBox1.Text = activity.Region;
comboBox2.Text = activity.Zone;
textBox1.Text = activity.Schoolname;
textBox2.Text = activity.Clubname;
comboBox3.Text = activity.Woreda;
dateTimePicker1.Value = activity.ActivityDate;
textBox3.Text = activity.IssuesRaised;
textBox4.Text = activity.AgreedActionPoints;
textBox7.Text = activity.FacilitatorName;
textBox6.Text = activity.Position;
}
List <Participant> participantsList = helper.GetParticpantData(2, activityId);
for (int i = 0; i < participantsList.Count; i++)
{
Participant participant0 = participantsList[i];
Participant2 participant = (Participant2)participant0;
string disabled = "No";
if (participant.Disabled == 0)
{
disabled = "No";
}
else
{
disabled = "Yes";
}
string[] row = { dataGridView2.RowCount + "", participant.Name, participant.Gradelevel, participant.Sex, participant.Age.ToString(), disabled };
dataGridView2.Rows.Add(row);
}
}
private void PopulateFields(int activityId)
{
Activity0Helper helper = new Activity0Helper();
Activity0 activity0 = helper.GetActivityData(ACTIVITY_TYPE, activityId);
Activity5 activity = (Activity5)activity0;
if (activity != null)
{
comboBox1.Text = activity.Region;
comboBox2.Text = activity.Zone;
comboBox3.Text = activity.Woreda;
comboBox5.Text = activity.Kebele;
DateTime newDateTime = new DateTime(Convert.ToInt32(activity.Year), 1, 1);
dateTimePicker1.Value = Convert.ToDateTime(newDateTime);
dateTimePicker4.Value = activity.ActivityDate;
textBox3.Text = activity.IssuesRaised;
textBox4.Text = activity.AgreedActionPoints;
textBox7.Text = activity.FacilitatorName;
textBox6.Text = activity.Position;
}
List <Participant> participantsList = helper.GetParticpantData(ACTIVITY_TYPE, activityId);
for (int i = 0; i < participantsList.Count; i++)
{
Participant participant0 = participantsList[i];
Participant5 participant = (Participant5)participant0;
string[] row = { dataGridView2.RowCount + "", participant.Pdate.ToString(), participant.Code, participant.Town, participant.Age.ToString(), GetStringFromInt(participant.Disabled), participant.Dateofvisit.ToString(), participant.Identifiedcase, participant.Others };
dataGridView2.Rows.Add(row);
dataGridView2.Rows[dataGridView2.RowCount - 2].Cells[9].Value = GetBoolFromInt(participant.Referralhealth);
dataGridView2.Rows[dataGridView2.RowCount - 2].Cells[10].Value = GetBoolFromInt(participant.Referralpolice);
dataGridView2.Rows[dataGridView2.RowCount - 2].Cells[11].Value = GetBoolFromInt(participant.Referrallegal);
dataGridView2.Rows[dataGridView2.RowCount - 2].Cells[12].Value = GetBoolFromInt(participant.Referralpsycho);
}
}
private void SaveData(int saveOrUpdate)
{
//mainFieldsValid();
if (mainFieldsValid())
{
Activity0Helper helper = new Activity0Helper();
Activity9 activity = new Activity9();
activity.Region = comboBox1.Text;
activity.Zone = comboBox2.Text;
activity.Woreda = comboBox3.Text;
activity.Kebele = comboBox5.Text;
activity.ActivityDate = dateTimePicker1.Value;
activity.UserId = Properties.Settings.Default.UID; //change this using property stored id of currently logged in user
activity.FacilitatorName = textBox7.Text; //make name of logged in user available in this field
activity.Position = textBox6.Text;
activity.LocalTimeStamp = DateTime.Now;
activity.Mac = StringCipher.GetMacAddress();
activity.IssuesRaised = textBox3.Text;
activity.AgreedActionPoints = textBox4.Text;
List <Participant> participantsList = new List <Participant>();
if (dataGridView2.RowCount > 1)
{
for (int i = 0; i < dataGridView2.Rows.Count - 1; i++)//-1 to avoid empty row
{
Participant9 participant = new Participant9();
if (dataGridView2.Rows[i].Cells[1].Value != null)
{
participant.Name = dataGridView2.Rows[i].Cells[1].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[2].Value != null)
{
participant.Kebele = dataGridView2.Rows[i].Cells[2].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[3].Value != null)
{
participant.Disabled = GetDisabledInt(dataGridView2.Rows[i].Cells[3].Value.ToString());
}
if (dataGridView2.Rows[i].Cells[4].Value != null)
{
participant.Noofadolescent = Convert.ToInt32(dataGridView2.Rows[i].Cells[4].Value.ToString());
}
if (dataGridView2.Rows[i].Cells[5].Value != null)
{
participant.Noofwomen = Convert.ToInt32(dataGridView2.Rows[i].Cells[5].Value.ToString());
}
if (dataGridView2.Rows[i].Cells[6].Value != null)
{
participant.Typeofmaterial = dataGridView2.Rows[i].Cells[6].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[7].Value != null)
{
participant.Unit = dataGridView2.Rows[i].Cells[7].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[8].Value != null)
{
participant.Quantity = Convert.ToInt32(dataGridView2.Rows[i].Cells[8].Value.ToString());
}
participantsList.Add(participant);
}
}
//MessageBox.Show(activity.Position);
int id = helper.Insert(ACTIVITY_TYPE, activity, participantsList);
if (id > 0)
{
InsertRegionAndKebeleData();
//MessageBox.Show("Activity data added successfully!");
MessageBox.Show("Activity data added successfully!", "Successfully Addition", MessageBoxButtons.OK, MessageBoxIcon.Information);
//check internet connection before syncing data
if (saveOrUpdate == 1)//update button clicked
{
//if (StringCipher.CheckInternet("http://" + Session.Properties.Settings.Default.RemoteDatabaseAddress))
SyncData();
}
//this.Close(); //or Reset fields
this.Close();
}
}
}
private void SaveData(int saveOrUpdate)
{
//mainFieldsValid();
if (mainFieldsValid())
{
//MessageBox.Show("All fields valid. Ready to submit data to database.");
Activity0Helper helper = new Activity0Helper();
Activity3 activity = new Activity3();
//(region, zone, woreda, kebele, activity_date, user_id, facilitator_name, position, localtimestamp, mac)
activity.Region = comboBox1.Text;
activity.Zone = comboBox2.Text;
activity.Woreda = comboBox3.Text;
activity.Trainingtitle = textBox1.Text;
activity.Trainingfacilitator = textBox2.Text;
activity.ActivityDate = dateTimePicker1.Value;
activity.UserId = Properties.Settings.Default.UID; //change this using property stored id of currently logged in user
activity.FacilitatorName = textBox7.Text; //make name of logged in user available in this field
activity.Position = textBox6.Text;
activity.LocalTimeStamp = DateTime.Now;
activity.Mac = StringCipher.GetMacAddress();
activity.IssuesRaised = textBox3.Text;
activity.AgreedActionPoints = textBox4.Text;
List <Participant> participantsList = new List <Participant>();
if (dataGridView2.RowCount > 1)
{
for (int i = 0; i < dataGridView2.Rows.Count - 1; i++)//-1 to avoid empty row
{
Participant3 participant = new Participant3();
if (dataGridView2.Rows[i].Cells[1].Value != null)
{
participant.Name = dataGridView2.Rows[i].Cells[1].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[2].Value != null)
{
participant.Sex = dataGridView2.Rows[i].Cells[2].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[3].Value != null)
{
participant.Organization = dataGridView2.Rows[i].Cells[3].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[4].Value != null)
{
participant.Position = dataGridView2.Rows[i].Cells[4].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[5].Value != null)
{
participant.Woreda = dataGridView2.Rows[i].Cells[5].Value.ToString();
}
if (dataGridView2.Rows[i].Cells[6].Value != null)
{
participant.Kebele = dataGridView2.Rows[i].Cells[6].Value.ToString();
}
participantsList.Add(participant);
}
}
//MessageBox.Show(activity.Position);
int id = helper.Insert(3, activity, participantsList);
if (id > 0)
{
InsertRegionAndKebeleData();
//MessageBox.Show("Activity data added successfully!");
MessageBox.Show("Activity data added successfully!", "Successfully Addition", MessageBoxButtons.OK, MessageBoxIcon.Information);
//check internet connection before syncing data
if (saveOrUpdate == 1)//update button clicked
{
//if (StringCipher.CheckInternet("http://" + Session.Properties.Settings.Default.RemoteDatabaseAddress))
SyncData();
}
//this.Close(); //or Reset fields
this.Close();
}
}
}
