// returns null if no a like users
public List <int> getSleepSegmentsStatsAveragesFromALikeUsersCombined(string _userId, int userAge, int userHeight, int userWeight, string userGender)
{
UserDetailsRepository repo = new UserDetailsRepository();
UserIdsModel r = repo.GetUsersByGenderHeightWeightAndAgeRange(userAge, userHeight, userWeight, userGender);
if (r.userIds.Count == 0)
{
return(null);
}
StringBuilder sbs = new StringBuilder();
foreach (string s in r.userIds)
{
sbs.Append(s + ",");
}
sbs = sbs.Remove(sbs.Length - 1, 1); //remove the last comma
string users = sbs.ToString();
var usersParam = new Parameter("users", users);
var sleepSegmentsStatsAverages = CallAzureDatabase("GetAverageSleepSegmentsStatsFromUsers", usersParam);
if (sleepSegmentsStatsAverages == null)
{
return(null);
}
List <int> averages = JsonConvert.DeserializeObject <List <int> >(sleepSegmentsStatsAverages);
return(averages);
}
public static void addUserToUserDetailsTable(UserDetailsRecord userDetails)
{
try
{
var _userDetailsRepository = new UserDetailsRepository();
var userRecord = _userDetailsRepository.SaveUserDetails(userDetails.userId,
userDetails.firstName,
userDetails.lastName,
userDetails.gender,
userDetails.age,
userDetails.height,
userDetails.weight);
if (userRecord == null)
{
throw new Exception("Error inserting user details to UserDetails table");
}
return;
}
catch (Exception e)
{
throw new AzureApiBadResponseCodeExcpetion(e);
}
}