public EFRepository(TheCoreBankingRetailContext context)
 {
     if (context == null)
     {
         throw new ArgumentNullException("context");
     }
     Context = context;
     dbSet   = Context.Set <T>();
 }
        //For Stored Procedure
        public decimal SPGLBalance(string accountNo)
        {
            var GLBalance = new GLBalance();

            using (var context = new TheCoreBankingRetailContext())
            {
                SqlParameter AcctNo = new SqlParameter("@AccountID", accountNo);

                GLBalance = context.GLBalance.FromSql("General.GetGLBalance2 @AccountID", AcctNo).Single();
            }
            return(GLBalance.GLBalances);
        }
Пример #3
0
        ////For Stored Procedure
        public bool SPGLBalance(string AccountId)
        {
            var result = false;

            using (var context = new TheCoreBankingRetailContext())
            {
                SqlParameter ProductAcctNo = new SqlParameter("@AccountID", AccountId);

                context.Database.ExecuteSqlCommand("General.GetGLBalance @AccountID", ProductAcctNo);
                result = true;
            }
            return(result);
        }
        //Stored procedure got Loan Disbursement
        public bool SingleFundTransfer(string accountDr, string accountCr, decimal amount, string comment, string refNo = null)
        {
            var result = false;

            using (var context = new TheCoreBankingRetailContext())
            {
                SqlParameter AccountDr   = new SqlParameter("@AccountDr", accountDr);
                SqlParameter AccountCr   = new SqlParameter("@AccountCr", accountCr);
                SqlParameter Amount      = new SqlParameter("@Amount", amount);
                SqlParameter NarrationCr = new SqlParameter("@NarrationCr", comment);
                SqlParameter Reference   = new SqlParameter("@Reference", refNo);
                context.Database.ExecuteSqlCommand("InsertFundTransfer @AccountDr,@AccountCr,@Amount,@NarrationCr,@Reference", AccountDr, AccountCr, Amount, NarrationCr, Reference);
                result = true;
            }

            return(result);
        }
 public BankingoperationtypeRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public TellerloginRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #7
0
 public StampChargeRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public TillLimitSetupRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public BankDraftSetupRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #10
0
        /// <summary>Make a repository of type T.</summary>
        /// <typeparam name="T">Type of repository to make.</typeparam>
        /// <param name="dbContext">
        /// The <see cref="DbContext"/> with which to initialize the repository.
        /// </param>
        /// <param name="factory">
        /// Factory with <see cref="DbContext"/> argument. Used to make the repository.
        /// If null, gets factory from <see cref="_repositoryFactories"/>.
        /// </param>
        /// <returns></returns>
        protected virtual T MakeRepository <T>(Func <TheCoreBankingRetailContext, object> factory, TheCoreBankingRetailContext dbContext)
        {
            var f = factory ?? _repositoryFactories.GetRepositoryFactory <T>();

            if (f == null)
            {
                throw new NotImplementedException("No factory for repository type, " + typeof(T).FullName);
            }
            var repo = (T)f(dbContext);

            Repositories[typeof(T)] = repo;
            return(repo);
        }
 public ChequeLeavesDetailRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #12
0
 public ChequeChargesRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #13
0
 public InwardBankChequeRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public GrantReversalPrivilegeRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #15
0
 public ChartofAccountRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public ChequeBookTypeRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public TellerCloseLimitSetupRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public TillTypeRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #19
0
 public APIStubRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public ReversalSetupRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #21
0
 public TransferChargesRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public FinanceCounterpartyTransactionRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public TillFunctionRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
Пример #24
0
 public StaffInformaionRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public RetailOperationRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }
 public SingleFundTransferRepository(TheCoreBankingRetailContext context) : base(context)
 {
 }