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