public bool OtelEkle(Otel o, PictureBox pbFoto) { bool sonuc = false; SqlCommand comm = new SqlCommand("insert into Otel (OtelAd,StatuID,Telefon,Adres,SehirID,Foto) values(@OtelAd,@StatuID,@Telefon,@Adres,@SehirID,@Foto)", conn); comm.Parameters.Add("@OtelAd", SqlDbType.VarChar).Value = _OtelAd; comm.Parameters.Add("@StatuID", SqlDbType.VarChar).Value = _StatuID; comm.Parameters.Add("@Telefon", SqlDbType.VarChar).Value = _Telefon; comm.Parameters.Add("@Adres", SqlDbType.VarChar).Value = _Adres; comm.Parameters.Add("@SehirID", SqlDbType.VarChar).Value = _SehirID; MemoryStream ms = new MemoryStream(); pbFoto.Image.Save(ms, ImageFormat.Jpeg); byte[] byteData = new byte[ms.Length]; ms.Position = 0; ms.Read(byteData, 0, Convert.ToInt32(ms.Length)); SqlParameter parametre = new SqlParameter("@Foto", SqlDbType.Image, byteData.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, byteData); comm.Parameters.Add(parametre); if (conn.State == ConnectionState.Closed) { conn.Open(); } try { sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (Exception ex) { string hata = ex.Message; } finally { conn.Close(); } return(sonuc); }
public void StatuGetir(ComboBox cb) { SqlCommand comm = new SqlCommand("select * from OtelStatu where Silindi=0", conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr; try { dr = comm.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Otel o = new Otel(); o._StatuID = Convert.ToInt32(dr["StatuID"]); o._StatuAd = dr["StatuAd"].ToString(); cb.Items.Add(o); } } } catch (Exception ex) { string hata = ex.Message; } finally { conn.Close(); } }
public DataSet OtelleriGetir(Otel o) { SqlDataAdapter da = new SqlDataAdapter("select Foto,Otel.OtelID,OtelAd,OtelStatu.StatuAd,OdaStatu.StatuAd,TipAd,Fiyat,TipID,OdaSayisi,OdaStatu.StatuID from OtelStatu inner join Otel on OtelStatu.StatuID=Otel.StatuID inner join OdaTipi on Otel.OtelID=OdaTipi.OtelID inner join OdaStatu on OdaTipi.StatuID=OdaStatu.StatuID where Otel.Silindi=0 and TipAd=@TipAdi and Otel.SehirID in (select SehirID from Sehirler where SehirAdi=@Sehir)", conn); da.SelectCommand.Parameters.Add("@Sehir", SqlDbType.VarChar).Value = o._SehirAd; da.SelectCommand.Parameters.Add("@TipAdi", SqlDbType.VarChar).Value = o._OdaTipi; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { da.Fill(ds, "Oteller"); } catch (Exception ex) { string hata = ex.Message; } finally { conn.Close(); } return(ds); }
public bool OtelDegistir(Otel o, PictureBox pbFoto) { bool sonuc = false; SqlCommand comm = new SqlCommand("update Otel set OtelAd=@OtelAd,StatuID=@StatuID,Telefon=@Telefon,Adres=@Adres,SehirID=@SehirID,Foto=@Foto where OtelID=@OtelID", conn); comm.Parameters.Add("@OtelAd", SqlDbType.VarChar).Value = o._OtelAd; comm.Parameters.Add("@StatuID", SqlDbType.Int).Value = o._StatuID; comm.Parameters.Add("@Telefon", SqlDbType.VarChar).Value = o._Telefon; comm.Parameters.Add("@Adres", SqlDbType.VarChar).Value = o._Adres; comm.Parameters.Add("@SehirID", SqlDbType.Int).Value = o._SehirID; comm.Parameters.Add("@OtelID", SqlDbType.Int).Value = o._OtelID; MemoryStream ms = new MemoryStream(); pbFoto.Image.Save(ms, ImageFormat.Jpeg); byte[] byteData = new byte[ms.Length]; ms.Position = 0; ms.Read(byteData, 0, Convert.ToInt32(ms.Length)); SqlParameter parametre = new SqlParameter("@Foto", SqlDbType.Image, byteData.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, byteData); comm.Parameters.Add(parametre); if (conn.State == ConnectionState.Closed) { conn.Open(); } try { int sayi = comm.ExecuteNonQuery(); if (sayi > 0) { sonuc = true; } } catch (Exception ex) { string hata = ex.Message; } finally { conn.Close(); } return(sonuc); }