public emlakTip emlakTipGetirId(int eTipId)
        {
            emlakTip et = new emlakTip();

            try
            {
                SqlCommand com = new SqlCommand("select * from EmlakTip where EmlakTipId=@etip", con);
                com.Parameters.AddWithValue("@etip", eTipId);
                com.CommandType = CommandType.Text;

                con.Open();
                SqlDataReader dr = com.ExecuteReader();
                while (dr.Read())
                {
                    et.EmlakTipId = Convert.ToInt32(dr["EmlakTipId"]);
                    et.EmlakTipAd = dr["EmlakTipAd"].ToString();
                }
                dr.Close();
            }
            catch (Exception ex)
            {
            }
            finally
            {
                con.Close();
            }
            return(et);
        }
        public List <emlakTip> emlakTipGetirTum()
        {
            List <emlakTip> emlakTipler = new List <emlakTip>();

            try
            {
                SqlCommand com = new SqlCommand("select * from EmlakTip  order by EmlakTipAd", con);
                com.CommandType = CommandType.Text;

                con.Open();
                SqlDataReader dr = com.ExecuteReader();
                while (dr.Read())
                {
                    emlakTip et = new emlakTip();
                    et.EmlakTipId = Convert.ToInt32(dr["EmlakTipId"]);
                    et.EmlakTipAd = dr["EmlakTipAd"].ToString();
                    emlakTipler.Add(et);
                }
                dr.Close();
            }
            catch (Exception ex)
            {
            }
            finally
            {
                con.Close();
            }
            return(emlakTipler);
        }