public static List <Location> List(int levelId = 0)
{
List <Location> list = new List <Location>();
string sql = string.Format(
"select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " +
"WHERE {0}=0 or l.LevelId={0} order by v.Name, l.Name;",
levelId
);
using (DataSet ds = DataAccess.RunSql(sql))
{
list.Capacity = ds.Tables[0].Rows.Count;
// list level locations
foreach (DataRow r in ds.Tables[0].Rows)
{
Location loc = new Location();
loc._initFromRow(r);
string name2 = r.StringOrBlank("Name2").Trim();
loc.Name = string.Format("{0} : {1}",
name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2,
loc.Name
);
list.Add(loc);
}
}
return(list);
}
public static List <Location> List(int levelId = 0)
{
List <Location> list = new List <Location>();
using (SqlCommand cmd = new SqlCommand()
{
CommandType = CommandType.Text,
CommandText =
"select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " +
"where @levelId=0 or l.LevelId=@levelId order by v.Name, l.Name;",
})
{
cmd.Parameters.AddWithValue("@levelId", levelId);
cmd.ExecuteReaderExt((r) =>
{
Location loc = new Location();
loc._initFromRow(r);
string name2 = r.StringOrBlank("Name2").Trim();
loc.Name = string.Format("{0} : {1}",
name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2,
loc.Name
);
list.Add(loc);
return(true);
});
}
return(list);
}
public static List<Location> List(int levelId = 0)
{
List<Location> list = new List<Location>();
using (SqlCommand cmd = new SqlCommand()
{
CommandType = CommandType.Text,
CommandText =
"select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " +
"where @levelId=0 or l.LevelId=@levelId order by v.Name, l.Name;",
})
{
cmd.Parameters.AddWithValue("@levelId", levelId);
cmd.ExecuteReaderExt((r) =>
{
Location loc = new Location();
loc._initFromRow(r);
string name2 = r.StringOrBlank("Name2").Trim();
loc.Name = string.Format("{0} : {1}",
name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2,
loc.Name
);
list.Add(loc);
return true;
});
}
return list;
}
public static List<Location> List(int levelId = 0)
{
List<Location> list = new List<Location>();
string sql = string.Format(
"select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " +
"WHERE {0}=0 or l.LevelId={0} order by v.Name, l.Name;",
levelId
);
using (DataSet ds = DataAccess.RunSql(sql))
{
list.Capacity = ds.Tables[0].Rows.Count;
// list level locations
foreach (DataRow r in ds.Tables[0].Rows)
{
Location loc = new Location();
loc._initFromRow(r);
string name2 = r.StringOrBlank("Name2").Trim();
loc.Name = string.Format("{0} : {1}",
name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2,
loc.Name
);
list.Add(loc);
}
}
return list;
}
