private void patientDataGridView_SelectionChanged(object sender, EventArgs e)
 {
     if (patientDataGridView.SelectedRows.Count == 1)
     {
         testDAO tD = new testDAO();
         DataSet ds = new DataSet();
         ds = tD.getTests();
         foreach (DataRow row in ds.Tables[0].Rows)
         {
             string testId = row["testId"].ToString();
             if (testId == patientDataGridView.SelectedRows[0].Cells[8].Value.ToString())
             {
                 testBox.Text = row["price"].ToString();
                 break;
             }
         }
     }
 }
        private void addButton_Click(object sender, EventArgs e)
        {
            if (testNameBox.Text == "" || testCategoryBox.Text == "" || testPriceBox.Text == "" || roomComboBox.Items.Count == 0)
            {
                MessageBox.Show("Please give all information");
                return;
            }

            string  name     = testNameBox.Text;
            string  category = testCategoryBox.Text;
            string  roomNo   = roomComboBox.SelectedItem.ToString();
            int     price    = Convert.ToInt32(testPriceBox.Text);
            testDTO t        = new testDTO(name, category, roomNo, price);
            testDAO tD       = new testDAO();

            tD.createTest(t);
            clearFields();
        }
Exemplo n.º 3
0
        private void setComboBox()
        {
            roomComboBox.Items.Clear();
            roomComboBox.Text = "";
            doctorComboBox.Items.Clear();
            doctorComboBox.Text = "";
            testComboBox.Items.Clear();
            testComboBox.Text = "";

            roomDAO             rD             = new roomDAO();
            DataSet             ds             = rD.getRooms();
            LinkedList <string> listOfAllRooms = new LinkedList <string>();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                string roomNo = row["roomNo"].ToString();
                //roomComboBox.Items.Add(roomNo);
                listOfAllRooms.AddLast(roomNo);
            }
            patientDAO pD = new patientDAO();

            ds = pD.getPatients();
            LinkedList <string> listOfUsedRooms = new LinkedList <string>();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                string roomNo = row["roomNo"].ToString();
                //roomComboBox.Items.Add(roomNo);
                listOfUsedRooms.AddLast(roomNo);
            }
            LinkedList <string> listOfUnUsedRooms = new LinkedList <string>();

            for (int i = 0; i < listOfAllRooms.Count; i++)
            {
                bool flag = true;
                for (int j = 0; j < listOfUsedRooms.Count; j++)
                {
                    string allRoom  = listOfAllRooms.ElementAt(i);
                    string usedRoom = listOfUsedRooms.ElementAt(j);
                    if (allRoom == usedRoom)
                    {
                        flag = false;
                        break;
                    }
                }
                if (flag)
                {
                    listOfUnUsedRooms.AddLast(listOfAllRooms.ElementAt(i));
                }
            }
            for (int i = 0; i < listOfUnUsedRooms.Count; i++)
            {
                string roomNo = listOfUnUsedRooms.ElementAt(i);
                roomComboBox.Items.Add(roomNo);
            }


            if (roomComboBox.Items.Count > 0)
            {
                roomComboBox.SelectedIndex = 0;
            }

            doctorDAO dD = new doctorDAO();

            ds = dD.getDoctors();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                int    doctorId = Convert.ToInt32(row["doctorId"].ToString());
                string name     = row["name"].ToString();
                doctorComboBox.Items.Add(doctorId + "," + name);
            }
            if (doctorComboBox.Items.Count > 0)
            {
                doctorComboBox.SelectedIndex = 0;
            }

            testDAO tD = new testDAO();

            ds = tD.getTests();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                int    testId   = Convert.ToInt32(row["testId"].ToString());
                string name     = row["name"].ToString();
                string category = row["category"].ToString();
                testComboBox.Items.Add(testId + "," + name + "," + category);
            }
            if (testComboBox.Items.Count > 0)
            {
                testComboBox.SelectedIndex = 0;
            }
        }
        private void patientDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            bool blank = false;

            if (patientDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[3].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[4].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[5].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[6].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[7].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[8].Value.ToString() == "")
            {
                blank = true;
            }
            if (patientDataGridView.Rows[e.RowIndex].Cells[9].Value.ToString() == "")
            {
                blank = true;
            }

            if (blank)
            {
                loadPatientsInfo();
                return;
            }


            int    patientId   = Convert.ToInt32(patientDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString());
            string name        = patientDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
            string gender      = patientDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();
            string age         = patientDataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();
            string address     = patientDataGridView.Rows[e.RowIndex].Cells[4].Value.ToString();
            string phone       = patientDataGridView.Rows[e.RowIndex].Cells[5].Value.ToString();
            string roomNo      = patientDataGridView.Rows[e.RowIndex].Cells[6].Value.ToString();
            int    doctorId    = Convert.ToInt32(patientDataGridView.Rows[e.RowIndex].Cells[7].Value.ToString());
            int    testId      = Convert.ToInt32(patientDataGridView.Rows[e.RowIndex].Cells[8].Value.ToString());
            string checkinDate = patientDataGridView.Rows[e.RowIndex].Cells[9].Value.ToString();

            DataSet   ds = new DataSet();
            roomDAO   rD = new roomDAO();
            testDAO   tD = new testDAO();
            doctorDAO dD = new doctorDAO();

            ds = rD.getRooms();
            bool flag = false;

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                string rN = row["roomNo"].ToString();
                if (roomNo == rN)
                {
                    flag = true;
                    break;
                }
            }
            if (flag == false)
            {
                loadPatientsInfo();
                return;
            }


            ds   = tD.getTests();
            flag = false;
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                string tI = row["testId"].ToString();
                if (testId == Convert.ToInt32(tI))
                {
                    flag = true;
                    break;
                }
            }
            if (flag == false)
            {
                loadPatientsInfo();
                return;
            }

            ds   = dD.getDoctors();
            flag = false;
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                string dI = row["doctorId"].ToString();
                if (doctorId == Convert.ToInt32(dI))
                {
                    flag = true;
                    break;
                }
            }
            if (flag == false)
            {
                loadPatientsInfo();
                return;
            }



            p = new patientDTO(patientId, name, gender, age, address, phone, roomNo, doctorId, testId, checkinDate);
            pD.updatePatient(p);
            loadPatientsInfo();
        }