//Remove a payeer or payer from the database based on the id public bool RemovePayerPayee(int id) { using (var context = new FinanceEDMContainer()) { var record = context.PayerPayees.Where(e => e.PPId == id).Single(); context.PayerPayees.Remove(record); context.SaveChanges(); } return(true); }
//remove a transaction by id public bool RemoveTransaction(int id) { using (var context = new FinanceEDMContainer()) { var remove = context.Transactions.Where(e => e.TransactionId == id).Single(); context.Transactions.Remove(remove); context.SaveChanges(); } return(true); }
//add a payer or payee to the database public bool AddPayerPayee(PayerPayee obj) { using (var context = new FinanceEDMContainer()) { //obj.UserDetailsUserId = Session.SessionID; obj.UserDetailsUserId = 1; context.PayerPayees.Add(obj); context.SaveChanges(); } return(true); }
//Add a transaction to the database public bool AddTransaction(List <Transaction> obj) { using (var context = new FinanceEDMContainer()) { foreach (Transaction item in obj) { context.Transactions.Add(item); context.SaveChanges(); } } return(true); }
//update a payer or payee based on the id public bool UpdatePayerPayee(PayerPayee obj) { using (var context = new FinanceEDMContainer()) { var record = context.PayerPayees.SingleOrDefault(e => e.PPId == obj.PPId); record.Name = obj.Name; record.Address = obj.Address; record.DOB = obj.DOB; record.Email = obj.Email; //obj.UserDetailsUserId = Session.SessionID; record.UserDetailsUserId = 1; context.SaveChanges(); } return(true); }
//update the transaction fields public bool UpdateTransaction(Transaction obj) { using (var context = new FinanceEDMContainer()) { var record = context.Transactions.SingleOrDefault(e => e.TransactionId == obj.TransactionId); record.Category = obj.Category; record.Date = obj.Date; record.Description = obj.Description; record.PayerPayeePPId = obj.PayerPayeePPId; record.Recuring = obj.Recuring; record.TransactionId = obj.TransactionId; record.TransactionType = obj.TransactionType; context.SaveChanges(); } return(true); }
//register new user public bool AddUser(UserDetails obj) { using (var context = new FinanceEDMContainer()) { var userRecord = context.UserDetails.Where(e => e.Email == obj.Email); if (userRecord.Any()) { return(false); } else { context.UserDetails.Add(obj); context.SaveChanges(); } } return(true); }