public async Task CreateUserWhithAllParam(UserAccountAllParamDto param)
{
if (param == null)
{
return;
}
using (var connection = _connection())
{
var parameters = new DynamicParameters();
parameters.Add("@firstName", dbType: DbType.String, value: param.firstName);
parameters.Add("@lastname", dbType: DbType.String, value: param.lastName);
parameters.Add("@surName", dbType: DbType.String, value: param.surName);
parameters.Add("@email", dbType: DbType.String, value: param.email);
parameters.Add("@postalAddress", dbType: DbType.String, value: param.postalAddress);
parameters.Add("@postalCode", dbType: DbType.String, value: param.postalCode);
parameters.Add("@city", dbType: DbType.String, value: param.city);
parameters.Add("@country", dbType: DbType.String, value: param.country);
parameters.Add("@password", dbType: DbType.String, value: param.password);
parameters.Add("@urlPicture", dbType: DbType.String, value: param.urlPicture);
try
{
await connection.QueryAsync( //ExecuteAsync
Constant.StoredProcedure.UserAccount.CreateUserAccount,
parameters,
commandType : CommandType.StoredProcedure).ConfigureAwait(false);
}
catch (Exception e)
{
var test = e.Message;
}
}
}
public async Task UpdateUserAccount(UserAccountAllParamDto param)
{
if (param == null)
{
return;
}
using (var connection = _connection())
{
var parameters = new DynamicParameters();
parameters.Add("@idUser", dbType: DbType.Int64, value: param.idUser);
parameters.Add("@firstName", dbType: DbType.String, value: param.firstName);
parameters.Add("@lastname", dbType: DbType.String, value: param.lastName);
parameters.Add("@surName", dbType: DbType.String, value: param.surName);
parameters.Add("@email", dbType: DbType.String, value: param.email);
parameters.Add("@postalAddress", dbType: DbType.String, value: param.postalAddress);
parameters.Add("@postalCode", dbType: DbType.String, value: param.postalCode);
parameters.Add("@city", dbType: DbType.String, value: param.city);
parameters.Add("@country", dbType: DbType.String, value: param.country);
parameters.Add("@password", dbType: DbType.String, value: param.password);
parameters.Add("@urlPicture", dbType: DbType.String, value: param.urlPicture);
await connection.QueryAsync(
Constant.StoredProcedure.UserAccount.SetUserAccount,
parameters,
commandType : CommandType.StoredProcedure).ConfigureAwait(false);
}
}
internal static UserAccountAllParam ToUserAccountAllParam(this UserAccountAllParamDto param)
{
if (param == null)
{
return(null);
}
return(new UserAccountAllParam
{
IdUser = param.idUser,
FirstName = param.firstName,
SurName = param.surName,
LastName = param.lastName,
Password = param.password,
Email = param.email,
PostalAddress = param.postalAddress,
PostalCode = param.postalCode,
City = param.city,
Country = param.country,
UrlPicture = param.urlPicture,
IsAdmin = param.isAdmin
});
}
/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public async Task PostUserWhithAllParam(UserAccountAllParam param)
{
UserAccountAllParamDto dto = param.ToPostUserWhithAllParam();
await UserAccountRepository.CreateUserWhithAllParam(dto).ConfigureAwait(false);
}