protected void Btn_officerControlAdd_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO [OFFICER_CONTROL] ([OFFICER_FIRSTNAME], [AUTH_LASTNAME], [OFFICER_ID], [DEPARTMENT], [STUDY_TERM], [STUDY_YEAR], [PERMISSION], [ADMIN_ID], [TIMESTAMP]) VALUES (N'" + Tb_officerControlFirstname.Text + "', N'" + Tb_officerControlLastname.Text + "', '" + Tb_officerControlOfficerID.Text + "', N'" + Ddl_officerControlDept.Text + "', '" + Ddl_officerControlStudyYear.Text + "', '" + Ddl_officerControlStudyYears.Text + "', N'" + Ddl_officerControlPermission.Text + "', '" + Tb_officerControlAdminID.Text + "', '" + DateTime.Now + "')";
cmd.ExecuteNonQuery();
con.Close();
Gv_officerControl.DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "officerControlModalCenter", "$('#officerControlModalCenter').modal('hide');", true);
}
protected void Btn_officerControlFilter_Click(object sender, EventArgs e)
{
Thread.Sleep(1000);
string OFFICER_FIRSTNAME = Tb_officerControlFilter.Text;
string Filter = "";
//Colum of data table
if (OFFICER_FIRSTNAME != "")
{
Filter = Filter + "OFFICER_FIRSTNAME like '%" + OFFICER_FIRSTNAME + "%' and ";
}
//Add filter expression of datasource
if (Filter.Length > 0)
{
string FinalFilter = Filter.Remove(Filter.Length - 4, 3);
SqlDataSourceOFFICER_CONTROL.FilterExpression = FinalFilter;
}
else
{
Gv_officerControl.DataBind();
}
}
