public void createCruise(Crucero cruise)
{
Dictionary <String, Object> dic = new Dictionary <String, Object>();
dic.Add("@Identificador", cruise.getIdentificador());
dic.Add("@Modelo", cruise.getModelo());
dic.Add("@IdFabricante", cruise.getIdFabricante());
dic.Add("@FechaAlta", cruise.getFechaAlta());
dic.Add("@CantCabinas", cruise.getCantidadCabinas());
db.executeProcedureWithParameters("dbo.sp_crear_crucero", dic);
}
public int verifyCruiseExisted(Crucero cruise)
{
DataTable dt = db.select_query("Select CRU.intCrucero from dbo.Crucero CRU where CRU.Identificador = '" + cruise.getIdentificador() + "';");
if (dt.Rows.Count != 0)
{
return(1);
}
return(0);
}
public int getIdCrucero(Crucero cruise)
{
DataTable dt = db.select_query("Select CRU.intCrucero from dbo.Crucero CRU where CRU.Identificador = '" + cruise.getIdentificador() + "'");
if (dt.Rows.Count != 1)
{
return(-1);
}
DataRow r = dt.Rows[0];
return(Convert.ToInt32(r["intCrucero"]));
}
