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