public void Delete(Expanses exp) { using (new NotesDeFraisEntities()) { e.Expanses.Remove(exp); } }
public ActionResult createExpanses(ExpansesModel expModel, Guid expanseReport_ID) { ExpanseRepositery expRepo = new ExpanseRepositery(); Expanses exp = new Expanses(); if (!ModelState.IsValid) { exp.Amount_HT = Convert.ToInt32(0); exp.Amount_TVA = Convert.ToInt32(0); } else { exp.Amount_HT = Convert.ToInt32(Request.Form["Amount_HT"]); exp.Amount_TVA = Convert.ToInt32(Request.Form["Amount_TVA"]); } var idCustomer = Request.Form["customerSelect"]; var idexpanseType = Request.Form["typeSelect"]; var idprojet = Request.Form["projectSelect"]; exp.Expanse_ID = Guid.NewGuid(); exp.Amount_TTC = exp.Amount_HT * exp.Amount_TVA / 100 + exp.Amount_HT; exp.Day = Convert.ToInt16(Request.Form["monthSelect"]); exp.ExpanseReport_ID = expanseReport_ID; exp.Customer_ID = new Guid(idCustomer); exp.ExpanseType_ID = new Guid(idexpanseType); exp.Project_ID = new Guid(idprojet); expRepo.AddExpanses(exp); return(RedirectToAction("AllExpanses", new { idExpanseReport = expanseReport_ID })); }
public ActionResult DeleteConfirmed(Guid id) { Expanses expanses = db.Expanses.Find(id); db.Expanses.Remove(expanses); db.SaveChanges(); return(RedirectToAction("Index")); }
public Expanses GetById(Guid id) { using (new NotesDeFraisEntities()) { Expanses expanse = (from ex in e.Expanses where ex.Expanse_ID == id select ex).FirstOrDefault(); return(expanse); } }
public void AddExpanses(Expanses exp) { using (new NotesDeFraisEntities()) { e.Expanses.Add(exp); e.SaveChanges(); } }
public void updateExpanses(Expanses exp, double ttc, double ht, double tva) { using (new NotesDeFraisEntities()) { exp.Amount_TTC = ttc; exp.Amount_HT = ht; exp.Amount_TVA = tva; e.SaveChanges(); } }
public ActionResult updateExpanse(Guid idExpanse) { ExpanseRepositery expRepo = new ExpanseRepositery(); Expanses exp = expRepo.GetById(idExpanse); Guid expRapId = exp.ExpanseReport_ID; double ht = Convert.ToInt32(Request.Form["Amount_HT"]); double ttc = Convert.ToInt32(Request.Form["Amount_TTC"]); double tva = Convert.ToInt32(Request.Form["Amount_TVA"]); expRepo.updateExpanses(exp, ttc, ht, tva); return(RedirectToAction("AllExpanses", new { idExpanseReport = expRapId })); }
public ActionResult Edit([Bind(Include = "Expanse_ID,ExpanseReport_ID,Day,ExpanseType_ID,Customer_ID,Project_ID,Amount_HT,Amount_TVA,Amount_TTC")] Expanses expanses) { if (ModelState.IsValid) { db.Entry(expanses).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Customer_ID = new SelectList(db.Customers, "Customer_ID", "Name", expanses.Customer_ID); ViewBag.ExpanseReport_ID = new SelectList(db.ExpanseReports, "ExpanseReport_ID", "ManagerComment", expanses.ExpanseReport_ID); ViewBag.ExpanseType_ID = new SelectList(db.ExpanseTypes, "ExpenseType_ID", "Name", expanses.ExpanseType_ID); ViewBag.Project_ID = new SelectList(db.Projects, "Project_ID", "Name", expanses.Project_ID); return(View(expanses)); }
// GET: Expanses/Details/5 public ActionResult Details(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Expanses expanses = db.Expanses.Find(id); if (expanses == null) { return(HttpNotFound()); } return(View(expanses)); }
public ActionResult edit(Guid idExpanse) { ExpanseRepositery expRep = new ExpanseRepositery(); ExpansesModel expModel = new ExpansesModel(); Expanses exp = expRep.GetById(idExpanse); expModel.Expanse_ID = exp.Expanse_ID; expModel.Project_ID = exp.Project_ID; expModel.Customer_ID = exp.Customer_ID; expModel.ExpanseReport_ID = exp.ExpanseReport_ID; expModel.Amount_HT = exp.Amount_HT; expModel.Amount_TTC = exp.Amount_TTC; expModel.Amount_TVA = exp.Amount_TVA; expModel.Day = exp.Day; return(View("EditExpanses", expModel)); }
public ActionResult Delete(Guid id) { ExpanseRepositery expRepo = new ExpanseRepositery(); ExpanseRepportRepositery expRapRep = new ExpanseRepportRepositery(); Expanses exp = expRepo.GetById(id); Guid idExpRapo = exp.ExpanseReport_ID; ExpanseReports expReport = expRapRep.GetById(idExpRapo); double ttc = expReport.Total_TTC - exp.Amount_TTC; double ht = expReport.Total_HT - exp.Amount_HT; double tva = expReport.Total_TVA - exp.Amount_TVA; expRapRep.updateExpanseReports(expReport, ttc, ht, tva); expRepo.Delete(exp); expRepo.Save(); return(RedirectToAction("AllExpanses", new { idExpanseReport = idExpRapo })); }
// GET: Expanses/Edit/5 public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Expanses expanses = db.Expanses.Find(id); if (expanses == null) { return(HttpNotFound()); } ViewBag.Customer_ID = new SelectList(db.Customers, "Customer_ID", "Name", expanses.Customer_ID); ViewBag.ExpanseReport_ID = new SelectList(db.ExpanseReports, "ExpanseReport_ID", "ManagerComment", expanses.ExpanseReport_ID); ViewBag.ExpanseType_ID = new SelectList(db.ExpanseTypes, "ExpenseType_ID", "Name", expanses.ExpanseType_ID); ViewBag.Project_ID = new SelectList(db.Projects, "Project_ID", "Name", expanses.Project_ID); return(View(expanses)); }