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;
}
}
