protected void Page_Load(object sender, EventArgs e)
{
bool valid = true;
string studentid = Request.QueryString["studentid"];
if (String.IsNullOrEmpty(studentid))
{
valid = false;
}
//We will attempt to get the record we need
if (valid)
{
var db = new SCHOOLDB();
Dictionary <String, String> student_record = db.FindStudent(Int32.Parse(studentid));
if (student_record.Count > 0)
{
student_fname.InnerHtml = student_record["STUDENTFNAME"];
student_lname.InnerHtml = student_record["STUDENTLNAME"];
student_number.InnerHtml = student_record["STUDENTNUMBER"];
enrolment_date.InnerHtml = student_record["ENROLMENTDATE"];
}
else
{
valid = false;
}
}
if (!valid)
{
student.InnerHtml = "There was an error finding that student.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
bool valid = true;
string studentid = Request.QueryString["studentid"];
System.Diagnostics.Debug.WriteLine("StudentID:" + studentid);
if (String.IsNullOrEmpty(studentid))
{
valid = false;
}
if (valid)
{
var db = new SCHOOLDB();
Dictionary <String, String> student_record = db.FindStudent(Int32.Parse(studentid));
if (student_record.Count > 0)
{
student_firstname.Text = student_record["STUDENTFNAME"];
student_lastname.Text = student_record["STUDENTLNAME"];
student_number.Text = student_record["STUDENTNUMBER"];
student_enrolment_date.Text = student_record["ENROLMENTDATE"];
}
else
{
valid = false;
}
}
}
protected void ShowStudentInfo(SCHOOLDB db)
{
bool valid = true;
string studentid = Request.QueryString["studentid"];
if (String.IsNullOrEmpty(studentid)) valid = false;
//We will attempt to get the record we need
if (valid)
{
Student student_record = db.FindStudent(Int32.Parse(studentid));
student_title.InnerHtml = student_record.GetFname() + " " + student_record.GetLname();
student_fname.Text = student_record.GetFname();
student_lname.Text = student_record.GetLname();
student_number.Text = student_record.GetNumber();
}
if (!valid)
{
student.InnerHtml = "There was an error finding that student.";
}
}
protected void Update_Student(object sender, EventArgs e)
{
//this connection instance is for editing data
SCHOOLDB db = new SCHOOLDB();
bool valid = true;
string studentid = Request.QueryString["studentid"];
if (String.IsNullOrEmpty(studentid)) valid = false;
if (valid)
{
Student new_student = new Student();
//set that student data
new_student.SetFname(student_fname.Text);
new_student.SetLname(student_lname.Text);
new_student.SetNumber(student_number.Text);
//add the student to the database
try
{
db.UpdateStudent(Int32.Parse(studentid), new_student);
Response.Redirect("ShowStudent.aspx?studentid=" + studentid);
}
catch
{
valid = false;
}
}
if (!valid)
{
student.InnerHtml = "There was an error updating that student.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
System.Diagnostics.Debug.WriteLine("Entered ResultSet");
string tid = Request.QueryString["studentid"];
string query = "select * from STUDENTS";
var db = new SCHOOLDB();
List <Dictionary <String, String> > ResultSet = db.List_Query(query);
foreach (Dictionary <String, String> row in ResultSet)
{
System.Diagnostics.Debug.WriteLine("Entered ResultSet");
//students_result.InnerHtml += "<div class=\"listitem\">";
//string studentid = row["STUDENTID"];
//string studentfirstname = row["STUDENTFNAME"];
//students_result.InnerHtml += "<div class=\"col4\"><a href=\"ViewStudent.aspx?studentid=" + studentid + "\">" + studentfirstname + "</a></div>";
//string studentlastname = row["STUDENTLNAME"];
//students_result.InnerHtml += "<div class=\"col4\">" + studentlastname + "</div>";
//string studentnumber = row["STUDENTNUMBER"];
//students_result.InnerHtml += "<div class=\"col4\">" + studentnumber + "</div>";
//string enrolmentdate = row["ENROLMENTDATE"];
//students_result.InnerHtml += "<div class=\"col4last\">" + enrolmentdate + "</div>";
//students_result.InnerHtml += "<button onclick=\"myFunction()\" class=\"btn btn-dar\">View</button>";
//students_result.InnerHtml += "<button onclick=\"myFunction()\" class=\"btn btn-dar\">Edit</button>";
//students_result.InnerHtml += "<button onclick=\"myFunction()\" class=\"btn btn-dar\">Delete</button>";
//students_result.InnerHtml += "</div>";
HtmlTableRow tRow = new HtmlTableRow();
HtmlTableCell tb1 = new HtmlTableCell();
tb1.InnerText = row["STUDENTFNAME"];
tRow.Controls.Add(tb1);
HtmlTableCell tb2 = new HtmlTableCell();
tb2.InnerText = row["STUDENTLNAME"];
tRow.Controls.Add(tb2);
HtmlTableCell tb3 = new HtmlTableCell();
tb3.InnerText = row["STUDENTNUMBER"];
tRow.Controls.Add(tb3);
HtmlTableCell tb4 = new HtmlTableCell();
string str = row["ENROLMENTDATE"];
str = str.Substring(0, 10);
System.Diagnostics.Debug.WriteLine("String" + str);
tb4.InnerText = str;
tRow.Controls.Add(tb4);
HtmlTableCell tb5 = new HtmlTableCell();
tb5.InnerHtml = "<input type=\"button\" value=\"view\" onclick=\"location.href='ViewStudent.aspx?studentid=" + row["STUDENTID"] + "'\" class=\"btn btn-dar\"/>";
tb5.InnerHtml += "<input type=\"button\" value=\"Edit\" onclick=\"location.href='CreateStudent.aspx?studentid=" + row["STUDENTID"] + "'\" class=\"btn btn-dar\"/>";
tb5.InnerHtml += "<input type=\"button\" value=\"Delete\" OnClick=\"return confirm('Are you sure want to delete the teacher?')\" class=\"btn btn-dar\"/>";
tRow.Controls.Add(tb5);
table1.Rows.Add(tRow);
}
}
