public IActionResult Edit(PortfolioAccount PortfolioAccount) { if (ModelState.IsValid) { _connectDb.Update(PortfolioAccount); _connectDb.SaveChanges(); } return(RedirectToAction("Index")); }
public IActionResult Create(PortfolioAccount portfolio) { if (ModelState.IsValid) { _connectDb.Add(portfolio); _connectDb.SaveChanges(); } return(RedirectToAction("Index")); }
public IActionResult Edit(int id) { PortfolioAccount portfolioAccount = _connectDb.PortfolioAccounts.Where(a => a.Id == id).FirstOrDefault(); if (portfolioAccount != null) { return(View(portfolioAccount)); } return(View()); }
public IActionResult Delete(PortfolioAccount portfolioAccount) { PortfolioAccount portfolio = _connectDb.PortfolioAccounts.Where(a => a.Id == portfolioAccount.Id).FirstOrDefault(); if (portfolio != null) { _connectDb.Remove(portfolio); _connectDb.SaveChanges(); } return(RedirectToAction("Index")); }
internal static DS.PortfolioAccount ToServerPortfolioAccount(PortfolioAccount account) { return(new DS.PortfolioAccount { ID = account.ID, Name = account.Name, BrokerName = account.BrokerName, DataFeedName = account.DataFeedName, Account = account.Account, UserName = account.UserName }); }
private bool UpdatePortfolioAccount(PortfolioAccount portfolioItem, SqlConnection aConnection, SqlTransaction transaction) { var cmd = new SqlCommand("UPDATE [dbo].[PortfolioAccounts] SET [Name] = @name WHERE [ID] = @id", aConnection); cmd.Parameters.AddWithValue("name", portfolioItem.Name); cmd.Parameters.AddWithValue("id", portfolioItem.ID); try { cmd.Transaction = transaction; cmd.ExecuteNonQuery(); } catch (Exception e) { Logger.Error("Failed to update portfolio account", e); return(false); } return(true); }
public IActionResult Index() { List <StockReceiveMast> list = _connectDb.StockReceiveMasts.ToList(); StockReceiveMastViewModel objMastModel = null; List <StockReceiveMastViewModel> listMastModel = new List <StockReceiveMastViewModel>(); foreach (var item in list) { PortfolioAccount portfolioAccount = _connectDb.PortfolioAccounts.Where(a => a.Id == item.PortfolioAcId).FirstOrDefault(); objMastModel = new StockReceiveMastViewModel() { Id = item.Id, PortfolioAccountNumber = portfolioAccount.AccountNumber, PortfolioAccountName = portfolioAccount.AccountName, ValueDate = item.ValueDate, Remarks = item.Remarks }; listMastModel.Add(objMastModel); } return(View(listMastModel)); }
private int AddPortfolioAccount(int portfolioID, PortfolioAccount portfolioAcct, SqlConnection aConnection, SqlTransaction transaction) { var cmd = new SqlCommand("INSERT INTO [dbo].[PortfolioAccounts] ([Portfolio_ID], [Name], [BrokerName], [UserName], [Account])" + "VALUES(@portfolio_id, @name, @brokerName, @userName, @account) SELECT CONVERT(int, SCOPE_IDENTITY())", aConnection); cmd.Parameters.AddWithValue("portfolio_id", portfolioID); cmd.Parameters.AddWithValue("name", portfolioAcct.Name); cmd.Parameters.AddWithValue("brokerName", portfolioAcct.BrokerName); cmd.Parameters.AddWithValue("userName", portfolioAcct.UserName); cmd.Parameters.AddWithValue("account", portfolioAcct.Account); try { cmd.Transaction = transaction; return((int)cmd.ExecuteScalar()); } catch (Exception e) { Logger.Error("Failed to insert portfolio account", e); return(-1); } }
public IActionResult Delete(int id) { PortfolioAccount portfolioAccount = _connectDb.PortfolioAccounts.Where(a => a.Id == id).FirstOrDefault(); return(View(portfolioAccount)); }