public static PatientModel LoadPatient(int patientId)
{
return(SqlDataAccess.LoadSingle <PatientModel>
(
@"SELECT Id, NHSNumber, Password, FK_PatientDetails_Id as Details FROM dbo.Patient
WHERE Id = @Id",
new PatientModel {
Id = patientId
}
));
}
public static PatientDetailsModel LoadPatientDetails(int id)
{
return(SqlDataAccess.LoadSingle <PatientDetailsModel>
(
@"SELECT * FROM dbo.PatientDetails
WHERE Id = @Id",
new PatientDetailsModel {
Id = id
}
));
}
public static ClinicianModel GetClinicianByHCP(string hcpId)
{
ClinicianModel data = new ClinicianModel
{
HCPId = hcpId
};
return(SqlDataAccess.LoadSingle <ClinicianModel>
(
@"SELECT * FROM dbo.Clinician
WHERE HCPId = @HCPId",
data
));
}
public static AdminModel AuthoriseAdmin(string username, string password)
{
AdminModel data = new AdminModel
{
Username = username,
Password = password
};
AdminModel adminModel = SqlDataAccess.LoadSingle <AdminModel>
(
@"SELECT Id, Username, Password FROM dbo.Admin
WHERE Username = @Username AND Password = @Password",
data
);
return(adminModel);
}
public static ClinicianModel AuthoriseClinician(string hcpId, string password)
{
ClinicianModel data = new ClinicianModel
{
HCPId = hcpId,
Password = password
};
ClinicianModel clinicianModel = SqlDataAccess.LoadSingle <ClinicianModel>
(
@"SELECT Id, HCPId, Password FROM dbo.Clinician
WHERE HCPId = @HCPId AND Password = @Password",
data
);
return(clinicianModel);
}