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