public void EditContact(int id, String name) { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); Contact contact = db.Contacts.Find(id); contact.Name = name; db.SaveChanges(); }
public void DeleteContact(int id) { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); Contact contact = db.Contacts.Find(id); db.Contacts.Remove(contact); db.SaveChanges(); }
public void DeleteEvent(int id) { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); Event eventData = db.Events.Find(id); db.Events.Remove(eventData); db.SaveChanges(); }
public void DeleteTransaction(int id) { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); Transaction transaction = db.Transactions.Find(id); db.Transactions.Remove(transaction); db.SaveChanges(); }
public void EditTransaction(TransactionDetails transactionDetails) { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); Transaction transaction = db.Transactions.Find(transactionDetails.Id); transaction.Date = transactionDetails.Date; transaction.ContactId = transactionDetails.ContactId; transaction.Amount = transactionDetails.Amount; db.SaveChanges(); }
public void SaveContact(ContactDetails contactDetails) { Contact contact = new Contact(); contact.Type = contactDetails.Type; contact.Name = contactDetails.Name; MyDatabaseFileEntities db = new MyDatabaseFileEntities(); db.Contacts.Add(contact); db.SaveChanges(); }
public void SaveTransaction(TransactionDetails transactionDetails) { Transaction transaction = new Transaction(); transaction.Date = transactionDetails.Date; transaction.Type = transactionDetails.Type; transaction.ContactId = transactionDetails.ContactId; transaction.Amount = transactionDetails.Amount; MyDatabaseFileEntities db = new MyDatabaseFileEntities(); db.Transactions.Add(transaction); db.SaveChanges(); }
public void EditEvent(EventDetails eventDetails) { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); Event eventData = db.Events.Find(eventDetails.Id); eventData.OccurrenceType = eventDetails.OccurrenceType; eventData.StartDate = eventDetails.StartDate; eventData.AdditionalRecurring = eventDetails.AdditionalRecurring; eventData.Description = eventDetails.Description; eventData.EventType = eventDetails.EventType; db.SaveChanges(); }
public dynamic GetContact() { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); return(db.Contacts); }
public dynamic GetTransaction() { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); return(db.Transactions); }
public dynamic GetEvent() { MyDatabaseFileEntities db = new MyDatabaseFileEntities(); return(db.Events); }