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