public static void DeleteIndicator(int portfolio_symbol_indicator_id)
{
using (ctaDBEntities entities = new ctaDBEntities())
{
entities.Database.Connection.Open();
Portfolio_Stock_Indicator psi = entities.Portfolio_Stock_Indicator.Where(ps => ps.Id == portfolio_symbol_indicator_id).FirstOrDefault();
if (psi != null)
{
entities.Portfolio_Stock_Indicator.Remove(psi);
entities.SaveChanges();
}
entities.Database.Connection.Close();
}
}
public static void AddIndicator(int portfolioID, int symbolID, int indicatorID, string param1, string color1, string param2, string color2, string param3, string color3)
{
using (ctaDBEntities entities = new ctaDBEntities())
{
entities.Database.Connection.Open();
Portfolio_Stock_Indicator psi = new Portfolio_Stock_Indicator();
psi.portfolio_id = portfolioID;
psi.indicator_id = indicatorID;
psi.stock_id = symbolID;
psi.param1 = (param1 == null) ? String.Empty : param1;
psi.color1 = (color1 == null) ? String.Empty : color1;
psi.param2 = (param2 == null) ? String.Empty : param2;
psi.color2 = (color2 == null) ? String.Empty : color2;
psi.param3 = (param3 == null) ? String.Empty : param3;
psi.color3 = (color3 == null) ? String.Empty : color3;
entities.Portfolio_Stock_Indicator.Add(psi);
entities.SaveChanges();
entities.Database.Connection.Close();
}
}
