Example #1
0
        public async void SaveAccount_AccountSavedAndLoaded()
        {
            // Arrange
            AccountEntity testAccount;

            using (var dbContextScope = dbContextScopeFactory.Create())
            {
                using (var dbContext = ambientDbContextLocator.Get <ApplicationContext>())
                {
                    testAccount = new AccountEntity {
                        Name = "testAccount"
                    };
                    dbContext.Accounts.Add(testAccount);
                    await dbContextScope.SaveChangesAsync();
                }
            }

            var paymentService = new PaymentService(ambientDbContextLocator, dbContextScopeFactory);

            var testEntry = new Payment(new PaymentEntity
            {
                ChargedAccount = testAccount
            });

            // Act
            await paymentService.SavePayments(testEntry);

            // Assert
            Assert.Equal(testEntry.Data.Amount, (await paymentService.GetById(testEntry.Data.Id)).Data.Amount);
        }
        public OperationResponse <AppUserRoleUpdateCommandOutputDTO> Update(AppUserRoleUpdateCommandInputDTO input)
        {
            var result    = new OperationResponse <AppUserRoleUpdateCommandOutputDTO>();
            var dbLocator = AmbientDbContextLocator.Get <IdentityDBContext>();
            {
                var entity = dbLocator.Set <IdentityRole>().FirstOrDefault(o => o.Id == input.Id);
                if (entity != null)
                {
                    entity.Id             = input.Id;
                    entity.Name           = input.Name;
                    entity.NormalizedName = input.NormalizedName;
                }

                dbLocator.SaveChanges();


                var dbResult = dbLocator.Set <IdentityRole>().Where(o => o.Id == entity.Id).Select(o => new AppUserRoleUpdateCommandOutputDTO
                {
                    Id             = o.Id,
                    Name           = o.Name,
                    NormalizedName = o.NormalizedName,
                }).FirstOrDefault();

                result.Bag = dbResult;
                return(result);
            }
        }
        public OperationResponse <AppUserRoleInsertCommandOutputDTO> Insert(AppUserRoleInsertCommandInputDTO input)
        {
            var result = new OperationResponse <AppUserRoleInsertCommandOutputDTO>();

            try
            {
                var entity = new IdentityRole
                {
                    Id             = input.Id,
                    Name           = input.Name,
                    NormalizedName = input.NormalizedName,
                };

                var dbLocator = AmbientDbContextLocator.Get <IdentityDBContext>();
                {
                    dbLocator.Add(entity);
                    dbLocator.SaveChanges();

                    var dto = dbLocator.Set <IdentityRole>().Where(o => o.Id == entity.Id).Select(o => new AppUserRoleInsertCommandOutputDTO
                    {
                        Id             = o.Id,
                        Name           = o.Name,
                        NormalizedName = o.NormalizedName,
                    }).FirstOrDefault();

                    result.Bag = dto;
                }
            }
            catch (Exception ex)
            {
                result.AddException(null, ex);
            }

            return(result);
        }
        public OperationResponse <IEnumerable <IdentityRoleClaim <string> > > GetPermissionsByRoleId(string id)
        {
            var result = new OperationResponse <IEnumerable <IdentityRoleClaim <string> > >();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    //result.Bag = dbLocator.Set<IdentityRole>().Where(o => o.Id == id).FirstOrDefault();.Select(entityItem => new AppUserRoleGetByIdCommandOutputDTO
                    //{
                    //    Id = entityItem.Id,
                    //    Name = entityItem.Name,
                    //    NormalizedName = entityItem.NormalizedName,
                    //}).FirstOrDefault();

                    result.Bag = dbLocator.Set <IdentityRoleClaim <string> >().Where(roleClaim => roleClaim.RoleId == id && roleClaim.ClaimType == "per").Select(roleClaim => roleClaim /*new AppUserRoleGetByIdCommandOutputPermissionDTO
                                                                                                                                                                                         * {
                                                                                                                                                                                         * RoleId = roleClaim.RoleId,
                                                                                                                                                                                         * PermissionId = roleClaim.ClaimValue,
                                                                                                                                                                                         * }*/).ToList();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error Geting User {id}", ex);
            }

            return(result);
        }
