public void AddCustomer(int organizationID, int productID, int versionID) { using (SqlCommand command = new SqlCommand()) { command.CommandText = @"INSERT INTO OrganizationProducts (OrganizationID, ProductID, ProductVersionID, IsVisibleOnPortal, DateCreated, DateModified, CreatorID, ModifierID) VALUES (@OrganizationID, @ProductID, @ProductVersionID, 1, @DateCreated, @DateModified, @CreatorID, @ModifierID)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@OrganizationID", organizationID); command.Parameters.AddWithValue("@ProductID", productID); command.Parameters.AddWithValue("@ProductVersionID", versionID); command.Parameters.AddWithValue("@DateCreated", DateTime.UtcNow); command.Parameters.AddWithValue("@DateModified", DateTime.UtcNow); command.Parameters.AddWithValue("@CreatorID", LoginUser.UserID); command.Parameters.AddWithValue("@ModifierID", LoginUser.UserID); ExecuteNonQuery(command, "OrganizationProducts"); } string organizationName = ((Organization)Organizations.GetOrganization(LoginUser, organizationID)).Name; string productName = ((Product)Products.GetProduct(LoginUser, productID)).Name; string versionNumber = ((ProductVersion)ProductVersions.GetProductVersion(LoginUser, (int)versionID)).VersionNumber; string description = "Added product '" + productName + "' version '" + versionNumber + "' to customer '" + organizationName + "'"; ActionLogs.AddActionLog(LoginUser, ActionLogType.Insert, ReferenceType.ProductVersions, (int)versionID, description); ActionLogs.AddActionLog(LoginUser, ActionLogType.Insert, ReferenceType.Products, productID, description); ActionLogs.AddActionLog(LoginUser, ActionLogType.Insert, ReferenceType.Organizations, organizationID, description); }
partial void BeforeRowDelete(int productVersionID) { ProductVersion version = (ProductVersion)ProductVersions.GetProductVersion(LoginUser, productVersionID); Product product = (Product)Products.GetProduct(LoginUser, version.ProductID); string description = "Deleted version '" + version.VersionNumber + "' for product '" + product.Name + "'"; ActionLogs.AddActionLog(LoginUser, ActionLogType.Delete, ReferenceType.ProductVersions, productVersionID, description); }