Esempio n. 1
0
        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);
        }
Esempio n. 2
0
 private void LIMPIAR_ERROR_DATOS_PAGO()
 {
     ERRORDEPAGOS.SetError(TXTNUMRECIBO, null);
 }