public LoginFieldS GetDataFromID(byte[] iD) { try { LoginFieldS lp = new LoginFieldS(); DataTable DB = new DataTable(); int idRecord = BitConverter.ToInt32(iD, 0); var sql = string.Format("select * from \"main\".\"logins\" where rowid={0} ", idRecord); using (SQLiteConnection connect = new SQLiteConnection(ConnectionString)) { connect.Open(); SQLiteCommand command = new SQLiteCommand(sql, connect); SQLiteDataAdapter adapter = new SQLiteDataAdapter(command); adapter.Fill(DB); int rows = DB.Rows.Count; lp = new LoginFieldS { url = (DB.Rows[0][0] == DBNull.Value) ? string.Empty : encode.Base64Decode(DB.Rows[0][0].ToString()), action = (DB.Rows[0][1] == DBNull.Value) ? string.Empty : encode.Base64Decode(DB.Rows[0][1].ToString()), userName = (DB.Rows[0][2] == DBNull.Value) ? string.Empty : encode.Base64Decode((string)DB.Rows[0][2].ToString()), title = (DB.Rows[0][4] == DBNull.Value) ? string.Empty : encode.Base64Decode((string)DB.Rows[0][4]), appID = (DB.Rows[0][5] == DBNull.Value) ? string.Empty : encode.Base64Decode(DB.Rows[0][5].ToString()), rowid = (DB.Rows[0][7] == DBNull.Value) ? string.Empty : DB.Rows[0][7].ToString() }; adapter.Dispose(); connect.Close(); return(lp); } } catch (Exception ex) { return(null); } }
public bool CheckExistUser(string username, string url) { try { LoginFieldS lp = new LoginFieldS(); DataTable DB = new DataTable(); var sql = string.Format("select username_value from \"main\".\"logins\" where origin_url=\"{0}\" ", encode.Base64Encode(url)); using (SQLiteConnection connect = new SQLiteConnection(ConnectionString)) { connect.Open(); SQLiteCommand command = new SQLiteCommand(sql, connect); SQLiteDataAdapter adapter = new SQLiteDataAdapter(command); adapter.Fill(DB); int rows = DB.Rows.Count; for (int i = 0; i < rows; i++) { if (encode.Base64Decode(DB.Rows[i][0].ToString()) == username) { return(true); } } adapter.Dispose(); connect.Close(); return(false); } } catch (Exception ex) { return(false); } }