/// <summary> /// Read and load pages data into the collection definition. /// </summary> /// <param name="cfg">The configuration profile to use.</param> /// <param name="errCode">Returns the error code of this operation.</param> /// <param name="errMsg">Returns the error string of this operation</param> /// <param name="expectedNumberOfPages">The expected nuumber of pages in the collection.</param> /// <param name="coll">The collection definition to add the data to.</param> /// <param name="colData">The data table containing the data for the collection.</param> /// <returns>An array oif file paths for files that were created in this method</returns> private static String[] ReadPagesData(CCConfiguration.CCConfigurationData cfg, out int errCode, out String errMsg, int expectedNumberOfPages, ref CCCollection coll, DataTable colData) { errCode = (int)CCEnums.CCErrorCodes.E0000; errMsg = null; List <String> result = new List <String>(); try { //-- Validate expected page count --\\ if (expectedNumberOfPages <= 0) { errCode = (int)CCEnums.CCErrorCodes.E0051; errMsg = String.Format("{0}, error code [{1}]", CCConstants.E0051, errCode); throw new Exception(errMsg); } int numberOfImagePages = CCUtils.GetImagePageCount(coll.ImagePath, null); //-- Validate page count --\\ if (numberOfImagePages <= 0) { errCode = (int)CCEnums.CCErrorCodes.E0061; errMsg = String.Format("{0}, file path [{1}], error code [{2}]", CCConstants.E0061, coll.ImagePath, errCode); throw new Exception(errMsg); } //-- Validate page count against expected page count --\\ if (numberOfImagePages != expectedNumberOfPages) { errCode = (int)CCEnums.CCErrorCodes.E0050; errMsg = String.Format("{4}. expected number of pages [{1}], actual image count [{2}], file path [{3}], error code [{0}]", errCode, expectedNumberOfPages, numberOfImagePages, coll.ImagePath, CCConstants.E0050); throw new Exception(errMsg); } List <CCCollection.CCForm> forms = new List <CCCollection.CCForm>(); for (int pageCount = 1; pageCount <= expectedNumberOfPages; pageCount++) { Dictionary <String, String> lstDct = new Dictionary <String, String>(); List <String> attachments = new List <String>(); DataRow[] pageRows = colData.Select(String.Format("{0}={1}", CCEnums.CCTableColumns.Level, IsStringData(colData.Columns[CCEnums.CCTableColumns.Level.ToString()]) ? "'" + pageCount.ToString() + "'" : pageCount.ToString())); if (pageRows == null || pageRows.Length <= 0) { pageRows = colData.Select(String.Format("{0}='{1}'", CCEnums.CCTableColumns.Level, pageCount)); } //-- Process pages data --\\ if (pageRows != null && pageRows.Length > 0) { List <int> pageNumbers = new List <int>(); String startDate = null; String endDate = null; //-- Iterate pages rows --\\ foreach (DataRow dr in pageRows) { //-- Get the page number the data is itntended to --\\ int pageNumber = CCUtils.StrToIntDef(dr[CCEnums.CCTableColumns.Level.ToString()].ToString(), -1); if (!pageNumbers.Contains(pageNumber)) { pageNumbers.Add(pageNumber); } //-- << Read pages data >>--\\ if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCPagesDataType.PageType.ToString(), true) == 0) { //-- PageType --\\ CCUtils.AddSetDictionaryItem(CCEnums.CCPagesDataType.PageType.ToString(), dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCPagesDataType.StartDate.ToString(), true) == 0) { //-- StartDate --\\ startDate = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); CCUtils.AddSetDictionaryItem(CCEnums.CCPagesDataType.StartDate.ToString(), startDate, excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCPagesDataType.EndDate.ToString(), true) == 0) { //-- EndDate --\\ endDate = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); CCUtils.AddSetDictionaryItem(CCEnums.CCPagesDataType.EndDate.ToString(), endDate, excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCPagesDataType.Attachments.ToString(), true) == 0) { //-- Attachments --\\ String val = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); if (!String.IsNullOrEmpty(val) && !File.Exists(val)) { errCode = (int)CCEnums.CCErrorCodes.E0065; errMsg = String.Format("{1}, file path[{2}], error code [{0}]", errCode, CCConstants.E0065, val ?? String.Empty); throw new Exception(errMsg); } else { if (!attachments.Contains(val)) { attachments.Add(val); } } } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCPagesDataType.XmlPrdPath.ToString(), true) == 0) { //-- XmlPrdPath --\\ int errC = 0; String errS = null; String sourceXmlPath = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); //-- Convert XML to PRD and add as page attachment --\\ String prdPath = DeserializePRD(out errC, out errS, pageNumber, false, sourceXmlPath); if (!String.IsNullOrEmpty(prdPath)) { if (File.Exists(sourceXmlPath)) { //-- Lock PRD file --\\ String lockPrd = CCFileList.GetLockedFilePath(prdPath, cfg.LockExtension); if (String.Compare(lockPrd, prdPath, true) != 0) { if (File.Exists(lockPrd)) { File.SetAttributes(lockPrd, FileAttributes.Normal); File.Delete(lockPrd); } File.SetAttributes(prdPath, FileAttributes.Normal); File.Move(prdPath, lockPrd); } File.Delete(sourceXmlPath); if (!attachments.Contains(lockPrd)) { attachments.Add(lockPrd); } if (!result.Contains(lockPrd)) { result.Add(lockPrd); } } } } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCPagesDataType.MetaData.ToString(), true) == 0) { //-- Additional MetaData--\\ String tagName = dr[CCEnums.CCTableColumns.Key.ToString()] is DBNull || String.IsNullOrEmpty(dr[CCEnums.CCTableColumns.Key.ToString()].ToString()) ? null : dr[CCEnums.CCTableColumns.Key.ToString()].ToString(); if (!String.IsNullOrEmpty(tagName)) { CCUtils.AddSetDictionaryItem(tagName, dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), excpetionOnDictDuplicates, ref lstDct); } } } //-- Validate page dates --\\ if (!ValidateDates(startDate, endDate, out errCode, out errMsg)) { //-- Validate start and end time\date --\\ errCode = (int)CCEnums.CCErrorCodes.E0020; errMsg = String.Format("{0}, {1} [{2}],{3} [{4}], page number [{5}], error code [{6}]", CCConstants.E0020, CCEnums.CCPagesDataType.StartDate, startDate, CCEnums.CCPagesDataType.EndDate, endDate, pageCount, errCode); throw new Exception(errMsg); } } //-- Create a form and page, NF 2011-11-07 added support for multipage per form --\\ CCCollection.CCForm frm = cfg.MultiPagePerForm ? forms.Count > 0 ? forms[0] : new CCCollection.CCForm(null, null, null) : new CCCollection.CCForm(null, null, null); if (!cfg.MultiPagePerForm || (cfg.MultiPagePerForm && forms.Count <= 0)) { frm.NamedUserTags.NativeDictionary = lstDct; //-- Add page Named user tags to Form user tags --\\ } CCCollection.CCPage pg = new CCCollection.CCPage(); pg.Attachments = attachments.ToArray(); pg.NamedUserTags.NativeDictionary = lstDct; if (!cfg.MultiPagePerForm || forms.Count <= 0) { frm.Pages = new CCCollection.CCPage[] { pg }; } else { List <CCCollection.CCPage> pgs = new List <CCCollection.CCPage>(frm.Pages); pgs.Add(pg); frm.Pages = pgs.ToArray(); } if (!cfg.MultiPagePerForm || forms.Count <= 0) { forms.Add(frm); } } //-- Do some validations --\\ if (expectedNumberOfPages != forms.Count) { if (!cfg.MultiPagePerForm || forms.Count <= 0) { errCode = (int)CCEnums.CCErrorCodes.E0090; errMsg = String.Format("Error code [{0}], {1},expected number of pages [{2}], eflow form count [{3}]", errCode, CCConstants.E0090, expectedNumberOfPages, forms.Count); throw new Exception(errMsg); } else { if (forms[0].Pages.Length != expectedNumberOfPages) { errCode = (int)CCEnums.CCErrorCodes.E0090; errMsg = String.Format("Error code [{0}], {1},expected number of pages [{2}] in one form, eflow form count [{3}]", errCode, CCConstants.E0090, expectedNumberOfPages, forms.Count); throw new Exception(errMsg); } } } errCode = (int)CCEnums.CCErrorCodes.E0001; coll.Forms = forms.ToArray(); } catch (Exception ex) { ILog.LogError(ex, false); if (String.IsNullOrEmpty(errMsg)) { errMsg = CCConstants.E0000 + "," + ex.Message; } throw (ex); } return(result.ToArray()); }
/// <summary> /// Read header data. /// </summary> /// <param name="cfg">The configuration profile to use.</param> /// <param name="errCode">The return error code, 1 is OK, anything else not.</param> /// <param name="errMsg">Will contain the error data if any error occures.</param> /// <param name="expectedNumberOfPages">Returns the expected number of pages.</param> /// <param name="dbCollectionData">The data table with rows to get Hedaer info.</param> /// <returns>A CCCollection when successfull, null when failed,</returns> public static CCCollection ReadHeaderData(CCConfiguration.CCConfigurationData cfg, out int errCode, out String errMsg, out int expectedNumberOfPages, DataTable dbCollectionData) { errCode = -1; errMsg = null; expectedNumberOfPages = 0; try { if (dbCollectionData == null || dbCollectionData.Rows.Count <= 0 || dbCollectionData.Columns.Count < 4) { errCode = (int)CCEnums.CCErrorCodes.E0041; errMsg = String.Format("{0}, error code [{1}]", CCConstants.E0041, errCode); throw new Exception(errMsg); } //-- Get header rows --\\ DataRow[] headerRows = dbCollectionData.Select(String.Format("{0}={1}", CCEnums.CCTableColumns.Level, IsStringData(dbCollectionData.Columns[CCEnums.CCTableColumns.Level.ToString()]) ? "'0'":"0")); if (headerRows == null || headerRows.Length <= 0) { headerRows = dbCollectionData.Select(String.Format("{0}='0'", CCEnums.CCTableColumns.Level)); } //-- Process header data --\\ if (headerRows != null && headerRows.Length > 0) { CCCollection res = new CCCollection(); Dictionary <String, String> lstDct = new Dictionary <String, String>(); List <String> attachments = new List <String>(); String startDate = null; String endDate = null; bool hasFlow = false; foreach (DataRow dr in headerRows) { //-- Extract columns data --\\ if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.Name.ToString(), true) == 0) { //-- Name --\\ res.Name = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.FlowType.ToString(), true) == 0) { //-- FlowType --\\ hasFlow = true; res.FlowType = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.AbsolutePriority.ToString(), true) == 0) { //-- AbsolutePriority --\\ double absPrio = 0d; if (double.TryParse(dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), out absPrio)) { res.AbsolutePriority = absPrio; } } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.StartDate.ToString(), true) == 0) { //-- StartDate --\\ startDate = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); CCUtils.AddSetDictionaryItem(CCEnums.CCHedaerDataType.StartDate.ToString(), startDate, excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.EndDate.ToString(), true) == 0) { //-- EndDate --\\ endDate = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); CCUtils.AddSetDictionaryItem(CCEnums.CCHedaerDataType.EndDate.ToString(), endDate, excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.DeviceID.ToString(), true) == 0) { //-- DeviceID --\\ CCUtils.AddSetDictionaryItem(CCEnums.CCHedaerDataType.DeviceID.ToString(), dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.UserID.ToString(), true) == 0) { //-- UserID --\\ CCUtils.AddSetDictionaryItem(CCEnums.CCHedaerDataType.UserID.ToString(), dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.MachineID.ToString(), true) == 0) { //-- MachineID --\\ CCUtils.AddSetDictionaryItem(CCEnums.CCHedaerDataType.MachineID.ToString(), dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.TotalPagesInBatch.ToString(), true) == 0) { //-- TotalPagesInBatch --\\ expectedNumberOfPages = CCUtils.StrToIntDef(dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), 0); CCUtils.AddSetDictionaryItem(CCEnums.CCHedaerDataType.TotalPagesInBatch.ToString(), expectedNumberOfPages.ToString(), excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.ImagePath.ToString(), true) == 0) { //-- ImagePath --\\ res.ImagePath = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.Attachments.ToString(), true) == 0) { //-- Attachments --\\ String val = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); if (!String.IsNullOrEmpty(val) && !File.Exists(val)) { errCode = (int)CCEnums.CCErrorCodes.E0065; errMsg = String.Format("{0}, file path [{1}], error code [{2}]", CCConstants.E0065, val ?? String.Empty, errCode); throw new Exception(errMsg); } else { if (!attachments.Contains(val)) { attachments.Add(val); } } } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.BatchType.ToString(), true) == 0) { //-- BatchType --\\ CCUtils.AddSetDictionaryItem(CCEnums.CCHedaerDataType.BatchType.ToString(), dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), excpetionOnDictDuplicates, ref lstDct); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.Priority.ToString(), true) == 0) { //-- Priority --\\ String pr = dr[CCEnums.CCTableColumns.Data.ToString()].ToString().ToUpper(); if (!String.IsNullOrEmpty(pr) && !Regex.IsMatch(pr, CCConstants.RX_PRIORITY)) { errCode = (int)CCEnums.CCErrorCodes.E0070; errMsg = String.Format("{0}, specified value [{1}], error code [{2}]", CCConstants.E0070, pr, errCode); throw new Exception(errMsg); } else { res.Priority = pr == WorkflowPriorityLevel.AboveNormal.ToString().Substring(0, 1) || pr.Replace(" ", String.Empty) == WorkflowPriorityLevel.AboveNormal.ToString().ToUpper() ? WorkflowPriorityLevel.AboveNormal : pr == WorkflowPriorityLevel.High.ToString().Substring(0, 1) || pr == WorkflowPriorityLevel.High.ToString().ToUpper() ? WorkflowPriorityLevel.High : pr == WorkflowPriorityLevel.Low.ToString().Substring(0, 1) || pr == WorkflowPriorityLevel.Low.ToString().ToUpper() ? WorkflowPriorityLevel.Low : WorkflowPriorityLevel.Normal; } } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.ApplicationName.ToString(), true) == 0) { //-- ApplicationName --\\ res.LoginApplication = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.StationName.ToString(), true) == 0) { //-- StationName --\\ res.LoginStation = dr[CCEnums.CCTableColumns.Data.ToString()].ToString(); } else if (String.Compare(dr[CCEnums.CCTableColumns.DataType.ToString()].ToString(), CCEnums.CCHedaerDataType.MetaData.ToString(), true) == 0) { //-- Additional MetaData --\\ String tagName = dr[CCEnums.CCTableColumns.Key.ToString()] is DBNull || String.IsNullOrEmpty(dr[CCEnums.CCTableColumns.Key.ToString()].ToString()) ? null : dr[CCEnums.CCTableColumns.Key.ToString()].ToString(); if (!String.IsNullOrEmpty(tagName)) { CCUtils.AddSetDictionaryItem(tagName, dr[CCEnums.CCTableColumns.Data.ToString()].ToString(), excpetionOnDictDuplicates, ref lstDct); } } } if (!hasFlow && !String.IsNullOrEmpty(cfg.FlowType)) { //-- Take flow type from configuration, if defined --\\ res.FlowType = cfg.FlowType; } #region //-- Do some validations --\\ if (expectedNumberOfPages <= 0) { //-- Validate expected number of pages value --\\ errCode = (int)CCEnums.CCErrorCodes.E0051; errMsg = String.Format("{0}, error code [{1}]", CCConstants.E0051, errCode); throw new Exception(errMsg); } else if (!File.Exists(res.ImagePath)) { //-- Validate image path --\\ errCode = (int)CCEnums.CCErrorCodes.E0060; errMsg = String.Format("{0}, file path [{1}], error code [{2}]", CCConstants.E0060, res.ImagePath ?? String.Empty, errCode); throw new Exception(errMsg); } else if (!String.IsNullOrEmpty(res.Name) && !Regex.IsMatch(res.Name, CCConstants.RX_COLLECTION_NAME)) { //-- Validate collection name --\\ errCode = (int)CCEnums.CCErrorCodes.E0010; errMsg = String.Format("{0}, error code [{1}]", CCConstants.E0010, errCode); throw new Exception(errMsg); } else if (!ValidateDates(startDate, endDate, out errCode, out errMsg)) { //-- Validate start and end time\date --\\ errCode = (int)CCEnums.CCErrorCodes.E0020; errMsg = String.Format("{0}, {1} [{2}],{3} [{4}], error code [{5}]", CCConstants.E0020, CCEnums.CCHedaerDataType.StartDate, startDate, CCEnums.CCHedaerDataType.EndDate, endDate, errCode); throw new Exception(errMsg); } #endregion //-- Finish setting data --\\ res.Attachments = attachments.ToArray(); res.NamedUserTags.NativeDictionary = lstDct; //-- Done gathering data from all header rows --\\ errCode = (int)CCEnums.CCErrorCodes.E0001; return(res); } else { errCode = 999; errMsg = String.Format("{0}, error code [{1}]", CCConstants.E0040, errCode); throw new Exception(errMsg); } } catch (Exception ex) { ILog.LogError(ex, false); throw (ex); } }