private void ultraBtnRefresh_Click(object sender, EventArgs e)
        {
            try
            {
                objHospitalDB = new HospitalDB();
                Doctor    objDoctor    = new Doctor(objHospitalDB);
                DoctorRow objDoctorRow = new DoctorRow();
                ultraGridDoc.DataSource = objDoctor.GetAll();

                /* dsDoctor = new DataSet();
                 * SqlCommand cmd = objHospitalDB.CreateCommand("Select * from [Hospital].[dbo].[Doctor]", false);
                 * SqlDataAdapter sda = new SqlDataAdapter();
                 * sda.SelectCommand = cmd;
                 * sda.Fill(dsDoctor);
                 * ultraGridDoc.DataSource = dsDoctor.Tables[0];*/
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                if (objHospitalDB != null)
                {
                    objHospitalDB.Dispose();
                }
            }
        }
        private void frmDoctorView_Load(object sender, EventArgs e)
        {
            objHospitalDB = new HospitalDB();
            Doctor    objDoctor    = new Doctor(objHospitalDB);
            DoctorRow objDoctorRow = new DoctorRow();

            ultraGridDoc.DataSource = objDoctor.GetAll();

            /* SqlCommand cmd = objHospitalDB.CreateCommand("SELECT * FROM Doctor");
             * SqlDataAdapter sda = new SqlDataAdapter(cmd);
             * dtDoctor = new DataTable();
             * sda.Fill(dtDoctor);
             * ultraGridDoc.DataSource = dtDoctor;*/
        }
        private void ultraBtnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("Are you sure you want to delete?", "delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    objHospitalDB = new HospitalDB();
                    Doctor    objDoctor    = new Doctor(objHospitalDB);
                    DoctorRow objDoctorRow = new DoctorRow();
                    objDoctorRow.Doctor_ID = Convert.ToInt32(this.id);
                    objDoctor.Delete(objDoctorRow);
                    ultraGridDoc.DataSource = objDoctor.GetAll();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            /*try
             * {
             *  objHospitalDB = new HospitalDB();
             * // con.Open();
             *  ultraGridDoc.Rows[this.ultraGridDoc.ActiveRow.Index].Delete(true);
             *  SqlCommand query = objHospitalDB.CreateCommand("delete from Doctor where Doctor_ID='" + this.id + "';", false);
             *  int p = query.ExecuteNonQuery();
             *
             *  MessageBox.Show(p + "Deleted");
             * }
             * catch (Exception ex)
             * {
             *  MessageBox.Show(ex.Message);
             * if(objHospitalDB!=null)
             *  {
             *      objHospitalDB.Dispose();
             *  }
             * }*/
        }
Пример #4
0
 public DoctorRowChangeEvent(DoctorRow row, global::System.Data.DataRowAction action)
 {
     this.eventRow    = row;
     this.eventAction = action;
 }