Example #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            PatientPage ob = new PatientPage();

            ob.Show();
            this.Hide();
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string     yes = "Yes";
            connection sv  = new connection();

            sv.thisConnection.Open();
            if (rel_date == "0")
            {
                OracleCommand thisCommand4 = sv.thisConnection.CreateCommand();
                thisCommand4.CommandText =
                    "update patient_data set release_date ='" + tday + "',if_release_paid ='" + yes + "'," +
                    "rel_amount='" + textBox1.Text + "' where p_id= '" + p_id.Text + "'";

                thisCommand4.Connection  = sv.thisConnection;
                thisCommand4.CommandType = CommandType.Text;
                //For Insert Data Into Oracle//
                try
                {
                    thisCommand4.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }


                OracleCommand thisCommand2 = sv.thisConnection.CreateCommand();
                //  textBox1.Text = "";
                thisCommand2.CommandText =
                    "SELECT * FROM ward_allocation where ward_no= '" + wardNo + "'";

                OracleDataReader thisReader2 = thisCommand2.ExecuteReader();

                while (thisReader2.Read())
                {
                    //   string ad_cost = thisReader["admit_cost"].ToString();
                    string tb       = thisReader2["total_bed"].ToString();
                    int    totalbed = Convert.ToInt32(tb);
                    bf = thisReader2["bed_free"].ToString();
                    int bedFre = Convert.ToInt32(bf);
                    if (bedFre <= totalbed)
                    {
                        int bed = (bedFre + 1);
                        bedFree = bed.ToString();
                    }
                    else if (bedFre > totalbed)
                    {
                        bedFree = tb;
                    }

                    try
                    {
                        // string filePath = thisReader["picture"].ToString();
                        // this.pb_profilepics.Image = Image.FromFile(filePath);
                    }
                    catch
                    { MessageBox.Show("Failure"); }
                }


                OracleCommand thisCommand3 = sv.thisConnection.CreateCommand();

                thisCommand3.CommandText =
                    "update ward_allocation set bed_free ='" + bedFree + "' where ward_no= '" + wardNo + "'";

                thisCommand3.Connection  = sv.thisConnection;
                thisCommand3.CommandType = CommandType.Text;
                //For Insert Data Into Oracle//
                try
                {
                    thisCommand3.ExecuteNonQuery();
                    MessageBox.Show("released");
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }



                if (bf != "0")
                {
                    OracleCommand thisCommand5 = sv.thisConnection.CreateCommand();
                    thisCommand5.CommandText =
                        "update ward_allocation set  empty_ward = ward_no where ward_no= '" + wardNo + "'";

                    OracleDataReader thisReader4 = thisCommand5.ExecuteReader();
                }

                else if (bf == "0")
                {
                    OracleCommand thisCommand6 = sv.thisConnection.CreateCommand();
                    thisCommand6.CommandText =
                        "update ward_allocation set  empty_ward = 0 where ward_no= '" + wardNo + "'";

                    OracleDataReader thisReader7 = thisCommand6.ExecuteReader();
                }
            }
            else
            {
                MessageBox.Show("Have been released");
            }


            sv.thisConnection.Close();

            PatientPage ob = new PatientPage();

            ob.Show();
            this.Hide();
        }
        private void button3_Click(object sender, EventArgs e)
        {
            connection CN = new connection();

            CN.thisConnection.Open();

            if (seri >= 0)
            {
                seri = seri - 1;
                OracleCommand thisCommand3 = CN.thisConnection.CreateCommand();

                thisCommand3.CommandText =
                    "update DOCTOR_DATA set doc_visit_lim ='" + seri + "' where DOC_ID= '" + doc_ID + "'";

                thisCommand3.Connection  = CN.thisConnection;
                thisCommand3.CommandType = CommandType.Text;
                //For Insert Data Into Oracle//
                try
                {
                    thisCommand3.ExecuteNonQuery();
                    //  MessageBox.Show("Updated");
                    this.Hide();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }

                button2WasClicked = true;
                connection sv = new connection();
                sv.thisConnection.Open();
                OracleDataAdapter thisAdapter = new OracleDataAdapter("SELECT * FROM doctor_appointment", sv.thisConnection);

                OracleCommandBuilder thisBuilder = new OracleCommandBuilder(thisAdapter);

                DataSet thisDataSet = new DataSet();
                thisAdapter.Fill(thisDataSet, "doctor_appointment");

                DataRow thisRow = thisDataSet.Tables["doctor_appointment"].NewRow();
                try
                {
                    thisRow["patient_name"] = textBox1.Text;
                    thisRow["token_id"]     = textBox3.Text;
                    thisRow["p_age"]        = textBox2.Text;
                    thisRow["mobile"]       = textBox6.Text;
                    thisRow["req_date"]     = dateTimePicker1.Value.ToString();
                    thisRow["doc_name"]     = comboBox1.Text;
                    thisRow["department"]   = comboBox2.Text;
                    thisRow["visit_status"] = "no comp";


                    thisDataSet.Tables["doctor_appointment"].Rows.Add(thisRow);



                    int a = thisAdapter.Update(thisDataSet, "doctor_appointment");

                    if (a == 1)
                    {
                        MessageBox.Show("Successful");
                    }
                }

                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    seri = seri + 1;
                    OracleCommand thisCommand4 = CN.thisConnection.CreateCommand();

                    thisCommand4.CommandText =
                        "update DOCTOR_DATA set doc_visit_lim ='" + seri + "' where DOC_ID= '" + doc_ID + "'";

                    thisCommand4.Connection  = CN.thisConnection;
                    thisCommand4.CommandType = CommandType.Text;
                    //For Insert Data Into Oracle//
                    try
                    {
                        thisCommand4.ExecuteNonQuery();
                        //  MessageBox.Show("Updated");
                        this.Hide();
                    }
                    catch (Exception dx)
                    {
                        Console.WriteLine(dx.Message);
                    }
                }

                sv.thisConnection.Close();
                PatientPage ob = new PatientPage();
                ob.Show();
                this.Hide();
            }
            else
            {
                MessageBox.Show("Doctor visit Limit out!!!!");
            }
        }
