Hi Nadia…
Here is my code.I am still getting the same error.When the dropdown column is in editable mode it do not throw error.But it throws error only when we do not touch the dropdown column and update the value in any other column in the same row..It stores the text in variable " fromCC " in function "UpdateAllocation()" (mentioned below) which is a GUID and hence throws an exception.
Allocation.aspx
————————
function dgAllocation_CellEditing_ExitedEditMode(sender, eventArgs) {
var grid = $find("<%=dgAllocation.ClientID%>");
var gridBehaviors = grid.get_behaviors();
var row = gridBehaviors.get_selection().get_selectedRows().getItem(0);
var rowId = row.get_index();
abmAPI.updateAllocations(rowId,
eventArgs.getCell().get_row().get_cellByColumnKey("AL_ID").get_value(),
eventArgs.getCell().get_row().get_cellByColumnKey("MI_YEAR").get_value(),
eventArgs.getCell().get_row().get_cellByColumnKey("CC_NAME").get_value(),
eventArgs.getCell().get_row().get_cellByColumnKey("AL_ACCTTYPE").get_value(),
eventArgs.getCell().get_row().get_cellByColumnKey("AL_ACCTPATTERN").get_value(),
eventArgs.getCell().get_row().get_cellByColumnKey("AL_DESTPATTERN").get_value(),
eventArgs.getCell().get_row().get_cellByColumnKey("ST_NUM").get_value(),
eventArgs.getCell().get_row().get_cellByColumnKey("AL_TIMING").get_value() != null ? eventArgs.getCell().get_row().get_cellByColumnKey("AL_TIMING").get_value() : "1",
updateAllocationsHandler);
}
<Behaviors>
<ig:EditingCore AutoCRUD="False" BatchUpdating="True">
<Behaviors>
<ig:CellEditing>
<ColumnSettings>
<ig:EditingColumnSetting ColumnKey="Notes" ReadOnly="True" />
<ig:EditingColumnSetting ColumnKey="MI_YEAR" ReadOnly="True" />
<ig:EditingColumnSetting ColumnKey="CC_ID" ReadOnly="True" />
<ig:EditingColumnSetting ColumnKey="CC_NAME" ReadOnly="False" EditorID="FromCCProvider" />
<ig:EditingColumnSetting ColumnKey="AL_ACCTTYPE" ReadOnly="False" EditorID="FromTypeProvider" />
<ig:EditingColumnSetting ColumnKey="AL_ACCTPATTERN" ReadOnly="False" />
<ig:EditingColumnSetting ColumnKey="AL_DESTPATTERN" ReadOnly="False" />
<ig:EditingColumnSetting ColumnKey="AL_ALLOCTYPE" ReadOnly="False" />
<ig:EditingColumnSetting ColumnKey="ST_NUM" ReadOnly="False" EditorID="AllocationTypeProvider" ValidatorID="RequiredFieldValidator1" />
<ig:EditingColumnSetting ColumnKey="MI_ID" ReadOnly="False" />
<ig:EditingColumnSetting ColumnKey="NUM_NOTES" ReadOnly="False" />
<ig:EditingColumnSetting ColumnKey="AL_TIMING" ReadOnly="False" />
</ColumnSettings>
<CellEditingClientEvents ExitedEditMode="dgAllocation_CellEditing_ExitedEditMode" />
<EditModeActions EnableOnKeyPress="True" MouseClick="Single" />
<EditModeActions MouseClick="Single" EnableOnKeyPress="True"></EditModeActions>
</ig:CellEditing>
<ig:RowAdding Alignment="Top" EditModeActions-EnableF2="true" EditModeActions-EnableOnActive="true"
EditModeActions-MouseClick="Single" Enabled="true">
<ColumnSettings>
<ig:RowAddingColumnSetting ColumnKey="Notes" ReadOnly="True" />
<ig:RowAddingColumnSetting ColumnKey="MI_YEAR" ReadOnly="True" />
<ig:RowAddingColumnSetting ColumnKey="CC_ID" ReadOnly="True" />
<ig:RowAddingColumnSetting ColumnKey="CC_NAME" ReadOnly="False" EditorID="FromCCProvider" />
<ig:RowAddingColumnSetting ColumnKey="AL_ACCTTYPE" ReadOnly="False" EditorID="FromTypeProvider" />
<ig:RowAddingColumnSetting ColumnKey="AL_ACCTPATTERN" ReadOnly="False" />
<ig:RowAddingColumnSetting ColumnKey="AL_DESTPATTERN" ReadOnly="False" />
<ig:RowAddingColumnSetting ColumnKey="AL_ALLOCTYPE" ReadOnly="False" />
<ig:RowAddingColumnSetting ColumnKey="ST_NUM" ReadOnly="False" EditorID="AllocationTypeProvider" />
<ig:RowAddingColumnSetting ColumnKey="MI_ID" ReadOnly="False" />
<ig:RowAddingColumnSetting ColumnKey="NUM_NOTES" ReadOnly="False" />
<ig:RowAddingColumnSetting ColumnKey="AL_TIMING" ReadOnly="False" />
</ColumnSettings>
<AddNewRowClientEvents ExitedEditMode="dgAllocation_CellEditing_ExitedEditMode" />
</ig:RowAdding>
<ig:RowDeleting Enabled="true" />
</Behaviors>
</ig:EditingCore>
<ig:Activation>
</ig:Activation>
<ig:Selection CellClickAction="Row" RowSelectType="Single">
</ig:Selection>
<ig:RowSelectors>
</ig:RowSelectors>
</Behaviors>
Function to Update and Insert(allocid is primary key)
—————————————————–
private void updateAllocation()
{
string output = "";
try
{
string rowId = Request.Form["rowId"].ToString();
int year = int.Parse(Request.Form["year"].ToString());
Guid fromCC = new Guid(Request.Form["fromCC"].ToString());
string fromType = Request.Form["fromType"];
string fromAccount = Request.Form["fromAccount"];
string destinationCC = Request.Form["destinationCC"];
string strAllocType = Request.Form["allocType"].ToString();
Guid allocType;
string allocId = Request.Form["allocId"].ToString();
Guid AL_ID;
Guid MI_ID = new Guid();
double al_timing = double.Parse(Request.Form["al_timing"].ToString());
if (strAllocType.Trim() == "FTE" || strAllocType.Trim() == "null")
allocType = new Guid();
else
allocType = new Guid(strAllocType);
foreach (ModelInstance mi in currentMM.ModelInstances)
{
if (mi.modelInstanceYear == year)
{
MI_ID = mi.modelInstanceID;
}
}
AllocationsService svc = new AllocationsService();
if (allocId == "null")
{
AL_ID = svc.insertAllocation(MI_ID, fromCC, fromType, fromAccount, destinationCC, allocType, al_timing, loggedInUserID);
output = rowId + "&&" + AL_ID.ToString();
}
else
{
AL_ID = new Guid(allocId);
svc.updateAllocation(AL_ID, MI_ID, fromCC, fromType, fromAccount, destinationCC, allocType, al_timing, loggedInUserID);
output = "VALID";
}
}
catch
{
output = "INVALID";
}
finally
{
Response.Clear();
Response.Write(output);
Response.End();
}
}
lB_2_9
deewakar kumar
