public static List <string> InsertDaylightPropDay(string id, int studymeasID, int indexnum, DaylightInfo.Daylight day)
{
List <string> s = new List <string>();
s.Add(String.Format("insert into ALL_ActigraphProps(verified, id, studymeasID, indexnum, ap_date, ap_section, ap_param, ap_value) values(1,'{0}',{1},{2},'{3}','{4}','{5}','{6}')"
, id, studymeasID, indexnum, day.Targetdate.Date, "DaylightInfo", "Sunrise", day.Sunrise.ToShortTimeString()));
s.Add(String.Format("insert into ALL_ActigraphProps(verified, id, studymeasID, indexnum, ap_date, ap_section, ap_param, ap_value) values(1,'{0}',{1},{2},'{3}','{4}','{5}','{6}')"
, id, studymeasID, indexnum, day.Targetdate.Date, "DaylightInfo", "Sunset", day.Sunset.ToShortTimeString()));
return(s);
}
public static string LogDaylightInfo(string id, int studymeasID_stats, int indexnum)
{
SQL_utils sql = new SQL_utils("data");
int studymeasID = sql.IntScalar_from_SQLstring("select studymeasID from uwautism_research_backend..tblstudymeas where measureID=4855 and " +
" timepointID=(select timepointID from uwautism_research_backend..tblstudymeas where studymeasID = " + studymeasID_stats.ToString() + ")");
string act_timezone = GetActigraphProperty(id, studymeasID, "Time Zone:");
string txtStartDate = GetActigraphProperty(id, studymeasID, "Data Collection Start Date:");
string txtEndDate = GetActigraphProperty(id, studymeasID, "Data Collection End Date:");
if (act_timezone != "Not Found!" & txtStartDate != "Not Found!" & txtEndDate != "Not Found!")
{
DateTime startdate = Convert.ToDateTime(txtStartDate).Date;
DateTime enddate = Convert.ToDateTime(txtEndDate).Date;
DbEntityInstance ent_studymeasID = new DbEntityInstance(new DbEntity(DbEntityType.studymeas), studymeasID);
int studyID = ent_studymeasID.PkvalOfRelatedEntity(DbEntityType.study);
int numdays = (enddate - startdate).Days;
try
{
DaylightInfo daylightinfo = new DaylightInfo(startdate, numdays, id, studyID, act_timezone);
List <string> insert_sql = new List <string>();
insert_sql.Add(InsertDaylightProp(id, studymeasID, indexnum, "Zip", daylightinfo.Zip));
insert_sql.Add(InsertDaylightProp(id, studymeasID, indexnum, "ZipDerivedFrom", daylightinfo.ZipDerivedFrom));
insert_sql.Add(InsertDaylightProp(id, studymeasID, indexnum, "Lat", daylightinfo.Lat));
insert_sql.Add(InsertDaylightProp(id, studymeasID, indexnum, "Lng", daylightinfo.Lng));
insert_sql.Add(InsertDaylightProp(id, studymeasID, indexnum, "Zip_TimeZoneName", daylightinfo.TimeZoneApiResultZip.zoneName));
insert_sql.Add(InsertDaylightProp(id, studymeasID, indexnum, "Zip_TimeZoneAbbr", daylightinfo.TimeZoneApiResultZip.abbreviation));
insert_sql.Add(InsertDaylightProp(id, studymeasID, indexnum, "Zip_TimeZoneNextAbbr", daylightinfo.TimeZoneApiResultZip.nextAbbreviation));
for (int i = 0; i < daylightinfo.Days.Count; i++)
{
DaylightInfo.Daylight day = daylightinfo.Days[i];
insert_sql.AddRange(InsertDaylightPropDay(id, studymeasID, indexnum, day));
}
foreach (string s in insert_sql)
{
sql.NonQuery_from_SQLstring(s);
}
return(String.Format("------ DaylightInfo ------ >> Looking up daylight hours: {0} properties inserted", insert_sql.Count));
}
catch (Exception ex)
{
return(ex.Message);
}
}
else
{
return(String.Format("------ DaylightInfo ------ >> TimeZone:{0} StartDate:{1} EndDate:{2}", act_timezone, txtStartDate, txtEndDate));
}
}
