protected void Btn_addNewEventAdd_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO[EVENT_CALENDAR]([SUBJECT], [DESCRIPTION], [START], [END], [CATEGORY], [STATUS], [CREATOR_ID], [CREATE_TIMESTAMP]) VALUES(N'" + Tb_addNewSubjectName.Text + "', N'" + Tb_eventDiscription.Text + "', '" + Tb_eventStart.Text + "', '" + Tb_eventEnd.Text + "', N'" + Ddl_category.Text + "', '" + Ddl_eventStatus.Text + "', '" + Tb_eventCreator_ID.Text + "', '" + DateTime.Now + "')";
cmd.ExecuteNonQuery();
con.Close();
Gv_calendar.DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "addNewEventModalCenter", "$('#addNewEventModalCenter').modal('hide');", true);
}
protected void Btn_carlendarSearch_Click(object sender, EventArgs e)
{
Thread.Sleep(1000);
string SUBJECT = Tb_calendarFilter.Text;
string Filter = "";
//Colum of data table
if (SUBJECT != "")
{
Filter = Filter + "SUBJECT like '%" + SUBJECT + "%' and ";
}
//Add filter expression of datasource
if (Filter.Length > 0)
{
string FinalFilter = Filter.Remove(Filter.Length - 4, 3);
SqlDataSourceEVENT_CALENDAR.FilterExpression = FinalFilter;
}
else
{
Gv_calendar.DataBind();
}
}
