private void MapSelected()
        {
            var mapper    = new CashFlowFixMapper((XPObjectSpace)ObjectSpace);
            var cashFlows = View.SelectedObjects;

            mapper.Process(cashFlows);

            new Xafology.ExpressApp.SystemModule.GenericMessageBox(
                "ACTION COMPLETED : Map Selected",
                "ACTION COMPLETED");
        }
        public void MapCashFlows()
        {
            var mapper         = new CashFlowFixMapper(objSpace);
            var fromDateSqlVar = mapper.SqlDeclareClauses.Where(c => c.ParameterName == "FromDate").FirstOrDefault();
            var toDateSqlVar   = mapper.SqlDeclareClauses.Where(c => c.ParameterName == "ToDate").FirstOrDefault();
            var snapshotSqlVar = mapper.SqlDeclareClauses.Where(c => c.ParameterName == "Snapshot").FirstOrDefault();

            fromDateSqlVar.CommandText = string.Format("'{0}'", fromDate.ToString("yyyy-MM-dd"));
            toDateSqlVar.CommandText   = string.Format("'{0}'", toDate.ToString("yyyy-MM-dd"));
            snapshotSqlVar.CommandText = @"(SELECT TOP 1 [CurrentCashFlowSnapshot] FROM SetOfBooks WHERE GCRecord IS NULL)";

            mapper.ProcessByOids(
                @"SELECT cf.Oid FROM CashFlow cf
WHERE cf.TranDate BETWEEN @FromDate AND @ToDate
AND cf.GCRecord IS NULL
AND cf.Snapshot = @Snapshot");
        }