protected void btngrabar_Click(object sender, EventArgs e)
{
Int32 ind1, ind2, ind3;
Int32 idtencion, idPaciente;
Int32.TryParse(txhIDMedicamento.Value.ToString(), out idtencion);
Int32.TryParse(txhIdpaciente.Value.ToString(), out idPaciente);
ServicioEmergenciaBL oServicioEmergenciaBL = new ServicioEmergenciaBL();
ind1 = oServicioEmergenciaBL.InsertarServiciosEmergencia(idtencion, idPaciente);
foreach (GridViewRow grd_Row in this.grvExamen.Rows)
{
ind2 = oServicioEmergenciaBL.InsertarExamen(idtencion, Convert.ToInt32(grd_Row.Cells[0].Text));
}
foreach (GridViewRow grd_Row1 in this.grvMedicamentos.Rows)
{
TextBox txtCantidad = (TextBox)(grd_Row1.FindControl("txtCantidad"));
ind3 = oServicioEmergenciaBL.InsertarMedicamento(idtencion, Convert.ToInt32(grd_Row1.Cells[0].Text), Convert.ToInt32(txtCantidad.Text));
}
IniciaPagina();
this.oEmergenciaExamenesBEList = null;
this.oEmergenciaExamenesBEList.Add(new BE_Emergencia());
this.grvExamen.DataSource = this.oEmergenciaExamenesBEList;
this.grvExamen.DataBind();
this.oEmergenciaMedicamentosBEList = null;
this.oEmergenciaMedicamentosBEList.Add(new BE_Emergencia());
this.grvMedicamentos.DataSource = this.oEmergenciaMedicamentosBEList;
this.grvMedicamentos.DataBind();
}
public EmergenciaBEList GeallServiciosMedicamentosbyId(Int32 IdAtencion)
{
EmergenciaBEList oEmergenciaBEList = new EmergenciaBEList();
SqlDataReader SqlReader = null;
try
{
using (SqlConnection Conex = new SqlConnection(Configuraciones.CadenaConexion))
{
/*Propiedades del SqlCommand*/
SqlCommand = new SqlCommand();
SqlCommand.CommandText = "sgsnet_sps_servicios_medicamentos_by_id";
SqlCommand.Connection = Conex;
SqlCommand.CommandType = CommandType.StoredProcedure;
SqlPara = new SqlParameter("@vi_id_atencion", SqlDbType.Int);
SqlPara.Direction = ParameterDirection.Input;
SqlPara.Value = IdAtencion;
SqlCommand.Parameters.Add(SqlPara);
/*Abrir la Conexion del SqlReader*/
Conex.Open();
SqlReader = SqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
if (SqlReader.HasRows) // Si Contiene Filas
{
while (SqlReader.Read())
{
BE_Emergencia oDesarmeUnidadesBE = CrearEntidadServiciosMedicamentoById(SqlReader);
oEmergenciaBEList.Add(oDesarmeUnidadesBE);
}
}
/*Cerrando las Conexion SqlReader*/
SqlReader.Close();
}
}
catch (Exception ex)
{
if (SqlReader != null && !SqlReader.IsClosed)
{
SqlReader.Close();
}
throw ex;
}
return(oEmergenciaBEList);
}
public EmergenciaBEList GeallMedicamento()
{
EmergenciaBEList oEmergenciaBEList = new EmergenciaBEList();
SqlDataReader SqlReader = null;
try
{
using (SqlConnection Conex = new SqlConnection(Configuraciones.CadenaConexion))
{
/*Propiedades del SqlCommand*/
SqlCommand = new SqlCommand();
SqlCommand.CommandText = "sgsnet_sps_medicamento";
SqlCommand.Connection = Conex;
SqlCommand.CommandType = CommandType.StoredProcedure;
/*Abrir la Conexion del SqlReader*/
Conex.Open();
SqlReader = SqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
if (SqlReader.HasRows) // Si Contiene Filas
{
while (SqlReader.Read())
{
BE_Emergencia oDesarmeUnidadesBE = CrearEntidadMedicamento(SqlReader);
oEmergenciaBEList.Add(oDesarmeUnidadesBE);
}
}
/*Cerrando las Conexion SqlReader*/
SqlReader.Close();
}
}
catch (Exception ex)
{
if (SqlReader != null && !SqlReader.IsClosed)
{
SqlReader.Close();
}
throw ex;
}
return(oEmergenciaBEList);
}
private void IniciaMedicamentos(Int32 ID)
{
ServicioEmergenciaBL oServicioEmergenciaBL = new ServicioEmergenciaBL();
try
{
this.oEmergenciaMedicamentosBEList = oServicioEmergenciaBL.GeallServiciosMedicamentosbyId(ID);
if (this.oEmergenciaMedicamentosBEList == null || this.oEmergenciaMedicamentosBEList.Count == 0)
{
this.oEmergenciaMedicamentosBEList.Add(new BE_Emergencia());
}
this.grvMedicamentos.DataSource = this.oEmergenciaMedicamentosBEList;
this.grvMedicamentos.DataBind();
}
catch (Exception ex)
{
}
}
