public DepartmanEntity IDyeGoreDepartmanGetir(int departmanID) { cmd = new SqlCommand("Select * From Departmanlar Where DepartmanID = @DepartmanID", conn); cmd.Parameters.AddWithValue("@DepartmanID", departmanID); DepartmanEntity currentDepartman = null; try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); currentDepartman = new DepartmanEntity() { DepartmanID = (int)reader["DepartmanID"], DepartmanAdi = reader["DepartmanAdi"].ToString() }; reader.Close(); return(currentDepartman); } catch { return(currentDepartman); } finally { conn.Close(); } }
public int IsmeGoreDepartmanGetir(string departmanAd) { DepartmanEntity departman = new DepartmanEntity(); cmd = new SqlCommand("Select * From Departmanlar Where DepartmanAdi=@departmanAdi", conn); cmd.Parameters.AddWithValue("@departmanAdi", departmanAd); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); reader.Read(); departman.DepartmanID = reader.GetInt32(0); reader.Close(); return(departman.DepartmanID); }