public HttpResponseMessage Get()
{
VendsRepository VenteRepo = new VendsRepository(connexion);
var user = VenteRepo.GetAll().ToList();
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
//create
public HttpResponseMessage Post([FromBody] Vends vente)
{
try
{
VendsRepository VenteRepo = new VendsRepository(connexion);
VenteRepo.Insert(vente);
return(Request.CreateResponse(HttpStatusCode.Created, vente));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//update
public HttpResponseMessage Put([FromBody] Vends vente)
{
try
{
VendsRepository VenteRepo = new VendsRepository(connexion);
if (vente == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Vente Not Found"));
}
VenteRepo.Update(vente);
return(Request.CreateResponse(HttpStatusCode.OK, vente));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void GetOne()
{
var Cxt = new VendsRepository(connexion);
var vente = new Vends
{
DateVente = new DateTime(),
IdPermaFungi = 1,
IdProduit = 2
};
CompositeKey <int, int> id = new CompositeKey <int, int> {
PK1 = 2, PK2 = 2
};
Assert.IsNotNull(Cxt.GetOne(id));
}
public HttpResponseMessage delete(int idPF, int idProd)
{
try
{
VendsRepository VenteRepo = new VendsRepository(connexion);
var compositKey = new CompositeKey <int, int>();
compositKey.PK1 = idPF;
compositKey.PK2 = idProd;
var venteToDelete = VenteRepo.GetOne(compositKey);
if (venteToDelete == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Vente with ID: " + compositKey.ToString() + "not found"));
}
VenteRepo.Delete(compositKey);
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Get(int idPF, int idProd)
{
VendsRepository VenteRepo = new VendsRepository(connexion);
PermaFungiRepository PFRepo = new PermaFungiRepository(connexion);
ProduitRepository prodRepo = new ProduitRepository(connexion);
var compositKey = new CompositeKey <int, int>();
compositKey.PK1 = PFRepo.GetOne(idPF).Id;
compositKey.PK2 = prodRepo.GetOne(idProd).Id;
var result = VenteRepo.GetOne(compositKey);
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Vente with ID: " + compositKey.ToString() + "not found"));
}
}
public HttpResponseMessage Get(DateTime debut, DateTime fin, int idPF)
{
ProduitRepository ProdRepo = new ProduitRepository(connexion);
VendsRepository venteRepo = new VendsRepository(connexion);
var result = ProdRepo.GetByDate(debut, fin, idPF);
if (result == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "prod with ID: " + result.ToString() + "not found"));
}
var ventes = new Ventes();
foreach (var item in venteRepo.GetAll())
{
int month = item.DateVente.Month;
string prodName = ProdRepo.GetOne(item.IdProduit).NomProduit;
double prodPrix = ProdRepo.GetOne(item.IdProduit).Prix;
switch (prodName)
{
case "Marc": ventes.MarcCollectes[month] += prodPrix;
break;
case "Kit": ventes.Kit[month] += prodPrix;
break;
case "Fungipop": ventes.Fungipop[month] += prodPrix;
break;
default:
break;
}
}
var productions = new Productions();
foreach (var item in venteRepo.GetAll())
{
int month = item.DateVente.Month;
string prodName = ProdRepo.GetOne(item.IdProduit).NomProduit;
double prodQuantite = ProdRepo.GetOne(item.IdProduit).Quantite;
switch (prodName)
{
case "Marc":
productions.Pleurottes[month] += prodQuantite;
break;
case "Kit":
productions.Pieds[month] += prodQuantite;
break;
case "Fungipop":
productions.Panicaults[month] += prodQuantite;
break;
default:
break;
}
}
var finalResult = new VenteEtProduction()
{
ventes = ventes, productions = productions
};
return(Request.CreateResponse(HttpStatusCode.OK, finalResult));
}
