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