private void executeQuery()
{
this.Cursor = Cursors.WaitCursor;
string colName = GridViewRole.FocusedColumn.FieldName;
string value = String.Empty;
if (!string.IsNullOrWhiteSpace(GridViewRole.GetFocusedDisplayText()))
{
value = GridViewRole.GetFocusedDisplayText();
}
if (!string.IsNullOrWhiteSpace(value))
{
string query = String.Format("it.CODE like '{0}%'", GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE"));
var special = context.ROLE.Where(query);
if (!string.IsNullOrWhiteSpace(GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "DESC")))
{
query = String.Format("it.{0} like '{1}%'", "[DESC]", GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "DESC"));
special = special.Where(query);
}
if (!string.IsNullOrWhiteSpace(GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "TYPE")))
{
query = String.Format("it.{0} like '{1}%'", "[TYPE]", GridViewRole.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "TYPE"));
special = special.Where(query);
}
int count = special.Count();
if (count > 0)
{
RoleBindingSource.DataSource = special;
GridViewRole.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value);
GridViewRole.FocusedRowHandle = 0;
GridViewRole.FocusedColumn.FieldName = colName;
}
else
{
MessageBox.Show("No records in database.");
GridViewRole.ClearColumnsFilter();
}
}
this.Cursor = Cursors.Default;
}
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
GridViewRole.ClearColumnsFilter();
if (RoleBindingSource.Current == null)
{
//fake query in order to create a link between the database table and the binding source
RoleBindingSource.DataSource = from opt in context.ROLE where opt.CODE == "KJM9" select opt;
RoleBindingSource.AddNew();
if (GridViewRole.FocusedRowHandle == GridControl.AutoFilterRowHandle)
{
GridViewRole.FocusedRowHandle = GridViewRole.RowCount - 1;
}
tYPEComboBoxEdit.Focus();
setReadOnly(false);
newRec = true;
return;
}
tYPEComboBoxEdit.Focus();
//bindingNavigatorPositionItem.Focus(); //trigger field leave event
GridViewRole.CloseEditor();
temp = newRec;
if (checkForms())
{
if (!temp)
{
context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( ROLE)RoleBindingSource.Current);
}
RoleBindingSource.AddNew();
if (GridViewRole.FocusedRowHandle == GridControl.AutoFilterRowHandle)
{
GridViewRole.FocusedRowHandle = GridViewRole.RowCount - 1;
}
tYPEComboBoxEdit.Focus();
setReadOnly(false);
newRec = true;
}
}
