public EventInfo GetRequestInfo(Guid id)
{
EventInfo evt = new EventInfo();
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var eventPartTwo = db.EventRequests.Where(x => x.Id == id).FirstOrDefault();
evt.Id = Guid.NewGuid();
evt.EventRequestID = id;
evt.ContactFirstName = eventPartTwo.ContactFirstName;
evt.ContactLastName = eventPartTwo.ContactLastName;
evt.ContactPhone = eventPartTwo.ContactPhone;
// evt.EventTitle = eventPartOne.EventTitle;
evt.NumberOfGuests = eventPartTwo.NumberOfGuests.Value;
evt.EventDescription = eventPartTwo.EventDescription;
evt.ContactEmail = eventPartTwo.ContactEmail;
evt.StartDate = DateTime.Parse(eventPartTwo.RequestedTime);
evt.EndDate = DateTime.Parse(eventPartTwo.RequestedTime);
// evt.StartDate = eventPartOne.StartDate.Value;
//evt.EndDate = eventPartOne.EndDate.Value;
// evt.IsPublic = eventPartOne.IsPublic.Value;
return(evt);
}
}
public void UpdateEvent(EventInfo evt)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var eventPartOne = db.Events.Where(x => x.Id == evt.Id).FirstOrDefault();
var eventPartTwo = db.EventRequests.Where(x => x.ApprovedEventId == evt.Id).FirstOrDefault();
eventPartOne.BookedBy = string.Format("{0} {1}", evt.ContactFirstName, evt.ContactLastName);
eventPartOne.IsPublic = evt.IsPublic;
eventPartOne.EventTitle = evt.EventTitle;
eventPartOne.EventDescription = evt.EventDescription;
eventPartOne.StartDate = evt.StartDate;
eventPartOne.EndDate = evt.EndDate;
eventPartTwo.RequestedTime = evt.StartDate.ToString();
eventPartTwo.ContactEmail = evt.ContactEmail;
eventPartTwo.ContactFirstName = evt.ContactFirstName;
eventPartTwo.ContactLastName = evt.ContactLastName;
eventPartTwo.ContactPhone = evt.ContactPhone;
eventPartTwo.EventDescription = evt.EventDescription;
eventPartTwo.NumberOfGuests = evt.NumberOfGuests;
db.SaveChanges();
}
}
public void CancelTeeTime(Guid id)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var removeTime = db.TeeTimes.Where(x => x.Id == id).FirstOrDefault();
db.TeeTimes.Remove(removeTime);
db.SaveChanges();
}
}
public void RemoveEventRequest(Guid id)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var badRequest = db.EventRequests.Where(x => x.Id == id).FirstOrDefault();
db.EventRequests.Remove(badRequest);
db.SaveChanges();
}
}
public void RemoveShopItem(Guid id)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var remove = db.ShopItems.Where(x => x.Id == id).FirstOrDefault();
db.ShopItems.Remove(remove);
db.SaveChanges();
}
}
public MgmtDailyPortal AdminPortalDisplay()
{
MgmtDailyPortal portal = new MgmtDailyPortal();
DateTime today = DateTime.Today;
portal.TodaysDate = today;
DateTime buffer = DateTime.Today.AddDays(1);
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
portal.TeeTimes = db.TeeTimes.Where(x => x.ScheduleTime >= today && x.ScheduleTime < buffer).Select(x => new TeeTimesPerSlot {
Id = x.Id,
ScheduleTime = x.ScheduleTime.Value,
Paid = x.Paid.Value,
BookedBy = x.BookedBy,
NumberOfPlayers = x.NumberOfPlayers.Value,
Member = x.Member.Value,
Cart = x.Cart.Value,
Created = x.Created.Value
}).ToList();
portal.TeeTimesCount = portal.TeeTimes.Count();
portal.Events = db.Events.Where(x => x.StartDate >= today && x.StartDate < buffer).Select(x => new CalendarEvent
{
Id = x.Id,
StartDate = x.StartDate.Value,
EndDate = x.EndDate.Value,
IsPublic = x.IsPublic.Value,
EventTitle = x.EventTitle,
EventDiscription = x.EventDescription,
BookedBy = x.BookedBy,
Created = x.Created.Value
}).ToList();
portal.ShopItems = db.ShopItems.Select(x => new entites.ShopItem
{
Id = x.Id,
Title = x.Title,
Description = x.Description,
ImageURL = x.ImageURL,
Price = (double)x.Price,
InStock = x.InStock.Value
}).ToList();
portal.EventRequests = db.EventRequests.Where(x => x.Approved == false).ToList();
portal.EventsCount = portal.Events.Count();
portal.Users = db.AspNetUsers.ToList();
}
return(portal);
}
public void RemoveUser(Guid id)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var user = db.AspNetUsers.Where(x => x.Id == id.ToString()).FirstOrDefault();
if (user != null)
{
db.AspNetUsers.Remove(user);
db.SaveChanges();
}
}
}
public void UpdateShopItem(entites.ShopItem item)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var current = db.ShopItems.Where(x => x.Id == item.Id).FirstOrDefault();
current.Title = item.Title;
current.Price = (decimal)item.Price;
current.ImageURL = item.ImageURL;
current.InStock = item.InStock;
current.Description = item.Description;
db.SaveChanges();
}
}
public void EmailAddition(string email)
{
if (!string.IsNullOrEmpty(email))
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
MailingList ml = new MailingList();
ml.Id = Guid.NewGuid();
ml.EmailAddress = email;
db.MailingLists.Add(ml);
db.SaveChanges();
}
}
}
public void AddShopItem(entites.ShopItem item)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
ShopItem adding = new ShopItem();
adding.Id = Guid.NewGuid();
adding.Title = item.Title;
adding.Description = item.Description;
adding.ImageURL = item.ImageURL;
adding.Price = (decimal)item.Price;
adding.InStock = item.InStock;
db.ShopItems.Add(adding);
db.SaveChanges();
}
}
public entites.ShopItem FindShopItem(Guid id)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
entites.ShopItem item = db.ShopItems.Where(x => x.Id == id).Select(x => new entites.ShopItem {
Id = x.Id,
Title = x.Title,
Description = x.Description,
ImageURL = x.ImageURL,
Price = (double)x.Price,
InStock = x.InStock.Value
}).FirstOrDefault();
return(item);
}
}
public List <entites.ShopItem> GetListOfCurrentShopItems()
{
List <entites.ShopItem> items = new List <entites.ShopItem>();
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
items = db.ShopItems.Select(x => new entites.ShopItem {
Id = x.Id,
Title = x.Title,
Description = x.Description,
ImageURL = x.ImageURL,
Price = (double)x.Price,
InStock = x.InStock.Value
}).ToList();
}
return(items);
}
public void RemoveEvent(Guid id)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var eventPartOne = db.Events.Where(x => x.Id == id).FirstOrDefault();
var eventPartTwo = db.EventRequests.Where(x => x.ApprovedEventId == id).FirstOrDefault();
if (eventPartOne != null)
{
db.Events.Remove(eventPartOne);
}
if (eventPartTwo != null)
{
db.EventRequests.Remove(eventPartTwo);
}
db.SaveChanges();
}
}
public void BookTeeTime(TeeTimeBooking teetime)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
TeeTime tt = new TeeTime();
tt.BookedBy = teetime.BookedBy;
tt.Cart = teetime.Cart;
tt.Id = Guid.NewGuid();
tt.Member = teetime.Member;
tt.NumberOfPlayers = teetime.NumberOfPlayers;
tt.Paid = false;
tt.ScheduleTime = teetime.ScheduledTime;
tt.Created = DateTime.Now;
db.TeeTimes.Add(tt);
db.SaveChanges();
}
}
public void SendEventRequest(SqualCreekBusinessLayer.entites.SubmitedEventRequest ser)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
EventRequest evReq = new EventRequest();
evReq.Id = Guid.NewGuid();
evReq.RequestedTime = ser.RequestedTime.ToString();
evReq.EventDescription = ser.EventDescription;
evReq.NumberOfGuests = ser.NumberOfGuests;
evReq.ContactFirstName = ser.ContactFirstName;
evReq.ContactLastName = ser.ContactLastName;
evReq.ContactEmail = ser.ContactEmail;
evReq.ContactPhone = ser.ContactPhone;
evReq.Budget = ser.Budget;
evReq.Approved = false;
db.EventRequests.Add(evReq);
db.SaveChanges();
}
}
public Cart SaveOrder(Cart cart)
{
Order order = new Order();
UserAddress userAddress = new UserAddress();
userAddress.Id = Guid.NewGuid();
userAddress.Street = cart.Address.Street;
userAddress.City = cart.Address.City;
userAddress.State = cart.Address.State;
userAddress.ZipCode = cart.Address.ZipCode;
//there is no user id saved yet
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
db.UserAddresses.Add(userAddress);
db.SaveChanges();
order.Id = Guid.NewGuid();
cart.OrderConfirmationId = order.Id;
order.Created = DateTime.Now;
order.MemberID = null;
order.Pickup = cart.PickUp;
order.MailTo = cart.MailTo;
order.AddressId = userAddress.Id;
order.CustomersName = cart.CustomersName;
db.Orders.Add(order);
foreach (var li in cart.LineItems)
{
OrderItem oi = new OrderItem();
oi.Id = Guid.NewGuid();
oi.OrderId = order.Id;
oi.ShopItemId = li.ShopItemId;
oi.Qty = li.Qty;
oi.Price = (decimal)li.Price;
db.OrderItems.Add(oi);
db.SaveChanges();
}
}
return(cart);
}
public void ScheduleEvent(EventInfo evt)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
SqualCreekBusinessLayer.Event evtSave = new SqualCreekBusinessLayer.Event();
evtSave.BookedBy = string.Format("{0} {1}", evt.ContactFirstName, evt.ContactLastName);
evtSave.Id = Guid.NewGuid();
evtSave.IsPublic = evt.IsPublic;
evtSave.EventTitle = evt.EventTitle;
evtSave.EventDescription = evt.EventDescription;
evtSave.StartDate = evt.StartDate;
evtSave.EndDate = evt.EndDate;
evtSave.Created = DateTime.Now;
db.Events.Add(evtSave);
db.SaveChanges();
if (db.EventRequests.Where(x => x.Id == evt.EventRequestID).Any())
{
var currentRequest = db.EventRequests.Where(x => x.Id == evt.EventRequestID).FirstOrDefault();
currentRequest.Approved = true;
currentRequest.ApprovedEventId = evtSave.Id;
db.SaveChanges();
}
else
{
EventRequest evtRequest = new EventRequest();
evtRequest.Approved = true;
evtRequest.Budget = 999;
evtRequest.RequestedTime = evt.StartDate.ToString();
evtRequest.ContactEmail = evt.ContactEmail;
evtRequest.ContactFirstName = evt.ContactFirstName;
evtRequest.ContactLastName = evt.ContactLastName;
evtRequest.ContactPhone = evt.ContactPhone;
evtRequest.EventDescription = evt.EventDescription;
evtRequest.NumberOfGuests = evt.NumberOfGuests;
evtRequest.Id = Guid.NewGuid();
evtRequest.ApprovedEventId = evtSave.Id;
db.EventRequests.Add(evtRequest);
db.SaveChanges();
}
}
}
public string CalenderPopulationPublic()
{
string json = "";
JArray data = new JArray();
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
DateTime searchStart = DateTime.Now.AddDays(-30);
List <CalendarEvent> events = new List <CalendarEvent>();
events = db.Events.Where(x => x.StartDate >= searchStart).Select(x => new CalendarEvent {
Id = x.Id,
StartDate = x.StartDate.Value,
EndDate = x.EndDate.Value,
IsPublic = x.IsPublic.Value,
EventTitle = x.EventTitle,
EventDiscription = x.EventDescription,
BookedBy = x.BookedBy,
Created = x.Created.Value
}).ToList();
foreach (CalendarEvent singleEvent in events)
{
JObject single = new JObject(new JProperty("title", singleEvent.EventTitle),
new JProperty("start", singleEvent.StartDate.ToString()),
new JProperty("end", singleEvent.EndDate.ToString())
);
data.Add(single);
}
}
json = data.ToString();
return(json);
}
public EventInfo EditEvent(Guid id)
{
EventInfo evt = new EventInfo();
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var eventPartOne = db.Events.Where(x => x.Id == id).FirstOrDefault();
var eventPartTwo = db.EventRequests.Where(x => x.ApprovedEventId == id).FirstOrDefault();
evt.Id = id;
evt.ContactFirstName = eventPartTwo.ContactFirstName;
evt.ContactLastName = eventPartTwo.ContactLastName;
evt.ContactPhone = eventPartTwo.ContactPhone;
evt.EventTitle = eventPartOne.EventTitle;
evt.NumberOfGuests = eventPartTwo.NumberOfGuests.Value;
evt.EventDescription = eventPartTwo.EventDescription;
evt.ContactEmail = eventPartTwo.ContactEmail;
evt.StartDate = eventPartOne.StartDate.Value;
evt.EndDate = eventPartOne.EndDate.Value;
evt.IsPublic = eventPartOne.IsPublic.Value;
return(evt);
}
}
public async Task <TeeTimesForDay> DailyTeeTimes(DateTime selected)
{
TeeTimesForDay ttd = new TeeTimesForDay();
List <TeeTimesPerSlot> ttpsList = new List <TeeTimesPerSlot>();
ttd.CurrentDate = selected;
DateTime holder = new DateTime();
//loop to create slots
for (int i = 0; i < 25; i++)
{
TimeSpan slotTime;
if (i < 1)
{
TeeTimesPerSlot ttps = new TeeTimesPerSlot();
slotTime = new TimeSpan(7, 0, 0);
ttps.ScheduleTime = selected.Date + slotTime;
holder = ttps.ScheduleTime;
ttps.Id = Guid.Empty;
ttps.Paid = false;
ttps.BookedBy = string.Empty;
ttps.Created = DateTime.Now;
ttps.NumberOfPlayers = 1;
ttps.Member = false;
ttps.Cart = false;
ttpsList.Add(ttps);
}
else
{
TeeTimesPerSlot ttps = new TeeTimesPerSlot();
holder = holder.AddMinutes(30);
ttps.ScheduleTime = holder;
holder = ttps.ScheduleTime;
ttps.Id = Guid.Empty;
ttps.Paid = false;
ttps.BookedBy = string.Empty;
ttps.Created = DateTime.Now;
ttps.NumberOfPlayers = 1;
ttps.Member = false;
ttps.Cart = false;
ttpsList.Add(ttps);
}
}
//now you need to loop through and see what slots are taken
List <TeeTimesPerSlot> FinalPull = new List <TeeTimesPerSlot>();
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
foreach (TeeTimesPerSlot slot in ttpsList)
{
if (db.TeeTimes.Any(x => x.ScheduleTime.ToString() == slot.ScheduleTime.ToString()))
{
var item = db.TeeTimes.Where(x => x.ScheduleTime == slot.ScheduleTime).Select(x => new TeeTimesPerSlot
{
ScheduleTime = x.ScheduleTime.Value,
Id = x.Id,
Paid = x.Paid.Value,
BookedBy = x.BookedBy,
Created = x.Created.Value,
NumberOfPlayers = x.NumberOfPlayers.Value,
Member = x.Member.Value,
Cart = x.Cart.Value
}).FirstOrDefault();
FinalPull.Add(item);
}
else
{
FinalPull.Add(slot);
}
}
}
ttd.SelectableTimes = GatherDates(DateTime.Now);
ttd.TeeTimesBySlot = FinalPull;
return(ttd);
}
