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