public Parameter(SOFTTEK.SCMS.Entity.Shared.Parameter <T> parameter)
{
Identifier = parameter.Identifier;
ExternalIdentifier = parameter.ExternalIdentifier;
Value = parameter.Value;
Description = parameter.Description;
Category = parameter.Category;
Order = parameter.Order;
IsActive = parameter.IsActive;
Comments = parameter.Comments;
}
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);
}
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);
}
