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)
{
//Response.Write("Student username : "******"username"]);
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"]))
{
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.AddStudent(sid, username, firstname, lastname, gender, email, number, password, usertype, department, cgpa, semester);
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Student Added 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);
}
}
}
