public static Medicamento Buscar(Int64 oRUC, int oCodigo)
{
Int64 ruc;
int codigo, precio;
string nombre, descripcion;
Medicamento oMed = null;
SqlDataReader oReader;
SqlConnection oConexion = new SqlConnection(Conexion.STR);
SqlCommand oComando = new SqlCommand("BuscarMedicamento", oConexion);
oComando.CommandType = CommandType.StoredProcedure;
oComando.Parameters.AddWithValue("@far", oRUC);
oComando.Parameters.AddWithValue("@codigo", oCodigo);
try
{
oConexion.Open();
oReader = oComando.ExecuteReader();
if (oReader.HasRows)
{
if (oReader.Read())
{
ruc = (Int64)oReader["ruc"];
codigo = (int)oReader["codigo"];
precio = (int)oReader["precio"];
nombre = (string)oReader["nombre"];
descripcion = (string)oReader["descripcion"];
Farmaceutica oFar = PersistenciaFarmaceutica.Buscar(oRUC);
oMed = new Medicamento(oFar, codigo, nombre, descripcion, precio);
}
}
oReader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConexion.Close();
}
return(oMed);
}
//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 POR FARMACEUTICA
public List <Medicamento> ListarMedicamentoPorFarmaceutica(Farmaceutica farmaceutica)
{
//GET CONNECTION STRING
SqlConnection connection = new SqlConnection(Conexion.ConnectionString);
//STORED PROCEDURE
SqlCommand Command = new SqlCommand("ListarMedicamentoPorFarmaceutica", connection);
Command.CommandType = CommandType.StoredProcedure;
//PARAMETRO
Command.Parameters.AddWithValue("@RUC", farmaceutica.pRUC);
//READER
SqlDataReader Reader;
//PREPARAR VARIABLES
int Codigo;
string Descripcion;
double Precio;
string Nombre;
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"];
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);
}
public static List <Medicamento> ListarMedicamentoUnico(Medicamento Medi)
{
Medicamento oMed;
List <Medicamento> oLista = new List <Medicamento>();
SqlDataReader oReader;
SqlConnection oConexion = new SqlConnection(Conexion.STR);
SqlCommand oComando = new SqlCommand("ListarMedicamentoUnico", oConexion);
oComando.CommandType = CommandType.StoredProcedure;
oComando.Parameters.AddWithValue("@ruc", Medi.Far.ruc);
oComando.Parameters.AddWithValue("@codigo", Medi.Codigo);
try
{
oConexion.Open();
oReader = oComando.ExecuteReader();
if (oReader.HasRows)
{
oReader.Read();
Int64 ruc = (Int64)oReader["ruc"];
int codigo = (int)oReader["codigo"];
string nombre = (string)oReader["nombre"];
string descripcion = (string)oReader["descripcion"];
int precio = (int)oReader["precio"];
Farmaceutica oFar = PersistenciaFarmaceutica.Buscar(ruc);
oMed = new Medicamento(oFar, codigo, nombre, descripcion, precio);
oLista.Add(oMed);
}
oReader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConexion.Close();
}
return(oLista);
}
public static List <Medicamento> Listar()
{
Medicamento oMed;
List <Medicamento> oLista = new List <Medicamento>();
SqlDataReader oReader;
SqlConnection oConexion = new SqlConnection(Conexion.STR);
SqlCommand oComando = new SqlCommand("ListarMedicamento", oConexion);
oComando.CommandType = CommandType.StoredProcedure;
try
{
oConexion.Open();
oReader = oComando.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
Int64 ruc = (Int64)oReader["ruc"];
Farmaceutica oFar = PersistenciaFarmaceutica.Buscar(ruc);
oMed = new Medicamento(oFar, (int)oReader["codigo"], (string)oReader["nombre"], (string)oReader["descripcion"],
(int)oReader["precio"]);
oLista.Add(oMed);
}
}
oReader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConexion.Close();
}
return(oLista);
}
public static List <Farmaceutica> ListarFarmaceuticas()
{
Farmaceutica oFar;
Int64 ruc;
List <Farmaceutica> oLista = new List <Farmaceutica>();
SqlDataReader oReader;
SqlConnection oConexion = new SqlConnection(Conexion.STR);
SqlCommand oComando = new SqlCommand("ListarFarmaceuticas", oConexion);
oComando.CommandType = CommandType.StoredProcedure;
try
{
oConexion.Open();
oReader = oComando.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
ruc = (Int64)oReader["ruc"];
oFar = PersistenciaFarmaceutica.Buscar(ruc);
oLista.Add(oFar);
}
oReader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConexion.Close();
}
return(oLista);
}
public static Medicamento Buscar(int codigo, int ruc)
{
Medicamento m = null;
SqlConnection cn = new SqlConnection(Conexion.str);
SqlCommand cmd = new SqlCommand("buscarmedicamento", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("codigo", codigo);
cmd.Parameters.AddWithValue("ruc", ruc);
SqlDataReader reader;
try
{
cn.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
codigo = (int)reader["codigo"];
string nombre = (string)reader["nombre"];
string desc = (string)reader["descripcion"];
ruc = (int)reader["ruc"];
double precio = (double)reader["precio"];
Farmaceutica farma = PersistenciaFarmaceutica.Buscar(ruc);
m = new Medicamento(codigo, farma, nombre, desc, precio);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
cn.Close();
}
return(m);
}
public static List <Medicamento> Listar()
{
List <Medicamento> listMed = new List <Medicamento>();
SqlConnection cn = new SqlConnection(Conexion.str);
SqlCommand cmd = new SqlCommand("listamedicamentos", cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader;
try
{
cn.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int codigo = (int)reader["codigo"];
int ruc = (int)reader["ruc"];
string nombre = (string)reader["nombre"];
string desc = (string)reader["descripcion"];
double precio = (double)reader["precio"];
Farmaceutica f = PersistenciaFarmaceutica.Buscar(ruc);
Medicamento m = new Medicamento(codigo, f, nombre, desc, precio);
listMed.Add(m);
}
reader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
cn.Close();
}
return(listMed);
}
