public async Task <bool> UpdateUserInfo(UserInfoTableModel userinfo) { var sql = string.Format("update user_info set user_name=@userName,user_pwd=@userPwd,user_phone=@userPhone,user_gender=@userGender,user_flag=@userFlag,create_time=@createTime,update_time=@updateTime where user_id=@userId"); var row = await _dbContext.Update <UserInfoTableModel>(sql, userinfo); return(row > 0 ? true : false); }
public async Task <bool> AddUserInfo(UserInfoTableModel userinfo) { string query = "insert into user(user_id, user_name,user_pwd,user_phone,user_gender,user_flag,create_time,update_time) values(@user_id,@user_name,@user_pwd,@user_phone,@user_gender,@user_flag,@create_time,@update_time)"; int row = await _dbContext.Update <UserInfoTableModel>(query, userinfo); return(row > 0 ? true : false); }
public async Task <IActionResult> Profile() { var userId = User.FindFirstValue(ClaimTypes.NameIdentifier); if (string.IsNullOrEmpty(userId)) { return(Redirect("/Identity/Account/Login%2FMy%2FProfile")); } UserInfoTableModel userInfo = (await _usersInfoRepository.spGetUserInfo_ByUserId(userId)) ?? new UserInfoTableModel(); List <EventTableModel> lastFiveEvents = await _eventsRepository.GetLastFiveEvents_ByUserId(userId); List <spGetNotEmptyValueWallet_ByUserIdResult> notEmptyWallets = await _walletsRepository.GetNotEmptyWalletsByUserIdAsync(userId); var user = await _usersManager.FindByIdAsync(userId); var model = new ProfileViewModel() { Email = user.Email, Username = user.UserName, PhoneNumber = user.PhoneNumber, UserInfo = userInfo, LastFiveEvents = lastFiveEvents, NotEmptyWallets = notEmptyWallets, IsMyProfile = true }; return(View(model)); }
public async Task <ActionResult> Profile(string username) { var user = await _usersManager.FindByNameAsync(username); var userId = User.FindFirstValue(ClaimTypes.NameIdentifier); if (user != null) { UserInfoTableModel userInfo = (await _usersInfoRepository.spGetUserInfo_ByUserId(user.Id)) ?? new UserInfoTableModel(); List <EventTableModel> lastFiveEvents = await _eventsRepository.GetLastFiveEvents_ByUserId(user.Id); List <spGetNotEmptyValueWallet_ByUserIdResult> notEmptyWallets = await _walletsRepository.GetNotEmptyWalletsByUserIdAsync(user.Id); var model = new ProfileViewModel() { Email = user.Email, Username = user.UserName, PhoneNumber = user.PhoneNumber, UserInfo = userInfo, LastFiveEvents = lastFiveEvents, NotEmptyWallets = notEmptyWallets, IsMyProfile = userId == user.Id }; return(View("~/Views/Users/Profile.cshtml", model)); } return(View("~/Views/Users/UserNotExists.cshtml")); }
public async Task spCreateOrUpdateProfileUsersInfoPhoto(UserInfoTableModel model) { try { await _db.ExecuteAsync( "CreateOrUpdateProfileUsersInfoPhoto", new { userId = model.UserId, profilePhotoPath = model.ProfilePhotoPath }, commandType : CommandType.StoredProcedure); } catch (Exception ex) { } }
public async Task spCreateOrUpdateUsersInfoLocation(UserInfoTableModel model) { try { await _db.ExecuteAsync( "CreateOrUpdateUsersInfoLocation", new { userId = model.UserId, location = model.Location }, commandType : CommandType.StoredProcedure); } catch (Exception ex) { } }
public async Task spCreateOrUpdateProfileUserInfo(UserInfoTableModel model) { try { await _db.ExecuteAsync( "CreateOrUpdateProfileUserInfo", new { userId = model.UserId, fullName = model.FullName, aboutMe = model.AboutMe, facebookLink = model.FacebookLink, instagramLink = model.InstagramLink, skypeLink = model.SkypeLink, twitterLink = model.TwitterLink, linkedinLink = model.LinkedinLink, githubLink = model.GithubLink }, commandType : CommandType.StoredProcedure); } catch (Exception ex) { } }