protected void rgGrid_InsertCommand(object sender, GridCommandEventArgs e) { try { UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); Label errorMsg = (Label)userControl.FindControl("lblErrorMessage"); ClsRequestType oRow = populateObj(userControl); string insertMsg = ""; if (IsValid) { if (oRow != null) { insertMsg = cls.InsertRequestType(oRow); if (insertMsg == "") { pnlsuccess.Visible = true; lblSuccess.Text = "Successfully Added New Record " + oRow.RequestType; } else { errorMsg.Visible = true; errorMsg.Text = insertMsg; e.Canceled = true; } } } else { // display error errorMsg.Visible = true; errorMsg.Text = "Please enter Required fields"; e.Canceled = true; } } catch (Exception ex) { pnlDanger.Visible = true; lblDanger.Text = ex.Message.ToString(); e.Canceled = true; } }
public string UpdateRequestType(ClsRequestType data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idRequestType > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblRequestType>() where qdata.idRequestType == data.idRequestType select qdata; // Execute the query, and change the column values // you want to change. foreach (tblRequestType updRow in query) { updRow.RequestType = data.RequestType; updRow.ActiveFlag = data.ActiveFlag; updRow.idRequestType = data.idRequestType; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Request Type with ID = " + "'" + data.idRequestType + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }