public async Task <IActionResult> PutCategorie(int id, CategorieModel categorie)
{
if (id != categorie.Id)
{
return(BadRequest());
}
_context.Entry(categorie).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CategorieExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IHttpActionResult GetCategorie(int id)
{
Categorie categorie = db.Categorie.Find(id);
if (categorie == null)
{
return(NotFound());
}
CategorieModel categorieModel = new CategorieModel();
categorieModel.ID = categorie.ID;
categorieModel.Titre = categorie.Titre;
List <ViewArticleJournalist> viewArticleJournalists = new List <ViewArticleJournalist>();
foreach (var a in categorie.Article)
{
ViewArticleJournalist article = new ViewArticleJournalist();
article.ID = a.ID;
article.Titre = a.Titre;
article.body = a.Body;
article.Date = a.Date;
article.img = a.Img;
article.Journalistes = a.Journalistes.Nom;
article.Categorie = a.CategorieID;
viewArticleJournalists.Add(article);
}
categorieModel.Article = viewArticleJournalists;
return(Ok(categorieModel));
}
public async Task <ActionResult <CategorieModel> > PostCategorie(CategorieModel categorie)
{
_context.Categories.Add(categorie);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCategorie", new { id = categorie.Id }, categorie));
}
public bool AddCategorie(CategorieModel cat)
{
try
{
if (!DbConnection.IsConnected())
{
DbConnection.InitDb();
}
SqlCommand cmd = new SqlCommand("INSERT INTO Categorie (Nom) VALUES(@title)",
DbConnection.connection);
cmd.Parameters.AddWithValue("@title", cat.Nom);
int nbLignes = cmd.ExecuteNonQuery();
if (nbLignes != 0)
{
return(true);
}
return(false);
}
catch (Exception e)
{
throw;
}
}
public CategorieModel GetCategoryById(int id)
{
SqlDataReader reader = null;
try
{
CategorieModel category = null;
if (!DbConnection.IsConnected())
{
DbConnection.InitDb();
}
SqlCommand cmd = new SqlCommand("SELECT * FROM Categorie WHERE (Id = @id)", DbConnection.connection);
cmd.Parameters.AddWithValue("@id", id);
reader = cmd.ExecuteReader();
if (reader.Read())
{
category = new CategorieModel {
Id = id, Nom = reader.GetString(1)
};
}
reader.Close();
return(category);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
reader.Close();
return(null);
}
}
public ActionResult Create(CategorieModel cm)
{
Categorie c = new Categorie()
{
Nom = cm.Nom
};
// List<Categorie> listcat = Session["Categories"] as List<Categorie>;
//if (listcat == null)
//{
// listcat = new List<Categorie>();
//}
try
{
sc.Add(c);
// TODO: Add insert logic here
sc.Commit();
return(RedirectToAction("ListeCategorie"));
}
catch
{
return(View());
}
}
public static Categorie CategorieModelTOCategorie(CategorieModel r)
{
return(new Categorie()
{
IdCategorie = r.IdCategorie,
TypeCategorie = r.TypeCategorie
});
}
// GET: Categorie/Create
public ActionResult Create()
{
CategorieModel cm = new CategorieModel();
//pour recupérer un champ spécifique Select(c=>c.name)
return(View(cm));
}
private void button1_Click(object sender, EventArgs e)
{
var newFilm = new CategorieModel
{
Nom = this.textBoxCat.Text,
};
if (_categorieService.AddCategorie(newFilm))
{
MessageBox.Show("Categorie ajouté avec succès.", "Succès ajout", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public IActionResult Update(CategorieModel model)
{
if (ModelState.IsValid)
{
this._context.Categories.Update(model);
_context.SaveChanges();
return(Redirect($"Categorie/Details/{model.Id}"));
}
else
{
return(Problem("erreur insertion db", "Error", 0, "Erreur"));
}
}
public IActionResult Create(string name)
{
var model = new CategorieModel();
model.Id = this.Id;
model.Name = name;
if (ModelState.IsValid)
{
_context.Categories.Add(model);
_context.SaveChanges();
return(Redirect($"Categorie/Details/{model.Id}"));
}
else
{
return(Problem("erreur insertion db", "Error", 0, "Erreur"));
}
}
public IEnumerable <CategorieModel> GetAllCategories()
{
var categories = new List <CategorieModel>();
SqlDataReader reader = null;
try
{
if (!DbConnection.IsConnected())
{
DbConnection.InitDb();
}
SqlCommand cmd = new SqlCommand("SELECT * FROM Categorie", DbConnection.connection);
reader = cmd.ExecuteReader();
while (reader.Read())
{
var category = new CategorieModel
{
Id = reader.GetInt32(0),
Nom = reader.GetString(1),
};
categories.Add(category);
}
reader.Close();
return(categories);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
reader.Close();
return(null);
}
}
public CategoriesChangeWindowViewModel(CategorieModel cat)
{
MeaningCat = cat;
name = MeaningCat.Categorie;
}