Example #5
0
        public OperationResponse <IEnumerable <IdentityRole> > GetRolesByUserId(string id)
        {
            var result = new OperationResponse <IEnumerable <IdentityRole> >();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    //result.Bag = dbLocator.Set<IdentityRole>().Where(o => o.Id == id).FirstOrDefault();.Select(entityItem => new AppUserRoleGetByIdCommandOutputDTO
                    //{
                    //    Id = entityItem.Id,
                    //    Name = entityItem.Name,
                    //    NormalizedName = entityItem.NormalizedName,
                    //}).FirstOrDefault();

                    result.Bag = dbLocator.Set <IdentityUserRole <string> >().Where(userRole => userRole.UserId == id).Join(dbLocator.Set <IdentityRole>(), userRole => userRole.RoleId, role => role.Id, (userRole, role) => role /* new AppUserRoleGetByIdCommandOutputUserDTO
                                                                                                                                                                                                                                    * {
                                                                                                                                                                                                                                    * Id = user.Id,
                                                                                                                                                                                                                                    * RoleId = userRole.RoleId,
                                                                                                                                                                                                                                    * UserId = user.Id
                                                                                                                                                                                                                                    * }*/).ToList();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error Geting User {id}", ex);
            }

            return(result);
        }
Example #6
0
        /// <summary>
        ///     Initializes this instance.
        /// </summary>
        public override async void Initialize()
        {
            var dbContextScopeFactory = new DbContextScopeFactory();
            var ambientDbContextLocator = new AmbientDbContextLocator();

            using (dbContextScopeFactory.Create())
            {
                await ambientDbContextLocator.Get<ApplicationContext>().Database.MigrateAsync();
            }

            if (Mvx.Resolve<Session>().ValidateSession())
            {
                if (CurrentPlatform == AppPlatform.UWP)
                {
                    RegisterAppStart<AccountListViewModel>();
                }
                else
                {
                    RegisterAppStart<MainViewModel>();
                }
            } else
            {
                RegisterAppStart<LoginViewModel>();
            }
        }
Example #7
0
        public OperationResponse <CustomerThirdPartyAppSettingInsertCommandOutputDTO> Insert(CustomerThirdPartyAppSettingInsertCommandInputDTO input)
        {
            var result = new OperationResponse <CustomerThirdPartyAppSettingInsertCommandOutputDTO>();
            var entity = new CustomerThirdPartyAppSetting
            {
                CustomerId           = input.CustomerId,
                ThirdPartyAppTypeId  = input.ThirdPartyAppTypeId,
                ThirdPartyCustomerId = input.ThirdPartyCustomerId,
            };

            var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
            {
                dbLocator.Add(entity);
                dbLocator.SaveChanges();

                var dbResult = dbLocator.Set <CustomerThirdPartyAppSetting>().Where(o => o.Id == entity.Id).Select(o => new CustomerThirdPartyAppSettingInsertCommandOutputDTO
                {
                    Id                   = o.Id,
                    CustomerId           = o.CustomerId,
                    CustomerName         = o.Customer.Name,
                    ThirdPartyAppTypeId  = o.ThirdPartyAppTypeId,
                    ThirdPartyCustomerId = o.ThirdPartyCustomerId,
                }).FirstOrDefault();

                result.Bag = dbResult;

                return(result);
            }
        }
Example #8
0
        public OperationResponse <IEnumerable <CustomerFreightout> > GetAll()
        {
            var result = new OperationResponse <IEnumerable <CustomerFreightout> >();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    result.Bag = dbLocator.Set <CustomerFreightout>().AsEnumerable() /*.Select(entityItem => new CustomerFreightoutGetAllCommandOutputDTO
                                                                                      * {
                                                                                      * Id = entityItem.Id,
                                                                                      * Cost = entityItem.Cost,
                                                                                      * CustomerFreightoutRateTypeId = entityItem.CustomerFreightoutRateTypeId,
                                                                                      * CustomerId = entityItem.CustomerId,
                                                                                      * DateFrom = entityItem.DateFrom,
                                                                                      * DateTo = entityItem.DateTo,
                                                                                      * SecondLeg = entityItem.SecondLeg,
                                                                                      * SurchargeHourly = entityItem.SurchargeHourly,
                                                                                      * SurchargeYearly = entityItem.SurchargeYearly,
                                                                                      * WProtect = entityItem.WProtect,
                                                                                      * }).ToList()*/;
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting all customer freightout", ex);
            }

            return(result);
        }
Example #9
0
        public void TestDbContextScopeWorks()
        {
            using var context = DbContextScopeFactory.CreateReadOnly();
            var moviesContext = AmbientDbContextLocator.Get <MoviesContext>();

            Assert.IsNotNull(moviesContext.Movies.Find(TestMovieSeededWithoutRelatedInfo.Id));
        }
