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