public ActionResult GetData()
{
using (DatabaseDepensesEntities dataDepense = new DatabaseDepensesEntities())
{
List <TDepenses> listDepenses = dataDepense.TDepenses.ToList <TDepenses>();
return(Json(new { data = listDepenses }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (DatabaseDepensesEntities dataDepense = new DatabaseDepensesEntities())
{
TDepenses tmps = dataDepense.TDepenses.Where(x => x.IdDepense == id).FirstOrDefault <TDepenses>();
dataDepense.TDepenses.Remove(tmps);
dataDepense.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(TDepenses depense)
{
using (DatabaseDepensesEntities dataDepense = new DatabaseDepensesEntities())
{
depense.IdDepense = dataDepense.TDepenses.Max(x => x.IdDepense) + 1;
dataDepense.TDepenses.Add(depense);
dataDepense.SaveChanges();
return(Json(new { succes = true, message = "Saved Succefully" }));
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
return(View(new TDepenses()));
}
else
{
using (DatabaseDepensesEntities dataDepense = new DatabaseDepensesEntities())
{
return(View(dataDepense.TDepenses.Where(x => x.IdDepense == id).FirstOrDefault <TDepenses>()));
}
}
}
// Obtenir statistique prix par type
public ActionResult GestStatParPrix()
{
Dictionary <string, double> dictData = new Dictionary <string, double>();
using (DatabaseDepensesEntities dataDepense = new DatabaseDepensesEntities())
{
List <TDepenses> listDepenses = dataDepense.TDepenses.ToList <TDepenses>(); // Obtention de tout les données
foreach (var it in listDepenses)
{
if (dictData.ContainsKey(it.typeDepense.Trim()))
{
dictData[it.typeDepense.Trim()] = dictData[it.typeDepense.Trim()] + it.prixDepense;
}
else
{
dictData.Add(it.typeDepense.Trim(), it.prixDepense);
}
}
return(Json(new { data = dictData }, JsonRequestBehavior.AllowGet));
}
}
