public void AddBankAccount(BankAccountInfo bankAccount) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); if (bankAccount.Id == Guid.Empty) bankAccount.Id = Guid.NewGuid(); db.BankAccounts.Add(bankAccount.ToEntity<BankAccount>()); db.SaveChanges(); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public void AddPractice(PracticeInfo practice) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); if (practice.Id == Guid.Empty) practice.Id = Guid.NewGuid(); db.Practices.Add(practice.ToEntity<Practice>()); db.SaveChanges(); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public void AddClient(List<ClientInfo> clients) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); foreach (ClientInfo c in clients) { if (c.Id == Guid.Empty) c.Id = Guid.NewGuid(); db.Clients.Add(c.ToEntity<Client>()); } db.SaveChanges(); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public void AddTransactions(List<TransactionInfo> transactions) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); foreach (TransactionInfo t in transactions) { if (t.Id == Guid.Empty) t.Id = Guid.NewGuid(); db.Transactions.Add(t.ToEntity<Transaction>()); } db.SaveChanges(); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public UserProfile GetUser(string userName) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var u = (from us in db.UserProfiles where us.UserName == userName select us).SingleOrDefault(); UserProfile user = UserProfile.FromEntity(u); return user; } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public List<TransactionTypeInfo> GetTransactionTypes() { List<TransactionTypeInfo> transTypeReturn = new List<TransactionTypeInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var transTypes = (from t in db.TransactionTypes orderby t.Sequence select t).ToList(); foreach (TransactionType t in transTypes) { transTypeReturn.Add(TransactionTypeInfo.FromEntity(t)); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return transTypeReturn; }
public List<TransactionInfo> GetTransactions() { List<TransactionInfo> transToReturn = new List<TransactionInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); List<Transaction> trans = new List<Transaction>(); trans = (from t in db.Transactions select t).ToList(); foreach (Transaction t in trans) { transToReturn.Add(TransactionInfo.FromEntity(t)); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return transToReturn; }
public List<TransactionInfo> GetTransactions(Guid? clientId, Guid? transactionId = null) { List<TransactionInfo> transToReturn = new List<TransactionInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); List<Transaction> trans = new List<Transaction>(); if (transactionId == null) { trans = (from t in db.Transactions where t.ClientId == clientId select t).ToList(); } else trans = (from t in db.Transactions where t.Id == transactionId.Value && t.ClientId == clientId select t).ToList(); foreach (Transaction t in trans) { transToReturn.Add(TransactionInfo.FromEntity(t)); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return transToReturn; }
public void DeleteBankAccount(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) { db.BankAccounts.Remove(ba); db.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public List<ClientInfo> GetClients(Guid practiceId) { List<ClientInfo> clientsToReturn = new List<ClientInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var clients = (from c in db.Clients where c.PracticeId == practiceId select c).ToList(); foreach (Client c in clients) { clientsToReturn.Add(ClientInfo.FromEntity(c)); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return clientsToReturn; }
public List<BankAccountInfo> GetBankAccounts() { List<BankAccountInfo> bankAccounts = new List<BankAccountInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var bas = (from b in db.BankAccounts select b).ToList(); foreach (BankAccount b in bas) { bankAccounts.Add(BankAccountInfo.FromEntity(b)); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return bankAccounts; }
public List<BankAccountInfo> GetBankAccounts(Guid clientId) { List<BankAccountInfo> bankAccounts = new List<BankAccountInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); if (clientId != Guid.Empty) { var bas = (from b in db.BankAccounts where b.ClientId == clientId select b).ToList(); foreach (BankAccount b in bas) { bankAccounts.Add(BankAccountInfo.FromEntity(b)); } } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return bankAccounts; }
public BankAccountInfo GetBankAccount(Guid bankAccountId) { BankAccountInfo bankAccount = new BankAccountInfo(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); if (bankAccountId != Guid.Empty) { var ba = (from b in db.BankAccounts where b.Id == bankAccountId select b).SingleOrDefault(); if (ba != null) { bankAccount = BankAccountInfo.FromEntity(ba); } } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return bankAccount; }
public void DeleteTransaction(Guid transactionId) { try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var tran = (from t in db.Transactions where t.Id == transactionId select t).SingleOrDefault(); if (tran != null) { db.Transactions.Remove(tran); db.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
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 List<PracticeInfo> GetPractices(Guid? userId = null) { List<PracticeInfo> practicesToReturn = new List<PracticeInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var pracs = (from t in db.Practices select t).ToList(); foreach (Practice t in pracs) { practicesToReturn.Add(PracticeInfo.FromEntity(t)); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return practicesToReturn; }
public List<ScheduleInfo> GetScheduleTypes() { List<ScheduleInfo> scheduleTypes = new List<ScheduleInfo>(); try { CashFlowManagerEntities db = new CashFlowManagerEntities(); var schTypes = (from s in db.Schedules orderby s.Sequence select s).ToList(); foreach (Schedule s in schTypes) { scheduleTypes.Add(ScheduleInfo.FromEntity(s)); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return scheduleTypes; }
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; } }