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