protected void Page_Load(object sender, EventArgs e) { student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); student_query_data = new StudentDataSet.studentsDataTable(); int did; if (Session["usertype"] != null) { if ((Session["usertype"].ToString() == "admin") || (Session["usertype"].ToString() == "Admin")) { if (Request["did"] != null) { did = Convert.ToInt32(Request["did"]); student_table.DeleteStudent(did); ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Student Deleated successfully!');location.href = 'Admin.aspx';", true); } else { Response.Redirect("~/Admin.aspx"); } } else { Response.Redirect("~/Admin.aspx"); } } else { Response.Redirect("~/Admin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["usertype"] != null) { student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); student_query_data = new StudentDataSet.studentsDataTable(); int id; if ((Session["usertype"].ToString() == "admin") || (Session["usertype"].ToString() == "Admin")) { if (Request["id"] != null) { id = Convert.ToInt32(Request["id"]); student_query_data = student_table.GetStudent(id); } else { Response.Redirect("~/Admin.aspx"); } } else if ((Session["usertype"].ToString() == "student") || (Session["usertype"].ToString() == "Student")) { id = Convert.ToInt32(Session["id"]); student_query_data = student_table.GetStudent(id); } } else { Response.Redirect("~/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { string text = Request["text"]; student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); student_query_data = new StudentDataSet.studentsDataTable(); student_query_data = student_table.GetSearchResult(text); string bind = "<thead><tr><th> ID </th><th> Username </th><th> Full Name </th><th> Gender </th><th> Email </th><th> Department </th><th> Semester </th></tr></thead>"; if (student_query_data.Count > 0) { for (int i = 0; i < student_query_data.Count; i++) { bind += "<tr><td>" + student_query_data[i].sid + "</td><td> " + student_query_data[i].username + " </td><td> " + student_query_data[i].fname + " " + student_query_data[i].lname + " </td><td> " + student_query_data[i].gender + "</td><td> " + student_query_data[i].email + " </td><td> " + student_query_data[i].department + " </td><td> " + student_query_data[i].semester + " </td></tr> "; } } //Response.Write(student_query_data); Response.Write(bind); //JavaScriptSerializer js = new JavaScriptSerializer(); //js.Serialize(student_query_data); //Response.Write(js.Serialize(student_query_data)); Response.End(); }
public string getAllStudents() { StudentDataSetTableAdapters.studentsTableAdapter student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); StudentDataSet.studentsDataTable student_query_data = new StudentDataSet.studentsDataTable(); student_query_data = student_table.GetData(); string bind = ""; for (int i = 0; i < student_query_data.Count; i++) { bind += "<tr><td> " + (i + 1) + "</td><td>" + student_query_data[i].sid + "</td><td> " + student_query_data[i].username + " </td><td> " + student_query_data[i].fname + " </td><td> " + student_query_data[i].lname + " </td><td> " + student_query_data[i].gender + "</td><td> " + student_query_data[i].email + " </td><td> " + student_query_data[i].number + " </td><td> " + student_query_data[i].password + " </td><td> " + student_query_data[i].usertype + " </td><td> " + student_query_data[i].department + " </td><td> " + student_query_data[i].cgpa + " </td><td> " + student_query_data[i].semester + " </td></tr> "; } return(bind); }
protected void Page_Load(object sender, EventArgs e) { if ((Request["username"] == null) || (Request["sid"] == null) || (Request["firstname"] == null) || (Request["lastname"] == null) || (Request["gender"] == null) || (Request["cgpa"] == null) || (Request["department"] == null) || (Request["semester"] == null) || (Request["email"] == null) || (Request["pnumber"] == null) || (Request["password"] == null) || (Request["cpassword"] == null)) { Response.Redirect("~/Admin.aspx"); } else if ((Request["username"] == "") || (Request["sid"] == "") || (Request["firstname"] == "") || (Request["lastname"] == "") || (Request["gender"] == "") || (Request["cgpa"] == "") || (Request["department"] == "") || (Request["semester"] == "") || (Request["email"] == "") || (Request["pnumber"] == "") || (Request["password"] == "") || (Request["cpassword"] == "")) { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Please fill up all the boxes!');location.href = 'Admin.aspx';", true); } else { if (String.Equals(Request["password"], Request["Cpassword"])) { int id = Convert.ToInt32(Request["id"]); string username = Request["username"]; string sid = Request["sid"]; string firstname = Request["firstname"]; string lastname = Request["lastname"]; string gender = Request["gender"]; float cgpa = float.Parse(Request["cgpa"]); string department = Request["department"]; string semester = Request["semester"]; string email = Request["email"]; string number = Request["pnumber"]; string password = Request["password"]; string cpassword = Request["cpassword"]; string usertype = "student"; StudentDataSetTableAdapters.studentsTableAdapter student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); StudentDataSet.studentsDataTable student_query_data = new StudentDataSet.studentsDataTable(); student_table.UpdateStudent(sid, username, firstname, lastname, gender, email, number, password, usertype, department, cgpa, semester, id); ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Student Info Updated successfully!');location.href = 'Admin.aspx';", true); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Error!! password did not match!');location.href = 'Admin.aspx';", true); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["usertype"] != null) { if ((Session["usertype"].ToString() == "admin") || (Session["usertype"].ToString() == "Admin")) { string username = Session["username"].ToString(); string password = Session["password"].ToString(); student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); student_query_data = new StudentDataSet.studentsDataTable(); admin_query_data = admin_table.Login(username, password); student_query_data = student_table.GetData(); } else if ((Session["usertype"].ToString() == "student") || (Session["usertype"].ToString() == "Student")) { Response.Redirect("~/Student.aspx"); } } else { Response.Redirect("~/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if ((Request["username"] == null) || (Request["password"] == null)) { Response.Redirect("~/Login.aspx"); } else if ((Request["username"] == "") || (Request["password"] == "")) { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Access Denied. Please Enter your username!');location.href = 'Login.aspx';", true); } else { string username = Request["username"]; string password = Request["password"]; StudentDataSetTableAdapters.studentsTableAdapter student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); StudentDataSet.studentsDataTable student_query_data = new StudentDataSet.studentsDataTable(); student_query_data = student_table.Login(username, password); StudentDataSetTableAdapters.adminsTableAdapter admin_table = new StudentDataSetTableAdapters.adminsTableAdapter(); StudentDataSet.adminsDataTable admin_query_data = new StudentDataSet.adminsDataTable(); student_query_data = student_table.Login(username, password); admin_query_data = admin_table.Login(username, password); if (student_query_data.Count >= 1) { Session["id"] = student_query_data[0]["id"]; Session["username"] = student_query_data[0]["username"]; Session["sid"] = student_query_data[0]["sid"]; Session["fname"] = student_query_data[0]["fname"]; Session["lname"] = student_query_data[0]["lname"]; Session["email"] = student_query_data[0]["email"]; Session["number"] = student_query_data[0]["number"]; Session["gender"] = student_query_data[0]["gender"]; Session["password"] = student_query_data[0]["password"]; Session["cgpa"] = student_query_data[0]["cgpa"]; Session["department"] = student_query_data[0]["department"]; Session["semester"] = student_query_data[0]["semester"]; Session["usertype"] = student_query_data[0]["usertype"]; Response.Redirect("~/Student.aspx"); } else if (admin_query_data.Count >= 1) { Session["id"] = admin_query_data[0]["id"]; Session["username"] = admin_query_data[0]["username"]; Session["email"] = admin_query_data[0]["email"]; Session["password"] = admin_query_data[0]["password"]; Session["number"] = admin_query_data[0]["number"]; Session["usertype"] = admin_query_data[0]["usertype"]; Response.Redirect("~/Admin.aspx"); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Error! Wrong Username or Password!');location.href = 'Login.aspx';", true); } } }