/**
* @Route("/testdb",name="database")
*/
public function test()
{
$member = new Entity\Member();
$member->setMobile("07129832");
$member->setRegisterDate("12/12/2012");
$member->setEmail("*****@*****.**");
$member->setFirstName("Nuwan");
$member->setLastName("Rathnayaka");
$member->setStudentId("123456F");
$member->setDeptName("noone");
$r = new Entity\Resource();
$r->setResourceId("1");
$r->setDescription("this description");
$r->setOfficerId("1234");
$r->setValue("sdsds");
$ra = new Entity\ResourceAllocation();
$ra->setResourceId("1");
$ra->setMemberId("123456F");
$ra->setComments("Use enjoy it");
$ra->setDueDate("2016-01-07");
$ra->setIssuedDate("2015-12-34");
$nStudent = new Entity\Member();
$nStudent->setStudentId("123456");
$db = new Modal\DBAccess($nStudent);
$n = $db->getDetail();
echo $n->getFirstName();
return new Response();
}
private function getUser($username)
{
$db = new DBConnection();
$link = $db->connect();
$query = "SELECT * FROM app_user WHERE email ='{$username}'";
$result = $link->query($query);
$user = null;
$member_id = 0;
while ($row = mysqli_fetch_assoc($result)) {
$user = new User($row['email'], $row['password'], "", unserialize($row['role']));
$member_id = $row['id'];
}
$db->closeConnection();
$member = new Member();
$member->setStudentId($member_id);
$da = new DBAccess($member);
$user->setMember($da->getDetail());
return $user;
}
