/// <summary> /// Adds the specified code. /// </summary> /// <param name="code">The code.</param> /// <returns></returns> protected tbl_StatisticData Add(string code) { var statisticData = new tbl_StatisticData() { ID = Guid.NewGuid(), SiteID = HttpContext.Current != null ? CurrentUser.Instance.SiteID : SiteId, Code = code, Value = 0, RecalculateDate = null }; using (var connection = new SqlConnection(ConfigurationManager.AppSettings["ADONETConnectionString"])) { connection.Open(); var query = @"INSERT INTO tbl_StatisticData ([ID], [SiteID], [Code], [Value], [RecalculateDate], [PreviousValue]) VALUES(newid(),@SiteID, @Code, @Value, null, 0)"; using (var command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("@SiteID", statisticData.SiteID); command.Parameters.AddWithValue("@Code", statisticData.Code); command.Parameters.AddWithValue("@Value", statisticData.Value); command.ExecuteNonQuery(); } } //_dataContext.tbl_StatisticData.AddObject(statisticData); //_dataContext.SaveChanges(); return(statisticData); }
/// <summary> /// Updates the specified statistic data. /// </summary> /// <param name="statisticData">The statistic data.</param> public void Update(tbl_StatisticData statisticData) { _dataContext.SaveChanges(); }