private void iNSURANBindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (InsuranBindingSource.Current == null) { return; } GridViewInsuran.CloseEditor(); yEARComboBoxEdit.Focus(); //bindingNavigatorPositionItem.Focus();//trigger field leave event bool temp = newRec; if (checkForms()) { 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, (INSURAN)InsuranBindingSource.Current); } }
private void InsuranForm_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter && GridViewInsuran.IsFilterRow(GridViewInsuran.FocusedRowHandle)) { executeQuery(); } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!GridViewInsuran.IsFilterRow(e.RowHandle)) { modified = true; labelControl1.Text = DateTime.Today.ToShortDateString(); labelControl2.Text = username; } }
private void setValues() { GridViewInsuran.SetFocusedRowCellValue("YEAR", 0); GridViewInsuran.SetFocusedRowCellValue("ITEM_", 0); GridViewInsuran.SetFocusedRowCellValue("FROM_AMT", 0); GridViewInsuran.SetFocusedRowCellValue("START_DATE", DateTime.Today); GridViewInsuran.SetFocusedRowCellValue("TO_AMT", 0); GridViewInsuran.SetFocusedRowCellValue("PREMIUM", 0); GridViewInsuran.SetFocusedRowCellValue("COMM_PCT", 0); GridViewInsuran.SetFocusedRowCellValue("AGENCY", string.Empty); GridViewInsuran.SetFocusedRowCellValue("COMM_FLG", "0"); }
private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = GridViewInsuran.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(GridViewInsuran.GetFocusedDisplayText())) { value = GridViewInsuran.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { string query = String.Format("it.AGENCY like '{0}%'", GridViewInsuran.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "AGENCY")); //string query = String.Format("it.{0} like '{1}%'", colName, value); var special = context.INSURAN.Where(query); if (!string.IsNullOrWhiteSpace(GridViewInsuran.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "START_DATE"))) { string validDate = GridViewInsuran.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "START_DATE"); string values = validCheck.convertDate(validDate); if (!string.IsNullOrWhiteSpace(values)) { DateTime startDate = Convert.ToDateTime(values); special = special.Where("it.START_DATE >= @date", new ObjectParameter("date", startDate)); } } int count = special.Count(); if (count > 0) { InsuranBindingSource.DataSource = special; GridViewInsuran.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value); GridViewInsuran.FocusedRowHandle = 0; GridViewInsuran.FocusedColumn.FieldName = colName; GridViewInsuran.ClearColumnsFilter(); } else { MessageBox.Show("No records in database."); GridViewInsuran.ClearColumnsFilter(); } } this.Cursor = Cursors.Default; }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { GridViewInsuran.ClearColumnsFilter(); if (InsuranBindingSource.Current == null) { //fake query in order to create a link between the database table and the binding source InsuranBindingSource.DataSource = from opt in context.INSURAN where opt.AGENCY == "KJM9" select opt; InsuranBindingSource.AddNew(); if (GridViewInsuran.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewInsuran.FocusedRowHandle = GridViewInsuran.RowCount - 1; } setValues(); setReadOnly(false); yEARComboBoxEdit.Focus(); newRec = true; return; } yEARComboBoxEdit.Focus(); //bindingNavigatorPositionItem.Focus(); //trigger field leave event GridViewInsuran.CloseEditor(); temp = newRec; if (checkForms()) { if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( INSURAN)InsuranBindingSource.Current); } InsuranBindingSource.AddNew(); if (GridViewInsuran.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewInsuran.FocusedRowHandle = GridViewInsuran.RowCount - 1; } setValues(); setReadOnly(false); yEARComboBoxEdit.Focus(); newRec = true; } }
private bool move() { GridViewInsuran.CloseEditor(); yEARComboBoxEdit.Focus(); //bindingNavigatorPositionItem.Focus();//trigger field leave event temp = newRec; if (checkForms()) { if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( INSURAN)InsuranBindingSource.Current); } setReadOnly(true); newRec = false; modified = false; return(true); } return(false); }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (InsuranBindingSource.Current == null) { return; } GridViewInsuran.CloseEditor(); if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes) { modified = false; newRec = false; InsuranBindingSource.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 = ImageComboBoxEditAgency.Text; }