public ActionResult EventandTrainingTab(string id) { EandTModel eventsListData = new EandTModel(); eventsListData = GetDataHelper.GetEandT(); foreach (var item in eventsListData.EventsAndtraining) { if (item.ETID == id) { GetDataHelper.ETStatusUpdate(item.ETID); } } eventsListData = GetDataHelper.GetEandT(); EventsAndTraining[] EventGrid = new EventsAndTraining[eventsListData.EventsAndtraining.Length]; EventsAndTraining[] UpcomingEventGrid = new EventsAndTraining[eventsListData.EventsAndtraining.Length]; EventsAndTraining[] TrainingGrid = new EventsAndTraining[eventsListData.EventsAndtraining.Length]; EventsAndTraining[] UpcomingTrainingGrid = new EventsAndTraining[eventsListData.EventsAndtraining.Length]; TrainingGrid = eventsListData.EventsAndtraining.Where(i => i.UserAdded == true).ToArray(); UpcomingTrainingGrid = eventsListData.EventsAndtraining.Where(i => i.UserAdded == false).ToArray(); EventGrid = eventsListData.EventsAndtraining.Where(i => i.UserAdded == true).ToArray(); UpcomingEventGrid = eventsListData.EventsAndtraining.Where(i => i.UserAdded == false). Where(i => i.UserAdded == false).ToArray(); EventGrid = TrainingGrid; UpcomingEventGrid = UpcomingTrainingGrid; eventsListData.EventGrid = EventGrid; eventsListData.UpcomingEventGrid = UpcomingEventGrid; return(View(eventsListData)); }
public static void UpdateETMockData() { string filename = System.Web.Hosting.HostingEnvironment.MapPath("~/TestData/") + @"/EventsAndTraining_June.json"; if (File.Exists(filename)) { EandTModel eandt = GetDataHelper.GetEandT(); int eandtCount = eandt.EventsAndtraining.Count(); for (int i = 0; i < eandtCount; i++) { } string json = File.ReadAllText(filename); } //EventsAndTraining et = new JavaScriptSerializer().Deserialize<EventsAndTraining>(json); //foreach(EventsAndTraining i in et) //{ // et.ETDate = DateTime.Now.Date.ToString("MM/dd/yyyy"); //} }
public static EandTModel GetEandT() { string file = System.Web.Hosting.HostingEnvironment.MapPath("~/TestData/") + @"/EventsAndTraining_June.json"; EandTModel eventsTrainings = new EandTModel(); string json = File.ReadAllText(file).Replace("##BaseURL##", ApplicationSettings.BaseUrl); eventsTrainings = (new JavaScriptSerializer().Deserialize <EandTModel>(json)); return(eventsTrainings); }
//[Obsolete] public static Attachment UpcomingEventsTraining() { EandTModel ETlist = new EandTModel(); ETlist = Helper.GetDataHelper.GetEandT(); var card = new ListCard(); card.content = new Content(); var list = new List <Item>(); card.content.title = "Upcoming events and training for you"; DateTime CurrDate = new DateTime(2019, 6, 1); for (int i = 0; i < ETlist.EventsAndtraining.Count(); i++) { if (!ETlist.EventsAndtraining[i].UserAdded) { continue; } else { DateTime D = DateTime.ParseExact(ETlist.EventsAndtraining[i].ETStartDate, "MM-dd-yyyy", System.Globalization.CultureInfo.InvariantCulture); if (D <= CurrDate.AddDays(7)) { var item = new Item(); item.icon = "https://fleetinfobot.azurewebsites.net/resources/Airline-Fleet-Bot-02.png"; item.id = i.ToString(); item.subtitle = ETlist.EventsAndtraining[i].ETStartDate + " to " + ETlist.EventsAndtraining[i].ETEndDate; item.type = "resultItem"; item.title = ETlist.EventsAndtraining[i].ETTitle; item.tap = new Tap() { type = "imBack", title = "titleitem", value = "Event and training item" + i }; list.Add(item); } } } card.content.items = list.ToArray(); Attachment attachment = new Attachment(); attachment.ContentType = card.contentType; attachment.Content = card.content; return(attachment); }
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); } }