/// <summary> /// Affichage de la vue suppression de la bouteille selectionnée /// </summary> /// <param name="id">id de la bouteille selectionnée</param> /// <returns>vue suppression</returns> public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_607_bottle tbl_607_bottle = db.tbl_607_bottle.Find(id); if (tbl_607_bottle == null) { return(HttpNotFound()); } return(View(tbl_607_bottle)); }
public ActionResult DeleteConfirmed(int id) { tbl_607_bottle tbl_607_bottle = db.tbl_607_bottle.Find(id); var join_bottle = db.tbl_607_join_bottle_gaz.Where(t => t.FK_ID_bottle == id).ToList(); foreach (var item in join_bottle) { db.tbl_607_join_bottle_gaz.Remove(item); db.SaveChanges(); } db.tbl_607_bottle.Remove(tbl_607_bottle); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// Validation du destockage d'une bouteille /// </summary> /// <param name="contiBottleNumber"></param> /// <returns>génération du mail</returns> public ActionResult ValidDestock(string contiBottleNumber) { try { var idDestock = db.tbl_607_location.Where(t => t.bottle_location == "DESTOCK").Select(t => t.ID).FirstOrDefault(); var idStock = db.tbl_607_location.Where(t => t.bottle_location == "STOCK").Select(t => t.ID).FirstOrDefault(); tbl_607_bottle tbl_607_Bottle = db.tbl_607_bottle.Include(t => t.tbl_607_location).Where(t => t.bottle_conti_number == contiBottleNumber && t.FK_ID_location == idStock).First(); tbl_607_Bottle.FK_ID_location = idDestock; db.SaveChanges(); //recupération du numéro de poste var infos = (from bo in db.tbl_607_bottle join l in db.tbl_607_location on bo.FK_ID_location equals l.ID join j in db.tbl_607_join_bottle_gaz on bo.ID equals j.FK_ID_bottle join g in db.tbl_607_gaz on j.FK_ID_gaz equals g.ID join od in db.tbl_607_order_details on g.FK_ID_order_details equals od.ID join o in db.tbl_607_order on od.FK_ID_order equals o.ID where bo.bottle_conti_number == contiBottleNumber && bo.FK_ID_location == idStock select new { Poste = od.poste_number, ContractNumber = o.order_number, Content = od.content_comments }).First(); //Variables Mail string mailsender = (System.Web.HttpContext.Current.User.Identity.Name.ToString().Remove(0, 5)) + "@contiwan.com"; //Numéro de poste ViewBag.Poste = infos.Poste; //Numéro de contrat ViewBag.ContractNumber = infos.ContractNumber; //Content ViewBag.Content = infos.Content; ViewBag.mailText = "mailto:[email protected]&cc=" + mailsender + "&subject=SpanGazV2 bottle return advice&body=---Test Center CONTINENTAL CPT--- %0A---Automatic mail generated by SpanGazV2--- %0ABottle return %0APoste N° " + infos.Poste + " %0AContract: " + infos.ContractNumber + " %0ASpan bottle %0AQuantity: 1 %0AContent: " + infos.Content; ViewBag.message = "Reload"; return(Json(new { view = "Index", mailText = ViewBag.mailText }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(HttpNotFound()); } }
public ActionResult SaveData() { try { // vérification de l'existance du BL // extraction des numeros de BL existants sur le contrat var BLBase = (db.tbl_607_shipping_delivery.Include(t => t.tbl_607_shipping_request).Include(s => s.tbl_607_shipping_request.tbl_607_order) .Include(o => o.tbl_607_shipping_request.tbl_607_order.tbl_607_order_details)) .Where(o => o.tbl_607_shipping_request.tbl_607_order.ID == BottlereceptionWizardViewModelTemp.idcontract).Select(t => t.BL_ref).ToList(); tbl_607_shipping_delivery tbl_607_Shipping_Delivery = new tbl_607_shipping_delivery(); // comparaison avec le numero saisi par l'utilisateur var Control = BLBase.Contains(BottlereceptionWizardViewModelTemp.BL_ref); if (Control) { //BL existant, nous allons donc uniquement proceder à un update } else { //BL inexistant, creation tbl_607_Shipping_Delivery.BL_ref = BottlereceptionWizardViewModelTemp.BL_ref; tbl_607_Shipping_Delivery.reception_date = BottlereceptionWizardViewModelTemp.reception_date; tbl_607_Shipping_Delivery.FK_ID_shipping_request = BottlereceptionWizardViewModelTemp.FK_ID_shipping_request; db.tbl_607_shipping_delivery.Add(tbl_607_Shipping_Delivery); db.SaveChanges(); //sauvegarde } // le certificat de conformite est unique et est lie a une bouteille tbl_607_conformity_certificate tbl_607_Conformity_Certificate = new tbl_607_conformity_certificate(); tbl_607_Conformity_Certificate.ID = BottlereceptionWizardViewModelTemp.conformity_certificate; tbl_607_Conformity_Certificate.fabrication_date = BottlereceptionWizardViewModelTemp.fabrication_date; tbl_607_Conformity_Certificate.expiration_date = BottlereceptionWizardViewModelTemp.expiration_date; db.tbl_607_conformity_certificate.Add(tbl_607_Conformity_Certificate); db.SaveChanges(); //sauvegarde // recuperation des id des enregistrements crees var FK_ID_shipping_delivery = db.tbl_607_shipping_delivery.Select(t => t.ID).Max(); // recuperation de l'id location pour stock var stock = db.tbl_607_location.Where(t => t.bottle_location == "STOCK").Select(t => t.ID).First(); // enregistrement dans la table bouteille tbl_607_bottle tbl_607_Bottle = new tbl_607_bottle(); tbl_607_Bottle.manufacturer_bottle_number = BottlereceptionWizardViewModelTemp.manufacturer_bottle_number; tbl_607_Bottle.bottle_conti_number = BottlereceptionWizardViewModelTemp.bottle_conti_number; tbl_607_Bottle.FK_ID_conformity_certificate = BottlereceptionWizardViewModelTemp.conformity_certificate; tbl_607_Bottle.FK_ID_shipping_delivery = FK_ID_shipping_delivery; tbl_607_Bottle.FK_ID_order = BottlereceptionWizardViewModelTemp.idcontract; tbl_607_Bottle.FK_ID_location = stock; db.tbl_607_bottle.Add(tbl_607_Bottle); db.SaveChanges(); //sauvegarde // mise à jour de la quantité recue sur le poste tbl_607_order_details tbl_607_Order_Detail = db.tbl_607_order_details.Where(t => t.poste_number == BottlereceptionWizardViewModelTemp.posteNumber && t.FK_ID_order == BottlereceptionWizardViewModelTemp.idcontract).First(); tbl_607_Order_Detail.recieved_quantity = tbl_607_Order_Detail.recieved_quantity++; db.SaveChanges(); //sauvegarde // mise a jour de la quantité sur la demande de livraison tbl_607_shipping_request_details tbl_607_Shipping_Request_Details = db.tbl_607_shipping_request_details.Where(t => t.FK_shipping_request == BottlereceptionWizardViewModelTemp.FK_ID_shipping_request).FirstOrDefault(); tbl_607_Shipping_Request_Details.reception_quantity = tbl_607_Shipping_Request_Details.reception_quantity++; db.SaveChanges(); //sauvegarde // Recuperation de l'ID Bottle. L'ID gaz est deja connu = key du dico var idBottle = db.tbl_607_bottle.Select(t => t.ID).Max(); //Nouvelle relève: valeurs par défaut 999bars et acteur: admin tbl_607_gaz_reporting tbl_607_Gaz_Reporting = new tbl_607_gaz_reporting(); tbl_607_Gaz_Reporting.pressure_value = 999; tbl_607_Gaz_Reporting.FK_ID_actors = 29; tbl_607_Gaz_Reporting.FK_ID_bottle = idBottle; tbl_607_Gaz_Reporting.reporting_date = DateTime.Now; db.tbl_607_gaz_reporting.Add(tbl_607_Gaz_Reporting); // Recuperation des reals gaz dans le dictionnaire foreach (KeyValuePair <int, float> value in Tbl_607_Real_Gaz_Content_temp) { tbl_607_real_gaz_content tbl_607_Real_Gaz_Content = new tbl_607_real_gaz_content(); tbl_607_join_bottle_gaz tbl_607_Join_Bottle_Gaz = new tbl_607_join_bottle_gaz(); // Enregistrement des reals gaz tbl_607_Real_Gaz_Content.real_content = value.Value; //force l'ecriture dans la base alors que nous sommes encore dans la boucle db.tbl_607_real_gaz_content.Add(tbl_607_Real_Gaz_Content); db.SaveChanges(); //sauvegarde //// Recuperation de l'id real gaz var fk_real = db.tbl_607_real_gaz_content.Select(t => t.ID).Max(); //Ecriture de la jointure tbl_607_Join_Bottle_Gaz.FK_ID_gaz = value.Key; tbl_607_Join_Bottle_Gaz.FK_ID_bottle = idBottle; tbl_607_Join_Bottle_Gaz.FK_ID_real_content = fk_real; db.tbl_607_join_bottle_gaz.Add(tbl_607_Join_Bottle_Gaz); //force l'ecriture dans la base alors que nous sommes encore dans la boucle db.SaveChanges(); //sauvegarde } //generation de la vue return(View("Index")); } catch (Exception ex) { //generation de la vue affichage erreur return(RedirectToAction("Index", "Ooops", new { message = ex })); } }