ArticleRepository.h

#pragma once
#include "BDD.h"
#include "Article.h"

using namespace  System::Collections::Generic;

using namespace System;
using namespace System::Data;

ref class ArticleRepository
{
private:
	BDD^ bdd;
public:
	ArticleRepository(BDD^ bdd) :bdd(bdd) {
	}
	List<Article^>^ getArticle(bool delState) {
		DataSet^ ds = bdd->executeQuery("SELECT * FROM [Article]" + (delState ? "" : " WHERE Del = 0"));

		List<Article^>^ list = gcnew List<Article^>();

		for each (DataRow ^ row in ds->Tables[0]->Rows)
		{
			Article^ article = gcnew Article();
			article->setIdArticle((String^)row[0]);
			article->setName((String^)row[1]);
			article->setKind((String^)row[2]);
			article->setPriceWT((Decimal^)row[6]);
			article->setVAT((int)row[8]);
			article->setPriceATI((Decimal^)row[7]);
			article->setStock((long long)row[3]);
			article->setRestockingLimit((long long)row[4]);
			article->setRestockingDate((DateTime^)row[5]);
			list->Add(article);
		}

		return list;
	}

	void editArticle(Article^ article) {
		bdd->executeNonQuery("UPDATE [Article] SET ID_Article = '" + article->getIdArticle() + "', NameArticle = '" + article->getName() + "', Kind = '" + article->getKind() + "', QuantityStock = '" + article->getStock() + "', RestockingTreshold = '" + article->getRestockingLimit() + "', DateRestocking = '" + article->getRestockingDate() + "', PriceWT = '" + article->getPriceWT() + "', PriceATI = '" + article->getPriceATI() + "', VATValue = '" + article->getVAT() + "', Del = '" + false + "' WHERE ID_Article = '" + article->getIdArticle() + "'");
	}

	void deleteArticle(Article^ article, int delOrRestore) {
		bdd->executeNonQuery("UPDATE [Article] SET Del = " + delOrRestore + " WHERE [ID_Article] = '" + article->getIdArticle() + "'");
	}

	void insertArticle(Article^ article) {
		bdd->executeInsert("INSERT INTO [Article] (ID_Article, NameArticle, Kind, QuantityStock, RestockingTreshold, DateRestocking, PriceWT, PriceATI, VATValue, Del) VALUES ('" + article->getIdArticle() + "', '" + article->getName() + "', '" + article->getKind() + "', '" + article->getStock() + "', '" + article->getRestockingLimit() + "', '" + article->getRestockingDate() + "', '" + article->getPriceWT() + "', '" + article->getPriceATI() + "', '" + article->getVAT() + "', '" + false + "');", 2);
	}
};