Example #1
0
        private void executeQuery()
        {
            this.Cursor = Cursors.WaitCursor;
            string colName = GridViewCarInfo.FocusedColumn.FieldName;
            string value   = String.Empty;

            if (!string.IsNullOrWhiteSpace(GridViewCarInfo.GetFocusedDisplayText()))
            {
                value = GridViewCarInfo.GetFocusedDisplayText();
            }
            if (!string.IsNullOrWhiteSpace(value))
            {
                string query   = String.Format("it.NAME like '{0}%'", GridViewCarInfo.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "NAME"));
                var    special = context.CARINFO.Where(query);

                if (!string.IsNullOrWhiteSpace(GridViewCarInfo.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE")))
                {
                    query   = String.Format("it.{0} like '{1}%'", "CODE", GridViewCarInfo.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE"));
                    special = special.Where(query);
                }
                int count = special.Count();
                if (count > 0)
                {
                    CarInfoBindingSource.DataSource = special;
                    GridViewCarInfo.ClearColumnsFilter();
                }
                else
                {
                    MessageBox.Show("No records in database.");
                    GridViewCarInfo.ClearColumnsFilter();
                }
            }
            this.Cursor = Cursors.Default;
        }
Example #2
0
        private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
        {
            GridViewCarInfo.ClearColumnsFilter();
            cODETextEdit.Focus();  //trigger field leave event
            if (CarInfoBindingSource.Current == null)
            {
                //fake query in order to create a link between the database table and the binding source
                CarInfoBindingSource.DataSource = from opt in context.CARINFO where opt.CODE == "KJM9" select opt;
                CarInfoBindingSource.AddNew();
                if (GridViewCarInfo.FocusedRowHandle == GridControl.AutoFilterRowHandle)
                {
                    GridViewCarInfo.FocusedRowHandle = GridViewCarInfo.RowCount - 1;
                }
                setValues();
                cODETextEdit.Focus();
                setReadOnly(false);
                newRec = true;
                return;
            }

            GridViewCarInfo.CloseEditor();
            temp = newRec;
            if (checkForms())
            {
                errorProvider1.Clear();
                if (!temp)
                {
                    context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( CARINFO)CarInfoBindingSource.Current);
                }
                CarInfoBindingSource.AddNew();
                if (GridViewCarInfo.FocusedRowHandle == GridControl.AutoFilterRowHandle)
                {
                    GridViewCarInfo.FocusedRowHandle = GridViewCarInfo.RowCount - 1;
                }
                setValues();
                cODETextEdit.Focus();
                setReadOnly(false);
                newRec = true;
            }
        }