コード例 #1
0
        private void stergeInregistrareToolStripMenuItem_Click(object sender, EventArgs e)
        {
            OleDbConnection conexiune = new OleDbConnection(Provider);
            OleDbCommand    comanda   = new OleDbCommand();

            comanda.Connection = conexiune;

            try
            {
                conexiune.Open();
                comanda.Transaction = conexiune.BeginTransaction();

                comanda.CommandText = "SELECT nume FROM pacienti WHERE id_pacient = @id";
                comanda.Parameters.Add("id", OleDbType.Integer).Value = Convert.ToInt32(((Pacienti)listView1.SelectedItems[0].Tag).Id_pacient);
                string nume_pacient = comanda.ExecuteNonQuery().ToString();

                comanda.CommandText = "DELETE FROM pacienti WHERE id_pacient = @id_pacient";

                comanda.Parameters.Add("id_pacient", OleDbType.Integer).Value = Convert.ToInt32(((Pacienti)listView1.SelectedItems[0].Tag).Id_pacient);

                //stergem pacientul si din lista medicului de care apartine
                Form_Medici     form_Med     = new Form_Medici();
                List <TreeNode> lista_medici = new List <TreeNode>();

                foreach (TreeNode medic in form_Med.treeView1.Nodes)
                {
                    lista_medici.Add(medic);
                }

                int j = 0;
                while (j < lista_medici.Count && nume_pacient != lista_medici[j].ToString())
                {
                    j++;
                }

                if (j == lista_medici.Count)
                {
                }
                else
                {
                    form_Med.treeView1.Nodes.Remove(form_Med.treeView1.Nodes[j]);
                }

                comanda.ExecuteScalar();
                comanda.Transaction.Commit();
            }catch (OleDbException ex)
            {
                MessageBox.Show(ex.Message);
                comanda.Transaction.Rollback();
            }
            finally
            {
                conexiune.Close();
            }

            UpdateList();
        }
コード例 #2
0
        private void mediciBTN_Click(object sender, EventArgs e)
        {
            Form_Medici form_Medici = new Form_Medici();

            form_Medici.ShowDialog();
        }
