Example #1
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            setalarm setalarm = new setalarm();

            setalarm.P_id                 = int.Parse(AlarmPatientIdTextBox.Text);
            setalarm.P_min_pulse_rate     = int.Parse(tbminP.Text);
            setalarm.P_max_pulse          = int.Parse(tbmaxP.Text);
            setalarm.P_min_temperature    = int.Parse(tbminT.Text);
            setalarm.P_max_temperature    = int.Parse(tbmaxT.Text);
            setalarm.P_min_breathing_rate = int.Parse(tbminB.Text);
            setalarm.P_max_breathing      = int.Parse(tbmaxB.Text);
            setalarm.P_min_blood_sys      = int.Parse(tbminS.Text);
            setalarm.P_max_sys            = int.Parse(tbmaxS.Text);
            setalarm.P_min_blood_dias     = int.Parse(tbminD.Text);
            setalarm.P_max_dias           = int.Parse(tbmaxD.Text);

            setalarmHandler setalarmHandler = new setalarmHandler();
            int             recordCnt       = setalarmHandler.addSetAlarm(databaseConnertor.getconn(), setalarm);

            MessageBox.Show(recordCnt + " record has been inserted !!");
            this.Close();
            SetAlarmLimit setAlarmLimit = new SetAlarmLimit();

            setAlarmLimit.Show();
        }
        private void searchPB_click(object sender, EventArgs e)
        {
            addPatientPanel.Hide();
            informPanel.Hide();
            medicalPanel.Hide();
            addDetailPanel.Hide();
            searchPanel.Show();

            addPatientPB.BorderStyle    = BorderStyle.None;
            medicalDetailPB.BorderStyle = BorderStyle.None;
            displayPB.BorderStyle       = BorderStyle.None;
            searchPB.BorderStyle        = BorderStyle.Fixed3D;

            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();
            addPatientHandler addPatientHandler = new addPatientHandler();

            patientDAT.DataSource = addPatientHandler.getAllPatient(databaseConnertor.getconn());

            DatabaseConnertor database = new DatabaseConnertor();

            databaseConnertor.connect();
            pmdetailsHandler pmdetailsHandler = new pmdetailsHandler();

            dataGridView1.DataSource = pmdetailsHandler.getAlldetails(databaseConnertor.getconn());
        }
Example #3
0
        private void btnSaveN_Click(object sender, EventArgs e)
        {
            DateTime     dateTime = dtpDOB.Value;
            const string after    = "yyyyMMdd";
            string       password = dateTime.ToString(after);

            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            addNurses addNurses = new addNurses();

            addNurses.S_position  = lbPN.Text;
            addNurses.S_firstName = tbFN.Text;
            addNurses.S_lastName  = tbLN.Text;
            addNurses.S_dob       = this.dtpDOB.Value;
            addNurses.S_age       = int.Parse(lbAge.Text);
            addNurses.S_email     = tbEmail.Text;
            addNurses.S_contact   = int.Parse(tbContact.Text);
            addNurses.S_loginid   = tbFN.Text + tbLN.Text;
            addNurses.S_password  = password;

            addNursesHandler addNursesHandler = new addNursesHandler();
            int recordCnt = addNursesHandler.addNewNurse(databaseConnertor.getconn(), addNurses);

            MessageBox.Show(recordCnt + " record has been inserted !!");
        }
        private void btnRegister_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            addPatient addPatient = new addPatient();

            addPatient.P_firstName        = firstNameTB.Text;
            addPatient.P_lastName         = lastNameTB.Text;
            addPatient.P_age              = int.Parse(ageLabel.Text);
            addPatient.P_dob              = this.dobDTP.Value;
            addPatient.P_contact          = int.Parse(contactTB.Text);
            addPatient.P_emergencyContact = int.Parse(emergencyContactTB.Text);
            addPatient.P_gender           = genderCB.Text;
            addPatient.P_address          = addressTB.Text;
            addPatient.P_floor            = tbFloor.Text;
            addPatient.P_bedNum           = int.Parse(tbBed.Text);
            addPatient.P_admission        = this.dtpAdmission.Value;

            addPatientHandler addPatientHandler = new addPatientHandler();
            int recordCnt = addPatientHandler.addNewPatient(databaseConnertor.getconn(), addPatient);

            MessageBox.Show(recordCnt + " record has been inserted !!");
        }
