public string GetCars()
{
GpsTrackingContext dbContext = new GpsTrackingContext();
locations = dbContext.GpsReal
.OrderByDescending(t => t.Id).ToList()
.DistinctBy(t => t.ModemId).ToList();
var context = GlobalHost.ConnectionManager.GetHubContext <TrackingHub>();
return(context.Clients.All.RecieveNotification(locations).ToString());
}
private void Pagging()
{
const int rowsPerPage = 10;
DbContext = new GpsTrackingContext();
var total = DbContext.GpsReal.Count();
var pageCount = Convert.ToInt32(Math.Ceiling((float)total / rowsPerPage));
var pageCountSize = 2;
var startPage = Convert.ToInt32(ViewState["CurrentPage"]) > pageCountSize
? Convert.ToInt32(ViewState["CurrentPage"]) - pageCountSize
: 1;
int endPage;
if (Convert.ToInt32(ViewState["CurrentPage"]) + pageCountSize < pageCount)
{
endPage = Convert.ToInt32(ViewState["CurrentPage"]) + pageCountSize;
}
else
{
endPage = pageCount;
}
var dt = new DataTable();
dt.Columns.Add("page");
dt.Columns.Add("class");
for (var i = startPage; i <= endPage; i++)
{
var R = dt.NewRow();
R["page"] = i;
R["class"] = Convert.ToInt32(ViewState["CurrentPage"]) == i ? "current" : " ";
dt.Rows.Add(R);
}
RpPager.DataSource = dt;
RpPager.DataBind();
var gpsReals = GpsRealPagging(rowsPerPage, Convert.ToInt32(ViewState["CurrentPage"]), txtType.Text,
!string.IsNullOrEmpty(fromDate.Text) ? Convert.ToDateTime(fromDate.Text) : (DateTime?)null,
!string.IsNullOrEmpty(toDate.Text) ? Convert.ToDateTime(toDate.Text) : (DateTime?)null);
GridView1.DataSource = gpsReals;
GridView1.DataBind();
NoData.Visible = GridView1.Rows.Count == 0;
RpPager.Visible = GridView1.Rows.Count >= 10;
}
// POST api/<controller>
public HttpResponseMessage Post([FromBody] BlockedAreaRequest request)
{
var dbContext = new GpsTrackingContext();
var existBlockedAreas = dbContext.BlockedAreas
.Include(t => t.BlockedAreaCoordinates)
.ToList();
foreach (var existBlockedArea in existBlockedAreas)
{
dbContext.BlockedAreaCoordinates.RemoveRange(existBlockedArea.BlockedAreaCoordinates);
}
dbContext.BlockedAreas.RemoveRange(existBlockedAreas);
dbContext.SaveChanges();
try
{
foreach (var requestBlockedArea in request.BlockedAreas)
{
var area = new BlockedArea(requestBlockedArea.Name, requestBlockedArea.Radius);
foreach (var areaCoordinate in requestBlockedArea.BlockedAreaCoordinates)
{
area.BlockedAreaCoordinates.Add(new BlockedAreaCoordinate(areaCoordinate.Lat,
areaCoordinate.Lng));
}
dbContext.BlockedAreas.Add(area);
}
dbContext.SaveChanges();
var response = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StringContent("Success")
};
return(response);
}
catch (Exception e)
{
var response = new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent(e.Message)
};
return(response);
}
}
public BlockedAreaRequest Get()
{
var dbContext = new GpsTrackingContext();
var blockedAreas = dbContext.BlockedAreas
.Include(t => t.BlockedAreaCoordinates)
.Select(t => new BlockedAreaModel
{
BlockedAreaCoordinates = t.BlockedAreaCoordinates.Select(c => new BlockedAreaCoordinateModel
{
Lat = c.Lat,
Lng = c.Long
}),
Name = t.Name,
Radius = t.Radius
});
return(new BlockedAreaRequest
{
BlockedAreas = blockedAreas
});
}
// GET api/<controller>/5
public List <TrackPoint> Get([FromUri] Request request)
{
var dbContext = new GpsTrackingContext();
return(dbContext.GpsReal
.Where(t => t.ModemId == request.SelectedCar)
.ToList()
.Where(t =>
DateTime.ParseExact(t.ServerTimestamp, "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture) >=
request.From &&
DateTime.ParseExact(t.ServerTimestamp, "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture) <=
request.To)
.Select(t => new TrackPoint
{
Lat = t.Lat,
Lng = t.Long,
Speed = t.Speed,
Date = DateTime.ParseExact(t.ServerTimestamp, "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture),
CarId = t.ModemId,
CarDirection = t.Direction
}).ToList());
}
public UnitOfWork(GpsTrackingContext context)
{
this.context = context;//new GpsTrackingContext();
}
public Repository(GpsTrackingContext context)
{
_context = context;//new GpsTrackingContext(); ;
}
public RoleStoreIntPk(GpsTrackingContext context)
: base(context)
{
}
public UserStoreIntPk(GpsTrackingContext context)
: base(context)
{
}
public UnitOfWork(GpsTrackingContext context)
{
this.context = context;//new GpsTrackingContext();
}
