Exemplo n.º 1
0
        private void appointment_Click(object sender, EventArgs e)
        {
            appointment pat = new appointment();

            this.Hide();
            pat.Show();
        }
Exemplo n.º 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            appointment appt = new appointment();

            this.Hide();
            appt.Show();
        }
Exemplo n.º 3
0
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                string sql = "INSERT INTO appointment (name,phone,gender,visit_date) values (@name,@phone,@gender,@visit_date)";
                using (SqlConnection sqlcon = new SqlConnection("Data Source=.;Initial Catalog=sem2;User ID=sa;Password=sap"))
                {
                    sqlcon.Open();
                    using (SqlCommand cmd = new SqlCommand(sql, sqlcon))
                    {
                        cmd.Parameters.AddWithValue("@name", name.Text.Trim());
                        cmd.Parameters.AddWithValue("@phone", phone.Text.Trim());
                        cmd.Parameters.AddWithValue("@visit_date", visit_date.Value);
                        string gender_value = "";
                        bool   isChecked    = radioButton1.Checked;
                        if (isChecked)
                        {
                            gender_value = radioButton1.Text;
                        }
                        else
                        {
                            gender_value = radioButton2.Text;
                        }

                        cmd.Parameters.AddWithValue("@gender", gender_value);
                        cmd.ExecuteNonQuery();
                        MessageBox.Show("You have successfully added the patient appointment to the database");
                        appointment appt = new appointment();
                        this.Hide();
                        appt.Show();
                    }
                }
            }
            catch (SqlException ex)
            {
                string msg = "Insert Error:";
                msg += ex.Message;
            }
        }