public bool CreateUser(string firstName, string lastName, string email, string phonenumber, string password) { var query = String.Format(@"Insert into Customers (FirstName, LastName, Email, ContactNbr, Password) Values ('{0}', '{1}', '{2}', '{3}', '{4}'); Select @@Identity as 'Identity'", firstName, lastName, email, phonenumber, password); using (var cmd = new SqlCommand(query, WingtipTicketApp.CreateTenantSqlConnection())) { using (var sdAdapter = new SqlDataAdapter(cmd)) { var dsUser = new DataSet(); sdAdapter.Fill(dsUser); if (dsUser.Tables.Count > 0 && dsUser.Tables[0].Rows.Count > 0) { var newUser = new CustomerModel { FirstName = firstName, LastName = lastName, Email = email, PhoneNumber = phonenumber, CustomerId = Convert.ToInt32(dsUser.Tables[0].Rows[0]["Identity"]) }; Startup.SessionUsers.Add(newUser); HttpContext.Current.Session["SessionUser"] = newUser; LogAction("Added new user - " + firstName + " " + lastName); return true; } } } return false; }
public bool Login(string email, string password) { var query = String.Format(@"Select FirstName, LastName, CustomerId from Customers Where Email='{0}' and Password='******'", email, password); using (var cmd = new SqlCommand(query, WingtipTicketApp.CreateTenantConnectionDatabase1())) { using (var sdAdapter = new SqlDataAdapter(cmd)) { var dsUser = new DataSet(); sdAdapter.Fill(dsUser); if (dsUser.Tables.Count > 0 && dsUser.Tables[0].Rows.Count > 0) { var newUser = new CustomerModel { FirstName = dsUser.Tables[0].Rows[0]["FirstName"].ToString(), LastName = dsUser.Tables[0].Rows[0]["LastName"].ToString(), Email = email, CustomerId = Convert.ToInt32(dsUser.Tables[0].Rows[0]["CustomerId"]) }; HttpContext.Current.Session["SessionUser"] = newUser; if (Startup.SessionUsers.Any(a => a.Email != null && a.Email.ToUpper() == email.ToUpper())) { Startup.SessionUsers.Remove(Startup.SessionUsers.First(a => a.Email.ToUpper() == email.ToUpper())); } Startup.SessionUsers.Add(newUser); return true; } } } return false; }
public CustomerEventsModel GetCustomerEvents(CustomerModel customerModel, int? venueId = null) { var myEventsView = new CustomerEventsModel(); if (customerModel == null) { return myEventsView; } var concertTicketsList = Context.Tickets.ReturnPurchasedTicketsByCustomerId(customerModel.CustomerId); var venuesList = Context.Venues.GetVenues(); var concertsList = new List<ConcertModel>(Context.Concerts.GetConcerts()); var ticketLevelsList = Context.Tickets.GetTicketLevels(); foreach (var ticket in concertTicketsList) { var concert = concertsList.Find(c => c.ConcertId == ticket.ConcertId); var ticketLevel = ticketLevelsList.Find(l => l.TicketLevelId == ticket.TicketLevelId); var tempTicket = new PurchasedTicketModel( concert.PerformerModel.ShortName, concert.ConcertId, venuesList.Find(v => v.VenueId.Equals(concert.VenueId)).VenueName, 1, ticketLevel.Description.Split('-').First().Trim(), ticket.SeatNumber, concert.ConcertDate, ticket.ConcertId, concert.VenueId ); if (myEventsView.PurchasedTickets.Exists(x => x.ConcertId == ticket.ConcertId && x.SectionName == tempTicket.SectionName)) { var index = myEventsView.PurchasedTickets.FindIndex(x => x.ConcertId == ticket.ConcertId && x.SectionName == tempTicket.SectionName); myEventsView.PurchasedTickets[index].TicketQuantity++; myEventsView.PurchasedTickets[index].SeatName += ", " + tempTicket.SeatName; } else if (venueId == null || tempTicket.VenueId == venueId) { myEventsView.PurchasedTickets.Add(tempTicket); if (!myEventsView.MyVenues.Exists(v => v.VenueId == tempTicket.VenueId)) { var venue = venuesList.Find(v => v.VenueId.Equals(concert.VenueId)); myEventsView.MyVenues.Add(new VenueModel() { VenueId = venue.VenueId, VenueName = venue.VenueName, Capacity = venue.Capacity }); } } } // Sort all events by date if (myEventsView.PurchasedTickets != null && myEventsView.PurchasedTickets.Count > 0) { myEventsView.PurchasedTickets.Sort((a, b) => a.EventDateTime.CompareTo(b.EventDateTime)); } return myEventsView; }