예제 #1
0
        private void ChangeClinic(string newname, string newaddress)
        {
            connect = new DBConnect();

            if (connect.OpenConnection())
            {
                try
                {
                    com = new MySqlCommand("CLINIC", connect.con);
                    com.CommandType = CommandType.StoredProcedure;

                    com.Parameters.AddWithValue("@NewName", newname);
                    com.Parameters.AddWithValue("@NewAddress", newaddress);
                    com.Parameters.AddWithValue("@Name", name);
                    com.Parameters.AddWithValue("@Address", address);
                    com.Parameters.AddWithValue("@Id", iIdRecord);

                    com.ExecuteNonQuery();

                    connect.CloseConnection();
                }

                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                
            }
        }
예제 #2
0
        public void AddToDoctor(string name, string surname, string patro, string clinic, string spec)
        {
            connect = new DBConnect();
            con = new MySqlConnection();
            con = connect.con;
            if (connect.OpenConnection())
            {
                try
                {
                    MySqlCommand com = new MySqlCommand("DOCTOR", con);
                    com.CommandType = CommandType.StoredProcedure;

                    com.Parameters.AddWithValue("@Id", iIdRecord);
                    com.Parameters.AddWithValue("@Id_doctor", id_doctor);
                    com.Parameters.AddWithValue("@newName", name);
                    com.Parameters.AddWithValue("@newSurname", surname);
                    com.Parameters.AddWithValue("@newPatro", patro);
                    com.Parameters.AddWithValue("@newclinic", clinic);
                    com.Parameters.AddWithValue("@newSpec", spec);
                    com.Parameters.AddWithValue("@Id_start", Convert.ToInt32(id_start));
                    com.Parameters.AddWithValue("@Id_end", Convert.ToInt32(id_end));

                    com.ExecuteNonQuery();

                    connect.CloseConnection();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

        }
예제 #3
0
        private void loadSpecHos()
        {
            Hospital_cb.Items.Clear();
            Specialization_cb.Items.Clear();
            connect = new DBConnect();

            com = new MySqlCommand(@"select name_clinic from clinic", connect.con);

            if (connect.OpenConnection())
            {
                using (MySqlDataReader dr = com.ExecuteReader())
                {

                    while (dr.Read())
                    {
                        Hospital_cb.Items.Add(dr["name_clinic"].ToString());
                    }

                    dr.Close();
                }

                connect.CloseConnection();
            }

            com = new MySqlCommand(@"select name_specialization from specialization", connect.con);

             if (connect.OpenConnection())
             {
                 using (MySqlDataReader dr = com.ExecuteReader())
                    {

                        while (dr.Read())
                        {
                            Specialization_cb.Items.Add(dr["name_specialization"].ToString());
                        }

                        dr.Close();
                    }
                 connect.CloseConnection();
              }
    }
예제 #4
0
        private void enter_btn_Click(object sender, EventArgs e)
        {
            
            Data.log = login_tb.Text;
            Data.pass = Password_tb.Text;

            DBConnect con = new DBConnect();
            if (con.OpenConnection())
            {
                this.Hide();
                hospital = new Hospital();
                  hospital.Show();
                con.CloseConnection();
            }
        }
예제 #5
0
        private void DelDubl()
        {
            connect = new DBConnect();
            if (connect.OpenConnection())
            {
                try
                {
                    com = new MySqlCommand("DUBLICATE", connect.con);
                    com.CommandType = CommandType.StoredProcedure;

                    com.ExecuteNonQuery();

                    connect.CloseConnection();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
예제 #6
0
        private void Dubl()
        {
            connect = new DBConnect();
            if (connect.OpenConnection())
            {
                try
                {
                    com = new MySqlCommand("CountDubl", connect.con);
                    com.CommandType = CommandType.StoredProcedure;
                    
                    dubl = Convert.ToInt32(com.ExecuteScalar());

                    connect.CloseConnection();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
예제 #7
0
        private void TimeTable(object sender, DataGridViewCellEventArgs e)
        {
            DBProcedure proc = new DBProcedure();
            string surname = Convert.ToString(Doctor_dataGrid.CurrentRow.Cells[0].Value);
            string name = Convert.ToString(Doctor_dataGrid.CurrentRow.Cells[1].Value);
            string patro = Convert.ToString(Doctor_dataGrid.CurrentRow.Cells[2].Value);
            string clinic = Convert.ToString(Doctor_dataGrid.CurrentRow.Cells[3].Value);
            string spec = Convert.ToString(Doctor_dataGrid.CurrentRow.Cells[4].Value);

            proc.search_id_doctor(name, surname, patro, clinic, spec);

            id = proc.id_doctor;

            connect = new DBConnect();
            com1 = new MySqlCommand(@"SELECT * FROM doctor, startrecept
                                    where doctor.id_startrecept = startrecept.id_startrecept 
                                    and id_doctor = "+@id, connect.con);
            com2 = new MySqlCommand(@"SELECT * FROM doctor, endrecept 
                                    where doctor.id_endrecept=endrecept.id_endrecept
                                    and id_doctor = " + @id, connect.con);

            if (connect.OpenConnection())
            {
                using (MySqlDataReader dr = com1.ExecuteReader())
                {

                    while (dr.Read())
                    {
                        sMon_tb.Text = dr["Monday"].ToString();
                        sTue_tb.Text = dr["Tuesday"].ToString();
                        sWed_tb.Text = dr["Wednesday"].ToString();
                        sThu_tb.Text = dr["thursday"].ToString();
                        sFri_tb.Text = dr["Friday"].ToString();
                        sSat_tb.Text = dr["saturday"].ToString();
                        sSun_tb.Text = dr["sunday"].ToString();

                    }

                    dr.Close();
                }
                connect.CloseConnection();
            }
            if (connect.OpenConnection())
            {
               using (MySqlDataReader dr = com2.ExecuteReader())
               {
                    while (dr.Read())
                    {
                        eMon_tb.Text = dr["Monday"].ToString();
                        eTue_tb.Text = dr["Tuesday"].ToString();
                        eWed_tb.Text = dr["Wednesday"].ToString();
                        eThu_tb.Text = dr["thursday"].ToString();
                        eFri_tb.Text = dr["Friday"].ToString();
                        eSat_tb.Text = dr["saturday"].ToString();
                        eSun_tb.Text = dr["sunday"].ToString();
                    }
                    dr.Close();
                }
                connect.CloseConnection();
            }
        }
예제 #8
0
        private void del_spec()
        {
            connect = new DBConnect();

            if (connect.OpenConnection())
            {
                try
                {
                    MySqlCommand com = new MySqlCommand("DELSPECIALIZATION", connect.con);
                    com.CommandType = CommandType.StoredProcedure;
                    com.Parameters.AddWithValue("@sName",Convert.ToString(Specialization_dataGrid.CurrentRow.Cells[0].Value));
                    
                    com.ExecuteNonQuery();
                    connect.CloseConnection();
                }
                catch
                {
                    MessageBox.Show("Нельзя удалить, существуют связи", "Ошибка", MessageBoxButtons.OK);
                }
            }
        }
예제 #9
0
        private void del_clinic()
        {
            connect = new DBConnect();

            if (connect.OpenConnection())
            {
                try
                {
                    MySqlCommand com = new MySqlCommand("DELCLINIC", connect.con);
                    com.CommandType = CommandType.StoredProcedure;
                    com.Parameters.AddWithValue("@sname", Convert.ToString(Hospital_dataGrid.CurrentRow.Cells[0].Value));
                    com.Parameters.AddWithValue("@saddress", Convert.ToString(Hospital_dataGrid.CurrentRow.Cells[1].Value));
                   
                    com.ExecuteNonQuery();

                    connect.CloseConnection();
                }
                catch 
                {
                    MessageBox.Show("Нельзя удалить, существуют связи", "Ошибка", MessageBoxButtons.OK);
                }
            }
        }
예제 #10
0
        public DataTable ToDataTable(string QueryString)
        {
            
            DataTable dt = new DataTable();

            connect = new DBConnect();
            MySqlConnection con = new MySqlConnection();

            con = connect.con;

            string str = QueryString;

            MySqlCommand com = new MySqlCommand(str, con);
                
             if (connect.OpenConnection())
             {
                    using (MySqlDataReader dr = com.ExecuteReader())
                    {
                            dt.Load(dr);
                    }
                   
                  connect.CloseConnection();
             }

               
            return dt;
        }
예제 #11
0
        public void StartTime(string mon, string tue, string wed, string thu, string fri, string sat, string sun)
        {
            connect = new DBConnect();
            con = new MySqlConnection();
            con = connect.con;
            if (connect.OpenConnection())
            {
                try
                {
                    com = new MySqlCommand("STARTRECEPT", con);
                    com.CommandType = CommandType.StoredProcedure;

                    com.Parameters.AddWithValue("@id", iIdRecord);
                    com.Parameters.AddWithValue("@id_doctor", id_doctor);
                    com.Parameters.AddWithValue("@smon", mon);
                    com.Parameters.AddWithValue("@stue", tue);
                    com.Parameters.AddWithValue("@swed", wed);
                    com.Parameters.AddWithValue("@sthu", thu);
                    com.Parameters.AddWithValue("@sfri", fri);
                    com.Parameters.AddWithValue("@ssat", sat);
                    com.Parameters.AddWithValue("@ssun", sun);

                    if (iIdRecord)
                    {
                        id_start = Convert.ToInt32(com.ExecuteScalar());
                    }
                    else com.ExecuteNonQuery();


                    connect.CloseConnection();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
예제 #12
0
        public void del_doc(DataGridViewRow doc)
        {
            connect = new DBConnect();
            con = new MySqlConnection();
            con = connect.con;
            if (connect.OpenConnection())
            {
                try
                {
                    MySqlCommand com = new MySqlCommand("DELDOCTOR", con);
                    com.CommandType = CommandType.StoredProcedure;
                    com.Parameters.AddWithValue("@Name", Convert.ToString( doc.Cells[1].Value));
                    com.Parameters.AddWithValue("@Surname", Convert.ToString(doc.Cells[0].Value));
                    com.Parameters.AddWithValue("@Patro", Convert.ToString(doc.Cells[2].Value));
                    com.Parameters.AddWithValue("@Spec", Convert.ToString(doc.Cells[4].Value));
                    com.Parameters.AddWithValue("@Clinic", Convert.ToString(doc.Cells[3].Value));

                    com.ExecuteNonQuery();

                    connect.CloseConnection();
                }
                catch
                {
                    MessageBox.Show("Нельзя удалить, существуют связи", "Ошибка", MessageBoxButtons.OK);
                }
            }
        }
예제 #13
0
        public void search_id_doctor(string name, string surname, string patro, string hospital, string spec)
        {
            connect = new DBConnect();
            con = new MySqlConnection();
            con = connect.con;
            if (connect.OpenConnection())
            {
                try
                {
                    MySqlCommand com = new MySqlCommand("ID_DOCTOR", con);
                    com.CommandType = CommandType.StoredProcedure;

                    com.Parameters.AddWithValue("@Name", name);
                    com.Parameters.AddWithValue("@Surname", surname);
                    com.Parameters.AddWithValue("@Patro", patro);
                    com.Parameters.AddWithValue("@clinic", hospital);
                    com.Parameters.AddWithValue("@Spec", spec);

                    id_doctor = Convert.ToInt32(com.ExecuteScalar());

                    connect.CloseConnection();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

        }
예제 #14
0
        private void TimeTable()
        {
            connect = new DBConnect();
            com1 = new MySqlCommand(@"SELECT * FROM doctor, startrecept
                                    where doctor.id_startrecept = startrecept.id_startrecept 
                                    and id_doctor = " + id_doctor, connect.con);
            com2 = new MySqlCommand(@"SELECT * FROM doctor, endrecept 
                                    where doctor.id_endrecept=endrecept.id_endrecept
                                    and id_doctor = " + id_doctor, connect.con);

            if (connect.OpenConnection())
            {
                using (MySqlDataReader dr = com1.ExecuteReader())
                {

                    while (dr.Read())
                    {
                        sMon_tb.Text = dr["Monday"].ToString();
                        sTue_tb.Text = dr["Tuesday"].ToString();
                        sWed_tb.Text = dr["Wednesday"].ToString();
                        sThu_tb.Text = dr["thursday"].ToString();
                        sFri_tb.Text = dr["Friday"].ToString();
                        sSat_tb.Text = dr["saturday"].ToString();
                        sSun_tb.Text = dr["sunday"].ToString();

                    }

                    dr.Close();
                }

                using (MySqlDataReader dr = com2.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        eMon_tb.Text = dr["Monday"].ToString();
                        eTue_tb.Text = dr["Tuesday"].ToString();
                        eWed_tb.Text = dr["Wednesday"].ToString();
                        eThu_tb.Text = dr["thursday"].ToString();
                        eFri_tb.Text = dr["Friday"].ToString();
                        eSat_tb.Text = dr["saturday"].ToString();
                        eSun_tb.Text = dr["sunday"].ToString();
                    }
                    dr.Close();
                }

                connect.CloseConnection();
            }
        }
예제 #15
0
        private void NewDoctor_Load(object sender, EventArgs e)
        {
            TimeTable();
            connect = new DBConnect();
            con = new MySqlConnection();
            con = connect.con;

            com = new MySqlCommand(@"select name_clinic from clinic", con);

            if (connect.OpenConnection())
            {
                using (MySqlDataReader dr = com.ExecuteReader())
                {

                    while (dr.Read())
                    {
                        Hospital_cb.Items.Add(dr["name_clinic"].ToString());
                    }

                    dr.Close();
                }

                connect.CloseConnection();
            }
                
            com = new MySqlCommand(@"select name_specialization from specialization", con);

            if (connect.OpenConnection())
            {
                 using (MySqlDataReader dr = com.ExecuteReader())
                    {

                        while (dr.Read())
                        {
                           
                            Specialization_cb.Items.Add(dr["name_specialization"].ToString());
                        }

                        dr.Close();
                    }
                 connect.CloseConnection();
              }
        }
예제 #16
0
        private void AddSpecialization(string name)
        {
            connect = new DBConnect();
            if (connect.OpenConnection())
            {
                try
                {
                    com = new MySqlCommand("SPECIALIZATION", connect.con);
                    com.CommandType = CommandType.StoredProcedure;
                    com.Parameters.AddWithValue("@NewName", name);
                    com.Parameters.AddWithValue("@Name", nameString);
                    com.Parameters.AddWithValue("@id", iIdRecord);
                    com.ExecuteNonQuery();

                    connect.CloseConnection();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }