public bool RegisterUser(RegisterVM reg)
{
var success = false;
using (var db = new ManagementToolProjectEntities())
{
bool emailExist = db.Users.FirstOrDefault(u => u.EmailAddress == reg.Email) != null;
if (!emailExist)
{
var regUser = new User
{
EmailAddress = reg.Email.Trim().ToLower(),
FirstName = reg.FirstName,
LastName = reg.LastName,
Password = reg.Password,
status = true
};
db.Users.Add(regUser);
success = db.SaveChanges() > 0;
}
}
return(success);
}
public void AddPerformanceOrder(int orderId)
{
var success = false;
var mediator = new TicketMediator();
var cart = mediator.GetCart();
using (var db = new ManagementToolProjectEntities())
{
foreach (var perf in cart.Performances)
{
var perfOrder = new OrderPerformanceMapping2
{
OderId = orderId,
PerformanceId = perf.PerformanceId,
Quantity = perf.Quantity
};
db.OrderPerformanceMapping2.Add(perfOrder);
success = db.SaveChanges() > 0;
if (success)
{
var performance = mediator.GetPerformance(perf.PerformanceId);
performance.AvailableTickets = performance.AvailableTickets - perf.Quantity;
success = mediator.UpdatePerformance(performance);
}
}
}
}
public bool CreateOrder(PaymentVM payment)
{
var success = false;
var mediator = new TicketMediator();
var cart = mediator.GetCart();
foreach (var perf in cart.Performances)
{
var performance = mediator.GetPerformance(perf.PerformanceId);
if (performance.AvailableTickets - perf.Quantity >= 0)
{
success = true;
if (!success)
{
break;
}
}
}
if (success)
{
using (var db = new ManagementToolProjectEntities())
{
var date = payment.ExpirationMonth + "/1/" + payment.ExpirationYear;
var expiry = DateTime.Parse(date);
var orderModel = new Order
{
FirstName = payment.FirstName,
LastName = payment.LastName,
BillingAdress = payment.BillingAddress.Address1,
BillingCity = payment.BillingAddress.City,
BillingState = payment.BillingAddress.State,
BillingZipCode = Convert.ToInt32(payment.BillingAddress.Zip),
ShippingAdress = payment.ShippingAddress.Address1,
ShippingCity = payment.ShippingAddress.City,
ShippingState = payment.ShippingAddress.State,
ShippingZipCode = Convert.ToInt32(payment.ShippingAddress.Zip),
ExpirationDate = expiry,
CreditCard = payment.CreditCardNumber,
status = 1
};
var order = db.Orders.Add(orderModel);
success = db.SaveChanges() > 0;
if (success)
{
AddPerformanceOrder(order.OrderId);
}
}
}
return(success);
}
public bool UpdatePerformance(PerformanceVM model)
{
var success = false;
using (var db = new ManagementToolProjectEntities())
{
var resp = new PerformanceRepository(db);
Performance perf = resp.GetFirstOrDefault(p => p.PerformanceId == model.PerformanceId);
perf.Date = DateTime.Parse(model.PerformanceDate);
perf.Price = model.Price;
perf.status = model.Cancelled;
perf.TotalTickets = model.AvailableTickets;
perf.EventId = model.EventId;
resp.Update(perf);
success = db.SaveChanges() > 0;
}
return(success);
}
public bool UpdateEvent(EventVM model)
{
var success = false;
using (var db = new ManagementToolProjectEntities())
{
var resp = new EventRepository(db);
Event dbEvent = db.Events.FirstOrDefault(e => e.EventId == model.Id);
dbEvent.Description = model.Description;
dbEvent.Image = model.Image;
dbEvent.Location = model.Location;
dbEvent.Name = model.Name;
dbEvent.status = Convert.ToInt32(model.Active);
resp.Update(dbEvent);
success = db.SaveChanges() > 0;
}
return(success);
}
public bool CreateEvent(EventVM model)
{
var success = false;
using (var db = new ManagementToolProjectEntities())
{
var eventModel = new Event
{
Name = model.Name,
Description = model.Description,
Location = model.Location,
Image = model.Image,
status = Convert.ToInt32(model.Active),
EventTypeId = model.Category
};
db.Events.Add(eventModel);
success = db.SaveChanges() > 0;
}
return(success);
}
public bool CreatePerformance(PerformanceVM model)
{
var success = false;
using (var db = new ManagementToolProjectEntities())
{
var resp = new PerformanceRepository(db);
var perf = new Performance
{
Date = DateTime.Parse(model.PerformanceDate),
EventId = model.EventId,
Price = model.Price,
status = model.Cancelled,
TotalTickets = model.AvailableTickets
};
resp.Insert(perf);
success = db.SaveChanges() > 0;
}
return(success);
}
