public void AddUser(User user)
{
string query = "INSERT INTO users(user_id, first_name, last_name, sex) values(@user_id, @first_name, @last_name, @sex);";
using (SQLiteConnection connection = new SQLiteConnection(m_ConnectionString))
{
connection.Open();
using (SQLiteCommand cmd = new SQLiteCommand(connection))
{
cmd.CommandText = query;
cmd.Parameters.Add("@user_id", DbType.Int32).Value = user.Id;
cmd.Parameters.Add("@first_name", DbType.String).Value = user.FirstName;
cmd.Parameters.Add("@last_name", DbType.String).Value = user.LastName;
cmd.Parameters.Add("@sex", DbType.String).Value = user.Sex.ToString();
int rowsUpdated = cmd.ExecuteNonQuery();
}
}
}
private void AddUser(User user)
{
try
{
OnProgress(string.Format("Processing name: {0} {1}. Found users: {2}", user.FirstName, user.LastName, m_UsersCount));
PhotosWrapper photosWrapper = new PhotosWrapper(m_SessionInfo);
List<string> profileUrls = photosWrapper.GetAllProfileUrls(user.Id);
foreach (string url in profileUrls)
{
byte[] avatarImage = Transport.DownloadFile(url);
if (avatarImage != null)
{
byte[] faceImage = FaceDetectionWrapper.GetFirstFace(avatarImage);
if (faceImage != null)
{
m_DbModel.AddUser(user);
m_DbModel.AddUserAvatar(user.Id, avatarImage);
m_DbModel.AddUserFace(user.Id, faceImage);
++m_UsersCount;
break;
}
}
}
}
catch (Exception ex)
{
s_log.Error(ex.Message, ex);
}
}
private List<User> ParseUsers(string response, bool ignoreOverflow = false)
{
JToken obj = JObject.Parse(response)["response"];
int total = (int)obj["count"];
if (total > 1000 && !ignoreOverflow)
{
throw new TooManyResultsException();
}
List<User> result = new List<User>();
JArray items = (JArray)obj["items"];
foreach (JToken item in items)
{
User user = new User();
user.Id = (int)item["id"];
user.FirstName = (string)item["first_name"];
user.LastName = (string)item["last_name"];
user.Sex = (UserSex)(int)item["sex"];
result.Add(user);
}
return result;
}
