Exemple #1
0
        /// <summary>
        /// Load the database datafields directly from the xml to generate a query,
        /// this is more far efficient than loading the visual tree.
        /// </summary>
        /// <param name="pathFile">Path file to be used</param>
        protected void InitData(string pathFile)
        {
            Contract.Requires(!string.IsNullOrEmpty(pathFile), "Path name is not valied");
            var currentAssemblyPath = System.IO.Path.GetDirectoryName(
                System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
            var builder = new StringBuilder();

            builder.Append(currentAssemblyPath);
            builder.Append(pathFile);
            var collection = SqlFieldLoader.LoadXmlData(builder.ToString());

            foreach (var table in collection.DataList)
            {
                var tmpBuilder = new StringBuilder();
                var fields     = table.DataFields;
                foreach (var f in fields)
                {
                    tmpBuilder.Append(f.Name);
                    tmpBuilder.Append(",");
                }
                var query = tmpBuilder.ToString();
                query = query.Substring(0, query.Length - 1);
                tmpBuilder.Clear();
                if (!BaseQueryDictionary.ContainsKey(table.Name))
                {
                    BaseQueryDictionary.Add(table.Name, query);
                }
            }
            // now instance a map
            Mapper = MapperField.GetMapper();
        }
Exemple #2
0
        protected override void InitializeShell()
        {
            // The main window and configuration services shall be injected just here
            // because in the configure container are not yet available.

            try
            {
                IMapper mapper = MapperField.GetMapper();
                IConfigurationService shell = Container.Resolve <IConfigurationService>();
                shell.Shell = Application.Current.MainWindow;
                PropertyInfo info = shell.Shell.GetType().GetProperty("UnityContainer");
                if (info != null)
                {
                    info.SetValue(shell.Shell, Container);
                }

                var wrapShell = this.WrapShell();
                wrapShell.Show();
                Container.Resolve <ProviderInfoView>();
                Container.Resolve <CommissionAgentInfoView>();
                Container.Resolve <BookingModule.Views.BookingInfoView>();
                Container.Resolve <KarveControls.HeaderedWindow.LineGridView>();
                Container.Resolve <BookingModule.Views.BookingFooterView>();
            } catch (Exception e)
            {
                logger.Error("Error during bootstrap:" + e.Message);
                MessageBox.Show("Error during bootstrap" + e.Message);
            }
        }
Exemple #3
0
        /// <summary>
        ///  Get magnifier settings by id.
        /// </summary>
        /// <param name="idValue">Identifier of the grid.</param>
        /// <returns></returns>
        public async Task <GridSettingsDto> GetMagnifierSettings(long idValue)
        {
            IMapper         mapper      = MapperField.GetMapper();
            GridSettingsDto settingsDto = new GridSettingsDto();

            if (_executorSql.State != ConnectionState.Open)
            {
                using (var dbConnection = _executorSql.OpenNewDbConnection())
                {
                    var dto = await dbConnection.GetAsync <GRID_SERIALIZATION>(idValue).ConfigureAwait(true);

                    if (dto != null)
                    {
                        settingsDto = mapper.Map <GRID_SERIALIZATION, GridSettingsDto>(dto);
                    }

                    return(settingsDto);
                }
            }

            var settings = await _executorSql.Connection.GetAsync <GRID_SERIALIZATION>(idValue);

            settingsDto = mapper.Map <GRID_SERIALIZATION, GridSettingsDto>(settings);
            return(settingsDto);
        }
Exemple #4
0
 /// <summary>
 /// Client data saver
 /// </summary>
 /// <param name="executor">Sql command executor</param>
 public OfficeDataSaver(ISqlExecutor executor)
 {
     _executor = executor;
     /// FIXME: violate the law of demter.
     _mapper            = MapperField.GetMapper();
     _queryStoreFactory = new QueryStoreFactory();
 }
Exemple #5
0
        public async Task <bool> SaveBranches(IDbConnection connection)
        {
            bool   retValue  = true;
            string deleteAll = string.Format("DELETE FROM ProDelega WHERE cldIdCliente='{0}'",
                                             this.Value.NUM_PROVEE);
            await connection.ExecuteAsync(deleteAll);

            IMapper tmpMapper = MapperField.GetMapper();

            foreach (var branch in this.BranchesDtos)
            {
                ProDelega delega = tmpMapper.Map <BranchesDto, ProDelega>(branch);
                delega.cldIdCliente = this.Value.NUM_PROVEE;

                try

                {
                    int value = await connection.InsertAsync(delega);
                }
                catch (System.Exception e)
                {
                    retValue = false;
                    string message = "Transaction Scope Exception in Vehicle Insertion. Reason: " + e.Message;
                    logger.Error(message);
                    DataLayerExecutionException dataLayer = new DataLayerExecutionException(message);
                    throw dataLayer;
                }
            }
            return(retValue);
        }
Exemple #6
0
        public async Task <ObservableCollection <GridSettingsDto> > GetMagnifierSettingByIds(List <long> registeredGridIds)
        {
            ObservableCollection <GRID_SERIALIZATION> settings = new ObservableCollection <GRID_SERIALIZATION>();

            Contract.Requires(registeredGridIds != null);
            using (var dbConnection = _executorSql.OpenNewDbConnection())
            {
                if (dbConnection != null)
                {
                    try
                    {
                        var dto = await dbConnection.GetAllAsync <GRID_SERIALIZATION>().ConfigureAwait(false);

                        var first = dto.OrderBy(x => x.GRID_ID).ToList();
                        foreach (var ids in registeredGridIds)
                        {
                            settings.Add(first.FirstOrDefault(x => x.GRID_ID == ids));
                        }
                    } catch (System.Exception e)
                    {
                        throw new DataLayerException(e.Message, e);
                    }
                }
            }
            var outSettings = MapperField.GetMapper()
                              .Map <IEnumerable <GRID_SERIALIZATION>, ObservableCollection <GridSettingsDto> >(settings);

            return(outSettings);
        }
 /// <summary>
 ///  Constructor
 /// </summary>
 /// <param name="sqlExecutor">This load the sql executor</param>
 public CompanyDataLoader(ISqlExecutor sqlExecutor)
 {
     _sqlExecutor       = sqlExecutor;
     _mapper            = MapperField.GetMapper();
     _currentPos        = 0;
     _helperBase        = new HelperBase();
     _queryStoreFactory = new QueryStoreFactory();
 }
 /// <summary>
 ///  Constructor for the budget
 /// </summary>
 /// <param name="sqlExecutor"></param>
 public BudgetDataAccessLayer(ISqlExecutor sqlExecutor) : base(sqlExecutor)
 {
     _dataLoader  = new BudgetDataLoader(sqlExecutor);
     _dataSaver   = new BudgetDataSaver(sqlExecutor);
     _dataDeleter = new BudgetDataDeleter(sqlExecutor);
     TableName    = "PRESUP1";
     _mapper      = MapperField.GetMapper();
 }
 /// <summary>
 ///  Booking data access layer.
 /// </summary>
 /// <param name="executor">Executor handle database connection.</param>
 public BookingDataAccessLayer(ISqlExecutor executor) : base(executor)
 {
     _mapper      = MapperField.GetMapper();
     _dataLoader  = new BookingDataLoader(SqlExecutor, _mapper);
     _dataDeleter = new BookingDataDeleter(SqlExecutor, _mapper);
     _dataSaver   = new BookingDataSaver(SqlExecutor, _mapper);
     TableName    = "RESERVAS1";
 }
Exemple #10
0
 public ReservationRequestDataAccessLayer(ISqlExecutor sqlExecutor) : base(sqlExecutor)
 {
     _dataLoader  = new DataLoader <PETICION, ReservationRequestDto>(sqlExecutor);
     _dataSaver   = new DataSaver <PETICION, ReservationRequestDto>(sqlExecutor);
     _dataDeleter = new DataDeleter <PETICION, ReservationRequestDto>(sqlExecutor);
     TableName    = "PETICION";
     _mapper      = MapperField.GetMapper();
 }
 public BookingDataAccessLayer(ISqlExecutor sqlExecutor) : base(sqlExecutor)
 {
     _dataLoader  = new DataLoader <RESERVAS1, BookingDto>(sqlExecutor);
     _dataSaver   = new DataSaver <RESERVAS1, BookingDto>(sqlExecutor);
     _dataDeleter = new DataDeleter <RESERVAS1, BookingDto>(sqlExecutor);
     TableName    = "RESERVAS1";
     _mapper      = MapperField.GetMapper();
 }
 /// <summary>
 /// BookingIncidentDataAccessLayer
 /// </summary>
 /// <param name="sqlExecutor">SQL executor</param>
 public BookingIncidentDataAccessLayer(ISqlExecutor sqlExecutor) : base(sqlExecutor)
 {
     _dataLoader  = new DataLoader <INCIRE, BookingIncidentViewObject>(sqlExecutor);
     _dataSaver   = new DataSaver <INCIRE, BookingIncidentViewObject>(sqlExecutor);
     _dataDeleter = new DataDeleter <INCIRE, BookingIncidentViewObject>(sqlExecutor);
     TableName    = "INCIRE";
     _mapper      = MapperField.GetMapper();
 }
Exemple #13
0
 public UsersDataAccessLayer(ISqlExecutor sqlExecutor) : base(sqlExecutor)
 {
     _dataLoader  = new DataLoader <USURE, UsersDto>(sqlExecutor);
     _dataSaver   = new DataSaver <USURE, UsersDto>(sqlExecutor);
     _dataDeleter = new DataDeleter <USURE, UsersDto>(sqlExecutor);
     TableName    = "USURE";
     _mapper      = MapperField.GetMapper();
 }
Exemple #14
0
 /// <summary>
 /// KarveNavigator constructor
 /// </summary>
 /// <param name="dataServices">DataServices to be used for navigation</param>
 /// <param name="regionManager">RegionManager to be used for instantiating a videw</param>
 /// <param name="eventManager">EventManager to be used for communicating between view models</param>
 /// <param name="dialogService">DialogServicing to be used for spotting errors.</param>
 public KarveNavigator(IDataServices dataServices, IRegionManager regionManager, IEventManager eventManager, IDialogService dialogService)
 {
     _dataServices  = dataServices;
     _regionManager = regionManager;
     _eventManager  = eventManager;
     _dialogService = dialogService;
     _mapper        = MapperField.GetMapper();
 }
Exemple #15
0
 public IncidentDataAccessLayer(ISqlExecutor sqlExecutor) : base(sqlExecutor)
 {
     _dataLoader  = new DataLoader <INCIDENCIAS, IncidentDto>(sqlExecutor);
     _dataSaver   = new DataSaver <INCIDENCIAS, IncidentDto>(sqlExecutor);
     _dataDeleter = new DataDeleter <INCIDENCIAS, IncidentDto>(sqlExecutor);
     TableName    = "INCIDENCIAS";
     _mapper      = MapperField.GetMapper();
 }
Exemple #16
0
 /// <summary>
 ///  Helper loader. This loader helps to load the data from dataservices
 /// </summary>
 /// <param name="services">Data services to be loaded.</param>
 public HelperLoader(IDataServices services)
 {
     _services           = services;
     _helperDataServices = services.GetHelperDataServices();
     _loadCompleted     += OnLoadCompleted;
     _currentIndex       = 0;
     _mapper             = MapperField.GetMapper();
     PageSize            = _defaultPageSize;
 }
 /// <summary>
 ///  Office data service constructor
 /// </summary>
 /// <param name="sqlExecutor">Sql Executor, interface for ADO.NET/Dapper access</param>
 public OfficeDataService(ISqlExecutor sqlExecutor) : base(sqlExecutor)
 {
     _mapper  = MapperField.GetMapper();
     _loader  = new OfficeDataLoader(SqlExecutor, _mapper);
     _saver   = new OfficeDataSaver(SqlExecutor, _mapper);
     _deleter = new OfficeDataDeleter(SqlExecutor, _mapper);
     // it is useful for the page count.
     TableName = "OFICINAS";
 }
Exemple #18
0
 public CommissionAgent()
 {
     _currentComisio      = new COMISIO();
     _commissionAgents    = new List <COMISIO>();
     _nacioPer            = new List <Country>();
     _tipoComis           = new List <TIPOCOMI>();
     _provinces           = new List <PROVINCIA>();
     _commissionAgentType = new CommissionAgentTypeData();
     _mapper = MapperField.GetMapper();
 }
Exemple #19
0
 /// <summary>
 /// This load a client using a valid executro.
 /// </summary>
 /// <param name="executor">Sql executor</param>
 public ClientDataLoader(ISqlExecutor executor)
 {
     _sqlExecutor        = executor;
     _mapper             = MapperField.GetMapper();
     _currentPoco        = new ClientDto();
     _currentPoco.Helper = new HelperBase();
     Valid              = true;
     _currentQueryPos   = 0;
     _queryStoreFactory = new QueryStoreFactory();
 }
 /// <summary>
 ///  Booking data access layer.
 /// </summary>
 /// <param name="executor">Executor handle database connection.</param>
 public BookingDataAccessLayer(ISqlExecutor executor, IConfigurationService service)
     : base(executor)
 {
     _mapper        = MapperField.GetMapper();
     _dataLoader    = new BookingDataLoader(SqlExecutor, _mapper);
     _dataDeleter   = new BookingDataDeleter(SqlExecutor, _mapper);
     _dataSaver     = new BookingDataSaver(SqlExecutor, _mapper);
     TableName      = "RESERVAS1";
     _configuration = service;
 }
Exemple #21
0
 public CommissionAgent(ISqlExecutor executor, string commissionId)
 {
     _executor                = executor;
     _currentComisio          = new COMISIO();
     _currentComisio.NUM_COMI = commissionId;
     _commissionAgents        = new List <COMISIO>();
     _nacioPer                = new List <Country>();
     _tipoComis               = new List <TIPOCOMI>();
     _provinces               = new List <PROVINCIA>();
     _commissionAgentType     = new CommissionAgentTypeData();
     _mapper = MapperField.GetMapper();
 }
Exemple #22
0
        public async Task <bool> SaveMagnifierSettings(GridSettingsDto settingsDto)
        {
            Contract.Requires(settingsDto != null);
            bool               value     = false;
            IMapper            mapper    = MapperField.GetMapper();
            GRID_SERIALIZATION serialize = mapper.Map <GridSettingsDto, GRID_SERIALIZATION>(settingsDto);

            Contract.Requires(serialize != null);
            value = await SaveOrUpdate(serialize).ConfigureAwait(false);

            return(value);
        }
        public async Task Should_Retrieve_ASortedClientPage()
        {
            Dictionary <string, ListSortDirection> direction = new Dictionary <string, ListSortDirection>
            {
                { "Name", ListSortDirection.Ascending },
                { "City", ListSortDirection.Descending }
            };

            IMapper mapper     = MapperField.GetMapper();
            var     sortedData = await _clientDataServices.GetSortedCollectionPagedAsync(direction, 1, 25);

            Assert.NotNull(sortedData);
            Assert.GreaterOrEqual(25, sortedData.Count());
        }
 /// <summary>
 /// ProviderInfoViewModel.
 /// </summary>
 /// <param name="eventManager"></param>
 /// <param name="configurationService"></param>
 /// <param name="dataServices"></param>
 /// <param name="dialogService"></param>
 /// <param name="manager"></param>
 /// <param name="controller"></param>
 public ProviderInfoViewModel(IEventManager eventManager, IConfigurationService configurationService,
                              IDataServices dataServices, IDialogService dialogService,
                              IRegionManager manager, IInteractionRequestController controller) : base(eventManager, configurationService, dataServices, dialogService, manager, controller)
 {
     ConfigurationService = configurationService;
     MailBoxHandler      += MessageHandler;
     AccountAssistQuery   = _accountAssistQuery;
     EventManager.RegisterObserverSubsystem(MasterModuleConstants.ProviderSubsystemName, this);
     // TODO: all the mapping shall be isolated.
     mapper = MapperField.GetMapper();
     _onBranchesPrimaryKey += ProviderInfoViewModel__onBranchesPrimaryKey;
     _onContactsPrimaryKey += ProviderInfoViewModel__onContactsPrimaryKey;
     _uniqueCounter++;
     _assistDataService = dataServices.GetAssistDataServices();
     SubSystem          = DataSubSystem.SupplierSubsystem;
     ViewModelUri       = new Uri("karve://supplier/viewmodel?id=" + Guid.ToString());
     InitVmCommands();
 }
        public async Task <ObservableCollection <GridSettingsDto> > GetMagnifierSettingByIds(List <long> registeredGridIds)
        {
            ObservableCollection <GRID_SERIALIZATION> settings = new ObservableCollection <GRID_SERIALIZATION>();

            Contract.Requires(registeredGridIds != null);
            using (var dbConnection = _executorSql.OpenNewDbConnection())
            {
                var dto = await dbConnection.GetAsyncAll <GRID_SERIALIZATION>();

                var first = dto.OrderBy(x => x.GRID_ID).ToList();
                foreach (var ids in registeredGridIds)
                {
                    settings.Add(first.FirstOrDefault(x => x.GRID_ID == ids));
                }
            }
            var outSettings = MapperField.GetMapper()
                              .Map <IEnumerable <GRID_SERIALIZATION>, ObservableCollection <GridSettingsDto> >(settings);

            return(outSettings);
        }
        public async Task Should_UpdateOrInsert_GridSerialized()
        {
            byte[]          currentBytes    = { 0x10, 0xFF, 0x23, 0x25, 0x23, 0x80 };
            var             base64          = Convert.ToBase64String(currentBytes);
            IMapper         mapper          = MapperField.GetMapper();
            GridSettingsDto gridSettingsDto = new GridSettingsDto();

            gridSettingsDto.GridIdentifier = 0x800;
            gridSettingsDto.GridName       = "Not known";
            gridSettingsDto.XmlBase64      = @"<grid></grid>";


            try
            {
                var serialize = mapper.Map <GridSettingsDto, GRID_SERIALIZATION>(gridSettingsDto);
                using (IDbConnection connection = _sqlExecutor.OpenNewDbConnection())
                {
                    using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
                    {
                        var value = false;
                        if (!connection.IsPresent <GRID_SERIALIZATION>(serialize))
                        {
                            value = await connection.InsertAsync <GRID_SERIALIZATION>(serialize) > 0;
                        }
                        else
                        {
                            value = await connection.UpdateAsync <GRID_SERIALIZATION>(serialize);
                        }
                        Assert.IsTrue(value);
                        scope.Complete();
                    }
                }
            }
            catch (Exception e)
            {
                var ex = e;
                Assert.Fail(ex.Message);
            }
            // nowe we have to assert this.
        }
Exemple #27
0
        protected override void InitializeShell()
        {
            // The main window and configuration services shall be injected just here
            // because in the configure container are not yet available.

            try
            {
                IConfigurationService shell = Container.Resolve <IConfigurationService>();
                shell.Shell = Application.Current.MainWindow;
                PropertyInfo info = shell.Shell.GetType().GetProperty("UnityContainer");
                if (info != null)
                {
                    info.SetValue(shell.Shell, Container);
                }
                Application.Current.MainWindow.Show();
                // we preload some heavy modules.
                // this is a trick to speed up further creations and load prism.
                //  Container.Resolve<ProviderInfoView>();
                //  Container.Resolve<CommissionAgentInfoView>();
                //  Container.Resolve<ClientsInfoView>();
                //  Container.Resolve<VehicleInfoView>();
                //  Container.Resolve<DriverLicenseView>();
                Container.Resolve <BookingModule.Views.BookingInfoView>();
                Container.Resolve <KarveControls.HeaderedWindow.LineGridView>();
                Container.Resolve <BookingModule.Views.BookingFooterView>();

                /*
                 * Resolve the view model. Kind of view model first approach. We can use a LineGridView
                 * for every kind of subject and for the specific.
                 *  This allows the reuse better than view.
                 */
                IMapper mapper = MapperField.GetMapper();
            } catch (Exception e)
            {
                logger.Error("Error during bootstrap:" + e.Message);
                MessageBox.Show("Error during bootstrap" + e.Message);
            }
        }
        /// <summary>
        /// Commision agent info view model.
        /// </summary>
        /// <param name="configurationService"></param>
        /// <param name="eventManager"></param>
        /// <param name="services"></param>
        /// <param name="dialogService"></param>
        /// <param name="regionManager"></param>
        /// <param name="controller"></param>
        public CommissionAgentInfoViewModel(IConfigurationService configurationService,
                                            IEventManager eventManager,
                                            IDataServices services,
                                            IDialogService dialogService,
                                            IRegionManager regionManager, IInteractionRequestController controller
                                            ) : base(eventManager,
                                                     configurationService,
                                                     services,
                                                     dialogService,

                                                     regionManager,
                                                     controller)
        {
            _queries    = new Dictionary <string, string>();
            _visibility = Visibility.Collapsed;
            _commissionAgentDataServices = DataServices.GetCommissionAgentDataServices();
            _regionManager         = regionManager;
            _onBranchesPrimaryKey += CommissionAgentInfoViewModel__onBranchesPrimaryKey;
            _onContactsPrimaryKey += CommissionAgentInfoViewModel__onContactsPrimaryKey;
            _onVisitPrimaryKey    += CommissionAgentInfoViewModel__onVisitPrimaryKey;
            IsVisible              = Visibility.Collapsed;
            AssistQueryDictionary  = new Dictionary <string, string>();
            PrimaryKeyValue        = string.Empty;
            ConfigurationService   = configurationService;
            InitEvents();
            InitCommands();
            ViewModelUri = new Uri("karve://broker/viewmodel?id=" + Guid.ToString());
            _mapper      = MapperField.GetMapper();
            EventManager.RegisterObserverSubsystem(MasterModuleConstants.CommissionAgentSystemName, this);
            // update the assist.
            UpdateAssist(ref _leftSideDualDfSearchBoxes);
            UpdateChangeCommand(ref _leftSideDualDfSearchBoxes);
            // register itself in the broacast.
            EventManager.RegisterObserver(this);
            _countTime = 0;
        }
Exemple #29
0
 public TestMappingData()
 {
     _mapper = MapperField.GetMapper();
 }
Exemple #30
0
 /// <summary>
 ///  Constructor for the sql deleter.
 /// </summary>
 /// <param name="executor">SqlExecutor to delete</param>
 public ClientDeleter(ISqlExecutor executor)
 {
     _mapper   = MapperField.GetMapper();
     _executor = executor;
 }