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