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