/// <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; }