private bool VERIFICA_DATOS_PAGO() { bool ok = true; if (TXTNUMRECIBO.Text == null) { ok = false; ERRORDEPAGOS.SetError(TXTNUMRECIBO, "INGRESA EL NUMERO DE RECIBO"); } if (TXTNUMRECIBO.Text != null) { try { SqlCommand cmd = new SqlCommand("verificar_recibo", _SqlConnection); cmd.CommandType = CommandType.StoredProcedure; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.Parameters.Add(new SqlParameter("@numrecibo", TXTNUMRECIBO.Text)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 1) { if (dt.Rows[0][0].ToString() == "1") { ok = false; ERRORDEPAGOS.SetError(TXTNUMRECIBO, "ESTE NUMERO DE RECIBO YA HA SIDO REGISTRADO!!!"); } } if (cmd.Connection.State == ConnectionState.Open) { cmd.Connection.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } return(ok); }
private void LIMPIAR_ERROR_DATOS_PAGO() { ERRORDEPAGOS.SetError(TXTNUMRECIBO, null); }