/// <summary>
/// Inserts the item.
/// </summary>
/// <param name="newItem">The new item.</param>
internal void InsertItem(CommonItem newItem)
{
using (var dataContext = new ItemData2DataContext(_connectionString))
{
dataContext.ItemDatas.InsertOnSubmit(new ItemData(newItem));
dataContext.SubmitChanges();
}
}
///// <summary>
///// Initializes a new instance of the <see cref="ItemData"/> class.
///// </summary>
///// <param name="dataContext">The data context.</param>
//internal ItemData2Table(ItemDataDataContext dataContext)
// {
//}
///// <summary>
///// Finds an item with an id.
///// </summary>
///// <param name="itemId">The item id.</param>
///// <returns></returns>
//internal ItemData SelectItem(Guid itemId)
//{
// var query = _DataContext.ItemDatas.Where(item => (item.ItemId == itemId));
// List<ItemData> list = query.ToList();
// if (list.Count > 0)
// return list[0];
// else
// return null;
//}
/// <summary>
/// Selects all items.
/// </summary>
/// <returns></returns>
internal List <ItemData> SelectAllItems()
{
using (var dataContext = new ItemData2DataContext(_connectionString))
{
var query = dataContext.ItemDatas.Where(item => (true));
return(query.ToList());
}
}
/// <summary>
/// Deletes the item with the id.
/// </summary>
/// <param name="itemId">The item id.</param>
internal void DeleteItem(Guid itemId)
{
string sqlCommand = $"DELETE FROM [ItemData] WHERE [ItemId] = '{itemId}'";
using (var dataContext = new ItemData2DataContext(_connectionString))
{
dataContext.ExecuteCommand(sqlCommand);
}
// LINQ round-trip DELETE queries are too slow
//var query = _DataContext.ItemDatas.Where(item => (item.ItemId == itemId));
//_DataContext.ItemDatas.DeleteAllOnSubmit(query);
//_DataContext.SubmitChanges();
}
