public SuccessfulCustomerTicketPurchaseViewModel()
{
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
//Assign the database context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Get the ticket Id's and split them into an array
string guestTicketId = Settings.Default.customerTicketId;
String[] separator = { "," };
string[] guestTicketList = guestTicketId.Split(separator, StringSplitOptions.RemoveEmptyEntries);
//For each value in guest ticket list add them to the data source
foreach (var ticketId in guestTicketList)
{
var rowData = (from data in context.Customer_Ticket_Details where data.ticketId.ToString().Contains(ticketId) && data.email.Contains(Settings.Default.Email) select data).ToList();
foreach (var customerTicketDetails in rowData)
{
CustomerTicketDetails.Add(customerTicketDetails);
}
}
//Display guest transaction according to the guest transaction id
CustomerTransactionsDetails = (from data in context.Customer_Transaction
where data.transactionId.ToString().Contains(Settings.Default.customerTransactionId)
select data).ToList();
}
/// <summary>
/// Constructor for the class containing initialization, declaration
/// and commands for the class
/// </summary>
public DefaultViewModel()
{
#region Initialization of user controls
registerViewModel = new RegisterViewModel();
viewEventsViewModel = new ViewEventsViewModel();
signInViewModel = new SignInViewModel();
searchEventViewModel = new SearchEventViewModel();
#endregion
#region Declaration of the events list for the tile views
//Using db context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Create a list of events
Events = (from data in context.Event_Details select data).ToList();
#endregion
#region Commands arguments
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
NavigateSearchCommand = new RelayCommand <NavigationViewModelBase>(Nav2);
NavigateTicketDetailsCommand = new RelayCommand <NavigationViewModelBase>(Nav3);
#endregion
}
public SuccessfulTicketsViewModel()
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
TicketList = (from data in context.Ticket_Details select data).ToList();
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
}
public AddEmployeeViewModel()
{
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
EmployeeDetails = (from data in context.Employee_Details select data).ToList();
}
public void SfDataGrid1_RowValidating(object sender, Syncfusion.UI.Xaml.Grid.RowValidatingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Customer_Details newRecord = args.RowData as Customer_Details;
Customer_Details currentCustomer = new Customer_Details();
if (newRecord != null)
{
currentCustomer.customerID = newRecord.customerID;
currentCustomer.email = newRecord.email;
currentCustomer.password = newRecord.password;
currentCustomer.firstName = newRecord.firstName;
currentCustomer.lastName = newRecord.lastName;
currentCustomer.address = newRecord.address;
currentCustomer.phoneNumber = newRecord.phoneNumber;
currentCustomer.city = newRecord.city;
currentCustomer.state = newRecord.state;
currentCustomer.postcode = newRecord.postcode;
currentCustomer.dateOfBirth = newRecord.dateOfBirth;
currentCustomer.dateCreated = newRecord.dateCreated;
}
using (context)
{
context.Customer_Details.Add(currentCustomer);
context.SaveChanges();
context.Dispose();
}
}
public async Task <HttpResponseMessage> AddCustomer(Customers addedCustomer)
{
int lastId = dbContext.Customers.Select(x => x).OrderByDescending(x => x.customer_id).First().customer_id;
addedCustomer.customer_id = lastId + 1;
try
{
using (var context = new CustomerDatabaseEntities())
{
context.Customers.Add(addedCustomer);
await context.SaveChangesAsync();
res.StatusCode = HttpStatusCode.Created;
res.Content = new StringContent(JsonConvert.SerializeObject(addedCustomer));
res.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
return(res);
}
}
catch (Exception e)
{
res.StatusCode = HttpStatusCode.BadRequest;
res.Content = new StringContent(e.ToString());
return(res);
}
}
/// <summary>
/// Saves changes to the database
/// </summary>
/// <returns>Boolean value</returns>
private bool SaveCustomerChanges()
{
//Assign a context value
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Set the initial value to false
bool output = false;
//Assigns the value of the helper class to the class
bool isNull = ArePropertiesNotNull(CurrentCustomer);
//Checks if helper class returns true or false
if (isNull)
{
CurrentCustomer.email = Email.Trim();
CurrentCustomer.password = Password.Trim();
CurrentCustomer.firstName = FirstName.Trim();
CurrentCustomer.lastName = LastName.Trim();
CurrentCustomer.phoneNumber = PhoneNumber;
CurrentCustomer.address = Address.Trim();
CurrentCustomer.city = City.Trim();
CurrentCustomer.state = State.Trim();
CurrentCustomer.postcode = Postcode;
CurrentCustomer.dateOfBirth = DateOfBirth;
CurrentCustomer.dateCreated = DateTime.Now;
context.Customer_Details.Add(CurrentCustomer);
context.SaveChanges();
output = true;
return(output);
}
return(output);
}
/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Customer_Details newRecord = args.RowData as Customer_Details;
if (sender == null)
{
return;
}
Customer_Details order = context.Customer_Details.First(i => i.customerID == newRecord.customerID);
if (newRecord != null)
{
order.customerID = newRecord.customerID;
order.email = newRecord.email;
order.password = newRecord.password;
order.firstName = newRecord.firstName;
order.lastName = newRecord.lastName;
order.address = newRecord.address;
order.city = newRecord.city;
order.state = newRecord.state;
order.postcode = newRecord.postcode;
order.dateOfBirth = newRecord.dateOfBirth;
order.dateCreated = newRecord.dateCreated;
}
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Constructor for view model
/// </summary>
public CustomerPurchaseTicketViewModel()
{
#region Command parameter
//Default command
NavDefaultCommand = new RelayCommand <NavigationViewModelBase>(Nav);
//Successful command
NavSuccessCommand = new RelayCommand <NavigationViewModelBase>(Nav2);
#endregion
//Set the database context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Tickets list
Tickets = (from data in context.Ticket_Details select data).ToList();
//Create a ticket list with the selected seats
string seatLocations = Settings.Default.SeatLocation;
String[] separator = { "," };
String[] strList = seatLocations.Split(separator, StringSplitOptions.RemoveEmptyEntries);
foreach (var seatLocation in strList)
{
var item = Tickets.FindAll(i => i.seatLocation == seatLocation && i.eventTitle == Settings.Default.EventTitle);
foreach (var ticketDetails in item)
{
ListOfMatchingTickets.Add(ticketDetails);
}
}
}
public async Task <HttpResponseMessage> AddAddress(Addresses addedAddress)
{
int lastId = dbContext.Addresses.Select(x => x).OrderByDescending(x => x.address_id).First().address_id;
int customerId = dbContext.Customers.Single(c => addedAddress.customer.first_name == c.first_name && addedAddress.customer.last_name == c.last_name).customer_id;
addedAddress.address_id = lastId + 1;
addedAddress.customer_id = customerId;
addedAddress.customer = null;
if (addedAddress.customer_id == null)
{
res.StatusCode = HttpStatusCode.BadRequest;
res.Content = new StringContent("This customer does not exist.");
return(res);
}
try
{
using (CustomerDatabaseEntities context = new CustomerDatabaseEntities())
{
context.Addresses.Add(addedAddress);
await context.SaveChangesAsync();
return(new HttpResponseMessage(HttpStatusCode.Created));
}
}
catch (Exception e)
{
res.StatusCode = HttpStatusCode.BadRequest;
res.Content = new StringContent(e.Message);
return(res);
}
}
public MoreDataViewModel()
{
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
CustomerTicket = (from data in context.Customer_Ticket_Details select data).ToList();
}
/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidatedForCustomerTransactions(object sender, RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Guest_Transaction newRecord = args.RowData as Guest_Transaction;
if (sender == null)
{
return;
}
Guest_Transaction order = context.Guest_Transaction.First(i => i.transactionId == newRecord.transactionId);
if (newRecord != null)
{
order.transactionId = newRecord.transactionId;
order.email = newRecord.email;
order.eventAddress = newRecord.eventAddress;
order.fullName = newRecord.fullName;
order.eventName = newRecord.eventName;
order.totalPrice = newRecord.totalPrice;
order.address = newRecord.address;
}
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidatedForCustomerTickets(object sender, RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Customer_Ticket_Details newRecord = args.RowData as Customer_Ticket_Details;
if (sender == null)
{
return;
}
Guest_Ticket_Details order = context.Guest_Ticket_Details.First(i => i.ticketId == newRecord.ticketId);
if (newRecord != null)
{
order.ticketId = newRecord.ticketId;
order.email = newRecord.email;
order.eventAddress = newRecord.eventAddress;
order.fullName = newRecord.fullName;
order.eventName = newRecord.eventName;
order.placeName = newRecord.placeName;
order.price = newRecord.price;
order.seatLocation = newRecord.seatLocation;
order.timeEnd = newRecord.timeEnd;
order.timeStart = newRecord.timeStart;
}
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
context.Dispose();
}
public async Task <HttpResponseMessage> DeleteCustomer(int id)
{
try
{
using (var context = new CustomerDatabaseEntities())
{
Customers customer = context.Customers.Single(x => x.customer_id == id);
List <Addresses> addresses = context.Addresses.Where(a => a.customer_id == customer.customer_id).ToList();
context.Customers.Remove(customer);
context.Addresses.RemoveRange(addresses);
await context.SaveChangesAsync();
return(new HttpResponseMessage(HttpStatusCode.OK));
}
}
catch (Exception e)
{
res.StatusCode = HttpStatusCode.BadRequest;
res.Content = new StringContent(e.ToString());
return(res);
}
}
public object NewCustomer(MusteriViewModel model)
{
try
{
var db = new CustomerDatabaseEntities();
db.Customers.Add(new Customer()
{
AdSoyad = model.AdSoyad,
Cinsiyet = model.Cinsiyet,
Adres = model.Adres,
DogumTarihi = model.DogumTarihi,
YasadigiSehir = model.YasadigiSehir,
Email = model.Email,
Meslek = model.Meslek,
Telefon = model.Tel,
ReklamMaili = model.ReklamMaili,
WebSite = model.WebSite,
Notlar = model.Notlar
});
db.SaveChanges();
return(new
{
success = true
});
}
catch (Exception ex)
{
return(new
{
success = false,
message = ex.Message
});
}
}
public object UpdateCustomer(MusteriViewModel model)
{
try
{
var db = new CustomerDatabaseEntities();
var cus = db.Customers.Find(model.Id);
cus.AdSoyad = model.AdSoyad;
cus.Cinsiyet = model.Cinsiyet;
cus.DogumTarihi = model.DogumTarihi;
cus.YasadigiSehir = model.YasadigiSehir;
cus.Email = model.Email;
cus.Meslek = model.Meslek;
cus.Telefon = model.Tel;
cus.ReklamMaili = model.ReklamMaili;
cus.WebSite = model.WebSite;
cus.Notlar = model.Notlar;
db.SaveChanges();
return(new
{
success = true
});
}
catch (Exception ex)
{
return(new
{
success = false,
message = ex.Message
});
}
}
public object GetAllCustomer()
{
try
{
var db = new CustomerDatabaseEntities();
var model = db.Customers.ToList().OrderBy(x => x.AdSoyad).Select(x => new MusteriViewModel
{
Id = x.Id,
AdSoyad = x.AdSoyad,
Cinsiyet = x.Cinsiyet,
Meslek = x.Meslek,
DogumTarihi = x.DogumTarihi,
Email = x.Email,
WebSite = x.WebSite,
ReklamMaili = x.ReklamMaili,
Adres = x.Adres,
YasadigiSehir = x.YasadigiSehir,
Tel = x.Telefon,
Notlar = x.Notlar
});
return(new
{
success = true,
data = model
});
}
catch (Exception ex)
{
return(new
{
success = false,
message = ex.Message
});
}
}
/// <summary>
/// Constructor
/// </summary>
public ViewPastTicketsViewModel()
{
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Set the lists according to the properties
CustomerTransactions = (from data in context.Customer_Transaction where data.email.Contains(Settings.Default.Email) select data).ToList();
CustomerTicketDetails = (from data in context.Customer_Ticket_Details where data.email.Contains(Settings.Default.Email) select data).ToList();
}
public LocationViewModel()
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Location = new List <Location_Details>(context.Location_Details);
//Setting this line to whatever index of the list
// is appears to show the right details
//SelectedItems = Location[5];
}
/// <summary>
/// A function which loads the image
/// of the layout of the location
/// </summary>
/// <returns></returns>
public byte[] LoadImageOfLocation()
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Event = (from data in context.Event_Details select data).ToList();
var selectedEvent = Event.Find(x => x.eventTitle == Settings.Default.EventTitle);
byte[] selectedImage = selectedEvent.eventPicture;
return(selectedImage);
}
public ModifyCustomerDetailsViewModel()
{
//Command parameter
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
//List generation
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
CustomerDetails = (from data in context.Customer_Details select data).ToList();
}
public AddCustomerDetailsViewModel()
{
//Command parameters
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
//Creating the list of customers
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
CustomerDetails = (from data in context.Customer_Details select data).ToList();
}
/// <summary>
/// Constructor for the page
/// </summary>
public ModifyEventsViewModel()
{
//Set the data base context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Navigate to the respective page
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
//Generate a list of events from context
EventList = (from data in context.Event_Details select data).ToList();
}
static void Main(string[] args)
{
using (CustomerDatabaseEntities customerContext = new CustomerDatabaseEntities())
{
var customers = customerContext.Customers.Select(x => x);
foreach (Customer customer in customers)
{
Console.WriteLine(customer.CustomerFirstName + " " + customer.CustomerLastName);
}
}
}
public ModifyGuestTicketsViewModel()
{
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
#region Lists with data context
GuestTransactionsDetails = (from data in context.Guest_Transaction select data).ToList();
GuestTicketDetails = (from data in context.Guest_Ticket_Details select data).ToList();
#endregion
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeleting(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Employee_Details;
var id = item.employeeID;
var email = item.email;
var password = item.password;
var firstName = item.firstName;
var lastName = item.lastName;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeleting(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Ticket_Details;
var id = item.ticketId;
var title = item.eventTitle;
var start = item.eventStart;
var end = item.eventEnd;
var price = item.price;
var seatLocation = item.seatLocation;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
public ViewEventsViewModel()
{
//Initialization of the next view model
buyingTicketsViewModel = new PurchaseTicketsViewModel();
//Setting the data context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Setting the navigation command parameters
NavCommand = new RelayCommand <NavigationViewModelBase>(Nav);
NavCommand2 = new RelayCommand <NavigationViewModelBase>(Nav2);
//Provide an item source for the data grid
Tickets = (from data in context.Ticket_Details where data.eventTitle == Settings.Default.EventTitle select data).ToList();
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeletingForCustomerTransactions(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Customer_Transaction;
var transactionId = item.transactionId;
var email = item.email;
var eventAddress = item.eventAddress;
var fullname = item.fullname;
var eventName = item.eventName;
var totalPrice = item.totalPrice;
var address = item.address;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// A function which attempts to save values to the database
/// </summary>
/// <returns>Boolean values</returns>
private bool SaveCustomerChanges()
{
//Initialization of bool
bool output = false;
//Assigns the value of the helper class to the class
bool isNull = ArePropertiesNotNull(CurrentEvent);
//Assign a context value
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//If the check for not null is not true
if (!isNull)
{
//Using the helper function which converts the image to bytes
byte[] imageBytes = ConvertImageToByteArray(ImagePathOfEventImage);
byte[] imageBytes2 = ConvertImageToByteArray(ImagePathOfEventLayout);
#region Saving to the database
CurrentEvent.eventPicture = imageBytes;
CurrentEvent.eventLayout = imageBytes2;
CurrentEvent.eventGenre = EventGenre.Trim();
CurrentEvent.eventTitle = EventTitle.Trim();
CurrentEvent.showOnHomePage = ShowOnHomePage.Value;
CurrentEvent.eventDescription = EventDescription.Trim();
CurrentEvent.eventStart = EventStart;
CurrentEvent.eventEnd = EventEnd;
CurrentEvent.capacity = Capacity;
CurrentEvent.eventLocation = EventLocation.Trim();
CurrentEvent.eventAddress = EventAddress.Trim();
context.Event_Details.Add(CurrentEvent);
//Save changes to the database
context.SaveChanges();
context.Dispose();
#endregion
//Return true if this function succeeds
output = true;
return(output);
}
//Otherwise return false
return(output);
}
