public void ChangeItemChangeLog(ChangeLog changeLog) { using (var context = new TVItemsDataContext(_connectionString)) { context.ChangeLogs.InsertOnSubmit(changeLog); context.SubmitChanges(); } }
public void AddItem(TVItem item) { using (var context = new TVItemsDataContext(_connectionString)) { context.TVItems.InsertOnSubmit(item); context.SubmitChanges(); } }
public void UpdateItem(TVItem item) { using (var context = new TVItemsDataContext(_connectionString)) { context.TVItems.Attach(item); context.Refresh(RefreshMode.KeepCurrentValues, item); context.SubmitChanges(); } }
public void RemoveItemChangeLog(int itemNumber) { using (var context = new TVItemsDataContext(_connectionString)) { var changeLog = new ChangeLog { ItemNumber = itemNumber, ChangeType = "Remove" }; context.ChangeLogs.InsertOnSubmit(changeLog); context.SubmitChanges(); } }