private bool ContainsObject(Object obj, System.Collections.ICollection list)
{
System.Collections.IEnumerator e = list.GetEnumerator();
while (e.MoveNext())
{
Object o = e.Current;
if (o is System.IO.FileInfo)
{
System.IO.FileInfo f1 = (System.IO.FileInfo)o;
if (obj is System.IO.FileInfo)
{
System.IO.FileInfo f2 = (System.IO.FileInfo)obj;
if (f1.FullName == f2.FullName &&
f1.GetType() == f2.GetType())
{
return(true);
}
}
}
else if (o.Equals(obj))
{
return(true);
}
}
return(false);
}
private static void UpdateSPList(ClientContext clientContext, DataTable dataTable, string fileName)
{
bool isError = true;
string strErrorMsg = string.Empty;
Int32 count = 0;
const string lstName = "Files";
const string lstColCreatedBy = "create";
const string lstColType = "typeof";
const string lstColSize = "Size";
try
{
SP.List oList = clientContext.Web.Lists.GetByTitle(lstName);
foreach (DataRow row in dataTable.Rows)
{
if (count++ == 0)
{
continue;
}
string filee = row[0].ToString();
string filename = filee.Split('\\').Last();
System.IO.FileInfo filesize = new System.IO.FileInfo(row[0].ToString());
long size = filesize.Length;
string exten = filesize.Extension;
Type type = filesize.GetType();
if ((size / 1048576.0) > 0 && (size / 1048576.0) < 15)
{
var fileCreationInformation = new FileCreationInformation();
fileCreationInformation.Content = System.IO.File.ReadAllBytes(row[0].ToString());
fileCreationInformation.Url = filename;
Microsoft.SharePoint.Client.File file = oList.RootFolder.Files.Add(fileCreationInformation);
clientContext.Load(file);
var item = file.ListItemAllFields;
item[lstColCreatedBy] = row[1].ToString();
item[lstColType] = exten;
item[lstColSize] = filesize.Length;
item.Update();
clientContext.ExecuteQuery();
}
}
isError = false;
}
catch (Exception e)
{
isError = true;
Console.WriteLine(e.Message);
}
finally
{
if (isError)
{
//Logging
}
}
}
private static void UpdateSPList(ClientContext clientContext, DataTable dataTable, string fileName)
{
bool isError = true;
string strErrorMsg = string.Empty;
Int32 count = 0;
const string lstName = "UploadedFiles";
const string lstColTitle = "Title";
const string lstColDepartment = "Department";
const string lstColCreatedBy = "CreatedBy";
const string lstColType = "Type";
const string lstColSize = "size";
try
{
SP.List oList = clientContext.Web.Lists.GetByTitle(lstName);
//FieldCollection fields = oList.Fields;
//clientContext.Load(fields);
//clientContext.ExecuteQuery();
//foreach(SP.Field field in fields)
//{
// Console.WriteLine(field.Title);
//}
foreach (DataRow row in dataTable.Rows)
{
System.IO.FileInfo filesize = new System.IO.FileInfo(row[0].ToString());
long size = filesize.Length;
string exten = filesize.Extension;
Type type = filesize.GetType();
if ((size / 1048576.0) > 1 && (size / 1048576.0) < 15)
{
// ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation();
// ListItem oListItem = oList.AddItem(itemCreateInfo);
//oListItem.FieldValues[lstColTitle]= row[0].ToString();
// oListItem[lstColTitle] = row[0].ToString();
// oListItem.FieldValues[lstColDepartment] = row[1].ToString();
// oListItem[lstColCreatedBy] = row[2];
// oListItem[lstColType] = row[3];
// oListItem[lstColSize] = row[2];
var fileCreationInformation = new FileCreationInformation();
fileCreationInformation.Content = System.IO.File.ReadAllBytes(@"C:\Users\vani reddy\documents\visual studio 2017\Projects\SharePointProject\SharePointProject\Screenshot (184).png");
fileCreationInformation.Url = row[0].ToString();
Microsoft.SharePoint.Client.File file = oList.RootFolder.Files.Add(fileCreationInformation);
clientContext.Load(file);
var item = file.ListItemAllFields;
item[lstColDepartment] = row[2].ToString();
item[lstColCreatedBy] = row[1].ToString();
item[lstColType] = exten;
item[lstColSize] = filesize.Length;
item.Update();
clientContext.ExecuteQuery();
// https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html
count++;
}
}
isError = false;
}
catch (Exception e)
{
isError = true;
Console.WriteLine(e.Message);
}
finally
{
if (isError)
{
//Logging
}
}
}
