public int Update(HastanelerEntities hastane)
{
cmd = new SqlCommand("update Hastaneler SET HastaneAdi=@hAd where HastaneID=@hastaneID", conn);
cmd.Parameters.AddWithValue("@hAd", hastane.HastaneAdi);
cmd.Parameters.AddWithValue("@hastaneID", hastane.HastaneID);
return(ExecuteCommand());
}
public HastanelerEntities GetHastaneById(int hastaneID)
{
HastanelerEntities currentHastane = new HastanelerEntities();
cmd = new SqlCommand("Select * From Hastaneler Where hastaneID = @id", conn);
cmd.Parameters.AddWithValue("@id", hastaneID);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
reader.Read();
currentHastane.HastaneID = reader.GetInt32(0);
currentHastane.HastaneAdi = reader.GetString(1);
reader.Close();
return(currentHastane);
}
public int Add(HastanelerEntities hastane)
{
cmd = new SqlCommand("INSERT INTO Hastaneler VALUES (@hAd)", conn);
cmd.Parameters.AddWithValue("@hAd", hastane.HastaneAdi);
return(ExecuteCommand());
}
