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; } }