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));
}
