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