public ActionResult Create([Bind(Include = "idElement,description,numero,motClef,commentaire,idCompetence")] ElementCompetence elementCompetence)
{
AssignNo(elementCompetence);
Trim(elementCompetence);
if (ModelState.IsValid)
{
db.ElementCompetence.Add(elementCompetence);
db.SaveChanges();
return(RedirectToAction("Create", "CriterePerformance", new { idElement = elementCompetence.idElement }));
}
return(View(elementCompetence));
}
public ActionResult Modifier(int?idElement)
{
if (idElement == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ElementCompetence elementCompetence = _db.ElementCompetence.Find(idElement);
if (elementCompetence == null)
{
return(HttpNotFound());
}
return(View(elementCompetence));
}
private void AssignerNo(ElementCompetence elementCompetence)
{
var dernierNo = 0;
var requete = (from tableElementCompetence in _db.ElementCompetence
where tableElementCompetence.IdCompetence == elementCompetence.IdCompetence
select tableElementCompetence.Numero);
if (requete.Any())
{
dernierNo = requete.Max();
}
elementCompetence.Numero = dernierNo + 1;
}
private void AssignNo(ElementCompetence elementCompetence)
{
int lastNo = 0;
IQueryable <int> query = (from ec in db.ElementCompetence
where ec.idCompetence == elementCompetence.idCompetence
select ec.numero);
IEnumerable <int> list = query;
if (query.Count() > 0)
{
lastNo = query.Max();
}
elementCompetence.numero = lastNo + 1;
}
public ActionResult Modifier([Bind(Include = "idElement,description,numero,motClef,commentaire,idCompetence")] ElementCompetence elementCompetence)
{
Trim(elementCompetence);
if (ModelState.IsValid)
{
this.AddToastMessage("Confirmation de la modificaion", "L'élément de compétence " + '\u0022' + elementCompetence.Description + '\u0022' + ", a bien été modifié.", ToastType.Success);
_db.Entry(elementCompetence).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Creation", "CriterePerformance", new { elementCompetence.IdElement }));
}
else
{
this.AddToastMessage("Confirmation de la modificaion", "L'élément de compétence " + '\u0022' + elementCompetence.Description + '\u0022' + ", n'a pas pus être modifié.", ToastType.Error);
}
return(View(elementCompetence));
}
private ActionResult Move(int v, int idElement)
{
ElementCompetence elementCompetence = db.ElementCompetence.Find(idElement);
IQueryable <ElementCompetence> query = (from cp in db.ElementCompetence
where cp.idCompetence == elementCompetence.idCompetence && cp.numero == elementCompetence.numero + v
select cp);
if (query.Count() > 0)
{
ElementCompetence cpAutre = query.First();
elementCompetence.numero += v;
cpAutre.numero -= v;
db.SaveChanges();
}
return(RedirectToAction("Order", new { idCompetence = elementCompetence.idCompetence }));
}
public ActionResult DeleteConfirmed(int idElement)
{
var PlanCadreElement = from pc in db.PlanCadreElement
where pc.idElement == idElement
select pc;
ElementCompetence elementCompetence = db.ElementCompetence.Find(idElement);
if (PlanCadreElement.Count() == 0)
{
db.CriterePerformance.RemoveRange(elementCompetence.CriterePerformance);
db.ElementCompetence.Remove(elementCompetence);
AjustNo(elementCompetence);
db.SaveChanges();
}
return(RedirectToAction("Info", "EnonceCompetence", new { idCompetence = elementCompetence.idCompetence }));
}
public ActionResult Create(int?idElement)
{
if (idElement == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ElementCompetence elementCompetence = db.ElementCompetence.Find(idElement);
if (elementCompetence == null)
{
return(HttpNotFound());
}
CriterePerformance criterePerformance = new CriterePerformance();
criterePerformance.ElementCompetence = elementCompetence;
criterePerformance.idElement = elementCompetence.idElement;
return(View(criterePerformance));
}
public ActionResult Create(int?idCompetence)
{
if (idCompetence == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnonceCompetence enonceCompetence = db.EnonceCompetence.Find(idCompetence);
if (enonceCompetence == null)
{
return(HttpNotFound());
}
ElementCompetence elementCompetence = new ElementCompetence();
elementCompetence.EnonceCompetence = enonceCompetence;
elementCompetence.idCompetence = enonceCompetence.idCompetence;
return(View(elementCompetence));
}
public ActionResult _PartialList(int?idElement)
{
ElementCompetence elementCompetence = db.ElementCompetence.Find(idElement);
return(PartialView(elementCompetence.CriterePerformance.OrderBy(cp => cp.numero)));
}
protected override bool isRCPOwner(string username, int id)
{
ElementCompetence elementCompetence = db.ElementCompetence.Find(id);
return(db.AccesProgramme.Any(e => e.codeProgramme == elementCompetence.EnonceCompetence.DevisMinistere.EnteteProgramme.codeProgramme));
}
