//Banking Details
public static bool SaveBankingDetails(EvolutionRepository.Models.BankAccount bankAcc)
{
var Result = false;
try
{
using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
{
ctx.Database.ExecuteSqlCommand("evo_BankAccountsSave @OrganisationID,@AccountHolder,@AccountNumber,@BankID,@Branch,@BranchCode,@AccountTypeID",
new SqlParameter("@OrganisationID", bankAcc.OrganisationID),
new SqlParameter("@AccountHolder", bankAcc.AccountHolder),
new SqlParameter("@AccountNumber", bankAcc.AccountNumber),
new SqlParameter("@BankID", bankAcc.BankID),
new SqlParameter("@Branch", bankAcc.Branch),
new SqlParameter("@BranchCode", bankAcc.BranchCode),
new SqlParameter("@AccountTypeID", bankAcc.AccountTypeID)
);
}
Result = true;
}
catch (Exception ex)
{
Result = false;
throw ex;
}
return(Result);
}
public static EvolutionRepository.Models.BankAccount GetOrganisationBankingDetails(int OrganisationId)
{
using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
{
EvolutionRepository.Models.BankAccount bankAccounts = new EvolutionRepository.Models.BankAccount();
bankAccounts = ctx.Database.SqlQuery <EvolutionRepository.Models.BankAccount>("evo_GetOrganisationBankAccounts @OrganisationId",
new SqlParameter("@OrganisationID", OrganisationId)).FirstOrDefault();
return(bankAccounts);
}
}
