/*
* public DataTable GetAllIng()
* {
* using (OracleConnection con = new conexion().Conexion())
* {
* OracleCommand cm = new OracleCommand("Get_alling", con);
* cm.BindByName = true;
* cm.CommandType = System.Data.CommandType.StoredProcedure;
* OracleParameter output = cm.Parameters.Add("my_cursor", OracleDbType.RefCursor);
* output.Direction = System.Data.ParameterDirection.ReturnValue;
* con.Open();
* cm.ExecuteNonQuery();
*
* OracleDataReader reader = ((OracleRefCursor)output.Value).GetDataReader();
* con.Close();
* using (DataTable dt = new DataTable())
* {
* OracleDataAdapter adapter = new OracleDataAdapter(cm);
* adapter.Fill(dt);
* return dt;
*
* }
* }
* }
*/
public bool SolicitarBebestible(bebestibleDAL objingDAL)
{
try
{
using (OracleConnection con = new conexion().Conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand objCmd = new OracleCommand("SolicitarInsumoBebestible", con);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.BindByName = true;
objCmd.Parameters.Add("p_nomb", OracleDbType.Varchar2).Value = nombre_ins;
objCmd.Parameters.Add("p_stock", OracleDbType.Double).Value = stock;
con.Open();
objCmd.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
return(false);
}
}
public static bebestibleDAL Getinstancia()
{
if (instance == null)
{
instance = new bebestibleDAL();
}
return(instance);
}