// GET: Admin/ReportParam/Edit/5 public ActionResult Edit(int?id, int rptId) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReportParam reportParam = ContextPerRequest.CurrentData.ReportParams.Find(id); ReportParamViewModel model = new ReportParamViewModel(); if (reportParam == null) { return(HttpNotFound()); } else { model.DisplayOrder = reportParam.DisplayOrder ?? 0; model.DropSQL = reportParam.DropSQL; model.ParamDescription = string.Empty; model.ParamName = reportParam.ParamName; model.ParamTitle = reportParam.ParamTitle; model.ParamTypeList = null; model.ParamWidth = reportParam.ParamWidth ?? 0; model.ReportID = reportParam.ReportID; model.ReportParamID = reportParam.ReportParamID; model.ReportParamTypeID = reportParam.ReportParamTypeID; } return(View(model)); }
public ActionResult Report(EnumReports reports, EnumDepartment?dep, ReportParamViewModel viewModel, FormCollection formCollection) { ReportDataSource[] repCol = new ReportDataSource[1]; DateTime? dateFrom = Helper.CommonHelper.ConvertToDate(formCollection["DateFrom"]); DateTime? dateTo = Helper.CommonHelper.ConvertToDate(formCollection["DateTo"]); switch (reports) { case EnumReports.RptDueInstallment: repCol[0] = GetDueInstallment(dateFrom, dateTo); break; case EnumReports.RptCommission: repCol[0] = GetCommission(viewModel.RecPeriodId, dep); break; case EnumReports.RptPartnerHutang: repCol[0] = GetLoan(viewModel.DateFrom, viewModel.DateTo, viewModel.PartnerId); break; case EnumReports.RptChartLoan: repCol[0] = GetLoan(viewModel.DateFrom, viewModel.DateTo, viewModel.PartnerId); break; } HttpContext.Session["ReportData"] = repCol; var e = new { Success = true, Message = "redirect", UrlReport = string.Format("{0}", reports.ToString()) }; return(Json(e, JsonRequestBehavior.AllowGet)); }
public ActionResult Report(EnumReport rpt, ReportParamViewModel viewModel, FormCollection formCollection) { ReportDataSource[] repCol = new ReportDataSource[1]; switch (rpt) { case EnumReport.RptDetailSales: repCol[0] = GetSalesDet(viewModel.DateFrom.Value, viewModel.DateTo.Value, viewModel.AgentId, viewModel.GameId); break; case EnumReport.RptRecapSalesByAgent: repCol[0] = GetSalesDet(viewModel.DateFrom.Value, viewModel.DateTo.Value, viewModel.AgentId, viewModel.GameId); break; case EnumReport.RptRecapSalesByGame: repCol[0] = GetSalesDet(viewModel.DateFrom.Value, viewModel.DateTo.Value, viewModel.AgentId, viewModel.GameId); break; case EnumReport.RptRecapWinSales: repCol[0] = GetSalesDet(viewModel.DateFrom.Value, viewModel.DateTo.Value, viewModel.AgentId, viewModel.GameId, EnumSalesDetStatus.Win.ToString()); break; } Session["ReportData"] = repCol; var e = new { Success = true, Message = "redirect", UrlReport = string.Format("{0}", rpt.ToString()) }; return(Json(e, JsonRequestBehavior.AllowGet)); }
// GET: Admin/ReportParam/Create public ActionResult Create(int id) { ReportParamViewModel model = new ReportParamViewModel(); model.ReportID = id; model.ReportParamTypeID = 0; return(View(model)); }
public ActionResult Report(EnumReport rpt) { ReportParamViewModel viewModel = ReportParamViewModel.Create(_mAgentRepository, _mGameRepository); string title = string.Empty; switch (rpt) { case EnumReport.RptDetailSales: title = "Lap. Detail Penjualan"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowAgent = true; break; case EnumReport.RptRecapSalesByAgent: title = "Lap. Rekap Penjualan"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowAgent = true; viewModel.ShowGame = true; break; case EnumReport.RptRecapSalesByGame: title = "Lap. Rekap Penjualan Per Game"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowAgent = true; viewModel.ShowGame = true; break; case EnumReport.RptRecapWinSales: title = "Lap. Rekap Penjualan Yg Menang"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowAgent = true; viewModel.ShowGame = true; break; } ViewData["CurrentItem"] = title; return(View(viewModel)); }
public ActionResult Create([Bind(Include = "ReportParamID,ReportID,ReportParamTypeID,ParamName,ParamTitle,ParamWidth,DisplayOrder,DropSQL")] ReportParamViewModel reportParam) { if (ModelState.IsValid) { ReportParam param = new ReportParam { DisplayOrder = reportParam.DisplayOrder, DropSQL = reportParam.DropSQL, ParamName = reportParam.ParamName, ParamTitle = reportParam.ParamTitle, ParamWidth = reportParam.ParamWidth, ReportID = reportParam.ReportID, ReportParamTypeID = reportParam.ReportParamTypeID }; ContextPerRequest.CurrentData.ReportParams.Add(param); ContextPerRequest.CurrentData.SaveChanges(); return(RedirectToAction("Edit", "Report", new { id = reportParam.ReportID })); } return(View(reportParam)); }
public ActionResult Report(EnumReports reports, EnumDepartment?dep = null) { ReportParamViewModel viewModel = ReportParamViewModel.Create(_tRecPeriodRepository, _mPartnerRepository); string title = string.Empty; switch (reports) { case EnumReports.RptDueInstallment: title = "Daftar Angsuran Jatuh Tempo"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = false; break; case EnumReports.RptCommission: title = "Lap. Komisi Karyawan"; viewModel.ShowRecPeriod = true; break; case EnumReports.RptPartnerHutang: title = "Lap. Hutang Toko"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowPartner = true; break; case EnumReports.RptChartLoan: title = "Grafik Pengajuan Kredit"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowPartner = true; break; } ViewData["CurrentItem"] = title; ViewData["ExportFormat"] = new SelectList(Enum.GetValues(typeof(EnumExportFormat))); return(View(viewModel)); }
public ActionResult ReportTrans(EnumReports reports, ReportParamViewModel viewModel, FormCollection formCollection) { return(Report(reports, viewModel, formCollection)); }
public ActionResult Report(EnumReports reports) { ReportParamViewModel viewModel = ReportParamViewModel.CreateReportParamViewModel(_mCostCenterRepository, _mWarehouseRepository, _mSupplierRepository, _tRecPeriodRepository, _mItemRepository); string title = string.Empty; switch (reports) { case EnumReports.RptBrand: title = "Daftar Master Merek"; break; case EnumReports.RptCostCenter: title = "Daftar Master Cost Center"; break; case EnumReports.RptJournal: title = "Daftar Jurnal"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowCostCenter = true; break; case EnumReports.RptNeraca: title = "Laporan Neraca"; viewModel.ShowCostCenter = true; viewModel.ShowRecPeriod = true; break; case EnumReports.RptLR: title = "Laporan Laba / Rugi"; viewModel.ShowCostCenter = true; viewModel.ShowRecPeriod = true; break; case EnumReports.RptStockCard: title = "Kartu Stok"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptStockItem: title = "Lap. Stok Per Gudang"; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptAnalyzeBudgetDetail: title = "Lap. Analisa Budget"; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptServiceOmzet: title = "Lap. Omzet Penjualan"; viewModel.ShowShiftNo = true; viewModel.ShowDateFrom = true; break; case EnumReports.RptCommissionRecap: title = "Lap. Rekap Komisi Terapis"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; break; case EnumReports.RptCommission: title = "Lap. Komisi Terapis"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; break; case EnumReports.RptCustomerBirthday: title = "Daftar Member Ulang Tahun"; //viewModel.ShowDateFrom = true; //viewModel.ShowDateTo = true; break; } ViewData["CurrentItem"] = title; ViewData["ExportFormat"] = new SelectList(Enum.GetValues(typeof(EnumExportFormat))); return(View(viewModel)); }
public ActionResult Report(EnumReports reports, ReportParamViewModel viewModel, FormCollection formCollection) { ReportDataSource[] repCol = new ReportDataSource[1]; switch (reports) { case EnumReports.RptBrand: repCol[0] = GetBrand(); break; case EnumReports.RptCostCenter: repCol[0] = GetCostCenter(); break; case EnumReports.RptJournal: repCol[0] = GetJournalDet(viewModel.DateFrom, viewModel.DateTo, viewModel.CostCenterId); break; case EnumReports.RptNeraca: repCol[0] = GetRecAccount(EnumAccountCatType.NERACA, viewModel.CostCenterId, viewModel.RecPeriodId); break; case EnumReports.RptLR: repCol[0] = GetRecAccount(EnumAccountCatType.LR, viewModel.CostCenterId, viewModel.RecPeriodId); break; case EnumReports.RptStockCard: repCol[0] = GetStockCard(viewModel.DateFrom, viewModel.DateTo, viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptStockItem: repCol[0] = GetStockItem(viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptAnalyzeBudgetDetail: repCol[0] = GetTransDetForBudget(viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptPrintFacturService: repCol = new ReportDataSource[3]; TTrans trans = _tTransRepository.Get(viewModel.TransId); repCol[0] = GetTrans(trans); repCol[1] = GetTransDet(trans.TransDets); repCol[2] = GetTransRoom(viewModel.TransId); break; case EnumReports.RptServiceOmzet: repCol = new ReportDataSource[2]; TShift s = _tShiftRepository.GetByDateAndShiftNo(viewModel.DateFrom, viewModel.ShiftNo); repCol[0] = GetShiftViewModel(s); repCol[1] = GetServiceOmzet(s.ShiftDateFrom, s.ShiftDateTo); break; case EnumReports.RptCommissionRecap: repCol[0] = GetTransDetByDate(viewModel.DateFrom, viewModel.DateTo); break; case EnumReports.RptCommission: repCol[0] = GetTransDetByDate(viewModel.DateFrom, viewModel.DateTo); break; case EnumReports.RptCustomerBirthday: repCol[0] = GetCustomerBirthday(viewModel.DateFrom, viewModel.DateTo); break; } Session["ReportData"] = repCol; var e = new { Success = true, Message = "redirect", UrlReport = string.Format("{0}", reports.ToString()) }; return(Json(e, JsonRequestBehavior.AllowGet)); //string reportType = formCollection["ExportFormat"]; //string mimeType, encoding, fileNameExtension; ////The DeviceInfo settings should be changed based on the reportType ////http://msdn2.microsoft.com/en-us/library/ms155397.aspx //string deviceInfo = //"<DeviceInfo>" + //string.Format(" <OutputFormat>{0}</OutputFormat>", formCollection["ExportFormat"]) + //" <PageWidth>8.5in</PageWidth>" + //" <PageHeight>11in</PageHeight>" + //" <MarginTop>0.5in</MarginTop>" + //" <MarginLeft>0.5in</MarginLeft>" + //" <MarginRight>0.5in</MarginRight>" + //" <MarginBottom>0.5in</MarginBottom>" + //"</DeviceInfo>"; //Warning[] warnings; //string[] streams; //byte[] renderedBytes; ////Render the report //renderedBytes = localReport.Render( // reportType, // deviceInfo, // out mimeType, // out encoding, // out fileNameExtension, // out streams, // out warnings); //Response.AddHeader("content-disposition", string.Format("attachment; filename={0}.{1}", reports.ToString(), fileNameExtension)); //return File(renderedBytes, mimeType); }
public ActionResult Report(EnumReports reports, DateTime?dateFrom = null, DateTime?dateTo = null, string customerId = null) { ReportParamViewModel viewModel = ReportParamViewModel.CreateReportParamViewModel(_mCostCenterRepository, _mWarehouseRepository, _mSupplierRepository, _tRecPeriodRepository, _mItemRepository); string title = string.Empty; switch (reports) { case EnumReports.RptBrand: title = "Daftar Master Merek"; break; case EnumReports.RptCostCenter: title = "Daftar Master Cost Center"; break; case EnumReports.RptJournal: title = "Daftar Jurnal"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowCostCenter = true; break; case EnumReports.RptNeraca: title = "Laporan Neraca"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowCostCenter = true; break; case EnumReports.RptLR: title = "Laporan Laba / Rugi"; viewModel.ShowCostCenter = true; viewModel.ShowRecPeriod = true; break; case EnumReports.RptStockCard: title = "Kartu Stok"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptStockItem: title = "Lap. Stok Per Gudang"; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptAnalyzeBudgetDetail: title = "Lap. Analisa Budget"; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptServiceOmzet: title = "Lap. Omzet Penjualan"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; break; case EnumReports.RptCommission: title = "Lap. Komisi Karyawan"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; break; case EnumReports.RptSalesByAction: title = "Lap. Penjualan Berdasar Jlh Tindakan"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; break; case EnumReports.RptBukuBesar: title = "Laporan Buku Besar"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowCostCenter = true; break; case EnumReports.RptCommissionRecap: title = "Lap. Rekap Komisi Karyawan"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; break; case EnumReports.RptServiceByCustomer: title = "Lap. Tindakan Per Pasien"; viewModel.ShowCustomer = true; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.DateFrom = dateFrom; viewModel.DateTo = dateTo; viewModel.CustomerId = customerId; break; } ViewData["CurrentItem"] = title; ViewData["ExportFormat"] = new SelectList(Enum.GetValues(typeof(EnumExportFormat))); return(View(viewModel)); }
public ActionResult Report(EnumReports reports, ReportParamViewModel viewModel, FormCollection formCollection) { ReportDataSource[] repCol = new ReportDataSource[1]; switch (reports) { case EnumReports.RptBrand: repCol[0] = GetBrand(); break; case EnumReports.RptCostCenter: repCol[0] = GetCostCenter(); break; case EnumReports.RptJournal: repCol[0] = GetJournalDet(viewModel.DateFrom, viewModel.DateTo, viewModel.CostCenterId); break; case EnumReports.RptNeraca: repCol[0] = GetRecAccount(EnumAccountCatType.NERACA, viewModel.CostCenterId, viewModel.RecPeriodId); break; case EnumReports.RptLR: repCol[0] = GetRecAccount(EnumAccountCatType.LR, viewModel.CostCenterId, viewModel.RecPeriodId); break; case EnumReports.RptStockCard: repCol[0] = GetStockCard(viewModel.DateFrom, viewModel.DateTo, viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptStockItem: repCol[0] = GetStockItem(viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptAnalyzeBudgetDetail: repCol[0] = GetTransDetForBudget(viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptPrintFacturService: repCol = new ReportDataSource[3]; TTrans trans = _tTransRepository.Get(viewModel.TransId); repCol[0] = GetTrans(trans); repCol[1] = GetTransDet(trans.TransDets); repCol[2] = GetTransRoom(viewModel.TransId); break; case EnumReports.RptServiceOmzet: repCol[0] = GetServiceOmzet(viewModel.DateFrom.Value, viewModel.DateTo.Value); break; case EnumReports.RptCommission: repCol[0] = GetCommission(viewModel.DateFrom.Value, viewModel.DateTo.Value); break; case EnumReports.RptSalesByAction: repCol[0] = GetTransDetForTotalAction(viewModel.DateFrom.Value, viewModel.DateTo.Value); break; case EnumReports.RptBukuBesar: repCol[0] = GetJournalDet(viewModel.DateFrom, viewModel.DateTo, viewModel.CostCenterId); break; case EnumReports.RptCommissionRecap: repCol[0] = GetCommission(viewModel.DateFrom.Value, viewModel.DateTo.Value); break; case EnumReports.RptServiceByCustomer: repCol[0] = GetTransDetForCustomer(viewModel.DateFrom, viewModel.DateTo, viewModel.CustomerId); break; } Session["ReportData"] = repCol; var e = new { Success = true, Message = "redirect", UrlReport = string.Format("{0}", reports.ToString()) }; return(Json(e, JsonRequestBehavior.AllowGet)); }
public ActionResult Report(EnumReports reports, ReportParamViewModel viewModel, FormCollection formCollection) { bool Success = true; string Message = "redirect"; try { EnumTransactionStatus stat = (EnumTransactionStatus)Enum.Parse(typeof(EnumTransactionStatus), formCollection["TransStatus"]); ReportDataSource[] repCol = new ReportDataSource[1]; switch (reports) { case EnumReports.RptBrand: repCol[0] = GetBrand(); break; case EnumReports.RptStockCard: repCol[0] = GetStockCard(viewModel.DateFrom, viewModel.DateTo, viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptStockItem: repCol[0] = GetStockItem(viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptAnalyzeBudgetDetail: repCol[0] = GetTransDetForBudget(viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptTransDetail: repCol[0] = GetTransTotal(viewModel.DateFrom, viewModel.DateTo, viewModel.WarehouseId, stat); break; case EnumReports.RptTransDetailByTransBy: repCol[0] = GetTransTotal(viewModel.DateFrom, viewModel.DateTo, viewModel.WarehouseId, viewModel.SupplierId, stat); break; case EnumReports.RptLRDetailSales: repCol[0] = GetTransTotalAndRef(viewModel.DateFrom, viewModel.DateTo, null, viewModel.CustomerId, stat); break; case EnumReports.RptMostItemSales: repCol[0] = GetTransDetail(viewModel.DateFrom, viewModel.DateTo, viewModel.WarehouseId, stat); break; } Session["ReportData"] = repCol; } catch (Exception ex) { Success = false; Message = "Error :\n " + ex.GetBaseException().Message; } var e = new { Success, Message, UrlReport = string.Format("{0}", reports.ToString()) }; return(Json(e, JsonRequestBehavior.AllowGet)); }
public ActionResult ReportTrans(EnumReports reports, EnumTransactionStatus TransStatus, EnumReportGroupBy?groupBy = null) { ReportParamViewModel viewModel = ReportParamViewModel.CreateReportParamViewModel(_mCostCenterRepository, _mWarehouseRepository, _mSupplierRepository, _tRecPeriodRepository, _mItemRepository); if (TransStatus != EnumTransactionStatus.None) { viewModel.TransStatus = TransStatus; } string title = Helper.CommonHelper.GetStringValue(reports); switch (reports) { case EnumReports.RptBrand: break; case EnumReports.RptCostCenter: break; case EnumReports.RptNeraca: viewModel.ShowCostCenter = true; viewModel.ShowRecPeriod = true; viewModel.ShowGenerateDetail = true; break; case EnumReports.RptLR: viewModel.ShowCostCenter = true; viewModel.ShowRecPeriod = true; viewModel.ShowGenerateDetail = true; break; case EnumReports.RptNeracaSum: viewModel.ShowRecPeriod = true; viewModel.ShowGenerateDetail = true; break; case EnumReports.RptLRSum: viewModel.ShowRecPeriod = true; viewModel.ShowGenerateDetail = true; break; case EnumReports.RptStockCard: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptStockItem: viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptAnalyzeBudgetDetail: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptTransDetail: title = string.Format(title, Helper.CommonHelper.GetStringValue(viewModel.TransStatus)); switch (viewModel.TransStatus) { case EnumTransactionStatus.PurchaseOrder: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.Received: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.Purchase: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.ReturPurchase: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.Using: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; case EnumTransactionStatus.Mutation: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; case EnumTransactionStatus.Budgeting: //viewModel.ShowDateFrom = true; //viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; } break; case EnumReports.RptTransRecap: string groupByTitle = groupBy != null?Helper.CommonHelper.GetStringValue(groupBy) : string.Empty; title = string.Format(title, Helper.CommonHelper.GetStringValue(viewModel.TransStatus), groupByTitle); switch (viewModel.TransStatus) { case EnumTransactionStatus.PurchaseOrder: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.Received: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.Purchase: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.ReturPurchase: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; viewModel.ShowSupplier = true; break; case EnumTransactionStatus.Using: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; case EnumTransactionStatus.Mutation: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; case EnumTransactionStatus.Budgeting: //viewModel.ShowDateFrom = true; //viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; } break; case EnumReports.RptItem: break; case EnumReports.RptJournal: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowAccount = false; viewModel.ShowAccountTo = false; break; case EnumReports.RptBukuBesar: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowAccount = true; viewModel.ShowAccountTo = true; break; case EnumReports.RptJournalByCostCenter: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowCostCenter = true; viewModel.ShowAccount = false; viewModel.ShowAccountTo = false; break; case EnumReports.RptBukuBesarByCostCenter: viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowCostCenter = true; viewModel.ShowAccount = true; viewModel.ShowAccountTo = true; break; } ViewData["CurrentItem"] = title; ViewData["ExportFormat"] = new SelectList(Enum.GetValues(typeof(EnumExportFormat))); return(View(viewModel)); }
public ActionResult Report(EnumReports reports, ReportParamViewModel viewModel, FormCollection formCollection, EnumReportGroupBy?groupBy = null) { //LocalReport localReport = new LocalReport(); //localReport.ReportPath = Server.MapPath(string.Format("~/Views/Transaction/Report/{0}.rdlc", reports.ToString())); ReportDataSource[] repCol = new ReportDataSource[1]; ReportParameter[] parameters = null; switch (reports) { case EnumReports.RptBrand: repCol[0] = GetBrand(); break; case EnumReports.RptCostCenter: repCol[0] = GetCostCenter(); break; case EnumReports.RptNeraca: repCol[0] = GetRecAccount(EnumAccountCatType.NERACA, viewModel.CostCenterId, viewModel.RecPeriodId, viewModel.GenerateDetail); break; case EnumReports.RptLR: repCol[0] = GetRecAccount(EnumAccountCatType.LR, viewModel.CostCenterId, viewModel.RecPeriodId, viewModel.GenerateDetail); break; case EnumReports.RptNeracaSum: repCol[0] = GetRecAccount(EnumAccountCatType.NERACA, viewModel.CostCenterId, viewModel.RecPeriodId, viewModel.GenerateDetail); break; case EnumReports.RptLRSum: repCol[0] = GetRecAccount(EnumAccountCatType.LR, viewModel.CostCenterId, viewModel.RecPeriodId, viewModel.GenerateDetail); break; case EnumReports.RptStockCard: repCol[0] = GetStockCard(viewModel.DateFrom, viewModel.DateTo, viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptStockItem: repCol[0] = GetStockItem(viewModel.ItemId, viewModel.WarehouseId); break; case EnumReports.RptAnalyzeBudgetDetail: repCol[0] = GetTransDetForBudget(viewModel.ItemId, viewModel.WarehouseId, viewModel.DateFrom.Value, viewModel.DateTo.Value); break; case EnumReports.RptTransDetail: EnumTransactionStatus stat = (EnumTransactionStatus)Enum.Parse(typeof(EnumTransactionStatus), formCollection["TransStatus"]); repCol[0] = GetTransTotal(viewModel.DateFrom, viewModel.DateTo, viewModel.WarehouseId, stat); break; case EnumReports.RptTransRecap: stat = (EnumTransactionStatus)Enum.Parse(typeof(EnumTransactionStatus), formCollection["TransStatus"]); parameters = new ReportParameter[3]; parameters[0] = new ReportParameter("ParamTitle", string.Format(CommonHelper.GetStringValue(EnumReports.RptTransRecap), CommonHelper.GetStringValue(stat), CommonHelper.GetStringValue(groupBy))); parameters[1] = new ReportParameter("ParamGroupBy", groupBy.ToString()); parameters[2] = new ReportParameter("ParamGroupByTitle", CommonHelper.GetStringValue(groupBy)); repCol[0] = GetTransTotal(viewModel.DateFrom, viewModel.DateTo, viewModel.WarehouseId, stat); break; case EnumReports.RptItem: repCol[0] = GetItemViewModel(); break; case EnumReports.RptJournal: repCol[0] = GetJournalDet(viewModel.DateFrom, viewModel.DateTo, viewModel.CostCenterId, viewModel.AccountId); break; case EnumReports.RptBukuBesar: repCol[0] = GetJournalDetFlow(viewModel.DateFrom, viewModel.DateTo, viewModel.CostCenterId, viewModel.AccountId, viewModel.AccountIdTo); break; case EnumReports.RptJournalByCostCenter: repCol[0] = GetJournalDet(viewModel.DateFrom, viewModel.DateTo, viewModel.CostCenterId, viewModel.AccountId); break; case EnumReports.RptBukuBesarByCostCenter: repCol[0] = GetJournalDetFlow(viewModel.DateFrom, viewModel.DateTo, viewModel.CostCenterId, viewModel.AccountId, viewModel.AccountIdTo); break; } Session["ReportData"] = repCol; Session["ReportParam"] = parameters; var e = new { Success = true, Message = "redirect", UrlReport = string.Format("{0}", reports.ToString()) }; return(Json(e, JsonRequestBehavior.AllowGet)); }
public ActionResult ReportTrans(EnumReports reports, ReportParamViewModel viewModel, FormCollection formCollection, EnumReportGroupBy?groupBy = null) { return(Report(reports, viewModel, formCollection, groupBy)); }
public ActionResult ReportTrans(EnumReports reports, EnumTransactionStatus TransStatus) { ReportParamViewModel viewModel = ReportParamViewModel.CreateReportParamViewModel(_mWarehouseRepository, _mSupplierRepository, _mItemRepository); string title = string.Empty; switch (reports) { case EnumReports.RptBrand: title = "Daftar Master Merek"; break; case EnumReports.RptStockCard: title = "Kartu Stok"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptStockItem: title = "Lap. Stok Per Gudang"; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptAnalyzeBudgetDetail: title = "Lap. Analisa Budget"; viewModel.ShowItem = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptTransDetail: title = "Lap. Detail"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; case EnumReports.RptTransDetailByTransBy: title = "Lap. Rekap Detail Transaksi"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowSupplier = true; break; case EnumReports.RptLRDetailSales: title = "Lap. Detail Laba Kotor"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowCustomer = true; break; case EnumReports.RptMostItemSales: title = "Lap. Penjualan Terbanyak"; viewModel.ShowDateFrom = true; viewModel.ShowDateTo = true; viewModel.ShowWarehouse = true; break; } ViewData["CurrentItem"] = title; ViewData["ExportFormat"] = new SelectList(Enum.GetValues(typeof(EnumExportFormat))); return(View(viewModel)); }