private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!GridViewSeaport.IsFilterRow(e.RowHandle)) { modified = true; } }
private void SeaportForm_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter && GridViewSeaport.IsFilterRow(GridViewSeaport.FocusedRowHandle)) { executeQuery(); } }
private void BindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (SeaPortBindingSource.Current == null) { return; } GridViewSeaport.CloseEditor(); codeTextEdit.Focus(); //bindingNavigatorPositionItem.Focus();//trigger field leave event bool temp = newRec; if (checkForms()) { codeTextEdit.Focus(); setReadOnly(true); 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, (SeaPort)SeaPortBindingSource.Current); } }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (SeaPortBindingSource.Current == null) { return; } GridViewSeaport.CloseEditor(); if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes) { modified = false; newRec = false; SeaPortBindingSource.RemoveCurrent(); errorProvider1.Clear(); context.SaveChanges(); setReadOnly(true); 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 setValues() { GridViewSeaport.SetFocusedRowCellValue("Code", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Name", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Address1", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Address2", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Address3", string.Empty); GridViewSeaport.SetFocusedRowCellValue("City", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Town", string.Empty); GridViewSeaport.SetFocusedRowCellValue("State", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Zip", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Country", string.Empty); GridViewSeaport.SetFocusedRowCellValue("Latitude", 0); GridViewSeaport.SetFocusedRowCellValue("Longitude", 0); GridViewSeaport.SetFocusedRowCellValue("GeoCode_ID", 0); }
private bool move() { GridViewSeaport.CloseEditor(); codeTextEdit.Focus(); // bindingNavigatorPositionItem.Focus();//trigger field leave event temp = newRec; if (checkForms()) { if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( SeaPort)SeaPortBindingSource.Current); } setReadOnly(true); newRec = false; modified = false; return(true); } return(false); }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { GridViewSeaport.ClearColumnsFilter(); if (SeaPortBindingSource.Current == null) { //fake query in order to create a link between the database table and the binding source SeaPortBindingSource.DataSource = from opt in context.SeaPort where opt.Code == "KJM9" select opt; SeaPortBindingSource.AddNew(); if (GridViewSeaport.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewSeaport.FocusedRowHandle = GridViewSeaport.RowCount - 1; } setValues(); codeTextEdit.Focus(); setReadOnly(false); newRec = true; return; } // bindingNavigatorPositionItem.Focus(); //trigger field leave event codeTextEdit.Focus(); GridViewSeaport.CloseEditor(); temp = newRec; if (checkForms()) { if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( SeaPort)SeaPortBindingSource.Current); } SeaPortBindingSource.AddNew(); if (GridViewSeaport.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewSeaport.FocusedRowHandle = GridViewSeaport.RowCount - 1; } setValues(); codeTextEdit.Focus(); setReadOnly(false); newRec = true; } }
private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = GridViewSeaport.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(GridViewSeaport.GetFocusedDisplayText())) { value = GridViewSeaport.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { string query = String.Format("it.Code like '{0}%'", GridViewSeaport.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "Code")); var special = context.SeaPort.Where(query); if (!string.IsNullOrWhiteSpace(GridViewSeaport.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "Name"))) { query = String.Format("it.{0} like '{1}%'", "Name", GridViewSeaport.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "Name")); special = special.Where(query); } int count = special.Count(); if (count > 0) { SeaPortBindingSource.DataSource = special; GridViewSeaport.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value); GridViewSeaport.FocusedRowHandle = 0; GridViewSeaport.FocusedColumn.FieldName = colName; } else { MessageBox.Show("No records in database."); GridViewSeaport.ClearColumnsFilter(); } } this.Cursor = Cursors.Default; }