/// <summary>
 /// Loads the manufacturer.
 /// </summary>
 private void LoadManufacturer()
 {
     ManufacturerCollection manufacturerCollection = new ManufacturerController().FetchAll();
       manufacturerCollection.OrderByAsc(Manufacturer.Columns.Name);
       ddlManufacturer.DataSource = manufacturerCollection;
       ddlManufacturer.DataTextField = Manufacturer.Columns.Name;
       ddlManufacturer.DataValueField = Manufacturer.Columns.ManufacturerId;
       ddlManufacturer.DataBind();
 }