partial void BeforeDBDelete(int productVersionStatusID) { ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(LoginUser); productVersionStatuses.LoadAllPositions(LoginUser.OrganizationID); int id = -1; foreach (ProductVersionStatus productVersionStatus in productVersionStatuses) { if (productVersionStatus.ProductVersionStatusID != productVersionStatusID) { id = productVersionStatus.ProductVersionStatusID; break; } } if (id < 0) { throw new Exception("You cannot delete the last product version."); } using (SqlCommand command = new SqlCommand()) { command.CommandText = "UPDATE ProductVersions SET ProductVersionStatusID = @NewID WHERE (ProductVersionStatusID = @ProductVersionStatusID)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@ProductVersionStatusID", productVersionStatusID); command.Parameters.AddWithValue("@NewID", id); ExecuteNonQuery(command, "ProductVersions"); } }
public void ValidatePositions(int organizationID) { ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(LoginUser); productVersionStatuses.LoadAllPositions(organizationID); int i = 0; foreach (ProductVersionStatus productVersionStatus in productVersionStatuses) { productVersionStatus.Position = i; i++; } productVersionStatuses.Save(); }