/// <summary>
/// If customer id is 0, they will be added. Otherwise, it will update based on the customer id
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static CustomerPurchase AddOrUpdate(CustomerPurchase p)
{
using (var context = new CustomerPurchaseContext())
{
context.Entry(p).State = (p.CustomerId == 0) ? EntityState.Added : EntityState.Modified;
context.SaveChanges();
return(p);
}
}
public static CustomerPurchase Add(CustomerPurchase p)
{
using (var context = new CustomerPurchaseContext())
{
context.CustomerPurchases.Add(p);
context.SaveChanges();
}
return(p);
}
/// <summary>
/// Updates all customer purchase data (Except for customer id, which is the primary key)
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static CustomerPurchase Update(CustomerPurchase p)
{
using (var context = new CustomerPurchaseContext())
{
context.CustomerPurchases.Attach(p);
context.Entry(p).State = EntityState.Modified;
context.SaveChanges();
return(p);
}
}
/// <summary>
/// Deletes a customer purchase from the database by their customer id
/// </summary>
/// <param name="p"></param>
public static void Delete(CustomerPurchase p)
{
using (var context = new CustomerPurchaseContext())
{
context.CustomerPurchases.Add(p);
context.Entry(p).State = EntityState.Deleted;
context.SaveChanges();
}
}
private void PurchaseTicket_Click(object sender, EventArgs e)
{
//Create a purchase object
CustomerPurchase cp = new CustomerPurchase()
{
FirstName = FirstNameTxt.Text,
LastName = LastNameTxt.Text,
Email = EmailTxt.Text,
PhoneNumber = PhoneNumberTxt.Text,
DatePurchased = DateTime.Now
};
//Add the purchase to the database
CustomerPurchaseDb.Add(cp);
MessageBox.Show($"Ticket successfully purchased");
DialogResult = DialogResult.OK;
}
