//Add by Jutarat A. on 05032014
/// <summary>
/// Get BillingOfficeDebtSummary list
/// </summary>
/// <returns></returns>
public ActionResult ICS030_LoadGetBillingOfficeDebtSummaryToGrid(ICS030_RegisterData data)
{
ICS030_ScreenParameter param = GetScreenObject <ICS030_ScreenParameter>();
ObjectResultData res = new ObjectResultData();
res.MessageType = MessageModel.MESSAGE_TYPE.WARNING;
IIncomeHandler iincomeHandler = ServiceContainer.GetService <IIncomeHandler>() as IIncomeHandler;
List <doGetBillingOfficeDebtSummary> _doGetBillingOfficeDebtSummaryList = new List <doGetBillingOfficeDebtSummary>();
List <OfficeDataDo> _doOfficeDataDo = new List <OfficeDataDo>();
// Add by Jirawat Jannet @ 2016-10-10
#region Init new data model for uing new billing office debt summary table datas
string localCurrency = MiscellaneousTypeCommon.getCurrencyName(CurrencyUtil.C_CURRENCY_LOCAL);
string UsCurrency = MiscellaneousTypeCommon.getCurrencyName(CurrencyUtil.C_CURRENCY_US);
List <ICS030_DebtActualTableData> _doDebtActualTabledatas = new List <ICS030_DebtActualTableData>();
#endregion
try
{
data.intMonth = data.RawdtpMonthYear.Month;
data.intYear = data.RawdtpMonthYear.Year;
_doGetBillingOfficeDebtSummaryList = iincomeHandler.GetBillingOfficeDebtSummaryList(data.intMonth, data.intYear);
_doOfficeDataDo = CommonUtil.dsTransData.dtOfficeData;
if (_doGetBillingOfficeDebtSummaryList != null && _doGetBillingOfficeDebtSummaryList.Count > 0)
{
foreach (doGetBillingOfficeDebtSummary billingData in _doGetBillingOfficeDebtSummaryList)
{
string strDisableLinkOfficeFlag = "1";
for (int i = 0; i < _doOfficeDataDo.Count; i++)
{
if (billingData.BillingOfficeCode == _doOfficeDataDo[i].OfficeCode)
{
strDisableLinkOfficeFlag = "0";
break;
}
}
billingData.DisableLinkOfficeFlag = strDisableLinkOfficeFlag;
}
#region Initial new datas for this table
foreach (var item in _doGetBillingOfficeDebtSummaryList)
{
#region Local currency
// local currency line 1
_doDebtActualTabledatas.Add(new ICS030_DebtActualTableData()
{
BillingOffice = item.BillingOffice,
BillingOfficeCode = item.BillingOfficeCode,
DisableLinkOfficeFlag = item.DisableLinkOfficeFlag,
BillingOfficeName = item.BillingOfficeName,
Currency = localCurrency,
AllUnpaidActual = item.UnpaidAmountString,
AllUnpaidTarget = item.TargetAmountAllString,
AllUnpaidCompareTotarget = item.TargetAmountAllShow,
UnpaidOver2MonthActual = item.UnpaidAmount2MonthString,
UnpaidOver2MonthTarget = item.TargetAmount2MonthString,
UnpaidOver2MonthCompareTotarget = item.TargetAmount2MonthShow,
UnpaidOver6Month = item.UnpaidAmount6MonthString,
UnpaidAmount = item.UnpaidAmount,
UnpaidAmount2Month = item.UnpaidAmount2Month,
UnpaidAmount6Month = item.UnpaidAmount6Month,
UnpaidDetail = item.UnpaidDetail,
UnpaidDetail2Month = item.UnpaidDetail2Month,
UnpaidDetail6Month = item.UnpaidDetail6Month,
TargetAmountAll = item.TargetAmountAll,
TargetAmount2Month = item.TargetAmount2Month,
TargetDetailAll = item.TargetDetailAll,
TargetDetail2Month = item.TargetDetail2Month
});
// local currency line 2
_doDebtActualTabledatas.Add(new ICS030_DebtActualTableData()
{
BillingOffice = item.BillingOffice,
BillingOfficeCode = item.BillingOfficeCode,
DisableLinkOfficeFlag = item.DisableLinkOfficeFlag,
BillingOfficeName = item.BillingOfficeName,
Currency = localCurrency,
AllUnpaidActual = item.UnpaidDetailString,
AllUnpaidTarget = item.TargetDetailAllString,
AllUnpaidCompareTotarget = item.TargetDetailAllShow,
UnpaidOver2MonthActual = item.UnpaidDetail2MonthString,
UnpaidOver2MonthTarget = item.TargetDetail2MonthString,
UnpaidOver2MonthCompareTotarget = item.TargetDetail2MonthShow,
UnpaidOver6Month = item.UnpaidDetail6MonthString,
UnpaidAmount = 0,
UnpaidAmount2Month = 0,
UnpaidAmount6Month = 0,
UnpaidDetail = 0,
UnpaidDetail2Month = 0,
UnpaidDetail6Month = 0,
TargetAmountAll = 0,
TargetAmount2Month = 0,
TargetDetailAll = 0,
TargetDetail2Month = 0
});
#endregion
#region US Currency
// us currency line 1
_doDebtActualTabledatas.Add(new ICS030_DebtActualTableData()
{
BillingOffice = item.BillingOffice,
BillingOfficeCode = item.BillingOfficeCode,
DisableLinkOfficeFlag = item.DisableLinkOfficeFlag,
BillingOfficeName = item.BillingOfficeName,
Currency = UsCurrency,
AllUnpaidActual = item.UnpaidAmountUsdString,
AllUnpaidTarget = item.TargetAmountAllUsdString,
AllUnpaidCompareTotarget = item.TargetAmountAllUsdShow,
UnpaidOver2MonthActual = item.UnpaidAmount2MonthUsdString,
UnpaidOver2MonthTarget = item.TargetAmount2MonthUsdString,
UnpaidOver2MonthCompareTotarget = item.TargetAmount2MonthUsdShow,
UnpaidOver6Month = item.UnpaidAmount6MonthUsdString,
UnpaidAmount = item.UnpaidAmountUsd,
UnpaidAmount2Month = item.UnpaidAmount2MonthUsd,
UnpaidAmount6Month = item.UnpaidAmount6MonthUsd,
UnpaidDetail = item.UnpaidDetailUsd,
UnpaidDetail2Month = item.UnpaidDetail2MonthUsd,
UnpaidDetail6Month = item.UnpaidDetail6MonthUsd,
TargetAmountAll = item.TargetAmountAllUsd,
TargetAmount2Month = item.TargetAmount2MonthUsd,
TargetDetailAll = item.TargetDetailAllUsd,
TargetDetail2Month = item.TargetDetail2MonthUsd,
});
// us currency line 2
_doDebtActualTabledatas.Add(new ICS030_DebtActualTableData()
{
BillingOffice = item.BillingOffice,
BillingOfficeCode = item.BillingOfficeCode,
DisableLinkOfficeFlag = item.DisableLinkOfficeFlag,
BillingOfficeName = item.BillingOfficeName,
Currency = UsCurrency,
AllUnpaidActual = item.UnpaidDetailUsdString,
AllUnpaidTarget = item.TargetDetailAllUsdString,
AllUnpaidCompareTotarget = item.TargetDetailAllUsdShow,
UnpaidOver2MonthActual = item.UnpaidDetail2MonthUsdString,
UnpaidOver2MonthTarget = item.TargetDetail2MonthUsdString,
UnpaidOver2MonthCompareTotarget = item.TargetDetail2MonthUsdShow,
UnpaidOver6Month = item.UnpaidDetail6MonthUsdString,
UnpaidAmount = 0,
UnpaidAmount2Month = 0,
UnpaidAmount6Month = 0,
UnpaidDetail = 0,
UnpaidDetail2Month = 0,
UnpaidDetail6Month = 0,
TargetAmountAll = 0,
TargetAmount2Month = 0,
TargetDetailAll = 0,
TargetDetail2Month = 0
});
#endregion
}
#endregion
}
if (param != null)
{
param.doGetBillingOfficeDebtSummaryList = _doGetBillingOfficeDebtSummaryList;
param.doNewGetBillingOfficeDebtSummaryList = _doDebtActualTabledatas;
param.doOfficeDataDo = _doOfficeDataDo;
}
}
catch (Exception ex)
{
res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION;
res.AddErrorMessage(ex);
return(Json(res));
}
//res.ResultData = CommonUtil.ConvertToXml<doGetBillingOfficeDebtSummary>(_doGetBillingOfficeDebtSummaryList, "Income\\ICS030_DebtActualTable", CommonUtil.GRID_EMPTY_TYPE.VIEW);
res.ResultData = CommonUtil.ConvertToXml <ICS030_DebtActualTableData>(_doDebtActualTabledatas, "Income\\ICS030_DebtActualTable", CommonUtil.GRID_EMPTY_TYPE.VIEW);
return(Json(res));
}