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