public async Task <List <FacebookCredential> > FacebookCredentials(int userId) { List <FacebookCredential> credentials = new List <FacebookCredential>(); string cmdStr = @"SELECT fb_credential_id, fb_username, fb_password FROM v_appuser_facebook WHERE appuser_id=@appuser_id order by fb_credential_id desc"; await using MySqlCommand cmd = await db.CreateCommand(cmdStr); cmd.Parameters.Add(new MySqlParameter("appuser_id", userId)); using MySqlDataReader odr = await cmd.ExecuteMySqlReaderAsync(); while (await odr.ReadAsync()) { var credential = new FacebookCredential { Id = await odr.ReadMySqlIntegerAsync("fb_credential_id"), Username = await odr.ReadMySqlStringAsync("fb_username"), Password = pwd.SimpleDecrypt(await odr.ReadMySqlStringAsync("fb_password")) }; if (credential.Id > 0 && !credentials.Any(c => c.Id == credential.Id && c.Username == credential.Username)) { credentials.Add(credential); } } return(credentials); }
public static void SaveCredentials(string username, string token) { using (var db = new AspNetDatingDataContext()) { var credentials = db.FacebookCredentials.FirstOrDefault(tc => tc.u_username == username); if (credentials == null) { credentials = new FacebookCredential { u_username = username }; db.FacebookCredentials.InsertOnSubmit(credentials); } credentials.fc_token = token; db.SubmitChanges(); } }
public FacebookCredentialViewModel(FacebookCredential credential) { Username = credential.Username; Password = credential.Password; }