//BUSCAR MEDICAMENTO public Medicamento BuscarMedicamento(int Codigo, string RucFarmaceutica) { //GET CONNECTION STRING SqlConnection connection = new SqlConnection(Conexion.ConnectionString); //STORED PROCEDURE SqlCommand sp = new SqlCommand("BuscarMedicamento", connection); sp.CommandType = CommandType.StoredProcedure; //PARAMETROS sp.Parameters.AddWithValue("@Codigo", Codigo); sp.Parameters.AddWithValue("@Farmaceutica", RucFarmaceutica); //READER SqlDataReader reader; try { //PREPARAR VARIABLES PersistenciaFarmaceutica persistenciaFarmaceutica = new PersistenciaFarmaceutica(); Medicamento medicamento; string Nombre; double Precio; string Descripcion; Farmaceutica farmaceutica = persistenciaFarmaceutica.BuscarFarmaceutica(RucFarmaceutica); connection.Open(); reader = sp.ExecuteReader(); if (reader.Read()) { Nombre = (string)reader["Nombre"]; Precio = (double)reader["Precio"]; Descripcion = (string)reader["Descripcion"]; medicamento = new Medicamento(Codigo, farmaceutica, Nombre, Descripcion, Precio); reader.Close(); } else { return(null); } return(medicamento); } catch { throw; } finally { connection.Close(); } }
//LISTAR MEDICAMENTO public List <Medicamento> ListarMedicamento() { //GET CONNECTION STRING SqlConnection connection = new SqlConnection(Conexion.ConnectionString); //STORED PROCEDURE SqlCommand Command = new SqlCommand("ListarMedicamento", connection); Command.CommandType = CommandType.StoredProcedure; //READER SqlDataReader Reader; //PREPARAR VARIABLES int Codigo; string Descripcion; double Precio; string Nombre; Farmaceutica farmaceutica = null; Medicamento medicamento = null; List <Medicamento> List = new List <Medicamento>(); PersistenciaFarmaceutica persistenciaFarmaceutica = new PersistenciaFarmaceutica(); try { connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { Codigo = (int)Reader["Codigo"]; Descripcion = (string)Reader["Descripcion"]; Precio = (double)Reader["Precio"]; Nombre = (string)Reader["Nombre"]; farmaceutica = persistenciaFarmaceutica.BuscarFarmaceutica((string)Reader["Farmaceutica"]); medicamento = new Medicamento(Codigo, farmaceutica, Nombre, Descripcion, Precio); List.Add(medicamento); } Reader.Close(); } catch (Exception ex) { throw new ApplicationException("Error en la base de datos: " + ex.Message); } finally { connection.Close(); } return(List); }