/*
* public static TransportList Transports()
* {
* TransportList _tl = new TransportList();
* using (var db = new dbEntities())
* {
* foreach(var t in db.vDumps)
* {
* _tl.AddTransport(new Transport(t.TransportId)
* {
* ParkNumber = t.ParkNumber,
* TypeId = t.TypeId,
* ModelId = t.ModelId,
* LastLongitude = (double)t.LastLongitude,
* LastLatitude = (double)t.LastLatitude
* });
* }
* }
* return _tl;
* }
*/
public static Dictionary <string, Dictionary <string, Dictionary <string, string> > > TransportsDict()
{
Dictionary <string, Dictionary <string, Dictionary <string, string> > > result = new Dictionary <string, Dictionary <string, Dictionary <string, string> > >();
using (var db = new dbEntities())
{
foreach (var t in db.vDumps)
{
if (!result.ContainsKey(t.TransportId))
{
result[t.TransportId] = new Dictionary <string, Dictionary <string, string> >();
}
if (!result[t.TransportId].ContainsKey("base"))
{
result[t.TransportId]["base"] = new Dictionary <string, string>();
}
if (!result[t.TransportId].ContainsKey("curdata"))
{
result[t.TransportId]["curdata"] = new Dictionary <string, string>();
}
//result[t.TransportId]["base"] = basedata;
//result[t.TransportId]["curdata"] = curdata;
result[t.TransportId]["base"]["id"] = t.TransportId;
result[t.TransportId]["base"]["park"] = t.ParkNumber;
result[t.TransportId]["base"]["type"] = t.TypeId;
result[t.TransportId]["base"]["model"] = t.ModelId;
result[t.TransportId]["curdata"]["lon"] = t.LastLongitude.ToString();
result[t.TransportId]["curdata"]["lat"] = t.LastLatitude.ToString();
}
}
return(result);
}
public static List <TransportItem> ToTransportProgress()
{
List <TransportItem> _trp = new List <TransportItem>();
using (var db = new dbEntities())
{
foreach (var t in db.vDumps)
{
TransportItem _ti = new TransportItem(t.TransportId);
_ti.ParkNumber = t.ParkNumber;
_ti.ModelId = t.ModelId;
_ti.TypeId = t.TypeId;
_ti.CurrentLocation.Latitude = (double)t.LastLatitude;
_ti.CurrentLocation.Longitude = (double)t.LastLongitude;
_trp.Add(_ti);
}
}
return(_trp);
}
public static List<ZoneItem> ToZoneProgress()
{
List<_Zone> _zonelist = new List<_Zone>();
using (var db = new dbEntities())
{
_zonelist = db.vZones.Select(x => new _Zone()
{
ZoneId = x.ZoneId,
ZoneName = x.ZoneName,
ZoneTypeId = (int)x.ZoneTypeId,
x = (double)x.x,
y = (double)x.y,
}).ToList();
}
string currentzone = string.Empty;
List<ZoneItem> znplist = new List<ZoneItem>();
ZoneItem zone = new ZoneItem();
foreach (var z in _zonelist)
{
if (z.ZoneId != currentzone && currentzone != string.Empty)
{
znplist.Add(zone);
currentzone = z.ZoneId;
zone = new ZoneItem(z.ZoneId);
zone.DisplayName = z.ZoneName;
zone.Type = z.ZoneTypeId;
}
if (currentzone == string.Empty)
{
currentzone = z.ZoneId;
zone.Id = z.ZoneId;
zone.DisplayName = z.ZoneName;
zone.Type = z.ZoneTypeId;
}
zone.AddPoint(z.x, z.y);
}
return znplist;
}