private void Lector03_Load(object sender, EventArgs e)
{
try
{
//LLENAMOS EL COMBO BOX de Distrito
cboDistrito.DataSource = objDistritoBL.ListarDistrito();
cboDistrito.DisplayMember = "Nombre_Distrito";
cboDistrito.ValueMember = "IdDistrito";
objLectorBE = objLectorBL.ConsultarLector(this.Codigo);
// MOSTRAMOS LOS DATOS DEL LECTOR A ACTUALIZAR
txtNombre.Text = objLectorBE.Nom_Lector;
txtApePat.Text = objLectorBE.ApePat_Lector;
txtApeMat.Text = objLectorBE.ApeMat_Lector;
txtDni.Text = objLectorBE.Dni;
txtDir.Text = objLectorBE.Dir;
txtTel.Text = objLectorBE.Tel;
txtEmail.Text = objLectorBE.Email_Lector;
cboDistrito.SelectedValue = objLectorBE.Id_Distrito;
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
}
}
protected void grvLectores_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
int fila = Convert.ToInt16(e.CommandArgument);//Manejo la fila en la que hizo click
if (e.CommandName == "Editar")
{
String vcod = grvLectores.Rows[fila].Cells[1].Text;
objBE = objBL.ConsultarLector(vcod);
lblID.Text = objBE.Id_Lector;
txtNombres.Text = objBE.Nom_Lector;
txtApePaterno.Text = objBE.ApePat_Lector;
txtApeMaterno.Text = objBE.ApeMat_Lector;
txtDni.Text = objBE.Dni;
txtDireccion.Text = objBE.Dir;
txtTelefono.Text = objBE.Tel;
txtEmail.Text = objBE.Email_Lector;
txtDistrito.Text = objBE.Id_Distrito;
lblMensaje2.Text = String.Empty;
lblId2.Visible = true;
lblID.Visible = true;
hdfAccion.Value = "M";
PopMant.Show();
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
}
}
public Boolean InsertarLector(LectorBE objLectorBE)
{
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_InsertarLector";
try
{
//Agregamos parametros
cmd.Parameters.AddWithValue("@nom_lec", objLectorBE.Nom_Lector);
cmd.Parameters.AddWithValue("@apePat_lec", objLectorBE.ApePat_Lector);
cmd.Parameters.AddWithValue("@apeMat_lec", objLectorBE.ApeMat_Lector);
cmd.Parameters.AddWithValue("@dni_lec", objLectorBE.Dni);
cmd.Parameters.AddWithValue("@dir_lec", objLectorBE.Dir);
cmd.Parameters.AddWithValue("@tel_lec", objLectorBE.Tel);
cmd.Parameters.AddWithValue("@email_lec", objLectorBE.Email_Lector);
cmd.Parameters.AddWithValue("@id_dis", objLectorBE.Id_Distrito);
cnx.Open();
cmd.ExecuteNonQuery();
blnexito = true;
//Codifique
}
catch (SqlException x)
{
blnexito = false;
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(blnexito);
}
public LectorBE ConsultarLector(String strcod)
{
LectorBE objLectorBE = new LectorBE();
try
{
//Codifique
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_ConsultarLector";
cmd.Parameters.AddWithValue("@id_Lector", strcod);
cnx.Open();
dtr = cmd.ExecuteReader();
if (dtr.HasRows == true)
{
dtr.Read();
if (dtr["IdLector"] == DBNull.Value)
{
objLectorBE.Id_Lector = "";
}
else
{
objLectorBE.Id_Lector = dtr["IdLector"].ToString();
}
if (dtr["Nombre_Lector"] == DBNull.Value)
{
objLectorBE.Nom_Lector = "";
}
else
{
objLectorBE.Nom_Lector = dtr["Nombre_Lector"].ToString();
}
if (dtr["Ape_Paterno"] == DBNull.Value)
{
objLectorBE.ApePat_Lector = "";
}
else
{
objLectorBE.ApePat_Lector = dtr["Ape_Paterno"].ToString();
}
if (dtr["Ape_Materno"] == DBNull.Value)
{
objLectorBE.ApeMat_Lector = "";
}
else
{
objLectorBE.ApeMat_Lector = dtr["Ape_Materno"].ToString();
}
if (dtr["Dni"] == DBNull.Value)
{
objLectorBE.Dni = "";
}
else
{
objLectorBE.Dni = dtr["Dni"].ToString();
}
if (dtr["Direccion_Lector"] == DBNull.Value)
{
objLectorBE.Dir = "";
}
else
{
objLectorBE.Dir = dtr["Direccion_Lector"].ToString();
}
if (dtr["Telefono"] == DBNull.Value)
{
objLectorBE.Tel = "";
}
else
{
objLectorBE.Tel = dtr["Telefono"].ToString();
}
if (dtr["Email_Lector"] == DBNull.Value)
{
objLectorBE.Email_Lector = "";
}
else
{
objLectorBE.Email_Lector = dtr["Email_Lector"].ToString();
}
if (dtr["IdDistrito"] == DBNull.Value)
{
objLectorBE.Id_Distrito = "";
}
else
{
objLectorBE.Id_Distrito = dtr["IdDistrito"].ToString();
}
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(objLectorBE);
}
public Boolean ActualizarLector(LectorBE objLectorBE)
{
return(objLectorADO.ActualizarLector(objLectorBE));
}
public Boolean InsertarLector(LectorBE objLectorBE)
{
return(objLectorADO.InsertarLector(objLectorBE));
}
