/// <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);
}
public RadComboBoxItemData[] GetAllTrailers(RadComboBoxContext context)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
string[] clientArgs = context["FilterString"].ToString().Split(':');
int depotID = 0;
depotID = int.Parse(clientArgs[0]);
Facade.IResource facResource = new Facade.Resource();
DataSet ds = facResource.GetAllResourcesFiltered(context.Text, eResourceType.Trailer, depotID, false, true);
int itemsPerRequest = 20;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > ds.Tables[0].Rows.Count)
{
endOffset = ds.Tables[0].Rows.Count;
}
DataTable dt = ds.Tables[0];
Telerik.Web.UI.RadComboBoxItemData rcItem = null;
for (int i = itemOffset; i < endOffset; i++)
{
rcItem = new Telerik.Web.UI.RadComboBoxItemData();
rcItem.Text = dt.Rows[i]["Description"].ToString();
rcItem.Value = dt.Rows[i]["ResourceId"].ToString();
result.Add(rcItem);
}
return(result.ToArray());
}
void cboResource_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
cboResource.Items.Clear();
Facade.IResource facResource = new Facade.Resource();
DataSet ds = facResource.GetAllResourcesFiltered(e.Text, false, true);
int itemsPerRequest = 20;
int itemOffset = e.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > ds.Tables[0].Rows.Count)
{
endOffset = ds.Tables[0].Rows.Count;
}
DataTable dt = ds.Tables[0];
Telerik.Web.UI.RadComboBoxItem rcItem;
for (int i = itemOffset; i < endOffset; i++)
{
rcItem = new Telerik.Web.UI.RadComboBoxItem();
rcItem.Text = dt.Rows[i]["Description"].ToString();
rcItem.Value = dt.Rows[i]["ResourceId"].ToString();
cboResource.Items.Add(rcItem);
}
if (dt.Rows.Count > 0)
{
e.Message = string.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset, dt.Rows.Count);
}
}
public RadComboBoxItemData[] GetAllDrivers(RadComboBoxContext context)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
Facade.IResource facResource = new Facade.Resource();
DataSet ds = facResource.GetAllResourcesFiltered(context.Text, eResourceType.Driver, false);
var itemsPerRequest = context.ContainsKey("ItemsPerRequest") ? (int)context["ItemsPerRequest"] : 20;
DataTable dt = ds.Tables[0];
var itemCount = dt.Rows.Count;
int itemOffset = context.NumberOfItems;
int endOffset = itemsPerRequest == 0 ? itemCount : itemOffset + itemsPerRequest;
if (endOffset > itemCount)
{
endOffset = itemCount;
}
for (int i = itemOffset; i < endOffset; i++)
{
var rcItem = new Telerik.Web.UI.RadComboBoxItemData();
rcItem.Text = dt.Rows[i]["Description"].ToString();
rcItem.Value = dt.Rows[i]["ResourceId"].ToString();
result.Add(rcItem);
}
return(result.ToArray());
}
public static eTextAnywhereSendSMS SendSMS(string clientReference, string billingReference, eTextAnywhereOriginatorType originatorType, string recipientsNumber, string messageText, string user)
{
TextAnywhere_SMS myTextAnywhere_SMS = new TextAnywhere_SMS();
string formattedNumber = myTextAnywhere_SMS.FormatNumber(recipientsNumber);
eTextAnywhereSendSMS wsResult = (eTextAnywhereSendSMS)myTextAnywhere_SMS.SendSMS(
Orchestrator.Globals.Configuration.TextAnywhereUsername,
Orchestrator.Globals.Configuration.TextAnywherePassword,
clientReference,
Orchestrator.Globals.Configuration.TextAnywhereOriginator,
Int32.Parse(Orchestrator.Globals.Configuration.TextAnywhereConnection),
Configuration.TextAnywhereOriginator,
(int)originatorType,
formattedNumber,
messageText,
0,
0);
if (wsResult == eTextAnywhereSendSMS.SMSSent)
{
// Log the message data for audit trail
Facade.IDriverCommunication facDriverCommunication = new Facade.Resource();
facDriverCommunication.RecordSMS(clientReference, billingReference, recipientsNumber, messageText, user);
}
return(wsResult);
}
protected void Page_Load(object sender, System.EventArgs e)
{
Orchestrator.WebUI.Security.Authorise.EnforceAuthorisation(eSystemPortion.Plan, eSystemPortion.AddEditResource);
if (!IsPostBack)
{
if (Request.QueryString["resourceId"] != null && Request.QueryString["date"] != null && Request.QueryString["date"] != "undefined")
{
int resourceId = Convert.ToInt32(Request.QueryString["resourceId"]);
Facade.IDriver facDriver = new Facade.Resource();
cboDriver.Text = facDriver.GetDriverForResourceId(resourceId).Individual.FullName;
cboDriver.SelectedValue = resourceId.ToString();
string date = Request.QueryString["date"];
rdiDate.SelectedDate = new DateTime(Convert.ToInt32(date.Substring(6, 4)), Convert.ToInt32(date.Substring(3, 2)), Convert.ToInt32(date.Substring(0, 2)));
// Get the start time for the driver for this date and populate the time control.
DataSet dsStartTime = facDriver.GetStartTimesForDateAndDriver(resourceId, rdiDate.SelectedDate.Value);
if (dsStartTime.Tables[0].Rows.Count > 0)
{
rdiStartTime.SelectedDate = (DateTime)dsStartTime.Tables[0].Rows[0]["StartDateTime"];
txtNotes.Text = dsStartTime.Tables[0].Rows[0]["Notes"].ToString();
}
}
else
{
rdiDate.SelectedDate = DateTime.UtcNow;
}
}
}
/// <summary>
/// Update Trailer
/// </summary>
private bool UpdateTrailer()
{
Facade.ITrailer facResource = new Facade.Resource();
string userName = ((Entities.CustomPrincipal)Page.User).UserName;
Entities.FacadeResult result = facResource.Update(trailer, userName);
if (result.Success)
{
if (Configuration.IsMwfCustomer && !string.IsNullOrEmpty(Configuration.BlueSphereCustomerId))
{
try
{
MobileWorkerFlow.MWFServicesCommunication.Client.UpdateTrailerInBlueSphere(trailer, trailer.ResourceId.ToString());
}
catch (Exception ex)
{
// MM (2nd April 2012): Not ideal but solution for now, if fail to get through to bluesphere then show error to user
lblConfirmation.Text = "There was an error updating the trailer: " + ex.Message;
lblConfirmation.Visible = true;
lblConfirmation.ForeColor = Color.Red;
result = new Entities.FacadeResult(false);
return(false);
}
}
}
else
{
infringementDisplay.Infringements = result.Infringements;
infringementDisplay.DisplayInfringments();
}
return(result.Success);
}
protected void Page_Load(object sender, System.EventArgs e)
{
bool success = false;
try
{
int resourceId = Convert.ToInt32(Request.QueryString["ResourceId"]);
int resourceTypeId = Convert.ToInt32(Request.QueryString["ResourceTypeId"]);
int resourceStatusId = Convert.ToInt32(Request.QueryString["ResourceStatusId"]);
using (Facade.IResource facResource = new Facade.Resource())
success = facResource.UpdateResourceStatus(resourceId, (eResourceType)resourceTypeId, (eResourceStatus)resourceStatusId, ((Entities.CustomPrincipal)Page.User).UserName);
}
catch {}
Response.Clear();
if (success)
{
Response.Write("Success");
}
else
{
Response.Write("Failed");
}
}
private void ShowVehicles()
{
lstVehiclesInProfile.Items.Clear();
lstVehicles.Items.Clear();
// Get a list of the vehicles.
Facade.IVehicle facVehicle = new Facade.Resource();
DataSet dsVehicles = facVehicle.GetAllVehicles();
foreach (DataRow row in dsVehicles.Tables[0].Rows)
{
if (row["GPSUnitID"] != DBNull.Value && !String.IsNullOrEmpty(row["GPSUnitID"].ToString()) && this.Profile.GPSUnits.Exists(a => a == row["GPSUnitID"].ToString()))
{
lstVehiclesInProfile.Items.Add(new Telerik.Web.UI.RadListBoxItem()
{
Text = row["RegNo"].ToString(), Value = row["GPSUnitID"].ToString()
});
}
else
{
lstVehicles.Items.Add(new Telerik.Web.UI.RadListBoxItem()
{
Text = row["RegNo"].ToString(), Value = row["GPSUnitID"].ToString()
});
}
}
}
private void dgRequests_ItemCommand(object source, DataGridCommandEventArgs e)
{
HtmlInputHidden hidRequestId = (HtmlInputHidden)e.Item.FindControl("hidRequestId");
if (hidRequestId != null)
{
int requestId = Convert.ToInt32(hidRequestId.Value);
switch (e.CommandName.ToLower())
{
case "edit":
Response.Redirect("AddUpdateDriverRequest.aspx?requestId=" + requestId.ToString());
break;
case "delete":
Facade.IDriverRequest facDriverRequest = new Facade.Resource();
if (facDriverRequest.Delete(requestId, ((Entities.CustomPrincipal)Page.User).UserName))
{
lblConfirmation.Text = "The request has been deleted.";
}
else
{
lblConfirmation.Text = "The request has not been deleted.";
}
lblConfirmation.Visible = true;
FilterRequests();
break;
}
}
}
//---------------------------------------------------------------------------------------
protected void cboVehicle_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache);
cboVehicle.Items.Clear();
Telerik.Web.UI.RadComboBoxItem rcItem = new Telerik.Web.UI.RadComboBoxItem();
DataSet ds = null;
Facade.IResource facResource = new Facade.Resource();
ds = facResource.GetAllResourcesFiltered(e.Text, eResourceType.Vehicle, false);
if (ds != null)
{
int endOffset = 0;
DataTable boundResults = BindComboBoxItems(ds.Tables[0], e.NumberOfItems, out endOffset);
cboVehicle.DataSource = boundResults;
cboVehicle.DataBind();
if (boundResults.Rows.Count > 0)
{
e.Message = string.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), boundResults.Rows.Count.ToString());
}
}
}
private void PopulateFilter()
{
Facade.Resource facResource = new Facade.Resource();
Facade.IOrganisationLocation facOrganiastionLocation = new Facade.Organisation();
//resource types
var resourceTypes = facResource.GetAllResourceTypes();
cboResourceTypes.DataSource = resourceTypes.Tables[0];
cboResourceTypes.DataTextField = "Description";
cboResourceTypes.DataValueField = "ResourceTypeId";
cboResourceTypes.DataBind();
string driverTypeName = Enum.GetName(typeof(eResourceType), eResourceType.Driver);
cboResourceTypes.Items.FindByText(driverTypeName).Selected = true;
//driver types
var driverTypes = facResource.GetAllDriverTypes();
cboDriverTypes.DataSource = driverTypes.Tables[0];
cboDriverTypes.DataTextField = "Description";
cboDriverTypes.DataValueField = "DriverTypeID";
cboDriverTypes.DataBind();
cboDriverTypes.Items.Insert(0, new ListItem("-- all --", "0"));
//depots
cboDepots.DataSource = facOrganiastionLocation.GetAllDepots(Orchestrator.Globals.Configuration.IdentityId);
cboDepots.DataValueField = "OrganisationLocationId";
cboDepots.DataTextField = "OrganisationLocationName";
cboDepots.DataBind();
cboDepots.Items.Insert(0, new ListItem("-- all --", "0"));
}
private void FilterRequests()
{
DateTime startDate = dteFilterStartDate.SelectedDate.Value;
DateTime endDate = DateTime.MaxValue;
if (dteFilterEndDate.SelectedDate.HasValue)
{
endDate = dteFilterEndDate.SelectedDate.Value;
endDate = endDate.Subtract(endDate.TimeOfDay);
endDate = endDate.Add(new TimeSpan(0, 23, 59, 59));
}
int resourceId = 0;
if (cboDrivers.SelectedValue != "")
{
resourceId = Convert.ToInt32(cboDrivers.SelectedValue);
}
Facade.IDriver facDriver = new Facade.Resource();
DataSet dsRequests = facDriver.GetDriverRequests(startDate, endDate, resourceId, ((Entities.CustomPrincipal)Page.User).IdentityId);
DataView dvRequests = new DataView(dsRequests.Tables[0]);
dvRequests.Sort = (SortCriteria + " " + SortDirection).Trim();
dgRequests.DataSource = dvRequests;
dgRequests.DataBind();
}
private void BindRepeater()
{
Facade.IBusinessType facBusinessType = new Facade.BusinessType();
Facade.IOrganisation facOrganisation = new Facade.Organisation();
var selectedDrivers = hidSelectedDriversValues.Value;
var driverList = selectedDrivers.Split(',').ToList();
Facade.IDriver facDriver = new Facade.Resource();
DataSet ds = facDriver.GetAllDrivers(false);
var drivers = from driver in ds.Tables[0].AsEnumerable()
select driver;
if (!cbSelectedAllDrivers.Checked)
{
drivers = from driver in ds.Tables[0].AsEnumerable()
where driverList.Contains(driver.Field <int>("ResourceId").ToString())
select driver;
}
repDrivers.DataSource = drivers;
repDrivers.DataBind();
grdSummary.Rebind();
AllWorkForDriver = null;
}
private bool UpdateKey()
{
Facade.IVehicleKey facVehicleKey = new Facade.Resource();
string userId = ((Entities.CustomPrincipal)Page.User).UserName;
return(facVehicleKey.Update(m_key, userId));
}
protected void Page_Load(object sender, EventArgs e)
{
int resourceId = Convert.ToInt32(Request.QueryString["resourceId"]);
// Get the data representing the goods stored on the trailer.
Facade.ITrailer facTrailer = new Facade.Resource();
DataSet dsGoods = facTrailer.GetGoodsStoredOnTrailer(resourceId);
// Get the xml representation of the dataset and transform it ready for return to the client.
string xml = dsGoods.GetXml();
XmlDocument data = new XmlDocument();
data.LoadXml(xml);
XslCompiledTransform transformer = new XslCompiledTransform();
transformer.Load(Server.MapPath(@"..\xsl\goodsStoredOnTrailer.xsl"));
XsltArgumentList args = new XsltArgumentList();
args.AddParam("webserver", "", Orchestrator.Globals.Configuration.WebServer);
XmlUrlResolver resolver = new XmlUrlResolver();
XPathNavigator navigator = data.CreateNavigator();
// Populate the Point.
StringWriter sw = new StringWriter();
transformer.Transform(navigator, args, sw);
// Return the transformed xml to the client.
Response.Write(sw.GetStringBuilder().ToString());
Response.Flush();
Response.End();
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
PopulateRequest();
Facade.IDriverRequest facDriverRequest = new Facade.Resource();
bool success = false;
string userId = ((Entities.CustomPrincipal)Page.User).UserName;
if (m_isUpdate)
{
success = facDriverRequest.Update(m_request, userId);
}
else
{
m_request.RequestId = facDriverRequest.Create(m_request, userId);
success = m_request.RequestId > 0;
}
lblConfirmation.Text = "The request has " + (success ? "" : "not ") + "been " + (m_isUpdate ? "updated." : "added.");
lblConfirmation.Visible = true;
if (success)
{
ViewState[C_REQUEST_VS] = m_request;
cboDrivers.Enabled = false;
btnAdd.Text = "Update Request";
}
}
}
void cboDriver_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
Facade.IResource facResource = new Facade.Resource();
DataSet ds = facResource.GetAllResourcesFiltered(e.Text, eResourceType.Driver, false);
DataTable dt = ds.Tables[0];
DataTable boundResults = dt.Clone();
int itemsPerRequest = 20;
int itemOffset = e.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > ds.Tables[0].Rows.Count)
{
endOffset = ds.Tables[0].Rows.Count;
}
for (int i = itemOffset; i < endOffset; i++)
{
boundResults.ImportRow(dt.Rows[i]);
}
cboDriver.Items.Clear();
cboDriver.DataSource = boundResults;
cboDriver.DataBind();
if (boundResults.Rows.Count > 0)
{
e.Message = string.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), dt.Rows.Count.ToString());
}
}
private bool AddVehicleService()
{
int vehicleServiceId = 0;
bool retVal = false;
string userName = ((Entities.CustomPrincipal)Page.User).UserName;
Facade.IVehicleService facVehicleService = new Facade.Resource();
// Need to add a row in with the date of the date of the service.
Entities.VehicleService vehicleService = new Orchestrator.Entities.VehicleService();
vehicleService.vehicleServiceDueDate = Convert.ToDateTime(dteNewServiceDate.SelectedDate);
vehicleService.vehicleId = m_vehicleId;
vehicleServiceId = facVehicleService.Create(vehicleService, userName);
dteNewServiceDate.Text = string.Empty;
if (vehicleServiceId == 0)
{
lblConfirmation.Text = "There was an error adding the vehicle service, please try again.";
lblConfirmation.Visible = true;
lblConfirmation.ForeColor = Color.Red;
retVal = false;
}
else
{
// Store the new id in the viewstate
ViewState[C_VEHICLESERVICE_ID] = vehicleServiceId;
retVal = true;
}
PopulateVehicleService();
return(retVal);
}
private void LoadAuditHistory()
{
Facade.IResource facResource = new Facade.Resource();
DataSet ds = facResource.GetAuditDetailsForResourceId(m_resourceId);
dgAuditHistory.DataSource = ds;
dgAuditHistory.DataBind();
}
private void LoadData()
{
Orchestrator.WebUI.Security.Authorise.EnforceAuthorisation(eSystemPortion.GeneralUsage);
using (Facade.IDriver facDriver = new Facade.Resource())
dgDriversAwaitingInstruction.DataSource = facDriver.GetDriversAwaitingInstruction();
dgDriversAwaitingInstruction.DataBind();
}
/// <summary>
/// Data Set Get Vehicle Service Data
/// </summary
private DataSet GetVehicleServiceData()
{
Facade.IVehicleService facVehicleService = new Facade.Resource();
DataSet dsVehicleHistoryService = null;;
dsVehicleHistoryService = facVehicleService.GetVehicleServiceHistory(m_vehicleId);
return(dsVehicleHistoryService);
}
private void ResetDriverPasscode()
{
var userName = ((Entities.CustomPrincipal)Page.User).UserName;
IDriver facResource = new Facade.Resource();
_driver.Passcode = null;
facResource.Update(_driver, userName);
ViewState["driver"] = _driver;
}
/// <summary>
/// Button Add Click
/// </summary>
private void btnAdd_Click(object sender, System.EventArgs e)
{
if (Page.IsValid)
{
bool retVal = false;
if (_driver == null)
{
populateDriver();
}
if (_isUpdate)
{
retVal = UpdateDriver();
if (retVal)
{
lblConfirmation.Text = "The Driver has been updated successfully";
if (cboControlArea.SelectedValue != String.Empty && cboTrafficArea.SelectedValue != String.Empty)
{
using (Facade.IResource facResource = new Facade.Resource())
facResource.AssignToArea(Convert.ToInt32(cboControlArea.SelectedValue), Convert.ToInt32(cboTrafficArea.SelectedValue), _driver.ResourceId, "Driver has been updated", ((Entities.CustomPrincipal)Page.User).UserName);
}
this.ReturnValue = lblConfirmation.Text;
}
}
else
{
retVal = AddDriver();
if (retVal)
{
lblConfirmation.Text = "The Driver has been added successfully.";
if (cboControlArea.SelectedValue != String.Empty && cboTrafficArea.SelectedValue != String.Empty)
{
using (Facade.IResource facResource = new Facade.Resource())
facResource.AssignToArea(Convert.ToInt32(cboControlArea.SelectedValue), Convert.ToInt32(cboTrafficArea.SelectedValue), _driver.ResourceId, "Driver has been updated", ((Entities.CustomPrincipal)Page.User).UserName);
}
this.ReturnValue = lblConfirmation.Text;
}
}
lblConfirmation.Visible = true;
if (retVal)
{
this.ReturnValue = "success";
this.Close();
}
}
}
/// <summary>
/// Button Add_Click
/// </summary>
private void btnAdd_Click(object sender, System.EventArgs e)
{
if (Page.IsValid)
{
bool retVal = false;
lblConfirmation.Text = "";
lblConfirmation.Visible = true;
populateTrailer();
if (m_isUpdate)
{
retVal = UpdateTrailer();
}
else
{
retVal = AddTrailer();
}
if (retVal)
{
if (m_isUpdate)
{
lblConfirmation.Text = "The trailer has been updated successfully.";
}
else
{
lblConfirmation.Text = "The trailer has been added successfully.";
btnAdd.Text = "Update";
}
if (cboControlArea.SelectedValue != String.Empty && cboTrafficArea.SelectedValue != String.Empty)
{
using (Facade.IResource facResource = new Facade.Resource())
facResource.AssignToArea(Convert.ToInt32(cboControlArea.SelectedValue), Convert.ToInt32(cboTrafficArea.SelectedValue), trailer.ResourceId, "Trailer has been updated", ((Entities.CustomPrincipal)Page.User).UserName);
}
// refresh the page we came from if it is expecting a call back
this.ClientScript.RegisterStartupScript(this.GetType(), "CallBack", "__dialogCallBack(window, 'refresh');", true);
this.ReturnValue = lblConfirmation.Text;
this.Close();
}
else
{
if (string.IsNullOrWhiteSpace(lblConfirmation.Text))
{
lblConfirmation.Text = m_isUpdate ? "The trailer has not been updated successfully." : "The trailer has not been added successfully.";
}
this.ReturnValue = lblConfirmation.Text;
}
}
}
public RadComboBoxItemData[] GetVehicles(RadComboBoxContext context)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
// If the context contains a "TopItemText" key then add to a the top of the result list an item containing this text (for example "- all -" or "- select -")
// But only if the list is currently empty. If they have clicked the ShowMoreResultsBox arrow, we don't want to add another "- all -"
bool hasTopItemText = false;
var topItemText = context.ContainsKey("TopItemText") ? context["TopItemText"].ToString() : string.Empty;
hasTopItemText = !string.IsNullOrWhiteSpace(topItemText);
if (hasTopItemText && context.NumberOfItems == 0)
{
result.Add(new Telerik.Web.UI.RadComboBoxItemData {
Text = topItemText
});
}
string[] clientArgs = context["FilterString"].ToString().Split(':');
int depotID = int.Parse(clientArgs[0]);
var query = (context.ContainsKey("Text") && context.Text != topItemText) ? context.Text : string.Empty;
Facade.IResource facResource = new Facade.Resource();
DataSet ds = facResource.GetAllResourcesFiltered(query, eResourceType.Vehicle, depotID, false, true);
int itemsPerRequest = 20;
int itemOffset = context.NumberOfItems;
// If the list contains a Top Item (e.g. -All-) and the list is already populated (the ShowMoreResultsBox has been clicked), do not include the Top Item or the offset will skip a vehicle.
if (hasTopItemText && context.NumberOfItems > 0)
{
itemOffset--;
}
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > ds.Tables[0].Rows.Count)
{
endOffset = ds.Tables[0].Rows.Count;
}
DataTable dt = ds.Tables[0];
Telerik.Web.UI.RadComboBoxItemData rcItem = null;
for (int i = itemOffset; i < endOffset; i++)
{
rcItem = new Telerik.Web.UI.RadComboBoxItemData();
rcItem.Text = dt.Rows[i]["Description"].ToString();
rcItem.Value = dt.Rows[i]["ResourceId"].ToString();
result.Add(rcItem);
}
return(result.ToArray());
}
private DataView GetVehicleData()
{
Facade.IVehicle facVehicle = new Facade.Resource();
DataSet dataSet = facVehicle.GetAllWithGPS();
DataView retVal = dataSet.Tables[0].DefaultView;
// Get a list of the Vehicle Controllers from the dataset
if (this.VehicleControllers == null)
{
VehicleControllers = retVal.ToTable(true, "CurrentVehicleController");
}
// Do we need to apply any filter?
if (int.Parse(cboFilter.SelectedValue) > -1)
{
if (int.Parse(cboFilter.SelectedValue) == 0)
{
// Filter by GPS Status (Red, Amber, Green)
retVal.RowFilter = string.Format("GPSStatus = '{0}'", rblGPSStatus.SelectedValue);
}
if (int.Parse(cboFilter.SelectedValue) == 1)
{
// Fulter by GPS Mapping Status (has a device been mapped)
retVal.RowFilter = string.Format("GPSUnitID {0}", rblMappingStatus.SelectedValue == "0" ? "Is NULL OR GPSUnitID = ''" : "IS NOT NULL AND GPSUnitID <> ''");
}
if (int.Parse(cboFilter.SelectedValue) == 2)
{
// Filter by Vehicle Controller
retVal.RowFilter = string.Format("CurrentVehicleController= '{0}'", cboVehicleController.SelectedValue);
}
if (int.Parse(cboFilter.SelectedValue) == 3)
{
// Filter by Search
string search = txtSearch.Text;
if (search.StartsWith("T"))
{
search = search.Substring(1);
}
retVal.RowFilter = string.Format("RegNo= '{0}' OR GPSUnitID='{0}'", search);
}
// Set the record count
this.litVehicleCount.Text = string.Format("{0} of {1} Vehicles", retVal.Count, dataSet.Tables[0].Rows.Count);
}
else
{
// Set the record count
this.litVehicleCount.Text = retVal.Table.Rows.Count + " Vehicles";
}
return(retVal);
}
private void LoadVehicleKey()
{
Facade.IVehicleKey facVehicleKey = new Facade.Resource();
m_key = facVehicleKey.GetForVehicleKeyId(m_keyId);
ViewState[C_KEY] = m_key;
ddlKeyTypes.SelectedValue = Utilities.UnCamelCase(m_key.VehicleKeyType.ToString());
txtSerial.Text = m_key.Serial;
btnAdd.Text = "Update Vehicle Key";
}
protected void Page_Load(object sender, EventArgs e)
{
m_driverResourceId = Convert.ToInt32(Request.QueryString["resourceId"]);
if (!IsPostBack)
{
Facade.IDriver facDriver = new Facade.Resource();
lblDriverName.Text = facDriver.GetDriverForResourceId(m_driverResourceId).Individual.FullName;
txtTravelNotes.Text = facDriver.GetTravelNotes(m_driverResourceId);
}
}
private void BindResources()
{
using (Facade.IResource facResource = new Facade.Resource())
{
DataView dv = new DataView(facResource.GetDeletedResources().Tables[0]);
string sorting = SortCriteria + " " + SortDirection;
dv.Sort = sorting.Trim();
dgResources.DataSource = dv;
dgResources.DataBind();
}
}
