public JsonResult Next(int no, int locationId) { today = today.AddDays(no); GetDate(); GetMonth(); period = string.Format("{0}{1}", today.Year, bulan); IList<TenantSubterminalDailySales> dailySales = subTerminalRepo.FindTenantSubTerminalDailySaleByPeriod(today, locationId); var _previousDayDate = today.AddDays(-1); var _twoDaysBeforeDate = today.AddDays(-2); IList<TenantSubterminalDailySales> previousDay = subTerminalRepo.FindTenantSubTerminalDailySaleByPeriod(_previousDayDate, locationId); IList<TenantSubterminalDailySales> twoDaysBefore = subTerminalRepo.FindTenantSubTerminalDailySaleByPeriod(_twoDaysBeforeDate, locationId); SalesAmountDay salesAmount = new SalesAmountDay() { CompanyName = "", LocationId = locationId, TotalSaleIDR = subTerminalRepo.TotalTenanSubTerminalSalePerDay(dailySales).ToString("N"), TotalSaleUSD = dailySales.Sum<TenantSubterminalDailySales>(y => y.TotalSalesPerTenantInUSD).ToString("N"), Transactiondate = today.ToString("dd MMMM yyyy"), PreviousDay = _previousDayDate.ToString("dd MMMM yyyy"), TwoDaysBefore = _twoDaysBeforeDate.ToString("dd MMMM yyyy"), TotalSaleIDRPreviousDay = previousDay.Sum<TenantSubterminalDailySales>(y => y.TotalSalePerTenan).ToString("N"), TotalSaleUSDPreviousDay = previousDay.Sum<TenantSubterminalDailySales>(y => y.TotalSalesPerTenantInUSD).ToString("N"), TotalSaleIDRTwoDaysBefore = twoDaysBefore.Sum<TenantSubterminalDailySales>(y => y.TotalSalePerTenan).ToString("N"), TotalSaleUSDTwoDaysBefore = twoDaysBefore.Sum<TenantSubterminalDailySales>(y => y.TotalSalesPerTenantInUSD).ToString("N") }; return Json(salesAmount, JsonRequestBehavior.AllowGet); }
public JsonResult PreviousPenjualanHarian(int no, int locationId) { today = today.AddDays(no); GetDate(); GetMonth(); period = string.Format("{0}{1}{2}", today.Year, bulan, hari); IList<DailySales> dailySales = _apRepo.FindDailySaleByPeriodAndLocationId(today, locationId); var _previousDayDate = today.AddDays(-1); var _twoDaysBeforeDate = today.AddDays(-2); IList<DailySales> previousDay = _apRepo.FindDailySaleByPeriodAndLocationId(_previousDayDate, locationId); IList<DailySales> twoDaysBefore = _apRepo.FindDailySaleByPeriodAndLocationId(_twoDaysBeforeDate, locationId); SalesAmountDay salesAmount = new SalesAmountDay() { CompanyName = "", LocationId = locationId, TotalSaleIDR = _apRepo.TotalSalePerDay(dailySales).ToString("N"), TotalSaleUSD = dailySales.Sum<DailySales>(y => y.TotalSaleInUSD).ToString("N"), Transactiondate = today.ToString("dd MMMM yyyy"), PreviousDay = _previousDayDate.ToString("dd MMMM yyyy"), TwoDaysBefore = _twoDaysBeforeDate.ToString("dd MMMM yyyy"), TotalSaleIDRPreviousDay = previousDay.Sum<DailySales>(y => y.TotalSale).ToString("N"), TotalSaleUSDPreviousDay = previousDay.Sum<DailySales>(y => y.TotalSaleInUSD).ToString("N"), TotalSaleIDRTwoDaysBefore = twoDaysBefore.Sum<DailySales>(y => y.TotalSale).ToString("N"), TotalSaleUSDTwoDaysBefore = twoDaysBefore.Sum<DailySales>(y => y.TotalSaleInUSD).ToString("N") }; return Json(salesAmount, JsonRequestBehavior.AllowGet); }