public JsonResult last(Comite comite) { var com = db.Comite.OrderByDescending(m => m.id).FirstOrDefault(); financial_data f = new financial_data(); if (com != null) { f = db.financial_data.Where(m => m.id == com.id_finance).FirstOrDefault(); return(Json(new { id = com.id, date = com.date_comite, statut = com.statut, etat = com.etat, id_finance = com.id_finance, vf = f.vf, prix_m = f.prix_m, vvo = f.vvo, bouquet = f.bouquet, bouquet_vvl = f.bouquet_vvl, decote_occupation = f.decote_occupation, decote_totale = f.decote_totale, vvl = f.vvl, }, JsonRequestBehavior.AllowGet)); } return(Json(new { }, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(int id) { financial_data financial_data = db.financial_data.Find(id); db.financial_data.Remove(financial_data); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: financial_data/Create public ActionResult Create(long id) { if (Session["id"] == null) { return(RedirectToAction("Login", "Users")); } List <string> type_c = new List <string> { "Inter-Comité", "Comité régulière" }; ViewData["type"] = new SelectList(type_c); ViewData["id_folder"] = id; List <Comite> comite = db.Comite.Where(m => m.id_folder == id).OrderByDescending(m => m.id).ToList(); Propriete p = db.Propriete.Where(m => m.id_folder == id).FirstOrDefault(); financial_data f = new financial_data(); List <tiers> l = db.tiers.Where(m => m.id_folder == id).ToList(); if (comite.Count != 0) { ViewData["Comite"] = comite; } else { ViewData["Comite"] = new List <Comite>(); } if (l != null) { if (l.Count == 2) { ViewData["ageTiers"] = l[0].age; ViewData["ageConjoint"] = l[1].age; ViewData["esperance"] = l[0].esperance_vie_actuelle; } else if (l.Count == 1) { ViewData["ageTiers"] = l[0].age; ViewData["esperance"] = l[0].esperance_vie_actuelle; } } if (p != null) { var somme = db.Lots.Where(m => m.id_Propriete == p.id).Select(m => m.surface).Sum(); p.area = somme; ViewData["id"] = p; } return(View()); }
public ActionResult Edit([Bind(Include = "id,vvl,prix_m,vvo,vf,decote_occupation,decote_totale,bouquet,bouquet_vvl")] financial_data financial_data) { if (ModelState.IsValid) { db.Entry(financial_data).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(financial_data)); }
// GET: financial_data/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } financial_data financial_data = db.financial_data.Find(id); if (financial_data == null) { return(HttpNotFound()); } return(View(financial_data)); }
public JsonResult comi(Comite comite) { Comite com = db.Comite.Where(m => m.id == comite.id).FirstOrDefault(); financial_data f = db.financial_data.Where(m => m.id == com.id_finance).FirstOrDefault(); return(Json(new { id = com.id, date = com.date_comite, statut = com.statut, etat = com.etat, id_finance = com.id_finance, vf = f.vf, prix_m = f.prix_m, vvo = f.vvo, bouquet = f.bouquet, bouquet_vvl = f.bouquet_vvl, decote_occupation = f.decote_occupation, decote_totale = f.decote_totale, vvl = f.vvl, }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "propriete,id,vvl,prix_m,vvo,vf,decote_occupation,decote_totale,bouquet,bouquet_vvl")] financial_data financial_data, string bouquet_vvl, string prix_m, string decote_totale, string type_c, DateTime date_c) { try { float bq_vvl = float.Parse(bouquet_vvl, CultureInfo.InvariantCulture.NumberFormat); float prix = float.Parse(prix_m, CultureInfo.InvariantCulture.NumberFormat); float decote = float.Parse(decote_totale, CultureInfo.InvariantCulture.NumberFormat); financial_data.bouquet_vvl = bq_vvl; financial_data.prix_m = prix; financial_data.decote_totale = decote; db.financial_data.Add(financial_data); db.SaveChanges(); Propriete p = db.Propriete.Where(m => m.id == financial_data.propriete).FirstOrDefault(); Comite c = new Comite(); c.date_comite = date_c; c.type_comite = type_c; c.etat = "en cours"; c.statut = "en cours"; c.id_folder = p.id_folder; c.id_finance = financial_data.id; db.Comite.Add(c); db.SaveChanges(); return(RedirectToAction("Details", "folders", new { id = p.id_folder })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }