public static void RemoveKortingFromProducts(string kortingId)
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
kr.RemoveKortingFromProducts(kortingId);
}
public static List <Korting> GetKortingByProductId(string productId)
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
return(kr.RetrieveKortingByProductId(productId));
}
public static void AddKortingToProduct(string kortingId, string productid)
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
kr.AddKortingToProduct(productid, kortingId);
}
public static List <Korting> All()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
return(kr.RetrieveAll());
}
public static Korting Find(string key)
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
return(kr.Retrieve(key));
}
public void Delete()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
kr.Delete("1");
}
public void Delete()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
kr.Delete(Id.ToString());
}
public void RetrieveAll()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
List <Korting> list = kr.RetrieveAll();
Assert.IsTrue(list.Count > 1);
}
public void Retrieve()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
Korting k = kr.Retrieve("5");
Assert.IsTrue(k.Kortingspercentage == 23);
}
public void Create()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
Korting k = kr.Retrieve("5");
k.Kortingspercentage = k.Kortingspercentage + 1;
kr.Create(k);
}
public void Update()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
Korting k = kr.Retrieve("5");
k.Opmerking = k.Opmerking + "aangepast";
kr.Update(k);
}
public string SaveOrUpdate()
{
KortingSQLContext ksc = new KortingSQLContext();
KortingRepository kr = new KortingRepository(ksc);
if (Id != 0)
{
kr.Update(this);
return(Id.ToString());
}
else
{
return(kr.Create(this));
}
}
