private bool move() { if (contactNewRowRec == true) { MessageBox.Show("Please save or delete the new record being added in the grid on the Contacts tab before attempting to navigate to another record."); return(false); } GridViewOper.CloseEditor(); TextEditCode.Focus(); //bindingNavigatorPositionItem.Focus();//trigger field leave event temp = newRec; if (checkForms()) { errorProvider1.Clear(); if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( OPERATOR)OperatorBindingSource.Current); } setReadOnly(true); newRec = false; modified = false; return(true); } return(false); }
private void OperatorForm_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter && GridViewOper.IsFilterRow(GridViewOper.FocusedRowHandle)) { executeQuery(); } }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { if (OperatorBindingSource.Current == null) { OperatorBindingSource.DataSource = from opt in context.OPERATOR where opt.CODE == "KJM9" select opt; OperatorBindingSource.AddNew(); TextEditCode.Focus(); setReadOnly(false); setValues(); newRec = true; return; } TextEditCode.Focus(); //bindingNavigatorPositionItem.Focus(); //trigger field leave event GridViewOper.CloseEditor(); temp = newRec; if (checkForms()) { errorProvider1.Clear(); if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( OPERATOR)OperatorBindingSource.Current); } OperatorBindingSource.AddNew(); TextEditCode.Focus(); setReadOnly(false); setValues(); newRec = true; } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!GridViewOper.IsFilterRow(e.RowHandle)) { modified = true; labelControl1.Text = validCheck.convertDate(DateTime.Today.ToShortDateString()); labelControl2.Text = username; } }
private void oPERATORBindingNavigatorSaveItem_Click(object sender, EventArgs e) { TextEditCode.Focus(); int contactID = 0; if (OperatorBindingSource.Current == null) { return; } GridViewOper.CloseEditor(); if (GridViewAdditionalContacts.RowCount > 0) { contactID = (int)GridViewAdditionalContacts.GetFocusedRowCellValue("ID"); } bool temp = newRec; if (checkForms()) { contactNewRowRec = false; errorProvider1.Clear(); setReadOnly(true); if (contactID == int.MaxValue) { int newID = (int)GridViewAdditionalContacts.GetFocusedRowCellValue("ID"); var values1 = from rec in context.RPTTYPE where rec.RecipientType == "Operator" select new { rec.CODE }; foreach (var result in values1) { if (globalRptType.Contains(result.CODE)) { RptContact lol = new RptContact(); lol.Code = TextEditCode.Text; lol.RptType = result.CODE; lol.Contact_ID = newID; context.RptContact.AddObject(lol); } } globalRptType = string.Empty; context.SaveChanges(); } contactNewRowRec = 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, (OPERATOR)OperatorBindingSource.Current); } }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (OperatorBindingSource.Current == null) { return; } GridViewOper.CloseEditor(); if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes) { modified = false; newRec = false; IEnumerable <CONTACT> contactRecs = from contact in context.CONTACT where contact.LINK_VALUE == TextEditCode.Text select contact; foreach (CONTACT rec in contactRecs) { context.DeleteObject(rec); } IEnumerable <RptContact> rptContactRecs = from contact in context.RptContact where contact.Code == TextEditCode.Text select contact; foreach (RptContact rec in rptContactRecs) { context.DeleteObject(rec); } OperatorBindingSource.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); } TextEditCode.Focus(); currentVal = TextEditCode.Text; modified = false; newRec = false; }
private void setValues() { GridViewOper.SetFocusedRowCellValue("CODE", string.Empty); GridViewOper.SetFocusedRowCellValue("NAME", string.Empty); GridViewOper.SetFocusedRowCellValue("ADDR1", string.Empty); GridViewOper.SetFocusedRowCellValue("ADDR2", string.Empty); GridViewOper.SetFocusedRowCellValue("ADDR3", string.Empty); GridViewOper.SetFocusedRowCellValue("CITY_CODE", string.Empty); GridViewOper.SetFocusedRowCellValue("CNTRY_CODE", string.Empty); GridViewOper.SetFocusedRowCellValue("PHONE", string.Empty); GridViewOper.SetFocusedRowCellValue("MAIL_FAX", "E"); GridViewOper.SetFocusedRowCellValue("PHONE", string.Empty); GridViewOper.SetFocusedRowCellValue("TELEX", string.Empty); GridViewOper.SetFocusedRowCellValue("AP", 0); GridViewOper.SetFocusedRowCellValue("AR", string.Empty); GridViewOper.SetFocusedRowCellValue("RES_EMAIL", string.Empty); GridViewOper.SetFocusedRowCellValue("AP_EMAIL", string.Empty); GridViewOper.SetFocusedRowCellValue("Due_Days", 0); GridViewOper.SetFocusedRowCellValue("TourfaxEmailFormat", "txt"); }
private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = GridViewOper.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(GridViewOper.GetFocusedDisplayText())) { value = GridViewOper.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { string query = String.Format("it.NAME like '{0}%'", GridViewOper.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "NAME")); var special = context.OPERATOR.Where(query); if (!string.IsNullOrWhiteSpace(GridViewOper.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE"))) { query = String.Format("it.{0} like '{1}%'", "CODE", GridViewOper.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE")); special = special.Where(query); } int count = special.Count(); if (count > 0) { OperatorBindingSource.DataSource = special; GridViewOper.FocusedRowHandle = 0; GridViewOper.FocusedColumn.FieldName = colName; GridViewOper.ClearColumnsFilter(); } else { MessageBox.Show("No records in database."); GridViewOper.ClearColumnsFilter(); //this should be final } } this.Cursor = Cursors.Default; }