public int Update(IlacEntities ilac)
{
cmd = new SqlCommand("update İlaclar SET IlacAdi=@iAd where IlacID=@ilacID", conn);
cmd.Parameters.AddWithValue("@iAd", ilac.IlacAdi);
cmd.Parameters.AddWithValue("@ilacID", ilac.IlacID);
return(ExecuteCommand());
}
public IlacEntities GetIlacById(int ilacID)
{
IlacEntities currentIlac = new IlacEntities();
cmd = new SqlCommand("Select * From İlaclar Where IlacID = @id", conn);
cmd.Parameters.AddWithValue("@id", ilacID);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
reader.Read();
currentIlac.IlacID = reader.GetInt32(0);
currentIlac.IlacAdi = reader.GetString(1);
reader.Close();
return(currentIlac);
}
public int Add(IlacEntities ilac)
{
cmd = new SqlCommand("INSERT INTO İlaclar VALUES (@iAd)", conn);
cmd.Parameters.AddWithValue("@iAd", ilac.IlacAdi);
return(ExecuteCommand());
}
