protected void BindDropDown()
{
Processing P = new Processing();
DrpCalendar.DataSource = P.BindCalenderDropdown("CalName", Convert.ToInt32(Session["UserId"]), "", 0, "");
DrpCalendar.DataTextField = "Cal_Name";
DrpCalendar.DataValueField = "Cal_Name";
DrpCalendar.DataBind();
}
protected void PopulateEvents()
{
String Date = "";
if (txtStrtDate.Text.ToString() != "")
{
string[] date = new string[3];
date = txtStrtDate.Text.Trim().Split('/');
Date = date[2] + date[1] + date[0];
}
else
{
Date = "19900101";
}
Processing P = new Processing();
drpEvent.DataSource = P.BindCalenderDropdown("Mom Events", Convert.ToInt32(Session["UserId"]), DrpCalendar.SelectedValue, Convert.ToInt32(DrpAcademicYear.SelectedValue), Date);
drpEvent.DataTextField = "EventTitle";
drpEvent.DataValueField = "EventTitle";
drpEvent.DataBind();
drpEvent.Items.Insert(0, new ListItem("Select", ""));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
DBH.CreateDataTable_TPS(dt, "EXEC SP_LOADTPSDETAILS");
drpYear.DataSource = dt.DefaultView.ToTable(true, "Year");
drpYear.DataTextField = "Year";
drpYear.DataValueField = "Year";
drpYear.DataBind();
drpYear.Items.Insert(0, new ListItem("Select", ""));
drpSem.DataSource = dt.DefaultView.ToTable(true, "Semester");
drpSem.DataTextField = "Semester";
drpSem.DataValueField = "Semester";
drpSem.DataBind();
drpSem.Items.Insert(0, new ListItem("Select", ""));
//ddl_types.DataSource = dt.DefaultView.ToTable(true, "Department");
//ddl_types.DataTextField = "Department";
//ddl_types.DataValueField = "Department";
//ddl_types.DataBind();
//ddl_types.Items.Insert(0, new ListItem("Select", ""));
Processing P = new Processing();
ddl_types.DataSource = P.BindCalenderDropdown("CalName", Convert.ToInt32(Session["UserId"]), "", 0, "");
ddl_types.DataTextField = "Cal_Name";
ddl_types.DataValueField = "Cal_Name";
ddl_types.DataBind();
ddl_category.DataSource = dt.DefaultView.ToTable(true, "ItemType");
ddl_category.DataTextField = "ItemType";
ddl_category.DataValueField = "ItemType";
ddl_category.DataBind();
ddl_category.Items.Insert(0, new ListItem("Select", ""));
}
}
