1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
|
class Class5
{
public void copyitem()
{
int count = 0;
string details = "";
string siteUrl = ConfigurationManager.AppSettings["365url"];
string login = ConfigurationManager.AppSettings["365Login"];
SecureString password = new SecureString();
foreach (char c in "monmmotdepasse".ToCharArray())
{
password.AppendChar(c);
}
try
{
ClientContext sourceContext = new ClientContext(siteUrl);
sourceContext.Credentials = new SharePointOnlineCredentials(login, password);
List liste1 = sourceContext.Web.Lists.GetByTitle("Nomliste1");
CamlQuery query = new CamlQuery();
query.ViewXml = "<View><Query></Query></View>";
ListItemCollection collistItem = liste1.GetItems(query);
sourceContext.Load(collistItem);
foreach (ListItem itemselected in collistItem)
{
// Console.WriteLine("{0}", itemselected["Title"]); // seul la colonne Title, Statut et Doublon peut être affiché. Ce sont des colonnes de base ou des colonnes de type OUI/NON
Console.WriteLine("a");
Console.WriteLine("{0}", itemselected["Nom Candidat"]);
string itemselectedNc = itemselected["Nom Candidat"].ToString(); // problème d'autorisation de mes colonnes
string itemselectedPc = itemselected["Prenom Candidat"].ToString();
string itemselectedmail = itemselected["E-mail"].ToString();
string itemselectedTypeP = itemselected["Type Profil"].ToString();
ClientContext destinationContext = new ClientContext(siteUrl);
destinationContext.Credentials = new SharePointOnlineCredentials(ConfigurationManager.AppSettings["365Login"], password);
List liste2 = destinationContext.Web.Lists.GetByTitle("Nomliste2");
ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation();
ListItem destinationitem = liste2.AddItem(itemCreateInfo);
destinationitem["Prenom Candidat"] = itemselectedPc;
destinationitem["E-mail"] = itemselectedmail;
destinationitem["Type Profil"] = itemselectedTypeP;
destinationitem.Update();
count++;
Console.WriteLine(count + "item(s) copied");
}
}
catch (Exception ex)
{
details += ex.ToString();
Console.WriteLine("{0}", ex);
}
}
} |
Partager