public List <Uyeler> GetAll() { using (var cmd = _unitOfWork.CreateCommand()) { cmd.CommandText = "SELECT * FROM Uyeler"; SqlDataReader rd = (SqlDataReader)cmd.ExecuteReader(); List <Uyeler> uyeler = new List <Uyeler>(); Uyeler uye = null; while (rd.Read()) { uye = new Uyeler { UID = rd.GetInt32(0), Adi = rd.GetString(1), Soyadi = rd.GetString(2), Telefon = rd.GetString(3), Eposta = rd.GetString(4), Adres = rd.GetString(5) }; uyeler.Add(uye); } rd.Close(); return(uyeler); } }
public List <Uyeler> Ara(string ad, string ePosta) { using (var cmd = _unitOfWork.CreateCommand()) { cmd.CommandText = "Exec SP_UyeAra" + " '" + ad + "','" + ePosta + "'"; SqlDataReader rd = (SqlDataReader)cmd.ExecuteReader(); Uyeler uye = null; List <Uyeler> uyeler = new List <Uyeler>(); while (rd.Read()) { uye = new Uyeler { UID = rd.GetInt32(0), Adi = rd.GetString(1), Soyadi = rd.GetString(2), Telefon = rd.GetString(3), Eposta = rd.GetString(4), Adres = rd.GetString(5) }; uyeler.Add(uye); } rd.Close(); return(uyeler); } }