// Later move it seperate class
private void CreatePartnerRelatedTablesDefaultEntries(CRMPartner newlyCreatedPartner)
{
//===========Create Partner Center Description=================================
List <PartnerCenterDescription> partnerCenterDescriptions = new List <PartnerCenterDescription>(3);
partnerCenterDescriptions.Add(new PartnerCenterDescription()
{
Language = "UK", CRMPartnerId = newlyCreatedPartner.CRMPartnerId, CreatedDate = DateTime.UtcNow, LastModified = DateTime.UtcNow, ContentStatusId = 1
});
partnerCenterDescriptions.Add(new PartnerCenterDescription()
{
Language = "DK", CRMPartnerId = newlyCreatedPartner.CRMPartnerId, CreatedDate = DateTime.UtcNow, LastModified = DateTime.UtcNow, ContentStatusId = 1
});
partnerCenterDescriptions.Add(new PartnerCenterDescription()
{
Language = "Ger", CRMPartnerId = newlyCreatedPartner.CRMPartnerId, CreatedDate = DateTime.UtcNow, LastModified = DateTime.UtcNow, ContentStatusId = 1
});
foreach (var item in partnerCenterDescriptions)
{
_choiceRepoistory.Add <PartnerCenterDescription>(item);
}
//===========Create Partner Course Package=================================
foreach (var item in _choiceRepoistory.GetAll <CoursePackage>())
{
PartnerCoursePackage partnerCoursePackage = new PartnerCoursePackage();
partnerCoursePackage.CoursePackageId = item.CoursePackageId;
partnerCoursePackage.CRMPartnerId = newlyCreatedPartner.CRMPartnerId;
_choiceRepoistory.Add <PartnerCoursePackage>(partnerCoursePackage);
PartnerPackageIncludedItem partnerPackageIncludedItem = new PartnerPackageIncludedItem();
partnerPackageIncludedItem.PartnerCoursePackageId = partnerCoursePackage.PartnerCoursePackageId;
// partnerPackageIncludedItem.PackageIncludedItemId = _choiceRepoistory.GetById<PackageIncludedItem>(x => x.CoursePackageId == partnerCoursePackage.CoursePackageId).PackageIncludedItemId;
var res = _choiceRepoistory.GetById <PackageIncludedItem>(x => x.CoursePackageId == partnerCoursePackage.CoursePackageId);
partnerPackageIncludedItem.PackageIncludedItemId = res != null ? (int?)res.PackageIncludedItemId : null;
_choiceRepoistory.Add <PartnerPackageIncludedItem>(partnerPackageIncludedItem);
PartnerPackageAdditionalItem partnerPackageAdditionalItem = new PartnerPackageAdditionalItem();
partnerPackageAdditionalItem.PartnerCoursePackageId = partnerCoursePackage.PartnerCoursePackageId;
_choiceRepoistory.Add <PartnerPackageAdditionalItem>(partnerPackageAdditionalItem);
PartnerPackageYear partnerPackageYear = new PartnerPackageYear();
partnerPackageYear.PartnerCoursePackageId = partnerCoursePackage.PartnerCoursePackageId;
_choiceRepoistory.Add <PartnerPackageYear>(partnerPackageYear);
}
//===========Create PartnerCenterInfo=================================
PartnerCenterInfo partnerCenterInfo = new PartnerCenterInfo();
partnerCenterInfo.CRMPartnerId = newlyCreatedPartner.CRMPartnerId;
_choiceRepoistory.Add <PartnerCenterInfo>(partnerCenterInfo);
//===========Create PartnerCenterRoomInfo=================================
//PartnerCenterRoomInfo partnerCenterRoomInfo = new PartnerCenterRoomInfo();
//partnerCenterRoomInfo.CRMPartnerId = newlyCreatedPartner.CRMPartnerId;
//_choiceRepoistory.Add<PartnerCenterRoomInfo>(partnerCenterRoomInfo);
//===========Create PartnerInspirationCategoriesDK=================================
//PartnerInspirationCategoriesDK partnerInspirationCategoriesDK = new PartnerInspirationCategoriesDK();
//partnerInspirationCategoriesDK.CRMPartnerId = newlyCreatedPartner.CRMPartnerId;
//_choiceRepoistory.Add<PartnerInspirationCategoriesDK>(partnerInspirationCategoriesDK);
//===========Create PartnerInspirationCategoriesUK=================================
//PartnerInspirationCategoriesUK partnerInspirationCategoriesUK = new PartnerInspirationCategoriesUK();
//partnerInspirationCategoriesUK.CRMPartnerId = newlyCreatedPartner.CRMPartnerId;
//_choiceRepoistory.Add<PartnerInspirationCategoriesUK>(partnerInspirationCategoriesUK);
}
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}");
}
public void InsertData(ClientContext clientContext, DKBSDbContext dbContext)
{
try
{
Console.WriteLine(" Successfully Connected");
SP.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();
foreach (ListItem oItem in oListDataItem)
{
Console.WriteLine("ID: {0} \nTitle: {1}", oItem["ID"], oItem["Title"]);
Console.WriteLine(((SP.FieldUserValue)(oItem["Author"])).LookupValue);
Console.WriteLine(((SP.FieldUserValue)(oItem["Editor"])).LookupValue);
Console.WriteLine(oItem["Created"].ToString());
Console.WriteLine(oItem["Modified"].ToString());
Console.WriteLine(oItem["TotalNumberOfRooms"]);
Console.WriteLine(oItem["SingleRooms"]);
Console.WriteLine(oItem["DoubleRooms"]);
Console.WriteLine(oItem["Suite"]);
// Console.WriteLine(oItem["PrivateRoom"]);
Console.WriteLine(oItem["HandicapRooms"]);
Console.WriteLine(oItem["DistanceToAdditionalAccomodation"]);
// Console.WriteLine(oItem["Plenum"]);
Console.WriteLine(oItem["TeamRoom"]);
Console.WriteLine(oItem["DistanceToAirport"]);
Console.WriteLine(oItem["DistanceToTrainStation"]);
Console.WriteLine(oItem["DistanceToBusStop"]);
Console.WriteLine(oItem["DistanceToMotorway"]);
Console.WriteLine(oItem["NumberOfFreeParkingSpace"]);
Console.WriteLine(oItem["DistanceToTheFreeParking"]);
Console.WriteLine(oItem["NumberOfPaidParkingSpace"]);
// Console.WriteLine(oItem["DistanceToThePaidParking"]);
// Console.WriteLine(oItem["MaxDiners"]);
// Console.WriteLine(oItem["MaximumSeatsInAuditorium"]);
Console.WriteLine(oItem["GreenArea"]);
Console.WriteLine(oItem["AgreementForEmployees"]);
Console.WriteLine(oItem["HandicapFriendly"]);
Console.WriteLine(oItem["StateAgreement"]);
Console.WriteLine(oItem["Bar"]);
Console.WriteLine(oItem["Lounge"]);
Console.WriteLine(oItem["NumberOfPaidParkingSpace"]);
Console.WriteLine(oItem["Spa"]);
Console.WriteLine(oItem["Golf"]);
Console.WriteLine(oItem["Pool"]);
Console.WriteLine(oItem["AirCon"]);
Console.WriteLine(oItem["FitnessRoom"]);
Console.WriteLine(oItem["CookingSchool"]);
Console.WriteLine(oItem["Casino"]);
Console.WriteLine(oItem["Lounge"]);
Console.WriteLine(oItem["AreaRestaurant"]);
Console.WriteLine(oItem["EnvironmentalCertificate"]);
Console.WriteLine(oItem["MinimumAttendees"]);
Console.WriteLine(oItem["MaximumTableSeats"]);
Console.WriteLine(oItem["MaximumAccommodations"]);
Console.WriteLine(oItem["MaximumSeats"]);
Console.WriteLine(oItem["DinningArea"]);
Console.WriteLine(oItem["NumberOfRooms"]);
PartnerCenterInfo partnerCenterInfo = new PartnerCenterInfo();
if (oItem["AgreementForEmployees"] != null && oItem["AgreementForEmployees"].ToString() != "")
{
partnerCenterInfo.AgreementForEmployees = Convert.ToBoolean(oItem["AgreementForEmployees"]);
}
if (oItem["AirCon"] != null && oItem["AirCon"].ToString() != "")
{
partnerCenterInfo.AirCondition = Convert.ToBoolean(oItem["AirCon"]);
}
if (oItem["DistanceToAirport"] != null)
{
partnerCenterInfo.AirportDistance = Convert.ToInt32(oItem["DistanceToAirport"]);
}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.Auditoriums = oItem["Title"].ToString();
//}
if (oItem["Bar"] != null && oItem["Bar"].ToString() != "")
{
partnerCenterInfo.Bar = Convert.ToBoolean(oItem["Bar"]);
}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.BilliardsDartTableTennis = oItem["Title"].ToString();
//}
if (oItem["Casino"] != null && oItem["Casino"].ToString() != "")
{
partnerCenterInfo.Casino = Convert.ToBoolean(oItem["Casino"]);
}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.Chamber = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.ContentStatusId = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.ContentStatus = oItem["Title"].ToString();
//}
if (oItem["CookingSchool"] != null && oItem["CookingSchool"].ToString() != "")
{
partnerCenterInfo.CookingSchool = Convert.ToBoolean(oItem["CookingSchool"]);
}
if (oItem["Author"] != null)
{
partnerCenterInfo.CreatedBy = ((SP.FieldUserValue)(oItem["Author"])).LookupValue;
}
if (oItem["Created"] != null)
{
partnerCenterInfo.CreatedDate = Convert.ToDateTime(oItem["Created"]);
}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.CRMPartnerId = oItem["Title"].ToString();
//}
if (oItem["DinningArea"] != null)
{
partnerCenterInfo.DiningArea = Convert.ToInt32(oItem["DinningArea"]);
}
if (oItem["DistanceToAdditionalAccomodation"] != null)
{
partnerCenterInfo.DistanceToAddtiionalAccommodation = Convert.ToInt32(oItem["DistanceToAdditionalAccomodation"]);
}
if (oItem["DistanceToBusStop"] != null)
{
partnerCenterInfo.DistanceToBus = Convert.ToInt32(oItem["DistanceToBusStop"]);
}
if (oItem["DistanceToFreeParking"] != null)
{
partnerCenterInfo.DistanceToFreeParking = Convert.ToInt32(oItem["DistanceToFreeParking"]);
}
if (oItem["DistanceToMotorway"] != null)
{
partnerCenterInfo.DistanceToMotorway = Convert.ToInt32(oItem["DistanceToMotorway"]);
}
if (oItem["DistanceToThePaidParking"] != null)
{
partnerCenterInfo.DistanceToPayParking = Convert.ToInt32(oItem["DistanceToThePaidParking"]);
}
if (oItem["EnvironmentalCertificate"] != null && oItem["EnvironmentalCertificate"].ToString() != "")
{
partnerCenterInfo.EnvironmentalCertificate = Convert.ToBoolean(oItem["EnvironmentalCertificate"]);
}
if (oItem["FitnessRoom"] != null && oItem["FitnessRoom"].ToString() != "")
{
partnerCenterInfo.FitnessRoom = Convert.ToBoolean(oItem["FitnessRoom"]);
}
if (oItem["Golf"] != null && oItem["Golf"].ToString() != "")
{
partnerCenterInfo.Golf = Convert.ToBoolean(oItem["Golf"]);
}
if (oItem["GreenArea"] != null && oItem["GreenArea"].ToString() != "")
{
partnerCenterInfo.GreenArea = Convert.ToBoolean(oItem["GreenArea"]);
}
if (oItem["TeamRoom"] != null)
{
partnerCenterInfo.GroupRooms = Convert.ToInt32(oItem["TeamRoom"]);
}
if (oItem["HandicapFriendly"] != null && oItem["HandicapFriendly"].ToString() != "")
{
partnerCenterInfo.Handicapfriendly = Convert.ToBoolean(oItem["HandicapFriendly"]);
}
if (oItem["HandicapRooms"] != null)
{
partnerCenterInfo.HandicapRooms = Convert.ToInt32(oItem["HandicapRooms"]);
}
if (oItem["Modified"] != null)
{
partnerCenterInfo.LastModified = Convert.ToDateTime(oItem["Modified"]);
}
if (oItem["Editor"] != null)
{
partnerCenterInfo.LastModifiedBY = ((SP.FieldUserValue)(oItem["Editor"])).LookupValue;
}
if (oItem["Lounge"] != null && oItem["Lounge"].ToString() != "")
{
partnerCenterInfo.Lounge = Convert.ToBoolean(oItem["Lounge"]);
}
if (oItem["MaximumAccommodations"] != null)
{
partnerCenterInfo.MaxAccommodation = oItem["MaximumAccommodations"].ToString();
}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.MaxDiningPlacesInRestaurant = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.MaxDiningPlacesInRoom = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.MaximumNumberOfVisitors = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.MaxSpaceAtRowOfChairs = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.MaxspaceAtTables = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.MaxSpaceInAuditorium = oItem["Title"].ToString();
// }
if (oItem["MinimumAttendees"] != null)
{
partnerCenterInfo.MinParticipants = Convert.ToInt32(oItem["MinimumAttendees"]);
}
if (oItem["NumberOfRooms"] != null)
{
partnerCenterInfo.NoOfRooms = Convert.ToInt32(oItem["NumberOfRooms"]);
}
if (oItem["DoubleRooms"] != null)
{
partnerCenterInfo.NumberOfDoubleRooms = Convert.ToInt32(oItem["DoubleRooms"]);
}
if (oItem["NumberOfFreeParkingSpace"] != null)
{
partnerCenterInfo.NumberOfFreeParkingSpaces = Convert.ToInt32(oItem["NumberOfFreeParkingSpace"]);
}
if (oItem["NumberOfPaidParkingSpace"] != null)
{
partnerCenterInfo.NumberOfParkingSpaces = Convert.ToInt32(oItem["NumberOfPaidParkingSpace"]);
}
if (oItem["SingleRooms"] != null)
{
partnerCenterInfo.NumberOfSingleRooms = Convert.ToInt32(oItem["SingleRooms"]);
}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.PartnerCenfoInfoSPId = oItem["Title"].ToString();
//}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.PartnerCentInfoSpId = oItem["Title"].ToString();
//}
if (oItem["Pool"] != null && oItem["Pool"].ToString() != "")
{
partnerCenterInfo.Pool = Convert.ToBoolean(oItem["Pool"]);
}
//if (oItem["Title"] != null)
//{
// partnerCenterInfo.RegionsAgreement = oItem["Title"].ToString();
//}
if (oItem["Spa"] != null && oItem["Spa"].ToString() != "")
{
partnerCenterInfo.Spa = Convert.ToBoolean(oItem["Spa"]);
}
if (oItem["StateAgreement"] != null && oItem["StateAgreement"].ToString() != "")
{
partnerCenterInfo.StateAgreement = Convert.ToBoolean(oItem["StateAgreement"]);
}
if (oItem["DistanceToTrainStation"] != null)
{
partnerCenterInfo.StationDdistance = Convert.ToInt32(oItem["DistanceToTrainStation"]);
}
//if (oItem["Suite"] != null && oItem["Suite"].ToString() != "")
//{
// partnerCenterInfo.Suite = Convert.ToBoolean(oItem["Suite"]);
//}
if (oItem["TotalNumberOfRooms"] != null)
{
partnerCenterInfo.TotalRooms = Convert.ToInt32(oItem["TotalNumberOfRooms"]);
}
}
}
catch (Exception)
{
throw;
}
}
