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