Departments

// Creates a new department object
DepartmentInfo newDepartment = new DepartmentInfo();

// Sets the department properties
newDepartment.DepartmentDisplayName = "New department";
newDepartment.DepartmentName = "NewDepartment";
newDepartment.DepartmentSiteID = SiteContext.CurrentSiteID;

// Saves the department to the database
DepartmentInfo.Provider.Set(newDepartment);

// Gets the department
DepartmentInfo updateDepartment = DepartmentInfo.Provider.Get("NewDepartment", SiteContext.CurrentSiteID);
if (updateDepartment != null)
{
    // Updates the department properties
    updateDepartment.DepartmentDisplayName = updateDepartment.DepartmentDisplayName.ToLower();

    // Saves the changes to the database
    DepartmentInfo.Provider.Set(updateDepartment);
}

// Gets all departments whose code name starts with 'NewDepartment'
var departments = DepartmentInfo.Provider.Get().WhereStartsWith("DepartmentName", "NewDepartment");

// Loops through the departments
foreach (DepartmentInfo modifyDepartment in departments)
{
    // Updates the department properties
    modifyDepartment.DepartmentDisplayName = modifyDepartment.DepartmentDisplayName.ToUpper();

    // Saves the changes to the database
    DepartmentInfo.Provider.Set(modifyDepartment);
}

// Gets the department
DepartmentInfo deleteDepartment = DepartmentInfo.Provider.Get("NewDepartment", SiteContext.CurrentSiteID);

if (deleteDepartment != null)
{
    // Deletes the department
    DepartmentInfo.Provider.Delete(deleteDepartment);
}

// Gets the department
DepartmentInfo department = DepartmentInfo.Provider.Get("NewDepartment", SiteContext.CurrentSiteID);

// Gets the tax class
TaxClassInfo taxClass = TaxClassInfo.Provider.Get("NewClass", SiteContext.CurrentSiteID);

if ((department != null) && (taxClass != null))
{
    // Adds the tax class to the department
    department.DepartmentDefaultTaxClassID = taxClass.TaxClassID;

    // Saves the changes to the database
    DepartmentInfo.Provider.Set(department);
}

// Gets the department
DepartmentInfo department = DepartmentInfo.Provider.Get("NewDepartment", SiteContext.CurrentSiteID);

if (department != null)
{
    // Removes the tax class to the department
    department.DepartmentDefaultTaxClassID = 0;

    // Saves the changes to the database
    DepartmentInfo.Provider.Set(department);
}