public bool CheckIsCatagoryInUse(Catagory catagory)
{
IArtistDao dao = DALFactory.CreateArtistDao(database);
if(dao.findByProperty(typeof(Artist).GetProperty("Catagory"), catagory).Count() > 0)
{
return true;
}
return false;
}
private static void CreateCatagories()
{
Console.WriteLine("Insert Catagories ");
ICatagoryDao catagoryDao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
for (int i = 1; i <= 10; i++)
{
Catagory c = new Catagory();
c.Name = "Catagory " + i;
c.Description = "Catagory Description for " + i;
catagoryDao.Insert(c);
}
}
public void TestInsert()
{
Catagory cat = new Catagory();
cat.Name = "UNIT-TEST";
cat.Description = "asdf";
ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
dao.Insert(cat);
PropertyInfo info = typeof(Catagory).GetProperty("Name");
Catagory result = dao.findByUniqueProperty(info, "UNIT-TEST");
Assert.AreEqual(result.Name, cat.Name);
Assert.AreEqual(result.Description, cat.Description);
}
public CatagoryVM(Catagory cat, IAdministrationServices service)
{
catagory = cat;
this.service = service;
SaveCommand = new RelayCommand((c) =>
{
if (!Validator.ValidateAll().IsValid)
{
return;
}
catagory = service.SaveCatagory(catagory);
if (catagory != null && catagory.Id > 0)
{
AppMessages.CatagoryChanged.Send(AppMessages.ChangeType.Change);
AppMessages.ShowSuccessMessage.Send($"Catagory {catagory.Name} saved");
return;
}
AppMessages.ShowErrorMessage.Send($"Error while saving Catagory {catagory.Name}");
});
DeleteCommand = new RelayCommand((c) =>
{
try {
if (service.DelteCatagory(catagory))
{
AppMessages.CatagoryChanged.Send(AppMessages.ChangeType.Remove);
AppMessages.ShowSuccessMessage.Send($"Catagory {catagory.Name} removed");
return;
}
}catch(ElementInUseException e)
{
AppMessages.ShowErrorMessage.Send(e.Message);
return;
}
AppMessages.ShowErrorMessage.Send($"Error while removing Catagory {catagory.Name}");
});
ApplyValidationRules();
}
public Catagory SaveCatagory(Catagory catagory)
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(database);
if(catagory.Id != null && catagory.Id > 0)
{
dao.Update(catagory);
return catagory;
}
catagory = dao.Insert(catagory);
return catagory;
}
public bool DelteCatagory(Catagory catagory)
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(database);
if (this.CheckIsCatagoryInUse(catagory))
{
throw new ElementInUseException($"Can't delete catagory {catagory.Name}. Catagory is assigned");
}
return dao.Delete(catagory);
}