private void bind_test_samples()
{
//Getting req_tests table from the database
ds_analytics.req_testsDataTable dt_test = req_tests.getTestsbyReqid(reqid);
//Make test_sample DataTable to bind to Gridview
DataTable dt_test_sample = new DataTable();
dt_test_sample.Columns.Add(new DataColumn("Test", typeof(System.String)));
for (int i = 1; i <= req_samples.countSamplesByReqId(reqid); i++)
{
dt_test_sample.Columns.Add(new DataColumn(i.ToString(), typeof(System.Boolean)));
}
//building Datatable for gridview using test_samples in server
foreach (ds_analytics.req_testsRow dr in dt_test.Rows)
{
DataRow dr_new = dt_test_sample.NewRow();
dr_new["Test"] = dr.testname;
ds_analytics.test_samplesDataTable ts_dt = test_samples.getTest_SamplesByTestid(dr.test_id);
int i = 1;
foreach (ds_analytics.test_samplesRow ts_row in ts_dt.Rows)
{
dr_new[i.ToString()] = ts_row.isselected;
i++;
}
dt_test_sample.Rows.Add(dr_new);
}
//Databind
gv_test_sample.DataSource = dt_test_sample;
gv_test_sample.DataBind();
}
private void bind_test_samples()
{
//Getting req_tests table from the database
ds_analytics.req_testsDataTable dt_test = req_tests.getTestsbyReqid(reqid);
//Make test_sample DataTable to bind to Gridview
DataTable dt_test_sample = new DataTable();
dt_test_sample.Columns.Add(new DataColumn("Test", typeof(System.String)));
for (int i = 1; i <= req_samples.countSamplesByReqId(reqid); i++)
{
dt_test_sample.Columns.Add(new DataColumn(i.ToString(), typeof(System.String)));
}
//building Datatable for gridview using test_samples in server
foreach (ds_analytics.req_testsRow dr in dt_test.Rows)
{
DataRow dr_new = dt_test_sample.NewRow();
dr_new["Test"] = dr.testname;
ds_analytics.test_samplesDataTable ts_dt = test_samples.getTest_SamplesByTestid(dr.test_id);
int i = 1;
foreach (ds_analytics.test_samplesRow ts_row in ts_dt.Rows)
{
if (ts_row.isselected)
{
//dr_new[i.ToString()] = isPDFrequest ? "True" : "\u2713";
dr_new[i.ToString()] = "True";
}
i++;
}
dt_test_sample.Rows.Add(dr_new);
}
//Databind
gv_test_sample.DataSource = dt_test_sample;
gv_test_sample.DataBind();
// Align in center
foreach (TableCell cell in gv_test_sample.HeaderRow.Cells)
{
if (gv_test_sample.HeaderRow.Cells.GetCellIndex(cell) > 0)
{
cell.Style.Add("text-align", "center");
}
}
foreach (GridViewRow gvr in gv_test_sample.Rows)
{
foreach (TableCell cell in gvr.Cells)
{
if (gvr.Cells.GetCellIndex(cell) > 0)
{
cell.Style.Add("text-align", "center");
}
}
}
}
private void bind_page_tests()
{
ds_analytics.req_testsDataTable req_test_dt = req_tests.getTestsbyReqid(process_reqid);
gv_tests.DataSource = req_test_dt;
gv_tests.DataBind();
foreach (GridViewRow gvr in gv_tests.Rows)
{
DropDownList ddl_ref = ((DropDownList)gvr.FindControl("dd_specification"));
ddl_ref.SelectedValue = req_test_dt.Rows[gvr.RowIndex]["reference"].ToString();
}
}
private void build_dt_test_sample()
{
//Getting req_tests table from the database
ds_analytics.req_testsDataTable dt_test = req_tests.getTestsbyReqid(process_reqid);
//Make test_sample DataTable to bind to Gridview
dt_test_sample = new DataTable();
dt_test_sample.Columns.Add(new DataColumn("test_id", typeof(System.Int64)));
dt_test_sample.Columns.Add(new DataColumn("testname", typeof(System.String)));
dt_test_sample.Columns.Add(new DataColumn("all", typeof(System.Boolean)));
for (int i = 1; i <= no_samples; i++)
{
dt_test_sample.Columns.Add(new DataColumn(i.ToString(), typeof(System.Boolean)));
}
//building datatable for gridview
foreach (ds_analytics.req_testsRow dr in dt_test.Rows)
{
DataRow dr_new = dt_test_sample.NewRow();
dr_new["test_id"] = dr.test_id;
dr_new["testname"] = dr.testname;
bool all_selected = true;
ds_analytics.test_samplesDataTable ts_dt = test_samples.getTest_SamplesByTestid(dr.test_id);
int i = 1;
foreach (ds_analytics.test_samplesRow ts_row in ts_dt.Rows)
{
dr_new[i.ToString()] = ts_row.isselected;
i++;
if (!ts_row.isselected)
{
all_selected = false;
}
}
dr_new["all"] = all_selected;
dt_test_sample.Rows.Add(dr_new);
}
Session["dt_test_sample"] = (DataTable)dt_test_sample;
}
private DataTable get_dt_ts_lab_selection()
{
int no_samples = req_samples.countSamplesByReqId(reqid);
//Getting req_tests table from the database
ds_analytics.req_testsDataTable dt_test = req_tests.getTestsbyReqid(reqid);
//Make test_sample DataTable Columns to bind to Gridview
DataTable dt_test_sample = new DataTable();
dt_test_sample.Columns.Add(new DataColumn("test_id", typeof(System.Int64)));
dt_test_sample.Columns.Add(new DataColumn("testname", typeof(System.String)));
for (int i = 1; i <= no_samples; i++)
{
dt_test_sample.Columns.Add(new DataColumn(i.ToString(), typeof(System.Boolean)));
}
//building Datatable for gridview using test_samples in server
foreach (ds_analytics.req_testsRow dr in dt_test.Rows)
{
DataRow dr_new = dt_test_sample.NewRow();
dr_new["test_id"] = dr.test_id;
dr_new["testname"] = dr.testname;
ds_analytics.test_samplesDataTable ts_dt = test_samples.getTest_SamplesByTestid(dr.test_id);
int i = 1;
foreach (ds_analytics.test_samplesRow ts_row in ts_dt.Rows)
{
dr_new[i.ToString()] = ts_row.isselected;
i++;
}
dt_test_sample.Rows.Add(dr_new);
}
return(dt_test_sample);
}
private void bind_req_tests()
{
ds_analytics.req_testsDataTable req_test_dt = req_tests.getTestsbyReqid(reqid);
gv_tests.DataSource = req_test_dt;
gv_tests.DataBind();
}