Product-related objects

// Creates a new public status object
PublicStatusInfo newStatus = new PublicStatusInfo();

// Sets the public status properties
newStatus.PublicStatusDisplayName = "New status";
newStatus.PublicStatusName = "NewStatus";
newStatus.PublicStatusEnabled = true;
newStatus.PublicStatusSiteID = SiteContext.CurrentSiteID;

// Saves the public status to the database
PublicStatusInfo.Provider.Set(newStatus);

// Gets the public status
PublicStatusInfo updateStatus = PublicStatusInfo.Provider.Get("NewStatus", SiteContext.CurrentSiteID);
if (updateStatus != null)
{
    // Updates the public status properties
    updateStatus.PublicStatusDisplayName = updateStatus.PublicStatusDisplayName.ToLowerCSafe();

    // Saves the changes to the database
    PublicStatusInfo.Provider.Set(updateStatus);
}

// Gets all public statuses on the current site whose name starts with 'New'
var statuses = PublicStatusInfo.Provider.Get()
                                       .OnSite(SiteContext.CurrentSiteID)
                                       .WhereStartsWith("PublicStatusName", "New");

// Loops through the public statuses
foreach (PublicStatusInfo modifyStatus in statuses)
{
    // Updates the public status properties
    modifyStatus.PublicStatusDisplayName = modifyStatus.PublicStatusDisplayName.ToUpperCSafe();

    // Saves the changes to the database
    PublicStatusInfo.Provider.Set(modifyStatus);
}

// Gets the public status
PublicStatusInfo deleteStatus = PublicStatusInfo.Provider.Get("NewStatus", SiteContext.CurrentSiteID);

if (deleteStatus != null)
{
    // Deletes the public status
    PublicStatusInfo.Provider.Delete(deleteStatus);
}

// Creates a new internal status object
InternalStatusInfo newStatus = new InternalStatusInfo();

// Sets the internal status properties
newStatus.InternalStatusDisplayName = "New internal status";
newStatus.InternalStatusName = "NewInternalStatus";
newStatus.InternalStatusEnabled = true;
newStatus.InternalStatusSiteID = SiteContext.CurrentSiteID;

// Saves the internal status to the database
InternalStatusInfo.Provider.Set(newStatus);

// Gets the internal status
InternalStatusInfo updateStatus = InternalStatusInfo.Provider.Get("NewInternalStatus", SiteContext.CurrentSiteID);
if (updateStatus != null)
{
    // Updates the internal status properties
    updateStatus.InternalStatusDisplayName = updateStatus.InternalStatusDisplayName.ToLowerCSafe();

    // Saves the changes to the database
    InternalStatusInfo.Provider.Set(updateStatus);
}

// Gets all internal statuses on the current site whose name starts with 'New'
var statuses = InternalStatusInfo.Provider.Get()
                                           .OnSite(SiteContext.CurrentSiteID)
                                           .WhereStartsWith("InternalStatusName", "New");

// Loops through the internal statuses
foreach (InternalStatusInfo modifyStatus in statuses)
{
    // Updates the internal status properties
    modifyStatus.InternalStatusDisplayName = modifyStatus.InternalStatusDisplayName.ToUpperCSafe();

    // Saves the changes to the database
    InternalStatusInfo.Provider.Set(modifyStatus);
}

// Gets the internal status
InternalStatusInfo deleteStatus = InternalStatusInfo.Provider.Get("NewInternalStatus", SiteContext.CurrentSiteID);

if (deleteStatus != null)
{
    // Deletes the internal status
    InternalStatusInfo.Provider.Delete(deleteStatus);
}

// Creates a new manufacturer object
ManufacturerInfo newManufacturer = new ManufacturerInfo();

// Sets the manufacturer properties
newManufacturer.ManufacturerDisplayName = "New manufacturer";
newManufacturer.ManufacturerName = "NewManufacturer";
newManufacturer.ManufacturerHomepage = "www.newmanufacturer.com";
newManufacturer.ManufacturerSiteID = SiteContext.CurrentSiteID;
newManufacturer.ManufacturerEnabled = true;

// Saves the manufacturer to the database
ManufacturerInfo.Provider.Set(newManufacturer);

// Gets the manufacturer
ManufacturerInfo updateManufacturer = ManufacturerInfo.Provider.Get("NewManufacturer", SiteContext.CurrentSiteID);
if (updateManufacturer != null)
{
    // Updates the manufacturer properties
    updateManufacturer.ManufacturerDisplayName = updateManufacturer.ManufacturerDisplayName.ToLowerCSafe();

    // Saves the changes to the database
    ManufacturerInfo.Provider.Set(updateManufacturer);
}

// Gets all manufacturers on the current site whose name starts with 'New'
var manufacturers = ManufacturerInfo.Provider.Get()
                                             .OnSite(SiteContext.CurrentSiteID)
                                             .WhereStartsWith("ManufacturerName", "New");

// Loops through the manufacturers
foreach (ManufacturerInfo modifyManufacturer in manufacturers)
{
    // Updates the manufacturer properties
    modifyManufacturer.ManufacturerDisplayName = modifyManufacturer.ManufacturerDisplayName.ToUpperCSafe();

    // Saves the changes to the database
    ManufacturerInfo.Provider.Set(modifyManufacturer);
}

// Gets the manufacturer
ManufacturerInfo deleteManufacturer = ManufacturerInfo.Provider.Get("NewManufacturer", SiteContext.CurrentSiteID);

if (deleteManufacturer != null)
{
    // Deletes the manufacturer
    ManufacturerInfo.Provider.Delete(deleteManufacturer);
}

// Creates a new supplier object
SupplierInfo newSupplier = new SupplierInfo();

// Sets the supplier properties
newSupplier.SupplierDisplayName = "New supplier";
newSupplier.SupplierName = "NewSupplier";
newSupplier.SupplierEmail = "newsupplier@supplier.com";
newSupplier.SupplierSiteID = SiteContext.CurrentSiteID;
newSupplier.SupplierPhone = "123456789";
newSupplier.SupplierFax = "987654321";
newSupplier.SupplierEnabled = true;

// Saves the supplier to the database
SupplierInfo.Provider.Set(newSupplier);

// Gets the supplier
SupplierInfo updateSupplier = SupplierInfoProvider.GetSupplierInfo("NewSupplier", SiteContext.CurrentSiteName);
if (updateSupplier != null)
{
    // Updates the supplier properties
    updateSupplier.SupplierDisplayName = updateSupplier.SupplierDisplayName.ToLowerCSafe();

    // Saves the changes to the database
    SupplierInfo.Provider.Set(updateSupplier);
}

// Gets all suppliers on the current site whose name starts with 'New'
var suppliers = SupplierInfo.Provider.Get()
                                    .OnSite(SiteContext.CurrentSiteID)
                                    .WhereStartsWith("SupplierName", "New");

// Loops through the suppliers
foreach (SupplierInfo modifySupplier in suppliers)
{
    // Updates the supplier properties
    modifySupplier.SupplierDisplayName = modifySupplier.SupplierDisplayName.ToUpperCSafe();

    // Saves the changes to the database
    SupplierInfo.Provider.Set(modifySupplier);
}

// Gets the supplier
SupplierInfo deleteSupplier = SupplierInfoProvider.GetSupplierInfo("NewSupplier", SiteContext.CurrentSiteName);

if (deleteSupplier != null)
{
    // Deletes the supplier
    SupplierInfo.Provider.Delete(deleteSupplier);
}