private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = AdvBandedGridViewCarRate.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(AdvBandedGridViewCarRate.GetFocusedDisplayText())) { value = AdvBandedGridViewCarRate.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { //string query = String.Format("it.{0} = {1}", "Inactive", false); string query = String.Format("it.CAT like '{0}%'", AdvBandedGridViewCarRate.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CAT")); var special = context.CARRATES.Where(query); if (!string.IsNullOrWhiteSpace(AdvBandedGridViewCarRate.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE"))) { query = String.Format("it.{0} like '{1}%'", "CODE", AdvBandedGridViewCarRate.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE")); special = special.Where(query); } if (!string.IsNullOrWhiteSpace(AdvBandedGridViewCarRate.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "OFF"))) { query = String.Format("it.{0} like '{1}%'", "OFF", AdvBandedGridViewCarRate.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "OFF")); special = special.Where(query); } if (!string.IsNullOrWhiteSpace(AdvBandedGridViewCarRate.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "START_DATE"))) { string validDate = AdvBandedGridViewCarRate.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) { CarRateBindingSource.DataSource = special; //AdvBandedGridViewCarRate.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value); AdvBandedGridViewCarRate.FocusedRowHandle = 0; AdvBandedGridViewCarRate.ClearColumnsFilter(); } else { MessageBox.Show("No records in database."); AdvBandedGridViewCarRate.ClearColumnsFilter(); } } this.Cursor = Cursors.Default; }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { AdvBandedGridViewCarRate.ClearColumnsFilter(); if (CarRateBindingSource.Current == null) { //fake query in order to create a link between the database table and the binding source CarRateBindingSource.DataSource = from opt in context.CARRATES where opt.CODE == "KJM9" select opt; CarRateBindingSource.AddNew(); if (AdvBandedGridViewCarRate.FocusedRowHandle == GridControl.AutoFilterRowHandle) { AdvBandedGridViewCarRate.FocusedRowHandle = AdvBandedGridViewCarRate.RowCount - 1; } setValues(); ImageComboBoxEditCode.Focus(); setReadOnly(false); sTART_DATEDateEdit.Properties.ReadOnly = false; newRec = true; return; } ImageComboBoxEditCode.Focus(); // bindingNavigatorPositionItem.Focus(); //trigger field leave event temp = newRec; if (checkForms()) { if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( CARRATES)CarRateBindingSource.Current); } CarRateBindingSource.AddNew(); if (AdvBandedGridViewCarRate.FocusedRowHandle == GridControl.AutoFilterRowHandle) { AdvBandedGridViewCarRate.FocusedRowHandle = AdvBandedGridViewCarRate.RowCount - 1; } setValues(); ImageComboBoxEditCode.Focus(); setReadOnly(false); sTART_DATEDateEdit.Properties.ReadOnly = false; newRec = true; } }