public void UpdateBankAccount(BankAccountInfo bankAccount) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); BankAccount ba = (from b in db.BankAccounts where b.Id == bankAccount.Id select b).SingleOrDefault(); if (ba != null) { ba.AccountName = bankAccount.AccountName; ba.AccountNumber = bankAccount.AccountNumber; ba.Balance = bankAccount.Balance; ba.ClientId = bankAccount.ClientId; } db.Entry(ba).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public void UpdateTransaction(TransactionInfo transaction) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var tran = (from t in db.Transactions where t.Id == transaction.Id select t).SingleOrDefault(); if (tran != null) { tran.Narration = transaction.Narration; tran.ScheduleId = transaction.ScheduleId; tran.Amount = transaction.Amount; tran.StartDate = transaction.StartDate; tran.TransactionTypeId = transaction.TransactionTypeId; db.Entry(tran).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public void AssociateAndUpdateUser(int userId, Guid? practiceId, string email) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); if (practiceId != Guid.Empty) { var user = (from u in db.UserProfiles where u.UserId == userId select u).SingleOrDefault(); if (user != null) { user.PracticeId = practiceId; user.Email = email; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }