private DataClasses.Document ClearDocumentProperties(DataClasses.Document document) { document.BucketName = ""; document.CommentID = ""; document.Comments = ""; document.Content_Bytes = null; document.Content_Ext = ""; document.Content_Size = 0; document.Content_title = ""; document.Content_Type = ""; document.DocumentId = ""; document.DocumentTitle = ""; document.DownloadFilePath = ""; document.FileId = ""; document.Mode = ""; document.Mongo_FileId1 = ""; document.Mongo_FileId2 = ""; document.Mongo_FileId3 = ""; document.Mongo_FileId4 = ""; document.Mongo_FileId5 = ""; document.Mongo_Meta = ""; document.NumFiles = 0; document.PHID = ""; document.PMID = ""; document.SharePoint_FileId1 = ""; document.SharePoint_FileId2 = ""; document.SharePoint_FileId3 = ""; document.SharePoint_FileId4 = ""; document.SharePoint_FileId5 = ""; document.SharePoint_Meta = ""; document.UploadFilePath = ""; return(document); }
protected bool Main() { bool nResult = true; DataClasses.Document document = new DataClasses.Document(); string dtIn = DateTime.Now.ToString("yyyy-MM-dd"); using (SPSite site = new SPSite(strUrl)) { using (SPWeb web = site.OpenWeb()) { SPList list = web.Lists["PolicyHolders"]; SPQuery query = new SPQuery(); query.RowLimit = 50; SPListItemCollection items = list.GetItems(query); foreach (SPListItem item in items) { SPAttachmentCollection attachments = item.Attachments; foreach (string fileName in attachments) { SPFile file = web.GetFile(attachments.UrlPrefix + fileName); byte[] bArray = file.OpenBinary(); document.BucketName = "pdfs"; document.CommentID = ""; document.Comments = ""; document.Content_Bytes = bArray; document.Content_Ext = "pdf"; document.Content_Size = 0; document.Content_title = item["Title"].ToString(); document.Content_Type = ""; document.DocumentId = item.ID.ToString(); document.DocumentTitle = ""; document.DownloadFilePath = fileName; document.FileId = ""; document.Mode = "initial"; document.Mongo_FileId1 = ""; document.Mongo_FileId2 = ""; document.Mongo_FileId3 = ""; document.Mongo_FileId4 = ""; document.Mongo_FileId5 = ""; document.Mongo_Meta = ""; document.NumFiles = 1; document.PHID = item["PolicyHolder_ID"].ToString(); document.PMID = ""; document.SharePoint_FileId1 = item["PolicyHolder_SocialSecurityNumbe"].ToString(); document.SharePoint_FileId2 = item["PolicyHolder_LastName"].ToString(); document.SharePoint_FileId3 = item["PolicyHolder_FirstName"].ToString(); document.SharePoint_FileId4 = item["PolicyHolder_ID"].ToString(); document.SharePoint_FileId5 = ""; document.SharePoint_Meta = ""; document.UploadFilePath = "migration"; document.Content_Date = Convert.ToDateTime(dtIn); document.DocumentDate = Convert.ToDateTime(dtIn); document.Import_Date = Convert.ToDateTime(dtIn); Handlers.DocumentHandler handler = new Handlers.DocumentHandler(document); ClearDocumentProperties(document); //document.BucketName = "pdfs"; //document.FileExt = "pdf"; //document.NumFiles = 1; //document.UploadFilePath = fileName; //document.Content = bArray; } } } } return(nResult); }