public async Task <bool> UpdateUserDetailsAsync(YourApplicationUser user)
{
if (user == null)
{
throw new ArgumentNullException("user");
}
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var result = connection.ExecuteAsync(@"
update UserDetail set
FirstName = @firstName, MiddleName = @middleName, LastName = @lastName
,Gender = @gender, BloodGroup = @bloodGroup
,DOB = @dob
,ContactNumber = @contactNumber, AlternateContactNumber =@altContactNumber
where UserId = @Id",
new {
firstName = user.FirstName, middleName = user.MiddleName,
lastName = user.LastName, gender = user.Gender,
bloodGroup = user.BloodGroup,
dob = user.DOB,
contactNumber = user.PhoneNumber,
altContactNumber = user.AlternateContactNumber,
Id = user.Id
});
return(await result > 0);
}
}
public async Task <bool> AddUserAsync(YourApplicationUser user)
{
using (var conn = new SqlConnection(_connectionString))
{
var result = await conn.ExecuteAsync(
"CreateNewUser"
, new
{
userName = user.UserName,
email = user.Email,
passwordHash = user.PasswordHash,
securityStamp = user.SecurityStamp,
roleId = user.RoleId,
FName = user.FirstName,
MName = user.MiddleName,
LName = user.LastName,
HNbr = user.HospitalNumber,
Gender = user.Gender,
Age = user.Age,
Dob = user.DOB,
Address = user.Address,
BGroup = user.BloodGroup,
Contact = user.PhoneNumber,
AltContact = user.AlternateContactNumber,
}
, commandType : CommandType.StoredProcedure);
return(result > 0);
}
}
public async Task <bool> UpdateUserAsync(YourApplicationUser user)
{
if (user == null)
{
throw new ArgumentNullException("user");
}
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var result = connection.ExecuteAsync(@"
update ApplicationUser set
UserName = @userName, PasswordHash = @passwordHash, SecurityStamp = @securityStamp
where Id = @Id", new { userName = user.UserName, passwordHash = user.PasswordHash, securityStamp = user.SecurityStamp, Id = user.Id });
return(await result > 0);
}
}