Example #5
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            addPatient addPatient = new addPatient();

            addPatient.P_firstName        = tbFN.Text;
            addPatient.P_lastName         = tbLN.Text;
            addPatient.P_age              = int.Parse(lbAge.Text);
            addPatient.P_dob              = this.dtpDob.Value;
            addPatient.P_contact          = int.Parse(tbContact.Text);
            addPatient.P_emergencyContact = int.Parse(tbEmergency.Text);
            addPatient.P_gender           = cbGender.Text;
            addPatient.P_address          = tbAddress.Text;
            addPatient.P_bedNum           = int.Parse(tbBed.Text);
            addPatient.P_floor            = tbFloor.Text;
            addPatient.P_admission        = dtpAdmission.Value;

            addPatientHandler addPatientHandler = new addPatientHandler();
            int recordCnt = addPatientHandler.addNewPatient(databaseConnertor.getconn(), addPatient);

            MessageBox.Show(recordCnt + " record has been inserted !!");
        }
        private void btnMute_Click(object sender, EventArgs e)
        {
            if (tbStaffName.Text == "")
            {
                MessageBox.Show("Insert Staff Name");
            }
            else
            {
                SendMessageW(this.Handle, WM_APPCOMMAND, this.Handle,
                             (IntPtr)APPCOMMAND_VOLUME_MUTE);

                DatabaseConnertor databaseConnertor = new DatabaseConnertor();
                databaseConnertor.connect();

                active active = new active();
                active.Ms_name             = tbStaffName.Text;
                active.Bed_number          = int.Parse(bedNo.Text);
                active.Staff_checkdatetime = DateTime.Parse(lbDateTime.Text);

                activeHandler activeHandler = new activeHandler();
                int           recordCnt1    = activeHandler.addActive(databaseConnertor.getconn(), active);

                Timer.Stop();
                MessageBox.Show("Checked Patient");
            }
        }
Example #7
0
        private void History_Load(object sender, EventArgs e)
        {
            DatabaseConnertor database = new DatabaseConnertor();

            database.connect();
            realtimeHandler realtimeHandler = new realtimeHandler();

            dgvHistory.DataSource = realtimeHandler.getAlldetails(database.getconn());

            database.connect();
            addPatientHandler addPatientHandler = new addPatientHandler();

            dgvPatient.DataSource = addPatientHandler.getAllPatient(database.getconn());
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            pmdetails pmdetails = new pmdetails();

            pmdetails.P_id          = int.Parse(patientIDTB.Text);
            pmdetails.P_systolic    = int.Parse(systolicTB.Text);
            pmdetails.P_diastolic   = int.Parse(diastolicTB.Text);
            pmdetails.P_breathing   = int.Parse(breathingTB.Text);
            pmdetails.P_pulse       = int.Parse(pulseTB.Text);
            pmdetails.P_temperater1 = double.Parse(temperatureTB.Text);

            pmdetailsHandler pmdetailsHandler = new pmdetailsHandler();
            int recordCnt2 = pmdetailsHandler.addNewDetails(databaseConnertor.getconn(), pmdetails);

            MessageBox.Show(recordCnt2 + " record has been inserted !!");
        }
Example #9
0
        private void pbRegister_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            rederegister rederegister = new rederegister();

            rederegister.Ms_id           = int.Parse(lbMedicalID.Text);
            rederegister.Register_date   = this.dateTimePicker2.Value;
            rederegister.Register_time   = tbTime.Text;
            rederegister.Deregister_date = this.dateTimePicker1.Value;
            rederegister.Deregister_time = tbDtime.Text;

            rederegisterHandler rederegisterHandler = new rederegisterHandler();
            int recordCnt1 = rederegisterHandler.addReDeregister(databaseConnertor.getconn(), rederegister);

            MessageBox.Show(recordCnt1 + " record has been inserted !!");

            this.Close();
            DeRegister deRegister = new DeRegister();

            deRegister.Show();
        }
