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); } }