protected void gvMain_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e) { ASPxGridView gv = sender as ASPxGridView; gv.SettingsText.PopupEditFormCaption = "Edit Form - Ticket # " + e.EditingKeyValue.ToString(); SetMandatory(); Session["Init"] = "0"; //If user is manager, it can edit all records, otherwise only your own ticket string sql = "SELECT IsManager from aspnet_Users WHERE UserName = @UserName"; List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "UserName", SqlDbType = SqlDbType.NVarChar, Value = User.Identity.Name } }; bool IsManager = bool.Parse(DataBase.GetDT(sp, sql, "ApplicationServices").Rows[0][0].ToString()); bool IsOwner = false; if (User.Identity.Name == gv.GetRowValuesByKeyValue(e.EditingKeyValue, "UserName").ToString()) { IsOwner = true; } if (!IsManager && !IsOwner) { gvMain.JSProperties["cpMessage"] = "You may only edit tickets that you have created. Managers can edit any ticket -- if you feel you need to be assigned as Manager, please send a request to your administrator."; e.Cancel = true; gvMain.CancelEdit(); } }
protected override void PrepareControlHierarchy() { base.PrepareControlHierarchy(); if (!Page.IsCallback) { gdvDataList.DataBind(); object obj = null; if (SelectedValueID > 0) { obj = gdvDataList.GetRowValuesByKeyValue(SelectedValueID, "Code", "Name"); } if (obj != null) { object[] objs = (object[])obj; hddData.Set(HKEY_ID, SelectedValueID); bteTextInput.Text = objs[0].ToString(); hddData.Set(HKEY_TXTINPUT, bteTextInput.Text); lblName.Text = objs[1].ToString(); } else { hddData.Set(HKEY_ID, 0); hddData.Set(HKEY_TXTINPUT, string.Empty); bteTextInput.Text = string.Empty; lblName.Text = string.Empty; } } }
protected override void PrepareControlHierarchy() { base.PrepareControlHierarchy(); if (!IsCallback) { gdvMFCustomers.DataBind(); object obj = null; if (SelectedMFCustomerID > 0) { obj = gdvMFCustomers.GetRowValuesByKeyValue(SelectedMFCustomerID, "CustomerNO", "CustomerName"); } if (obj != null) { object[] objs = (object[])obj; hddMFCustomers.Set(HKEY_ID, SelectedMFCustomerID); bteMFCustomers.Text = objs[0].ToString(); hddMFCustomers.Set(HKEY_NO, bteMFCustomers.Text); lblCustomerName.Text = objs[1].ToString(); } else { hddMFCustomers.Set(HKEY_ID, 0); hddMFCustomers.Set(HKEY_NO, string.Empty); bteMFCustomers.Text = string.Empty; lblCustomerName.Text = string.Empty; } } }
protected void ASPxGridView1_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; DataType dataType = (DataType)grid.GetRowValuesByKeyValue(e.Keys[0], "Type"); string editorID = string.Empty; switch (dataType) { case DataType.Text: editorID = "txt"; break; case DataType.DateTime: editorID = "date"; break; case DataType.Dictionary1: editorID = "dict"; break; case DataType.Dictionary2: editorID = "dict"; break; } ASPxEdit editor = (ASPxEdit)grid.FindEditFormTemplateControl(editorID); e.NewValues["DataValue"] = editor.Value.ToString(); }
/// <summary> /// fires when edit row get current value of combobox and populate on combobox databound or we will lose initial text /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void dxgridTitles_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e) { ASPxGridView _grid = (ASPxGridView)sender; string[] _fields = { "Title" }; string _title = _grid.GetRowValuesByKeyValue(e.EditingKeyValue, _fields).ToString(); Session["Title"] = _title; }
public void DeleteFile(ASPxGridView gv, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try{ string path = gv.GetRowValuesByKeyValue(e.Keys[0], "Path").ToString(); File.Delete(Server.MapPath(path)); } catch (Exception) { } }
protected void grdModifier_RowCommand(object sender, ASPxGridViewRowCommandEventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { if (e.CommandArgs.CommandName == "select") { ASPxGridView grid = (ASPxGridView)sender; object id_ = e.KeyValue; txtModifier.Text = grid.GetRowValuesByKeyValue(id_, "sz_modifier").ToString(); txtIDCode.Text = grid.GetRowValuesByKeyValue(id_, "sz_code").ToString(); txtModifierDesc.Text = grid.GetRowValuesByKeyValue(id_, "sz_modifier_desc").ToString(); txtSelectedModifierID.Text = grid.GetRowValuesByKeyValue(id_, "i_modifier_id").ToString(); btnAdd.Enabled = false; btnUpdate.Enabled = true; } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void Detail_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { DataTable dt = new DataTable(); ASPxGridView EffectGrid = (ASPxGridView)sender; foreach (var args in e.UpdateValues) { string OBID = args.Keys[0].ToString();// leftrel string tag_no = args.NewValues[3].ToString(); string right_rel = EffectGrid.GetRowValuesByKeyValue(OBID, "RIGHTREL").ToString(); string qry = " UPDATE TBLSYSTEM_TAGNO SET TAGNO = '" + tag_no + "' "; qry = qry + " WHERE LEFTREL = '" + OBID + "' AND RIGHTREL = '" + right_rel + "' "; SqlCommand cmd; cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn); cmd.ExecuteNonQuery(); } }
protected void gvProducts_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e) { ASPxGridView gridView = sender as ASPxGridView; string[] parameters = e.Parameters.Split('|'); string command = parameters[0]; if (command == "MOVEUP" || command == "MOVEDOWN") { int focusedRowKey = GetGridViewKeyByVisibleIndex(gridView, gridView.FocusedRowIndex); int index = (int)gridView.GetRowValues(gridView.FocusedRowIndex, "DisplayOrder"); int newIndex = index; if (command == "MOVEUP") { newIndex = (index == 0) ? index : index - 1; } if (command == "MOVEDOWN") { newIndex = (index == gridView.VisibleRowCount) ? index : index + 1; } int rowKey = GetKeyIDBySortIndex(gridView, newIndex); UpdateSortIndex(focusedRowKey, newIndex); UpdateSortIndex(rowKey, index); gridView.FocusedRowIndex = gridView.FindVisibleIndexByKeyValue(rowKey); } if (command == "DRAGROW") { int draggingIndex = int.Parse(parameters[1]); int targetIndex = int.Parse(parameters[2]); int draggingRowKey = GetKeyIDBySortIndex(gridView, draggingIndex); int targetRowKey = GetKeyIDBySortIndex(gridView, targetIndex); int draggingDirection = (targetIndex < draggingIndex) ? 1 : -1; for (int rowIndex = 0; rowIndex < gridView.VisibleRowCount; rowIndex++) { int rowKey = GetGridViewKeyByVisibleIndex(gridView, rowIndex); int index = (int)gridView.GetRowValuesByKeyValue(rowKey, "DisplayOrder"); if ((index > Math.Min(targetIndex, draggingIndex)) && (index < Math.Max(targetIndex, draggingIndex))) { UpdateSortIndex(rowKey, index + draggingDirection); } } UpdateSortIndex(draggingRowKey, targetIndex); UpdateSortIndex(targetRowKey, targetIndex + draggingDirection); } gridView.DataBind(); }
protected void ASPxGridViewDemo_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e) { if (e.Column != null && e.Column.FieldName == "Type") { ASPxComboBox comboBox = (ASPxComboBox)e.Editor; ASPxGridView gridView = (ASPxGridView)sender; IssueType issueType = (IssueType)gridView.GetRowValuesByKeyValue(e.KeyValue, "IssueTypeName"); /*var filterValues = from issue in Issues * where issue.Type == issueType * select issue;*/ var filterValues = Issues.Where(issue => issue.Type == issueType); comboBox.DataSource = filterValues; comboBox.DataBindItems(); } }
protected void InitializeCombo(ASPxGridViewEditorEventArgs e, string parentComboName, SqlDataSource source, CallbackEventHandlerBase callBackHandler, ASPxGridView grid) { string id = string.Empty; if (!grid.IsNewRowEditing) { object val = grid.GetRowValuesByKeyValue(e.KeyValue, parentComboName); id = (val == null || val == DBNull.Value) ? null : val.ToString(); } ASPxComboBox combo = e.Editor as ASPxComboBox; if (combo != null) { // unbind combo combo.DataSourceID = null; FillMenuHijoCombo(combo, id, source); combo.Callback += callBackHandler; } return; }
protected void grdDetailEntry_HtmlDataCellPrepared(object sender, ASPxGridViewTableDataCellEventArgs e) { if (e.DataColumn.Name.Equals("AccountId")) { ASPxGridView grid = sender as ASPxGridView; if (grid != null) { e.Cell.Text = session.GetObjectByKey <NAS.DAL.Accounting.AccountChart.Account>(grid.GetRowValuesByKeyValue(e.KeyValue, "AccountId!Key")).Code; } } }