protected void ddlFarmaceutica_SelectedIndexChanged(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(ddlFarmaceutica.SelectedItem.Value)) { LogicaFarmaceutica logicaFarmaceutica = new LogicaFarmaceutica(); Farmaceutica farmaceutica = logicaFarmaceutica.BuscarFarmaceutica(ddlFarmaceutica.SelectedItem.Value); LogicaMedicamento logicaMedicamento = new LogicaMedicamento(); Session["ListaMedicamentos"] = logicaMedicamento.ListarMedicamentoPorFarmaceutica(farmaceutica); gvMedicamentos.DataSource = (List <Medicamento>)Session["ListaMedicamentos"]; gvMedicamentos.DataBind(); //LIMPIAR GRIDVIEW PEDIDOS gvPedidos.DataSource = null; gvPedidos.DataBind(); } } catch (Exception ex) { lblERROR.ForeColor = System.Drawing.Color.Red; lblERROR.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { ddl.DataSource = negFarmaceutica.Listar(); ddl.DataTextField = "nombre"; ddl.DataValueField = "ruc"; ddl.DataBind(); } catch (Exception ex) { lblError.Text = ex.Message; } } GridView1.Visible = false; ddlEstado.Visible = false; Farmaceutica f = negFarmaceutica.Buscar(Convert.ToInt64(ddl.SelectedValue)); Session["farmaceutica"] = f; List <Medicamento> lm = negMedicamento.ListarPorFarmaceutica(f); grdMedicamentos.DataSource = lm; grdMedicamentos.DataBind(); }
protected void btnAlta_Click(object sender, EventArgs e) { try { Int64 oRUC = Convert.ToInt64(txtRucMedicamento.Text.Trim()); Farmaceutica oFar = LogicaFarmaceutica.Buscar(oRUC); int oCodigo = Convert.ToInt32(txtCodMedicamento.Text.Trim()); string oNombre = txtNombreMed.Text.Trim(); string oDescripcion = txtDescripcion.Text.Trim(); int oPrecio = Convert.ToInt32(txtPrecio.Text.Trim()); Medicamento oMed = new Medicamento(oFar, oCodigo, oNombre, oDescripcion, oPrecio); btnAlta.Enabled = false; btnBuscar.Enabled = false; LogicaMedicamento.Alta(oMed); lblError.Text = "Alta exitosa"; } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { ddlFarmaceuticas.DataSource = LogicaFarmaceutica.Listar(); ddlFarmaceuticas.DataTextField = "Nombre"; ddlFarmaceuticas.DataValueField = "Ruc"; ddlFarmaceuticas.AutoPostBack = true; ddlFarmaceuticas.DataBind(); Farmaceutica f = LogicaFarmaceutica.Buscar(Convert.ToInt32(ddlFarmaceuticas.SelectedValue)); List <Medicamento> lista = LogicaMedicamento.Listar(f); Session["listamed"] = lista; gvMedicamentos.DataSource = lista; gvMedicamentos.DataBind(); } catch (Exception ex) { lblError.Text = ex.Message; } } }
protected void btnBuscar_Click(object sender, EventArgs e) { lblError.Text = string.Empty; try { if (txtRuc.Text.Length != 12) { throw new Exception("Ingrese un Rut valido"); } Farmaceutica f = negFarmaceutica.Buscar(Convert.ToInt64(txtRuc.Text)); Medicamento m = negMedicamento.Buscar(f, Convert.ToInt32(txtCodigo.Text)); if (m == null) { NoEncontrado(); } else { txtNombre.Text = m.Nombre; txtDescripcion.Text = m.Descripcion; txtPrecio.Text = m.Precio.ToString(); Encontrado(); Session["medicamento"] = m; } } catch (Exception ex) { lblError.Text = ex.Message; } }
public Medicamento Buscar(Farmaceutica pFarmaceutica, int pCodigo) { SqlConnection c = Conexion.Conectar(); SqlCommand cmd = new SqlCommand("BuscarMedicamento", c); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("rut", pFarmaceutica.Ruc)); cmd.Parameters.Add(new SqlParameter("codigo", pCodigo)); SqlDataReader dr = cmd.ExecuteReader(); Medicamento m = null; while (dr.Read()) { m = new Medicamento(pFarmaceutica, Convert.ToInt32(dr["codigo"].ToString()), dr["nombre"].ToString(), dr["descipcion"].ToString(), Convert.ToDecimal(dr["precio"].ToString())); } dr.Close(); Conexion.Desconectar(c); return(m); }
public List <Medicamento> ListarPorFarmaceutica(Farmaceutica pFarmaceutica) { List <Medicamento> lista = new List <Medicamento>(); SqlConnection c = Conexion.Conectar(); SqlCommand cmd = new SqlCommand("MedicamentosxFarmaceutica", c); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("rut", pFarmaceutica.Ruc)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Medicamento m = new Medicamento(pFarmaceutica, 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); }
protected void btnBuscar_Click(object sender, EventArgs e) { lblError.Text = string.Empty; try { if (txtRuc.Text.Length != 12) { throw new Exception("ingrese un Rut valido"); } Farmaceutica f = negFarmaceutica.Buscar(Convert.ToInt64(txtRuc.Text)); if (f == null) { NoEncontrado(); } else { txtNombre.Text = f.Nombre; txtCorreo.Text = f.Correo; txtDireccion.Text = f.Direccion; Encontrado(); Session["farmaceutica"] = f; } } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void grdMedicamentos_SelectedIndexChanged(object sender, EventArgs e) { try { GridView1.Visible = true; ddlEstado.SelectedIndex = 0; lblError.Text = string.Empty; Farmaceutica f = (Farmaceutica)Session["farmaceutica"]; Medicamento m = negMedicamento.Buscar(f, Convert.ToInt32(grdMedicamentos.SelectedRow.Cells[1].Text)); Session["m"] = m; GridView1.DataSource = negPedido.ListarPorMedicamento(m, "Todos"); GridView1.DataBind(); ddlEstado.Visible = true; if (negPedido.ListarPorMedicamento(m, "Todos").Count == 0) { ddlEstado.Visible = false; throw new Exception("No se encontraron pedidos de este medicamento"); } } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void btnListar_Click(object sender, EventArgs e) { try { string Seleccion = ddlListadoMedicamento.SelectedValue; Farmaceutica oFar = LogicaFarmaceutica.BuscarXNombre(Seleccion); List <Medicamento> oLista = LogicaMedicamento.ListarMedicamentosXFarmaceutica(oFar); if (oLista != null) { gvListadoMedicamento.DataSource = oLista; gvListadoMedicamento.DataBind(); } else { lblError.Text = oFar.nombre + " aun no tiene medicamentos asociados."; } } catch (Exception ex) { lblError.Text = ex.Message; } }
public static Medicamento Buscar(Farmaceutica pFarmaceutica, int pCodigo) { perMedicamento pm = new perMedicamento(); Medicamento m = pm.Buscar(pFarmaceutica, pCodigo); return(m); }
public static Farmaceutica Buscar(long pRuc) { perFarmaceutica pf = new perFarmaceutica(); Farmaceutica f = pf.Buscar(pRuc); return(f); }
//LISTAR MEDICAMENTO POR FARMACEUTICA public List <Medicamento> ListarMedicamentoPorFarmaceutica(Farmaceutica farmaceutica) { try { PersistenciaMedicamento persistenciaMedicamento = new PersistenciaMedicamento(); return(persistenciaMedicamento.ListarMedicamentoPorFarmaceutica(farmaceutica)); } catch { throw; } }
public static Farmaceutica BuscarXNombre(string Nombre) { string correo, calle, nombre; int numero, apto; Int64 ruc; Farmaceutica oFar = null; SqlDataReader oReader; SqlConnection oConexion = new SqlConnection(Conexion.STR); SqlCommand oComando = new SqlCommand("BuscarFarmaceuticaXNombre", oConexion); oComando.CommandType = CommandType.StoredProcedure; oComando.Parameters.AddWithValue("@nombre", Nombre); try { oConexion.Open(); oReader = oComando.ExecuteReader(); if (oReader.HasRows) { if (oReader.Read()) { nombre = (string)oReader["nombre"]; ruc = (Int64)oReader["ruc"]; correo = (string)oReader["correo"]; calle = (string)oReader["calle"]; numero = (int)oReader["numero"]; if (oReader["apto"] != DBNull.Value) { apto = (int)oReader["apto"]; } else { apto = 1; } oFar = new Farmaceutica(ruc, nombre, correo, calle, numero, apto); } } oReader.Close(); } catch (Exception ex) { throw ex; } finally { oConexion.Close(); } return(oFar); }
//MODIFICAR FARMACEUTICA public void ModificarFarmaceutica(Farmaceutica farmaceutica) { try { PersistenciaFarmaceutica persistenciaFarmaceutica = new PersistenciaFarmaceutica(); persistenciaFarmaceutica.ModificarFarmaceutica(farmaceutica); } catch (Exception ex) { throw ex; } }
protected void btnEliminar_Click(object sender, EventArgs e) { try { Farmaceutica farma = (Farmaceutica)Session["farmaceutica"]; LogicaFarmaceutica.Eliminar(farma); } catch (Exception ex) { lblError.Text = ex.Message; } }
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); }
//MODIFICAR FARMACEUTICA public void ModificarFarmaceutica(Farmaceutica farmaceutica) { //GET CONNECTION STRING SqlConnection connection = new SqlConnection(Conexion.ConnectionString); //STORED PROCEDURE SqlCommand sp = new SqlCommand("ModificarFarmaceutica", connection); sp.CommandType = CommandType.StoredProcedure; //PARAMETROS sp.Parameters.AddWithValue("@RUC", farmaceutica.pRUC); sp.Parameters.AddWithValue("@Nombre", farmaceutica.pNombre); sp.Parameters.AddWithValue("@CorreoElectronico", farmaceutica.pCorreoElectronico); sp.Parameters.AddWithValue("@Direccion", farmaceutica.pDireccion); //RETORNO SqlParameter retorno = new SqlParameter("@retorno", SqlDbType.Int); retorno.Direction = ParameterDirection.ReturnValue; sp.Parameters.Add(retorno); try { connection.Open(); //MODIFICAR FARMACEUTICA sp.ExecuteNonQuery(); //RETORNO switch ((int)retorno.Value) { case 1: //EXITO break; //FARMACEUTICA NO EXISTE case -1: throw new Exception("El RUC no existe."); //EXCEPCION NO CONTROLADA default: throw new Exception("Ha ocurrido un error vuelva a intentarlo mas tarde."); } } catch { throw; } finally { connection.Close(); } }
protected void ddlFarmaceuticas_SelectedIndexChanged(object sender, EventArgs e) { try { Farmaceutica f = LogicaFarmaceutica.Buscar(Convert.ToInt32(ddlFarmaceuticas.SelectedValue)); List <Medicamento> lista = LogicaMedicamento.Listar(f); Session["listamed"] = lista; gvMedicamentos.DataSource = lista; gvMedicamentos.DataBind(); } catch (Exception ex) { lblError.Text = ex.Message; } }
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); }
protected void btnModificar_Click(object sender, EventArgs e) { try { Farmaceutica farma = (Farmaceutica)Session["farmaceutica"]; farma.Nombre = txtNombre.Text.Trim(); farma.Correo = txtCorreo.Text.Trim(); farma.Direccion = txtDireccion.Text.Trim(); LogicaFarmaceutica.Modificar(farma); } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void btnTodos_Click(object sender, EventArgs e) { try { string Seleccion = ddlListadoMedicamento.SelectedValue; Farmaceutica oFar = LogicaFarmaceutica.BuscarXNombre(Seleccion); gvListadoMedicamento.DataSource = LogicaMedicamento.ListarMedicamentosXFarmaceutica(oFar); gvListadoMedicamento.DataBind(); } catch (Exception ex) { lblError.Text = ex.Message; } }
//BUSCAR FARMACEUTICA public Farmaceutica BuscarFarmaceutica(string RUC) { //GET CONNECTION STRING SqlConnection connection = new SqlConnection(Conexion.ConnectionString); //STORED PROCEDURE SqlCommand sp = new SqlCommand("BuscarFarmaceutica", connection); sp.CommandType = CommandType.StoredProcedure; //PARAMETROS sp.Parameters.AddWithValue("@RUC", RUC); //READER SqlDataReader reader; //PREPARAR VARIABLES Farmaceutica farmaceutica; string Nombre; string CorreoElectronico; string Direccion; try { connection.Open(); reader = sp.ExecuteReader(); if (reader.Read()) { Nombre = (string)reader["Nombre"]; CorreoElectronico = (string)reader["CorreoElectronico"]; Direccion = (string)reader["Direccion"]; farmaceutica = new Farmaceutica(RUC, Nombre, CorreoElectronico, Direccion); reader.Close(); } else { return(null); } return(farmaceutica); } catch { throw; } finally { connection.Close(); } }
protected void btnEliminar_Click(object sender, EventArgs e) { lblError.Text = string.Empty; try { Farmaceutica f = (Farmaceutica)Session["farmaceutica"]; negFarmaceutica.Baja(f); Limpiar(); lblError.Text = "Farmacéutica eliminada con éxito"; } catch (Exception ex) { lblError.Text = ex.Message; } }
//LISTAR FARMACEUTICAS public List <Farmaceutica> ListarFarmaceuticas() { //GET CONNECTION STRING SqlConnection connection = new SqlConnection(Conexion.ConnectionString); //STORED PROCEDURE SqlCommand Command = new SqlCommand("ListarFarmaceutica", connection); Command.CommandType = CommandType.StoredProcedure; //READER SqlDataReader Reader; //PREPARAR VARIABLES string RUC; string Nombre; string CorreoElectronico; string Direccion; Farmaceutica farmaceutica = null; List <Farmaceutica> List = new List <Farmaceutica>(); try { connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { RUC = (string)Reader["RUC"]; Nombre = (string)Reader["Nombre"]; CorreoElectronico = (string)Reader["CorreoElectronico"]; Direccion = (string)Reader["Direccion"]; farmaceutica = new Farmaceutica(RUC, Nombre, CorreoElectronico, Direccion); List.Add(farmaceutica); } Reader.Close(); } catch (Exception ex) { throw new ApplicationException("Error en la base de datos: " + ex.Message); } finally { connection.Close(); } return(List); }
protected void btnEliminar_Click(object sender, EventArgs e) { try { Farmaceutica oFar = (Farmaceutica)Session["FarmaceuticaABM"]; Logica.LogicaFarmaceutica.Eliminar(oFar); this.LimpioFormulario(); lblError.Text = "Eliminacion exitosa"; } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void btnModificar_Click(object sender, EventArgs e) { try { LogicaFarmaceutica logicaFarmaceutica = new LogicaFarmaceutica(); LogicaMedicamento logicaMedicamento = new LogicaMedicamento(); Farmaceutica farmaceutica = logicaFarmaceutica.BuscarFarmaceutica(ddlFarmaceuticas.SelectedItem.Value); if (farmaceutica == null) { throw new Exception("La farmaceutica no existe."); } string descripcion = txtDescripcion.Text; double precio; string nombre = txtNombre.Text; int codigo; //VARIFICAR INT try { codigo = Convert.ToInt32(txtCodigo.Text); } catch { throw new Exception("El codigo debe ser un numero."); } //VERIFICAR DOUBLE try { precio = double.Parse(txtPrecio.Text); } catch { throw new Exception("El precio debe ser un numero."); } Medicamento medicamento = new Medicamento(codigo, farmaceutica, nombre, descripcion, precio); logicaMedicamento.ModificarMedicamento(medicamento); lblERROR.ForeColor = System.Drawing.Color.Green; lblERROR.Text = "Modificacion exitosa."; } catch (Exception ex) { lblERROR.ForeColor = System.Drawing.Color.Red; lblERROR.Text = ex.Message; } }
public void Baja(Farmaceutica f) { SqlConnection c = Conexion.Conectar(); SqlCommand cmd = new SqlCommand("EliminarFarmaceutica", c); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("rut", f.Ruc)); SqlParameter r = new SqlParameter(); r.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(r); cmd.ExecuteNonQuery(); Conexion.Desconectar(c); int a = Convert.ToInt32(r.Value.ToString()); switch (a) { case -1: { throw new Exception("No existe la farmacéutica."); } case -2: { throw new Exception("No es posible eliminar ya que tiene pedidos asociados."); } case 1: { break; } default: { throw new Exception("Error desconocido."); } } }