//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); } }