public void InsertData()
{
try
{
List oListData = ClientContext.Web.Lists.GetByTitle("Centrets lokaler i tal");
CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query></Query><ViewFields><FieldRef Name='Title' /><FieldRef Name='Author' /><FieldRef Name='Editor' /><FieldRef Name='MaxPeopleAtTable' /><FieldRef Name='MaxPeopleAtUTable' /><FieldRef Name='MaxPeopleAtSchoolBoard' /><FieldRef Name='Created' /><FieldRef Name='Modified' /><FieldRef Name='MaxPeopleByIsland' /><FieldRef Name='MaxPeopleInOneRoom' /><FieldRef Name='DivideRoom' /><FieldRef Name='Remarks' /><FieldRef Name='SiteCIIDLookup' /></ViewFields></View>";
ListItemCollection oListDataItem = oListData.GetItems(camlQuery);
ClientContext.Load(oListDataItem);
ClientContext.ExecuteQuery();
var contentStatusId = Extension.GetApprovedConentStatusId(DKBSDbContext);
foreach (ListItem oItem in oListDataItem)
{
CRMPartner partner = DKBSDbContext.CRMPartner.FirstOrDefault(p => p.AccountId == oItem.GetLookupId("SiteCIIDLookup"));
if (partner == null)
{
ErrorCount += 1;
log.Error($"Partner not found SharepointId:{oItem.Id}");
continue;
}
try
{
log.Info($"Partner room info started. Partner Id: {partner.AccountId} SharepointId:{oItem.Id}");
PartnerCenterRoomInfo pRoom = new PartnerCenterRoomInfo()
{
RoomName = oItem["Title"].ToSharepointString(),
SharepointId = oItem.GetId(),
MaxPersonsAtMeetingTable = oItem["MaxPeopleAtTable"].ToInt(),
MaxPersonsAtRowOfChairs = oItem["MaxPeopleInOneRoom"].ToInt(),
MaxPersonsAtSchoolTable = oItem["MaxPeopleAtSchoolBoard"].ToInt(),
MaxPersonsAtUTable = oItem["MaxPeopleAtUTable"].ToInt(),
MaxPersonsAtIslands = oItem["MaxPeopleByIsland"].ToInt(),
IsRoomdividetosmallroom = oItem["DivideRoom"].ToBoolean(),
Remark = oItem["Remarks"].ToSharepointString(),
CreatedDate = oItem.GetCreateDate(),
LastModifiedBY = oItem.GetEditor(),
CreatedBy = oItem.GetAuthor(),
LastModified = oItem.GetModifiedDate(),
ContentStatusId = contentStatusId,
CRMPartnerId = partner.CRMPartnerId
};
DKBSDbContext.Add(pRoom);
DKBSDbContext.SaveChanges();
log.Info($"Partner room info completed. Partner Id: {partner.AccountId} SharepointId:{oItem.Id}");
}
catch (Exception ex)
{
ErrorCount += 1;
log.Error($"Partner room info unable to process. Partner Id: {partner.AccountId} SharepointId:{oItem.Id}", ex);
}
}
}
catch (Exception)
{
log.Error($"Unable to load Centrets lokaler i tal");
}
log.Info($"Total ErrorCount:{ErrorCount}");
}
public void InsertData()
{
try
{
List oList = ClientContext.Web.Lists.GetByTitle("Partnere");
CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query></Query></View>";
ListItemCollection collListItem = oList.GetItems(camlQuery);
ClientContext.Load(collListItem);
ClientContext.ExecuteQuery();
var contentStatusId = Extension.GetApprovedConentStatusId(DKBSDbContext);
foreach (ListItem oListItem in collListItem)
{
try
{
var hyperLink = ((FieldUrlValue)(oListItem["CISite"]));
if (hyperLink != null)
{
var hLink = ((FieldUrlValue)(oListItem["CISite"])).Url;
ClientContext Context = new ClientContext(hLink);
Context.AuthenticationMode = ClientAuthenticationMode.FormsAuthentication;
Context.FormsAuthenticationLoginInfo = new FormsAuthenticationLoginInfo("CRM Automation", "9LEkTny4");
Context.ExecuteQuery();
List oListData = Context.Web.Lists.GetByTitle("Aktiviteter");
camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query></Query></View>";
ListItemCollection oListDataItem = oListData.GetItems(camlQuery);
Context.Load(oListDataItem);
Context.ExecuteQuery();
CRMPartner partner = DKBSDbContext.CRMPartner.Where(p => p.AccountId == oListItem.Id.ToString()).Single();
foreach (ListItem oItem in oListDataItem)
{
try
{
log.Info($"PartnerInspirationCategoriesDK started. Partner Id: {partner.AccountId} SharepointId:{oItem.Id}");
PartnerInspirationCategoriesDK dk = new PartnerInspirationCategoriesDK();
dk.CRMPartnerId = partner.CRMPartnerId;
dk.ContentStatusId = contentStatusId;
dk.Heading = oItem["Headline"].ToSharepointString();
dk.Description = oItem["Description"].ToSharepointString();
dk.SharepointId = oItem.GetId();
dk.CreatedBy = oItem.GetAuthor();
dk.LastModifiedBY = oItem.GetEditor();
dk.CreatedDate = oItem.GetCreateDate();
dk.LastModified = oItem.GetModifiedDate();
dk.Price = oItem["Price"].ToDecimal();
dk.Sorting = oItem["Position"].ToInt();
DKBSDbContext.PartnerInspirationCategoriesDK.Add(dk);
DKBSDbContext.SaveChanges();
log.Info($"PartnerInspirationCategoriesDK completed. Partner Id: {partner.AccountId} SharepointId:{oItem.Id}");
}
catch (Exception ex)
{
ErrorCount += 1;
log.Error($"PartnerInspirationCategoriesDK unable to process. Partner Id: {partner.AccountId} SharepointId:{oItem.Id}", ex);
}
}
}
}
catch (Exception ex)
{
ErrorCount += 1;
log.Error($"PartnerInspirationCategoriesDK unable to process. Partner Id: {oListItem.GetId()}", ex);
}
}
}
catch (Exception)
{
ErrorCount += ErrorCount;
log.Error($"Unable to load Centrets lAktiviteter");
}
log.Info($"Total ErrorCount:{ErrorCount}");
}
public void InsertData()
{
try
{
List oList = ClientContext.Web.Lists.GetByTitle("Partnere");
CamlQuery camlQuery = new CamlQuery();
//<Where><Eq><FieldRef Name='ID' /><Value Type='Text'>49</Value></Eq>
camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query></Where></Query></View>";
ListItemCollection collListItem = oList.GetItems(camlQuery);
ClientContext.Load(collListItem);
ClientContext.ExecuteQuery();
//get content status Id.
var contentStatusId = Extension.GetApprovedConentStatusId(DKBSDbContext);
foreach (ListItem oListItem in collListItem)
{
var hyperLink = ((FieldUrlValue)(oListItem["CISite"]));
if (hyperLink != null)
{
try
{
var hLink = ((FieldUrlValue)(oListItem["CISite"])).Url;
ClientContext Context = new ClientContext(hLink);
Context.AuthenticationMode = ClientAuthenticationMode.FormsAuthentication;
Context.FormsAuthenticationLoginInfo = new FormsAuthenticationLoginInfo(Configuration["SharePointUserName"], Configuration["SharePointPassword"]);
Context.ExecuteQuery();
List oListData = Context.Web.Lists.GetByTitle("Kursuspakke");
camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query></Query></View>";
ListItemCollection oListDataItem = oListData.GetItems(camlQuery);
Context.Load(oListDataItem);
Context.ExecuteQuery();
foreach (ListItem oItem in oListDataItem)
{
log.Info($"Partner course package data process started Partner Id: {oItem.Id}");
try
{
log.Info($"Partner course package data process started Kursuspakke: {oItem.Id} Service Catalog Id { oItem["KursuspakkeID"].ToInt(true, 0)}");
CoursePackage coursePackage = DKBSDbContext.CoursePackage.Where(p => p.SharepointId == oItem["KursuspakkeID"].ToInt(true, 0)).Single();
CRMPartner partner = DKBSDbContext.CRMPartner.Where(p => p.AccountId == oListItem.Id.ToString()).Single();
PartnerCoursePackage partnerPackage = new PartnerCoursePackage();
partnerPackage.CRMPartnerId = partner.CRMPartnerId;
partnerPackage.SharepointId = oItem.Id;
partnerPackage.CoursePackageId = coursePackage.CoursePackageId;
partnerPackage.ContentStatusId = contentStatusId;
partnerPackage.Offered = oItem["Offered"].ToBoolean();
partnerPackage.Price = oItem["Price"].ToDecimal();
partnerPackage.CreatedDate = oItem.GetCreateDate();
partnerPackage.LastModified = oItem.GetModifiedDate();
partnerPackage.LastModifiedBy = oItem.GetEditor();
partnerPackage.CreatedBy = oItem.GetAuthor();
var includedPriceDetails = oItem["IncludedInPriceDefault"].ParseString();
var additionalIncluded = oItem["IncludedInPriceAdditional"].ParseString();
var optionalPurchages = oItem["OptionalPurchases"].ParseString();
var pricePerYear = oItem["PricePerYear"].ParseString();
// Included in price
foreach (var item in includedPriceDetails)
{
var packageItem = DKBSDbContext.PackageIncludedItem.First(p => p.CoursePackageId == coursePackage.CoursePackageId && p.DK == item[0]);
PartnerPackageIncludedItem ppi = new PartnerPackageIncludedItem()
{
PartnerCoursePackageId = partnerPackage.PartnerCoursePackageId,
CreatedDate = oItem.GetCreateDate(),
LastModified = oItem.GetModifiedDate(),
LastModifiedBy = oItem.GetEditor(),
CreatedBy = oItem.GetAuthor(),
PackageIncludedItemId = packageItem.PackageIncludedItemId,
Offered = item[2].IsChecked(),
};
partnerPackage.PartnerPackageIncludedItems.Add(ppi);
}
// additional included
foreach (var item in additionalIncluded)
{
PartnerPackageAdditionalItem ppai = new PartnerPackageAdditionalItem()
{
PartnerCoursePackageId = partnerPackage.PartnerCoursePackageId,
CreatedDate = oItem.GetCreateDate(),
LastModified = oItem.GetModifiedDate(),
LastModifiedBy = oItem.GetEditor(),
CreatedBy = oItem.GetAuthor(),
DK = item[0],
UK = item[1]
};
partnerPackage.PartnerPackageAdditionalItems.Add(ppai);
}
// optional purchages in price
foreach (var item in optionalPurchages)
{
PartnerPackageAdditionalItem ppai = new PartnerPackageAdditionalItem()
{
PartnerCoursePackageId = partnerPackage.PartnerCoursePackageId,
CreatedDate = oItem.GetCreateDate(),
LastModified = oItem.GetModifiedDate(),
LastModifiedBy = oItem.GetEditor(),
CreatedBy = oItem.GetAuthor(),
DK = item[0],
UK = item[1],
Price = item[2].ToDecimal(defaultData: true, defaultDataValue: 0).Value
};
partnerPackage.PartnerPackageAdditionalItems.Add(ppai);
}
// Price next year
foreach (var item in pricePerYear)
{
PartnerPackageYear pny = new PartnerPackageYear()
{
PartnerCoursePackageId = partnerPackage.PartnerCoursePackageId,
CreatedDate = oItem.GetCreateDate(),
LastModified = oItem.GetModifiedDate(),
LastModifiedBy = oItem.GetEditor(),
CreatedBy = oItem.GetAuthor(),
Year = item[0].ToInt(true, 0).Value,
PricePerPerson = item[1].ToDecimal(true, 0).Value,
};
partnerPackage.PartnerPackageYears.Add(pny);
}
DKBSDbContext.Add(partnerPackage);
DKBSDbContext.SaveChanges();
log.Info($"Partner course package data process completed Kursuspakke: {oItem.Id} Service Catalog Id { oItem["KursuspakkeID"].ToInt(true, 0)}");
}
catch (Exception ex)
{
ErrorCount += 1;
log.Error($"Error:Unable to insert Course package Kursuspakke Id: {oItem.Id} Service Catalog Id { oItem["KursuspakkeID"].ToInt(true, 0)}", ex);
}
}
log.Info($"Partner course package data process completed Partner Id: {oListItem.Id}");
}
catch (Exception ex)
{
ErrorCount += 1;
log.Error($"Error:Unable to pull Kursuspakke. PartnerId:{oListItem.Id}", ex);
}
}
}
}
catch (Exception ex)
{
log.Error($"Error:Unable to pull Partnere.", ex);
}
log.Info($"Total ErrorCount:{ErrorCount}");
}
public void InsertData()
{
try
{
List oListData = ClientContext.Web.Lists.GetByTitle("Centret_i_tal");
CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query></Query></View>";
ListItemCollection oListDataItem = oListData.GetItems(camlQuery);
ClientContext.Load(oListDataItem);
ClientContext.ExecuteQuery();
var contentStatusId = Extension.GetApprovedConentStatusId(DKBSDbContext);
foreach (ListItem oItem in oListDataItem)
{
try
{
PartnerCenterInfo cinfo = new PartnerCenterInfo();
var partnerName = oItem["Title"].ToSharepointString();
if (string.IsNullOrWhiteSpace(partnerName))
{
ErrorCount += 1;
log.Error($"Partner center info partner name is empty. for Id : {oItem.GetId()}");
continue;
}
var partners = DKBSDbContext.CRMPartner.Where(p => p.PartnerName.Trim().ToLower() == partnerName.Trim().ToLower());
if (partners == null || partners.Count() == 0)
{
ErrorCount += 1;
log.Error($"Partner center info partner not found for Id : {oItem.GetId()}");
continue;
}
if (partners.Count() > 1)
{
ErrorCount += 1;
log.Error($"Partner center info partner name repeated more than oncee. for Id : {oItem.GetId()} partner name:{partners.First().PartnerName}");
continue;
}
log.Info($"Partner center info process started.{partners.First().PartnerName} and Id : {oItem.GetId()}");
cinfo.CRMPartnerId = partners.First().CRMPartnerId;
cinfo.ContentStatusId = contentStatusId;
cinfo.AgreementForEmployees = oItem["AgreementForEmployees"].ToBoolean();
cinfo.AirCondition = oItem["AirCon"].ToBoolean();
cinfo.AirportDistance = oItem["DistanceToAirport"].ToFloat();
cinfo.Auditoriums = oItem["NumberOfAuditoriums"].ToInt();
cinfo.Bar = oItem["Bar"].ToBoolean();
cinfo.Casino = oItem["Casino"].ToBoolean();
cinfo.Chamber = oItem["Plenum"].ToInt();
cinfo.CookingSchool = oItem["CookingSchool"].ToBoolean();
cinfo.CreatedBy = oItem.GetAuthor();
cinfo.CreatedDate = oItem.GetCreateDate();
cinfo.DiningArea = oItem["DinningArea"].ToInt();
cinfo.DistanceToAddtiionalAccommodation = oItem["DistanceToAdditionalAccomodation"].ToFloat();
cinfo.DistanceToBus = oItem["DistanceToBusStop"].ToFloat();
cinfo.DistanceToFreeParking = oItem["DistanceToTheFreeParking"].ToFloat();
cinfo.DistanceToMotorway = oItem["DistanceToMotorway"].ToFloat();
cinfo.DistanceToPayParking = oItem["DistanceToThePaidParking"].ToFloat();
cinfo.EnvironmentalCertificate = oItem["EnvironmentalCertificate"].ToBoolean();
cinfo.FitnessRoom = oItem["FitnessRoom"].ToBoolean();
cinfo.Golf = oItem["Golf"].ToBoolean();
cinfo.GreenArea = oItem["GreenArea"].ToBoolean();
cinfo.GroupRooms = oItem["TeamRoom"].ToInt();
cinfo.Handicapfriendly = oItem["HandicapFriendly"].ToBoolean();
cinfo.HandicapRooms = oItem["HandicapRooms"].ToInt();
cinfo.LastModified = oItem.GetModifiedDate();
cinfo.LastModifiedBY = oItem.GetEditor();
cinfo.Lounge = oItem["Lounge"].ToBoolean();
cinfo.MaxAccommodation = oItem["MaximumAccommodations"].ToSharepointString();
cinfo.MaxDiningPlacesInRestaurant = oItem["AreaRestaurant"].ToInt();
cinfo.MaxDiningPlacesInRoom = oItem["PrivateRoom"].ToInt();
cinfo.MaximumNumberOfVisitors = oItem["MaxDiners"].ToInt();
cinfo.MaxSpaceAtRowOfChairs = oItem["MaximumTableSeats"].ToInt();
cinfo.MaxspaceAtTables = oItem["MaximumTableSeats"].ToInt();
cinfo.MaxSpaceInAuditorium = oItem["MaximumSeatsInAuditorium"].ToInt();
cinfo.MinParticipants = oItem["MinimumAttendees"].ToInt();
cinfo.NoOfRooms = oItem["NumberOfRooms"].ToInt();
cinfo.NumberOfDoubleRooms = oItem["DoubleRooms"].ToInt();
cinfo.NumberOfFreeParkingSpaces = oItem["NumberOfFreeParkingSpace"].ToInt();
cinfo.NumberOfParkingSpaces = oItem["NumberOfPaidParkingSpace"].ToInt();
cinfo.NumberOfSingleRooms = oItem["SingleRooms"].ToInt();
cinfo.Pool = oItem["Pool"].ToBoolean();
cinfo.RegionsAgreement = oItem["RegionAgreement"].ToBoolean();
cinfo.Spa = oItem["Spa"].ToBoolean();
cinfo.StateAgreement = oItem["StateAgreement"].ToBoolean();
cinfo.StationDdistance = oItem["DistanceToTrainStation"].ToFloat();
cinfo.Suite = oItem["Suite"].ToInt();
cinfo.TotalRooms = oItem["TotalNumberOfRooms"].ToInt();
cinfo.SharepointId = oItem.GetId();
DKBSDbContext.Add(cinfo);
DKBSDbContext.SaveChanges();
log.Info($"Partner center info process completed.{partners.First().PartnerName} and Id : {oItem.GetId()}");
}
catch (Exception ex)
{
ErrorCount += 1;
log.Error($"Partner center info Error. Id : {oItem.GetId()}", ex);
}
}
}
catch (Exception ex)
{
ErrorCount += 1;
log.Error($"Unble to pull Partner center info", ex);
}
log.Info($"Total ErrorCount:{ErrorCount}");
}
