private void BtnReject_Click(object sender, EventArgs e)
{
string sql = this.GridReqAppo.CurrentRow.Cells["patientname"].Value.ToString();
MessageBox.Show("Do you Want to Delete " + sql + "?");
string id = this.GridReqAppo.CurrentRow.Cells["id"].Value.ToString();
string sqll = "delete from tempReqAppoDoc where id='" + id + "';";
DataAccess.ExecuteQuery(sqll);
string sql1 = "select * from tempReqAppoDoc where doctorid='" + dr.Userid + "'";
this.PopulateGridView(sql1);
this.GridReqAppo.DataSource = this.Ds.Tables[0];
pa.Userid = this.GridReqAppo.CurrentRow.Cells["patientid"].Value.ToString();
dr.Userid = this.GridReqAppo.CurrentRow.Cells["doctorid"].Value.ToString();
pa.Nmessage = "Your Requested Appointment is rejected from Doctor Id: " + dr.Username + "";
prepo.AddPatientNotification(pa, dr);
}
private void BtnPrescription_Click(object sender, EventArgs e)
{
ps.Symptom = this.txtSymptom.Text;
ps.Diseases = this.comDisease.Text;
ps.Test = this.comTest.Text;
ps.Testclinicname = this.comClinic.Text;
string sql = "select * from clinic where username='******'";
Ds = DataAccess.GetDataSet(sql);
Clinic c = new Clinic(Ds);
string s = c.Userid;
ps.Testclinicid = s;
ps.Report = this.txtReport.Text;
ps.Medicines = this.txtMedicines.Text;
prepo.AddPatientHistoryInfromation(pa, dr, cl, ps);
MessageBox.Show("Successfully Prescived!");
this.Visible = false;
sql = "delete from patientWatingList where patientid='" + pa.Userid + "';";
DataAccess.ExecuteQuery(sql);
//////
string sqll = "select * from patientWatingList where doctorid='" + dr.Userid + "'";
////
if (ps.Test.Equals("none"))
{
pa.Nmessage = "New prescription from Doctor: " + dr.Username + ".Please check Your History.";
prepo.AddPatientNotification(pa, dr);
}
else
{
pa.Nmessage = "New prescription from Doctor: " + dr.Username + ".and also a panding test " + ps.Test + "Please check Your History.";
prepo.AddPatientNotification(pa, dr);
}
}