//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);
}
}
