internal async Task UpdateIsActive(UpdateIsActiveModel model, HttpRequestMessage Request)
{
var UserManager = Request.GetOwinContext().GetUserManager <ApplicationUserManager>();
ApplicationUser user = await UserManager.FindByIdAsync(model.id);
if (model.status == 1)
{
user.LockoutEndDateUtc = DateTime.Now.AddYears(200);
user.LockoutEnabled = true;
}
else
{
user.LockoutEndDateUtc = null;
user.LockoutEnabled = false;
}
IdentityResult result = await UserManager.UpdateAsync(user);
if (result.Errors == null)
{
ErrorModel _errors = new ErrorModel();
foreach (string error in result.Errors)
{
_errors.message += error;
}
throw new Exception(_errors.message);
}
}
internal async Task UpdateIsActive(SqlConnection connection1, UpdateIsActiveModel model)
{
String commandText1 = "update companies set status = @status " +
"where id = @id";
SqlCommand command1 = new SqlCommand(commandText1, connection1);
SqlParameter parameter = new SqlParameter("@id", SqlDbType.VarChar);
parameter.Value = model.id;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@status", SqlDbType.Int);
parameter.Value = model.status;
command1.Parameters.Add(parameter);
await command1.ExecuteNonQueryAsync();
}
