public void SelectById()
{
CollectionItemManager manager = new CollectionItemManager();
//Variante 1: Alle Datensätze lesen und erstes Element auswählen und wieder lesen
List <CollectionItem> itemList = manager.Select().ToList();
CollectionItem firstItem = itemList.FirstOrDefault();
if (firstItem != null)
{
CollectionItem item = manager.SelectById(firstItem.Id);
Assert.IsNotNull(item);
}
else
{
Assert.IsNotNull(firstItem);
}
//Variante 2: Neues Element einfügen, ID feststellen und wieder lesen
CollectionItem newItem = new CollectionItem();
newItem.Name = string.Format("CollectionItem SelectById {0}", DateTime.Now);
newItem.Setnumber = "99999";
manager.Insert(newItem);
Assert.AreNotEqual(newItem.Id, 0);
if (newItem.Id != 0)
{
CollectionItem item = manager.SelectById(newItem.Id);
Assert.IsNotNull(item);
}
}
public void Select()
{
CollectionItemManager manager = new CollectionItemManager();
var itemList = manager.Select().ToList();
Assert.AreNotEqual(itemList.Count, 0);
}
public void SelectAsync()
{
CollectionItemManager manager = new CollectionItemManager();
var asyncResult = manager.SelectAsync();
asyncResult.Wait();
List <CollectionItem> itemList = asyncResult.Result.ToList();
Assert.AreNotEqual(itemList.Count, 0);
}
public void InsertAsync()
{
CollectionItem newItem = new CollectionItem();
newItem.Name = string.Format("CollectionItem Async {0}", DateTime.Now);
newItem.Setnumber = "99999";
CollectionItemManager manager = new CollectionItemManager();
manager.InsertAsync(newItem).Wait();
Assert.AreNotEqual(newItem.Id, 0);
}
public CollectionListViewModel()
{
CollectionItemManager manager = new CollectionItemManager();
ObservableCollection <CollectionItem> itemList = new ObservableCollection <CollectionItem>(manager.Select());
_collectionItemListViewSource = new CollectionViewSource()
{
Source = itemList
};
CheckCommand = new RelayCommand(CheckExecute, CheckCanExcute);
RelocateCommand = new RelayCommand(SelectedExecute, SelectedCanExecute);
ExportCommand = new RelayCommand(SelectedExecute, SelectedCanExecute);
PrintLabelCommand = new RelayCommand(SelectedExecute, SelectedCanExecute);
PrintListCommand = new RelayCommand(SelectedExecute, SelectedCanExecute);
}
public void Delete()
{
CollectionItemManager manager = new CollectionItemManager();
List <CollectionItem> itemList = manager.Select().ToList();
CollectionItem firstItem = itemList.FirstOrDefault();
if (firstItem != null)
{
long id = firstItem.Id;
manager.Delete(id);
CollectionItem deletedItem = manager.SelectById(id);
Assert.IsNull(deletedItem);
}
else
{
Assert.Fail();
}
}
public void Update()
{
CollectionItemManager manager = new CollectionItemManager();
List <CollectionItem> itemList = manager.Select().ToList();
CollectionItem firstItem = itemList.FirstOrDefault();
if (firstItem != null)
{
string oldName = firstItem.Name;
firstItem.Name = string.Format("{0} Updated", oldName);
manager.Update(firstItem, firstItem.Id);
CollectionItem savedItem = manager.SelectById(firstItem.Id);
Assert.AreNotEqual(savedItem.Name, oldName);
}
else
{
Assert.IsNotNull(firstItem);
}
}
