public string EliminarHotel(DHoteles HOTEL)
{
string rpta = "";
SqlConnection SqlCon = new SqlConnection();
try
{
SqlCon.ConnectionString = Conexion.Cn;
SqlCon.Open();
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.Connection = SqlCon;
SqlCmd.CommandText = "HOT_ELIMINAR";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter ParHabid = new SqlParameter();
ParHabid.ParameterName = "@ID";
ParHabid.SqlDbType = SqlDbType.Int;
ParHabid.Value = HOTEL.HOT_ID;
SqlCmd.Parameters.Add(ParHabid);
rpta = SqlCmd.ExecuteNonQuery() == 1 ? "OK" : "No se elimino la Habitacion correctamente";
}
catch (Exception ex)
{
rpta = ex.Message;
}
finally
{
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
return(rpta);
}
public string InsertarHotel(DHoteles Hotel)
{
string rpta = "";
SqlConnection SqlCon = new SqlConnection();
try
{
SqlCon.ConnectionString = Conexion.Cn;
SqlCon.Open();
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.Connection = SqlCon;
SqlCmd.CommandText = "HOT_INSERT";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter ParHabid = new SqlParameter();
ParHabid.ParameterName = "@ID";
ParHabid.SqlDbType = SqlDbType.Int;
ParHabid.Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(ParHabid);
SqlParameter ParNom = new SqlParameter();
ParNom.ParameterName = "@NOMBRE";
ParNom.SqlDbType = SqlDbType.VarChar;
ParNom.Size = 50;
ParNom.Value = Hotel.HOT_NOMBRE;
SqlCmd.Parameters.Add(ParNom);
SqlParameter ParHabNum = new SqlParameter();
ParHabNum.ParameterName = "@PAIS";
ParHabNum.SqlDbType = SqlDbType.VarChar;
ParHabNum.Size = 50;
ParHabNum.Value = Hotel.PAIS;
SqlCmd.Parameters.Add(ParHabNum);
rpta = SqlCmd.ExecuteNonQuery() == 1 ? "OK" : "No se agrego EL HOTEL correctamente";
}
catch (Exception ex)
{
rpta = ex.Message;
}
finally
{
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
return(rpta);
}
public DataTable BuscarHotel(DHoteles Hotel)
{
DataTable DtResultado = new DataTable("HOTELES");
SqlConnection SqlCon = new SqlConnection();
try
{
SqlCon.ConnectionString = Conexion.Cn;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.Connection = SqlCon;
SqlCmd.CommandText = "HOT_BUCAR";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter ParTextoBuscar = new SqlParameter();
ParTextoBuscar.ParameterName = "@NOMBRE";
ParTextoBuscar.SqlDbType = SqlDbType.VarChar;
ParTextoBuscar.Size = 50;
ParTextoBuscar.Value = Hotel.TEXTO_BUSCAR1;
SqlCmd.Parameters.Add(ParTextoBuscar);
SqlParameter ParTextoBuscar2 = new SqlParameter();
ParTextoBuscar2.ParameterName = "@PAIS";
ParTextoBuscar2.SqlDbType = SqlDbType.VarChar;
ParTextoBuscar2.Size = 50;
ParTextoBuscar2.Value = Hotel.TEXTO_BUSCAR2;
SqlCmd.Parameters.Add(ParTextoBuscar2);
SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd);
SqlDat.Fill(DtResultado);
}
catch (Exception ex)
{
string msm = Convert.ToString(ex);
DtResultado = null;
}
return(DtResultado);
}
