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);
        }