public static void DeleteShape(int portfolio_symbol_shape_id)
{
using (ctaDBEntities entities = new ctaDBEntities())
{
entities.Database.Connection.Open();
Portfolio_Stock_Shape psi = entities.Portfolio_Stock_Shape.Where(ps => ps.Id == portfolio_symbol_shape_id).FirstOrDefault();
if (psi != null)
{
entities.Portfolio_Stock_Shape.Remove(psi);
entities.SaveChanges();
}
entities.Database.Connection.Close();
}
}
public static void AddShape(int portfolio_id, int symbol_id, int shape_id, DateTime start_date, double start_value, DateTime end_date, double end_value, string color, string name)
{
using (ctaDBEntities entities = new ctaDBEntities())
{
entities.Database.Connection.Open();
Portfolio_Stock_Shape pss = new Portfolio_Stock_Shape();
pss.portfolio_id = portfolio_id;
pss.stock_id = symbol_id;
pss.shape_id = shape_id;
pss.name = name;
pss.color = color;
pss.date1 = start_date;
pss.date2 = end_date;
pss.value1 = start_value;
pss.value2 = end_value;
entities.Portfolio_Stock_Shape.Add(pss);
entities.SaveChanges();
entities.Database.Connection.Close();
}
}
