/// <summary> /// Retrieve unpaid detail dept summary information by billingtarget list of specific screen mode and search criteria information /// </summary> /// <param name="data">Search criteria from link</param> /// <returns></returns> public ActionResult ICS030_LoadGetUnpaidDetailDebtSummaryByBillingTargetData(ICS030_RegisterData data) { ICS030_ScreenParameter param = GetScreenObject <ICS030_ScreenParameter>(); ObjectResultData res = new ObjectResultData(); res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; List <doGetUnpaidDetailDebtSummary> _doGetUnpaidDetailDebtSummaryList = new List <doGetUnpaidDetailDebtSummary>(); try { if (param != null) { data.intMonth = data.RawdtpMonthYear.Month; data.intYear = data.RawdtpMonthYear.Year; CommonUtil comUtil = new CommonUtil(); IIncomeHandler iincomeHandler = ServiceContainer.GetService <IIncomeHandler>() as IIncomeHandler; _doGetUnpaidDetailDebtSummaryList = iincomeHandler.GetUnpaidDetailDebtSummaryByBillingTargetList( comUtil.ConvertContractCode(data.strBillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG), data.strOfficeCode); //Add (strOfficeCode) by Jutarat A. on 11042014 foreach (var item in _doGetUnpaidDetailDebtSummaryList) { if (item.DebtTracingRegistered == 1) { item.DebtTracingRegisteredGridFormat = param.conYes; } else { item.DebtTracingRegisteredGridFormat = param.conNo; } } // Save RegisterData in session param.RegisterData = data; } } catch (Exception ex) { res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION; res.AddErrorMessage(ex); return(Json(res)); } res.ResultData = CommonUtil.ConvertToXml <doGetUnpaidDetailDebtSummary>(_doGetUnpaidDetailDebtSummaryList, "Income\\ICS030_ListOfUnPaidByBillingTarget", CommonUtil.GRID_EMPTY_TYPE.VIEW); return(Json(res)); }
public ActionResult ICS033() { ICS033_ScreenParameter param = GetScreenObject <ICS033_ScreenParameter>(); if (param != null) { #region Billing detail ViewBag.BillingOfficeCode = param.BillingOfficeCode; ViewBag.BillingOfficeName = param.BillingOfficeName; ViewBag.BillingClientNameEN = param.BillingClientNameEN; ViewBag.BillingClientNameLC = param.BillingClientNameLC; ViewBag.BillingClientAddressEN = param.BillingClientAddressEN; ViewBag.BillingClientAddressLC = param.BillingClientAddressLC; ViewBag.BillingClientTelNo = param.BillingClientTelNo; ViewBag.ContactPersonName = param.ContactPersonName; ViewBag.Mode = param.Mode; ViewBag.BillingTargetCode = param.BillingTargetCode; ViewBag.InvoiceNo = param.InvoiceNo; ViewBag.InvoiceOCC = param.InvoiceOCC; ViewBag.BillingCode = param.BillingCode; #endregion #region Unpaid billing detail list #region Get data IIncomeHandler incomeHandler = ServiceContainer.GetService <IIncomeHandler>() as IIncomeHandler; if (param.Mode == ICS033_ScreenCallerMode.GetByBillingTarget) { string billingTargetCodeLongFormat = new CommonUtil().ConvertBillingTargetCode(param.BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG); param.UnpaidDetailDebtSummary = incomeHandler.GetUnpaidDetailDebtSummaryByBillingTargetList(billingTargetCodeLongFormat); } else if (param.Mode == ICS033_ScreenCallerMode.GetByInvoice) { param.UnpaidDetailDebtSummary = incomeHandler.GetUnpaidDetailDebtSummaryByInvoiceList(param.InvoiceNo, param.InvoiceOCC); } else if (param.Mode == ICS033_ScreenCallerMode.GetByBillingCode) { param.UnpaidDetailDebtSummary = incomeHandler.GetUnpaidDetailDebtSummaryByBillingCodeList(param.BillingCode); } #endregion #region Display Yes/No format string yesDisplay = string.Empty; string noDisplay = string.Empty; List <doMiscTypeCode> miscs = new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_FLAG_DISPLAY, ValueCode = "%" } }; ICommonHandler hand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> lst = hand.GetMiscTypeCodeList(miscs); foreach (doMiscTypeCode l in lst) { if (l.ValueCode == FlagDisplay.C_FLAG_DISPLAY_NO) { yesDisplay = l.ValueDisplay; } if (l.ValueCode == FlagDisplay.C_FLAG_DISPLAY_YES) { noDisplay = l.ValueDisplay; } } foreach (doGetUnpaidDetailDebtSummary item in param.UnpaidDetailDebtSummary) { if (item.DebtTracingRegistered == 1) { item.DebtTracingRegisteredGridFormat = noDisplay; } else { item.DebtTracingRegisteredGridFormat = yesDisplay; } } #endregion #endregion #region Calculate total unpaid decimal unpaidAmount = 0; decimal unpaidAmountUs = 0; if (param.UnpaidDetailDebtSummary != null) { unpaidAmount = param.UnpaidDetailDebtSummary.Sum(d => d.BillingAmount).GetValueOrDefault(); unpaidAmountUs = param.UnpaidDetailDebtSummary.Sum(d => d.BillingAmountUsd).GetValueOrDefault(); } ViewBag.UnpaidAmountString = unpaidAmount.ToString("N2"); ViewBag.unpaidAmountUsString = unpaidAmountUs.ToString("N2"); #endregion // add by Jirawat Jannet @ 2016-10-17 #region Currency Type ViewBag.CurrencyTypeLocalName = MiscellaneousTypeCommon.getCurrencyName(CurrencyUtil.C_CURRENCY_LOCAL); ViewBag.CurrencyTypeUsName = MiscellaneousTypeCommon.getCurrencyName(CurrencyUtil.C_CURRENCY_US); #endregion } return(View()); }