//need to make PO changes to get the details of PO to adaptive card public static async System.Threading.Tasks.Task GetPODetailsandWriteToFile() // need to decide how many time it will run and update the data file. { string token = await GetDataHelper.GetAuthenticationToken(); string endpoint = "https://avadheshftc.sharepoint.com/sites/EmployeeConnectPrototype/_api/web/Lists(guid'74ff3893-3f08-4c67-a835-334cdaf6bfa3')/items"; SpfxPurchaseOrder news = null; using (var client = new HttpClient()) { using (var request = new HttpRequestMessage(HttpMethod.Get, endpoint)) { string location = System.Web.Hosting.HostingEnvironment.MapPath(@"~\TestData\"); request.Headers.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); request.Headers.Authorization = new AuthenticationHeaderValue("Bearer", token); using (HttpResponseMessage response = await client.SendAsync(request)) { if (response.IsSuccessStatusCode) { var json = await response.Content.ReadAsStringAsync(); try { news = (new JavaScriptSerializer().Deserialize <SpfxPurchaseOrder>(json)); File.WriteAllText(location + "PODetailsMock.json", json); } catch (Exception ex) { } } } } } }
public static SpfxPurchaseOrder GetPOs() { string file = System.Web.Hosting.HostingEnvironment.MapPath("~/TestData/") + @"/purchaseOrderMock.json"; SpfxPurchaseOrder POs = new SpfxPurchaseOrder(); string json = File.ReadAllText(file).Replace("##BaseURL##", ApplicationSettings.BaseUrl); POs = (new JavaScriptSerializer().Deserialize <SpfxPurchaseOrder>(json)); return(POs); }
public static ComposeExtensionResponse HandleMessageExtensionQuery(ConnectorClient connector, Activity activity) { var query = activity.GetComposeExtensionQueryData(); if (query == null) { // We only process the 'getRandomText' queries with this message extension return(null); } if (query.CommandId == "News") { NewsModel news = GetDataHelper.GetNews(); var title = ""; var titleParam = query.Parameters?.FirstOrDefault(p => p.Name == "newsTitle"); var response = new ComposeExtensionResponse(new ComposeExtensionResult("list", "result")); ComposeExtensionAttachment[] attachments = null; if (titleParam != null) { title = titleParam.Value.ToString(); List <string> searchtitle = news.news.Select(a => a.NewsTitle).Where(c => c.ToLower().Contains(title.ToLower())).Select(d => d).ToList(); List <string> searchImages = news.news.Where(a => a.NewsTitle.ToLower().Contains(title.ToLower())).Select(c => c.NewsThumbnailUrl).ToList(); List <string> searchDateTime = news.news.Where(a => a.NewsTitle.ToLower().Contains(title.ToLower())).Select(c => c.NewsDateTIme).ToList(); List <string> searchdetail = news.news.Where(a => a.NewsTitle.ToLower().Contains(title.ToLower())).Select(c => c.DetailedNews).ToList(); List <string> searchby = news.news.Where(a => a.NewsTitle.ToLower().Contains(title.ToLower())).Select(c => c.NewsBy).ToList(); int attacCount = searchtitle.Count(); attachments = new ComposeExtensionAttachment[attacCount]; for (int i = 0; i < attacCount; i++) { attachments[i] = GetNewsAttachment(searchImages[i], searchtitle[i], searchby[i], searchdetail[i]); } response.ComposeExtension.Attachments = attachments.ToList(); } else { List <string> searchtitle = news.news.Select(c => c.NewsTitle).Take(20).ToList(); List <string> searchImages = news.news.Select(c => c.NewsThumbnailUrl).Take(20).ToList(); List <string> searchDateTime = news.news.Select(c => c.NewsDateTIme).Take(20).ToList(); List <string> searchdetail = news.news.Select(c => c.DetailedNews).Take(20).ToList(); List <string> searchby = news.news.Select(c => c.NewsBy).Take(20).ToList(); attachments = new ComposeExtensionAttachment[searchtitle.Count()]; for (int i = 0; i < searchtitle.Count(); i++) { attachments[i] = GetNewsAttachment(searchImages[i], searchtitle[i], searchby[i], searchdetail[i]); } response.ComposeExtension.Attachments = attachments.ToList(); } return(response); } else if (query.CommandId == "Task") { SpfxPurchaseOrder task = GetDataHelper.GetPOs(); var title = ""; var titleParam = query.Parameters?.FirstOrDefault(p => p.Name == "tasktitle"); var response = new ComposeExtensionResponse(new ComposeExtensionResult("list", "result")); ComposeExtensionAttachment[] attachments = null; if (titleParam != null) { title = titleParam.Value.ToString(); //List<string> description = task.PurchaseOrder.Select(a => a.Description).Where(c => c.ToLower().Contains(title.ToLower())).Select(d => d).ToList(); //List<string> totamount = task.PurchaseOrder.Where(a => a.Description.ToLower().Contains(title.ToLower())).Select(c => c.TotalAmount).ToList(); List <string> description = task.value.Select(a => a.Description).Where(c => c.ToLower().Contains(title.ToLower())).Select(d => d).ToList(); List <string> totamount = task.value.Where(a => a.Description.ToLower().Contains(title.ToLower())).Select(c => c.TotalAmount).ToList(); int attacCount = description.Count(); attachments = new ComposeExtensionAttachment[attacCount]; for (int i = 0; i < attacCount; i++) { attachments[i] = GetTaskAttachments(description[i], totamount[i]); } response.ComposeExtension.Attachments = attachments.ToList(); } else { List <string> description = task.value.Where(b => b.PoStatus == "pending").Select(c => c.Description).Take(20).ToList(); List <string> totamount = task.value.Where(b => b.PoStatus == "pending").Select(c => c.TotalAmount).Take(20).ToList(); attachments = new ComposeExtensionAttachment[description.Count()]; for (int i = 0; i < description.Count(); i++) { attachments[i] = GetTaskAttachments(description[i], totamount[i]); } response.ComposeExtension.Attachments = attachments.ToList(); } return(response); } else if (query.CommandId == "EventsAndTrainings") { EandTModel eventsTrainings = GetDataHelper.GetEandT(); var title = ""; var titleParam = query.Parameters?.FirstOrDefault(p => p.Name == "EventsAndTrainingstitle"); var response = new ComposeExtensionResponse(new ComposeExtensionResult("list", "result")); ComposeExtensionAttachment[] attachments = null; if (titleParam != null) { title = titleParam.Value.ToString(); List <string> searchTitle = eventsTrainings.EventsAndtraining.Select(a => a.ETTitle).Where(c => c.ToLower().Contains(title.ToLower())).Select(d => d).ToList(); List <string> searchdetails = eventsTrainings.EventsAndtraining.Select(a => a.ETDetails).Where(c => c.ToLower().Contains(title.ToLower())).Select(d => d).ToList(); List <string> searchdate = eventsTrainings.EventsAndtraining.Where(a => a.ETTitle.ToLower().Contains(title.ToLower())).Select(d => d.ETStartDate).ToList(); List <string> searchimage = eventsTrainings.EventsAndtraining.Where(a => a.ETTitle.ToLower().Contains(title.ToLower())).Select(d => d.ETThumbnailUrl).ToList(); List <string> searchETType = eventsTrainings.EventsAndtraining.Where(a => a.ETTitle.ToLower().Contains(title.ToLower())).Select(d => d.ETType).ToList(); List <string> searchETid = eventsTrainings.EventsAndtraining.Where(a => a.ETTitle.ToLower().Contains(title.ToLower())).Select(d => d.ETID).ToList(); List <bool> searchETar = eventsTrainings.EventsAndtraining.Where(a => a.ETTitle.ToLower().Contains(title.ToLower())).Select(d => d.UserAdded).ToList(); int attacCount = searchTitle.Count(); attachments = new ComposeExtensionAttachment[attacCount]; for (int i = 0; i < attacCount; i++) { attachments[i] = GetEventsAttachment(searchimage[i], searchTitle[i] + ',' + searchETType[i], searchdate[i], searchdetails[i], searchETid[i], searchETar[i]); } response.ComposeExtension.Attachments = attachments.ToList(); } else { List <string> searchTitle = eventsTrainings.EventsAndtraining.Select(c => c.ETTitle).ToList(); List <string> searchdetails = eventsTrainings.EventsAndtraining.Select(c => c.ETDetails).ToList(); List <string> searchdate = eventsTrainings.EventsAndtraining.Select(c => c.ETStartDate).ToList(); List <string> searchimage = eventsTrainings.EventsAndtraining.Select(c => c.ETThumbnailUrl).ToList(); List <string> searchETType = eventsTrainings.EventsAndtraining.Select(c => c.ETType).ToList(); List <string> searchETid = eventsTrainings.EventsAndtraining.Select(c => c.ETID).ToList(); List <bool> searchETar = eventsTrainings.EventsAndtraining.Select(c => c.UserAdded).ToList(); attachments = new ComposeExtensionAttachment[searchTitle.Count]; for (int i = 0; i < searchTitle.Count; i++) { attachments[i] = GetEventsAttachment(searchimage[i], searchTitle[i] + ',' + searchETType[i], searchdate[i], searchdetails[i], searchETid[i], searchETar[i]); } response.ComposeExtension.Attachments = attachments.ToList(); } return(response); } else { return(null); } }