/// <summary>
/// Delete user method
/// </summary>
/// <param name="user">User entity</param>
/// <returns>User deleted confirm</returns>
/// <author>Oscar Julian Rojas</author>
/// <date>10/07/2021</date>
public async Task<User> DeleteUser(User user)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.ID), user.Id);
return await GetAsyncFirst<User>(UserQuerys.DeleteUser, parameters, CommandType.Text);
}
/// <summary>
/// GetAll CardFailRepository Method repository
/// </summary>
/// <returns>All CardFailRepository entity</returns>
public async Task <IEnumerable <CardFail> > GetByIdAsync(Guid id)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add(HelpersEnums.GetEnumDescription(EnumCardFailParameters.ID), id);
return(await GetAsync <CardFail>(CardFailsQuerys.SelectCardFilsById, null, CommandType.Text));
}
/// <summary>
/// Method update password
/// </summary>
/// <returns>All users</returns>
/// <author>Oscar Julian Rojas</author>
/// <date>10/07/2021</date>
public async Task<User> UpdatePassword(User user)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.ID), user.Id);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.PASSWORD), user.Password);
return await GetAsyncFirst<User>(UserQuerys.SelectUser, parameters, CommandType.Text);
}
/// <summary>
/// Insert typeidentificacion method repository
/// </summary>
/// <param name="typeIdentificacion">Tipo de identificacion model</param>
/// <returns>Type Identificacion create</returns>
public async Task <TypeIdentification> CreateTypeIdentification(TypeIdentification typeIdentificacion)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add(HelpersEnums.GetEnumDescription(EnumTypeIdentificationParameters.ID), Guid.NewGuid());
parameters.Add(HelpersEnums.GetEnumDescription(EnumTypeIdentificationParameters.Description), typeIdentificacion.Description);
parameters.Add(HelpersEnums.GetEnumDescription(EnumTypeIdentificationParameters.CREATED_BY), typeIdentificacion.CreatedBy);
parameters.Add(HelpersEnums.GetEnumDescription(EnumTypeIdentificationParameters.CREATED_ON), typeIdentificacion.CreatedOn);
parameters.Add(HelpersEnums.GetEnumDescription(EnumTypeIdentificationParameters.STATE), typeIdentificacion.State);
return(await GetAsyncFirst <TypeIdentification>(QueryTypeIdentification.InsertTypeIdentification, parameters, CommandType.Text));
}
/// <summary>
/// Insert CardFailRepository method repository
/// </summary>
/// <param name="typeIdentificacion">Tipo de CardFailRepository model</param>
/// <returns>Type CardFailRepository create</returns>
public async Task <TypeIdentification> CreateCardFailRegistryAsync(CardFail card)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add(HelpersEnums.GetEnumDescription(EnumCardFailParameters.ID), Guid.NewGuid());
parameters.Add(HelpersEnums.GetEnumDescription(EnumCardFailParameters.Quantities), card.Quantities);
parameters.Add(HelpersEnums.GetEnumDescription(EnumCardFailParameters.CREATED_BY), card.CreatedBy);
parameters.Add(HelpersEnums.GetEnumDescription(EnumCardFailParameters.CREATED_ON), card.CreatedOn);
parameters.Add(HelpersEnums.GetEnumDescription(EnumCardFailParameters.STATE), card.State);
return(await GetAsyncFirst <TypeIdentification>(QueryTypeIdentification.InsertTypeIdentification, parameters, CommandType.Text));
}
/// <summary>
/// Create User Method repository
/// </summary>
/// <param name="user">User Entity</param>
/// <returns>User entity create</returns>
public async Task<User> CreateUser(User user)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.ID), Guid.NewGuid());
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.NAME), user.Name);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.MIDDLE_NAME), user.MiddleName);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.LAST_NAME), user.LastName);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.SUR_NAME), user.SurName);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.EMAIL), user.Email);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.PASSWORD), user.Password);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.CREATED_BY), user.CreatedBy);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.CREATED_ON), user.CreatedOn);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.IDENTIFICATION_TYPE), user.TypeIdentificationId);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.IDENTIFICATION), user.Identification);
parameters.Add(HelpersEnums.GetEnumDescription(EnumUserParameters.STATE), user.State);
return await GetAsyncFirst<User>(UserQuerys.CreateUser, parameters, CommandType.Text);
}