public static Student Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM students WHERE id = @studentId;", conn);
SqlParameter studentIdParameter = new SqlParameter();
studentIdParameter.ParameterName = "@studentId";
studentIdParameter.Value = id.ToString();
cmd.Parameters.Add(studentIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
int findStudentId = 0;
string findStudentName = null;
string findStudentDoe = null;
while(rdr.Read())
{
findStudentId = rdr.GetInt32(0);
findStudentName = rdr.GetString(1);
findStudentDoe = rdr.GetString(2);
}
Student findStudent = new Student(findStudentName,findStudentDoe,findStudentId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return findStudent;
}
public void Test5_FindId()
{
Student newStudent = new Student ("Rick","2016-1-1");
newStudent.Save();
Student findStudent = Student.Find(newStudent.GetId());
Assert.Equal(findStudent, newStudent);
}
public void Test2_GetDoe()
{
// arrange
Student newStudent = new Student("Russ", "2016-1-1");
// act
string result = newStudent.GetDoe();
Assert.Equal("2016-1-1", result);
}
public void Test3_SetName()
{
// arrange
Student newStudent = new Student("Russ", "2016-1-1");
newStudent.SetName("Sam");
// act
string result = newStudent.GetName();
Assert.Equal("Sam", result);
}
public void Test4_SaveStudent()
{
//Arrange
Student newStudent = new Student("Russ", "2016-1-1");
newStudent.Save();
//ACt
List<Student> allStudents = Student.GetAll();
Console.WriteLine(allStudents.Count);
//assert
Assert.Equal(newStudent, allStudents[0]);
}
public HomeModule()
{
Get["/"] = _ => {
return View["index.cshtml"];
};
Get["/students"] = _ => {
List<Student> allStudents = Student.GetAll();
return View["students.cshtml", allStudents];
};
Get["/students/new"] = _ => {
return View["add_student.cshtml"];
};
Post["/students/new"] = _ => {
Student newStudent = new Student(Request.Form["student-name"],Request.Form["student-doe"]);
newStudent.Save();
List<Student> allStudents= Student.GetAll();
return View["students.cshtml", allStudents];
};
Get["/students/delete/{id}"] = parameters => {
Student SelectedStudent = Student.Find(parameters.id);
return View["confirm_student_delete.cshtml", SelectedStudent];
};
Get["students/edit/{id}"] = parameters => {
Student SelectedStudent = Student.Find(parameters.id);
return View["student_edit.cshtml", SelectedStudent];
};
Patch["students/edit/{id}"] = parameters => {
Student SelectedStudent = Student.Find(parameters.id);
SelectedStudent.Update(Request.Form["student-name"]);
return View["index.cshtml"];
};
Delete["/students/delete/{id}"] = parameters => {
Student SelectedStudent = Student.Find(parameters.id);
SelectedStudent.Delete();
return View["index.cshtml"];
};
Post["/students/delete"] = _ => {
Student.DeleteAll();
return View["index.cshtml"];
};
}
public static List<Student> GetAll()
{
List<Student> allStudents = new List<Student>{};
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM students;", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while(rdr.Read())
{
int studentId = rdr.GetInt32(0);
string studentName = rdr.GetString(1);
string studentDoe = rdr.GetString(2);
Student newStudent = new Student(studentName, studentDoe, studentId);
allStudents.Add(newStudent);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return allStudents;
}
public void Test7_DeleteOneStudent()
{
Student firstStudent = new Student("Russ","2016-1-1");
firstStudent.Save();
Student secondStudent = new Student("Bob", "2016-1-1");
secondStudent.Save();
firstStudent.Delete();
List<Student> allStudents = Student.GetAll();
List<Student> afterDeleteFristStudent = new List<Student> {secondStudent};
Assert.Equal(afterDeleteFristStudent, allStudents);
}
public void Test6_UpdateStudent_Database()
{
Student newStudent = new Student("Rouz","2016-1-1");
newStudent.Save();
newStudent.Update("mike");
string result = newStudent.GetName();
Assert.Equal("mike", result);
}
