// ////////////////////////////////////////////////////////////////////////
 // PUBLIC METHODS
 //
 /// <summary>
 /// LoadAllByMaterialId
 /// </summary>
 /// <param name="materialId">materialId</param>              
 /// <param name="companyId">companyId</param>
 public void LoadAllByMaterialId(int materialId, int companyId)
 {
     MaterialsInformationNoteInformationGateway materialsInformationNoteInformationGateway = new MaterialsInformationNoteInformationGateway(Data);
     materialsInformationNoteInformationGateway.LoadAllByMaterialId(materialId, companyId);
 }
        /// ////////////////////////////////////////////////////////////////////////
        /// PRIVATE METHODS
        ///
        /// <summary>
        /// UpdateFieldsForSections
        /// </summary>
        private void UpdateFieldsForSections()
        {
            foreach (MaterialsByProcessReportTDS.MaterialsByProcessReportRow row in (MaterialsByProcessReportTDS.MaterialsByProcessReportDataTable)Table)
            {
                MaterialsInformationNoteInformationGateway materialsInformationNoteInformationGateway = new MaterialsInformationNoteInformationGateway();
                materialsInformationNoteInformationGateway.LoadAllByMaterialId(row.MaterialID, row.COMPANY_ID);

                MaterialsInformationNoteInformation materialsInformationNoteInformation = new MaterialsInformationNoteInformation(materialsInformationNoteInformationGateway.Data);
                string comments = materialsInformationNoteInformation.GetAllNotes(row.MaterialID, row.COMPANY_ID, materialsInformationNoteInformationGateway.Table.Rows.Count, "\n");

                if (comments.Length > 0)
                {
                    row.Notes = comments;
                }
                else
                {
                    row.SetNotesNull();
                }
            }
        }