コード例 #3
0
        private void adaugaIntregistrareToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form_adauga_pacient form_add_pacient = new Form_adauga_pacient();

            form_add_pacient.ShowDialog();

            if (form_add_pacient.DialogResult == DialogResult.OK)
            {
                OleDbConnection conexiune = new OleDbConnection(Provider);
                OleDbCommand    comanda   = new OleDbCommand();
                comanda.Connection = conexiune;

                try
                {
                    conexiune.Open();
                    comanda.Transaction = conexiune.BeginTransaction();

                    comanda.CommandText = "SELECT max(id_pacient) FROM pacienti";
                    int cod = Convert.ToInt32(comanda.ExecuteScalar());

                    comanda.CommandText = "INSERT INTO pacienti(id_pacient,nume,varsta,denumire_boala,grupa_sange,alergii,CNP,medic)  VALUES(@id_pacient,@nume,@varsta,@denumire_boala,@grupa_sange,@alergii,@CNP,@medic)";

                    comanda.Parameters.Add("id_pacient", OleDbType.Integer).Value  = cod + 1;
                    comanda.Parameters.Add("nume", OleDbType.Char).Value           = form_add_pacient.pacient.Nume;
                    comanda.Parameters.Add("varsta", OleDbType.Integer).Value      = form_add_pacient.pacient.Varsta;
                    comanda.Parameters.Add("denumire_boala", OleDbType.Char).Value = form_add_pacient.pacient.Denumire_boala;
                    comanda.Parameters.Add("grupa_sange", OleDbType.Char).Value    = form_add_pacient.pacient.Grupa_sange;
                    comanda.Parameters.Add("alergii", OleDbType.Char).Value        = form_add_pacient.pacient.Alergii;
                    comanda.Parameters.Add("CNP", OleDbType.Char).Value            = form_add_pacient.pacient.Cnp;
                    comanda.Parameters.Add("medic", OleDbType.Char).Value          = form_add_pacient.pacient.Medic;

                    Form_Medici     form_Med     = new Form_Medici();
                    List <TreeNode> lista_medici = new List <TreeNode>();

                    foreach (TreeNode medic in form_Med.treeView1.Nodes)
                    {
                        lista_medici.Add(medic);
                    }

                    //for(int i = 0; i<lista_medici.Count; i++)
                    //{
                    //  MessageBox.Show(lista_medici[i].ToString());
                    //}

                    int j = 0;
                    while (j < lista_medici.Count && form_add_pacient.pacient.Medic != lista_medici[j].ToString())
                    {
                        j++;
                    }
                    //MessageBox.Show("Medicul " + lista_medici[j].ToString());
                    if (j == lista_medici.Count)      //daca a ajuns la finalul listei si nu a gasit medicul in lista => nod nou si adauga medic nou
                    {
                        MessageBox.Show("Medicul introdus nu figureaza in baza de date. Doriti o inregistrare noua?", "Question", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                        form_Med.adaugaInregistrareToolStripMenuItem_Click(sender, e, form_add_pacient.pacient.Medic);
                        //MessageBox.Show("Medic adaugat", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else     // daca a gasit medicul cautat => adauga un copil la nodul respectiv
                    {
                        MessageBox.Show(Convert.ToString(lista_medici[j]));
                        MessageBox.Show(form_add_pacient.pacient.Nume);
                        MessageBox.Show(form_add_pacient.pacient.Denumire_boala);
                        form_Med.treeView1.Nodes[j].Nodes.Add(form_add_pacient.pacient.Nume + ", diagnosticat cu " + form_add_pacient.pacient.Denumire_boala);
                        MessageBox.Show("S-a adaugat pacientul la un medic deja existent!!!!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    // form_Med.nr_pacienti++;

                    comanda.ExecuteNonQuery();
                    comanda.Transaction.Commit();
                }catch (OleDbException ex)
                {
                    MessageBox.Show(ex.Message);
                    comanda.Transaction.Rollback();
                }
                finally
                {
                    conexiune.Close();
                }
                UpdateList();
            }
        }
コード例 #4
0
        private void modificaInregistrareToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form_adauga_pacient form_adauga_pacient = new Form_adauga_pacient((Pacienti)listView1.SelectedItems[0].Tag);

            form_adauga_pacient.ShowDialog();

            if (form_adauga_pacient.DialogResult == DialogResult.OK)
            {
                OleDbConnection conexiune = new OleDbConnection(Provider);
                OleDbCommand    comanda   = new OleDbCommand();
                comanda.Connection = conexiune;

                try
                {
                    conexiune.Open();
                    comanda.Transaction = conexiune.BeginTransaction();

                    // comanda.CommandText = "SELECT nume FROM pacienti WHERE id_pacient = @id";
                    //comanda.Parameters.Add("id", OleDbType.Integer).Value = Convert.ToInt32(((Pacienti)listView1.SelectedItems[0].Tag).Id_pacient);
                    // string nume_pacient = comanda.ExecuteScalar().ToString();

                    comanda.CommandText = "UPDATE pacienti SET nume =@nume, varsta =@varsta, denumire_boala =@denumire_boala, grupa_sange =@grupa_sange, alergii = @alergii, CNP = @cnp,medic =@medic WHERE id_pacient = @id_pacient";

                    comanda.Parameters.Add("nume", OleDbType.Char).Value           = form_adauga_pacient.pacient.Nume;
                    comanda.Parameters.Add("varsta", OleDbType.Integer).Value      = form_adauga_pacient.pacient.Varsta;
                    comanda.Parameters.Add("denumire_boala", OleDbType.Char).Value = form_adauga_pacient.pacient.Denumire_boala;
                    comanda.Parameters.Add("grupa_sange", OleDbType.Char).Value    = form_adauga_pacient.pacient.Grupa_sange;
                    comanda.Parameters.Add("alergii", OleDbType.Char).Value        = form_adauga_pacient.pacient.Alergii;
                    comanda.Parameters.Add("cnp", OleDbType.Char).Value            = form_adauga_pacient.pacient.Cnp;
                    comanda.Parameters.Add("medic", OleDbType.Char).Value          = form_adauga_pacient.pacient.Medic;
                    comanda.Parameters.Add("id_pacient", OleDbType.Integer).Value  = Convert.ToInt32(((Pacienti)listView1.SelectedItems[0].Tag).Id_pacient);

                    //facem update si in lista medicilor cu pacienti

                    Form_Medici     form_Med     = new Form_Medici();
                    List <TreeNode> lista_medici = new List <TreeNode>();

                    foreach (TreeNode medic in form_Med.treeView1.Nodes)
                    {
                        lista_medici.Add(medic);
                    }

                    int j = 0;
                    while (j < lista_medici.Count && form_adauga_pacient.pacient.Nume != lista_medici[j].ToString())
                    {
                        j++;
                    }

                    TreeNode nou = new TreeNode(form_adauga_pacient.pacient.Nume + ", diagnosticat cu" + form_adauga_pacient.pacient.Denumire_boala);

                    if (j == lista_medici.Count)
                    {
                    }
                    else
                    {
                        form_Med.treeView1.Nodes[j] = nou;
                    }

                    comanda.ExecuteNonQuery();
                    comanda.Transaction.Commit();
                }
                catch (OleDbException ex)
                {
                    MessageBox.Show(ex.Message);
                    comanda.Transaction.Rollback();
                }
                finally
                {
                    conexiune.Close();
                }

                UpdateList();
            }
        }