public IEnumerable <stockMarketDaily> GetAllStockMarket() { using (StockMarketDailyDataContext dataContext = new StockMarketDailyDataContext()) { return(dataContext.stockMarketDailies.ToList()); } }
public void RemoveDailyStockMarket(int id) { using (StockMarketDailyDataContext dataContext = new StockMarketDailyDataContext()) { var stockMarketDaily = dataContext.stockMarketDailies.Where(stock => stock.Id == id).SingleOrDefault(); dataContext.stockMarketDailies.DeleteOnSubmit(stockMarketDaily); dataContext.SubmitChanges(); } }
public void SaveStockMarketDaily(stockMarketDaily stockMarket) { if (stockMarket == null) { throw new ArgumentNullException("Stock Market was NULL"); } using (StockMarketDailyDataContext dataContext = new StockMarketDailyDataContext()) { stockMarket.CreatedDate = DateTime.Now; dataContext.stockMarketDailies.InsertOnSubmit(stockMarket); dataContext.SubmitChanges(); } }