protected void Btn_requestStudentSend_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO [REQUEST_STUDENT] ([WORK_DEPARTMENT], [REQUEST_AMOUNT], [WORK_DESCRIPTION], [STUDY_TERMS], [STUDY_YEARS], [AUTH_CONTROL_ID], [AUTH_CONTROL_FIRSTNAME], [AUTH_CONTROL_LASTNAME], [STATUS], [TIMESTAMP]) VALUES (N'" + Ddl_requestStudentDepartment.Text + "', '" + Ddl_requestStudentAmount.Text + "', N'" + Tb_requestStudentWorkDescription.Text + "', '" + Ddl_requestStudentStudyYear.Text + "', '" + Ddl_requestStudentStudyYears.Text + "', '" + Tb_requestStudentAuthID.Text + "', '" + Tb_requestStudentAuthFirstname.Text + "', '" + Tb_requestStudentAuthLastname.Text + "', 'Open', '" + DateTime.Now + "')";
cmd.ExecuteNonQuery();
con.Close();
Gv_authRequestStd.DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "requestStudentModalCenter", "$('#requestStudentModalCenter').modal('hide');", true);
}
protected void Btn_authRequestStdFilter_Click(object sender, EventArgs e)
{
Thread.Sleep(1000);
string WORK_DESCRIPTION = Tb_authRequestStdFilter.Text;
string Filter = "";
//Colum of data table
if (WORK_DESCRIPTION != "")
{
Filter = Filter + "WORK_DESCRIPTION like '%" + WORK_DESCRIPTION + "%' and ";
}
//Add filter expression of datasource
if (Filter.Length > 0)
{
string FinalFilter = Filter.Remove(Filter.Length - 4, 3);
SqlDataSourceREQUEST_STUDENT.FilterExpression = FinalFilter;
}
else
{
Gv_authRequestStd.DataBind();
}
}