/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidatedForCustomerTransactions(object sender, RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Customer_Transaction newRecord = args.RowData as Customer_Transaction;
if (sender == null)
{
return;
}
Customer_Transaction order = context.Customer_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_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>
/// 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;
}
Customer_Ticket_Details order = context.Customer_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>
/// Changes record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
Employee_Details newRecord = args.RowData as Employee_Details;
Employee_Details order = context.Employee_Details.First(i => i.employeeID == newRecord.employeeID);
order.employeeID = newRecord.employeeID;
order.email = newRecord.email;
order.password = newRecord.password;
order.firstName = newRecord.firstName;
order.lastName = newRecord.lastName;
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
/// <summary>
/// Adds record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
Ticket_Details newRecord = args.RowData as Ticket_Details;
Ticket_Details order = context.Ticket_Details.First(i => i.ticketId == newRecord.ticketId);
order.ticketId = newRecord.ticketId;
order.eventTitle = newRecord.eventTitle;
order.eventStart = newRecord.eventStart;
order.eventEnd = newRecord.eventEnd;
order.price = newRecord.price;
order.seatLocation = newRecord.seatLocation;
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
/// <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>
/// 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>
/// Adds record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
Event_Details newRecord = args.RowData as Event_Details;
Event_Details order = context.Event_Details.First(i => i.eventID == newRecord.eventID);
order.eventID = newRecord.eventID;
order.eventAddress = newRecord.eventAddress;
order.eventDescription = newRecord.eventDescription;
order.capacity = newRecord.capacity;
order.eventStart = newRecord.eventStart;
order.eventEnd = newRecord.eventEnd;
order.eventLocation = newRecord.eventLocation;
order.eventPicture = newRecord.eventPicture;
order.eventTitle = newRecord.eventTitle;
order.eventGenre = newRecord.eventGenre;
order.showOnHomePage = newRecord.showOnHomePage;
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
/// <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();
}
