protected void Button_GenomicAnalysis_Click(object sender, EventArgs e)
{
Label_RecordNotFound.Text = " ";
GridView_Record.Visible = false;
try
{
var result = datacon.UDSP_GenomicAnalysis((TextBox__GenomicAnalysis.Text));
GridView_Record.DataSource = result;
GridView_Record.DataBind();
GridView_Record.Visible = true;
TextBox__GenomicAnalysis.Text = "";
Label_RecordNotFound.Text = " ";
int rowCount = GridView_Record.Rows.Count;
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
catch (Exception ex)
{
Label_RecordNotFound.Text = " Record was not found.";
}
}
protected void Button_ViewRecordPatientCost_Click(object sender, EventArgs e)
{
GridView_Record.Visible = false;
Label_RecordNotFound.Text = " ";
try
{
var result = datacon.UDSP_PatientCost(Int32.Parse(TextBox_PatientCost.Text));
GridView_Record.DataSource = result;
GridView_Record.DataBind();
GridView_Record.Visible = true;
TextBox_PatientCost.Text = "";
Label_RecordNotFound.Text = " ";
int rowCount = GridView_Record.Rows.Count;
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
catch (Exception ex)
{
Label_RecordNotFound.Text = " Record was not found.";
}
}
protected void Button_ViewRecordInside_Click(object sender, EventArgs e)
{
string tableName = DropDownList_ViewRecord.SelectedItem.Text.ToString();
int rowCount = 0;
if (tableName.Equals("Patient"))
{
var result = datacon.UDSP_ViewRecord_Patient(tableName, Int32.Parse(TextBox_ViewRecordInside.Text));
GridView_Record.DataSource = result;
GridView_Record.DataBind();
rowCount = GridView_Record.Rows.Count;
GridView_Record.Visible = true;
TextBox_ViewRecordInside.Text = "";
DropDownList_ViewRecord.SelectedIndex = 0;
Label_RecordNotFound.Text = "";
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
else if (tableName.Equals("Disease"))
{
var result = datacon.UDSP_ViewRecord_Disease(tableName, Int32.Parse(TextBox_ViewRecordInside.Text));
GridView_Record.DataSource = result;
GridView_Record.DataBind();
rowCount = GridView_Record.Rows.Count;
GridView_Record.Visible = true;
TextBox_ViewRecordInside.Text = "";
DropDownList_ViewRecord.SelectedIndex = 0;
Label_RecordNotFound.Text = "";
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
else if (tableName.Equals("Gene"))
{
var result = datacon.UDSP_ViewRecord_Gene(tableName, TextBox_ViewRecordInside.Text);
GridView_Record.DataSource = result;
GridView_Record.DataBind();
rowCount = GridView_Record.Rows.Count;
GridView_Record.Visible = true;
TextBox_ViewRecordInside.Text = "";
DropDownList_ViewRecord.SelectedIndex = 0;
Label_RecordNotFound.Text = "";
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
else if (tableName.Equals("Pathway"))
{
var result = datacon.UDSP_ViewRecord_Pathway(tableName, TextBox_ViewRecordInside.Text);
GridView_Record.DataSource = result;
GridView_Record.DataBind();
rowCount = GridView_Record.Rows.Count;
GridView_Record.Visible = true;
TextBox_ViewRecordInside.Text = "";
DropDownList_ViewRecord.SelectedIndex = 0;
Label_RecordNotFound.Text = "";
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
else if (tableName.Equals("DNA"))
{
var result = datacon.UDSP_ViewRecord_DNA(tableName, TextBox_ViewRecordInside.Text);
GridView_Record.DataSource = result;
GridView_Record.DataBind();
rowCount = GridView_Record.Rows.Count;
GridView_Record.Visible = true;
TextBox_ViewRecordInside.Text = "";
DropDownList_ViewRecord.SelectedIndex = 0;
Label_RecordNotFound.Text = "";
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
else if (tableName.Equals("RNA"))
{
var result = datacon.UDSP_ViewRecord_RNA(tableName, TextBox_ViewRecordInside.Text);
GridView_Record.DataSource = result; rowCount = GridView_Record.Rows.Count;
GridView_Record.DataBind();
rowCount = GridView_Record.Rows.Count;
GridView_Record.Visible = true;
TextBox_ViewRecordInside.Text = "";
DropDownList_ViewRecord.SelectedIndex = 0;
Label_RecordNotFound.Text = "";
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
else if (tableName.Equals("Protein"))
{
var result = datacon.UDSP_ViewRecord_Protein(tableName, TextBox_ViewRecordInside.Text);
GridView_Record.DataSource = result;
GridView_Record.DataBind();
rowCount = GridView_Record.Rows.Count;
GridView_Record.Visible = true;
TextBox_ViewRecordInside.Text = "";
DropDownList_ViewRecord.SelectedIndex = 0;
Label_RecordNotFound.Text = "";
if (rowCount == 0)
{
Label_RecordNotFound.Text = " Record Not Found. ";
}
}
}