public DataSet GetDashboardData()
{
DataSet ds = null;
string commandText = "[dbo].[sp_GetDashboardData]";
using (var db = new SkillsTrackerContext())
{
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = commandText;
try
{
db.Database.Connection.Open();
var reader = cmd.ExecuteReader();
ds = new DataSet();
while (!reader.IsClosed && reader.HasRows)
{
DataTable dt = new DataTable();
dt.Load(reader);
ds.Tables.Add(dt);
}
}
finally
{
db.Database.Connection.Close();
}
}
return(ds);
}
public UnitOfWork(SkillsTrackerContext context)
{
_context = context;
Skills = new SkillsRepository(context);
Associates = new AssociatesRepository(context);
AssociateSkills = new AssociateSkillsRepository(context);
}
public AssociatesRepository(SkillsTrackerContext context) :
base(context)
{
}
public SkillsRepository(SkillsTrackerContext context) :
base(context)
{
}
