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