public Pedido Buscar(int pCodigo)
{
SqlConnection c = Conexion.Conectar();
SqlCommand cmd = new SqlCommand("BuscarPedido", c);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("num", pCodigo));
SqlDataReader dr = cmd.ExecuteReader();
Pedido p = null;
perMedicamento pmed = new perMedicamento();
perCliente pcli = new perCliente();
perFarmaceutica pfar = new perFarmaceutica();
while (dr.Read())
{
p = new Pedido(pmed.Buscar(pfar.Buscar(Convert.ToInt64(dr["Rut"].ToString())), Convert.ToInt32(dr["codMedicamento"].ToString())), pcli.Buscar(dr["username"].ToString()), pCodigo, Convert.ToInt32(dr["cantidad"].ToString()), (dr["estado"].ToString()));
}
dr.Close();
Conexion.Desconectar(c);
if (p == null)
{
throw new Exception("No existe el pedido");
}
return(p);
}
public List <Pedido> ListarPedido()
{
List <Pedido> lista = new List <Pedido>();
SqlConnection c = Conexion.Conectar();
SqlCommand cmd = new SqlCommand("ListarPedido", c);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
Pedido p = null;
perCliente pcli = new perCliente();
perMedicamento pmed = new perMedicamento();
perFarmaceutica pfar = new perFarmaceutica();
while (dr.Read())
{
p = new Pedido(pmed.Buscar(pfar.Buscar(Convert.ToInt64(dr["Rut"].ToString())), Convert.ToInt32(dr["codMedicamento"].ToString())), pcli.Buscar(dr["username"].ToString()), Convert.ToInt32(dr["numero"].ToString()), Convert.ToInt32(dr["cantidad"].ToString()), (dr["estado"].ToString()));
lista.Add(p);
}
dr.Close();
Conexion.Desconectar(c);
return(lista);
}
public List <Medicamento> Listar()
{
List <Medicamento> lista = new List <Medicamento>();
SqlConnection c = Conexion.Conectar();
SqlCommand cmd = new SqlCommand("ListarMedicamentos", c);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
perFarmaceutica perf = new perFarmaceutica();
while (dr.Read())
{
Medicamento m = new Medicamento(perf.Buscar(Convert.ToInt64(dr["rut"].ToString())), Convert.ToInt32(dr["codigo"].ToString()), dr["nombre"].ToString(), dr["descipcion"].ToString(), Convert.ToDecimal(dr["precio"].ToString()));
lista.Add(m);
}
dr.Close();
Conexion.Desconectar(c);
return(lista);
}
