Exemple #1
0
 public object GetBUPACommissionByDate(FilterMapper filterMapper)
 {
     try
     {
         using (var db = new PERFECTIBSEntities())
         {
             var qry = (from tran in db.tblBankTransactionDetails
                        join cur in db.tblCurrencies on tran.currencyType equals cur.CurrencyID
                        join ag in db.tblAgents on tran.AgentID equals ag.AgentID
                        join cl in db.tblClients on tran.ClientID equals cl.ClientID
                        where tran.IsInvoiceTrf == 0 &&
                        tran.PaymentDate >= filterMapper.fromDate && tran.PaymentDate <= filterMapper.toDate
                        group tran by new { cur.CurrencyName, tran.currencyType, ag.AgentCode, tran.PaymentDate, cl.ClientName } into gr
                        select new CommissionDetailMapper
             {
                 AgentCode = gr.Key.AgentCode,
                 ClientName = gr.Key.ClientName,
                 PaidDate = gr.Key.PaymentDate,
                 CurrencyType = gr.Key.CurrencyName,
                 Amount = gr.Sum(s => s.AgentAmount),
                 CurrencyRate = 0,
             }).ToList();
             return(qry);
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemple #2
0
 public List <AgenCommissionMapper> GetBUPACommissionDetailByDate(FilterMapper filterMapper)
 {
     try
     {
         using (var db = new PERFECTIBSEntities())
         {
             var qry = (from tran in db.tblBankTransactionDetails
                        join cur in db.tblCurrencies on tran.currencyType equals cur.CurrencyID
                        join ag in db.tblAgents on tran.AgentID equals ag.AgentID
                        join cl in db.tblClients on tran.ClientID equals cl.ClientID
                        where tran.IsInvoiceTrf == 0 &&
                        tran.PaymentDate >= filterMapper.fromDate && tran.PaymentDate <= filterMapper.toDate
                        select new AgenCommissionMapper
             {
                 AgentCode = ag.AgentCode.Trim(),
                 PaymentDate = tran.PaymentDate,
                 Amount = tran.Amount,
                 CurrencyType = cur.CurrencyName,
                 CurrencyRate = 0,
             }).ToList();
             return(qry);
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemple #3
0
        public bool UpdateFilter(ApiFilter filter)
        {
            var dalFilter = FilterMapper.ConvertToDALEntity(filter);
            var id        = Update(dalFilter, FilterAdapter);

            return(true);
        }
Exemple #4
0
        public async Task <OrdersModel> GetUserOrdersAsync(OrdersFilterModel model, long id)
        {
            var response = new OrdersModel();

            if (id == 0)
            {
                response.Errors.Add(ErrorConstants.ModelIsNull);
                return(response);
            }
            var filterModel = FilterMapper.MapOrdersFilteringModel(model);
            var orders      = await _orderRepository.GetByUserIdAsync(filterModel, id);

            if (orders == null)
            {
                response.Errors.Add(ErrorConstants.ImpossibleToFindOrder);
                return(response);
            }
            var responceOrders = new OrdersModel();

            foreach (var order in orders.Data)
            {
                var orderItemModel = OrderMapper.MapResponseModelToModelItem(order);
                responceOrders.Items.Add(orderItemModel);
            }
            responceOrders.TotalCount = orders.TotalItemsCount;
            return(responceOrders);
        }
 public IEnumerable <RenewalListMapper> GetClientExpireInfo(FilterMapper filterMapper)
 {
     try
     {
         using (var db = new PERFECTIBSEntities())
         {
             var qry = (from crh in db.tblClientRequestHeaders
                        join c in db.tblClients on crh.ClientID equals c.ClientID
                        where filterMapper.fromDate <= crh.PolicyEnd && filterMapper.toDate >= crh.PolicyEnd
                        select new RenewalListMapper
             {
                 ClientId = c.ClientID,
                 ClientName = c.ClientName,
                 ContactNo = c.ContactNo,
                 Address = c.ClientAddress,
                 ExpirationDate = crh.PolicyEnd,
             }).ToList();
             return(qry);
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemple #6
0
        public async Task <PrintingEditionsModel> GetAllAsync(PrintingEditionsFilterModel model)
        {
            var response = new PrintingEditionsModel();

            if (model == null)
            {
                response.Errors.Add(ErrorConstants.ModelIsNull);
            }
            var filterModel      = FilterMapper.MapPrintingEditionsFilteringModel(model);
            var printingEditions = await _authorInPrintingEditionsRepository.GetFilteredPrintingEditionsAsync(filterModel);

            if (printingEditions == null)
            {
                response.Errors.Add(ErrorConstants.ImpossibleToFindProduct);
                return(response);
            }
            var products = new PrintingEditionsModel();

            foreach (var printingEdition in printingEditions.Data)
            {
                var convertedPrice           = _currencyConverter.Convert(CurrencyEnum.Currency.USD, model.Currency, printingEdition.PrintingEdition.Price);
                var printingEditionItemModel = PrintingEditionMapper.MapProductResponseModelToModelItem(printingEdition, model.Currency, convertedPrice);
                products.Items.Add(printingEditionItemModel);
            }
            products.TotalCount = printingEditions.TotalItemsCount;
            return(products);
        }
        public void WhenSetNullConditionThenSetBothConditionToNull()
        {
            var hbmFilter = new HbmFilter();
            var mapper    = new FilterMapper("MyFilter", hbmFilter);

            mapper.Condition(null);
            hbmFilter.condition.Should().Be.Null();
            hbmFilter.Text.Should().Be.Null();
        }
        public void WhenSetSingleLineConditionThenSetSimpleCondition()
        {
            var hbmFilter = new HbmFilter();
            var mapper    = new FilterMapper("MyFilter", hbmFilter);

            mapper.Condition("aFiled = :aParameter");
            hbmFilter.condition.Should().Be("aFiled = :aParameter");
            hbmFilter.Text.Should().Be.Null();
        }
        public void WhenSetMultiLineConditionThenResetSimpleCondition()
        {
            var hbmFilter = new HbmFilter();
            var mapper    = new FilterMapper("MyFilter", hbmFilter);

            mapper.Condition("aFiled = :aParameter");
            mapper.Condition("aFiled = :aParameter" + Environment.NewLine + "AND anotherField = :anotherParam");
            hbmFilter.condition.Should().Be.Null();
            hbmFilter.Text.Should().Have.SameSequenceAs("aFiled = :aParameter", "AND anotherField = :anotherParam");
        }
        public void WhenSetSingleLineConditionThenResetTextCondition()
        {
            var hbmFilter = new HbmFilter();
            var mapper    = new FilterMapper("MyFilter", hbmFilter);

            mapper.Condition("aFiled = :aParameter" + Environment.NewLine + "AND anotherField = :anotherParam");
            mapper.Condition("aFiled = :aParameter");
            mapper.Condition("aFiled = :aParameter");
            hbmFilter.Text.Should().Be.Null();
        }
        public void WhenSetEmptyConditionThenSetBothConditionToNull()
        {
            var hbmFilter = new HbmFilter();
            var mapper    = new FilterMapper("MyFilter", hbmFilter);

            mapper.Condition(string.Empty);
            hbmFilter.condition.Should().Be.Null();
            hbmFilter.Text.Should().Be.Null();

            mapper.Condition("    ");
            hbmFilter.condition.Should().Be.Null();
            hbmFilter.Text.Should().Be.Null();
        }
Exemple #12
0
        public AmountMapper GetBupaAmount(FilterMapper map)
        {
            try
            {
                using (var db = new PERFECTIBSEntities())
                {
                    var custCode = (from b in db.tblBussinessUnits
                                    where b.BussinessUnit == "BUPA"
                                    select new
                    {
                        b.ERPCustomerCode,
                    }).FirstOrDefault();

                    int[] ids = db.tblBankTransactionDetails.Where(t => t.IsInvoiceTrf == 0).Select(t => t.BankDetailID).ToArray();

                    var qry = (from tran in db.tblBankTransactionDetails
                               join cur in db.tblCurrencies on tran.currencyType equals cur.CurrencyID
                               where tran.IsInvoiceTrf == 0 && tran.PaymentDate >= map.fromDate && tran.PaymentDate <= map.toDate
                               group tran by new { cur.CurrencyName, tran.currencyType } into gr
                               select new AmountDetailMapper
                    {
                        CurrencyType = gr.Key.CurrencyName,
                        Amount = gr.Sum(s => s.IBSAmount),
                        CurrencyRate = 0,
                        AgentCode = custCode.ERPCustomerCode,
                    }).AsQueryable();

                    qry = qry.Where(q => q.Amount > 0).AsQueryable();
                    if (map != null)
                    {
                        if (map.type != null)
                        {
                            if (map.type != "0")
                            {
                                qry = qry.Where(q => q.CurrencyType == map.type).AsQueryable();
                            }
                        }
                    }

                    AmountMapper mapper = new AmountMapper();
                    mapper.Ids = ids;
                    mapper.AmountDetailMappers = new List <AmountDetailMapper>();
                    mapper.AmountDetailMappers.AddRange(qry.ToList());
                    return(mapper);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
        public object GetAgentCommission(FilterMapper map)
        {
            try
            {
                AgenCommissionRootMapper mapper = new AgenCommissionRootMapper();
                using (var db = new PERFECTIBSEntities())
                {
                    mapper.Ids = db.tblBankTransactionDetails.Where(t => t.IsAgentTrf == 0).Select(t => t.BankDetailID).ToArray();


                    var qry = (from tran in db.tblBankTransactionDetails
                               join cur in db.tblCurrencies on tran.currencyType equals cur.CurrencyID
                               join ag in db.tblAgents on tran.AgentID equals ag.AgentID
                               where tran.IsAgentTrf == 0 && tran.PaymentDate >= map.fromDate && tran.PaymentDate <= map.toDate
                               //    group tran by new { cur.CurrencyName, tran.currencyType, ag.AgentCode } into gr
                               select new AgenCommissionMapper
                    {
                        //CurrencyType = gr.Key.CurrencyName,
                        //Amount = gr.Sum(s => s.AgentAmount),
                        //CurrencyRate = 0,
                        //AgentCode = gr.Key.AgentCode
                        PaymentDate = tran.PaymentDate,
                        CurrencyType = cur.CurrencyName,
                        Amount = tran.AgentAmount,
                        CurrencyRate = 0,
                        AgentCode = ag.AgentCode,
                    }).AsQueryable();

                    qry = qry.Where(q => q.Amount > 0).AsQueryable();
                    if (map.type != null)
                    {
                        if (map.type != "0")
                        {
                            qry = qry.Where(q => q.CurrencyType == map.type).AsQueryable();
                        }
                    }
                    mapper.AgenCommissionMappers = new List <AgenCommissionMapper>();

                    mapper.AgenCommissionMappers.AddRange(qry.ToList());
                    return(mapper);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #14
0
        public ApiAdapter(IDataBaseManagerFactory dbEngine, string address, string port, string table, string login, string password)
        {
            DbManager   = new DatabaseManager(dbEngine, address, port, table, login, password);
            DbConnector = new DbConnector(DbManager);

            LanguageAdapter                = new LanguageAdapter(DbConnector);
            UserAdapter                    = new UserAdapter(DbConnector);
            UserDetailsAdapter             = new UserDetailsAdapter(DbConnector);
            TransactionTypeAdapter         = new TransactionTypeAdapter(DbConnector);
            TransferTypeAdapter            = new TransferTypeAdapter(DbConnector);
            FrequencyAdapter               = new FrequencyAdapter(DbConnector);
            ImportanceAdapter              = new ImportanceAdapter(DbConnector);
            TagAdapter                     = new TagAdapter(DbConnector);
            OperationAdapter               = new OperationAdapter(DbConnector);
            OperationDetailsAdapter        = new OperationDetailsAdapter(DbConnector);
            OperationTagRelationAdapter    = new OperationTagAdapter(DbConnector);
            OperationsGroupAdapter         = new OperationsGroupAdapter(DbConnector);
            OperationsGroupRelationAdapter = new OperationsGroupTagAdapter(DbConnector);
            FilterAdapter                  = new FilterAdapter(DbConnector);
            DashboardAdapter               = new DashboardAdapter(DbConnector);
            DashboardFilterRelationAdapter = new DashboardFilterRelationAdapter(DbConnector);
            BankAdapter                    = new BankAdapter(DbConnector);
            SettingsAdapter                = new SettingsAdapter(DbConnector);
            SchematicTypeAdapter           = new SchematicTypeAdapter(DbConnector);
            SchematicAdapter               = new SchematicAdapter(DbConnector);

            LanguageMapper        = new LanguageMapper();
            UserMapper            = new UserMapper();
            UserDetailsMapper     = new UserDetailsMapper();
            TransactionTypeMapper = new TransactionTypeMapper();
            TransferTypeMapper    = new TransferTypeMapper();
            FrequencyMapper       = new FrequencyMapper();
            ImportanceMapper      = new ImportanceMapper();
            TagMapper             = new TagMapper();
            TagRelationMapper     = new RelationTagMapper();
            OperationMapper       = new OperationMapper();
            OperationsGroupMapper = new OperationsGroupMapper();
            FilterMapper          = new FilterMapper();
            DashboardMapper       = new DashboardMapper();
            DashboardFilterMapper = new DashboardFilterMapper();
            BankMapper            = new BankMapper();
            SettingsMapper        = new SettingsMapper();
            SchematicTypeMapper   = new SchematicTypeMapper();
            SchematicMapper       = new SchematicMapper();
        }
Exemple #15
0
        public async Task <AuthorsModel> GetAllAsync(AuthorsFilteringModel model)
        {
            var authorModel = new AuthorsModel();
            var filterModel = FilterMapper.MapAuthorsFilteringModel(model);
            var authors     = await _authorRepository.GetFilteredAsync(filterModel);

            if (authors == null || !authors.Data.Any())
            {
                authorModel.Errors.Add(ErrorConstants.ImpossibleToFindAuthor);
            }
            foreach (var author in authors.Data)
            {
                var resultModel = AuthorMapper.MapResponseModelToModelItem(author);
                authorModel.Items.Add(resultModel);
            }
            authorModel.TotalCount = authors.TotalItemsCount;
            return(authorModel);
        }
Exemple #16
0
        public async Task <UserModel> GetAllAsync(UsersFilterModel model, long adminId)
        {
            var response = new UserModel();

            if (model == null)
            {
                response.Errors.Add(ErrorConstants.ModelIsNull);
                return(response);
            }
            var filterModel      = FilterMapper.MapUserFilteringModel(model);
            var applicationUsers = await _userRepository.GetFilteredAsync(filterModel, adminId);

            var users = new UserModel();

            foreach (var user in applicationUsers.Data)
            {
                var userModelItem = await UpdateStatus(user);

                users.Items.Add(userModelItem);
            }
            users.TotalCount = applicationUsers.TotalItemsCount;
            return(users);
        }
Exemple #17
0
 public List <ApiFilter> GetFilters(ApiUser user)
 {
     FilterMapper.Update(user);
     return(FilterMapper.ConvertToApiEntitiesCollection(FilterAdapter.GetAll($"user_id={user.Id}")).ToList());
 }