public static List <ListStruct> LoadData(SqlConnection cn, ClimbingStyleType style, int projNum)
{
List <ListStruct> rV = new List <ListStruct>();
ListsForShowTableAdapter lta = new ListsForShowTableAdapter();
lta.Connection = cn;
DsListShow.ListsForShowDataTable dt = lta.GetData(projNum);
foreach (DsListShow.ListsForShowRow row in dt.Rows)
{
if (row.showPhoto && row.style == style.ToString())
{
ListStruct lstr;
lstr.iid = row.iid;
lstr.name = row.grp + " " + row.round + " " + row.style;
rV.Add(lstr);
}
}
return(rV);
}
public static List <ListForShow> GetAllLists(SqlConnection cn, int projNum = 1)
{
if (cn == null)
{
throw new ArgumentNullException("cn");
}
if (cn.State != ConnectionState.Open)
{
cn.Open();
}
ListsForShowTableAdapter lta = new ListsForShowTableAdapter();
lta.Connection = cn;
List <ListForShow> lst = new List <ListForShow>();
foreach (DsListShow.ListsForShowRow row in lta.GetData(projNum))
{
lst.Add(new ListForShow(row.iid, row.grp, row.style, row.round, row.routeNumber, cn));
}
return(lst);
}