Example #10
0
        public override async Task Startup()
        {
            var dbContextScopeFactory   = new DbContextScopeFactory();
            var ambientDbContextLocator = new AmbientDbContextLocator();

            using (dbContextScopeFactory.Create())
            {
                await ambientDbContextLocator.Get <ApplicationContext>().Database.MigrateAsync();
            }
        }
Example #11
0
        public OperationResponse Insert(ProductMedia input)
        {
            var result = new OperationResponse <ProductMediaInsertCommandOutputDTO>();

            var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();

            dbLocator.Add(input);

            return(result);
        }
Example #12
0
        /// <summary>
        ///     Initializes this instance.
        /// </summary>
        public override async void Initialize()
        {
            var dbContextScopeFactory   = new DbContextScopeFactory();
            var ambientDbContextLocator = new AmbientDbContextLocator();

            using (dbContextScopeFactory.Create())
            {
                await ambientDbContextLocator.Get <ApplicationContext>().Database.MigrateAsync();
            }

            RegisterAppStart(new AppStart());
        }
Example #13
0
        /// <summary>
        ///     Setup Logic who is executed before every test
        /// </summary>
        public CategoryServiceTests()
        {
            ApplicationContext.DbPath = Path.Combine(AppContext.BaseDirectory, DatabaseConstants.DB_NAME);
            Dispose();

            dbContextScopeFactory   = new DbContextScopeFactory();
            ambientDbContextLocator = new AmbientDbContextLocator();

            using (dbContextScopeFactory.Create())
            {
                ambientDbContextLocator.Get <ApplicationContext>().Database.Migrate();
            }
        }
Example #14
0
        public OperationResponse <CustomerFreightoutUpdateCommandOutputDTO> Update(CustomerFreightoutUpdateCommandInputDTO input)
        {
            var result = new OperationResponse <CustomerFreightoutUpdateCommandOutputDTO>();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    var entity = dbLocator.Set <CustomerFreightout>().FirstOrDefault(o => o.Id == input.Id);
                    if (entity != null)
                    {
                        entity.Cost = input.Cost;
                        entity.CustomerFreightoutRateTypeId = input.CustomerFreightoutRateTypeId;
                        entity.CustomerId      = input.CustomerId;
                        entity.DateFrom        = input.DateFrom;
                        entity.DateTo          = input.DateTo;
                        entity.SecondLeg       = input.SecondLeg;
                        entity.SurchargeHourly = input.SurchargeHourly;
                        entity.SurchargeYearly = input.SurchargeYearly;
                        entity.WProtect        = input.WProtect;
                    }

                    dbLocator.SaveChanges();


                    var dbResult = dbLocator.Set <CustomerFreightout>().Where(o => o.Id == entity.Id).Select(o => new CustomerFreightoutUpdateCommandOutputDTO
                    {
                        Id           = o.Id,
                        CustomerId   = o.CustomerId,
                        CustomerName = o.Customer.Name,
                        Cost         = o.Cost,
                        CustomerFreightoutRateTypeId = o.CustomerFreightoutRateTypeId,
                        DateFrom        = o.DateFrom,
                        DateTo          = o.DateTo,
                        SecondLeg       = o.SecondLeg,
                        SurchargeHourly = o.SurchargeHourly,
                        SurchargeYearly = o.SurchargeYearly,
                        WProtect        = o.WProtect,
                    }).FirstOrDefault();
                    result.Bag = dbResult;

                    return(result);
                }
            }
            catch (Exception ex)
            {
            }

            return(result);
        }
        public OperationResponse Add(Product entity)
        {
            var result = new OperationResponse();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <FunzaDBContext>();
                dbLocator.Add(entity);
            }
            catch (Exception ex)
            {
                result.AddException($"Error adding Funza Product", ex);
            }

            return(result);
        }
        public OperationResponse <DomainModel.Product.AbstractProduct> GetByIdWithMedias(int id)
        {
            var result = new OperationResponse <DomainModel.Product.AbstractProduct>();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                result.Bag = dbLocator.Set <AbstractProduct>().Include(t => t.ProductMedias).Where(o => o.Id == id).FirstOrDefault();
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting Product {id}", ex);
            }

            return(result);
        }
Example #17
0
        public OperationResponse <Grower> GetById(int id)
        {
            var result = new OperationResponse <Grower>();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                result.Bag = dbLocator.Set <Grower>().Where(o => o.Id == id).FirstOrDefault();
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting Grower {id}", ex);
            }

            return(result);
        }
