Ultrawebgrid and ValueList | Infragistics Forums

OK, then, here goes the aspx first:

var celldescid;
function grdTimeSheet_AfterCellUpdateHandler(gridName, cellId) {
var totalStaticColumns = 7; // HARDCODED PROVISION
var cell1 = igtbl_getCellById(cellId);
var cellIndex = cell1.Column.Index;
var totalNonChargeableRows = document.getElementById('<%=hdnRowCount.ClientID%>').value;
var totalStaticRows = parseFloat(totalNonChargeableRows) + 3;
var NonUpdatableRowsFromEnd = 2;
var Customer_ID_ColumnIndex = 3;
var Customer_name_ColumnIndex = 2;
var TypeOfWorkColumnIndex = 5;
celldescid = cellId;

if (cellIndex >= totalStaticColumns)// HARDCODED PROVISION
{

var grid1 = igtbl_getGridById(gridName);
var cell1 = igtbl_getCellById(cellId);
var cellIndex = cell1.Column.Index;
var RowsCounter = grid1.Rows.length;

//Update the Work Subcategories based on the Work Category selected

if (cellIndex == TypeOfWorkColumnIndex) {

var grid1 = igtbl_getGridById(gridName);
var cell1 = igtbl_getCellById(cellId);
var selectedValue = cell1.getValue();
PageMethods.Populate_Work_SubType_DropDownList(selectedValue, OnCallWorkSubTypeComplete, OnCallWorkSubTypeTimeOut, OnCallWorkSubTypeError);
}
}

// Callback function on complete
function OnCallWorkSubTypeComplete(result) {
var workSubTypeColumnIndex = 6;
var ddlArrayContainer;
var ddlArrayItem;
if (celldescid != null)
{
//alert('celldescid is not null');
var rowid = window.igtbl_getRowById(celldescid);
if (rowid != null) {
var cell = rowid.getCell(workSubTypeColumnIndex);
if (result.length > 0)
{
ddlArrayContainer = new Array(result.length);
for (var iterator = 0; iterator < result.length; iterator++)
{
ddlArrayItem = new Array(result[iterator].Name,result[iterator].Name);
ddlArrayContainer[iterator] = ddlArrayItem;
}
cell.Column.ValueList = ddlArrayContainer;
//Set by default the selected value to the first value of the array
cell.setValue(ddlArrayContainer[0]);
}
else
{
cell.setValue('');
cell.Column.ValueList = null;
}
}
}
}

function OnCallWorkSubTypeTimeOut(arg) {
alert("TimeOut encountered when loading Description" & arg.toString());
}

function OnCallWorkSubTypeError(arg) {
alert("Error encountered when loading Description");
}

function BeforeEnterEditMode(tableName, cellName) {
celldescid = cellName;
var cellColumn = window.igtbl_getColumnById(cellName);
if (cellColumn.Key != "Description")
return;

var rowId = window.igtbl_getRowById(cellName);
var typeOfWorkCell = rowId.getCell(5);
var selectedTypeOfWork = typeOfWorkCell.getValue();
window.PageMethods.Populate_Work_SubType_DropDownList(selectedTypeOfWork, OnCallWorkSubTypeComplete, OnCallWorkSubTypeTimeOut, OnCallWorkSubTypeError);
}

Now with the code behind file, first the declaration of the categories dropdown, followed by the web method to fetch the subcategories:

Page_Load:

{

Populate_TypeOfWork_GridDropDown();

PopulateWorkDescriptionGridDropDown();

}

private void Populate_TypeOfWork_GridDropDown()
{
try
{
DataTable workTypesTable = new DataTable();
workTypesTable.Columns.Add("Work_Id");
workTypesTable.Columns.Add("Work_Description");

List<ASPNET.StarterKit.BusinessLogicLayer.Task> WorkTypesList = ASPNET.StarterKit.BusinessLogicLayer.Task.GetAllTasks();
//CH: The following can also be implemented as a foreach loop...
for (int i = 0; i < WorkTypesList.Count; i++)
{
ASPNET.StarterKit.BusinessLogicLayer.Task workType = WorkTypesList[i];
bool isChargeableTask = workType.Charge;
if (isChargeableTask)
{
DataRow row = workTypesTable.NewRow();
row["Work_Id"] = workType.TaskID;
row["Work_Description"] = workType.Description;
workTypesTable.Rows.Add(row);
}
}

ValueList workTypes = grdTimeSheet.DisplayLayout.Bands[0].Columns[TypeOfWorkColumnIndex].ValueList;
workTypes.DataSource = workTypesTable;
workTypes.ValueMember = "Work_Id";
workTypes.DisplayMember = "Work_Description";
workTypes.DataBind();
grdTimeSheet.DisplayLayout.Bands[0].Columns[TypeOfWorkColumnIndex].Type = ColumnType.DropDownList;
grdTimeSheet.DisplayLayout.Bands[0].Columns[TypeOfWorkColumnIndex].ValueList = workTypes;
}
catch (Exception ex)
{
Log.updateLog("Error####:" + ex.ToString());
}
}

[System.Web.Services.WebMethod]
public static List<WorkSubTask> Populate_Work_SubType_DropDownList(int taskId)
{
var listwst = new List<WorkSubTask>();
try
{
var subTaskList = SubTask.GetSubTasks(taskId);
for (var i = 0; i < subTaskList.Count; i++)
{
var subtask = subTaskList[i];
var objwst = new WorkSubTask(subtask.Id, subtask.Description);
listwst.Add(objwst);
}
return (listwst);
}
catch (Exception ex)
{
Log.updateLog("Error####:" + ex);
return null;
}
}

private void PopulateWorkDescriptionGridDropDown()
{

var workDescriptionsTable=new DataTable();
workDescriptionsTable.Columns.Add(new DataColumn("Id", typeof (string)));
workDescriptionsTable.Columns.Add(new DataColumn("Description", typeof(string)));
//Populate the subtasks tabe
var workDescriptionsList = SubTask.GetAllSubTasks();
foreach (var subTask in workDescriptionsList)
{
var newRow = workDescriptionsTable.NewRow();
newRow["Id"] = subTask.Id;
newRow["Description"] = subTask.Description;
workDescriptionsTable.Rows.Add(newRow);
}

var workDescriptions = grdTimeSheet.DisplayLayout.Bands[0].Columns[SubTypeOfWorkIndex].ValueList;
workDescriptions.ValueMember = "Id";
workDescriptions.DisplayMember = "Description";
workDescriptions.DataBind();

grdTimeSheet.DisplayLayout.Bands[0].Columns[SubTypeOfWorkIndex].Type = ColumnType.DropDownList;
grdTimeSheet.DisplayLayout.Bands[0].Columns[SubTypeOfWorkIndex].ValueList = workDescriptions;
}

As you can see from the above the following things should be happening:

1. On Page_Load, both value lists (the category and subcategory) are populated.

2. Whenever in the page we have an update of the category field, the subcategory valuelist dropdown is created and populated (by calling the web method above) and its value is set to the first item of the list. (This is wrong, we would prefer have it assume the already selected item).

3. In the BeforeEnterEditMode event, we try to again create and populate the valuelist for the subcategory based on the selected value in the category valuelist.

When executed, and the grid is loaded, the first time we click on the subcategory value list, expecting to get a dropdown, we get no drop-down; only the selected value is highlighted instead. By moving to another cell and then returning back to the sub-category we have the dropdown appear and getting the first value in the list. (we would prefer having selected the value already selected).

I hope all these help you and don't confuse you too much.