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