} // Map function closer public List <SqlParameter> MapParamsForUpsert(CompanyData entity) => new List <SqlParameter> { BuildParam("@company_key", entity.CompanyKey), BuildParam("@company_code", entity.CompanyCode), BuildParam("@company_name", entity.CompanyName), BuildParam("@company_desc", entity.CompanyDesc), GetOutParam() };
//public IEnumerable<FeeScheduleData> GetAll(AccountData account) //{ // Log.LogInformation("Accessing FeeScheduleRepo GetAll by Account function"); // var pcol = new List<SqlParameter>() { Mapper.BuildParam("@account_key", account.AccountKey) }; // using (entityContext) return MapRows(entityContext.ExecuteProcedureAsSqlDataReader("usp_fee_schedule_all_by_account", pcol)); //} public IEnumerable <FeeScheduleData> GetAll(CompanyData company) { Log.LogInformation("Accessing FeeScheduleRepo GetAll by Company function"); var pcol = new List <SqlParameter>() { Mapper.BuildParam("@account_key", company.CompanyKey) }; using (entityContext) return(MapRows(entityContext.ExecuteProcedureAsSqlDataReader("usp_fee_schedule_all_by_company", pcol))); }
public IEnumerable <PersonData> GetAll(CompanyData comp) { Log.LogInformation("Accessing PersonRepo GetAll by Company function"); var pcol = new List <SqlParameter>() { Mapper.BuildParam("@company_key", comp.CompanyKey) }; using (entityContext) return(MapRows(entityContext.ExecuteProcedureAsSqlDataReader("usp_person_all_by_company", pcol))); }
public List <SqlParameter> MapParamsForDelete(CompanyData entity) => MapParamsForDelete(entity.CompanyKey);