public JsonResult GetLastadd() { int totalCount; var list = SpendService.Instance(UserSid).GetSpendList(out totalCount, 1, 3); var models = Spend2SpendViewModel.MapList2LastAddViewModelList(list); return(Json(models)); }
public JsonResult GetTop() { //var list = Spend.GetTop(ClientId, 7); var list = SpendService.Instance(UserSid).GetTop(7); var models = Spend2SpendViewModel.MapList2TopViewModelList(list); return(Json(models)); }
public JsonResult SpendTransfer(SpendTransferViewModel model) { Mapper.Initialize(cfg => cfg.CreateMap <SpendTransferViewModel, SpendTransfer>()); SpendTransfer trans = Mapper.Map <SpendTransferViewModel, SpendTransfer>(model); SpendService.Instance(UserSid).CreateTransfer(trans); return(Json(new { })); }
public JsonResult SpendExpense(SpendNewViewModel model) { var spend = SpendViewModel2Spend.Map(model); SpendService.Instance(UserSid).CreateExpense(spend); //model.Save(ClientId); return(Json(new { })); //return RedirectToAction("New"); }
public ActionResult SpendDelete(int?id) { if (!id.HasValue) { return(HttpNotFound()); } SpendService.Instance(UserSid).SpendDelete(id.Value); return(Json(new { })); }
public ActionResult Stat(int?id) { if (!id.HasValue) { return(HttpNotFound()); } int year = DateTime.Now.Year; int month = DateTime.Now.Month; var stat = SpendService.Instance(UserSid).GetMonthlyBilleport(year, month, billId: id).First(); return(View(stat)); }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { UserSid = User.Identity.GetUserId(); ViewBag.UserSid = UserSid; //Создание категорий для нового пользователя if (!String.IsNullOrEmpty(UserSid) && (Session["HasDefaultValues"] == null || !Convert.ToBoolean(Session["HasDefaultValues"]))) { SpendService.Instance(UserSid).CreateDefaultBills(); SpendService.Instance(UserSid).CreateDefaultCategories(); Session["HasDefaultValues"] = true; } base.OnActionExecuting(filterContext); }
public ActionResult SpendCategoryDelete(int?id) { if (!id.HasValue) { return(HttpNotFound()); } try { SpendService.Instance(UserSid).SpendCategoryDelete(id.Value); } catch (ArgumentException ex) { return(Json(new { responseText = ex.Message })); } return(Json(new { })); }
public ActionResult List(string filter = null, int?year = null, int?month = null, int?quarter = null, int?categoryId = null, int?vectorId = null, int?billId = null) { DateTime?dateStart = null; DateTime?dateEnd = null; if (!year.HasValue) { year = DateTime.Now.Year; } if (!month.HasValue) { month = DateTime.Now.Month; } if (filter == "month") { dateStart = new DateTime(year.Value, month.Value, 1); dateEnd = new DateTime(year.Value, month.Value, DateTime.DaysInMonth(year.Value, month.Value)); } if (filter == "quarter") { dateEnd = new DateTime(year.Value, month.Value, DateTime.DaysInMonth(year.Value, month.Value)); var startMonth = dateEnd.Value.AddMonths(-3).Month; var startYear = dateEnd.Value.AddMonths(-3).Year; dateStart = new DateTime(startYear, startMonth, 1); } if (filter == "year") { dateEnd = new DateTime(year.Value, month.Value, DateTime.DaysInMonth(year.Value, month.Value)); var startMonth = dateEnd.Value.AddMonths(-12).Month; var startYear = dateEnd.Value.AddMonths(-12).Year; dateStart = new DateTime(startYear, startMonth, 1); } if (filter == "5year") { dateEnd = new DateTime(year.Value, month.Value, DateTime.DaysInMonth(year.Value, month.Value)); var startMonth = dateEnd.Value.AddYears(-5).Month; var startYear = dateEnd.Value.AddYears(-5).Year; dateStart = new DateTime(startYear, startMonth, 1); } //var list =Spend.GetList(ClientId); int totalCount; var list = SpendService.Instance(UserSid).GetSpendList(out totalCount, dateStart: dateStart, dateEnd: dateEnd, categoryId: categoryId, vectorId: vectorId, billId: billId); return(View(list)); }
public ActionResult GetCategoryChartDataGroupByMonthes(string filter, int?year, int?quarter = null, string vectorSysName = null, int?cat = null, int?bill = null) { IEnumerable <KeyValuePair <string, IEnumerable <SpendChartViewModel> > > list = new List <KeyValuePair <string, IEnumerable <SpendChartViewModel> > >(); if (filter == "year") { list = SpendService.Instance(UserSid) .GetYearlyCategoryChartDataGroupByMonthes(year.Value, vectorSysName, cat, bill); } //.Where(x=>x.Key.Contains("Бензин")); //if (filter == "5year") list = SpendService.Instance(UserSid).Get5YearlyCumulativeTotalChartData(year.Value); //if (filter == "alltime") list = SpendService.Instance(UserSid).GetAllTimeCumulativeTotalChartData(); //var viewList = new List<SpendChartGroupByViewModel>(); //for (int i = 0; i < 12; i++) //{ // foreach (var item in list) // { // var listItem = new SpendChartGroupByViewModel() // { // CategoryName = item.Key, // }; // var values = new List<SpendChartViewModel>(); // var value = new SpendChartViewModel(); // } // listItem.Values = values; // viewList.Add(listItem); //} return(Json(list)); }
public ActionResult GetDifferenceChartData(string filter, int?year, int?month) { if (String.IsNullOrEmpty(filter)) { return(RedirectToAction("SpendCategoryReport", new { filter = "month" })); } if (!year.HasValue) { return(RedirectToAction("SpendCategoryReport", new { filter = filter, year = DateTime.Now.Year, month = month })); } if (!month.HasValue) { return(RedirectToAction("SpendCategoryReport", new { filter = filter, year = year, month = DateTime.Now.Month })); } IEnumerable <SpendChartViewModel> list = new List <SpendChartViewModel>(); if (filter == "month") { list = SpendService.Instance(UserSid).GetDifferenceMonthlyChartData(year.Value, month.Value); } return(Json(list)); }
// GET: SpendCategories public ActionResult Index() { var list = SpendService.Instance(UserSid).GetCategoryList(); return(View(list)); }
public ActionResult Delete(int id) { SpendService.Instance(UserSid).SpendBillDelete(id); return(Json(new { })); }
public ActionResult Update(SpendBills model) { SpendService.Instance(UserSid).SpendBillEdit(model); return(Json(new { })); }
public ActionResult BillMerge(int[] bills, int nameId) { SpendService.Instance(UserSid).SpendBillMerge(bills, nameId); return(Json(new { })); }
public ActionResult Edit(SpendCategory model) { SpendService.Instance(UserSid).SpendCategoryEdit(model); return(Json(new { })); }
public ActionResult CatMerge(int[] cats, int nameId) { SpendService.Instance(UserSid).SpendCategoryMerge(cats, nameId); return(Json(new {})); }
public ActionResult GetCumulativeTotalChartData(string filter, int?year, int?month, int?quarter = null, int?cat = null, int?bill = null) { if (String.IsNullOrEmpty(filter)) { return(RedirectToAction("SpendCategoryReport", new { filter = "month" })); } if (!year.HasValue) { return(RedirectToAction("SpendCategoryReport", new { filter = filter, year = DateTime.Now.Year, month = month })); } if (!month.HasValue) { return(RedirectToAction("SpendCategoryReport", new { filter = filter, year = year, month = DateTime.Now.Month })); } if (!quarter.HasValue) { var quarterD = (double)month / 3; if (quarterD <= 1) { quarter = 1; } else if (quarterD > 1 && quarterD <= 2) { quarter = 2; } else if (quarterD > 2 && quarterD <= 3) { quarter = 3; } else if (quarterD > 3 && quarterD <= 4) { quarter = 4; } return(RedirectToAction("SpendCategoryReportData", new { filter = filter, year = year, month = DateTime.Now.Month, quarter = quarter })); } IEnumerable <SpendChartViewModel> list = new List <SpendChartViewModel>(); if (filter == "month") { list = SpendService.Instance(UserSid).GetMonthlyCumulativeTotalChartData(year.Value, month.Value, cat, bill); } if (filter == "quarter") { list = SpendService.Instance(UserSid).GetQuarterCumulativeTotalChartData(year.Value, quarter.Value, cat, bill); } if (filter == "year") { list = SpendService.Instance(UserSid).GetYearlyCumulativeTotalChartData(year.Value, cat, bill); } if (filter == "5year") { list = SpendService.Instance(UserSid).Get5YearlyCumulativeTotalChartData(year.Value, month.Value, cat, bill); } if (filter == "alltime") { list = SpendService.Instance(UserSid).GetAllTimeCumulativeTotalChartData(cat, bill); } return(Json(list)); }
public ActionResult GetSpendListChartData(string filter, int?year, int?month, int?quarter = null, string vectorSysName = null) { if (String.IsNullOrEmpty(filter)) { return(RedirectToAction("GetSpendListChartData", new { filter = "month", year = year, month = month, quarter = quarter })); } if (!year.HasValue) { return(RedirectToAction("GetSpendListChartData", new { filter = filter, year = DateTime.Now.Year, month = month, quarter = quarter })); } if (!month.HasValue) { return(RedirectToAction("GetSpendListChartData", new { filter = filter, year = year, month = DateTime.Now.Month, quarter = quarter })); } if (!quarter.HasValue) { var quarterD = (double)month / 3; if (quarterD <= 1) { quarter = 1; } else if (quarterD > 1 && quarterD <= 2) { quarter = 2; } else if (quarterD > 2 && quarterD <= 3) { quarter = 3; } else if (quarterD > 3 && quarterD <= 4) { quarter = 4; } return(RedirectToAction("GetSpendListChartData", new { filter = filter, year = year, month = DateTime.Now.Month, quarter = quarter })); } IEnumerable <SpendChartViewModel> list = new List <SpendChartViewModel>(); if (filter == "month") { list = SpendService.Instance(UserSid).GetSpendListMonthlyChartData(year.Value, month.Value, vectorSysName); } if (filter == "quarter") { list = SpendService.Instance(UserSid).GetSpendListQuarterChartData(year.Value, quarter.Value, vectorSysName); } if (filter == "year") { list = SpendService.Instance(UserSid).GetSpendListYearlyChartData(year.Value, vectorSysName); } if (filter == "5year") { list = SpendService.Instance(UserSid).GetSpendList5YearlyChartData(year.Value, vectorSysName); } if (filter == "alltime") { list = SpendService.Instance(UserSid).GetSpendListAllTimeChartData(vectorSysName); } return(Json(list)); }
public ActionResult SpendBillReport(string filter, int?year, int?month, int?quarter = null) { if (String.IsNullOrEmpty(filter)) { return(RedirectToAction("SpendBillReport", new { filter = "month", year = year, month = month, quarter = quarter })); } if (!year.HasValue) { return(RedirectToAction("SpendBillReport", new { filter = filter, year = DateTime.Now.Year, month = month, quarter = quarter })); } if (!month.HasValue) { return(RedirectToAction("SpendBillReport", new { filter = filter, year = year, month = DateTime.Now.Month, quarter = quarter })); } if (!quarter.HasValue) { var quarterD = (double)month / 3; if (quarterD <= 1) { quarter = 1; } else if (quarterD > 1 && quarterD <= 2) { quarter = 2; } else if (quarterD > 2 && quarterD <= 3) { quarter = 3; } else if (quarterD > 3 && quarterD <= 4) { quarter = 4; } return(RedirectToAction("SpendBillReport", new { filter = filter, year = year, month = DateTime.Now.Month, quarter = quarter })); } IEnumerable <SpendStatBillViewModel> list = new List <SpendStatBillViewModel>(); if (filter == "month") { list = SpendService.Instance(UserSid).GetMonthlyBilleport(year.Value, month.Value); } if (filter == "quarter") { list = SpendService.Instance(UserSid).GetQuarterBillReport(year.Value, quarter.Value); } if (filter == "year") { list = SpendService.Instance(UserSid).GetYearlyBillReport(year.Value); } if (filter == "5year") { list = SpendService.Instance(UserSid).Get5YearlyBillReport(year.Value); } if (filter == "alltime") { list = SpendService.Instance(UserSid).GetAllTimeBillReport(); } return(View("SpendBillReport", list)); }
public ActionResult Edit(int id) { var model = SpendService.Instance(UserSid).SpendCategoryGet(id); return(View(model)); }
public ActionResult BillList() { var list = SpendService.Instance(UserSid).SpendBillGetList(); return(View(list)); }
public ActionResult SpendCategoryOrderDown(int id) { SpendService.Instance(UserSid).SpendCategoryOrderDown(id); return(Json(new { })); }
public ActionResult SpendBillOrderUp(int id) { SpendService.Instance(UserSid).SpendBillOrderUp(id); return(Json(new { })); }