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(); }