This is a migrated thread and some comments may be shown as answers.

[Solved] How to Keep Insert Form Open after commanditem event is used in RadGrid

3 Answers 347 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Chi Ming asked on 14 Jun 2013, 02:11 PM

Hello everyone!

Tell me how to keep Insert Form Open after the commanditem event is used - check if username is not in the database so insert a new user in the database and close the form. Check If username is already in the database so keep the insert form open and change new username in the insert form.

The InsertNewUser method is called in the CommandItem Event.

private void InsertNewUser(GridItem gridItem)

{

//initizlize new object of User System

User UserBLL = new User();

//initizlize new setUser of User Info Model

UserInfo setUserInfo = new UserInfo();

//initizlize new object of PO User System Info

POUserSystemInfo POUserSysBLL = new POUserSystemInfo();

//initizlize new object of PO User Attribute Model

POInfo setPOUserInfo = new POInfo();

UserControl userControl = (UserControl)gridItem.FindControl(GridEditFormItem.EditFormUserControlID);

RadTextBox txtfirstname = (userControl.FindControl("txtfirstname") as RadTextBox);

RadTextBox txtlastname = (userControl.FindControl("txtlastname") as RadTextBox);

RadTextBox txtusername = (userControl.FindControl("txtusername") as RadTextBox);

RadTextBox txtemail = (userControl.FindControl("txtemail") as RadTextBox);

RadMaskedTextBox txtPhone = (userControl.FindControl("txtPhone") as RadMaskedTextBox);

RadMaskedTextBox txtExtension = (userControl.FindControl("txtExtension") as RadMaskedTextBox);

RadMaskedTextBox txtfax = (userControl.FindControl("txtfax") as RadMaskedTextBox);

RadTextBox txtjobtitle = (userControl.FindControl("txtjobtitle") as RadTextBox);

RadTabStrip RadTabStrip1 = (userControl.FindControl("RadTabStrip1") as RadTabStrip);

RadPageView RadPageView2 = (userControl.FindControl("RadPageView2") as RadPageView);

setUserInfo.user_id = 0;

setUserInfo.firstname = txtfirstname.Text;

setUserInfo.lastname = txtlastname.Text;

setUserInfo.sys_username = txtusername.Text;

setUserInfo.jobtitle = txtjobtitle.Text;

setUserInfo.designation = ' ';

setUserInfo.phone = txtPhone.Text;

setUserInfo.fax = txtfax.Text;

setUserInfo.email = txtemail.Text;

setUserInfo.update_date = DateTime.Now;

setUserInfo.removed = false;

setUserInfo.extension = txtExtension.Text;

setUserInfo.update_date = DateTime.Now;

setUserInfo.removed = false;

setUserInfo.extension = txtExtension.Text;

setUserInfo.update_by = 0;

//Check if Username is not in the database.

if (UserBLL.GetUser(txtusername.Text.Trim()) == null)

{

//Insert New Record to the table in the database

int NewUserID = 0;

NewUserID = UserBLL.RegisterUser(setUserInfo);

if (NewUserID > 0)

{

//Clear ViewState and Refresh RadGrid Control

ViewState["Users"] = null;

rgUsersMain.Rebind();

gridItem.OwnerTableView.IsItemInserted = false;

Edit = true;

EditItemIndex = rgUsersMain.Items.Count - 1;

Session["IsNewUser"] = true;

Session["rgNewUserID"] = NewUserID;

}

else

{

//Keep Insert Form Open

GridEditableItem edititem = (GridEditableItem)gridItem;

gridItem.OwnerTableView.IsItemInserted = true;

rgUsersMain.MasterTableView.InsertItem();

//rgUsersMain.Rebind();

RadWindowManager1.RadAlert("User Already Exists", 330, 180, "Server RadAlert", "", "");

}

//Clear ViewState and Refresh RadGrid Control

ViewState["Users"] = null;

rgUsersMain.Rebind();

gridItem.OwnerTableView.IsItemInserted = false;

Edit = true;

EditItemIndex = rgUsersMain.Items.Count - 1;

Session["IsNewUser"] = true;

Session["rgNewUserID"] = NewUserID;

}

else

{

//Keep Insert Form Open

GridEditableItem edititem = (GridEditableItem)gridItem;

gridItem.OwnerTableView.IsItemInserted = true;

rgUsersMain.MasterTableView.InsertItem();

//rgUsersMain.Rebind();

RadWindowManager1.RadAlert("User Already Exists", 330, 180, "Server RadAlert", "", "");

}

3 Answers, 1 is accepted

answered on 19 Jun 2013, 07:42 AM

Hi Chi Ming,

Could you please let me know where InsertNewUser method is being called? Basically you could check whether the user is already inserted and cancel the command and show an alert message. This way the insert form will remain opened. Check out the following code snippet.

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

{

if (e.CommandName == RadGrid.PerformInsertCommandName)

{

//check whether the user exist

if (userExist)

{

e.Canceled = true;

//show alert message

}

else

{

//proceed with inserting the new user.

}

Kostadin
Telerik

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.

answered on 19 Jun 2013, 02:47 PM

The InsertNewUser Method is being called in the if-conditional statement in the item-command event. Thank you for sending me information.

I need to ask you other question regarding edit form.

Once it inserted a new user to the database, How does it change insert to edit in mode? I need to keep the EDIT form open even if new user is inserted into the database

1. Once "Add New User" button is selected in the web user control, it calls InsertNewuser() method and update a new user to the database. Once it is completed, it needs to change the insert to edit in the mode and keep the form open.

protected void rgUsersMain_ItemCommand(object sender, GridCommandEventArgs e)

{

if (e.CommandName.Equals(RadGrid.PerformInsertCommandName))

{

try

{

InsertNewUser(e.Item);

e.Canceled = true;

}

catch (Exception ex)

{

Logging.WriteLogToFile("Add New User", ex);

Label lblError = new Label();

lblError.Text = "Unable to insert new user. Reason: " + ex.Message;

lblError.ForeColor = System.Drawing.Color.Red;

rgUsersMain.Controls.Add(lblError);

}

else if (e.CommandName.Equals(RadGrid.UpdateCommandName))

{

try

{

UpdateUser(e.Item);

e.Canceled = true;

}

catch (Exception ex)

{

Logging.WriteLogToFile("Update User", ex);

Label lblError = new Label();

lblError.Text = "Unable to update user. Reason: " + ex.Message;

lblError.ForeColor = System.Drawing.Color.Red;

rgUsersMain.Controls.Add(lblError);

}

else if (e.CommandName.Equals(RadGrid.DeleteCommandName))

{

try

{

DeleteUser(e.Item);

}

catch (Exception ex)

{

Logging.WriteLogToFile("Delete User", ex);

Label lblError = new Label();

lblError.Text = "Unable to delete user. Reason: " + ex.Message;

lblError.ForeColor = System.Drawing.Color.Red;

rgUsersMain.Controls.Add(lblError);

}

else if (e.CommandName.Equals(RadGrid.CancelCommandName))

{

Session["CurrentRoleLocations"] = null;

Session["rgUserID"] = null;

ViewState["Users"] = null;

rgUsersMain.Rebind();

}

2. Calling the InsertNewUser Method

private void InsertNewUser(GridItem gridItem)

{

//initizlize new object of User System

User UserBLL = new User();

//initizlize new setUser of User Info Model

UserInfo setUserInfo = new UserInfo();

//initizlize new object of PO User System Info

POUserSystemInfo POUserSysBLL = new POUserSystemInfo();

//initizlize new object of PO User Attribute Model

POInfo setPOUserInfo = new POInfo();

DataTable dt = new DataTable();

dt = (DataTable)ViewState["Users"];

//Create new row in the DataSource

DataRow newRow = this.Users.NewRow();

//Insert new values

Hashtable newValues = new Hashtable();