private void setValues() { GridViewHtlBrand.SetFocusedRowCellValue("CODE", string.Empty); GridViewHtlBrand.SetFocusedRowCellValue("DESC", string.Empty); GridViewHtlBrand.SetFocusedRowCellValue("CHAIN", string.Empty); GridViewHtlBrand.SetFocusedRowCellValue("LOGO_PATH", string.Empty); }
private void HtlBrandForm_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter && GridViewHtlBrand.IsFilterRow(GridViewHtlBrand.FocusedRowHandle)) { executeQuery(); } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!GridViewHtlBrand.IsFilterRow(e.RowHandle)) { modified = true; } }
private void hTLBRANDBindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (HtlBrandBindingSource.Current == null) { return; } GridViewHtlBrand.CloseEditor(); cODETextEdit.Focus(); //bindingNavigatorPositionItem.Focus(); ((HTLBRAND)HtlBrandBindingSource.Current).ImagesRoot = imagesRoot; bool temp = newRec; if (checkForms()) { cODETextEdit.Focus(); cODETextEdit.Properties.ReadOnly = true; GridViewHtlBrand.Columns.ColumnByName(colName).OptionsColumn.AllowEdit = false; panelControlStatus.Visible = true; LabelStatus.Text = "Record Saved"; rowStatusSave = new Timer(); rowStatusSave.Interval = 3000; rowStatusSave.Start(); rowStatusSave.Tick += TimedEventSave; } if (!temp && !modified) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, (HTLBRAND)HtlBrandBindingSource.Current); } }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (HtlBrandBindingSource.Current == null) { return; } GridViewHtlBrand.CloseEditor(); if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes) { modified = false; newRec = false; HtlBrandBindingSource.RemoveCurrent(); errorProvider1.Clear(); context.SaveChanges(); HtlBrandBindingSource.EndEdit(); cODETextEdit.Properties.ReadOnly = true; GridViewHtlBrand.Columns.ColumnByName(colName).OptionsColumn.AllowEdit = false; panelControlStatus.Visible = true; LabelStatus.Text = "Record Deleted"; rowStatusDelete = new Timer(); rowStatusDelete.Interval = 3000; rowStatusDelete.Start(); rowStatusDelete.Tick += new EventHandler(TimedEventDelete); } currentVal = cODETextEdit.Text; }
private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = GridViewHtlBrand.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(GridViewHtlBrand.GetFocusedDisplayText())) { value = GridViewHtlBrand.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { string query = String.Format("it.CODE like '{0}%'", GridViewHtlBrand.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE")); var special = context.HTLBRAND.Where(query); if (!string.IsNullOrWhiteSpace(GridViewHtlBrand.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "DESC"))) { query = String.Format("it.{0} like '{1}%'", "[DESC]", GridViewHtlBrand.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "DESC")); special = special.Where(query); } if (!string.IsNullOrWhiteSpace(GridViewHtlBrand.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CHAIN"))) { query = String.Format("it.{0} like '{1}%'", "[CHAIN]", GridViewHtlBrand.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CHAIN")); special = special.Where(query); } int count = special.Count(); if (count > 0) { HtlBrandBindingSource.DataSource = special; GridViewHtlBrand.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value); GridViewHtlBrand.FocusedRowHandle = 0; GridViewHtlBrand.FocusedColumn.FieldName = colName; GridViewHtlBrand.ClearColumnsFilter(); } else { MessageBox.Show("No records in database."); GridViewHtlBrand.ClearColumnsFilter(); } } this.Cursor = Cursors.Default; }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { GridViewHtlBrand.ClearColumnsFilter(); if (HtlBrandBindingSource.Current == null) { //fake query in order to create a link between the database table and the binding source HtlBrandBindingSource.DataSource = from opt in context.HTLBRAND where opt.CODE == "KJM9" select opt; HtlBrandBindingSource.AddNew(); if (GridViewHtlBrand.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewHtlBrand.FocusedRowHandle = GridViewHtlBrand.RowCount - 1; } setValues(); cODETextEdit.Focus(); cODETextEdit.Properties.ReadOnly = false; GridViewHtlBrand.Columns.ColumnByName(colName).OptionsColumn.AllowEdit = true; newRec = true; return; } cODETextEdit.Focus(); //bindingNavigatorPositionItem.Focus(); GridViewHtlBrand.CloseEditor(); temp = newRec; ((HTLBRAND)HtlBrandBindingSource.Current).ImagesRoot = imagesRoot; if (checkForms()) { if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, (HTLBRAND)HtlBrandBindingSource.Current); } HtlBrandBindingSource.AddNew(); if (GridViewHtlBrand.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewHtlBrand.FocusedRowHandle = GridViewHtlBrand.RowCount - 1; } setValues(); cODETextEdit.Focus(); cODETextEdit.Properties.ReadOnly = false; GridViewHtlBrand.Columns.ColumnByName(colName).OptionsColumn.AllowEdit = true; newRec = true; } }
private bool move() { GridViewHtlBrand.CloseEditor(); cODETextEdit.Focus(); //bindingNavigatorPositionItem.Focus(); temp = newRec; ((HTLBRAND)HtlBrandBindingSource.Current).ImagesRoot = imagesRoot; if (checkForms()) { if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( HTLBRAND)HtlBrandBindingSource.Current); } cODETextEdit.Properties.ReadOnly = true; GridViewHtlBrand.Columns.ColumnByName(colName).OptionsColumn.AllowEdit = false; newRec = false; modified = false; return(true); } return(false); }