public void patientInfo(Patient patient)
{
try{
string pid = patient.getPatientID();
string pfname = patient.getFirstName();
string psurname = patient.getSurname();
string paddress = patient.getAddress();
string pnic = patient.getNIC();
int pcontactno = patient.getContactNo();
int pregistrationfee = patient.getRegistrationFee();
conn.Open();
SqlCommand cmd = new SqlCommand("insert into patient_registration values('" + pid + "','" + pfname + "','" + psurname + "','" + paddress + "','" + pnic + "','" + pcontactno + "','" + pregistrationfee + "')", conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
var sqlException = ex.InnerException as System.Data.SqlClient.SqlException;
if (sqlException.Number == 2601 || sqlException.Number == 2627)
{
}
conn.Close();
}
}
public void deletePatientInfo(Patient patient)
{
string pid = patient.getPatientID();
string pfname = patient.getFirstName();
string psurname = patient.getSurname();
string paddress = patient.getAddress();
string pnic = patient.getNIC();
int pcontactno = patient.getContactNo();
int pregistrationfee = patient.getRegistrationFee();
conn.Open();
SqlCommand cmd = new SqlCommand("delete from patient_registration where patientid='" + pid + "'", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
public void updatePatientInfo(Patient patient)
{
string pid = patient.getPatientID();
string pfname = patient.getFirstName();
string psurname = patient.getSurname();
string paddress = patient.getAddress();
string pnic = patient.getNIC();
int pcontactno = patient.getContactNo();
int pregistrationfee = patient.getRegistrationFee();
conn.Open();
SqlCommand cmd = new SqlCommand("update patient_registration set patientid='" + pid + "',fname='" + pfname + "',surname='" + psurname + "',address='" + paddress + "',nic='" + pnic + "',contactno='" + pcontactno + "',registrationfee='" + pregistrationfee + "' where patientid='" + pid + "'", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
private void btnPatientRegistrationSearchPatient_Click(object sender, EventArgs e)
{
try
{
string patientid = txtPatientRegistrationPatientID.Text;
PatientDBO pdbo = new PatientDBO();
Patient patient = pdbo.findPatient(patientid);
txtPatientRegistrationPatientID.Text = patient.getPatientID();
txtPatientRegistrationFirstName.Text = patient.getFirstName();
txtPatientRegistrationSurname.Text = patient.getSurname();
txtPatientRegistrationAddress.Text = patient.getAddress();
txtPatientRegistrationNIC.Text = patient.getNIC();
txtPatientRegistrationContactNo.Text = patient.getContactNo().ToString();
txtPatientRegistrationRegistrationFee.Text = patient.getRegistrationFee().ToString();
}
catch (Exception ex)
{
MessageBox.Show("Couldn't find any records or details of such a Patient.", "Incorrect Entry", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
