public async Task <ArticleFamilleEntity> UpdateAsync(ArticleFamilleEntity item)
{
_context.Update(item);
await _context.SaveChangesAsync();
return(item);
}
public async Task <ArticleFamilleEntity> AddAsync(ArticleFamilleEntity item)
{
_context.ArticleFamilleEntities.Add(item);
await _context.SaveChangesAsync();
return(item);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Code,Libelle")] ArticleFamilleEntity articleFamille)
{
if (id != articleFamille.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
await _service.Update(articleFamille);
}
catch (DbUpdateConcurrencyException)
{
if (!ArticleFamilleExists(articleFamille.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(articleFamille));
}
public async Task <ArticleFamilleEntity> Update(ArticleFamilleEntity item)
{
if (!_repository.Exist(item.Id))
{
throw new NotFoundException(ExceptionMessageUtil.NOT_FOUND);
}
return(await _repository.UpdateAsync(item));
}
public async Task <ArticleFamilleEntity> DeleteAsync(ArticleFamilleEntity item)
{
item.IsDeleted = true;
_context.Update(item);
await _context.SaveChangesAsync();
return(item);
}
public async Task <IActionResult> Create([Bind("Id,Code,Libelle")] ArticleFamilleEntity articleFamille)
{
if (ModelState.IsValid)
{
var item = await _service.Add(articleFamille);
return(RedirectToAction(nameof(Index)));
}
return(View(articleFamille));
}
public async Task <ArticleFamilleEntity> Add(ArticleFamilleEntity item)
{
return(await _repository.AddAsync(item));
}
public static void Initialize(ApplicationDbContext context)
{
// Seed statuts de commande
if (!context.NomCommandeStatutEntities.Any())
{
var commande_status = new NomCommandeStatutEntity[]
{
new NomCommandeStatutEntity {
Code = "P", Libelle = "Panier"
},
new NomCommandeStatutEntity {
Code = "V", Libelle = "Livrée"
},
new NomCommandeStatutEntity {
Code = "A", Libelle = "En attente de préparation"
},
new NomCommandeStatutEntity {
Code = "L", Libelle = "En cours de livraison"
},
new NomCommandeStatutEntity {
Code = "X", Libelle = "Annulée"
}
};
foreach (NomCommandeStatutEntity s in commande_status)
{
context.NomCommandeStatutEntities.Add(s);
}
context.SaveChanges();
}
// Seed statuts de commande fournisseur
if (!context.NomCommandeFournisseurStatutEntities.Any())
{
var commande_fournisseur_status = new NomCommandeFournisseurStatutEntity[]
{
new NomCommandeFournisseurStatutEntity {
Code = "C", Libelle = "Création"
},
new NomCommandeFournisseurStatutEntity {
Code = "T", Libelle = "Transmise au fournisseur"
},
new NomCommandeFournisseurStatutEntity {
Code = "R", Libelle = "Réceptionnée"
},
new NomCommandeFournisseurStatutEntity {
Code = "A", Libelle = "Annulation"
}
};
foreach (NomCommandeFournisseurStatutEntity s in commande_fournisseur_status)
{
context.NomCommandeFournisseurStatutEntities.Add(s);
}
context.SaveChanges();
}
// Seed statuts des inventaires
if (!context.NomInventaireStatutEntities.Any())
{
var inventaire_status = new NomInventaireStatutEntity[]
{
new NomInventaireStatutEntity {
Code = "E", Libelle = "En cours"
},
new NomInventaireStatutEntity {
Code = "T", Libelle = "Terminé"
}
};
foreach (NomInventaireStatutEntity s in inventaire_status)
{
context.NomInventaireStatutEntities.Add(s);
}
context.SaveChanges();
}
// ARTICLE FAMILLE
if (!context.ArticleFamilleEntities.Any())
{
var article_familles = new ArticleFamilleEntity[]
{
new ArticleFamilleEntity {
Code = "MOB", Libelle = "Mobilier"
},
new ArticleFamilleEntity {
Code = "DECO", Libelle = "Décoration"
},
new ArticleFamilleEntity {
Code = "ELEC", Libelle = "Electronique"
}
};
foreach (ArticleFamilleEntity s in article_familles)
{
context.ArticleFamilleEntities.Add(s);
}
context.SaveChanges();
}
// TVA
if (!context.NomTypeTVAEntities.Any())
{
var type_tvas = new NomTypeTVAEntity[]
{
new NomTypeTVAEntity {
Code = "DOUZE", Libelle = "Douze", Taux = 12M
},
new NomTypeTVAEntity {
Code = "VINGT", Libelle = "Vingt", Taux = 20M
},
new NomTypeTVAEntity {
Code = "ZERO", Libelle = "Zero", Taux = 0M
}
};
foreach (NomTypeTVAEntity s in type_tvas)
{
context.NomTypeTVAEntities.Add(s);
}
context.SaveChanges();
}
// ADRESSES (pour fournisseur, notamment)
if (!context.AdresseEntities.Any())
{
var adresses = new AdresseEntity[]
{
/*
* Champ1 = "", Champ2 = "", CodePostal = "", Ville = "", Pays = ""
*/
new AdresseEntity {
Champ1 = "1 bld de Strasbourg", Champ2 = "", CodePostal = "44000", Ville = "NANTES", Pays = "FRANCE"
},
new AdresseEntity {
Champ1 = "12 rue de la Foret", Champ2 = "", CodePostal = "49500", Ville = "CRESSON", Pays = "FRANCE"
}
};
foreach (AdresseEntity s in adresses)
{
context.AdresseEntities.Add(s);
}
context.SaveChanges();
}
// FOURNISSEUR
if (!context.FournisseurEntities.Any())
{
var id_adresse_A = context.AdresseEntities.Where(f => f.Champ1 == "1 bld de Strasbourg").First().Id;
var id_adresse_B = context.AdresseEntities.Where(f => f.Champ1 == "12 rue de la Foret").First().Id;
var fournisseurs = new FournisseurEntity[]
{
new FournisseurEntity {
Raison = "Meubles SARL",
Telephone = "+33622657991",
Email = "*****@*****.**",
AdresseId = id_adresse_A
},
new FournisseurEntity {
Raison = "Boiserie and Co.",
Telephone = "+33801223040",
Email = "*****@*****.**",
AdresseId = id_adresse_B
},
};
foreach (FournisseurEntity s in fournisseurs)
{
context.FournisseurEntities.Add(s);
}
context.SaveChanges();
}
// ARTICLES
if (!context.ArticleEntities.Any())
{
var id_fournisseur_A = context.FournisseurEntities.Where(f => f.Raison == "Meubles SARL").First().Id;
var id_fournisseur_B = context.FournisseurEntities.Where(f => f.Raison == "Boiserie and Co.").First().Id;
var articles = new ArticleEntity[]
{
new ArticleEntity {
Code = "CHA",
Libelle = "Chaise",
PrixUnitaire = 20,
Threshold = 10,
ArticleFamilleId = context.ArticleFamilleEntities.Where(f => f.Code == "MOB").First().Id,
NomTypeTVAId = context.NomTypeTVAEntities.Where(f => f.Code == "VINGT").First().Id,
FournisseurId = id_fournisseur_A
},
new ArticleEntity {
Code = "TAB",
Libelle = "Table",
PrixUnitaire = 150,
Threshold = 5,
ArticleFamilleId = context.ArticleFamilleEntities.Where(f => f.Code == "MOB").First().Id,
NomTypeTVAId = context.NomTypeTVAEntities.Where(f => f.Code == "DOUZE").First().Id,
FournisseurId = id_fournisseur_B
},
new ArticleEntity {
Code = "LUX",
Libelle = "Lampe",
PrixUnitaire = 12.5M,
Threshold = 30,
ArticleFamilleId = context.ArticleFamilleEntities.Where(f => f.Code == "DECO").First().Id,
NomTypeTVAId = context.NomTypeTVAEntities.Where(f => f.Code == "ZERO").First().Id,
FournisseurId = id_fournisseur_A
},
};
foreach (ArticleEntity s in articles)
{
context.ArticleEntities.Add(s);
}
context.SaveChanges();
}
// STOCK :: initialise AU MOINS a 0, si par exemple l'Article provient du Seeding
List <StockEntity> stocks = new List <StockEntity>();
foreach (var article in context.ArticleEntities)
{
if (!context.StockEntities.Where(w => w.ArticleID == article.Id).Any())
{
var stock = new StockEntity();
stock.ArticleID = article.Id;
stock.Quantite = article.Threshold;
stocks.Add(stock);
}
}
foreach (var item in stocks)
{
context.StockEntities.Add(item);
}
if (stocks.Any())
{
context.SaveChanges();
}
}