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 Create_Btn_Click(object sender, EventArgs e)
{
args[0] = Create_Console.Text;
args[1] = "";
args[2] = DateTime.Now.ToString();
args[3] = "O";
if (find.Batch_Name(args[0]).Rows.Count == 0)
{
insertion.Batches(args);
Load_Databases();
}
}
private string Students(string batch_name)
{
string data = "";
string Batch_ID = find.Batch_Name(batch_name).Rows.Count != 0 ? find.Batch_Name(batch_name).Rows[0]["Batch_ID"].ToString() : "0";
DataTable dt = search.Students();
for (int i = 0; i < dt.Rows.Count; i++)
{
int Activate = 0;
if (dt.Rows[i]["Batch_ID"].ToString() == Batch_ID)
{
Activate = 1;
}
data = data + dt.Rows[i]["Name"].ToString() + "," + dt.Rows[i]["Father_Name"].ToString() + "," +
secure.Decrypt(dt.Rows[i]["Contact"].ToString(), "TSIE-GEHM-TAKUCF") + "," + secure.Decrypt(dt.Rows[i]["Email"].ToString(), "TSIE-GEHM-TAKUCF") + "," +
dt.Rows[i]["Date_Of_Join"].ToString() + "," +
dt.Rows[i]["Institute"].ToString().Substring(0, 10) + "," + dt.Rows[i]["Date_Of_Birth"].ToString().Substring(0, 10) + "," +
dt.Rows[i]["Status"].ToString() + "," + Activate.ToString() + ";";
}
return(data);
}