public static UserDB ConvertFromUser(User item) { UserDB toReturn = new UserDB (); toReturn.AccountActive = item.AccountActive; toReturn.AccountID = item.AccountID; toReturn.DateOfBirth = item.DateOfBirth; toReturn.EmailAddress = item.EmailAddress; toReturn.Errors = item.Errors; toReturn.FirstName = item.FirstName; toReturn.LastName = item.LastName; toReturn.Password = item.Password; toReturn.Picture = item.Picture; toReturn.PictureURL = item.PictureURL; toReturn.HasProfileImage = item.HasProfileImage; toReturn.AllowLocationSearch = item.AllowLocationSearch; toReturn.AllowSearch = item.AllowSearch; toReturn.DateCreated = item.DateCreated; toReturn.Description = item.Description; toReturn.Latitude = item.Latitude; toReturn.Longitude = item.Longitude; toReturn.ShowLocation = item.ShowLocation; toReturn.UserGender = item.UserGender; toReturn.UserName = item.UserName; return toReturn; }
/// <summary> /// Disconnect an user from the server /// </summary> /// <param name="user"></param> /// <returns></returns> public bool Disconnect(User user) { foreach (var token in _tokensByUser[user.Id]) { _tokens.Remove(token); } _authenticatedUsers.Remove(user); return _tokensByUser.Remove(user.Id); }
public void InsertOrUpdateUser(User user) { lock (this.dbLock) { using (SQLiteConnection sqlCon = new SQLiteConnection(this.DBPath)) { sqlCon.Execute(WZConstants.DBClauseSyncOff); sqlCon.BeginTransaction(); try { UserDB userDB = UserDB.ConvertFromUser(user); if (sqlCon.Execute("UPDATE UserDB SET " + "AccountActive=?, " + "AccountGuid=?, " + "DateOfBirth=?, " + "EmailAddress=?, " + "FirstName=?, " + "LastName=?, " + "Password=?, " + "Picture=?, " + "PictureUrl=?, " + "HasProfileImage=? " + "WHERE AccountGuid=?", userDB.AccountActive, userDB.AccountGuid, userDB.DateOfBirth, userDB.EmailAddress, userDB.FirstName, userDB.LastName, userDB.Password, userDB.Picture, userDB.PictureURL, userDB.HasProfileImage, userDB.AccountGuid) == 0) { sqlCon.Insert(userDB, typeof(UserDB)); }//end if sqlCon.Commit(); } catch (Exception ex) { #if(DEBUG) Console.WriteLine("Error in InsertOrUpdateContact! {0}--{1}", ex.Message, ex.StackTrace); #endif sqlCon.Rollback(); }//end try catch }//end using sqlCon }//end lock }
public void LoadUser() { this.Connection.CreateTable<User>(); var testUser = new User() { Id = 1, Username = "******", Guid = Guid.NewGuid().ToString(), Password = "******" }; this.Connection.Insert(testUser); }