private void CarRateForm_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter && AdvBandedGridViewCarRate.IsFilterRow(AdvBandedGridViewCarRate.FocusedRowHandle)) { executeQuery(); } }
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; } }
private void setValues() { AdvBandedGridViewCarRate.SetFocusedRowCellValue("OFF", string.Empty); AdvBandedGridViewCarRate.SetFocusedRowCellValue("CODE", string.Empty); AdvBandedGridViewCarRate.SetFocusedRowCellValue("CAT", string.Empty); AdvBandedGridViewCarRate.SetFocusedRowCellValue("H_L", string.Empty); AdvBandedGridViewCarRate.SetFocusedRowCellValue("YEAR", string.Empty); AdvBandedGridViewCarRate.SetFocusedRowCellValue("DESCRIPTION", string.Empty); AdvBandedGridViewCarRate.SetFocusedRowCellValue("GWKLY_RATE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("GDAY_RATE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("GXTRA_RATE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("GADNL_DRVR", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("GUNDR_AGE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("NWKLY_RATE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("NDAY_RATE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("NXTRA_RATE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("NADNL_DRVR", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("NUNDR_AGE", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("AGENCY", string.Empty); AdvBandedGridViewCarRate.SetFocusedRowCellValue("WKMIN_DAYS", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("WKMAX_DAYS", 0); AdvBandedGridViewCarRate.SetFocusedRowCellValue("COMM_FLG", "N"); AdvBandedGridViewCarRate.SetFocusedRowCellValue("COMM_PCT", 0); }