/// <summary> /// Validation du panier /// </summary> /// <param name="contract">numéro de contrat</param> /// <returns></returns> public ActionResult SaveAll(string contract) { //recuperation du user actif string user = System.Web.HttpContext.Current.User.Identity.Name.ToString(); //generation de numéro de demande DateTime datee = DateTime.Now; sr_ref = (System.Web.HttpContext.Current.User.Identity.Name.ToString().Remove(0, 5)) + "-" + datee.ToString("yyyy-MM-dd") + "-" + datee.ToString("HH:mm"); sr_ref = sr_ref.Replace(':', '-'); fileName = sr_ref; try { //recuperation de l'id user int fK_ID_actors = (db.tbl_607_actors.Where(u => u.id_uid == user)).First().id; //recuperation de l'id contrat int contractID = db.tbl_607_order.Where(t => t.order_number == contract).Select(t => t.ID).First(); //sauvegarde de shipping request tbl_607_shipping_request tbl_607_Shipping_Request = new tbl_607_shipping_request(); tbl_607_Shipping_Request.request_date = DateTime.Now; tbl_607_Shipping_Request.FK_ID_actors = fK_ID_actors; tbl_607_Shipping_Request.FK_order = contractID; tbl_607_Shipping_Request.shipping_request_ref = sr_ref; db.tbl_607_shipping_request.Add(tbl_607_Shipping_Request); db.SaveChanges(); //sauvegarde //recuperation de l'id de shipping request int idShippingRequest = db.tbl_607_shipping_request.Where(t => t.shipping_request_ref == sr_ref).Select(t => t.ID).First(); //sauvegarde de shipping request details tbl_607_shipping_request_details tbl_607_Shipping_Request_Details = new tbl_607_shipping_request_details(); foreach (KeyValuePair <int, int> value in partialSave) { tbl_607_Shipping_Request_Details.FK_ID_order_details = value.Key; tbl_607_Shipping_Request_Details.shipping_quantity = value.Value; tbl_607_Shipping_Request_Details.reception_quantity = 0; tbl_607_Shipping_Request_Details.FK_shipping_request = idShippingRequest; db.tbl_607_shipping_request_details.Add(tbl_607_Shipping_Request_Details); db.SaveChanges(); //sauvegarde } return(Content(sr_ref)); } catch (Exception ex) { //generation de la vue affichage erreur return(RedirectToAction("Index", "Ooops", new { message = ex })); } }
/// <summary> /// Affichage de la vue de suppression d'une commande /// </summary> /// <param name="id">id de la commande sélectionnée</param> /// <returns>vue suppression</returns> // GET: Orders/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_607_shipping_request tbl_607_shipping_request = db.tbl_607_shipping_request.Find(id); if (tbl_607_shipping_request == null) { return(HttpNotFound()); } return(View(tbl_607_shipping_request)); }
public ActionResult DeleteConfirmed(int id) { tbl_607_shipping_request tbl_607_shipping_request = db.tbl_607_shipping_request.Find(id); db.tbl_607_shipping_request.Remove(tbl_607_shipping_request); try { db.SaveChanges(); return(RedirectToAction("Index")); } catch (DbEntityValidationException ex) { string s = ex.Message; return(RedirectToAction("../Ooops", new { message = s })); } }
/// <summary> /// Affichage de la vue d'édition d'une commande /// </summary> /// <param name="id">id de la commande sélectionnée</param> /// <returns>vue d'édition</returns> // GET: Orders/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_607_shipping_request tbl_607_shipping_request = db.tbl_607_shipping_request.Find(id); if (tbl_607_shipping_request == null) { return(HttpNotFound()); } ViewBag.FK_ID_actors = new SelectList(db.tbl_607_actors, "id", "first_name", tbl_607_shipping_request.FK_ID_actors); ViewBag.FK_order = new SelectList(db.tbl_607_order, "ID", "order_number", tbl_607_shipping_request.FK_order); return(View(tbl_607_shipping_request)); }
public ActionResult Edit([Bind(Include = "ID,request_date,FK_order,FK_ID_actors")] tbl_607_shipping_request tbl_607_shipping_request) { if (ModelState.IsValid) { db.Entry(tbl_607_shipping_request).State = EntityState.Modified; try { db.SaveChanges(); return(RedirectToAction("Index")); } catch (DbEntityValidationException ex) { string s = ex.Message; return(RedirectToAction("../Ooops", new { message = s })); } } ViewBag.FK_ID_actors = new SelectList(db.tbl_607_actors, "id", "first_name", tbl_607_shipping_request.FK_ID_actors); ViewBag.FK_order = new SelectList(db.tbl_607_order, "ID", "order_number", tbl_607_shipping_request.FK_order); return(View(tbl_607_shipping_request)); }