Example #1
0
 private void VouchGenForm_KeyDown(object sender, KeyEventArgs e)
 {
     if (e.KeyCode == Keys.Enter && GridViewVouch.IsFilterRow(GridViewVouch.FocusedRowHandle))
     {
         executeQuery();
     }
 }
Example #2
0
 private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
 {
     if (VoucherBindingSource.Current == null)
     {
         VoucherBindingSource.AddNew();
         TextEditAgyNo.Focus();
         //agyNoTextEdit.Properties.ReadOnly = false;
         //gridView1.Columns.ColumnByName(colName1).OptionsColumn.AllowEdit = true;
         newRec = true;
         return;
     }
     TextEditAgyNo.Focus();
     //bindingNavigatorPositionItem.Focus();  //trigger field leave event
     GridViewVouch.CloseEditor();
     temp = newRec;
     if (checkForms())
     {
         if (!temp)
         {
             context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, (VOUCHER)VoucherBindingSource.Current);
         }
         VoucherBindingSource.AddNew();
         TextEditAgyNo.Focus();
         //agyNoTextEdit.Properties.ReadOnly = false;
         //gridView1.Columns.ColumnByName(colName1).OptionsColumn.AllowEdit = true;
         newRec = true;
     }
 }
Example #3
0
 private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
 {
     if (!GridViewVouch.IsFilterRow(e.RowHandle))
     {
         modified = true;
     }
 }
Example #4
0
        private void vOUCHERBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            if (VoucherBindingSource.Current == null)
            {
                return;
            }

            GridViewVouch.CloseEditor();
            TextEditAgyNo.Focus();
            bool temp = newRec;

            // bindingNavigatorPositionItem.Focus();//trigger field leave event
            if (checkForms())
            {
                TextEditAgyNo.Focus();
                //agyNoTextEdit.Properties.ReadOnly = true;
                //gridView1.Columns.ColumnByName(colName1).OptionsColumn.AllowEdit = false;
                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, (VOUCHER)VoucherBindingSource.Current);
            }
        }
Example #5
0
 private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
 {
     if (VoucherBindingSource.Current == null)
     {
         return;
     }
     GridViewVouch.CloseEditor();
     if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
     {
         modified = false;
         newRec   = false;
         VoucherBindingSource.RemoveCurrent();
         errorProvider1.Clear();
         context.SaveChanges();
         //agyNoTextEdit.Properties.ReadOnly = true;
         //gridView1.Columns.ColumnByName(colName1).OptionsColumn.AllowEdit = false;
         panelControlStatus.Visible = true;
         LabelStatus.Text           = "Record Deleted";
         rowStatusDelete            = new Timer();
         rowStatusDelete.Interval   = 3000;
         rowStatusDelete.Start();
         rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
     }
     currentVal = TextEditAgyNo.Text;
 }
Example #6
0
        private void executeQuery()
        {
            this.Cursor = Cursors.WaitCursor;
            string colName = GridViewVouch.FocusedColumn.FieldName;
            string value   = String.Empty;

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

                if (!string.IsNullOrWhiteSpace(GridViewVouch.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "AgyNo")))
                {
                    query   = String.Format("it.{0} like '{1}%'", "AgyNo", GridViewVouch.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "AgyNo"));
                    special = special.Where(query);
                }
                if (!string.IsNullOrWhiteSpace(GridViewVouch.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "Code")))
                {
                    query   = String.Format("it.{0} like '{1}%'", "Code", GridViewVouch.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "Code"));
                    special = special.Where(query);
                }
                if (!string.IsNullOrWhiteSpace(GridViewVouch.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "StartDate")))
                {
                    string validDate = GridViewVouch.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "StartDate");
                    string values    = validCheck.convertDate(validDate);
                    if (!string.IsNullOrWhiteSpace(values))
                    {
                        DateTime startDate = Convert.ToDateTime(values);
                        special = special.Where("it.StartDate >= @date", new ObjectParameter("date", startDate));
                    }
                }
                int count = special.Count();
                if (count > 0)
                {
                    VoucherBindingSource.DataSource = special;
                    GridViewVouch.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value);
                    GridViewVouch.FocusedRowHandle        = 0;
                    GridViewVouch.FocusedColumn.FieldName = colName;
                }
                else
                {
                    MessageBox.Show("No records in database.");
                    GridViewVouch.ClearColumnsFilter();
                }
            }
            this.Cursor = Cursors.Default;
        }
Example #7
0
 private bool move()
 {
     GridViewVouch.CloseEditor();
     TextEditAgyNo.Focus();
     //bindingNavigatorPositionItem.Focus();//trigger field leave event
     temp = newRec;
     if (checkForms())
     {
         if (!temp)
         {
             context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, (VOUCHER)VoucherBindingSource.Current);
         }
         //agyNoTextEdit.Properties.ReadOnly = true;
         //gridView1.Columns.ColumnByName(colName1).OptionsColumn.AllowEdit = false;
         newRec   = false;
         modified = false;
         return(true);
     }
     return(false);
 }