public emlakDetay()
 {
     fiyatlar      = new fiyat();
     resimlerBuyuk = new List <string>();
     resimlerKucuk = new List <string>();
     ozellikler    = new List <string>();
 }
Ejemplo n.º 2
0
        public fiyat fiyatGetirEmlakId(int gelenEmlakId)
        {
            fiyat f = new fiyat();

            try
            {
                SqlCommand com = new SqlCommand("select * from Fiyat where EmlakId=@emlakId", con);
                com.Parameters.AddWithValue("@emlakId", gelenEmlakId);
                com.CommandType = CommandType.Text;

                con.Open();
                SqlDataReader dr = com.ExecuteReader();
                while (dr.Read())
                {
                    f.Dolar   = Convert.ToInt32(dr["dolar"]);
                    f.EmlakId = Convert.ToInt32(dr["EmlakId"]);
                    f.Euro    = Convert.ToInt32(dr["Euro"]);
                    f.Pound   = Convert.ToInt32(dr["Pound"]);
                    f.Tl      = Convert.ToInt32(dr["TL"]);
                }
                dr.Close();
            }
            catch (Exception ex)
            {
            }
            finally
            {
                con.Close();
            }
            return(f);
        }