public static object _readPortfolioDetail(portfolio port)
{
string[] symbols = port.symbols;
string from = port.from;
string to = port.to;
string split = port.split;
if (string.IsNullOrEmpty(split))
{
List <Array> aPortfolio_Whole_Data = new List <Array>();
if (string.IsNullOrEmpty(to) || to.Equals(from))
{
aPortfolio_Whole_Data = getMData(symbols, from);
}
else
{
aPortfolio_Whole_Data = getHData(symbols, from, to);
}
return(aPortfolio_Whole_Data);
}
else
{
if (split.Equals("m"))
{
}
else if (split.Equals("h"))
{
}
else if (split.Equals("d"))
{
}
return(new { errmsg = "It has not been completed" });
}
}
public static bool _savePortfolio(string username, portfolio portfolio)
{
var conn = new SqlConnection(SQLConnectionStr.connectionStr);
var cmd = new SqlCommand("save_Portfolio", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userName", username);
cmd.Parameters.AddWithValue("@PortName", portfolio.portfolioname);
cmd.Parameters.AddWithValue("@from", portfolio.from);
cmd.Parameters.AddWithValue("@to", portfolio.to == null?"":portfolio.to);
cmd.Parameters.AddWithValue("@split", portfolio.split == null?"":portfolio.split);
conn.Open();
int result = int.Parse(cmd.ExecuteScalar().ToString());
foreach (string symbol in portfolio.symbols)
{
var cmd_1 = new SqlCommand("save_PortfolioItems", conn);
cmd_1.CommandType = CommandType.StoredProcedure;
cmd_1.Parameters.AddWithValue("@PortID", result);
cmd_1.Parameters.AddWithValue("@symbol", symbol);
cmd_1.ExecuteNonQuery();
}
conn.Close();
return(true);
}
public static portfolio _getDefaultPortfolio(string baseSymbol)
{
var portfolio = new portfolio();
portfolio.split = "";
portfolio.from = "20160201";
portfolio.to = "";
portfolio.symbols = new string[] { baseSymbol };
return(portfolio);
}
public static portfolio[] _readPortfolio(string username)
{
List <portfolio> portfolios = new List <portfolio>();
var conn = new SqlConnection(SQLConnectionStr.connectionStr);
var cmd = new SqlCommand("get_Portfolio", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", username);
conn.Open();
SqlDataReader resultReader = cmd.ExecuteReader();
while (resultReader.Read())
{
var portfolio = new portfolio();
portfolio.portfolioID = int.Parse(resultReader.GetValue(0).ToString());
portfolio.portfolioname = resultReader.GetValue(2).ToString();
portfolio.from = resultReader.GetValue(3).ToString().Replace("-", "");
portfolio.to = (resultReader.GetValue(4).ToString().Equals("1900-01-01")) ? "" :resultReader.GetValue(4).ToString().Replace("-", "");
portfolio.split = resultReader.GetValue(5).ToString();
var cmd_getSymbols = new SqlCommand("get_Portfolio_Items", conn);
cmd_getSymbols.CommandType = CommandType.StoredProcedure;
cmd_getSymbols.Parameters.AddWithValue("@PortID", portfolio.portfolioID);
SqlDataReader resultReader_symbols = cmd_getSymbols.ExecuteReader();
List <string> symbols = new List <string>();
while (resultReader_symbols.Read())
{
symbols.Add(resultReader_symbols.GetValue(0).ToString());
}
portfolio.symbols = symbols.ToArray();
portfolios.Add(portfolio);
}
conn.Close();
return(portfolios.ToArray());
}
