private string ForamtFileSearch(OwnerayoutFileType dojoType, string mimeType) { string filenameFilter = (dojoType == OwnerayoutFileType.Future ? "-airbnb_pending.csv" : "-airbnb.csv"); string beginOfLastMonth = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-01T12:00:00"); return(string.Format("name contains '{0}' and mimeType='{1}' and createdTime > '{2}'", filenameFilter, mimeType, beginOfLastMonth)); }
public List <SelectListItem> GetAirbnbReportFiles(OwnerayoutFileType type, DateTime reportDate) { List <SelectListItem> selectList = new List <SelectListItem>(); try { string searchFilter = FormatFolderFileSearch(type, reportDate); DojoLogger.Info(string.Format("search filter={0}", searchFilter)); var files = GetFileList(searchFilter); foreach (var file in files) { selectList.Add(new SelectListItem { Text = file.Name, Value = file.Name + ";" + file.Id }); } return(selectList.OrderBy(x => x.Text).ToList()); } catch (Exception ex) { DojoLogger.Error(ex.Message); throw; } }
private string FormatFolderFileSearch(OwnerayoutFileType dojoType, DateTime reportDate) { // get the folder Id for the reportDate string parentId = string.Empty; string folderName = (dojoType == OwnerayoutFileType.Future ? string.Format("Future Transactions - {0}", reportDate.ToString("MMMMM d yyyy")) : reportDate.ToString("MMMMM d yyyy")); // e.g. April 5 2017 string folderFilter = string.Format("mimeType='{0}' and name='{1}'", FOLDER_MIME_TYPE, folderName); var folders = GetFileList(folderFilter); if (folders.Count > 0) { parentId = folders[0].Id; } // search query for reportDate files string filenameFilter = (dojoType == OwnerayoutFileType.Future ? "-airbnb_pending.csv" : "-airbnb.csv"); return(string.Format("'{0}' in parents and name contains '{1}'", parentId, filenameFilter)); }
public List <SelectListItem> GetAirbnbReportFolders(OwnerayoutFileType type) { List <SelectListItem> selectList = new List <SelectListItem>(); try { string searchFilter = FormatFolderSearch(type); var folders = GetFileList(searchFilter); foreach (var folder in folders) { selectList.Add(new SelectListItem { Text = folder.Name, Value = folder.Id }); } return(selectList.OrderBy(x => x.Text).ToList()); } catch { throw; } }
private string FormatFolderSearch(OwnerayoutFileType dojoType) { string parentId = (dojoType == OwnerayoutFileType.Future ? FutureFolderId : CompletedFolderId); return(string.Format("'{0}' in parents and mimeType='{1}'", parentId, FOLDER_MIME_TYPE)); }