public void DeleteWallet(WalletModel wallet, string userId) { SqlDataAccess sql = new SqlDataAccess(_config); var p = new { WalletName = wallet.WalletName, UserId = userId }; sql.Execute("spWallets_RemoweWallet", p, "FinAppData"); }
public int Get(Customer customer) { var sqlDataAccess = new SqlDataAccess(); var result = sqlDataAccess.Execute("SELECT * FROM CUSTOMERS"); return(0); }
public void AddWallet(WalletModel wallet, string userId) { if (WalletDoesNotExist(wallet.WalletName, userId)) { SqlDataAccess sql = new SqlDataAccess(_config); var p = new { UserId = userId, WalletName = wallet.WalletName, CurrentAmount = wallet.CurrentAmount }; sql.Execute("spWallets_AddWallet", p, "FinAppData"); } }
public bool AddArticle(ArticleModel article) { if (ArticleDoesNotExist(article.ArticleName)) { _sql.Execute("spArticles_AddAritcle", article, "FinAppData"); return(true); } else { return(false); } }
public void MakeTransition(TransitionModel transition, string userId) { SqlDataAccess sql = new SqlDataAccess(_config); var p = new { UserId = userId, WalletId = transition.Wallet.Id, TransitionAmount = transition.Amount, TransitionDate = transition.TransitionDate, TransitionType = transition.TransitionType, ArticleId = transition.Article.Id }; sql.Execute("spTransitions_MakeTransitions", p, "FinAppData"); }
private bool WalletDoesNotExist(string nameToCheck, string userId) { SqlDataAccess dataAccess = new SqlDataAccess(_config); var p = new DynamicParameters(); p.Add("@WalletName", nameToCheck); p.Add("@UserId", userId); p.Add("@Out", DbType.Int32, direction: ParameterDirection.Output); dataAccess.Execute("spWallets_WalletsLookUp", p, "FinAppData"); var retval = p.Get <int>("@Out"); if (retval == 0) { return(true); } else { return(false); } }