public IActionResult AddBeer(BeerFormViewModel addedBeer)
{
BeerBDD beerBDD = new BeerBDD();
addedBeer.Categories = populateCategorie();
addedBeer.Gammes = populateGamme();
IActionResult retour = null;
if (ModelState.IsValid)
{
Beer beer = new Beer();
beer.Identifiant = addedBeer.Identifiant;
beer.Libelle = addedBeer.Libelle;
beer.DateProduction = addedBeer.DateProduction;
beer.TauxAlcoolemie = float.Parse(addedBeer.TauxAlcoolemie);
beer.IdentifiantCategorie = addedBeer.IdentifiantCategorie;
beer.IdentifiantGamme = addedBeer.IdentifiantGamme;
beer.Commentaire = addedBeer.Commentaire;
bool isOK = beerBDD.Insert(beer);
retour = RedirectToAction("Index");
}
else
{
retour = View(addedBeer);
}
return(retour);
}
public IActionResult Edit(BeerFormViewModel modifiedBeer)
{
BeerBDD beerBDD = new BeerBDD();
IActionResult retour = null;
if (ModelState.IsValid)
{
Beer beer = new Beer();
beer.Identifiant = modifiedBeer.Identifiant;
beer.Libelle = modifiedBeer.Libelle;
beer.DateProduction = modifiedBeer.DateProduction;
beer.TauxAlcoolemie = float.Parse(modifiedBeer.TauxAlcoolemie);
beer.IdentifiantCategorie = modifiedBeer.IdentifiantCategorie;
beer.IdentifiantGamme = modifiedBeer.IdentifiantGamme;
beer.Commentaire = modifiedBeer.Commentaire;
bool isOK = beerBDD.Update(beer);
retour = RedirectToAction("Index");
}
else
{
retour = View(modifiedBeer);
}
return(retour);
}
public IActionResult DeleteConfirmation(int id)
{
BeerBDD beerBDD = new BeerBDD();
beerBDD.Delete(id);
return(RedirectToAction("Index"));
}
private void DeleteButton_Click(object sender, EventArgs e)
{
BeerBDD beerBDD = new BeerBDD();
DialogResult d = MessageBox.Show("Etes vous sur de supprimer ?", "Supression", MessageBoxButtons.YesNo);
if (d == DialogResult.Yes)
{
beerBDD.Delete(int.Parse(this.IDLabel.Text));
this.RefreshBeerListBox();
}
}
private void ModifierButton_Click(object sender, EventArgs e)
{
Beer b = beerUserControl.GetBeer();
b.Identifiant = Int32.Parse(this.IDLabel.Text);
BeerBDD contactBDD = new BeerBDD();
bool nbLignes = contactBDD.Update(b);
if (nbLignes)
{
this.RefreshBeerListBox();
}
}
public IActionResult Index()
{
CategorieBDD categorieBDD = new CategorieBDD();
List <Categorie> categories = categorieBDD.GetAll();
GammeBDD gammeBDD = new GammeBDD();
List <Gamme> gammes = gammeBDD.GetAll();
BeerBDD beerBDD = new BeerBDD();
List <Beer> beers = beerBDD.GetAll();
BeersViewModel model = new BeersViewModel();
model.Beers = beers;
model.Categories = categories;
model.Gammes = gammes;
return(View(model));
}
private void RefreshBeerListBox()
{
int index = this.BeerListBox.SelectedIndex;
BeerBDD beerBDD = new BeerBDD();
List <Beer> beers = beerBDD.GetAll();
this.BeerListBox.ValueMember = "Identifiant";
this.BeerListBox.DisplayMember = "Libelle";
this.BeerListBox.DataSource = beers;
if (index < beers.Count - 1 && index != -1)
{
this.BeerListBox.SelectedIndex = index;
}
}
public IActionResult Delete(int id)
{
BeerBDD beerBDD = new BeerBDD();
Beer beer = beerBDD.Get(id);
CategorieBDD categorieBDD = new CategorieBDD();
Categorie categorie = categorieBDD.Get(beer.IdentifiantCategorie);
GammeBDD gammeBDD = new GammeBDD();
Gamme gamme = gammeBDD.Get(beer.IdentifiantGamme);
BeerDeleteViewModel model = new BeerDeleteViewModel();
model.Beer = beer;
model.Categorie = categorie;
model.Gamme = gamme;
return(View(model));
}
private void ValiderButton_Click(object sender, EventArgs e)
{
BeerBDD beerBDD = new BeerBDD();
Beer b = this.beerUserControl.GetBeer();
this.DialogResult = DialogResult.OK;
try
{
beerBDD.Insert(b);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.DialogResult = DialogResult.Cancel;
}
this.Close();
}
public IActionResult Edit(int id)
{
BeerBDD beerBDD = new BeerBDD();
Beer beer = beerBDD.Get(id);
BeerFormViewModel beerModel = new BeerFormViewModel();
beerModel.Identifiant = beer.Identifiant;
beerModel.Libelle = beer.Libelle;
beerModel.DateProduction = beer.DateProduction;
beerModel.TauxAlcoolemie = beer.TauxAlcoolemie.ToString();
beerModel.IdentifiantCategorie = beer.IdentifiantCategorie;
beerModel.IdentifiantGamme = beer.IdentifiantGamme;
beerModel.Commentaire = beer.Commentaire;
beerModel.Categories = populateCategorie();
beerModel.Gammes = populateGamme();
return(View(beerModel));
}
