protected void Bind_GridViewPatient()
{
string term = TextboxSearch.Text.Trim().ToLower();
List <Classes.Entity.Patient> patients = therapistBLL.GetUnrequestedPatients(term);
ViewState["GridViewPatient"] = patients;
GridViewPatient.DataSource = patients;
GridViewPatient.DataBind();
UpdatePanelAccounts.Update();
}
public void display()
{
DataTable dt = new DataTable();
String con;
con = "User Id = sandeep; Password=admin; Data source = XE";
cn.ConnectionString = con;
cn.Open();
//to display data from department table
OracleCommand cmd = new OracleCommand("Select * from Patients_Details", cn);
OracleDataAdapter adp = new OracleDataAdapter(cmd);
adp.Fill(dt);
cn.Close();
GridViewPatient.DataSource = dt;
GridViewPatient.DataBind();
}
protected void Bind_GridViewPatientAndRecord()
{
string nric = string.Empty;
if (ViewState["GridViewPatientSelectedPatientNRIC"] != null)
{
nric = Convert.ToString(ViewState["GridViewPatientSelectedPatientNRIC"]);
}
List <Record> records = new RecordBLL().GetRecords(nric);
ViewState["GridViewRecords"] = records;
GridViewRecords.DataSource = records;
GridViewRecords.DataBind();
string term = TextboxSearch.Text.Trim().ToLower();
List <Classes.Entity.Patient> patients = therapistBLL.GetCurrentPatients(term);
ViewState["GridViewPatient"] = patients;
GridViewPatient.DataSource = patients;
GridViewPatient.DataBind();
UpdatePanelNewMedicalNote.Update();
}
protected void GridViewPatient_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridViewPatient.PageIndex = e.NewPageIndex;
GridViewPatient.DataSource = ViewState["GridViewPatient"];
GridViewPatient.DataBind();
}