예제 #1
0
        void populate()
        {
            Pasien  Pat   = new Pasien();
            string  query = "select * from UserTab";
            DataSet ds    = Pat.ShowPatient(query);

            UserDGV.DataSource = ds.Tables[0];
        }
예제 #2
0
        void populate()
        {
            Pasien  Pat   = new Pasien();
            string  query = "select * from PrescriptionTab";
            DataSet ds    = Pat.ShowPatient(query);

            PrescDGV.DataSource = ds.Tables[0];
        }
예제 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            string query = "insert into PasTab values('" + PatNameTab.Text + "','" + PatHpTab.Text + "','" + PatAddresTab.Text + "','" + DOBDateCb.Value.Date + "','" + GenCb.SelectedItem.ToString() + "','" + PatAllergiesTab.Text + "')";
            Pasien Pat   = new Pasien();

            try
            {
                Pat.AddPatient(query);
                MessageBox.Show("Patient Sucesfully Added");
                populate();
            }catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
        }
예제 #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            string query = "insert into UserTab values('" + UsNameTab.Text + "'," + UsPassw.Text + ",'" + UsPassw.Text + "')";
            Pasien Pat   = new Pasien();

            try
            {
                Pat.AddPatient(query);
                MessageBox.Show("User Sucesfully Added");
                populate();
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
        }
예제 #5
0
        private void button1_Click(object sender, EventArgs e)
        {
            string query = "insert into AppointmentTab values('" + PatientCb.SelectedValue.ToString() + "','" + TreatmentCb.SelectedValue.ToString() + "','" + Date.Value.Date + "','" + Time.Value.TimeOfDay + "')";
            Pasien Pat   = new Pasien();

            try
            {
                Pat.AddPatient(query);
                MessageBox.Show("Appointment Sucesfully Recorded");
                populate();
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
        }
예제 #6
0
        private void button1_Click(object sender, EventArgs e)
        {
            string query = "insert into PrescriptionTab values('" + PasId.SelectedValue.ToString() + "','" + TreatmentTab.Text + "','" + TreatCostTab.Text + "', '" + MedTab.Text + "', '" + QtyTab.Text + "')";
            Pasien Pat   = new Pasien();

            try
            {
                Pat.AddPatient(query);
                MessageBox.Show("Treatment Sucesfully Added");
                populate();
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
        }
예제 #7
0
        private void DelButt_Click(object sender, EventArgs e)
        {
            Pasien Pat = new Pasien();

            if (key == 0)
            {
                MessageBox.Show("Select the Patient");
            }
            else
            {
                try
                {
                    string query = "Delete from PrescriptionTab where PrescId=" + key + "";
                    Pat.DeletePatient(query);
                    MessageBox.Show("Patient Sucesfully Deleted");
                    populate();
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
            //Pasien Pat = new Pasien();
            //if (key == 0)
            //{
            //    MessageBox.Show("Select the Prescription to Cancel");

            //}
            //else
            //{
            //    try
            //    {

            //        string query = "Delete from PrescriptionTab where PrescId=" + key + "";
            //        Pat.DeletePatient(query);
            //        MessageBox.Show("Prescription Succesfully Deleted");
            //        populate();
            //    }
            //    catch (Exception Ex)
            //    {
            //        MessageBox.Show(Ex.Message);
            //    }
            //}
        }
예제 #8
0
        private void button2_Click(object sender, EventArgs e)
        {
            Pasien Pat = new Pasien();

            if (key == 0)
            {
                MessageBox.Show("Select the User to Delete");
            }
            else
            {
                try
                {
                    string query = "Delete from UserTab where Ud=" + key + "";
                    Pat.DeletePatient(query);
                    MessageBox.Show("User Succesfully Deleted");
                    populate();
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
        }
예제 #9
0
        private void button2_Click(object sender, EventArgs e)
        {
            Pasien Pat = new Pasien();

            if (key == 0)
            {
                MessageBox.Show("Select the Appointment to Cancel");
            }
            else
            {
                try
                {
                    string query = "Delete from AppointmentTab where Apid=" + key + "";
                    Pat.DeletePatient(query);
                    MessageBox.Show("Appointement Succesfully Deleted");
                    populate();
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
        }
예제 #10
0
        private void button3_Click(object sender, EventArgs e)
        {
            Pasien Pat = new Pasien();

            if (key == 0)
            {
                MessageBox.Show("Select the User");
            }
            else
            {
                try
                {
                    string query = "Update UserTab set Uname='" + UsNameTab.Text + "',Upass="******",Uhp='" + UsPhoneTab.Text + "'where Ud=" + key + ";";

                    Pat.DeletePatient(query);
                    MessageBox.Show("User Sucesfully Updated");
                    populate();
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
        }
예제 #11
0
        private void button3_Click(object sender, EventArgs e)
        {
            Pasien Pat = new Pasien();

            if (key == 0)
            {
                MessageBox.Show("Select the Patient");
            }
            else
            {
                try
                {
                    string query = "Update PasTab set PatName='" + PatNameTab.Text + "',PatHp='" + PatHpTab.Text + "',PatAddress='" + PatAddresTab.Text + "',PatDOB='" + DOBDateCb.Value.Date + "',PatGender='" + GenCb.SelectedItem.ToString() + "',PatAllergies='" + PatAllergiesTab.Text + "'where Patid=" + key + "";

                    Pat.DeletePatient(query);
                    MessageBox.Show("Patient Sucesfully Updated");
                    populate();
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
        }
예제 #12
0
        private void button3_Click(object sender, EventArgs e)
        {
            Pasien Pat = new Pasien();

            if (key == 0)
            {
                MessageBox.Show("Select the Treatment");
            }
            else
            {
                try
                {
                    string query = "Update TreatmentTab set TreatName='" + TreatmentNameTab.Text + "',TreatDesc='" + TreatmentDesc.Text + "',TreatCost='" + TreatmentCostTab.Text + "'where Treatid=" + key + "";

                    Pat.DeletePatient(query);
                    MessageBox.Show("Treatment Sucesfully Updated");
                    populate();
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
        }
예제 #13
0
        private void button3_Click(object sender, EventArgs e)
        {
            Pasien Pat = new Pasien();

            if (key == 0)
            {
                MessageBox.Show("Select the Patient");
            }
            else
            {
                try
                {
                    string query = "Update AppointmentTab set Patient='" + PatientCb.SelectedValue.ToString() + "',Treatment='" + TreatmentCb.SelectedValue.ToString() + "',ApDate='" + Date.Value.Date + "',ApTime='" + Time.Value.TimeOfDay + "'where Apid=" + key + "";

                    Pat.DeletePatient(query);
                    MessageBox.Show("Appointment Sucesfully Updated");
                    populate();
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
        }