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