public Accident(vw_PQT_AccidentHeader a) { Units = from u in db.vw_PQT_Units where u.REPORTINGAGENCY == a.REPORTINGAGENCYid && u.REPORTNUMBER == a.REPORTNUMBER select u; REPORTINGAGENCYid = a.REPORTINGAGENCYid; ReportingAgency = a.ReportingAgency; REPORTNUMBER = a.REPORTNUMBER; LOCALID = a.LOCALID; ACCIDENTTIME = a.ACCIDENTTIME; ACCIDENTDATE = a.ACCIDENTDATE; STREETADDRESS = a.STREETADDRESS; AOTROADWAYGROUPid = a.AOTROADWAYGROUPid; RoadGroup = a.RoadGroup; VCSG_AOTROUTE = a.VCSG_AOTROUTE; HOWMAPPED = a.HOWMAPPED; CITYTOWN = a.GIS_CITYTOWN; if (a.HOWMAPPED != null) { LATITUDE = a.GIS_LATITUDE; LONGITUDE = a.GIS_LONGITUDE; } else if (a.VCSG_LONGITUDE != null && a.VCSG_LATITUDE != null) { LATITUDE = a.VCSG_LATITUDE; LONGITUDE = a.VCSG_LONGITUDE; } //computed fields InjuryType = GetInjuryType(a); Weather = GetWeatherCondition(a); DayNight = GetDayNight(a.ACCIDENTTIME); Impairment = GetImpairment(); Involving = GetInvolving(); Animal = GetAnimal(); }
public string GetWeatherCondition(vw_PQT_AccidentHeader a) { switch (Convert.ToInt32(a.WEATHERCONDITIONid)) { case 1: return "Clear"; case 2: case 3: return "Cloudy"; case 4: return "Rain"; case 5: case 6: return "Freezing Precipitation"; case 7: case 8: return "Wind"; case 9: case 10: case 11: return "Unknown"; default: return "Unkown"; } }
public string GetInjuryType(vw_PQT_AccidentHeader a) { return a.CrashType; }