public static void CreateMarketIndexStock(MarketIndexStockModel marketIndexStockModel)
{
using (ctaDBEntities entities = new ctaDBEntities())
{
MarketIndex_Stock mIndexs = new MarketIndex_Stock()
{
marketindex_id = marketIndexStockModel.marketindex_id, stock_id = marketIndexStockModel.stock_id
};
entities.MarketIndex_Stock.Add(mIndexs);
entities.SaveChanges();
if (!(entities.Database.Connection.State == ConnectionState.Closed))
{
entities.Database.Connection.Close();
}
}
}
public static void UpdateMarketIndexStock(MarketIndexStockModel marketIndexStockModel)
{
using (ctaDBEntities entities = new ctaDBEntities())
{
MarketIndex_Stock mIndexS = entities.MarketIndex_Stock.Where(s => s.Id == marketIndexStockModel.Id).FirstOrDefault();
if (mIndexS != null)
{
mIndexS.marketindex_id = marketIndexStockModel.marketindex_id;
mIndexS.stock_id = marketIndexStockModel.stock_id;
entities.SaveChanges();
}
if (!(entities.Database.Connection.State == ConnectionState.Closed))
{
entities.Database.Connection.Close();
}
}
}