Example #18
0
        public OperationResponse Insert(ProductCategory entity)
        {
            var result = new OperationResponse();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                dbLocator.Add(entity);
            }
            catch (Exception ex)
            {
                result.AddException($"Error adding customer freightout", ex);
            }

            return(result);
        }
        public OperationResponse Add(ColorReference entity)
        {
            var result = new OperationResponse();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                dbLocator.Add(entity);
            }
            catch (Exception ex)
            {
                result.AddException($"Error adding Funza Color", ex);
            }

            return(result);
        }
Example #20
0
        public OperationResponse Insert(SampleBox entity)
        {
            var result = new OperationResponse();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                dbLocator.Add(entity);
            }
            catch (Exception ex)
            {
                result.AddException($"Error adding Sample Box ", ex);
            }

            return(result);
        }
        public OperationResponse Insert(CompositionProductBridge entity)
        {
            var result = new OperationResponse();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                dbLocator.Add(entity);
            }
            catch (Exception ex)
            {
                result.AddException($"Error adding Product Bridge", ex);
            }

            return(result);
        }
Example #22
0
        public OperationResponse <SampleBox> GetByIdWithMedias(int id)
        {
            var result = new OperationResponse <SampleBox>();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                result.Bag = dbLocator.Set <SampleBox>() /*.Include(t => t.ProductMedias)*/.Where(o => o.Id == id).FirstOrDefault();
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting Sample Box  {id}", ex);
            }

            return(result);
        }
        /// <summary>
        ///     Setup Logic who is executed before every test
        /// </summary>
        public PaymentRepositoryTests()
        {
            ApplicationContext.DbPath = Path.Combine(AppContext.BaseDirectory, DatabaseConstants.DB_NAME);

            dbContextScopeFactory   = new DbContextScopeFactory();
            ambientDbContextLocator = new AmbientDbContextLocator();

            using (dbContextScopeFactory.Create())
            {
                ambientDbContextLocator.Get <ApplicationContext>().Database.Migrate();
            }
            using (var db = new ApplicationContext())
            {
                db.Database.Migrate();
            }
        }
        public OperationResponse <DomainModel.SaleOpportunity.SaleOpportunity> GetById(int id)
        {
            var result = new OperationResponse <DomainModel.SaleOpportunity.SaleOpportunity>();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    result.Bag = dbLocator.Set <SaleOpportunity>().Where(o => o.Id == id).FirstOrDefault();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting SaleOpportunity {id}", ex);
            }

            return(result);
        }
Example #25
0
        public OperationResponse <IEnumerable <SampleBox> > GetAll()
        {
            var result = new OperationResponse <IEnumerable <SampleBox> >();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    result.Bag = dbLocator.Set <SampleBox>().AsEnumerable();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting all Product ", ex);
            }

            return(result);
        }
        public OperationResponse <IEnumerable <ColorReference> > GetAll()
        {
            var result = new OperationResponse <IEnumerable <DomainModel.Funza.ColorReference> >();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    result.Bag = dbLocator.Set <DomainModel.Funza.ColorReference>().AsEnumerable();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting all Funza Colors", ex);
            }

            return(result);
        }
        public OperationResponse <Product> GetByFunzaId(int id)
        {
            var result = new OperationResponse <Product>();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <FunzaDBContext>();
                {
                    result.Bag = dbLocator.Set <Product>().Where(o => o.FunzaId == id).FirstOrDefault();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting Funza Product {id}", ex);
            }

            return(result);
        }
        public OperationResponse <IEnumerable <Product> > GetAll()
        {
            var result = new OperationResponse <IEnumerable <DomainModel.Product> >();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <FunzaDBContext>();
                {
                    result.Bag = dbLocator.Set <DomainModel.Product>().AsEnumerable();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting all Funza Products", ex);
            }

            return(result);
        }
        public OperationResponse <ColorReference> GetByFunzaId(string id)
        {
            var result = new OperationResponse <ColorReference>();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    result.Bag = dbLocator.Set <ColorReference>().Where(o => o.FunzaId == id).FirstOrDefault();
                }
            }
            catch (Exception ex)
            {
                result.AddException($"Error getting Funza Color {id}", ex);
            }

            return(result);
        }
Example #30
0
        public OperationResponse <IEnumerable <ProductCategory> > GetAll()
        {
            var result = new OperationResponse <IEnumerable <ProductCategory> >();

            try
            {
                var dbLocator = AmbientDbContextLocator.Get <RiverdaleDBContext>();
                {
                    result.Bag = dbLocator.Set <ProductCategory>().AsEnumerable();
                }
            }
            catch (Exception ex)
            {
                result.AddError("Error GetAll ProductCategory", ex);
            }

            return(result);
        }