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());
}
public RadComboBoxItemData[] GetClients(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 -")
var topItemText = context.ContainsKey("TopItemText") ? context["TopItemText"].ToString() : string.Empty;
if (!string.IsNullOrWhiteSpace(topItemText))
{
result.Add(new Telerik.Web.UI.RadComboBoxItemData {
Text = topItemText
});
}
bool includeSuspended = false;
if (context.ContainsKey("DisplaySuspended"))
{
includeSuspended = context["DisplaySuspended"] == null ? false : context["DisplaySuspended"].ToString() == "False" ? false : true;
}
var query = (context.ContainsKey("Text") && context.Text != topItemText) ? context.Text : string.Empty;
Orchestrator.Facade.IReferenceData facRefData = new Orchestrator.Facade.ReferenceData();
DataSet ds = facRefData.GetAllClientsFiltered(query, includeSuspended);
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]["OrganisationName"].ToString();
rcItem.Value = dt.Rows[i]["IdentityId"].ToString();
result.Add(rcItem);
}
return(result.ToArray());
}
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 RadComboBoxData GetEmployeeList(RadComboBoxContext context)
{
RadComboBoxData comboData = new RadComboBoxData();
try
{
string keyword = context.Text;
int pageFrom = context.NumberOfItems;
int pageSize = 10;
int?departmentId = null;
if (context.ContainsKey("DepartmentId") && context["DepartmentId"] != null)
{
departmentId = Convert.ToInt32(context["DepartmentId"]);
}
var employees = EmployeeManager.GetEmployees(pageFrom, pageSize, departmentId, context.Text, null, true);
if (employees != null)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
foreach (var item in employees)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = item.EmployeeName;
itemData.Value = Convert.ToString(item.EmployeeId);
result.Add(itemData);
}
int totalCount = employees[0].TotalCount;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + totalCount;
comboData.EndOfItems = totalCount < pageSize;
//comboData.Message = GetStatusMessagecustom(endOffset);
comboData.Items = result.ToArray();
}
return(comboData);
}
catch (Exception ex)
{
return(comboData);
}
}