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;
}
private void cARINFOBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (CarInfoBindingSource.Current == null)
{
return;
}
GridViewCarInfo.CloseEditor();
cODETextEdit.Focus();
// bindingNavigatorPositionItem.Focus();//trigger field leave event
bool temp = newRec;
if (checkForms())
{
errorProvider1.Clear();
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, (CARINFO)CarInfoBindingSource.Current);
}
}
private void CarInfoForm_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter && GridViewCarInfo.IsFilterRow(GridViewCarInfo.FocusedRowHandle))
{
executeQuery();
}
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (CarInfoBindingSource.Current == null)
{
return;
}
GridViewCarInfo.CloseEditor();
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
CarInfoBindingSource.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);
}
cODETextEdit.Focus();
currentVal = cODETextEdit.Text;
modified = false;
newRec = false;
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (!GridViewCarInfo.IsFilterRow(e.RowHandle))
{
modified = true;
}
labelControl6.Text = DateTime.Today.ToShortDateString();
labelControl7.Text = username;
}
private void setValues()
{
GridViewCarInfo.SetFocusedRowCellValue("Type", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("CODE", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("NAME", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("AP", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("AR", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("OPERATOR", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("OPER_NAME", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("ADDR1", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("ADDR2", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("ADDR3", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("PHONE", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("TELEX", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("CONTACT", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("CONT_PHONE", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("AIRPORT", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("AIR_MI", 0);
GridViewCarInfo.SetFocusedRowCellValue("COUNTRY", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("CITY", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("CITY_MI", 0);
GridViewCarInfo.SetFocusedRowCellValue("CREDIT", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("COMMENT1", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("COMMENT2", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("COMMENT3", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("COMMENT4", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("RATE_BASIS", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("RSTR_CDE", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("USE_CLIENT_LOGO", "N");
GridViewCarInfo.SetFocusedRowCellValue("VOUCH_DAYS_PRIOR", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("STATE", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("ZIP", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("TOWN", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("GMACCTNO", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("USER_DEC1", 0);
GridViewCarInfo.SetFocusedRowCellValue("USER_DEC2", 0);
GridViewCarInfo.SetFocusedRowCellValue("USER_INT1", 0);
GridViewCarInfo.SetFocusedRowCellValue("USER_INT2", 0);
GridViewCarInfo.SetFocusedRowCellValue("USER_TXT1", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("USER_TXT2", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("USER_TXT3", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("USER_TXT4", string.Empty);
GridViewCarInfo.SetFocusedRowCellValue("Due_Days", 0);
}
private bool move()
{
GridViewCarInfo.CloseEditor();
cODETextEdit.Focus();
//bindingNavigatorPositionItem.Focus();//trigger field leave event
temp = newRec;
if (checkForms())
{
errorProvider1.Clear();
if (!temp)
{
context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( CARINFO)CarInfoBindingSource.Current);
}
setReadOnly(true);
newRec = false;
modified = false;
return(true);
}
return(false);
}
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;
}
}
