public PoliklinikEntity IDyeGorePoliklinikGetir(int poliklinikID)
{
cmd = new SqlCommand("Select * From Poliklinikler Where PoliklinikID = @PoliklinikID", conn);
cmd.Parameters.AddWithValue("@PoliklinikID", poliklinikID);
PoliklinikEntity currentPoliklinik = null;
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
currentPoliklinik = new PoliklinikEntity()
{
PoliklinikID = (int)reader["PoliklinikID"],
PoliklinikAdi = reader["PoliklinikAdi"].ToString(),
HastaneID = (int)reader["HastaneID"]
};
reader.Close();
return(currentPoliklinik);
}
catch
{
return(currentPoliklinik);
}
finally
{
conn.Close();
}
}
public int IsmeGorePoliklinikGetir(string poliklinikAd)
{
PoliklinikEntity poliklinik = new PoliklinikEntity();
cmd = new SqlCommand("Select * From Poliklinikler Where PoliklinikAdi=@poliklinikAdi", conn);
cmd.Parameters.AddWithValue("@poliklinikAdi", poliklinikAd);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
reader.Read();
poliklinik.PoliklinikID = reader.GetInt32(0);
reader.Close();
return(poliklinik.PoliklinikID);
}
