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