public static async Task <HttpResponseMessage> Run( [HttpTrigger(AuthorizationLevel.Function, "get", Route = "GetUserUnderlyingInfo/{UserId}")] HttpRequest req, string UserId, ILogger log, ExecutionContext context) { if (UserId == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } try { UserUnderlyingInfo userUnderlyingInfo = await DbHelper.GetDataAsync <UserUnderlyingInfo>( Constants.getUserUnderlyingInfo, UserId); if (userUnderlyingInfo == null) { return(new HttpResponseMessage(HttpStatusCode.NotFound)); } log.LogInformation(JsonConvert.SerializeObject(userUnderlyingInfo)); return(new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(JsonConvert.SerializeObject(userUnderlyingInfo), Encoding.UTF8, "application/json") }); } catch (System.Exception ex) { log.LogInformation(ex.Message); return(null); } }
public static async Task <HttpResponseMessage> Run( [HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestMessage req, ILogger log, ExecutionContext context) { try { UserUnderlyingInfo userUnderlyingInfo = await req.Content.ReadAsAsync <UserUnderlyingInfo>(); if (userUnderlyingInfo == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } bool dataRecorded = await DbHelper.PostDataAsync(userUnderlyingInfo, Constants.postUserUnderlyingInfo); if (dataRecorded) { log.LogInformation("Data recorded"); return(new HttpResponseMessage(HttpStatusCode.OK)); } else { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } } catch (System.Exception ex) { log.LogInformation(ex.Message); return(null); } }
public static async Task <T> GetDataAsync <T>(string ops, string paramString) { var conStr = System.Environment.GetEnvironmentVariable("SqlConnectionString", EnvironmentVariableTarget.Process); switch (ops) { case Constants.getUserInfo: UserInfo userInfo = new UserInfo(); using (SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandText = "SELECT * FROM UserInfo where UserId = " + "'" + paramString + "'"; cmd.Connection = conn; reader = cmd.ExecuteReader(); if (reader != null) { while (reader.Read()) { userInfo.UserId = reader["UserId"].ToString(); userInfo.UserType = reader["UserType"].ToString(); userInfo.FirstName = reader["FirstName"].ToString(); userInfo.LastName = reader["LastName"].ToString(); userInfo.Role = reader["Role"].ToString(); userInfo.Age = (int)reader["Age"]; userInfo.MobileNumber = reader["MobileNumber"].ToString(); userInfo.EmailAddress = reader["EmailAddress"].ToString(); userInfo.StreetAddress1 = reader["StreetAddress1"].ToString(); userInfo.StreetAddress1 = reader["StreetAddress2"].ToString(); userInfo.StreetAddress1 = reader["City"].ToString(); userInfo.StreetAddress1 = reader["State"].ToString(); userInfo.StreetAddress1 = reader["Country"].ToString(); userInfo.StreetAddress1 = reader["ZipCode"].ToString(); userInfo.TeamsAddress = reader["TeamsAddress"].ToString(); userInfo.TwilioAddress = reader["TwilioAddress"].ToString(); } } return((T)Convert.ChangeType(userInfo, typeof(T))); } case Constants.getScreeningInfo: using (SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; List <ScreeningInfo> lstScreenInfo = new List <ScreeningInfo>(); cmd.CommandText = "SELECT * FROM ScreeningInfo where UserId = " + "'" + paramString + "'"; cmd.Connection = conn; reader = cmd.ExecuteReader(); if (reader != null) { while (reader.Read()) { ScreeningInfo screeningInfo = new ScreeningInfo(); screeningInfo.UserId = reader["UserId"].ToString(); screeningInfo.DateOfEntry = reader["DateOfEntry"].ToString(); screeningInfo.UserExposed = DBNull.Value.Equals(reader["UserExposed"]) ? false : (bool)reader["UserExposed"]; screeningInfo.ExposureDirect = DBNull.Value.Equals(reader["ExposureDirect"]) ? false : (bool)reader["ExposureDirect"]; screeningInfo.ExposureIndirect = DBNull.Value.Equals(reader["ExposureIndirect"]) ? false : (bool)reader["ExposureIndirect"]; screeningInfo.ExposureMultiple = DBNull.Value.Equals(reader["ExposureMultiple"]) ? false : (bool)reader["ExposureMultiple"]; screeningInfo.ExposureNotsure = DBNull.Value.Equals(reader["ExposureNotsure"]) ? false : (bool)reader["ExposureNotsure"]; screeningInfo.ExposureDate = reader["ExposureDate"].ToString(); screeningInfo.SymptomsYesNo = DBNull.Value.Equals(reader["SymptomsYesNo"]) ? false : (bool)reader["SymptomsYesNo"]; screeningInfo.SymptomFever = DBNull.Value.Equals(reader["SymptomFever"]) ? false : (bool)reader["SymptomFever"]; screeningInfo.SymptomShortnessOfBreath = DBNull.Value.Equals(reader["ExposureDirect"]) ? false : (bool)reader["SymptomShortnessOfBreath"]; screeningInfo.SymptomCough = DBNull.Value.Equals(reader["SymptomShortnessOfBreath"]) ? false : (bool)reader["SymptomCough"]; screeningInfo.SymptomRunningNose = DBNull.Value.Equals(reader["SymptomRunningNose"]) ? false : (bool)reader["SymptomRunningNose"]; screeningInfo.SymptomSoreThroat = DBNull.Value.Equals(reader["SymptomSoreThroat"]) ? false : (bool)reader["SymptomSoreThroat"]; screeningInfo.SymptomChills = DBNull.Value.Equals(reader["SymptomChills"]) ? false : (bool)reader["SymptomChills"]; screeningInfo.SymptomDizziness = DBNull.Value.Equals(reader["SymptomDizziness"]) ? false : (bool)reader["SymptomDizziness"]; screeningInfo.SymptomAbdomenPain = DBNull.Value.Equals(reader["SymptomAbdomenPain"]) ? false : (bool)reader["SymptomAbdomenPain"]; screeningInfo.SymptomOther = reader["SymptomOther"].ToString(); screeningInfo.GUID = reader["GUID"].ToString(); screeningInfo.QuarantineRequired = DBNull.Value.Equals(reader["QuarantineRequired"]) ? false : (bool)reader["QuarantineRequired"]; lstScreenInfo.Add(screeningInfo); } } return((T)Convert.ChangeType(lstScreenInfo, typeof(T))); } case Constants.getUserUnderlyingInfo: UserUnderlyingInfo userUnderlyingInfo = new UserUnderlyingInfo(); using (SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandText = "SELECT * FROM UserUnderlyingInfo where UserId = " + "'" + paramString + "'"; cmd.Connection = conn; reader = cmd.ExecuteReader(); if (reader != null) { while (reader.Read()) { userUnderlyingInfo.UserId = reader["UserId"].ToString(); userUnderlyingInfo.HeartDisease = DBNull.Value.Equals(reader["HeartDisease"]) ? false : (bool)reader["HeartDisease"]; userUnderlyingInfo.Asthma = DBNull.Value.Equals(reader["Asthma"]) ? false : (bool)reader["Asthma"]; userUnderlyingInfo.LungProblems = DBNull.Value.Equals(reader["LungProblems"]) ? false : (bool)reader["LungProblems"]; userUnderlyingInfo.Cancer = DBNull.Value.Equals(reader["Cancer"]) ? false : (bool)reader["Cancer"]; userUnderlyingInfo.Diabetes = DBNull.Value.Equals(reader["Diabetes"]) ? false : (bool)reader["Diabetes"]; userUnderlyingInfo.Chemotherapy = DBNull.Value.Equals(reader["Chemotherapy"]) ? false : (bool)reader["Chemotherapy"]; userUnderlyingInfo.Arthritis = DBNull.Value.Equals(reader["Arthritis"]) ? false : (bool)reader["Arthritis"]; userUnderlyingInfo.isThermometerHandy = DBNull.Value.Equals(reader["isThermometerHandy"]) ? false : (bool)reader["isThermometerHandy"]; userUnderlyingInfo.isO2SatMonitorHandy = DBNull.Value.Equals(reader["isO2SatMonitorHandy"]) ? false : (bool)reader["isO2SatMonitorHandy"]; } } return((T)Convert.ChangeType(userUnderlyingInfo, typeof(T))); } default: QuarantineInfo quarantineInfo = new QuarantineInfo(); List <QuarantineInfo> ListqData = new List <QuarantineInfo>(); using (SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandText = "SELECT * FROM QuarantineInfo where UserId = " + "'" + paramString + "'"; cmd.Connection = conn; reader = cmd.ExecuteReader(); if (reader != null) { while (reader.Read()) { QuarantineInfo qData = new QuarantineInfo(); qData.UserId = reader["UserId"].ToString(); qData.Cycle = DBNull.Value.Equals(reader["Cycle"]) ? 0 : (int)reader["Cycle"]; qData.QuarStartDate = reader["QuarStartDate"].ToString(); qData.QuarMidpointDate = reader["QuarMidpointDate"].ToString(); qData.QuarEndDate = reader["QuarEndDate"].ToString(); qData.DateOfEntry = reader["DateOfEntry"].ToString(); qData.SymptomFever = DBNull.Value.Equals(reader["SymptomFever"]) ? false : (bool)reader["SymptomFever"]; qData.SymptomShortnessOfBreath = DBNull.Value.Equals(reader["SymptomShortnessOfBreath"]) ? false : (bool)reader["SymptomShortnessOfBreath"]; qData.SymptomCough = DBNull.Value.Equals(reader["SymptomCough"]) ? false : (bool)reader["SymptomCough"]; qData.SymptomRunningNose = DBNull.Value.Equals(reader["SymptomRunningNose"]) ? false : (bool)reader["SymptomRunningNose"]; qData.SymptomSoreThroat = DBNull.Value.Equals(reader["SymptomSoreThroat"]) ? false : (bool)reader["SymptomSoreThroat"]; qData.SymptomChills = DBNull.Value.Equals(reader["SymptomChills"]) ? false : (bool)reader["SymptomChills"]; qData.SymptomDizziness = DBNull.Value.Equals(reader["SymptomDizziness"]) ? false : (bool)reader["SymptomDizziness"]; qData.SymptomAbdomenPain = DBNull.Value.Equals(reader["SymptomAbdomenPain"]) ? false : (bool)reader["SymptomAbdomenPain"]; qData.SymptomDiarrhea = DBNull.Value.Equals(reader["SymptomDiarrhea"]) ? false : (bool)reader["SymptomDiarrhea"]; qData.SymptomFatigue = DBNull.Value.Equals(reader["SymptomFatigue"]) ? false : (bool)reader["SymptomFatigue"]; qData.SymptomOther = reader["SymptomOther"].ToString(); qData.Temperature = DBNull.Value.Equals(reader["Temperature"]) ? 0 : (decimal)reader["Temperature"]; qData.O2Saturation = DBNull.Value.Equals(reader["O2Saturation"]) ? 0 : (decimal)reader["O2Saturation"]; qData.AntibodyTestDate = reader["AntibodyTestDate"].ToString(); qData.AntibodyTestResult = DBNull.Value.Equals(reader["AntibodyTestResult"]) ? false : (bool)reader["AntibodyTestResult"]; qData.RequestRTW = reader["RequestRTW"].ToString(); qData.ApprovalRTW = DBNull.Value.Equals(reader["ApprovalRTW"]) ? false : (bool)reader["ApprovalRTW"]; qData.TeamsCallInitiated = DBNull.Value.Equals(reader["TeamsCallInitiated"]) ? false : (bool)reader["TeamsCallInitiated"]; qData.TeamsCallCompleted = DBNull.Value.Equals(reader["TeamsCallCompleted"]) ? false : (bool)reader["TeamsCallCompleted"]; ListqData.Add(qData); } } return((T)Convert.ChangeType(ListqData, typeof(T))); } } }