Example #10
0
        private void registerPictureBox_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            registers register = new registers();

            register.S_id            = int.Parse(LoginIdLabel.Text);
            register.Register_date   = this.datePicker.Value;
            register.Register_time   = tbTime.Text;
            register.Deregister_date = this.datePicker1.Value;
            register.Deregister_time = tbDtime.Text;

            registerHandler registerHandler = new registerHandler();
            int             recordCnt1      = registerHandler.addRegister(databaseConnertor.getconn(), register);

            MessageBox.Show(recordCnt1 + " record has been inserted !!");

            this.Close();
            Register register1 = new Register();

            register1.Show();
        }
        private void timer2_Tick(object sender, EventArgs e)
        {
            //This code for Connet with realtime

            /*bsys.Text = RealTime.passingtext1;
             * bdia.Text = RealTime.passingtext2;
             * bpul.Text = RealTime.passingtext3;
             * bbre.Text = RealTime.passingtext4;
             * btem.Text = RealTime.passingtext5;
             * pid.Text = RealTime.passingtext6;*/

            bsrandomnum = random.Next(85, 145);
            bdrandomnum = random.Next(65, 100);
            prandomnum  = random.Next(65, 75);
            brandomnum  = random.Next(12, 20);
            trandomnum  = random.Next(36, 37);
            bsys.Text   = bsrandomnum.ToString();
            bdia.Text   = bdrandomnum.ToString();
            bpul.Text   = prandomnum.ToString();
            bbre.Text   = brandomnum.ToString();
            btem.Text   = trandomnum.ToString();

            int bsyst = int.Parse(bsys.Text);
            int bdiat = int.Parse(bdia.Text);
            int bpult = int.Parse(bpul.Text);
            int bbret = int.Parse(bbre.Text);
            int btemt = int.Parse(btem.Text);

            int sysmin = int.Parse(sysMin.Text);
            int sysmax = int.Parse(sysMax.Text);
            int diamin = int.Parse(diaMin.Text);
            int diamax = int.Parse(diaMax.Text);
            int pulmin = int.Parse(pulMin.Text);
            int pulmax = int.Parse(pulMax.Text);
            int bremin = int.Parse(breMin.Text);
            int bremax = int.Parse(breMax.Text);
            int temmin = int.Parse(temMin.Text);
            int temmax = int.Parse(temMax.Text);

            if (bsyst <= sysmin || bsyst >= sysmax)
            {
                bcolor.BackColor = Color.Red;
                SoundPlayer player1 = new System.Media.SoundPlayer(Properties.Resources.Alarm);
                player1.Play();

                DatabaseConnertor databaseConnertor = new DatabaseConnertor();
                databaseConnertor.connect();

                active active = new active();
                active.Bed_number         = int.Parse(bedNo.Text);
                active.Emergency_datetime = DateTime.Parse(lbDateTime.Text);
                active.Systolic           = int.Parse(bsys.Text);

                activeHandler activeHandler = new activeHandler();
                int           recordCnt1    = activeHandler.addActive(databaseConnertor.getconn(), active);
            }
            else if (bdiat <= diamin || bdiat >= diamax)
            {
                bcolor.BackColor = Color.Red;
                SoundPlayer player1 = new System.Media.SoundPlayer(Properties.Resources.Alarm);
                player1.Play();

                DatabaseConnertor databaseConnertor = new DatabaseConnertor();
                databaseConnertor.connect();

                active active = new active();
                active.Bed_number         = int.Parse(bedNo.Text);
                active.Emergency_datetime = DateTime.Parse(lbDateTime.Text);
                active.Diastolic          = int.Parse(bdia.Text);

                activeHandler activeHandler = new activeHandler();
                int           recordCnt1    = activeHandler.addActive(databaseConnertor.getconn(), active);
            }
            else if (bpult <= pulmin || bpult >= pulmax)
            {
                bcolor.BackColor = Color.Red;
                SoundPlayer player1 = new System.Media.SoundPlayer(Properties.Resources.Alarm);
                player1.Play();

                DatabaseConnertor databaseConnertor = new DatabaseConnertor();
                databaseConnertor.connect();

                active active = new active();
                active.Bed_number         = int.Parse(bedNo.Text);
                active.Emergency_datetime = DateTime.Parse(lbDateTime.Text);
                active.Pulse = int.Parse(bpul.Text);

                activeHandler activeHandler = new activeHandler();
                int           recordCnt1    = activeHandler.addActive(databaseConnertor.getconn(), active);
            }
            else if (bbret <= bremin || bbret >= bremax)
            {
                bcolor.BackColor = Color.Red;
                SoundPlayer player1 = new System.Media.SoundPlayer(Properties.Resources.Alarm);
                player1.Play();

                DatabaseConnertor databaseConnertor = new DatabaseConnertor();
                databaseConnertor.connect();

                active active = new active();
                active.Bed_number         = int.Parse(bedNo.Text);
                active.Emergency_datetime = DateTime.Parse(lbDateTime.Text);
                active.Breathing          = int.Parse(bbre.Text);

                activeHandler activeHandler = new activeHandler();
                int           recordCnt1    = activeHandler.addActive(databaseConnertor.getconn(), active);
            }
            else if (btemt <= temmin || btemt >= temmax)
            {
                bcolor.BackColor = Color.Red;
                SoundPlayer player1 = new System.Media.SoundPlayer(Properties.Resources.Alarm);
                player1.Play();

                DatabaseConnertor databaseConnertor = new DatabaseConnertor();
                databaseConnertor.connect();

                active active = new active();
                active.Bed_number         = int.Parse(bedNo.Text);
                active.Emergency_datetime = DateTime.Parse(lbDateTime.Text);
                active.Temperature        = int.Parse(btem.Text);

                activeHandler activeHandler = new activeHandler();
                int           recordCnt1    = activeHandler.addActive(databaseConnertor.getconn(), active);
            }
            else
            {
                bcolor.BackColor = Color.Green;
            }
        }
