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