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