Example #12
0
        private void timer1_Tick(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            realtimeclass realtimeclass = new realtimeclass();

            realtimeclass.P_id          = int.Parse(pID.Text);
            realtimeclass.P_systolic    = int.Parse(lbSys.Text);
            realtimeclass.P_diastolic   = int.Parse(lbDia.Text);
            realtimeclass.P_breathing   = int.Parse(lbBre.Text);
            realtimeclass.P_pulse       = int.Parse(lbPul.Text);
            realtimeclass.P_temperature = int.Parse(lbTem.Text);

            realtimeHandler realtimeHandler = new realtimeHandler();
            int             recordCnt1      = realtimeHandler.addRealTime(databaseConnertor.getconn(), realtimeclass);

            bsrandomnum = random.Next(105, 145);
            bdrandomnum = random.Next(65, 100);
            prandomnum  = random.Next(65, 75);
            //prandomnum = random.Next(0);
            brandomnum = random.Next(12, 20);
            trandomnum = random.Next(36, 37);
            lbSys.Text = bsrandomnum.ToString();
            lbDia.Text = bdrandomnum.ToString();
            lbPul.Text = prandomnum.ToString();
            lbBre.Text = brandomnum.ToString();
            lbTem.Text = trandomnum.ToString();

            chart1.Series[0].Points.AddXY(bstime++, bsrandomnum);
            chart1.Series[0].Color = Color.LightGreen;
            chart1.Series[1].Points.AddXY(bdtime++, bdrandomnum);
            if (chart1.Series[0].Points.Count > 5)
            {
                chart1.Series[0].Points.Remove(chart1.Series[0].Points[0]);
                chart1.ChartAreas[0].AxisX.Minimum = chart1.Series[0].Points[0].XValue;
                chart1.ChartAreas[0].AxisX.Maximum = bstime;
            }

            chart2.Series[0].Points.AddXY(ptime++, prandomnum);
            chart2.Series[0].Color = Color.LightGreen;

            if (chart2.Series[0].Points.Count > 5)
            {
                chart2.Series[0].Points.Remove(chart2.Series[0].Points[0]);
                chart2.ChartAreas[0].AxisX.Minimum = chart2.Series[0].Points[0].XValue;
                chart2.ChartAreas[0].AxisX.Maximum = ptime;
            }

            chart3.Series[0].Points.AddXY(btime++, brandomnum);
            chart3.Series[0].Color = Color.LightGreen;

            if (chart3.Series[0].Points.Count > 5)
            {
                chart3.Series[0].Points.Remove(chart3.Series[0].Points[0]);
                chart3.ChartAreas[0].AxisX.Minimum = chart3.Series[0].Points[0].XValue;
                chart3.ChartAreas[0].AxisX.Maximum = btime;
            }

            chart4.Series[0].Points.AddXY(ttime++, trandomnum);
            chart4.Series[0].Color = Color.LightGreen;

            if (chart4.Series[0].Points.Count > 5)
            {
                chart4.Series[0].Points.Remove(chart4.Series[0].Points[0]);
                chart4.ChartAreas[0].AxisX.Minimum = chart4.Series[0].Points[0].XValue;
                chart4.ChartAreas[0].AxisX.Maximum = ttime;
            }



            if (lbPul.Text == "0")
            {
                timer.Stop();
                // SoundPlayer player = new System.Media.SoundPlayer();
                SoundPlayer player1 = new SoundPlayer(Properties.Resources.BedsideSoundss);
                player1.Play();
                // player.Stop();
            }

            else
            {
                System.Media.SoundPlayer player = new System.Media.SoundPlayer(Properties.Resources.BedsideSounds);
                player.Play();
            }

            passingtext1 = lbSys.Text;
            passingtext2 = lbDia.Text;
            passingtext3 = lbPul.Text;
            passingtext4 = lbBre.Text;
            passingtext5 = lbTem.Text;
            passingtext6 = pID.Text;
        }