public IHttpActionResult MyPublishUpdate([FromBody] PUBLICATION publish, int id) { using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.PUBLICATIONS.FirstOrDefault(x => x.Id == id); if (result == null) { return(BadRequest()); } result.PubContent = publish.PubContent; result.PubTitle = publish.PubTitle; result.PubModifiedDate = DateTime.Now; result.PubSefLink = publish.PubSefLink; int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult AddMyPublish([FromBody] PUBLICATION publish) { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { publish.PubUserId = id; db.PUBLICATIONS.Add(publish); int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public ActionResult SupprimerPublication(int?id) { PUBLICATION pub = null; try { if (id == null) { throw new ArgumentNullException("id"); } pub = db.GetPublication(id).First(); } catch { TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.ERREUR, Resources.Publication.idPublicationInvalide); } if (pub != null) { return(View(pub)); } return(RedirectToAction("Publications", "Sectoriel")); }
public ActionResult DeleteConfirmed(int id) { PUBLICATION pUBLICATION = db.PUBLICATIONs.Find(id); db.PUBLICATIONs.Remove(pUBLICATION); db.SaveChanges(); return(RedirectToAction("Index")); }
// POST api/values public HttpResponseMessage Post(TravelEditModel model) { if (HttpContext.Current.Request.Headers["Authorization"] == null) { throw new HttpResponseException(HttpStatusCode.Unauthorized); } else { try { TRAVEL travelBdd = new TRAVEL(); travelBdd.ID_ARRIVALAGENCY = model.ArrivalAgency.Id; travelBdd.ID_DEPARTUREAGENCY = model.DepartureAgency.Id; travelBdd.ARRIVALHOUR = model.ArrivalTime; travelBdd.DEPARTUREHOUR = model.DepartureTime; travelBdd.CAPACITY = model.Capacity; PUBLICATION publicationBdd = new PUBLICATION(); string tokenString = HttpContext.Current.Request.Headers["Authorization"]; UserManager userManager = new UserManager(); publicationBdd.ID_USER = userManager.getUserFromSession(new Guid(tokenString)); publicationBdd.TITLE = model.Publication.Title; publicationBdd.DESCRIPTION = model.Publication.Description; publicationBdd.ID_GROUP = 1; publicationBdd.ID_CATEGORY = 1; publicationBdd.DATE_TIME_CREATION = DateTime.Now.AddHours(1); manager.add(travelBdd, publicationBdd); return(new HttpResponseMessage() { Content = new JsonContent(new { Success = true, //error Message = "Success" //return exception }) }); } catch (Exception e) { return(new HttpResponseMessage() { Content = new JsonContent(new { Success = false, //error Message = "Exception with token :" + HttpContext.Current.Request.Headers["Authorization"] + " Error :" + e.ToString() //return exception }) }); } } }
public ActionResult Edit([Bind(Include = "ID_PUBLICATION,ID_USER,TITLE,DESCRIPTION,ID_CATEGORY,ID_GROUP")] PUBLICATION pUBLICATION) { if (ModelState.IsValid) { db.Entry(pUBLICATION).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_CATEGORY = new SelectList(db.CATEGORies, "ID_CATEGORY", "TITLE", pUBLICATION.ID_CATEGORY); ViewBag.ID_GROUP = new SelectList(db.GROUPs, "ID_GROUP", "LABEL", pUBLICATION.ID_GROUP); ViewBag.ID_USER = new SelectList(db.USERs, "ID_USER", "FIRST_NAME", pUBLICATION.ID_USER); return(View(pUBLICATION)); }
// GET: Publication/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PUBLICATION pUBLICATION = db.PUBLICATIONs.Find(id); if (pUBLICATION == null) { return(HttpNotFound()); } return(View(pUBLICATION)); }
public void remove(PUBLICATION publication) { try { var Context = new connext_dbEntities(); Context.PUBLICATIONs.Remove(publication); Context.SaveChanges(); } catch (Exception ex) { #if DEBUG throw new Exception("Impossible de supprimer le lieu." + Environment.NewLine + ex.StackTrace); #else throw new Exception("Impossible de supprimer le lieu."); #endif } }
// GET: Publication/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PUBLICATION pUBLICATION = db.PUBLICATIONs.Find(id); if (pUBLICATION == null) { return(HttpNotFound()); } ViewBag.ID_CATEGORY = new SelectList(db.CATEGORies, "ID_CATEGORY", "TITLE", pUBLICATION.ID_CATEGORY); ViewBag.ID_GROUP = new SelectList(db.GROUPs, "ID_GROUP", "LABEL", pUBLICATION.ID_GROUP); ViewBag.ID_USER = new SelectList(db.USERs, "ID_USER", "FIRST_NAME", pUBLICATION.ID_USER); return(View(pUBLICATION)); }
public void add(TRAVEL travel, PUBLICATION publication) { try { var Context = new connext_dbEntities(); publication.TRAVELs.Add(travel); Context.PUBLICATIONs.Add(publication); Context.SaveChanges(); } catch (Exception ex) { #if DEBUG throw new Exception("Impossible de modifier le covoiturage." + Environment.NewLine + ex.StackTrace); #else throw new Exception("Impossible de modifier le covoiturage."); #endif } }
public ActionResult ObtenirPublication(int?id) { PUBLICATION pub = null; try { if (id == null) { throw new ArgumentNullException("id"); } pub = db.GetPublication(id).First(); } catch { TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.ERREUR, Resources.Publication.idPublicationInvalide); } if (pub != null) { if (User.IsInRole("admin") || ((List <SECTEUR>)Session["lstSect"]).Any(s => s.ID == pub.IDSECTEUR)) { var cd = new ContentDisposition { FileName = pub.NOMFICHIERORIGINAL, Inline = false }; Response.AppendHeader("Content-Disposition", cd.ToString()); try { return(File(IOFile.ReadAllBytes(Fichiers.CheminEnvois(pub.NOMFICHIERSERVEUR)), pub.NOMFICHIERORIGINAL)); } catch (IOException) { TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.ERREUR, Resources.Publication.publicationErreurFichier); } } else { TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.ERREUR, Resources.Publication.accesRefuse); } } return(RedirectToAction("Publications", "Sectoriel")); }
public ActionResult AjoutPublication(PUBLICATION envoiPubli) { if (ModelState.IsValid) { try { HttpPostedFileBase fichier = envoiPubli.fichier; string mimetype = fichier.ContentType; string nomOriginal = Fichiers.GetNomOriginal(fichier.FileName); string nomServeur = Fichiers.GetNomServeur(fichier.FileName); fichier.SaveAs(Fichiers.CheminEnvois(nomServeur)); ObjectParameter idNouvPub = new ObjectParameter("idpub", typeof(int)); db.AjouterPublication(envoiPubli.TITRE, envoiPubli.DESCRIPTION, envoiPubli.IDSECTEUR, envoiPubli.IDSUJET, nomOriginal, nomServeur, mimetype, WebSecurity.CurrentUserId, idNouvPub); List <String> motsCles = envoiPubli.TITRE.Split(new Char[] { ' ' }).ToList(); if (!String.IsNullOrEmpty(envoiPubli.motcles)) { motsCles.AddRange(envoiPubli.motcles.Split(new Char[] { ' ' })); } db.UpdateMotsClesPub((int)idNouvPub.Value, MotsCles.TraiterMotsCles(motsCles)); TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.SUCCES, Resources.Publication.publicationAjoutee); return(RedirectToAction("Publications", "Sectoriel")); } catch (Exception ex) { TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.ERREUR, Resources.Publication.publicationErreur + " (" + ex.GetType() + ")"); } } List <GetSecteurs_Result> listeSecteurs = db.GetSecteursLocalises(Session); List <GetSujetsPublication_Result> listeSujetsPub = db.GetSujetsPublicationLocalises(Session).ToList(); ViewData[Constantes.CLE_SECTEURS] = listeSecteurs; ViewData[Constantes.CLE_SUJETSPUBLICATION] = listeSujetsPub; return(View(envoiPubli)); }
public ActionResult SupprimerPublication(int?id, string confirmer, string annuler) { if (!String.IsNullOrEmpty(confirmer) && String.IsNullOrEmpty(annuler)) { PUBLICATION pub = null; try { if (id == null) { throw new ArgumentNullException("id"); } pub = db.GetPublication(id).First(); } catch { TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.ERREUR, Resources.Publication.idPublicationInvalide); } if (pub != null) { db.SupprimerPublication(id); string cheminEnvoi = Fichiers.CheminEnvois(pub.NOMFICHIERSERVEUR); if (IOFile.Exists(cheminEnvoi)) { IOFile.Delete(cheminEnvoi); } TempData[Constantes.CLE_MSG_RETOUR] = new Message(Message.TYPE_MESSAGE.SUCCES, Resources.Publication.publicationSupprimee); } } return(RedirectToAction("Publications", "Sectoriel")); }