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