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) { }
}