Example #4
0
        private void logincheck()
        {
            if (!(String.IsNullOrEmpty(textBox1.Text) || String.IsNullOrEmpty(textBox2.Text)))
            {
                try
                {
                    connection CN = new connection();
                    CN.thisConnection.Open();
                    OracleCommand thisCommand = new OracleCommand();
                    thisCommand.Connection  = CN.thisConnection;
                    thisCommand.CommandText = "SELECT * FROM HOSPITAL_LOGIN WHERE username='******' AND password='******'";
                    thisReader = thisCommand.ExecuteReader();



                    if (thisReader.Read())
                    {
                        if (comboBox1.Text == "Administrator" && thisReader["designation"].ToString() == "admin")
                        {
                            AdminPage oform = new AdminPage();
                            oform.Show();
                            this.Hide();
                        }
                        else if (comboBox1.Text == "Doctor" && thisReader["designation"].ToString() == "doctor")
                        {
                            DoctorPage pat = new DoctorPage(textBox1.Text);
                            pat.Show();
                            this.Hide();
                        }
                        else if (comboBox1.Text == "Receptionist" && thisReader["designation"].ToString() == "receptionist")
                        {
                            PatientPage oform = new PatientPage();
                            oform.Show();
                            this.Hide();
                        }
                        else if (comboBox1.Text == "Compounder" && thisReader["designation"].ToString() == "compounder")
                        {
                            compounder oform = new compounder();
                            oform.Show();
                            this.Hide();
                        }
                        else if (comboBox1.Text == "Nurse" && thisReader["designation"].ToString() == "nurse")
                        {
                            nurse_page oform = new nurse_page();
                            oform.Show();
                            this.Hide();
                        }
                        else
                        {
                            MessageBox.Show("select your using position");
                        }
                    }
                    else
                    {
                        MessageBox.Show("username or password incorrect");
                    }
                    //this.Close();
                    CN.thisConnection.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }


            else
            {
                MessageBox.Show("Please input username and password!!!!");
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            button2WasClicked = true;

            connection sv = new connection();

            sv.thisConnection.Open();
            OracleDataAdapter thisAdapter = new OracleDataAdapter("SELECT * FROM patient_data", sv.thisConnection);

            OracleCommandBuilder thisBuilder = new OracleCommandBuilder(thisAdapter);

            DataSet thisDataSet = new DataSet();

            thisAdapter.Fill(thisDataSet, "patient_data");

            DataRow thisRow = thisDataSet.Tables["patient_data"].NewRow();

            try
            {
                thisRow["p_id"]         = p_id.Text;
                thisRow["p_name"]       = p_name.Text;
                thisRow["p_mobile"]     = p_mob.Text;
                thisRow["address"]      = p_add.Text;
                thisRow["refdoctor"]    = comboBox1.Text;
                thisRow["admit_date"]   = dateTimePicker1.Value.ToString();
                thisRow["ward_no"]      = ward_no.Text;
                thisRow["total_cost"]   = textBox1.Text;
                thisRow["if_paid"]      = "Yes";
                thisRow["release_date"] = "0";

                thisDataSet.Tables["patient_data"].Rows.Add(thisRow);

                int a = thisAdapter.Update(thisDataSet, "patient_data");

                if (a == 1)
                {
                    MessageBox.Show("Successful");
                }
            }

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


            if (!String.IsNullOrEmpty(ward_no.Text))
            {
                OracleCommand thisCommand4 = sv.thisConnection.CreateCommand();
                thisCommand4.CommandText =
                    "SELECT * FROM ward_allocation where ward_no= '" + ward_no.Text + "'";

                OracleDataReader thisReader3 = thisCommand4.ExecuteReader();
                //
                while (thisReader3.Read())
                {
                    string cmd2 = thisReader3["bed_free"].ToString();
                    int    cc2  = Convert.ToInt32(cmd2);


                    if (cc2 > 0)
                    {
                        result = (cc2 - 1);
                        res    = result.ToString();
                    }

                    else
                    {
                        res = "0";
                    }


                    if (cmd2 != "0")
                    {
                        OracleCommand thisCommand5 = sv.thisConnection.CreateCommand();
                        thisCommand5.CommandText =
                            "update ward_allocation set  empty_ward = ward_no where ward_no= '" + ward_no.Text + "'";

                        OracleDataReader thisReader4 = thisCommand5.ExecuteReader();
                    }

                    else if (cmd2 == "0")
                    {
                        OracleCommand thisCommand6 = sv.thisConnection.CreateCommand();
                        thisCommand6.CommandText =
                            "update ward_allocation set  empty_ward = 0 where ward_no= '" + ward_no.Text + "'";

                        OracleDataReader thisReader7 = thisCommand6.ExecuteReader();
                    }

                    OracleCommand thisCommand3 = sv.thisConnection.CreateCommand();
                    thisCommand3.CommandText =
                        "update ward_allocation set " +
                        "bed_free='" + res + "' where ward_no= '" + ward_no.Text + "'";

                    thisCommand3.Connection  = sv.thisConnection;
                    thisCommand3.CommandType = CommandType.Text;
                    try
                    {
                        thisCommand3.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                }
            }

            sv.thisConnection.Close();
            PatientPage ob = new PatientPage();

            ob.Show();
            this.Hide();
        }