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