protected void Search_Batch_Test_Btn_Click(object sender, EventArgs e)
{
string keyword = Search_Batch_Test_Console.Text;
DataTable temp_table = new DataTable();
temp_table.Columns.Add(new DataColumn("Batch_Test_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("Batch_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("Test_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("TimeStamp", typeof(string)));
for (int i = 0; i < find.Test_NAME(keyword).Rows.Count; i++)
{
for (int j = 0; j < find.Batch_Test_TestID(find.Test_NAME(keyword).Rows[i]["Test_ID"].ToString()).Rows.Count; j++)
{
temp_table.ImportRow(find.Batch_Test_TestID(find.Test_NAME(keyword).Rows[i]["Test_ID"].ToString()).Rows[j]);
}
}
for (int i = 0; i < find.Batch_Name(keyword).Rows.Count; i++)
{
for (int j = 0; j < find.Batch_Test_BATCHID(find.Batch_Name(keyword).Rows[i]["Batch_ID"].ToString()).Rows.Count; j++)
{
temp_table.ImportRow(find.Batch_Test_BATCHID(find.Batch_Name(keyword).Rows[i]["Batch_ID"].ToString()).Rows[j]);
}
}
All_Test.DataSource = temp_table;
All_Test.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string batch_id = find.Students(Student_ID()).Rows.Count != 0 ? find.Students(Student_ID()).Rows[0]["Batch_ID"].ToString() : "0";
All_Test.DataSource = find.Batch_Test_BATCHID(batch_id);
All_Test.DataBind();
}
void Load_Databases()
{
All_Batch.DataSource = search.Batches();
All_Batch.DataBind();
All_Test.DataSource = search.Test();
All_Test.DataBind();
}
void Load_Tests(string value, string keyword)
{
Batch_ID.Value = value;
DataTable temp_table = new DataTable();
temp_table.Columns.Add(new DataColumn("Test_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("Name", typeof(string)));
temp_table.Columns.Add(new DataColumn("Details", typeof(string)));
temp_table.Columns.Add(new DataColumn("TimeStamp", typeof(string)));
DataTable remain_table = new DataTable();
remain_table.Columns.Add(new DataColumn("Test_ID", typeof(string)));
remain_table.Columns.Add(new DataColumn("Name", typeof(string)));
remain_table.Columns.Add(new DataColumn("Details", typeof(string)));
remain_table.Columns.Add(new DataColumn("TimeStamp", typeof(string)));
if (keyword == "")
{
for (int i = 0; i < search.Test().Rows.Count; i++)
{
if (find.Batch_Test(Batch_ID.Value, search.Test().Rows[i]["Test_ID"].ToString()).Rows.Count != 0)
{
temp_table.ImportRow(search.Test().Rows[i]);
}
else
{
remain_table.ImportRow(search.Test().Rows[i]);
}
}
for (int i = 0; i < remain_table.Rows.Count; i++)
{
temp_table.ImportRow(remain_table.Rows[i]);
}
}
else
{
for (int i = 0; i < search.Test().Rows.Count; i++)
{
if (find.Batch_Test(Batch_ID.Value, search.Test().Rows[i]["Test_ID"].ToString()).Rows.Count != 0 && find.Test_NAME(keyword).Rows.Count != 0)
{
temp_table.ImportRow(search.Test().Rows[i]);
}
else
{
remain_table.ImportRow(search.Test().Rows[i]);
}
}
}
All_Test.DataSource = temp_table;
All_Test.DataBind();
}
protected void Find_Btn_Click(object sender, EventArgs e)
{
string batch_id = find.Students(Student_ID()).Rows[0]["Batch_ID"].ToString();
DataTable temp_table = new DataTable();
temp_table.Columns.Add(new DataColumn("Batch_Test_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("Batch_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("Test_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("TimeStamp", typeof(string)));
for (int i = 0; i < find.Test_NAME(Search_Console.Text).Rows.Count; i++)
{
string test_id_temp = find.Test_NAME(Search_Console.Text).Rows[i]["Test_ID"].ToString();
if (find.Batch_Test(batch_id, test_id_temp).Rows.Count != 0)
{
temp_table.ImportRow(find.Batch_Test(batch_id, test_id_temp).Rows[0]);
}
}
All_Test.DataSource = temp_table;
All_Test.DataBind();
}
protected void Student_Search_Button_Click(object sender, EventArgs e)
{
string keyword = Student_Search_Console.Text;
DataTable temp_table = new DataTable();
temp_table.Columns.Add(new DataColumn("Giving_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("Student_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("Batch_Test_ID", typeof(string)));
temp_table.Columns.Add(new DataColumn("TimeStamp", typeof(string)));
for (int i = 0; i < find.Student_Name(keyword).Rows.Count; i++)
{
for (int j = 0; j < find.Giving(find.Student_Name(keyword).Rows[i]["Student_Id"].ToString(), batch_test_id_fld.Value).Rows.Count; j++)
{
temp_table.ImportRow(find.Giving(find.Student_Name(keyword).Rows[i]["Student_Id"].ToString(), batch_test_id_fld.Value).Rows[j]);
}
}
All_Test.DataSource = temp_table;
All_Test.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
All_Test.DataSource = search.Batch_Test();
All_Test.DataBind();
}
