public TahlilEntity IDyeGoreTahlilGetir(int tahlilID)
{
cmd = new SqlCommand("Select * From Tahliller Where TahlilID = @TahlilID", conn);
cmd.Parameters.AddWithValue("@TahlilID", tahlilID);
TahlilEntity currentTahlil = null;
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
currentTahlil = new TahlilEntity()
{
TahlilID = (int)reader["TahlilID"],
TahlilAdi = reader["TahlilAdi"].ToString()
};
reader.Close();
return(currentTahlil);
}
catch
{
return(currentTahlil);
}
finally
{
conn.Close();
}
}
public int TahlilEkle(TahlilEntity tahlil)
{
cmd = new SqlCommand("Insert Into Tahliller Values(@TahlilID,@TahlilAdi)", conn);
AddParametersToCommand(tahlil);
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result);
}
public int TahlilGuncelle(TahlilEntity tahlil)
{
cmd = new SqlCommand("Update Tahliller Set TahlilID=@TahlilID, TahlilAdi=@TahlilAdi", conn);
AddParametersToCommand(tahlil);
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result);
}
void AddParametersToCommand(TahlilEntity tahlil)
{
cmd.Parameters.AddWithValue("@TahlilID", tahlil.TahlilID);
cmd.Parameters.AddWithValue("@TahlilAdi", tahlil.TahlilAdi);
}
