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