private void ultraButtonRegister_Click(object sender, EventArgs e) { try { if (this.strFormMode == "Edit") { ultraButtonRegister.Text = "Update"; objHospDB = new HospitalDB(); // SqlCommand cmd =objHospDB.CreateCommand("update PatientInfo set Name='" + ultraTextEditorName.Text + "',Address='" + ultraTextEditorAddress.Text + "',DateOfBirth='" + ultraDateTimeEditorPatientRgister.DateTime + "',Phone='" + classPhone.Text + "',EmergencyContact='" + classEmergencyContact.Text + "',DateOfRegistration='" + ultraDateTimeEditorDORPR.DateTime + "' where ID= '" + classtextEditorID.Text + "'"); // int obj = cmd.ExecuteNonQuery(); PatientInfo objPatietntInfo = new PatientInfo(objHospDB); PatientInfoRow objPatientInforow = new PatientInfoRow(); objPatientInforow.Id = Convert.ToInt32(classtextEditorID.Text); objPatientInforow.Name = ultraTextEditorName.Text; objPatientInforow.Address = ultraTextEditorAddress.Text; objPatientInforow.DateOfBirth = ultraDateTimeEditorPatientRgister.DateTime; objPatientInforow.Phone = Convert.ToInt32(classPhone.Text); objPatientInforow.EmergencyContact = Convert.ToInt32(classEmergencyContact.Text); objPatientInforow.DateOfRegistration = ultraDateTimeEditorDORPR.DateTime; objPatietntInfo.Update(objPatientInforow); MessageBox.Show(":updated"); //openfrmPatientList(); openPatientList(); } else { //conn.Open(); objHospDB = new HospitalDB(); PatientInfo objPatietntInfo = new PatientInfo(objHospDB); PatientInfoRow objPatientInforow = new PatientInfoRow(); objPatientInforow.Name = ultraTextEditorName.Text; objPatientInforow.Address = ultraTextEditorAddress.Text; objPatientInforow.DateOfBirth = ultraDateTimeEditorPatientRgister.DateTime; objPatientInforow.Phone = Convert.ToInt32(classPhone.Text); objPatientInforow.EmergencyContact = Convert.ToInt32(classEmergencyContact.Text); objPatientInforow.DateOfRegistration = ultraDateTimeEditorDORPR.DateTime; //SqlCommand cmd = objHospDB.CreateCommand("Insert into PatientInfo values('" + ultraTextEditorName.Text + "','" + ultraTextEditorAddress.Text + "','" + ultraDateTimeEditorPatientRgister.DateTime + "','" + classPhone.Text + "','" + classEmergencyContact.Text + "','" + ultraDateTimeEditorDORPR.DateTime + "')"); objPatietntInfo.Insert(objPatientInforow); MessageBox.Show(":Registered"); //openfrmPatientList(); openPatientList(); } } catch (Exception ex) { MessageBox.Show("error"); } }
private void ultraButtonDelete_Click(object sender, EventArgs e) { ultraGridPatientList.Rows[this.ultraGridPatientList.ActiveRow.Index].Delete(true); try { objHospDB = new HospitalDB(); PatientInfo objPatientInfo = new PatientInfo(objHospDB); PatientInfoRow objPatientInfoRow = new PatientInfoRow(); objPatientInfoRow.Id = Convert.ToInt32(id); objPatientInfo.Delete(objPatientInfoRow); MessageBox.Show(":deleted"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public PatientInfoRowChangeEvent(PatientInfoRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; }