/// <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));
}
