示例#1
0
        public List <SOFTTEK.SCMS.Entity.Shared.Parameter <string> > GetMasterDataForCategory(string categoryName = null)
        {
            return(context.Execute(() => {
                DateTime lastUpdateSAPPMMasterData;
                List <SOFTTEK.SCMS.Entity.Shared.Parameter <string> > masterDataItems = new List <SCMS.Entity.Shared.Parameter <string> >();
                bool querySAP = true;

                lastUpdateSAPPMMasterData = GetSAPPMMasterDataExtractionDate();
                querySAP = DateTime.Now.Subtract(lastUpdateSAPPMMasterData) > new TimeSpan(1, 0, 0);

                // Query SAP is information expired(1 hour)
                if (querySAP)
                {
                    // Retrieve SAP PM Master Data
                    masterDataItems = RetrieveSapPMMasterData();
                    masterDataItems = string.IsNullOrEmpty(categoryName) ? masterDataItems : masterDataItems.Where(p => p.Description == categoryName).ToList();
                }
                else
                {
                    using (sraDataSource = new Data.SRADataContext(context.SecurityContext))
                    {
                        sraDataSource.ConnectionString = "SRA";
                        sraDataSource.DefaultUser = System.Configuration.ConfigurationManager.AppSettings["S_APP_UID"];
                        sraDataSource.Initialize();

                        masterDataItems = sraDataSource.GetParametersForCategory <string>("SAP_PM_MASTER_DATA");
                        masterDataItems = string.IsNullOrEmpty(categoryName) ? masterDataItems : masterDataItems.Where(p => p.Description == categoryName).ToList();
                    }
                }
                return masterDataItems;
            }, "Query to SAP for PM master data and registration/update of applicable items"));
        }
示例#2
0
        private DateTime GetSAPPMMasterDataExtractionDate()
        {
            DateTime lastUpdateSAPPMMasterData;

            // Get Last SAP Extraction Date
            using (sraDataSource = new Data.SRADataContext(context.SecurityContext))
            {
                sraDataSource.ConnectionString = "SRA";
                sraDataSource.DefaultUser      = System.Configuration.ConfigurationManager.AppSettings["S_APP_UID"];
                sraDataSource.Initialize();
                SOFTTEK.SCMS.Entity.Shared.Parameter <DateTime> pmSapExtractionParameter = sraDataSource.GetParametersForCategory <DateTime>("SYSTEM_DATES").
                                                                                           Where(p => p.Description == "SAP_PM_LAST_EXTRACTION").FirstOrDefault();
                lastUpdateSAPPMMasterData = pmSapExtractionParameter != null ? pmSapExtractionParameter.Value : default(DateTime);
            }
            return(lastUpdateSAPPMMasterData);
        }
示例#3
0
        private List <SCMS.Entity.Shared.Parameter <string> > RetrieveSapPMMasterData()
        {
            List <SOFTTEK.SCMS.Entity.Shared.Parameter <string> > masterDataItems;

            using (pmDataSource = new Data.PMDataContext(context.SecurityContext))
            {
                /**pmDataSource.ConnectionString = "SRA";
                 * pmDataSource.DefaultUser = System.Configuration.ConfigurationManager.AppSettings["S_APP_UID"];
                 * pmDataSource.Initialize();*/
                masterDataItems = pmDataSource.GetMasterData();
            }

            using (sraDataSource = new Data.SRADataContext(context.SecurityContext))
            {
                sraDataSource.ConnectionString = "SRA";
                sraDataSource.DefaultUser      = System.Configuration.ConfigurationManager.AppSettings["S_APP_UID"];
                sraDataSource.Initialize();
                List <SOFTTEK.SCMS.Entity.Shared.Parameter <string> > registeredMasterDataItems = sraDataSource.GetParametersForCategory <string>("SAP_PM_MASTER_DATA");

                // Match sap master data items with registered items by external identifier
                masterDataItems = masterDataItems.Select((mi) => {
                    SOFTTEK.SCMS.Entity.Shared.Parameter <string> ri = registeredMasterDataItems.Where(r1 => r1.ExternalIdentifier == mi.ExternalIdentifier).FirstOrDefault();

                    if (ri != null)
                    {
                        mi.Category   = ri.Category;
                        mi.Identifier = ri.Identifier;
                    }

                    return(mi);
                }).ToList();

                // Register/Update SAP records
                registeredMasterDataItems = masterDataItems.Select((mi) =>
                {
                    return(mi.Identifier > 0 && mi.Category != null ?
                           sraDataSource.UpdateParameterForCategory <string>(mi.Category.Name, mi) :
                           sraDataSource.RegisterParameterForCategory <string>(mi.Category != null && !string.IsNullOrEmpty(mi.Category.Name) ?
                                                                               mi.Category.Name :
                                                                               "SAP_PM_MASTER_DATA", mi));
                }).ToList();

                // Set current date as last extraction date
                SOFTTEK.SCMS.Entity.Shared.Parameter <DateTime> systemDate = sraDataSource.GetParametersForCategory <DateTime>("SYSTEM_DATES").Where(p => p.Description == "SAP_PM_LAST_EXTRACTION").FirstOrDefault();
                if (systemDate != null)
                {
                    systemDate.Value = DateTime.Now;
                }
                else
                {
                    systemDate = new SOFTTEK.SCMS.Entity.Shared.Parameter <DateTime>
                    {
                        Description = "SAP_PM_LAST_EXTRACTION",
                        Comments    = "Last date of PM Master Data Extraction from SAP",
                        IsActive    = true,
                        Value       = DateTime.Now
                    };
                }

                SOFTTEK.SCMS.Entity.Shared.Parameter <DateTime> pmSapExtractionParameter = systemDate != null && systemDate.Identifier > 0 ?
                                                                                           sraDataSource.UpdateParameterForCategory(systemDate.Category.Name, systemDate) :
                                                                                           sraDataSource.RegisterParameterForCategory("SYSTEM_DATES", systemDate);
            }
            return(masterDataItems);
        }