public void DeleteUser(usuarioDAL objaux)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("EliminarUsuario", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("rut", OracleDbType.Varchar2).Value = rut;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public void Alter_montototalporboleta(int id_pe)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("Alter_monto_pedidobyid", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("id_pe", OracleDbType.Int32).Value = id_pe;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public void Altereliminaring(IngredienteDAL objaux)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("alter_estadoingrediente", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("ide", OracleDbType.Varchar2).Value = id_ingrediente;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public void Altereestado_espera(BebestibleDAL objaux)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("alter_beb_preparado", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("ide", OracleDbType.Varchar2).Value = numero_pedido;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public void DeleteMesa(int id)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("deletemesa", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("ID_", OracleDbType.Varchar2).Value = id;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public void DesPlato(PlatoDAL objaux)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("DeshabilitarPlato", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("id_", OracleDbType.Varchar2).Value = Id_plato;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public bool getLogin(string nomuser, string pass)
{
try
{
OracleConnection con = new Conexion().conexion();
con.Open();
OracleCommand com = new OracleCommand("get_userpass", con);
com.BindByName = true;
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add("USERNAME", OracleDbType.Varchar2).Value = nomuser;
OracleParameter output = com.Parameters.Add("my_cursor", OracleDbType.RefCursor);
output.Direction = System.Data.ParameterDirection.ReturnValue;
com.ExecuteNonQuery();
OracleDataReader reader = ((OracleRefCursor)output.Value).GetDataReader();
string shaword = encriptador(pass);
if (reader.HasRows)
{
while (reader.Read())
{
nom_usuario = reader[1].ToString();
clave = reader[2].ToString();
rol = reader[3].ToString();
if (nom_usuario == nomuser && clave == shaword && rol == "Bar")
{
con.Close();
return(true);
}
}
}
con.Close();
return(false);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
public DataTable Get_beb_orden_listo()
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("Get_Orden_listo", 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 void alter_bebestible_Desp(int orden, int beb)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("alter_beb_Despachado", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("ide", OracleDbType.Varchar2).Value = beb;
cm.Parameters.Add("orden", OracleDbType.Varchar2).Value = orden;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public void Anular_pedido(int id_pe, int id_ins)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand objCmd = new OracleCommand();
objCmd.Connection = con;
objCmd.CommandText = "Anular_pedido";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("id_pe", OracleDbType.Int32).Value = id_pe;
objCmd.Parameters.Add("id_ins", OracleDbType.Int32).Value = id_ins;
con.Open();
objCmd.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
}
}
public string Get_tipo_pedido(int id_pe)
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("Get_tipo_pedido", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("id_pe", OracleDbType.Int32).Value = id_pe;
OracleParameter output = cm.Parameters.Add("my_cursor", OracleDbType.Varchar2, 40);
output.Direction = System.Data.ParameterDirection.ReturnValue;
con.Open();
try
{
cm.ExecuteNonQuery();
return(output.Value.ToString());
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
return("No existe");
}
}
}
public void Insert_Pedido(DateTime fecha, int monto)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("InsertPedido", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("fecha", OracleDbType.Date).Value = fecha;
cm.Parameters.Add("monto", OracleDbType.Int32).Value = monto;
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
}
public bool ingresaRelacion(int id_plato, int cantidad)
{
try
{
OracleConnection con = new Conexion().conexion();
OracleCommand cm = new OracleCommand("add_ordenPlato", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("id_pla", OracleDbType.Int32).Value = id_plato;
cm.Parameters.Add("cantidad", OracleDbType.Int32).Value = cantidad;
con.Open();
cm.ExecuteNonQuery();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public DataTable GetAllOrdenesByBoleta(int numBoleta)
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("GetAllDetalleByBoleta", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
OracleParameter output = cm.Parameters.Add("my_cursor", OracleDbType.RefCursor);
cm.Parameters.Add("num_boleta", OracleDbType.Int32).Value = numBoleta;
output.Direction = System.Data.ParameterDirection.ReturnValue;
con.Open();
cm.ExecuteNonQuery();
OracleDataReader reader = ((OracleRefCursor)output.Value).GetDataReader();
con.Close();
DataTable dt = new DataTable();
OracleDataAdapter adapter = new OracleDataAdapter(cm);
adapter.Fill(dt);
return(dt);
}
}
public bool CreaOrden(int num_boleta)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("add_orden", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("id_boleta", OracleDbType.Int32).Value = num_boleta;
con.Open();
cm.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public int Get_bebyid(string nom)
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("Get_bebyid", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("nomb", OracleDbType.Varchar2).Value = nom;
OracleParameter output = cm.Parameters.Add("my_cursor", OracleDbType.Int32);
output.Direction = System.Data.ParameterDirection.ReturnValue;
con.Open();
try
{
cm.ExecuteNonQuery();
return(Int32.Parse(output.Value.ToString()));
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
return(0);
}
}
}
public bool EliminarReserva(int id_res)
{
try
{
OracleConnection con = new Conexion().conexion();
con.Open();
OracleCommand com = new OracleCommand("Delete_reserva", con);
com.BindByName = true;
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add("id_reserv", OracleDbType.Int32).Value = id_res;
com.ExecuteNonQuery();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool GetNick(string nick)
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("Get_nickuser", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("nick", OracleDbType.Varchar2).Value = nick;
OracleParameter output = cm.Parameters.Add("my_cursor", OracleDbType.RefCursor);
output.Direction = System.Data.ParameterDirection.ReturnValue;
con.Open();
try
{
cm.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
}
OracleDataReader reader = ((OracleRefCursor)output.Value).GetDataReader();
con.Close();
using (DataTable dt = new DataTable())
{
OracleDataAdapter adapter = new OracleDataAdapter(cm);
adapter.Fill(dt);
int num = dt.Rows.Count;
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
public string Get_nombrecompleto(int rut)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("Get_nombre_usuarioby_Rut", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("p_rut", OracleDbType.Int32).Value = rut;
OracleParameter output = cm.Parameters.Add("my_cursor", OracleDbType.Varchar2, 40);
output.Direction = System.Data.ParameterDirection.ReturnValue;
con.Open();
cm.ExecuteNonQuery();
con.Close();
return(output.Value.ToString());
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
return("");
}
}
public bool reduceStock(int idbeb, int cantidad)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("reduce_stock_bebestible", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("idbeb", OracleDbType.Int32).Value = idbeb;
cm.Parameters.Add("cantidad", OracleDbType.Int32).Value = cantidad;
con.Open();
cm.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool PagaBoleta(int numbol, string status)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleCommand cm = new OracleCommand("UpdateEstadoBoleta", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("numbol", OracleDbType.Int32).Value = numbol;
cm.Parameters.Add("status", OracleDbType.Varchar2).Value = status;
con.Open();
cm.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool AgregarReserva(int rut, DateTime fechahora, int id_mesa)
{
try
{
OracleConnection con = new Conexion().conexion();
con.Open();
OracleCommand com = new OracleCommand("Insert_reserva", con);
com.BindByName = true;
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add("id_cliente", OracleDbType.Int32).Value = rut;
com.Parameters.Add("fecha", OracleDbType.Date).Value = fechahora;
com.Parameters.Add("mesa_id", OracleDbType.Int32).Value = id_mesa;
com.ExecuteNonQuery();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool CreaRelacion(double cantidad, int ing_id)
{
try
{
using (OracleConnection con = new Conexion().conexion())
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cm = new OracleCommand("crea_relacion_plato_ing", con);
cm.BindByName = true;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.Add("cantidad", OracleDbType.Double).Value = cantidad;
cm.Parameters.Add("ing_id", OracleDbType.Int32).Value = ing_id;
con.Open();
cm.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine("" + ex);
return(false);
}
}
public DataTable getGarzones()
{
try
{
OracleConnection con = new Conexion().conexion();
con.Open();
OracleCommand com = new OracleCommand("GetGarzones", con);
com.BindByName = true;
com.CommandType = System.Data.CommandType.StoredProcedure;
OracleParameter output = com.Parameters.Add("my_cursor", OracleDbType.RefCursor);
output.Direction = System.Data.ParameterDirection.ReturnValue;
com.ExecuteNonQuery();
OracleDataReader reader = ((OracleRefCursor)output.Value).GetDataReader();
DataTable dt = new DataTable();
dt.Load(reader);
con.Close();
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
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);
}
}
