public static MesaDAL Getinstancia()
{
if (instance == null)
{
instance = new MesaDAL();
}
return(instance);
}
public void AlterMesa(MesaDAL objaux)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("Altermesa", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("sala", OracleDbType.Varchar2).Value = Nombre_sala;
cm.Parameters.Add("cap", OracleDbType.Int32).Value = Capacidad;
cm.Parameters.Add("id_", OracleDbType.Int32).Value = Id_mesa;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
