public ActionResult <IEnumerable <PartnerInspirationCategoriesDKDTO> > PartnerInspirationCategoriesDK([FromBody] PartnerInspirationCategoriesDKDTO partnerInspirationCategoriesDKDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
if (partnerInspirationCategoriesDKDTO == null)
{
return(BadRequest());
}
var checkPartnerInspirationCategoriesDKId = _choiceRepoistory.GetPartnerInspirationCategoriesDK().Find(c => c.PartnerInspirationCategoriesDKId == partnerInspirationCategoriesDKDTO.PartnerInspirationCategoriesDKId);
if (checkPartnerInspirationCategoriesDKId != null)
{
return(BadRequest());
}
PartnerInspirationCategoriesDK newlypartnerInspirationCategoriesDKDTO = new PartnerInspirationCategoriesDK()
{
PartnerInspirationCategoriesDKId = partnerInspirationCategoriesDKDTO.PartnerInspirationCategoriesDKId,
CRMPartnerId = partnerInspirationCategoriesDKDTO.CRMPartnerId,
Heading = partnerInspirationCategoriesDKDTO.Heading,
Description = partnerInspirationCategoriesDKDTO.Description,
Price = partnerInspirationCategoriesDKDTO.Price,
Sorting = partnerInspirationCategoriesDKDTO.Sorting,
ContentStatusId = partnerInspirationCategoriesDKDTO.ContentStatusId,
CreatedDate = partnerInspirationCategoriesDKDTO.CreatedDate,
CreatedBy = partnerInspirationCategoriesDKDTO.CreatedBy,
LastModified = partnerInspirationCategoriesDKDTO.LastModified,
LastModifiedBY = partnerInspirationCategoriesDKDTO.LastModifiedBY
};
_choiceRepoistory.SetpartnerInspirationCategoriesDK(newlypartnerInspirationCategoriesDKDTO);
_choiceRepoistory.Complete();
return(CreatedAtRoute("getbypartnerinspirationcategoriesDK", new { newlypartnerInspirationCategoriesDKDTO.PartnerInspirationCategoriesDKId }, newlypartnerInspirationCategoriesDKDTO));
}
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 SetpartnerInspirationCategoriesDK(PartnerInspirationCategoriesDK partnerInspirationCategoriesDK)
{
_dbContext.PartnerInspirationCategoriesDK.Add(partnerInspirationCategoriesDK);
}
public void InsertData(ClientContext clientContext, DKBSDbContext dbContext)
{
try
{
Console.WriteLine(" Successfully Connected");
SP.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();
foreach (ListItem oListItem in collListItem)
{
var hyperLink = ((SP.FieldUrlValue)(oListItem["CISite"]));
if (hyperLink != null)
{
Console.WriteLine("ID: {0} \nTitle: {1} \nSite: {2} \nSiteUrl: {3} ", oListItem.Id, oListItem["Title"], oListItem["CISite"], oListItem["CISiteShortUrl"]);
var hLink = ((SP.FieldUrlValue)(oListItem["CISite"])).Url;
Console.WriteLine(hLink);
ClientContext Context = new ClientContext(hLink);
Context.AuthenticationMode = ClientAuthenticationMode.FormsAuthentication;
Context.FormsAuthenticationLoginInfo = new FormsAuthenticationLoginInfo("CRM Automation", "9LEkTny4");
Context.ExecuteQuery();
SP.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();
foreach (ListItem oItem in oListDataItem)
{
Console.WriteLine("ID: {0} \nHeadline: {1}", oItem["ID"], oItem["Headline"]);
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["Title"]);
Console.WriteLine(oItem["Description"]);
Console.WriteLine(oItem["Picture"]);
Console.WriteLine(oItem["Price"]);
PartnerInspirationCategoriesDK partnerInspirationCategoriesDK = new PartnerInspirationCategoriesDK();
// partnerInspirationCategoriesDK.ContentStatusId = 2;//Approved
// partnerInspirationCategoriesDK.CRMPartnerId = oListItem.Id;
partnerInspirationCategoriesDK.ContentStatusId = 1; //Approved
partnerInspirationCategoriesDK.CRMPartnerId = 1;
if (oItem["Headline"] != null)
{
partnerInspirationCategoriesDK.Heading = oItem["Headline"].ToString();
}
// partnerInspirationCategoriesDK.CRMPartnerId = 1;
if (oItem["Description"] != null)
{
partnerInspirationCategoriesDK.Description = oItem["Description"].ToString();
}
if (oItem["ID"] != null)
{
partnerInspirationCategoriesDK.SharepointId = oItem.Id;
}
if (((SP.FieldUserValue)(oItem["Author"])).LookupValue != null)
{
partnerInspirationCategoriesDK.CreatedBy = ((SP.FieldUserValue)(oItem["Author"])).LookupValue;
}
if (((SP.FieldUserValue)(oItem["Editor"])).LookupValue != null)
{
partnerInspirationCategoriesDK.LastModifiedBY = ((SP.FieldUserValue)(oItem["Editor"])).LookupValue;
}
if (oItem["Created"] != null)
{
partnerInspirationCategoriesDK.CreatedDate = Convert.ToDateTime(oItem["Created"].ToString());
}
if (oItem["Modified"] != null)
{
partnerInspirationCategoriesDK.LastModified = Convert.ToDateTime(oItem["Modified"].ToString());
}
if (oItem["Price"] != null)
{
partnerInspirationCategoriesDK.Price = Convert.ToDecimal(oItem["Price"].ToString());
}
dbContext.Add(partnerInspirationCategoriesDK);
dbContext.SaveChanges();
}
}
}
}
catch (Exception)
{
throw;
}
}
