public List <UserAndSharesEntity> SelectStocksForUserObjectParameters(UserEntity userEntity, SharesEntity sharesEntity) { TransactionRepositories transactionRepositories = new TransactionRepositories(dbContext); var usersAndShare = transactionRepositories.GetUserAndShareParameters(userEntity, sharesEntity); return(usersAndShare); }
public List <SharesEntity> FindOutTheValueOfShares(UserAndSharesEntity userAndSharesEntity) { TransactionRepositories transactionRepositories = new TransactionRepositories(dbContext); var shares = transactionRepositories.GetShares(userAndSharesEntity); return(shares); }
public List <UserAndSharesEntity> SelectSharesToThUserEntity(UserEntity userEntity) { TransactionRepositories transactionRepositories = new TransactionRepositories(dbContext); var usersAndShare = transactionRepositories.GetUserAndShareList(userEntity); return(usersAndShare); }
public List <UserEntity> SelectUser() { TransactionRepositories transactionRepositories = new TransactionRepositories(dbContext); var users = transactionRepositories.GetUserList(); return(users); }
public void StockPurchaseTransaction(UserEntity seller, UserEntity customer, int sharePrice, int numberOfSharesToSell, UserAndSharesEntity sellerSharesToThUserEntity, UserAndSharesEntity customerSharesToThUserEntity) { TransactionRepositories transactionRepositories = new TransactionRepositories(dbContext); transactionRepositories.UpdateUserTable(seller); transactionRepositories.UpdateUserTable(customer); transactionRepositories.UpdateUserTable(sellerSharesToThUserEntity); transactionRepositories.UpdateUserTable(customerSharesToThUserEntity); transactionRepositories.SaveChanges(); }
public void RegisterNewTransactionHistory(TransactionHistoryEntity transactionHistoryEntity) { var entityToAdd = new TransactionHistoryEntity() { DateTimeBay = transactionHistoryEntity.DateTimeBay, SellerId = transactionHistoryEntity.SellerId, CustomerId = transactionHistoryEntity.CustomerId, AmountShare = transactionHistoryEntity.AmountShare, Cost = transactionHistoryEntity.Cost }; TransactionRepositories transactionRepositories = new TransactionRepositories(dbContext); transactionRepositories.Add(entityToAdd); transactionRepositories.SaveChanges(); }
public static Response doCheckout(List <Cart> carts, int UserID, int PaymentTypeID, DateTime date) { Header_Transaction headerTran = TransactionsFactories.InsertHeaderTransaction(UserID, PaymentTypeID, date); TransactionRepositories.InsertHeaderTransaction(headerTran); Detail_Transaction detailTran = new Detail_Transaction(); for (int i = 0; i < carts.Count; i++) { detailTran = TransactionsFactories.InsertDetailTransaction(headerTran.ID, carts[i].ProductID, carts[i].Quantity); TransactionRepositories.InsertDetailTransaction(detailTran); CartRepositories.DeleteCart(carts[i].ProductID, UserID); } return(new Response(true)); }
public static Response DeletePayment(int ID) { if (TransactionRepositories.GetHeaderTransactionByPaymentID(ID) != null) { return(new Response(false, "Cant delete this payment type because its referenced on another table in the database")); } PaymentType payment = PaymentRepositories.GetPaymentType(ID); if (payment != null) { PaymentRepositories.DeletePaymentType(payment); return(new Response(true)); } return(new Response(false, "Theres no selected payment type.")); }
public static Response DeleteProduct(int ProductID) { Cart cart = CartRepositories.GetCartByProduct(ProductID); Detail_Transaction detailTran = TransactionRepositories.GetDetailTransactionByProductID(ProductID); if (cart != null || detailTran != null) { return(new Response(false, "Cant delete this product because its referenced in another table in database")); } Product pro = ProductRepositories.GetProduct(ProductID); if (pro != null) { ProductRepositories.DeleteProduct(ProductID); return(new Response(true)); } return(new Response(false, "cant find the product")); }
public static void insert(TransactionHistory trans) { TransactionRepositories.insertTransaction(trans); }
public static List <TransactionHistory> getTransactionByEmail(String email) { return(TransactionRepositories.getTransactionByEmail(email)); }
public static List <TransactionHistory> getAllTransaction() { return(TransactionRepositories.getAllTransaction()); }
public static List <Detail_Transaction> GetDetailTransactions() { return(TransactionRepositories.GetDetailTransactions()); }
public static List <Header_Transaction> GetHeaderTransactions() { return(TransactionRepositories.GetHeaderTransactions()); }
public static List <Detail_Transaction> GetDetailTransactionsByTransactionID(int TransactionID) { return(TransactionRepositories.GetDetailTransactionsByTransactionID(TransactionID)); }
public static List <Header_Transaction> GetHeaderTransactionsByUser(int UserID) { return(TransactionRepositories.GetHeaderTransactionsByUser(UserID)); }