public TeshislerEntity IDyeGoreTeshisGetir(int teshisID)
{
cmd = new SqlCommand("Select * From Teshisler Where TeshisID = @TeshisID", conn);
cmd.Parameters.AddWithValue("@TeshisID", teshisID);
TeshislerEntity currentTeshis = null;
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
currentTeshis = new TeshislerEntity()
{
TeshisID = (int)reader["TeshisID"],
TeshisAdi = reader["TeshisAdi"].ToString()
};
reader.Close();
return(currentTeshis);
}
catch
{
return(currentTeshis);
}
finally
{
conn.Close();
}
}
public int TeshisEkle(TeshislerEntity teshis)
{
cmd = new SqlCommand("Insert Into Teshisler Values(@TeshisID,@TeshisAdi)", conn);
AddParametersToCommand(teshis);
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result);
}
public int TeshisGuncelle(TeshislerEntity teshis)
{
cmd = new SqlCommand("Update Teshisler Set TeshisID=@TeshisID, TeshisAdi=@TeshisAdi", conn);
AddParametersToCommand(teshis);
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result);
}
void AddParametersToCommand(TeshislerEntity teshis)
{
cmd.Parameters.AddWithValue("@TeshisID", teshis.TeshisID);
cmd.Parameters.AddWithValue("@TeshisAdi", teshis.TeshisAdi);
}
