using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using CertAuth.Domain; using Microsoft.Data.SqlClient; namespace CertAuthAdmin.Models { public class CollectorItemsDA { public List tbl { get; set; } public IEnumerable GetItem(int id) { string connStr = Globals.connStr; List lst; lst = new List(); IEnumerable theList; using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("Collectors_ItemList_GetByCollectorID", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CollectorItemsList rec = new CollectorItemsList(); rec.CollectorID = (int)rdr["CollectorID"]; rec.CollectorFirstName = rdr["CollectorFirstName"].ToString(); rec.CollectorLastName = rdr["CollectorLastName"].ToString(); rec.collectorDisplayName = rdr["collectorDisplayName"].ToString(); rec.ItemName = rdr["ItemName"].ToString(); rec.ItemType = rdr["ItemType"].ToString(); rec.ItemTypeDesc = rdr["ItemTypeDesc"].ToString(); rec.ItemSubType = rdr["ItemSubType"].ToString(); rec.ItemSubTypeDesc = rdr["ItemSubTypeDesc"].ToString(); rec.Category = rdr["Category"].ToString(); rec.CategoryDesc = rdr["CategoryDesc"].ToString(); rec.SubCategory = rdr["SubCategory"].ToString(); rec.SubCategoryDesc = rdr["SubCategoryDesc"].ToString(); lst.Add(rec); } con.Close(); } theList = lst; return theList; } } }