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);
}
////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)
{
}
public StampChargeRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public TillLimitSetupRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public BankDraftSetupRepository(TheCoreBankingRetailContext context) : base(context)
{
}
/// <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)
{
}
public ChequeChargesRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public InwardBankChequeRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public GrantReversalPrivilegeRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public ChartofAccountRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public ChequeBookTypeRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public TellerCloseLimitSetupRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public TillTypeRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public APIStubRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public ReversalSetupRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public TransferChargesRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public FinanceCounterpartyTransactionRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public TillFunctionRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public StaffInformaionRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public RetailOperationRepository(TheCoreBankingRetailContext context) : base(context)
{
}
public SingleFundTransferRepository(TheCoreBankingRetailContext context) : base(context)
{
}
