using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using CertAuth.Domain; using Microsoft.AspNetCore.Mvc.Rendering; using Microsoft.Data.SqlClient; namespace CertAuthAdmin.Models { public class CollectorsDA { public List tbl { get; set; } private List Sli { get; set; } public IEnumerable GetAll() { string connStr = Globals.connStr; List Datalst; IEnumerable Datalist; Datalst = new List(); using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("Collectors_GetAll", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CollectorsLst rec = new CollectorsLst(); rec.Id = (int)rdr["Id"]; rec.UserKey = rdr["UserKey"].ToString(); rec.CollectorFirstName = rdr["CollectorFirstName"].ToString(); rec.CollectorLastName = rdr["CollectorLastName"].ToString(); rec.CollectorAddress1 = rdr["CollectorAddress1"].ToString(); rec.CollectorAddress2 = rdr["CollectorAddress2"].ToString(); rec.CollectorCity = rdr["CollectorCity"].ToString(); rec.CollectorProvince = rdr["CollectorProvince"].ToString(); rec.CollectorCountry = rdr["CollectorCountry"].ToString(); rec.CollectorPostalCode = rdr["CollectorPostalCode"].ToString(); rec.EmailAddress = rdr["EmailAddress"].ToString(); rec.CollectorPhone = rdr["CollectorPhone"].ToString(); rec.CollectorCellPhone = rdr["CollectorCellPhone"].ToString(); rec.DisplayName = (bool)rdr["DisplayName"]; rec.DisplayEmail = (bool)rdr["DisplayEmail"]; rec.Status = rdr["Status"].ToString(); rec.TimeStamp = (DateTime)rdr["TimeStamp"]; rec.collectorDisplayName = rdr["collectorDisplayName"].ToString(); Datalst.Add(rec); } con.Close(); } Datalist = Datalst; return Datalist; } } }