public List <Country> GetCountries(int countryId) { using (JumpStartDbContext context = new JumpStartDbContext()) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@CountryId", SqlDbType.Int) { Value = countryId }); string sql = "exec usp_GetCountry @CountryId"; var result = context.Countries.FromSqlRaw(sql, parameters.ToArray()); return(result.ToList()); } }
public List <ExpenseDetailsSPModel> GetExpenseDetailsByCategory(int id) { using (JumpStartDbContext context = new JumpStartDbContext()) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@ExpenseCategoryId", SqlDbType.Int) { Value = id }); string sql = "exec usp_ExpenseDetails @ExpenseCategoryId"; var result = context.ExpenseDetailsSPModel.FromSqlRaw(sql, parameters.ToArray()); return(result.ToList()); } }
public JobService(JumpStartDbContext context) { _context = context; }
public UserJobsController(JumpStartDbContext context) { _context = context; }
public UserService(JumpStartDbContext jumpDbContext, IJobManager jobManager) { _jumpDbContext = jumpDbContext; _jobManager = jobManager; }