public bool RetrieveExpressImportStatus() { try { var headerValues = Request.Headers.GetValues("Authorization"); var token = headerValues.FirstOrDefault(); var credentialsFromToken = Token.GetCredentialsFromToken(token); var siteUrl = ConfigurationManager.AppSettings["url"]; var sharepointContext = new SharepointContext(siteUrl, credentialsFromToken[0], credentialsFromToken[1]); var streamReader = new StreamReader(HttpContext.Current.Request.InputStream); var retrievedPostData = streamReader.ReadToEnd(); var jObject = JObject.Parse(retrievedPostData); var resourceId = (string)jObject["resourceId"]; var query = string.Format(Query.ExpressImport, resourceId); var retrievedListItems = sharepointContext.RetrieveListItems(query, List.ExpressImports); return retrievedListItems.ToList().Count != 0; } catch (Exception) { return false; throw; } }
public bool AddExpressImportEntry() { try { var headerValues = Request.Headers.GetValues("Authorization"); var token = headerValues.FirstOrDefault(); var credentialsFromToken = Token.GetCredentialsFromToken(token); var siteUrl = ConfigurationManager.AppSettings["url"]; var sharepointContext = new SharepointContext(siteUrl, credentialsFromToken[0], credentialsFromToken[1]); var streamReader = new StreamReader(HttpContext.Current.Request.InputStream); var retrievedPostData = streamReader.ReadToEnd(); var jObject = JObject.Parse(retrievedPostData); var resourceId = (int)jObject["resourceId"]; var startDate = (DateTime)jObject["startDate"]; var endDate = (DateTime)jObject["endDate"]; var addValuesDictionary = new Dictionary<string, object> { {Column.ResourceKey, new FieldLookupValue { LookupId = resourceId }}, {Column.ImportFromDate,startDate }, {Column.ImportToDate,endDate} }; sharepointContext.AddListItem(List.ExpressImports, addValuesDictionary); return true; } catch (IdcrlException) { return false; } }
public List<CustomerModel> GetProjectsList() { try { var headerValues = Request.Headers.GetValues("Authorization"); var token = headerValues.FirstOrDefault(); var credentialsFromToken = Token.GetCredentialsFromToken(token); var siteUrl = ConfigurationManager.AppSettings["url"]; var sharepointContext = new SharepointContext(siteUrl, credentialsFromToken[0], credentialsFromToken[1]); var retrievedListItems = sharepointContext.RetrieveListItems(Query.Customers, List.Customers); var customerList = retrievedListItems.Select(item => new CustomerModel(item)).ToList(); return customerList.Count == 0 ? null : customerList; } catch (IdcrlException) { return null; } catch (InvalidOperationException) { return null; } catch (Exception ex) { throw ex; } }
public List<ResourceModel> GetAuthenticationWithToken() { try { var headerValues = Request.Headers.GetValues("Authorization"); var token = headerValues.FirstOrDefault(); var siteUrl = ConfigurationManager.AppSettings["url"]; var credentialsFromToken = Token.GetCredentialsFromToken(token); var sharepointContext = new SharepointContext(siteUrl, credentialsFromToken[0], credentialsFromToken[1]); var query = string.Format(Query.ResourceId, credentialsFromToken[0]); const string listTitle = List.Resources; var retrievedListItems = sharepointContext.RetrieveListItems(query, listTitle); var idList = retrievedListItems.Select(item => new ResourceModel(item)).ToList(); return idList.Count == 0 ? null : idList; } catch (IdcrlException) { return null; } }
public List<ResourceModel> AuthenticationWithCredentials() { try { var streamReader = new StreamReader(HttpContext.Current.Request.InputStream); var retrievedPostData = streamReader.ReadToEnd(); var jObject = JObject.Parse(retrievedPostData); var username = Token.DecryptStringAes((string)jObject["username"]); var password = Token.DecryptStringAes((string)jObject["password"]); var siteUrl = ConfigurationManager.AppSettings["url"]; var sharepointContext = new SharepointContext(siteUrl, username, password); var query = string.Format(Query.ResourceId, username); var retrievedListItems = sharepointContext.RetrieveListItems(query, List.Resources); var idList = retrievedListItems.Select(item => new ResourceModel(item)).ToList(); return idList.Count == 0 ? null : idList; } catch (IdcrlException) { return null; } }
private SharepointContext CreateSharepointContext() { var credentialsFromToken = GetCredentialsFromHeader(); var siteUrl = ConfigurationManager.AppSettings["url"]; var sharepointContext = new SharepointContext(siteUrl, credentialsFromToken[0], credentialsFromToken[1]); return sharepointContext; }