예제 #1
0
파일: Form8.cs 프로젝트: natz247/FGMIS2
        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);
            }
        }
예제 #2
0
파일: Form8.cs 프로젝트: natz247/FGMIS2
        private void SaveData(int saveOrUpdate)
        {
            //mainFieldsValid();
            if (mainFieldsValid())
            {
                Activity0Helper helper   = new Activity0Helper();
                Activity8       activity = new Activity8();

                activity.Region     = comboBox1.Text;
                activity.Zone       = comboBox2.Text;
                activity.Woreda     = comboBox3.Text;
                activity.Schoolname = textBox11.Text;
                DateTime newTime = dateTimePicker1.Value;
                activity.Year            = newTime.Year.ToString();
                activity.ActivityDate    = dateTimePicker2.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
                    {
                        Participant8 participant = new Participant8();
                        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.Age = Convert.ToInt32(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.Gradelevel = dataGridView2.Rows[i].Cells[4].Value.ToString();
                        }

                        if (dataGridView2.Rows[i].Cells[5].Value != null)
                        {
                            participant.Statusofretention = dataGridView2.Rows[i].Cells[5].Value.ToString();
                        }

                        if (dataGridView2.Rows[i].Cells[6].Value != null)
                        {
                            participant.Remark = dataGridView2.Rows[i].Cells[6].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();
                }
            }
        }