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 int GetRowCount(int activityIndex, int year) { int rowCounter = 0; string tableName = "activity" + activityIndex; Activity0 currentActivity = null; if (TableExists(tableName)) { User user = null; connection = new OleDbConnection(Properties.Settings.Default.DatabaseAddress); command = connection.CreateCommand(); command.CommandText = "SELECT * FROM " + tableName; connection.Open(); OleDbDataReader dr = command.ExecuteReader(); while (dr.Read()) { currentActivity = new Activity0(); currentActivity.ActivityDate = dr.GetDateTime(5); int currentYear = currentActivity.ActivityDate.Year; if (currentYear == year) { rowCounter += 1; } } connection.Close(); dr.Close(); return(rowCounter); } else { return(0); } }
private bool IsOfYear(int activityIndex, int activityId, int year) { string tableName = "activity" + activityIndex; bool isOfYear = false; Activity0 currentActivity = null; if (TableExists(tableName)) { int totalNumber = 0; connection = new OleDbConnection(Properties.Settings.Default.DatabaseAddress); command = connection.CreateCommand(); command.CommandText = "SELECT * FROM " + tableName + " WHERE [ID]=" + activityId; connection.Open(); OleDbDataReader dr = command.ExecuteReader(); while (dr.Read()) { currentActivity = new Activity0(); currentActivity.ActivityDate = dr.GetDateTime(5); int currentYear = currentActivity.ActivityDate.Year; if (currentYear == year) { isOfYear = true; } } connection.Close(); dr.Close(); return(isOfYear); } else { return(isOfYear); } }
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); } }
public List <Activity0> GetActivityListByPartner(string tableName, string organization, string partner) { List <Activity0> activityList = new List <Activity0>(); try { command.CommandText = "SELECT * FROM " + tableName + " WHERE [sync_status]=1"; command.CommandType = CommandType.Text; connection.Open(); OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { Activity0 activity = new Activity0(); activity.Aid = Convert.ToInt32(reader["ID"].ToString()); activity.Region = reader["region"].ToString(); activity.Zone = reader["zone"].ToString(); activity.Woreda = reader["woreda"].ToString(); activity.Kebele = reader["kebele"].ToString(); activity.ActivityDate = reader.GetDateTime(5); activity.UserId = Convert.ToInt32(reader["user_id"].ToString()); activity.RemoteId = Convert.ToInt32(reader["remoteid"].ToString()); UserHelper userHelper = new UserHelper(); if (userHelper.IsUserOfOrganization(activity.UserId, organization, partner)) { activityList.Add(activity); } } return(activityList); } catch (Exception) { throw; } finally { if (connection != null) { connection.Close(); } } }
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 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); } }
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); } }