/// <summary>
/// // ID'ye göre oda çeşidini getirir.
/// </summary>
/// <param name="odaCesidiId"></param>
/// <returns></returns>
public OdaCesidi IDyegoreOdaCesidiGetir(int odaCesidiId)
{
cmd = new SqlCommand("select * from odacesidi where odacesidiid=@odacesidiId", cnn);
cmd.Parameters.AddWithValue("@odacesidiId", odaCesidiId);
OdaCesidi odaCesidi = null;
try
{
cnn.Open();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
odaCesidi = new OdaCesidi()
{
OdaCesidiID = (int)rd["odacesidiid"],
Cesit = rd["cesit"].ToString()
};
}
return(odaCesidi);
}
catch (Exception)
{
return(odaCesidi);
}
finally
{
cnn.Close();
}
}
/// <summary>
/// //Tüm oda çeşitlerini getirir.
/// </summary>
/// <returns></returns>
///
public int OdaCesidiEkle(OdaCesidi odacesidi)
{
cmd = new SqlCommand("Insert into OdaCesidi (Cesit) values (@cesit)", cnn);
cmd.Parameters.AddWithValue("@cesit", odacesidi.Cesit);
return(ExecuteCommand());
}
public void Guncelle()
{
odaCesidi = new OdaCesidi();
SqlCommandBuilder commBuilder = new SqlCommandBuilder(da);
da.Update(dt);
}
public int OdaCesidiGuncelle(OdaCesidi odacesidi)
{
cmd = new SqlCommand("update OdaCesidi set Cesit=@cesit where OdaCesidiID=@ocid", cnn);
cmd.Parameters.AddWithValue("@cesit", odacesidi.Cesit);
cmd.Parameters.AddWithValue("@ocid", odacesidi.OdaCesidiID);
return(ExecuteCommand());
}
public bool Update(OdaCesidi odacesidi)
{
_odaCesidiDAL = new OdaCesidiDAL();
return(_odaCesidiDAL.OdaCesidiGuncelle(odacesidi) > 0);
}
public bool Add(OdaCesidi odacesidi)
{
_odaCesidiDAL = new OdaCesidiDAL();
return(_odaCesidiDAL.OdaCesidiEkle(odacesidi) > 0);
}
