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