Grid Edit Popup - Set UpdateBy UpdateDate Values

[Mick Suskovich]

I have a Rad Grid with 
    <MasterTableView EditMode="PopUp"

 

 

 

    <EditFormSettings EditFormType="Template" CaptionFormatString="Entity Properties..." PopUpSettings-Modal="true" >

 

 

 

Using an Object DataSource

 

 

<asp:ObjectDataSource ID="EntityObjectDataSource" runat="server"

 

 

DataObjectTypeName="Namespace.Entities.Enity"

 

 

DeleteMethod="Delete" InsertMethod="Insert" SelectMethod="GetAll"

 

 

TypeName="Namespace.BusinessServices.EntityServices.EntityController"

 

 

UpdateMethod="Update" OldValuesParameterFormatString="original_{0}">

 

 

 

</asp:ObjectDataSource>

 

 

 

I used netTiers to gen service/Entity/ and data access - I have an abstraction layer (controllers) wrapping the net tiers services.

Amongst the controls, I have two text boxes UpdateByTextBox and UpdateDateText Box,
I would like to set these values once the user clicks the 'Save' command button.

(I was able to figure out how to set my CreateByTextBox and CreateDateTextBox by using the following
protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)

 

{

 

    if

 

(e.CommandName == RadGrid.InitInsertCommandName)

 

    {

 

        //cancel the default operation

 

        e.Canceled =

true;

 

 

        //Prepare an IDictionary with the predefined values

 

        System.Collections.Specialized.

ListDictionary newValues = new System.Collections.Specialized.ListDictionary() ;

 

 

        //set default value(s)        

 

        newValues[

"CreateBy"] = m_CurrentUserIdentityName; // initialized in page constructor

 

        newValues[

"CreateDate"] = DateTime.Now.ToString();

 

 

        //Insert the item and rebind

 

 

 

        e.Item.OwnerTableView.InsertItem(newValues);

 

    }

Any suggestions/questions or help is greatly appreciated...

[Veli]

Hello Mick,

Similarly with the InitInsert command, when the Save button is pressed in RadGrid's edit form, the ItemCommand event is fired with command name PerformInsert. This is the place where you can reference your custom controls and their values:

void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.PerformInsertCommandName)
    {
        GridEditFormInsertItem item = e.Item as GridEditFormInsertItem;
        //item.FindControl() can be used to retrieve control by ID
    }
}

Best wishes,
Veli
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Mick Suskovich]

Thank you for you reply - it lead me to where I needed to be --> here is a sample of my functioning code - for adding the audit user during and edit/update operation...

if (e.CommandName == RadGrid.UpdateCommandName)
            {

                GridEditFormItem _GridEditFormItem = e.Item as GridEditFormItem;

                TextBox _TextBox =  _GridEditFormItem.FindControl("UpdateByTextBox") as TextBox;

                if (_TextBox != null)
                    _TextBox.Text = m_CurrentUserIdentityName;

            }

[Emad]

Hi,

I have the same problem, I tried Mick code but it gives me error "NullReference unhanded by user code"
Note "CREATED_BY" is GridBoundColumn because i use automatic insert/update/delete operations.

please advice...




C#

protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)

{


if (e.CommandName == RadGrid.InitInsertCommandName)

{

GridEditFormItem item = e.Item as GridEditFormItem;

TextBox tBox = new TextBox();

tBox = item.FindControl("CREATED_BY") as TextBox;

if (tBox != null)

tBox.Text = "emad"; 

}   

}

Thanks
Emad

[Veli]

Try the following code instead:

protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.InitInsertCommandName)
    {
        GridEditFormItem item = e.Item as GridEditFormItem;
        TextBox tBox = item["CREATED_BY"].Controls[0] as TextBox;
        if (tBox != null)
            tBox.Text = "emad";
    }
}

Veli
the Telerik team

[Emad]

Hello Veli,

unfortunately, it's not working..

TextBox tBox = item["CREATED_BY"].Controls[0] as TextBox;
this line raise error null reference exception.
item name is correct.


Please advice.

Thanks,
Emad

[Emad]

Thanks, I found the solution

add the below code and onUdating data source call this code


C#

protected void EntityDataSource1_Updating(object sender, EntityDataSourceChangingEventArgs e)
    {
       Organization org = (Organization)e.Entity;
       org.UpdateBy = "[UserID]";
    }

Regards,
Emad