private static void SaveChangesfromBooking(string userName, BookMeetingRoomForm entity, out string nameRoom)
{
var db = new Model.EntityModelContainer();
var typeRoom = false;
nameRoom = string.Empty;
if (entity.TypeRoom.Value.ToString() == With_Projector)
{
typeRoom = true;
}
var listNomRoom = db.RoomSet.Where(b => b.Projector == typeRoom && b.Size >= entity.Attendant);
db.Bookings.Add(new Model.Booking
{
EmplyeeId = userName,
StartDate = entity.StartDate,
StartTime = entity.StartTime,
EndTime = entity.EndTime,
Attendant = entity.Attendant,
Room = listNomRoom.First(),
IsCancel = false,
});
nameRoom = listNomRoom.First().NameRoom.ToString();
db.SaveChanges();
}
private static void ShowBookings(IDialogContext context, ViewMeetingRoomForm entity, out bool result)
{
var db = new Model.EntityModelContainer();
result = false;
var user = context.Activity.From.Name;
IQueryable <Model.Booking> contactQuery = null;
// Iterate through the results of the parameterized query.
foreach (var list in contactQuery)
{
var cont = 0;
var nameRoom = db.RoomSet.FirstOrDefault(b => b.Id == list.Room.Id);
//$"Resesrvation {cont.ToString()}";
context.PostAsync("Reservation " + cont.ToString() + "." + "Meeting Room: " + nameRoom +
" Start Date: " + list.StartDate.ToShortDateString() +
" Start Time: " + list.StartTime.ToShortTimeString() +
" End Time: " + list.EndTime.ToShortTimeString() +
" Attendant: " + list.Attendant.ToString() +
"/n/r");
}
}
private static async Task PostMeetingRoomCarousel(IDialogContext context, string typeAction)
{
var db = new Model.EntityModelContainer();
var user = context.Activity.From.Name;
var reply = context.MakeMessage();
var TypeAction = string.Empty;
if (typeAction == "View")
{
TypeAction = ActionTypes.ShowImage;
}
else
{
TypeAction = ActionTypes.PostBack;
}
reply.AttachmentLayout = "carousel";
var contactQuery = from Bookings in db.Bookings
where Bookings.EmplyeeId == user && Bookings.IsCancel == false
select Bookings;
// Iterate through the results of the parameterized query.
foreach (var list in contactQuery)
{
var heroCard = new HeroCard();
heroCard.Buttons = new List <CardAction>
{
new CardAction
{
// Type, title and value are required!
Type = TypeAction,
Title = $"{list.Room.NameRoom} - {list.StartDate.ToShortDateString()} - {list.StartTime.ToShortTimeString()}",
Value = $"{list.Id}",
}
};
heroCard.Title = string.Empty;
heroCard.Images = new List <CardImage>
{
new CardImage
{
Url = GetImageOfMeetingRoom(list.Room.NameRoom)
}
};
reply.Attachments.Add(heroCard.ToAttachment());
}
await context.PostAsync(reply);
}
private async Task SaveChangesfromCancelBooking(IDialogContext context, IAwaitable <string> result)
{
using (var db = new Model.EntityModelContainer())
{
var id = 0;
id = int.Parse(result.GetAwaiter().GetResult());
var itemToRemove = db.Bookings.SingleOrDefault(b => b.Id == id);
itemToRemove.IsCancel = true;
db.SaveChanges();
}
await context.PostAsync("Great....Cancelled Reservation.");
}
private bool CheckBooksforUser(IDialogContext context)
{
var db = new Model.EntityModelContainer();
var id = context.Activity.From.Name;
var message = string.Empty;
var item = db.Bookings.FirstOrDefault(b => b.EmplyeeId == id && b.IsCancel == false);
if (item == null)
{
return(false);
}
else
{
return(true);
}
}
