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); }