public SettingSeed SeedData()
{
var seedData = _staticFileReader.GetJSONSeedData(SeedType.SETTING, SeedVersion.V1);
//var settingSeedtmp = new SettingSeed();
//settingSeedtmp.SettingHeaders.Add(new SettingHead()
//{
// Name = "USER_LANGUAGE",
// Value = "EN",
// DefaultValue = "EN",
// Description = "User Language",
// SettingType = "USER",
// Status = "N"
//});
//settingSeedtmp.SettingHeaders.Add(new SettingHead()
//{
// Name = "SYSTEM_LANGUAGE",
// Value = "EN",
// DefaultValue = "EN",
// Description = "System Language",
// SettingType = "SYSTEM",
// Status = "N"
//});
//var options = new JsonSerializerOptions
//{
// PropertyNamingPolicy = JsonNamingPolicy.CamelCase,
// WriteIndented = true
//};
//var seedString = JsonSerializer.Serialize<SettingSeed>(settingSeedtmp, options);
var settingSeed = new SettingSeed();
if (!string.IsNullOrWhiteSpace(seedData))
{
var options = new JsonSerializerOptions
{
PropertyNamingPolicy = JsonNamingPolicy.CamelCase,
WriteIndented = true
};
settingSeed = JsonSerializer.Deserialize <SettingSeed>(seedData, options);
var test = string.Empty;
}
return(settingSeed);
}
protected override void Seed(Portal.CMS.Entities.PortalEntityModel context)
{
ThemeSeed.Seed(context);
RoleSeed.Seed(context);
SettingSeed.Seed(context);
PostCategorySeed.Seed(context);
PageSectionTypeSeed.Seed(context);
PageComponentTypeSeed.Seed(context);
MediaSeed.Seed(context);
CopySeed.Seed(context);
context.SaveChanges();
MenuSeed.Seed(context);
PageSeed.Seed(context);
PostSeed.Seed(context);
}
protected override void Seed(NomEntities context)
{
GetBidUpImdicator().ForEach(c => context.BidUpIndicators.Add(c));
GetCapacityTypeIndicator().ForEach(c => context.metadataCapacityTypeIndicator.Add(c));
GetCycle().ForEach(c => context.metadataCycle.Add(c));
GetExportDeclaration().ForEach(c => context.metadataExportDeclaration.Add(c));
// GetFileStatus().ForEach(c => context.metadataFileStatu.Add(c));
GetQuantityTypeIndicator().ForEach(c => context.metadataQuantityTypeIndicator.Add(c));
GetRequestType().ForEach(c => context.metadataRequestType.Add(c));
var contractList = ContractSeed.GetContract(); //.ForEach(c => context.Contract.Add(c));
EmailTemplateSeed.GetEmailSeed().ForEach(c => context.EmailTemplates.Add(c));
FileStatusSeed.GetFileStatus().ForEach(c => context.metadataFileStatu.Add(c));
MetadataDataSetSeed.GetDataSet().ForEach(c => context.metadataDataset.Add(c));
PipelineEncKeyInfoSeed.GetPipelineEncKeyInfo().ForEach(c => context.metadataPipelineEncKeyInfo.Add(c));
SettingSeed.GetSettingData().ForEach(c => context.Setting.Add(c));
metadataErrorCodeSeed.GetErrorCode().ForEach(c => context.metadataErrorCode.Add(c));
GetSendingStatus().ForEach(c => context.SendingStages.Add(c));
GetReceivingStages().ForEach(c => context.ReceivingStages.Add(c));
var locationList = LocationsSeed.GetLocations();
#region Identity Seed
// add roles
if (!context.Roles.Any(r => r.Name == "Admin"))
{
var store = new RoleStore <IdentityRole>(context);
var manager = new RoleManager <IdentityRole>(store);
var role = new IdentityRole {
Name = "Admin"
};
manager.Create(role);
}
//add users
if (!(context.ShipperCompany.Any(u => u.DUNS == "837565548")))
{
var shipperCompany = new ShipperCompany
{
Name = "Shell",
DUNS = "837565548",
IsActive = true,
CreatedBy = "",
CreatedDate = DateTime.Now,
ModifiedBy = "",
ModifiedDate = DateTime.Now,
SubscriptionID = 0,
ShipperAddress = ""
};
context.ShipperCompany.Add(shipperCompany);
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser
{
UserName = "******",
PhoneNumber = "0797697898",
EmailConfirmed = true,
Email = "*****@*****.**",
PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Monday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper
{
UserId = userToInsert.Id,
FirstName = "Tiffany P",
LastName = "On",
ShipperCompanyID = shipperCompany.ID,
IsActive = true,
CreatedBy = "",
CreatedDate = DateTime.Now,
ModifiedBy = "",
ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Tuesday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Rebecca J", LastName = "Newson", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Wednesday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Terry A", LastName = "Mcmillin", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Thursday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Amanda", LastName = "Boettcher", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Friday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Jason J", LastName = "Babin", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Saturday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Deepthi", LastName = "Bollu", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Sunday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Carly M", LastName = "Billington", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Jan02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Jayme C", LastName = "D'Agnolo", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Feb02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Brandon", LastName = "Johnson", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "March02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Tami L", LastName = "Covington", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "April02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Danielle", LastName = "Foster", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "May02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Christen", LastName = "Schaffer", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "June02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "John", LastName = "Powell", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "July02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Leslie", LastName = "May", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "August02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Justin", LastName = "Babb", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
}
if (!(context.ShipperCompany.Any(u => u.DUNS == "078711334")))
{
var shipperCompany = new ShipperCompany
{
Name = "Enercross",
DUNS = "078711334",
IsActive = true,
CreatedBy = "",
CreatedDate = DateTime.Now,
ModifiedBy = "",
ModifiedDate = DateTime.Now,
SubscriptionID = 0,
ShipperAddress = ""
};
context.ShipperCompany.Add(shipperCompany);
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0797697898", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Monday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Gagan", LastName = "Deep", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
if (!(context.Users.Any(u => u.UserName == "*****@*****.**")))
{
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser {
UserName = "******", PhoneNumber = "0000000000", EmailConfirmed = true, Email = "*****@*****.**", PhoneNumberConfirmed = true,
};
userManager.Create(userToInsert, "Monday02__");
userManager.AddToRole(userToInsert.Id, "Admin");
var shipper = new Shipper {
UserId = userToInsert.Id, FirstName = "Gagan", LastName = "Deep", ShipperCompanyID = shipperCompany.ID, IsActive = true, CreatedBy = "", CreatedDate = DateTime.Now, ModifiedBy = "", ModifiedDate = DateTime.Now
};
context.Shipper.Add(shipper);
}
}
#endregion
#region Add Pipeline
try
{
var pipelineList = PipelineSeed.GetPipelines();
var transactionTypeList = TransactionTypesSeed.GetTransactionTypes();
var tspList = TransportationServiceProviderSeed.GetTransportationServiceProvider();
var pipelineTranTypeMapList = PipelineTransactionTypeMapSeed.GetPipelineTransactionTypeMap();
var tpwList = TradingPartnerWorksheetSeed.GetTradingPartnerWorksheet();
var counterPartyList = CounterPartySeed.GetCounterParty();
var pipeEncKeyInfoList = PipelineEncKeyInfoSeed.GetPipelineEncKeyInfo();
foreach (var tranType in transactionTypeList)
{
var tt = new metadataTransactionType
{
Identifier = tranType.Identifier,
IsActive = tranType.IsActive,
Name = tranType.Name,
SequenceNo = tranType.SequenceNo
};
context.metadataTransactionType.Add(tt);
context.Commit();
var tranTypeMapOnPipeTTId = pipelineTranTypeMapList.Where(a => a.TransactionTypeID == tranType.ID).ToList();
foreach (var ttm in tranTypeMapOnPipeTTId)
{
var map = new Pipeline_TransactionType_Map
{
IsActive = ttm.IsActive,
LastModifiedBy = ttm.LastModifiedBy,
LastModifiedDate = ttm.LastModifiedDate,
PathType = ttm.PathType,
PipeDuns = "",//pipe.DUNSNo,
PipelineID = ttm.PipelineID,
TransactionTypeID = tt.ID,
CreatedBy = "",
CreatedDate = DateTime.Now
};
context.Pipeline_TransactionType_Map.Add(map);
context.Commit();
}
}
foreach (var tsp in tspList)
{
var tspObj = new TransportationServiceProvider
{
CreatedBy = tsp.CreatedBy,
CreatedDate = tsp.CreatedDate,
DUNSNo = tsp.DUNSNo,
IsActive = tsp.IsActive,
ModifiedBy = tsp.ModifiedBy,
ModifiedDate = tsp.ModifiedDate,
Name = tsp.Name
};
context.TransportationServiceProvider.Add(tspObj);
context.Commit();
var tspPipeList = pipelineList.Where(a => a.TSPId == tsp.ID).ToList();
foreach (var pipe in tspPipeList)
{
var pipeObj = new Pipeline
{
IsActive = pipe.IsActive,
ModelTypeID = pipe.ModelTypeID,
ModifiedBy = pipe.ModifiedBy,
ModifiedDate = pipe.ModifiedDate,
Name = pipe.Name,
ToUseTSPDUNS = pipe.ToUseTSPDUNS,
TSPId = tspObj.ID,
CreatedBy = "",
CreatedDate = DateTime.Now,
DUNSNo = pipe.DUNSNo
};
context.Pipeline.Add(pipeObj);
context.Commit();
var pipeTpwList = tpwList.Where(a => a.PipelineID == pipe.ID).ToList();
foreach (var tpw in pipeTpwList)
{
var tpwObj = new TradingPartnerWorksheet
{
IsActive = tpw.IsActive,
IsTest = tpw.IsTest,
KeyLive = tpw.KeyLive,
KeyTest = tpw.KeyTest,
ModifiedBy = tpw.ModifiedBy,
ModifiedDate = tpw.ModifiedDate,
Name = tpw.Name,
PasswordLive = tpw.PasswordLive,
PasswordTest = tpw.PasswordTest,
PipeDuns = pipeObj.DUNSNo,
PipelineID = pipeObj.ID,
ReceiveDataSeperator = tpw.ReceiveDataSeperator,
ReceiveSegmentSeperator = tpw.ReceiveSegmentSeperator,
ReceiveSubSeperator = tpw.ReceiveSubSeperator,
SendDataSeperator = tpw.SendDataSeperator,
SendSegmentSeperator = tpw.SendSegmentSeperator,
SendSubSeperator = tpw.SendSubSeperator,
URLLive = tpw.URLLive,
URLTest = tpw.URLTest,
UsernameLive = tpw.UsernameLive,
UsernameTest = tpw.UsernameTest,
CreatedBy = "",
CreatedDate = DateTime.Now
};
context.TradingPartnerWorksheet.Add(tpwObj);
}
var conPipeList = contractList.Where(a => a.PipelineID == pipe.ID).ToList();
foreach (var conPipe in conPipeList)
{
var con = new Contract
{
IsActive = conPipe.IsActive,
LocationFromID = conPipe.LocationFromID,
LocationToID = conPipe.LocationToID,
MDQ = conPipe.MDQ,
ModifiedBy = conPipe.ModifiedBy,
ModifiedDate = conPipe.ModifiedDate,
PipeDuns = pipeObj.DUNSNo,
PipelineID = pipeObj.ID,
ReceiptZone = conPipe.ReceiptZone,
RequestNo = conPipe.RequestNo,
RequestTypeID = conPipe.RequestTypeID,
ShipperID = 0,
ValidUpto = conPipe.ValidUpto,
CreatedBy = "",
DeliveryZone = conPipe.DeliveryZone,
FuelPercentage = conPipe.FuelPercentage,
CreatedDate = DateTime.Now
};
context.Contract.Add(con);
}
var locPipeList = locationList.Where(a => a.PipeDuns.Trim() == pipe.DUNSNo.Trim()).ToList();
foreach (var locPipe in locPipeList)
{
var loc = new Location
{
Identifier = locPipe.Identifier,
IsActive = locPipe.IsActive,
ModifiedBy = locPipe.ModifiedBy,
ModifiedDate = locPipe.ModifiedDate,
Name = locPipe.Name,
PipeDuns = pipeObj.DUNSNo,
PipelineID = pipeObj.ID,
PropCode = locPipe.PropCode,
RDUsageID = locPipe.RDUsageID,
CreatedBy = locPipe.CreatedBy,
CreatedDate = locPipe.CreatedDate
};
context.Location.Add(loc);
}
var ttmpList = context.Pipeline_TransactionType_Map.Where(a => a.PipelineID == pipe.ID).ToList();//pipelineTranTypeMapList.Where(a => a.PipelineID == pipe.ID).ToList();
foreach (var map in ttmpList)
{
map.PipelineID = pipeObj.ID;
map.PipeDuns = pipeObj.DUNSNo;
context.Pipeline_TransactionType_Map.Attach(map);
var entry = context.Entry(map);
entry.Property(e => e.PipelineID).IsModified = true;
entry.Property(e => e.PipeDuns).IsModified = true;
context.Commit();
}
var pipeEncKeyInfoPipeList = pipeEncKeyInfoList.Where(a => a.PipelineId == pipe.ID).ToList();
foreach (var peki in pipeEncKeyInfoPipeList)
{
peki.PipelineId = pipeObj.ID;
peki.PipeDuns = pipeObj.DUNSNo;
context.metadataPipelineEncKeyInfo.Add(peki);
}
}
}
foreach (var cp in counterPartyList)
{
context.CounterParty.Add(cp);
}
}
catch (Exception ex)
{
}
#endregion
context.Commit();
}
