/// <summary>
/// Data Set Get Trailer Data
/// </summary>
private DataSet GetTrailerData()
{
DataSet dsTrailers = null;
if (Request.QueryString["showAvailable"] != null)
{
DateTime startDate = DateTime.Parse(dteStartDate.SelectedDate.ToString());
startDate = startDate.Subtract(startDate.TimeOfDay);
DateTime endDate = DateTime.Parse(dteEndDate.SelectedDate.ToString());
endDate = endDate.Subtract(endDate.TimeOfDay).Add(new TimeSpan(23, 59, 59));
Facade.IResource facTrailer = new Facade.Resource();
dsTrailers = facTrailer.GetAvailableForDateRange(eResourceType.Trailer, startDate, endDate);
pnlTrailer.Visible = true;
}
else if (!String.IsNullOrEmpty(txtFilterTrailerRef.Text))
{
Facade.ITrailer facResource = new Facade.Resource();
dsTrailers = facResource.GetFiltered(false, txtFilterTrailerRef.Text);
pnlTrailer.Visible = true;
}
else
{
Facade.ITrailer facResource = new Facade.Resource();
dsTrailers = facResource.GetAll(false, false);
pnlTrailer.Visible = true;
}
return(dsTrailers);
}
/// <summary>
/// Data Set Get Vehicle Data
/// </summary
private DataSet GetVehicleData(bool inlcudeDeleted)
{
Facade.IVehicle facResource = new Facade.Resource();
DataSet dsVehicles = null;
Facade.IResource facTrailer = new Facade.Resource();
if (Request.QueryString["showAvailable"] != null)
{
DateTime startDate = rdiStartDate.SelectedDate.Value;
startDate = startDate.Subtract(startDate.TimeOfDay);
DateTime endDate = rdiEndDate.SelectedDate.Value;
endDate = endDate.Subtract(endDate.TimeOfDay).Add(new TimeSpan(23, 59, 59));
dsVehicles = facTrailer.GetAvailableForDateRange(eResourceType.Vehicle, startDate, endDate);
if (Orchestrator.Globals.Configuration.FleetMetrikInstance)
{
dsVehicles.Tables[0].Columns.Add("CurrentLocation", typeof(string));
}
}
else if (Orchestrator.Globals.Configuration.FleetMetrikInstance)
{
dsVehicles = facResource.GetAllWithGPS(inlcudeDeleted);
dsVehicles.Tables[0].Columns.Add("CurrentLocation", typeof(string));
}
else
{
dsVehicles = facResource.GetAllVehicles();
if (Orchestrator.Globals.Configuration.FleetMetrikInstance)
{
dsVehicles.Tables[0].Columns.Add("CurrentLocation", typeof(string));
}
}
return(dsVehicles);
}
private void PopulateVehicles()
{
DataSet ds = null;
if (dteStartDate.SelectedDate != DateTime.MinValue && dteEndDate.SelectedDate != DateTime.MinValue)
{
DateTime startDate = dteStartDate.SelectedDate.Value;
startDate = startDate.Subtract(startDate.TimeOfDay);
DateTime endDate = dteEndDate.SelectedDate.Value;
endDate = endDate.Subtract(endDate.TimeOfDay).Add(new TimeSpan(23, 59, 59));
Facade.IResource facResource = new Facade.Resource();
ds = facResource.GetAvailableForDateRange(eResourceType.Vehicle, startDate, endDate);
}
else
{
ds = (DataSet)ViewState[C_VEHICLESDS_VS];
}
if (ds != null)
{
DataView dv = new DataView(ds.Tables[0]);
string sortExpression = SortCriteria + " " + SortDirection;
dv.Sort = sortExpression.Trim();
dgVehicles.DataSource = dv;
dgVehicles.DataBind();
ViewState[C_VEHICLESDS_VS] = ds;
}
else
{
dgVehicles.Visible = false;
}
}
