/// <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();
}
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();
}
}
/// <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();
}
/// <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();
}
/// <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);
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeletingForTickets(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Guest_Ticket_Details;
var ticketId = item.ticketId;
var email = item.email;
var eventAddress = item.eventAddress;
var fullName = item.fullName;
var eventName = item.eventName;
var placeName = item.placeName;
var price = item.price;
var seatLocation = item.seatLocation;
var timeEnd = item.timeEnd;
var timeStart = item.timeStart;
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 Event_Details;
var id = item.eventID;
var address = item.eventAddress;
var description = item.eventDescription;
var capacity = item.capacity;
var eventStart = item.eventStart;
var eventEnd = item.eventEnd;
var eventPic = item.eventPicture;
var eventTitle = item.eventTitle;
var eventGenre = item.eventGenre;
var showOnHomePage = item.showOnHomePage;
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 Customer_Details;
var id = item.customerID;
var email = item.email;
var password = item.password;
var firstName = item.firstName;
var lastName = item.lastName;
var address = item.address;
var city = item.city;
var state = item.state;
var postcode = item.postcode;
var dateOfBirth = item.dateOfBirth;
var dateCreated = item.dateCreated;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
public void SfDataGrid1_RowValidating(object sender, Syncfusion.UI.Xaml.Grid.RowValidatingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Employee_Details newRecord = args.RowData as Employee_Details;
Employee_Details currentEmployee = new Employee_Details();
if (newRecord != null)
{
currentEmployee.employeeID = newRecord.employeeID;
currentEmployee.email = newRecord.email;
currentEmployee.password = newRecord.password;
currentEmployee.firstName = newRecord.firstName;
currentEmployee.lastName = newRecord.lastName;
}
using (context)
{
context.Employee_Details.Add(currentEmployee);
context.SaveChanges();
context.Dispose();
}
}
/// <summary>
/// A function which returns a boolean
/// value if the generation of tickets
/// is correct
/// </summary>
/// <returns>Boolean value</returns>
private bool SaveChanges()
{
//Gets a value for the number of tickets
int numberOfTickets = LevelOneCapacity;
//Set the initial value to false
bool output = false;
//Loop for generating tickets
for (int i = 1; i < numberOfTickets + 1; i++)
{
//Based on the context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
#region Adding tickets to database
CurrentTicket.eventTitle = EventTitle;
CurrentTicket.price = LevelOnePrice;
CurrentTicket.seatLocation = LevelOneChar + i;
CurrentTicket.eventStart = EventStartLevelOne;
CurrentTicket.eventEnd = EventEndLevelOne;
context.Ticket_Details.Add(CurrentTicket);
context.SaveChanges();
context.Dispose();
#endregion
}
//Assigning a value to level 2
string levelTwoChar = LevelTwoChar;
decimal levelTwoPrice = LevelTwoPrice;
int levelTwoCapacity = LevelTwoCapacity;
//Checks if any of these values are zero. If not continue however return true (since level one tickets succeeded )
if (levelTwoChar == null || levelTwoPrice == 0 || levelTwoCapacity == 0)
{
return(true);
}
//If the level two capacity is above zero (ie there are tickets to generate)
if (levelTwoCapacity > 0)
{
//Loop for generating level 2 tickets
for (int i = 1; i < LevelTwoCapacity + 1; i++)
{
//Based on the database context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
#region Adding tickets and saving to database
CurrentTicket.eventTitle = EventTitle;
CurrentTicket.price = LevelTwoPrice;
CurrentTicket.seatLocation = LevelTwoChar + i;
CurrentTicket.eventStart = EventStartLevelOne;
CurrentTicket.eventEnd = EventEndLevelOne;
context.Ticket_Details.Add(CurrentTicket);
context.SaveChanges();
context.Dispose();
#endregion
}
}
//Assigning values to level 3
string levelThreeChar = LevelThreeChar;
int levelThreeCapacity = LevelThreeCapacity;
decimal levelThreePrice = LevelThreePrice;
//Checks if any of these values are zero. If not continue however return true (since level two tickets succeeded )
if (levelThreeChar == null || levelThreePrice == 0 || levelThreeCapacity == 0)
{
return(true);
}
//If the level three capacity is above zero (ie there are tickets to generate)
if (levelThreeCapacity > 0)
{
//Loop for generating tickets
for (int i = 1; i < levelThreeCapacity + 1; i++)
{
//Assign the database context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
#region Saving to database
CurrentTicket.eventTitle = EventTitle;
CurrentTicket.price = LevelThreePrice;
CurrentTicket.seatLocation = LevelThreeChar + i;
CurrentTicket.eventStart = EventStartLevelOne;
CurrentTicket.eventEnd = EventEndLevelOne;
context.Ticket_Details.Add(CurrentTicket);
context.SaveChanges();
context.Dispose();
#endregion
}
}
//Return true
output = true;
return(output);
}
