public IEnumerable <dynamic> GetData(String cmdText)
{
using (var ctx = new ZildingDBContext())
{
var loggedInUser = new SqlParameter("@OrgLvlId", 1);
var dbResults = ctx.RolesList
.FromSql("EXECUTE sp_get_rolesby_orglvlid @OrgLvlId", loggedInUser)
.ToList();
}
var builder = new ConfigurationBuilder();
builder.SetBasePath(Directory.GetCurrentDirectory());
builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
.AddJsonFile($"appsettings.{_env.EnvironmentName}.json", optional: true);
var connectionStringConfig = builder.Build();
using (var connection = new SqlConnection(connectionStringConfig.GetConnectionString("sqlServerConnection:connectionString")))
{
connection.Open();
using (var command = new SqlCommand(cmdText, connection))
{
using (var dataReader = command.ExecuteReader())
{
var fields = new List <String>();
for (var i = 0; i < dataReader.FieldCount; i++)
{
fields.Add(dataReader.GetName(i));
}
while (dataReader.Read())
{
var item = new ExpandoObject() as IDictionary <String, Object>;
for (var i = 0; i < fields.Count; i++)
{
item.Add(fields[i], dataReader[fields[i]]);
}
yield return(item);
}
}
}
}
}
public RoleService(ZildingDBContext db, IHostingEnvironment env)
{
_db = db;
_env = env;
}
