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