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