Example #1
0
        public long GetUser(string email, string hash)
        {
            long _result = -1;

            if (Connected)
            {
                using (SqlDataReader _reader = new SqlCommand(string.Format("Select * from MarketUser Where Email='{0}'", email), _sql).ExecuteReader())
                {
                    if (_reader.HasRows)
                    {
                        while (_reader.Read())
                        {
                            if (_reader.GetString(_reader.GetOrdinal("Password")).Equals(hash))
                            {
                                _result = _reader.GetInt64(_reader.GetOrdinal("UserId"));
                            }
                        }
                    }
                }
            }

            return _result;
        }
 /// <summary>
 /// Get tag ID data from the SQL database table.
 /// </summary>
 public void GetData(ListView listview)
 {
     using (sqlConn = new SqlConnection(connectionString))
     {
         sqlConn.Open();
         using (SqlDataReader reader = new SqlCommand("SELECT * FROM TagInfo", sqlConn).ExecuteReader())
         {
             try
             {
                 while (reader.Read())
                 {
                     string[] rowitem = new string[2];
                     rowitem[0] = reader.GetString(reader.GetOrdinal("TagId"));
                     rowitem[1] = reader.GetDateTime(reader.GetOrdinal("TagTime")).ToString();
                     ListViewItem listitem = new ListViewItem(rowitem);
                     //table.Rows.Add(epc, time);
                     listview.Items.Add(listitem);
                 }
                 reader.Close();
             }
             catch (System.Data.SqlClient.SqlException ee)
             {
                 MessageBox.Show(ee.Message.ToString());
             }
         }
         sqlConn.Close();
     }
 }
Example #3
0
        public bool IsToken(long id, string AccessToken)
        {
            bool _result = false;

            if (Connected)
            {
                using (SqlDataReader _reader = new SqlCommand(string.Format("Select * From MarketToken Where UserId='{0}'", id), _sql).ExecuteReader())
                {
                    if (_reader.HasRows)
                    {
                        while (_reader.Read())
                        {
                            if (_reader.GetString(_reader.GetOrdinal("AccessToken")).Equals(AccessToken))
                            {
                                _result = true;

                                break;
                            }
                        }
                    }

                }
            }

            return _result;
        }