public void ClearChangeLogs()
{
using (var dataContext = new TVItemsDataContext(_connectionString))
{
dataContext.ExecuteCommand("TRUNCATE TABLE ChangeLogs");
}
}
public void Delete(int itemNumber)
{
using (var dataContext = new TVItemsDataContext(_connectionString))
{
dataContext.ExecuteCommand("DELETE FROM TVItems WHERE ItemNumber = {0}", itemNumber);
}
}
public IEnumerable <TVItem> GetAll()
{
using (var dataContext = new TVItemsDataContext(_connectionString))
{
return(dataContext.TVItems.ToList());
}
}
public void AddChangeLog(ChangeLog changeLog)
{
using (var dataContext = new TVItemsDataContext(_connectionString))
{
dataContext.ChangeLogs.InsertOnSubmit(changeLog);
dataContext.SubmitChanges();
}
}
public void AddItem(TVItem item)
{
using (var dataContext = new TVItemsDataContext(_connectionString))
{
dataContext.TVItems.InsertOnSubmit(item);
dataContext.SubmitChanges();
}
}
public void Update(TVItem item)
{
using (var dataContext = new TVItemsDataContext(_connectionString))
{
dataContext.TVItems.Attach(item);
dataContext.Refresh(RefreshMode.KeepCurrentValues, item);
dataContext.SubmitChanges();
}
}