protected void Page_Load(object sender, EventArgs e) { AchieversDAL dal = new AchieversDAL(); try { if (!IsPostBack) { if (Request.QueryString["sid"] != null) { Users user = new Users(); user = (Users)(Session["user"]); sgnName.Text = user.FullName; studentId = int.Parse(Request.QueryString["sid"].ToString()); stu = business.getStudent(studentId); fvStudents.DataSource = stu; fvStudents.DataBind(); string deptName = stu[0].ProgramName; int Year = stu[0].StartYear; //string filePath = "http://dcm.uhcl.edu/capf17gswen2/DefaultPDF's/UHCL_EM_ACTIVE_COURSE_CATALOG_7133_"+Year+".xlsx"; //bool exists = false; //HttpWebRequest request = (HttpWebRequest)System.Net.WebRequest.Create(filePath); //HttpWebResponse response = (HttpWebResponse)request.GetResponse(); //exists = CheckIfFileExistsOnServer(filePath); if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + @"DefaultPDF's\UHCL_EM_ACTIVE_COURSE_CATALOG_7133_" + Year + ".xlsx")) { ConfigurationManager.AppSettings["Year"] = Year.ToString(); } else { ConfigurationManager.AppSettings["Year"] = DateTime.Now.Year.ToString(); } //ConfigurationManager.AppSettings["excelPath"] = Server.MapPath("http://dcm.uhcl.edu/capf17gswen2/DefaultPDF's/UHCL_EM_ACTIVE_COURSE_CATALOG_7133_"+ConfigurationManager.AppSettings["Year"]+".xlsx"); GridView1.DataSource = dal.GetAllCourses(deptName); GridView1.DataBind(); GridView2.DataSource = dal.GetAllMandatoryCoursesByDept(deptName); GridView2.DataBind(); GridView3.DataSource = dal.GetAllElectiveCoursesByDept(deptName); GridView3.DataBind(); } else { Response.Redirect("Error.aspx"); } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Message", "<script> alert('" + ex.Message + "')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["userRole"] == null) { Session["user"] = null; Response.Redirect("Login.aspx"); } else if (Session["userRole"].ToString() == "Academic") { Users user = new Users(); user = (Users)(Session["user"]); sgnName.Text = user.FullName; //if(Page.PreviousPage.FindControl("NewStudentPage.aspx")==true) //{ //} } AchieversDAL dal = new AchieversDAL(); }
protected void ddlMemberSelection_SelectedIndexChanged(object sender, EventArgs e) { if(ddlMemberSelection.Text=="Student") { pnlAddFac.Visible = false; pnlAddStudent.Visible = true; AchieversDAL dal = new AchieversDAL(); ddlDept.DataSource = dal.GetAllDept(); ddlDept.DataBind(); faculties = bizl.GetAllFaculties(); ddlAdvisor.DataSource = faculties; ddlAdvisor.DataValueField = "key"; ddlAdvisor.DataTextField = "value"; ddlAdvisor.DataBind(); } else if (ddlMemberSelection.Text == "Faculty Advisor") { pnlAddFac.Visible = true; pnlAddStudent.Visible = false; } }