public ActionResult InsertTransRef(TTransRef viewModel, FormCollection formCollection)
{
TTransRef transDetToInsert = new TTransRef();
transDetToInsert.SetAssignedIdTo(Guid.NewGuid().ToString());
transDetToInsert.TransIdRef = _tTransRepository.Get(formCollection["TransIdRef"]);
//transDetToInsert.TransId = _tTransRepository.Get(formCollection["TransId"]);
transDetToInsert.CreatedDate = DateTime.Now;
transDetToInsert.CreatedBy = User.Identity.Name;
transDetToInsert.DataStatus = EnumDataStatus.New.ToString();
ListTransRef.Add(transDetToInsert);
return(Content("success"));
}
private void SavePayment(TPayment payment, FormCollection formCollection, bool isEdit)
{
//if (isEdit)
//{
// if (ListDeleteDetailTrans != null)
// if (ListDeleteDetailTrans.Count > 0)
// DeleteTransactionDetail(Trans, addStock, calculateStock, ListDeleteDetailTrans.ToArray());
//}
payment.PaymentDets.Clear();
//save detail
string splitter = ",";
string[] selectedTransId = formCollection["SelectedTransId"].Split(splitter.ToCharArray());
TPaymentDet detToInsert;
TTrans trans;
decimal total = 0;
for (int i = 0; i < selectedTransId.Length; i++)
{
trans = _tTransRepository.Get(selectedTransId[i]);
if (trans != null)
{
detToInsert = new TPaymentDet(payment);
detToInsert.SetAssignedIdTo(Guid.NewGuid().ToString());
detToInsert.TransId = trans;
detToInsert.PaymentDetValue = trans.TransGrandTotal;
detToInsert.CreatedDate = DateTime.Now;
detToInsert.CreatedBy = User.Identity.Name;
detToInsert.DataStatus = Enums.EnumDataStatus.New.ToString();
payment.PaymentDets.Add(detToInsert);
total += detToInsert.PaymentDetValue.HasValue ? detToInsert.PaymentDetValue.Value : 0;
}
}
payment.PaymentTotal = total;
if (isEdit)
{
_tPaymentRepository.Update(payment);
}
else
{
_tPaymentRepository.Save(payment);
}
////save journal
//SaveJournal(payment);
}
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, 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));
}
