public static Patient GetById(Guid patientId)
{
var query = SqlQueryGeneration.GetPatientById(patientId);
var patient = _sqlManager.GetPatient(query);
return(patient.Count > 0 ? patient.First() : null);
}