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 BindDropDown()
{
StudentRegistrationDAL P = new StudentRegistrationDAL();
DrpCalendar.DataSource = P.BindCalenderDropdown("CalName", Convert.ToInt32(Session["EMPID"]), "", 0, "");
DrpCalendar.DataTextField = "Cal_Name";
DrpCalendar.DataValueField = "Cal_Name";
DrpCalendar.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
StudentRegistrationDAL P = new StudentRegistrationDAL();
DrpCalendar.DataSource = P.BindCalenderDropdown("CalName", Convert.ToInt32(Session["EMPID"]), "", 0, "");
DrpCalendar.DataTextField = "Cal_Name";
DrpCalendar.DataValueField = "Cal_Name";
DrpCalendar.DataBind();
if (Convert.ToInt32(Session["UserId"]) == 1619)
{
DrpCalendar.Items.Insert(0, new ListItem("Select", ""));
}
PopulateCat();
PopulateEvents();
DataTable dt = new DataTable();
DBH.CreateDataTable_TPS(dt, "SELECT Cal_Name=ltrim(rtrim(Cal_Name)) ,Department=ltrim(rtrim(Department)) ,Category1=ltrim(rtrim(Category1)),Category2=ltrim(rtrim(Category2)) ,EventTitle=ltrim(rtrim(EventTitle)),ItemType=ltrim(rtrim(ItemType)),Year=ltrim(rtrim(Year)),Semester=ltrim(rtrim(Semester)) FROM [DB_SkylineCalendarEvents].[dbo].[Cal_Master] ");
//DrpCalendar.DataSource = dt.DefaultView.ToTable(true, "Cal_Name");
//DrpCalendar.DataTextField = "Cal_Name";
//DrpCalendar.DataValueField = "Cal_Name";
//DrpCalendar.DataBind();
//DrpCalendar.Items.Insert(0, new ListItem("Select", ""));
//DrpCat1.DataSource = dt.DefaultView.ToTable(true, "Category1");
//DrpCat1.DataTextField = "Category1";
//DrpCat1.DataValueField = "Category1";
//DrpCat1.DataBind();
//DrpCat1.Items.Insert(0, new ListItem("Select", ""));
drpCat2.DataSource = dt.DefaultView.ToTable(true, "Category2");
drpCat2.DataTextField = "Category2";
drpCat2.DataValueField = "Category2";
drpCat2.DataBind();
drpCat2.Items.Insert(0, new ListItem("Select", ""));
//drpEvent.DataSource = dt.DefaultView.ToTable(true, "EventTitle");
//drpEvent.DataTextField = "EventTitle";
//drpEvent.DataValueField = "EventTitle";
//drpEvent.DataBind();
//drpEvent.Items.Insert(0, new ListItem("Select", ""));
DrpType.DataSource = dt.DefaultView.ToTable(true, "ItemType");
DrpType.DataTextField = "ItemType";
DrpType.DataValueField = "ItemType";
DrpType.DataBind();
DrpType.Items.Insert(0, new ListItem("Select", ""));
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", ""));
if (Convert.ToString(Session["Role"]) == "Dean" || Convert.ToString(Session["Role"]) == "COEC" || Convert.ToString(Session["Role"]) == "Admin")
{
PnlConsolidate.Visible = true;
}
}
}
