コード例 #1
0
        private void btn_OK_Click(object sender, EventArgs e)
        {
            Studies st = new Studies();

            st.Show();
            this.Hide();
        }
コード例 #2
0
 private void btnSaveParents_Click(object sender, EventArgs e)
 {
     if (PersonalInformation.Worker)
     {
         Job j = new Job();
         j.Show();
         this.Hide();
     }
     if (PersonalInformation.Student)
     {
         Studies st = new Studies();
         st.Show();
         this.Hide();
     }
     if (PersonalInformation.unemployed)
     {
         Dashboard d = new Dashboard();
         d.Show();
         this.Hide();
     }
 }
コード例 #3
0
ファイル: Parents.cs プロジェクト: yasminee99/Nadhamni31
        private void btnSaveParents_Click(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                //insert into father's table
                SqlCommand cmd1 = new SqlCommand("insert into Father(FirstName,Birthday,RespiratoryDiseases,CardiovascularDiseases,Diabetes,Cancer,FamilyDr,UserName)values(@FirstName,@Birthday,@RespiratoryDiseases,@CardiovascularDiseases,@Diabetes,@Cancer,@FamilyDr,@UserName)", con);
                cmd1.CommandType = CommandType.Text;
                cmd1.Parameters.AddWithValue("@FirstName", txt_firstnameFather.Text);
                cmd1.Parameters.AddWithValue("@Birthday", birthdayFather.Value.ToString());
                cmd1.Parameters.AddWithValue("@RespiratoryDiseases", RD_F);
                cmd1.Parameters.AddWithValue("@CardiovascularDiseases", CV_F);
                cmd1.Parameters.AddWithValue("@Diabetes", D_F);
                cmd1.Parameters.AddWithValue("@Cancer", C_F);
                cmd1.Parameters.AddWithValue("@FamilyDr", txt_docFamily.Text);
                cmd1.Parameters.AddWithValue("@UserName", Home.FK);
                cmd1.ExecuteNonQuery();
                //insert into mother's table
                SqlCommand cmd2 = new SqlCommand("insert into Mother(FirstName,Birthday,RespiratoryDiseases,CardiovascularDiseases,Diabetes,Cancer,FamilyDr,UserName)values(@FirstName,@Birthday,@RespiratoryDiseases,@CardiovascularDiseases,@Diabetes,@Cancer,@FamilyDr,@UserName)", con);
                cmd2.CommandType = CommandType.Text;
                cmd2.Parameters.AddWithValue("@FirstName", txt_firstnameMother.Text);
                cmd2.Parameters.AddWithValue("@Birthday", birthdayMother.Value.ToString());
                cmd2.Parameters.AddWithValue("@RespiratoryDiseases", RD_M);
                cmd2.Parameters.AddWithValue("@CardiovascularDiseases", CV_M);
                cmd2.Parameters.AddWithValue("@Diabetes", D_M);
                cmd2.Parameters.AddWithValue("@Cancer", C_M);
                cmd2.Parameters.AddWithValue("@FamilyDr", txt_docFamily.Text);
                cmd2.Parameters.AddWithValue("@UserName", Home.FK);
                cmd2.ExecuteNonQuery();
                MessageBox.Show("success");

                //passage entre les interfaces
                if (PersonalInformation.Worker)
                {
                    Job j = new Job();
                    j.Show();
                    this.Hide();
                }
                if (PersonalInformation.Student)
                {
                    Studies st = new Studies();
                    st.Show();
                    this.Hide();
                }
                if (PersonalInformation.unemployed)
                {
                    Dashboard d = new Dashboard();
                    d.Show();
                    this.Hide();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
            }
        }