public DataTable LoadData(string spName, List<SqlParameter> parameters)
{
if (spName == null)
throw new Exception("SpName is not initialized.");
var db = new Core.Data.Database().GetDatabase();
SqlCommand cmd = new SqlCommand(spName);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(parameters.ToArray());
return db.ExecuteDataSet(cmd).Tables[0];
}
public List<Models.Module> LoadModules()
{
List<Models.Module> modules = new List<Models.Module>();
var db = new Core.Data.Database().GetDatabase();
SqlCommand cmd = new SqlCommand("Core.sp_GetModules");
cmd.CommandType = System.Data.CommandType.StoredProcedure;
var d = db.ExecuteReader(cmd);
while (d.Read())
{
var m = new Models.Module();
m.Id = new Guid(d["Id"].ToString());
m.Name = d["Name"].ToString();
m.Path = d["Path"].ToString();
m.FileName = d["FileName"].ToString();
//TODO: assemblyleri ekle.
SqlCommand cmdAssemblies = new SqlCommand("Core.sp_GetAssemblies");
cmdAssemblies.CommandType = System.Data.CommandType.StoredProcedure;
cmdAssemblies.Parameters.AddWithValue("@ModuleId", m.Id.ToString());
var reader = db.ExecuteReader(cmdAssemblies);
m.Assemblies = new List<Models.Assembly>();
while (reader.Read())
{
var a = new Models.Assembly();
a.Id = new Guid(reader["Id"].ToString());
a.ModuleId = m.Id;
a.Name = reader["Name"].ToString();
a.Namespace = reader["Namespace"].ToString();
m.Assemblies.Add(a);
}
modules.Add(m);
}
//TODO: spyi oluştur
return modules;
}
