public loginCookies getLogin(string site) { loginCookies login = new loginCookies(); try { cnn.Open(); string str = string.Format("SELECT site_id FROM sites WHERE site='{0}'", site); SQLiteCommand cmd = new SQLiteCommand(str, cnn); string site_id = null; using (SQLiteDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { site_id = reader[0].ToString(); } } cmd.CommandText = string.Format("SELECT * FROM logins WHERE site_id='{0}'", site_id); using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { login.cookies = reader["cookie"].ToString().TrimEnd(' '); login.username = reader["username"].ToString().TrimEnd(' '); login.password = reader["password"].ToString().TrimEnd(' '); } } } catch (Exception e) { Console.WriteLine(e); } cnn.Close(); return(login); }
public bool checkLogin(string siteString) { Website site = getSiteFromString(siteString); if (site != null) { loginCookies login = datahandler.getLogin(site.Name); return(site.checkLogin(login)); } return(false); }