public string getUserdatabyPatientAndtherapist(string lpatientId, string lTherapistId)
{
string result = string.Empty;
JsonUserData _user = new JsonUserData();
_user.Users = new List <User>();
try
{
var _patient = (from p in context.User
where p.UserId == lpatientId
select p).FirstOrDefault();
var _therapist = (from p in context.User
where p.UserId == lTherapistId
select p).FirstOrDefault();
if (_patient != null)
{
_user.Users.Add(_patient);
}
if (_therapist != null)
{
_user.Users.Add(_therapist);
}
_user.result = "success";
}
catch (Exception ex)
{
_user.result = "failed";
}
return(JsonConvert.SerializeObject(_user));
}
private IEnumerable <JsonUserData> ReadUserData()
{
var assembly = typeof(Program).GetTypeInfo().Assembly;
using Stream? resource = assembly.GetManifestResourceStream("SqExpress.IntTest.TestData.users.json");
var document = JsonDocument.Parse(resource);
foreach (var user in document.RootElement.EnumerateArray())
{
JsonUserData buffer = default;
foreach (var userProperty in user.EnumerateObject())
{
if (userProperty.Name == "external_id")
{
buffer.ExternalId = userProperty.Value.GetGuid();
}
if (userProperty.Name == "first_name")
{
buffer.FirstName = userProperty.Value.GetString();
}
if (userProperty.Name == "last_name")
{
buffer.LastName = userProperty.Value.GetString();
}
if (userProperty.Name == "email")
{
buffer.Email = userProperty.Value.GetString();
}
}
yield return(buffer);
}
}
