public bool Add(string categoryName, int parentId, int ID=-1)
{
BibliotekaDataContext db = new BibliotekaDataContext();
if (categories.Exists(x => x.nazwa == categoryName) == true) return false;
if (ID <= 0)
{
db.Kategorias.InsertOnSubmit(new Kategoria() { nazwa = categoryName, kategoriaNadrzednaID = parentId });
}
else
{
db.Kategorias.InsertOnSubmit(new Kategoria() { nazwa = categoryName, kategoriaNadrzednaID = parentId, id=ID });
}
try
{
db.SubmitChanges();
}
catch (System.Data.SqlClient.SqlException SqlExp)
{
lastException = SqlExp.Message;
return false;
}
Kategoria cat = db.Kategorias.Where(x => x.nazwa == categoryName).Single();
categories.Add(cat);
return true;
}
private void LoadCategories()
{
BibliotekaDataContext db = new BibliotekaDataContext();
categories = new List<Kategoria>();
foreach (Kategoria cat in db.Kategorias)
{
categories.Add(cat);
}
}
public bool Remove(string categoryName)
{
if (categories.Exists(x => x.nazwa == categoryName) == false) return false;
Kategoria delCat = categories.Where(x => x.nazwa == categoryName).Single();
BibliotekaDataContext db = new BibliotekaDataContext();
db.Kategorias.DeleteOnSubmit(delCat);
try
{
db.SubmitChanges();
}
catch (System.Data.SqlClient.SqlException SqlExp)
{
lastException = SqlExp.Message;
return false;
}
categories.Remove(delCat);
return true;
}
