public static async Task <MeetingDetail> InsertOrMergeEntityAsync(CloudTable table, MeetingDetail entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
try
{
// Create the InsertOrReplace table operation
TableOperation insertOrMergeOperation = TableOperation.InsertOrMerge(entity);
// Execute the operation.
TableResult result = await table.ExecuteAsync(insertOrMergeOperation);
MeetingDetail meetingDetail = result.Result as MeetingDetail;
// Get the request units consumed by the current operation. RequestCharge of a TableResult is only applied to Azure Cosmos DB
return(meetingDetail);
}
catch (Microsoft.Azure.Cosmos.Table.StorageException e)
{
throw;
}
}
public ActionResult DeleteConfirmed(int id)
{
MeetingDetail meetingDetail = db.MeetingDetails.Find(id);
db.MeetingDetails.Remove(meetingDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Meeting_ID,Meeting_Title,Meeting_Date,Meeting_StartTime,Meeting_EndTime")] MeetingDetail meetingDetail)
{
if (ModelState.IsValid)
{
db.Entry(meetingDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(meetingDetail));
}
private async Task <DialogTurnResult> AskForDuration(WaterfallStepContext stepContext, CancellationToken cancellationToken)
{
string result = (string)stepContext.Context.TurnState["data"]; //gets attendees' names
var tokenResponse = (TokenResponse)stepContext.Result; //gets token
if (tokenResponse?.Token != null)
{
var client = new SimpleGraphClient(tokenResponse.Token);
string[] attendeeNames = string.Concat(result.Where(c => !char.IsWhiteSpace(c))).Split(","); //splits comma separated names of attendees
List <string> attendeeTableStorage = new List <string>();
foreach (string name in attendeeNames)
{
List <string> attendeeEmails = await client.GetAttendeeEmailFromName(name); //gets email from attendee's name
if (attendeeEmails.Count > 1) //there can be multiple people having same first name, ask user to start again and enter email instead to be more specific
{
await stepContext.Context.SendActivityAsync("There are " + attendeeEmails.Count + " people whose name start with " + name + ". Please type hi to start again, and instead of first name, enter email to avoid ambiguity.");
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
else if (attendeeEmails.Count == 1) // attendee found
{
attendeeTableStorage.Add(attendeeEmails[0]);
}
else //attendee not found in organization
{
await stepContext.Context.SendActivityAsync("Attendee not found, please type anything to start again");
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
}
var sb = new System.Text.StringBuilder();
foreach (string email in attendeeTableStorage)
{
sb.Append(email + ","); //converts emails to comma separated string to store in table
}
string finalString = sb.ToString().Remove(sb.Length - 1);
if (result != null)
{
MeetingDetail meetingDetail = new MeetingDetail(stepContext.Context.Activity.Conversation.Id, userEmail);
meetingDetail.Attendees = finalString;
await InsertOrMergeEntityAsync(table, meetingDetail); //inserts attendees' emails in table
return(await stepContext.PromptAsync(nameof(NumberPrompt <double>), new PromptOptions { Prompt = MessageFactory.Text("What will be duration of the meeting? (in hours)"), RetryPrompt = MessageFactory.Text("Invalid value, please enter a proper value") }, cancellationToken));
}
}
await stepContext.Context.SendActivityAsync("Something went wrong. Please type anything to get started again.");
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
public async Task <ActionResult> Login12(LoginViewModel model, string returnUrl)
{
// HttpCookie cookie = new HttpCookie("Login");
var user = await UserManager.FindByNameAsync(model.Email);
if (user != null)
{
var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, false, false);
switch (result)
{
case SignInStatus.Success:
if (dbOperations.ValidateUserWithMeetingDetails(model.Email) == false)
{
return(View("InValid", "In Valid User"));
}
//if (model.RememberMe)
//{
// cookie.Values.Add("Email", model.Email);
// cookie.Values.Add("Password", model.Password);
// cookie.Expires = DateTime.Now.AddDays(15);
// Response.Cookies.Add(cookie);
//}
//else
//{
// Response.Cookies.Remove("Login");
// cookie.Expires = DateTime.Now.AddDays(-15);
// cookie.Value = null;
// Response.SetCookie(cookie);
//}
_meetingDetails = (new CommonOperations()).GetMeetingDetail(0, model.Email);
MeetingID = _meetingDetails.MeetingID;
//bool checktype=(new CommonOperations()).GetUserType(model.Email);
//if (checktype)
_meetingDetails.SuperAdmin = true;
ViewBag.MeetingDetails = MeetingDetails;
ViewBag.IsSubmitted = ReadOnly;
SetInformationTabDetails(1);
return(RedirectToAction("InformationView"));
default:
ViewBag.InvalidUser = true;
return(View("Login"));
}
}
return(View("InValid", "In Valid User"));
}
public ActionResult Create([Bind(Include = "Meeting_ID,Meeting_Title,Meeting_Date,Meeting_StartTime,Meeting_EndTime")] MeetingDetail meetingDetail)
{
if (ModelState.IsValid)
{
db.MeetingDetails.Add(meetingDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(meetingDetail));
}
// GET: MeetingDetails/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MeetingDetail meetingDetail = db.MeetingDetails.Find(id);
if (meetingDetail == null)
{
return(HttpNotFound());
}
return(View(meetingDetail));
}
public void SetMeeting(MeetingInfo meeting)
{
using (var context = new RepoDemo.MeetingDemoEntities())
{
var meetingInfo = new MeetingDetail
{
MeetingAgenda = meeting.MeetingAgenda,
MeetingAttendees = meeting.MeetingAttendees,
MeetingDateTime = meeting.MeetingDateTime,
MeetingSubject = meeting.MeetingSubject
};
context.MeetingDetails.Add(meetingInfo);
context.SaveChanges();
}
}
public void UpdateMeetingById(MeetingInfo meeting)
{
using (var context = new RepoDemo.MeetingDemoEntities())
{
var meetingInfo = new MeetingDetail
{
MeetingAgenda = meeting.MeetingAgenda,
MeetingAttendees = meeting.MeetingAttendees,
MeetingDateTime = meeting.MeetingDateTime,
MeetingId = meeting.MeetingId,
MeetingSubject = meeting.MeetingSubject
};
context.Entry(meetingInfo).State = EntityState.Modified;
context.SaveChanges();
}
}
private async Task <DialogTurnResult> AskForDescription(WaterfallStepContext stepContext, CancellationToken cancellationToken)
{
var result = (string)stepContext.Result;
if (result != null)
{
MeetingDetail meetingDetail = new MeetingDetail(stepContext.Context.Activity.Conversation.Id, userEmail);
meetingDetail.Title = result;
await InsertOrMergeEntityAsync(table, meetingDetail); //inserts title in table
return(await stepContext.PromptAsync(nameof(TextPrompt), new PromptOptions { Prompt = MessageFactory.Text("Please enter description of the meeting") }, cancellationToken));
}
await stepContext.Context.SendActivityAsync("Something went wrong. Please type anything to get started again.");
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
/// <summary>
/// Updates the Meeting.
/// </summary>
/// <param name="adobeConnectXmlApi">The adobe connect XML API.</param>
/// <param name="meetingUpdateItem"><see cref="MeetingUpdateItem" /></param>
/// <returns>
/// <see cref="ApiStatus" />
/// </returns>
public static ApiStatus MeetingUpdate(this AdobeConnectXmlAPI adobeConnectXmlApi, MeetingUpdateItem meetingUpdateItem)
{
MeetingDetail meetingDetail = null;
if (meetingUpdateItem == null)
{
return(null);
}
if (String.IsNullOrEmpty(meetingUpdateItem.ScoId))
{
return(Helpers.WrapStatusException(StatusCodes.Invalid, StatusSubCodes.Format, new ArgumentNullException("MeetingItem", "ScoId must be set to update existing item")));
}
meetingUpdateItem.FolderId = null;
return(adobeConnectXmlApi.ScoUpdate(meetingUpdateItem, out meetingDetail));
}
public ActionResult LogOff(string Email)
{
if (!string.IsNullOrEmpty(Email))
{
var user = db.Repository <ApplicationUser>().GetAll().Where(a => a.Email == Email).FirstOrDefault();
if (user != null)
{
user.LastLoginDate = DateTime.Now;
db.Repository <ApplicationUser>().Update(user);
db.SaveChanges();
}
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
_meetingDetails = null;
MeetingID = 0;
}
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
return(RedirectToAction("Login", "Participant"));
}
private async Task <DialogTurnResult> ShowMeetingTimeSuggestions(WaterfallStepContext stepContext, CancellationToken cancellationToken)
{
double duration = Convert.ToDouble(stepContext.Context.TurnState["data"]);
var tokenResponse = (TokenResponse)stepContext.Result;
if (tokenResponse?.Token != null)
{
// Pull in the data from the Microsoft Graph.
var client = new SimpleGraphClient(tokenResponse.Token);
MeetingDetail meetingDetail = await RetrieveMeetingDetailsAsync(table, userEmail, stepContext.Context.Activity.Conversation.Id); //retrives data from table
timeSuggestions = await client.FindMeetingTimes(meetingDetail.Attendees, duration); //returns meeting times
if (timeSuggestions.Count == 0)
{
await stepContext.Context.SendActivityAsync("No appropriate meeting slot found. Please try again by typing 'hi' and change date this time");
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
var cardOptions = new List <Choice>();
for (int i = 0; i < timeSuggestions.Count; i++)
{
cardOptions.Add(new Choice()
{
Value = timeSuggestions[i].Start.DateTime + " - " + timeSuggestions[i].End.DateTime
}); //creates list of meeting time choices
}
return(await stepContext.PromptAsync(nameof(ChoicePrompt), new PromptOptions
{
Prompt = MessageFactory.Text("These are the time suggestions. Click on the time slot for when you want the meeting to be set."),
RetryPrompt = MessageFactory.Text("Sorry, Please the valid choice"),
Choices = cardOptions,
Style = ListStyle.HeroCard, //displays choices as buttons
}, cancellationToken));
}
await stepContext.Context.SendActivityAsync("Something went wrong. Please type anything to get started again.");
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
public static async Task <MeetingDetail> RetrieveMeetingDetailsAsync(CloudTable table, string partitionKey, string rowKey)
{
try
{
TableOperation retrieveOperation = TableOperation.Retrieve <MeetingDetail>(partitionKey, rowKey);
TableResult result = await table.ExecuteAsync(retrieveOperation);
MeetingDetail meetingDetail = result.Result as MeetingDetail;
if (meetingDetail != null)
{
return(meetingDetail);
}
return(null);
}
catch (StorageException e)
{
throw;
}
}
private async Task <DialogTurnResult> SendMeetingInvite(WaterfallStepContext stepContext, CancellationToken cancellationToken)
{
string description = (string)stepContext.Context.TurnState["data"];
var tokenResponse = (TokenResponse)stepContext.Result;
if (tokenResponse?.Token != null)
{
var client = new SimpleGraphClient(tokenResponse.Token);
MeetingDetail meetingDetail = await RetrieveMeetingDetailsAsync(table, userEmail, stepContext.Context.Activity.Conversation.Id); //retrieves current meeting details
await client.SendMeetingInviteAsync(timeSuggestions[Int32.Parse(meetingDetail.TimeSlotChoice)], meetingDetail.Attendees, meetingDetail.Title, description); //creates event
await stepContext.Context.SendActivityAsync("Meeting has been scheduled. Thank you!");
}
else
{
await stepContext.Context.SendActivityAsync("Something went wrong. Please type anything to get started again.");
}
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
private async Task <DialogTurnResult> AskForAttendees(WaterfallStepContext stepContext, CancellationToken cancellationToken)
{
var tokenResponse = (TokenResponse)stepContext.Result; // Get the token from the previous step.
if (tokenResponse?.Token != null)
{
// Pull in the data from the Microsoft Graph.
var client = new SimpleGraphClient(tokenResponse.Token);
var me = await client.GetMeAsync();
userEmail = me.UserPrincipalName;
table = CreateTableAsync("botdata"); //creates table if does not exist already
MeetingDetail meetingDetail = new MeetingDetail(stepContext.Context.Activity.Conversation.Id, userEmail);
await InsertOrMergeEntityAsync(table, meetingDetail); //inserts user's email in table
return(await stepContext.PromptAsync(nameof(TextPrompt), new PromptOptions { Prompt = MessageFactory.Text("With whom would you like to set up a meeting?") }, cancellationToken));
}
await stepContext.Context.SendActivityAsync("Something went wrong. Please type anything to get started again.");
return(await stepContext.EndDialogAsync(cancellationToken : cancellationToken));
}
public ActionResult Login()
{
MeetingID = 0;
_meetingDetails = null;
ViewBag.MeetingDetails = null;
DAL.LoginViewModel model = new DAL.LoginViewModel();
if (User.Identity.IsAuthenticated == false)
{
// ViewBag.ReturnUrl = returnUrl;
if (Request.Cookies["Login"] != null)
{
model.Email = Request.Cookies["Login"].Values["Email"];
model.Password = Request.Cookies["Login"].Values["Password"];
model.RememberMe = true;
}
}
return(View(model));
}
public MeetingDetail GetMeetingDetail(int meetingID, string email = null)
{
MeetingDetail model = new MeetingDetail();
if (meetingID == 0 && string.IsNullOrEmpty(email))
{
return(null);
}
using (meetingContext = new OCASIAMeetingContext())
{
if (meetingID == 0)
{
model = meetingContext.UserDetails.Where(el => el.IsActive && el.Email == email).Select(el =>
new MeetingDetail()
{
MeetingID = el.MeetingID.Value,
MeetingName = el.Meetings.MeetingName,
UserDetailsID = el.UserDetailID,
Tabs = el.Meetings.RegistrationTabs,
EmailAddress = el.Meetings.OfficalEmail,
PageBanner = el.Meetings.PageBannerPath,
FaqDescription = el.Meetings.FaqDescription,
FaqPath = el.Meetings.FaqPath,
UserName = el.GivenName,
StartDate = el.Meetings.EventStartDate,
ContactNumber = el.Meetings.PhoneNumber,
ReadOnly = el.IsSubmitted == null ? false : el.IsSubmitted.Value,
IsPersonalFilled = string.IsNullOrEmpty(el.PassportNumber) ? false : true
}
).FirstOrDefault();
if (model == null)
{
return(null);
}
model.IsTravelFilled = meetingContext.TravelDetails.Where(el => el.IsActive && el.UserDetailID == model.UserDetailsID).FirstOrDefault() == null ? true : false;
model.IsGuestsFilled = meetingContext.UserDetails.Where(el => el.IsActive && el.GuestOf == model.UserDetailsID.ToString()).FirstOrDefault() == null ? true : false;
}
else
{
model = meetingContext.Meetings.Where(el => el.IsActive && el.AllowRegistration && el.IsActive && el.MeetingID == meetingID).Select(el => new MeetingDetail()
{
MeetingID = el.MeetingID,
MeetingName = el.MeetingName,
StartDate = el.EventStartDate,
Tabs = el.RegistrationTabs,
ContactNumber = el.PhoneNumber,
EmailAddress = el.OfficalEmail,
FaqDescription = el.FaqDescription,
FaqPath = el.FaqPath,
PageBanner = el.PageBannerPath
}).FirstOrDefault();
}
if (model == null)
{
return(null);
}
#if DEBUG
model.PageBanner = "../Content/banners.jpg";
model.FaqPath = "../Content/banners.jpg";
#else
model.PageBanner = model.PageBanner?.Replace("~", Helper.FilePath);
model.FaqPath = model.FaqPath?.Replace("~", Helper.FilePath);
#endif
}
return(model);
}
/// <summary>
/// Creates a new Meeting.
/// </summary>
/// <param name="adobeConnectXmlApi">The adobe connect XML API.</param>
/// <param name="meetingUpdateItem"><see cref="MeetingUpdateItem" /></param>
/// <param name="meetingDetail"><see cref="MeetingDetail" /></param>
/// <returns>
/// <see cref="ApiStatus" />
/// </returns>
public static ApiStatus MeetingCreate(this AdobeConnectXmlAPI adobeConnectXmlApi, MeetingUpdateItem meetingUpdateItem, out MeetingDetail meetingDetail)
{
meetingDetail = null;
if (meetingUpdateItem == null)
{
return(null);
}
if (String.IsNullOrEmpty(meetingUpdateItem.FolderId))
{
return(Helpers.WrapStatusException(StatusCodes.Invalid, StatusSubCodes.Format, new ArgumentNullException("MeetingItem", "FolderID must be set to create new item")));
}
if (meetingUpdateItem.MeetingItemType == SCOtype.NotSet)
{
return(Helpers.WrapStatusException(StatusCodes.Invalid, StatusSubCodes.Format, new ArgumentNullException("MeetingItem", "SCOtype must be set")));
}
meetingUpdateItem.ScoId = null;
return(adobeConnectXmlApi.ScoUpdate(meetingUpdateItem, out meetingDetail));
}
public MeetingController()
{
meetingDetail = new MeetingDetail();
}
