public static async Task <HttpResponseMessage> Run( [HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestMessage req, ILogger log, ExecutionContext context) { try { ScreeningInfo screeningInfo = await req.Content.ReadAsAsync <ScreeningInfo>(); if (screeningInfo == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } bool dataRecorded = await DbHelper.PostDataAsync(screeningInfo, Constants.postScreeningInfo); 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); } }
//returneaza orele la care ruleaza un film intr-o anumita zi public ActionResult <List <ScreeningInfo> > GetHours(DateTime?date, int id) { if (date != null) { if (date <= DateTime.Now.AddDays(-1) && date > DateTime.Now.AddDays(6)) { return(BadRequest()); } } var ScreeningHours = _context.Screenings.Where(x => x.movieId == id).Where(x => x.date == date).OrderBy(x => x.s_hour).ToList(); List <ScreeningInfo> screenings = new List <ScreeningInfo>(); foreach (var screeningHour in ScreeningHours) { var nohours = screeningHour.s_hour.Hour; var nominutes = screeningHour.s_hour.Minute; var notoadd = nohours * 60 + nominutes - 30; DateTime date2 = (DateTime)date; if (DateTime.Now < (DateTime)date2.AddMinutes(notoadd)) { ScreeningInfo screening = new ScreeningInfo() { screeningId = screeningHour.Id, hour = screeningHour.s_hour, is3D = screeningHour.is3D }; screenings.Add(screening); } } return(Ok(screenings)); }
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))); } } }
public Screening(DateTime _date, ScreeningInfo _result) { Date = _date; Result = _result; }