/// <summary> /// Search and get view billing target data /// </summary> /// <param name="cond"></param> /// <returns></returns> public ActionResult CMS470_SearchResponse(doBillingTargetDataSearchCondition cond) { ObjectResultData res = new ObjectResultData(); CommonUtil c = new CommonUtil(); List <View_dtBillingTargetData> nlst = new List <View_dtBillingTargetData>(); List <dtBillingTargetData> list = new List <dtBillingTargetData>(); try { /// Validate Require //////////////// if (CommonUtil.IsNullOrEmpty(cond.CMS470_chkJuristic) && CommonUtil.IsNullOrEmpty(cond.CMS470_chkIndividual) && CommonUtil.IsNullOrEmpty(cond.CMS470_chkAssociation) && CommonUtil.IsNullOrEmpty(cond.CMS470_chkPublicOffice) && CommonUtil.IsNullOrEmpty(cond.CMS470_chkOther)) { res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; res.AddErrorMessage(MessageUtil.MODULE_COMMON, ScreenID.C_SCREEN_ID_SEARCH_BILLING_INFORMATION, MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0055, null, null); return(Json(res)); } // Concate string CustomerTypeCode with commar separate. like ,xx,yy,zz, List <string> lstCustomerTypeCode = new List <string>(); lstCustomerTypeCode.Add(cond.CMS470_chkJuristic); lstCustomerTypeCode.Add(cond.CMS470_chkIndividual); lstCustomerTypeCode.Add(cond.CMS470_chkAssociation); lstCustomerTypeCode.Add(cond.CMS470_chkPublicOffice); lstCustomerTypeCode.Add(cond.CMS470_chkOther); cond.CMS470_CustomerTypeCode = CommonUtil.CreateCSVString(lstCustomerTypeCode); cond.CMS470_BillingClientCode = c.ConvertBillingClientCode(cond.CMS470_BillingClientCode, CommonUtil.CONVERT_TYPE.TO_LONG); if (cond.CMS470_CustomerTypeCode == string.Empty) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0055); //return Json(res); } else { IViewBillingHandler handler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; list = handler.GetViewBillingTargetDataForSearch(cond); foreach (dtBillingTargetData l in list) { nlst.Add(CommonUtil.CloneObject <dtBillingTargetData, View_dtBillingTargetData>(l)); } } } catch (Exception ex) { //nlst = new List<View_dtBillingClientData>(); res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION; res.AddErrorMessage(ex); } res.ResultData = CommonUtil.ConvertToXml <View_dtBillingTargetData>(nlst, "Common\\CMS470_ResultBillingTarget", CommonUtil.GRID_EMPTY_TYPE.SEARCH); return(Json(res)); }
/// <summary> /// Get billing detail list /// </summary> /// <returns></returns> public ActionResult CMS450_ViewBillingDetailList() { ObjectResultData res = new ObjectResultData(); List <dtViewBillingDetailList> list = new List <dtViewBillingDetailList>(); try { CMS450_ScreenParameter param = GetScreenObject <CMS450_ScreenParameter>(); CommonUtil cm = new CommonUtil(); string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); IViewBillingHandler handlerViewBilling = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); if (!CommonUtil.IsNullOrEmpty(param.BillingTargetCode)) { list = handlerViewBilling.GetViewBillingDetailListByTargetCode(cm.ConvertBillingTargetCode(param.BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG)); } else if (!CommonUtil.IsNullOrEmpty(param.BillingOCC) && !CommonUtil.IsNullOrEmpty(param.ContractCode)) { list = handlerViewBilling.GetViewBillingDetailList(strContractCode, param.BillingOCC); } else if (!CommonUtil.IsNullOrEmpty(param.InvoiceNo)) { List <dtViewBillingDetailListOfLastInvoiceOCC> listBillingDetail = handlerViewBilling.GetViewBillingDetailListOfLastInvoiceOCC(param.InvoiceNo, null, null, null, null); for (int i = 0; i < listBillingDetail.Count(); i++) { listBillingDetail[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } if (listBillingDetail.Count > 0) { List <dtViewBillingDetailList> lst = CommonUtil.ClonsObjectList <dtViewBillingDetailListOfLastInvoiceOCC, dtViewBillingDetailList>(listBillingDetail); res.ResultData = CommonUtil.ConvertToXml <dtViewBillingDetailList>(lst, "Common\\CMS450_ViewBillingDetailInformation", CommonUtil.GRID_EMPTY_TYPE.VIEW); return(Json(res)); } } for (int i = 0; i < list.Count(); i++) { list[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } } catch (Exception ex) { res.AddErrorMessage(ex); } // test //list.RemoveRange(0, 670); res.ResultData = CommonUtil.ConvertToXml <dtViewBillingDetailList>(list, "Common\\CMS450_ViewBillingDetailInformation", CommonUtil.GRID_EMPTY_TYPE.VIEW); return(Json(res)); }
/// <summary> /// Get View Billin gBasic /// </summary> /// <param name="strBillingTargetCode"></param> /// <returns></returns> public ActionResult CMS400_GetViewBillingBasicForGrid(string strBillingTargetCode) { ObjectResultData res = new ObjectResultData(); try { CommonUtil cm = new CommonUtil(); IViewBillingHandler handlerViewBilling = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; if (!CommonUtil.IsNullOrEmpty(strBillingTargetCode)) { strBillingTargetCode = cm.ConvertBillingTargetCode(strBillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG); } ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); List <dtViewBillingBasicList> lst = handlerViewBilling.GetViewBillingBasicList( null, strBillingTargetCode, null, null, null, null ); for (int i = 0; i < lst.Count(); i++) { lst[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } res.ResultData = CommonUtil.ConvertToXml <dtViewBillingBasicList>(lst, "Common\\CMS400_BillingBasic", CommonUtil.GRID_EMPTY_TYPE.VIEW); } catch (Exception ex) { res.AddErrorMessage(ex); return(Json(res)); } return(Json(res)); }
/// <summary> /// Getting billing occ list for load to grid /// </summary> /// <returns></returns> public ActionResult CMS420_LoadGridBillingOCC() { ObjectResultData res = new ObjectResultData(); try { CMS420_ScreenParameter param = GetScreenObject <CMS420_ScreenParameter>(); CommonUtil cm = new CommonUtil(); string strContractCode_short = param.ContractCode; string strContractCode = cm.ConvertContractCode(strContractCode_short, CommonUtil.CONVERT_TYPE.TO_LONG); IViewBillingHandler viewBillingHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); List <dtViewBillingOccList> viewBillingOccListData = viewBillingHandler.GetViewBillingOccList(strContractCode); for (int i = 0; i < viewBillingOccListData.Count(); i++) { viewBillingOccListData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } CommonUtil.MappingObjectLanguage <dtViewBillingOccList>(viewBillingOccListData); string xml = CommonUtil.ConvertToXml <dtViewBillingOccList>(viewBillingOccListData, "Common\\CMS420_BillingOCC", CommonUtil.GRID_EMPTY_TYPE.SEARCH); res.ResultData = xml; return(Json(res)); } catch (Exception ex) { res.AddErrorMessage(ex); return(Json(res)); } }
/// <summary> /// Check suspend, authority and resume of CMS430 /// </summary> /// <param name="param">Screen parameter</param> /// <returns></returns> public ActionResult CMS430_Authority(CMS430_ScreenParameter param) { ObjectResultData res = new ObjectResultData(); CommonUtil cm = new CommonUtil(); try { string strContractCode = null; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); // If param.ContractCode is null then set to CommonUtil.dsTransData.dtCommonSearch.ContractCode; if (CommonUtil.IsNullOrEmpty(param.ContractCode) == true && param.CommonSearch != null && string.IsNullOrEmpty(param.CommonSearch.ContractCode) == false) { //param.ContractCode = CommonUtil.dsTransData.dtCommonSearch.ContractCode; param.ContractCode = param.CommonSearch.ContractCode; } // Check permission if (CheckUserPermission(ScreenID.C_SCREEN_ID_VIEW_DIPOSIT_INFORMATION, FunctionID.C_FUNC_ID_OPERATE) == false) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0053); return(Json(res)); } // is parameter OK ? if (CommonUtil.IsNullOrEmpty(param.ContractCode)) { //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0040); res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0147); return(Json(res)); } else { if (!CommonUtil.IsNullOrEmpty(param.BillingOCC)) { List <dtViewDepositDetailInformation> lst = new List <dtViewDepositDetailInformation>(); strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); IViewBillingHandler viewHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; lst = viewHandler.GetViewDepositDetailInformation(strContractCode, param.BillingOCC); if (lst.Count <= 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); return(Json(res)); } else { for (int i = 0; i < lst.Count(); i++) { lst[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } } } } // Check Data Exist strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); IRentralContractHandler handler = ServiceContainer.GetService <IRentralContractHandler>() as IRentralContractHandler; List <dtTbt_RentalContractBasicForView> lstBaisc = handler.GetTbt_RentalContractBasicForView(strContractCode); if (lstBaisc.Count <= 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); return(Json(res)); } else { for (int i = 0; i < lstBaisc.Count(); i++) { lstBaisc[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } param.dtRentalContract = lstBaisc[0]; } } catch (Exception ex) { res.AddErrorMessage(ex); } return(InitialScreenEnvironment <CMS430_ScreenParameter>("CMS430", param, res)); }
/// <summary> /// Get view deposit detail /// </summary> /// <param name="ContractCode"></param> /// <param name="BillingOCC"></param> /// <returns></returns> public ActionResult CMS430_GetViewDepositDetailControl(string ContractCode, string BillingOCC) { ObjectResultData res = new ObjectResultData(); List <dtViewDepositDetailInformation> lst = new List <dtViewDepositDetailInformation>(); try { CMS430_ScreenParameter param = GetScreenObject <CMS430_ScreenParameter>(); CommonUtil cm = new CommonUtil(); string strContractCode = cm.ConvertContractCode(ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); IViewBillingHandler viewHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); lst = viewHandler.GetViewDepositDetailInformation(strContractCode, BillingOCC); for (int i = 0; i < lst.Count(); i++) { lst[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } if (lst.Count > 0) { if (lst.Count == 1 && CommonUtil.IsNullOrEmpty(lst[0].DepositFeeNo)) { param.dtDepositDetail = null; } else { decimal BalanceOfDeposit = 0; foreach (dtViewDepositDetailInformation data in lst) { if (data.DepositStatus == DepositStatus.C_DEPOSIT_STATUS_PAYMENT) { BalanceOfDeposit += (data.ProcessAmount ?? 0); } else if (data.DepositStatus == DepositStatus.C_DEPOSIT_STATUS_RETURN || data.DepositStatus == DepositStatus.C_DEPOSIT_STATUS_SLIDE || data.DepositStatus == DepositStatus.C_DEPOSIT_STATUS_REVENUE || data.DepositStatus == DepositStatus.C_DEPOSIT_STATUS_CANCEL_PAYMENT || data.DepositStatus == DepositStatus.C_DEPOSIT_STATUS_CANCEL_SLIDE) { BalanceOfDeposit += (data.ProcessAmount ?? 0); } data.BalanceOfDeposit = BalanceOfDeposit; if (CommonUtil.IsNullOrEmpty(data.ReceivedFee)) { //Receive Fee & Currency is NULL , Default it. data.ReceivedFeeCurrencyType = SECOM_AJIS.Common.Util.ConstantValue.CurrencyUtil.C_CURRENCY_LOCAL; data.ReceivedFee = 0; } if (CommonUtil.IsNullOrEmpty(data.ProcessAmount)) { data.ProcessAmountCurrencyType = SECOM_AJIS.Common.Util.ConstantValue.CurrencyUtil.C_CURRENCY_LOCAL; data.ProcessAmount = 0; } } param.dtDepositDetail = lst; } res.ResultData = lst[0]; } else { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); return(Json(res)); } } catch (Exception ex) { res.AddErrorMessage(ex); return(Json(res)); } return(Json(res)); }
/// <summary> /// Initialize screen of CMS430 /// </summary> /// <returns></returns> public ActionResult CMS430() { ObjectResultData res = new ObjectResultData(); try { CMS430_ScreenParameter param = GetScreenObject <CMS430_ScreenParameter>(); CommonUtil cm = new CommonUtil(); string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); IViewBillingHandler viewHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); //List<dtViewBillingOccList> lst = viewHandler.GetViewBillingOccList(strContractCode); List <dtViewBillingOccList> lst = viewHandler.GetViewBillingOCCListForDepositFree(strContractCode); for (int i = 0; i < lst.Count(); i++) { lst[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } if (lst.Count > 0) { foreach (dtViewBillingOccList data in lst) { if (CommonUtil.IsNullOrEmpty(data.MonthlyBillingAmount)) { data.MonthlyBillingAmount = 0.00M; } if (CommonUtil.IsNullOrEmpty(data.BalanceDeposit)) { data.BalanceDeposit = 0.00M; } if (CommonUtil.IsNullOrEmpty(data.BillingOCC)) { data.BillingOCC = "-"; } if (CommonUtil.IsNullOrEmpty(data.PaymentName)) { data.PaymentName = "-"; } if (CommonUtil.IsNullOrEmpty(data.IssueInvoiceName)) { data.IssueInvoiceName = "-"; } if (CommonUtil.IsNullOrEmpty(data.OfficeName)) { data.OfficeName = "-"; } } param.dtOCCList = lst; } // Prepare for show section ViewBag.txtContractCode = param.dtRentalContract.ContractCodeShort; ViewBag.txtNormalDepositFee = param.dtRentalContract.TextTransferNormalDepositFee_CMS430; ViewBag.txtNormalDepositFeeUsd = param.dtRentalContract.TextTransferNormalDepositFeeUsd_CMS430; //Merge at 14032017 By Pachara S. //ViewBag.txtNormalDepositFee = param.dtRentalContract.NormalDepositFeeNumeric; ViewBag.txtBillingDepositFee = param.dtRentalContract.TextTransferOrderDepositFee_CMS430; ViewBag.txtBillingDepositFeeUsd = param.dtRentalContract.TextTransferOrderDepositFeeUsd_CMS430; //Merge at 14032017 By Pachara S. //ViewBag.txtBillingDepositFee = param.dtRentalContract.OrderDepositFeeNumeric; ViewBag.txtExemptedDepositFee = param.dtRentalContract.TextTransferExemptedDepositFee_CMS430; ViewBag.txtExemptedDepositFeeUsd = param.dtRentalContract.TextTransferExemptedDepositFeeUsd_CMS430; //Merge at 14032017 By Pachara S. //ViewBag.txtExemptedDepositFee = param.dtRentalContract.ExemptedDepositFeeNumeric; ViewBag.txtContractTargetNameEN = param.dtRentalContract.CustFullNameEN_Cust; ViewBag.txtBranchNameEN = param.dtRentalContract.BranchNameEN; ViewBag.txtSiteNameEN = param.dtRentalContract.SiteNameEN_Site; ViewBag.txtContractTargetNameLC = param.dtRentalContract.CustFullNameLC_Cust; ViewBag.txtBranchNameLC = param.dtRentalContract.BranchNameLC; ViewBag.txtSiteNameLC = param.dtRentalContract.SiteNameLC_Site; //To for test //ViewBag.BillingOCC = "01"; ViewBag.BillingOCC = param.BillingOCC; ViewBag.ContractCode = param.ContractCode; } catch (Exception ex) { res.AddErrorMessage(ex); } return(View()); }
/// <summary> /// Check suspend, authority and resume of CMS400 /// </summary> /// <param name="param"></param> /// <returns></returns> public ActionResult CMS400_Authority(CMS400_ScreenParameter param) { ObjectResultData res = new ObjectResultData(); try { // for test //param.CallerScreenID = "CMS410"; //param.BillingTargetCode = "0000009-001"; //param.isEnableBtnShowInvoiceList = true; //Check permission if (CheckUserPermission(ScreenID.C_SCREEN_ID_SEARCH_BILLING_INFORMATION, FunctionID.C_FUNC_ID_OPERATE) == false) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0053); return(Json(res)); } IBillingHandler handlerBilling = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler; IViewBillingHandler handlerViewBilling = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; CommonUtil cm = new CommonUtil(); ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); string strBillingTargetCode = cm.ConvertBillingTargetCode(param.BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG); if (param.CallerScreenID == ScreenID.C_SCREEN_ID_VIEW_BILLING_TARGET_INFORMATION) { //check require field if (CommonUtil.IsNullOrEmpty(param.BillingTargetCode)) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0040); return(Json(res)); } //data exist List <dtTbt_BillingTargetForView> lst = handlerBilling.GetTbt_BillingTargetForView(strBillingTargetCode, MiscType.C_CUST_TYPE); if (lst.Count <= 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); return(Json(res)); } else { param.dtBillingTargetForView = lst[0]; } if (param.isEnableBtnShowInvoiceList == false) { List <dtViewBillingBasicList> lstBasic = handlerViewBilling.GetViewBillingBasicList(null, strBillingTargetCode, null, null, null, null); for (int i = 0; i < lstBasic.Count(); i++) { lstBasic[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } //if (lstBasic.Count <= 0) //{ // //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); // //return Json(res); //} //else //{ param.doBasicList = lstBasic; //} } else { List <dtViewBillingInvoiceListOfLastInvoiceOcc> lstInvoice = handlerViewBilling.GetViewBillingInvoiceListOfLastInvoiceOcc(null, strBillingTargetCode, null, null, null, null); //if (lstInvoice.Count <= 0) //{ // //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); // //return Json(res); //} //else //{ param.dtViewBillingInvoiceListOfLastInvoiceOccList = lstInvoice; //} } } } catch (Exception ex) { res.AddErrorMessage(ex); } return(InitialScreenEnvironment <CMS400_ScreenParameter>("CMS400", param, res)); }
/// <summary> /// Search Data /// </summary> /// <param name="strBillingClientCode"></param> /// <param name="strBillingTargetNo"></param> /// <param name="strBillingClientName"></param> /// <param name="strBillingClientAddress"></param> /// <param name="strBillingClientCode2"></param> /// <param name="Flag"></param> /// <param name="strInvoiceNo"></param> /// <returns></returns> public ActionResult CMS400_SearchDataToGrid(string strBillingClientCode, string strBillingTargetNo, string strBillingClientName, string strBillingClientAddress, string strBillingClientCode2, int Flag, string strInvoiceNo, string strTaxIDNo) { ObjectResultData res = new ObjectResultData(); try { // Check validate control CMS400_ScreenParameter param = GetScreenObject <CMS400_ScreenParameter>(); CommonUtil cm = new CommonUtil(); string strBillingTargetCode = null; IViewBillingHandler handlerViewBilling = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; if (!CommonUtil.IsNullOrEmpty(strBillingClientCode2) || !CommonUtil.IsNullOrEmpty(strBillingTargetNo)) { strBillingTargetCode = cm.ConvertBillingClientCode(strBillingClientCode2, CommonUtil.CONVERT_TYPE.TO_LONG) + "-" + strBillingTargetNo; } else { strBillingTargetCode = null; } if (CommonUtil.IsNullOrEmpty(strBillingClientCode)) { strBillingClientCode = null; } else { strBillingClientCode = cm.ConvertBillingClientCode(strBillingClientCode, CommonUtil.CONVERT_TYPE.TO_LONG); } if (CommonUtil.IsNullOrEmpty(strBillingClientName)) { strBillingClientName = null; } if (CommonUtil.IsNullOrEmpty(strBillingClientAddress)) { strBillingClientAddress = null; } if (CommonUtil.IsNullOrEmpty(strInvoiceNo)) { strInvoiceNo = null; } if (CommonUtil.IsNullOrEmpty(strTaxIDNo)) { strTaxIDNo = null; } if (Flag == 0) { List <doBillingTargetList> lst = handlerViewBilling.GetViewBillingTargetList( strBillingClientCode, strBillingTargetCode, strBillingClientName, strBillingClientAddress, strInvoiceNo, strTaxIDNo ); res.ResultData = CommonUtil.ConvertToXml <doBillingTargetList>(lst, "Common\\CMS400_BillingTarget", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (Flag == 1) { List <dtViewBillingBasicList> lst = handlerViewBilling.GetViewBillingBasicList( strBillingClientCode, strBillingTargetCode, strBillingClientName, strBillingClientAddress, strInvoiceNo, strTaxIDNo ); res.ResultData = CommonUtil.ConvertToXml <dtViewBillingBasicList>(lst, "Common\\CMS400_BillingBasic", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (Flag == 2) { if (CommonUtil.IsNullOrEmpty(strInvoiceNo)) { strInvoiceNo = null; } List <dtViewBillingInvoiceListOfLastInvoiceOcc> lst = handlerViewBilling.GetViewBillingInvoiceListOfLastInvoiceOcc( strBillingClientCode, strBillingTargetCode, strBillingClientName, strBillingClientAddress, strInvoiceNo, strTaxIDNo ); //lst[0].NoOfBillingDetail = 2500; res.ResultData = CommonUtil.ConvertToXml <dtViewBillingInvoiceListOfLastInvoiceOcc>(lst, "Common\\CMS400_UncancelInvoice", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } } catch (Exception ex) { res.AddErrorMessage(ex); } return(Json(res)); }
/// <summary> /// Getting billing basic information /// </summary> /// <param name="BillingOCC"></param> /// <returns></returns> public ActionResult CMS420_LoadBillingBasicInformation(string BillingOCC) { ObjectResultData res = new ObjectResultData(); try { CMS420_ScreenParameter param = GetScreenObject <CMS420_ScreenParameter>(); CommonUtil cm = new CommonUtil(); string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); param.BillingOCC = BillingOCC; IViewBillingHandler viewBillingHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; IBillingHandler billingHandler = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); List <dtViewBillingBasic> viewBillingBasicData = viewBillingHandler.GetViewBillingBasic(strContractCode, BillingOCC, null, null, null, null); List <doTbt_MonthlyBillingHistoryList> monthlyBillingHistoryListData = billingHandler.GetBillingHistoryList(strContractCode, BillingOCC, CurrencyUtil.C_CURRENCY_LOCAL, CurrencyUtil.C_CURRENCY_US); for (int i = 0; i < viewBillingBasicData.Count(); i++) { viewBillingBasicData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } for (int i = 0; i < monthlyBillingHistoryListData.Count(); i++) { monthlyBillingHistoryListData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } ICommonHandler handlerCommon = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <object> result = new List <object>(); bool carefulFlag = false; string paymentMethod = "0"; if (viewBillingBasicData.Count > 0) { //Language mapping CommonUtil.MappingObjectLanguage <dtViewBillingBasic>(viewBillingBasicData); //Misc mapping MiscTypeMappingList miscMapping = new MiscTypeMappingList(); miscMapping.AddMiscType(viewBillingBasicData.ToArray <dtViewBillingBasic>()); handlerCommon.MiscTypeMappingList(miscMapping); carefulFlag = viewBillingBasicData[0].CarefulFlag.HasValue ? viewBillingBasicData[0].CarefulFlag.Value : false; paymentMethod = viewBillingBasicData[0].PaymentMethod; dtViewBillingBasic_ForView billingBasic = new dtViewBillingBasic_ForView() { BillingCode = string.Format("{0}-{1}", cm.ConvertContractCode(viewBillingBasicData[0].ContractCode, CommonUtil.CONVERT_TYPE.TO_SHORT), viewBillingBasicData[0].BillingOCC), BillingOffice = CommonUtil.TextCodeName(viewBillingBasicData[0].BillingOfficeCode, viewBillingBasicData[0].OfficeName), DebtTracingOffice = CommonUtil.TextCodeName(viewBillingBasicData[0].DebtTracingOfficeCode, viewBillingBasicData[0].DebtTracingOfficeName), BillingTargetCode = cm.ConvertBillingTargetCode(viewBillingBasicData[0].BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_SHORT), PreviousBillingTargetCode = cm.ConvertBillingTargetCode(viewBillingBasicData[0].PreviousBillingTargetCode, CommonUtil.CONVERT_TYPE.TO_SHORT), CustomerType = viewBillingBasicData[0].CustTypeCodeName, BillingClientNameEN = viewBillingBasicData[0].FullNameEN, BillingClientBranchNameEN = viewBillingBasicData[0].BranchNameEN, BillingClientAddressEN = viewBillingBasicData[0].AddressEN, BillingClientNameLC = viewBillingBasicData[0].FullNameLC, BillingClientBranchNameLC = viewBillingBasicData[0].BranchNameLC, BillingClientAddressLC = viewBillingBasicData[0].AddressLC, MonthlyBillingAmount = viewBillingBasicData[0].TextTransferMonthlyBillingAmount, PaymentMethod = viewBillingBasicData[0].PaymentMethodName, BillingCycle = CommonUtil.TextNumeric(viewBillingBasicData[0].BillingCycle, 0), CreditTerm = CommonUtil.TextNumeric(viewBillingBasicData[0].CreditTerm), CalculationDailyFee = viewBillingBasicData[0].CalDailyFeeStatusName, LastBillingDate = CommonUtil.TextDate(viewBillingBasicData[0].LastBillingDate), ManagementCodeForSortDetails = viewBillingBasicData[0].SortingType, AdjustEndingDateOfBillingPeriod = CommonUtil.TextDate(viewBillingBasicData[0].AdjustEndDate), BillingFlag = viewBillingBasicData[0].StopBillingFlagCodeName, VATUnchargedBillingTarget = viewBillingBasicData[0].VATUnchargedFlag.HasValue ? viewBillingBasicData[0].VATUnchargedFlag.Value : false, BalanceOfDepositFee = viewBillingBasicData[0].TextTransferBalanceDeposit, MonthlyFeeBeforeStop = viewBillingBasicData[0].TextTransferMonthlyFeeBeforeStop, ResultBasedMaintenanceBillingFlag = viewBillingBasicData[0].ResultBasedMaintenanceFlag.HasValue ? viewBillingBasicData[0].ResultBasedMaintenanceFlag.Value : false, LastPaymentConditionChangingDate = CommonUtil.TextDate(viewBillingBasicData[0].ChangeDate), RegisteringDateOfLastChanging = CommonUtil.TextDate(viewBillingBasicData[0].ChangeDate), ApproveNo = viewBillingBasicData[0].ApproveNo, DocumentReceiving = viewBillingBasicData[0].DocAuditResultName, AdjustmentType = viewBillingBasicData[0].AdjustType, AdjustBillingAmount = viewBillingBasicData[0].TextTransferAdjustBillingPeriodAmount, AdjustBillingPeriodStartDate = CommonUtil.TextDate(viewBillingBasicData[0].AdjustBillingPeriodStartDate), AdjustBillingPeriodEndDate = CommonUtil.TextDate(viewBillingBasicData[0].AdjustBillingPeriodEndDate) , IDNo = viewBillingBasicData[0].IDNo //Add by Jutarat A. on 12122013 }; result.Add(billingBasic); } else { result.Add(new dtViewBillingBasic_ForView()); } if (monthlyBillingHistoryListData.Count > 0) { doTbt_MonthlyBillingHistoryList_ForView billingHistory = new doTbt_MonthlyBillingHistoryList_ForView() { LastMonthlyBillingAmount = monthlyBillingHistoryListData[0].TextTransferMonthlyBillingAmount, LastDate = CommonUtil.TextDate(monthlyBillingHistoryListData[0].BillingStartDate), BillingAmountBeforeChanging1 = monthlyBillingHistoryListData.Count < 2 ? null : monthlyBillingHistoryListData[1].TextTransferMonthlyBillingAmount, DateBeforeChanging1 = monthlyBillingHistoryListData.Count < 2 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[1].BillingStartDate), BillingAmountBeforeChanging2 = monthlyBillingHistoryListData.Count < 3 ? null : monthlyBillingHistoryListData[2].TextTransferMonthlyBillingAmount, DateBeforeChanging2 = monthlyBillingHistoryListData.Count < 3 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[2].BillingStartDate), BillingAmountBeforeChanging3 = monthlyBillingHistoryListData.Count < 4 ? null : monthlyBillingHistoryListData[3].TextTransferMonthlyBillingAmount, DateBeforeChanging3 = monthlyBillingHistoryListData.Count < 4 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[3].BillingStartDate), BillingAmountBeforeChanging4 = monthlyBillingHistoryListData.Count < 5 ? null : monthlyBillingHistoryListData[4].TextTransferMonthlyBillingAmount, DateBeforeChanging4 = monthlyBillingHistoryListData.Count < 5 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[4].BillingStartDate), BillingAmountBeforeChanging5 = monthlyBillingHistoryListData.Count < 6 ? null : monthlyBillingHistoryListData[5].TextTransferMonthlyBillingAmount, DateBeforeChanging5 = monthlyBillingHistoryListData.Count < 6 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[5].BillingStartDate) }; result.Add(billingHistory); } else { result.Add(new doTbt_MonthlyBillingHistoryList_ForView()); } result.Add(carefulFlag); result.Add(paymentMethod); res.ResultData = result.ToArray(); return(Json(res)); } catch (Exception ex) { res.AddErrorMessage(ex); return(Json(res)); } }
/// <summary> /// Check suspend, authority and resume of CMS420 /// </summary> /// <param name="param"></param> /// <returns></returns> public ActionResult CMS420_Authority(CMS420_ScreenParameter param) { ObjectResultData res = new ObjectResultData(); try { // If param.ContractCode is null then set to CommonUtil.dsTransData.dtCommonSearch.ContractCode; if (String.IsNullOrEmpty(param.ContractCode)) { //param.strContractCode = CommonUtil.dsTransData.dtCommonSearch.ContractCode; if (param.CommonSearch != null) { if (CommonUtil.IsNullOrEmpty(param.CommonSearch.ContractCode) == false) { param.ContractCode = param.CommonSearch.ContractCode; } } } // Check permission if (CheckUserPermission(ScreenID.C_SCREEN_ID_VIEW_BILLING_BASIC_INFORMATION, FunctionID.C_FUNC_ID_OPERATE) == false) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0053); return(Json(res)); } if (param.CallerScreenID == ScreenID.C_SCREEN_ID_SEARCH_BILLING_INFORMATION) { // is parameter OK ? if (CommonUtil.IsNullOrEmpty(param.ContractCode)) { //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0040); res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0155); return(Json(res)); } if (CommonUtil.IsNullOrEmpty(param.ContractCode) && CommonUtil.IsNullOrEmpty(param.BillingOCC)) { //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0040); res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0155); return(Json(res)); } // Check data exist CommonUtil cm = new CommonUtil(); string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); IViewBillingHandler viewBillingHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); List <dtViewBillingBasic> viewBillingBasicData = viewBillingHandler.GetViewBillingBasic(strContractCode, param.BillingOCC, null, null, null, null); for (int i = 0; i < viewBillingBasicData.Count(); i++) { viewBillingBasicData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } if (viewBillingBasicData.Count == 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); // data not found return(Json(res)); } } else { // is parameter OK ? if (CommonUtil.IsNullOrEmpty(param.ContractCode)) { //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0040); res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0147); return(Json(res)); } // Check data exist CommonUtil cm = new CommonUtil(); string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); IViewBillingHandler viewBillingHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; List <dtViewBillingOccList> viewBillingOccListData = viewBillingHandler.GetViewBillingOccList(strContractCode); if (viewBillingOccListData.Count == 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); // data not found return(Json(res)); } } param.CommonSearch = new ScreenParameter.CommonSearchDo() { ContractCode = param.ContractCode }; return(InitialScreenEnvironment <CMS420_ScreenParameter>("CMS420", param, res)); } catch (Exception ex) { res.AddErrorMessage(ex); return(Json(res)); } }
public ActionResult CMS420() { ObjectResultData res = new ObjectResultData(); try { CMS420_ScreenParameter param = GetScreenObject <CMS420_ScreenParameter>(); CommonUtil cm = new CommonUtil(); ViewBag._ContractCode = param.ContractCode; ViewBag._BillingOCC = param.BillingOCC; string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); ViewBag._CallerScreen = param.CallerScreenID; IViewBillingHandler viewBillingHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; IBillingHandler billingHandler = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler; ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = MiscType.C_CURRENCT, ValueCode = "%" } }).ToList(); List <dtViewBillingOccList> viewBillingOccListData = viewBillingHandler.GetViewBillingOccList(strContractCode); List <dtViewBillingBasic> viewBillingBasicData = viewBillingHandler.GetViewBillingBasic(strContractCode, param.BillingOCC, null, null, null, null); List <doTbt_MonthlyBillingHistoryList> monthlyBillingHistoryListData = billingHandler.GetBillingHistoryList(strContractCode, param.BillingOCC, CurrencyUtil.C_CURRENCY_LOCAL, CurrencyUtil.C_CURRENCY_US); for (int i = 0; i < viewBillingOccListData.Count(); i++) { viewBillingOccListData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } for (int i = 0; i < viewBillingBasicData.Count(); i++) { viewBillingBasicData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } for (int i = 0; i < monthlyBillingHistoryListData.Count(); i++) { monthlyBillingHistoryListData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies); } ICommonHandler handlerCommon = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; ViewBag.IsSpecialCareful = "0"; ViewBag.txtVATUnchargedBillingTarget = false; ViewBag.txtResultBasedMaintenanceBillingFlag = false; if (viewBillingOccListData.Count > 0) { //Language mapping CommonUtil.MappingObjectLanguage <dtViewBillingOccList>(viewBillingOccListData); ViewBag.txtContractCode = cm.ConvertContractCode(viewBillingOccListData[0].ContractCode, CommonUtil.CONVERT_TYPE.TO_SHORT); } if (param.BillingOCC != null) { if (viewBillingBasicData.Count > 0) { //Language mapping CommonUtil.MappingObjectLanguage <dtViewBillingBasic>(viewBillingBasicData); //Misc mapping MiscTypeMappingList miscMapping = new MiscTypeMappingList(); miscMapping.AddMiscType(viewBillingBasicData.ToArray <dtViewBillingBasic>()); handlerCommon.MiscTypeMappingList(miscMapping); if (viewBillingBasicData[0].CarefulFlag.HasValue) { ViewBag.IsSpecialCareful = viewBillingBasicData[0].CarefulFlag.Value == true ? "1" : "0"; } ViewBag.IsPaymentMethod = viewBillingBasicData[0].PaymentMethod; ViewBag.txtBillingCode = string.Format("{0}-{1}", cm.ConvertContractCode(viewBillingBasicData[0].ContractCode, CommonUtil.CONVERT_TYPE.TO_SHORT), viewBillingBasicData[0].BillingOCC); ViewBag.txtBillingOffice = CommonUtil.TextCodeName(viewBillingBasicData[0].BillingOfficeCode, viewBillingBasicData[0].OfficeName); ViewBag.txtDebtTracingOffice = CommonUtil.TextCodeName(viewBillingBasicData[0].DebtTracingOfficeCode, viewBillingBasicData[0].DebtTracingOfficeName); ViewBag.txtBillingTargetCode = cm.ConvertBillingTargetCode(viewBillingBasicData[0].BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_SHORT); ViewBag.txtPreviousBillingTargetCode = cm.ConvertBillingTargetCode(viewBillingBasicData[0].PreviousBillingTargetCode, CommonUtil.CONVERT_TYPE.TO_SHORT); ViewBag.txtCustomerType = viewBillingBasicData[0].CustTypeCodeName; ViewBag.txtBillingClientNameEN = viewBillingBasicData[0].FullNameEN; ViewBag.txtBillingClientBranchNameEN = viewBillingBasicData[0].BranchNameEN; ViewBag.txtBillingClientAddressEN = viewBillingBasicData[0].AddressEN; ViewBag.txtBillingClientNameLC = viewBillingBasicData[0].FullNameLC; ViewBag.txtBillingClientBranchNameLC = viewBillingBasicData[0].BranchNameLC; ViewBag.txtBillingClientAddressLC = viewBillingBasicData[0].AddressLC; ViewBag.txtMonthlyBillingAmount = viewBillingBasicData[0].TextTransferMonthlyBillingAmount; //ViewBag.txtMonthlyBillingAmount = CommonUtil.TextNumeric(viewBillingBasicData[0].MonthlyBillingAmount); ViewBag.txtPaymentMethod = viewBillingBasicData[0].PaymentMethodName; ViewBag.txtBillingCycle = CommonUtil.TextNumeric(viewBillingBasicData[0].BillingCycle, 0); ViewBag.txtCreditTerm = CommonUtil.TextNumeric(viewBillingBasicData[0].CreditTerm); ViewBag.txtCalculationDailyFee = viewBillingBasicData[0].CalDailyFeeStatusName; ViewBag.txtLastBillingDate = CommonUtil.TextDate(viewBillingBasicData[0].LastBillingDate); ViewBag.txtManagementCodeForSortDetails = viewBillingBasicData[0].SortingType; ViewBag.txtAdjustEndingDateOfBillingPeriod = CommonUtil.TextDate(viewBillingBasicData[0].AdjustEndDate); ViewBag.txtBillingFlag = viewBillingBasicData[0].StopBillingFlagCodeName; ViewBag.txtVATUnchargedBillingTarget = viewBillingBasicData[0].VATUnchargedFlag.HasValue ? viewBillingBasicData[0].VATUnchargedFlag.Value : false; ViewBag.txtBalanceOfDepositFee = viewBillingBasicData[0].TextTransferBalanceDeposit; //ViewBag.txtBalanceOfDepositFee = CommonUtil.TextNumeric(viewBillingBasicData[0].BalanceDeposit); ViewBag.txtMonthlyFeeBeforeStop = viewBillingBasicData[0].TextTransferMonthlyFeeBeforeStop; //ViewBag.txtMonthlyFeeBeforeStop = CommonUtil.TextNumeric(viewBillingBasicData[0].MonthlyFeeBeforeStop); ViewBag.txtResultBasedMaintenanceBillingFlag = viewBillingBasicData[0].ResultBasedMaintenanceFlag.HasValue ? viewBillingBasicData[0].ResultBasedMaintenanceFlag.Value : false; ViewBag.txtLastPaymentConditionChangingDate = CommonUtil.TextDate(viewBillingBasicData[0].ChangeDate); ViewBag.txtRegisteringDateOfLastChanging = CommonUtil.TextDate(viewBillingBasicData[0].ChangeDate); ViewBag.txtApproveNo = viewBillingBasicData[0].ApproveNo; ViewBag.txtDocumentReceiving = viewBillingBasicData[0].DocAuditResultName; ViewBag.txtAdjustmentType = viewBillingBasicData[0].AdjustType; ViewBag.txtAdjustBillingAmount = viewBillingBasicData[0].TextTransferAdjustBillingPeriodAmount; //ViewBag.txtAdjustBillingAmount = CommonUtil.TextNumeric(viewBillingBasicData[0].AdjustBillingPeriodAmount); ViewBag.txtAdjustBillingPeriodStartDate = CommonUtil.TextDate(viewBillingBasicData[0].AdjustBillingPeriodStartDate); ViewBag.txtAdjustBillingPeriodEndDate = CommonUtil.TextDate(viewBillingBasicData[0].AdjustBillingPeriodEndDate); ViewBag.txtIDNo = viewBillingBasicData[0].IDNo; //Add by Jutarat A. on 12122013 } if (monthlyBillingHistoryListData != null) { if (monthlyBillingHistoryListData.Count > 0) { ViewBag.txtLastMonthlyBillingAmount = monthlyBillingHistoryListData[0].TextTransferMonthlyBillingAmount; ViewBag.txtLastDate = CommonUtil.TextDate(monthlyBillingHistoryListData[0].BillingStartDate); ViewBag.txtBillingAmountBeforeChanging1 = monthlyBillingHistoryListData.Count < 2 ? null : monthlyBillingHistoryListData[1].TextTransferMonthlyBillingAmount; ViewBag.txtDateBeforeChanging1 = monthlyBillingHistoryListData.Count < 2 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[1].BillingStartDate); ViewBag.txtBillingAmountBeforeChanging2 = monthlyBillingHistoryListData.Count < 3 ? null : monthlyBillingHistoryListData[2].TextTransferMonthlyBillingAmount; ViewBag.txtDateBeforeChanging2 = monthlyBillingHistoryListData.Count < 3 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[2].BillingStartDate); ViewBag.txtBillingAmountBeforeChanging3 = monthlyBillingHistoryListData.Count < 4 ? null : monthlyBillingHistoryListData[3].TextTransferMonthlyBillingAmount; ViewBag.txtDateBeforeChanging3 = monthlyBillingHistoryListData.Count < 4 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[3].BillingStartDate); ViewBag.txtBillingAmountBeforeChanging4 = monthlyBillingHistoryListData.Count < 5 ? null : monthlyBillingHistoryListData[4].TextTransferMonthlyBillingAmount; ViewBag.txtDateBeforeChanging4 = monthlyBillingHistoryListData.Count < 5 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[4].BillingStartDate); ViewBag.txtBillingAmountBeforeChanging5 = monthlyBillingHistoryListData.Count < 6 ? null : monthlyBillingHistoryListData[5].TextTransferMonthlyBillingAmount; ViewBag.txtDateBeforeChanging5 = monthlyBillingHistoryListData.Count < 6 ? null : CommonUtil.TextDate(monthlyBillingHistoryListData[5].BillingStartDate); } } } //Finding service type code if (string.IsNullOrEmpty(strContractCode) == false) { //Rental IRentralContractHandler handlerR = ServiceContainer.GetService <IRentralContractHandler>() as IRentralContractHandler; List <tbt_RentalContractBasic> dtRentalContract = handlerR.GetTbt_RentalContractBasic(strContractCode, null); if (dtRentalContract.Count > 0) { param.ServiceTypeCode = ServiceType.C_SERVICE_TYPE_RENTAL; ViewBag.ServiceTypeCode = ServiceType.C_SERVICE_TYPE_RENTAL; ViewBag.ProductTypeCode = dtRentalContract[0].ProductTypeCode; } else { // Sale ISaleContractHandler handlerS = ServiceContainer.GetService <ISaleContractHandler>() as ISaleContractHandler; List <tbt_SaleBasic> dtSaleContract = handlerS.GetTbt_SaleBasic(strContractCode, null, true); if (dtSaleContract.Count > 0) { param.ServiceTypeCode = ServiceType.C_SERVICE_TYPE_SALE; ViewBag.ServiceTypeCode = ServiceType.C_SERVICE_TYPE_SALE; ViewBag.ProductTypeCode = dtSaleContract[0].ProductTypeCode; } } } return(View()); } catch (Exception ex) { res.AddErrorMessage(ex); return(Json(res)); } }
/// <summary> /// Check suspend, authority and resume of CMS450 /// </summary> /// <param name="param">Screen parameter</param> /// <returns></returns> public ActionResult CMS450_Authority(CMS450_ScreenParameter param) { ObjectResultData res = new ObjectResultData(); try { // Check permission if (CheckUserPermission(ScreenID.C_SCREEN_ID_VIEW_BILLING_DETAIL, FunctionID.C_FUNC_ID_OPERATE) == false) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0053); return(Json(res)); } // is parameter OK ? if (CommonUtil.IsNullOrEmpty(param.BillingTargetCode) && CommonUtil.IsNullOrEmpty(param.ContractCode) && CommonUtil.IsNullOrEmpty(param.BillingOCC) && CommonUtil.IsNullOrEmpty(param.InvoiceNo)) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0156); return(Json(res)); } // data is exist ? CommonUtil cm = new CommonUtil(); IBillingHandler handlerBilling = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler; IViewBillingHandler handlerViewBilling = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; List <dtTbt_BillingTargetForView> listBillingTarget = new List <dtTbt_BillingTargetForView>(); if (!CommonUtil.IsNullOrEmpty(param.BillingTargetCode)) { listBillingTarget = handlerBilling.GetTbt_BillingTargetForView(cm.ConvertBillingTargetCode(param.BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG), MiscType.C_CUST_TYPE); if (listBillingTarget.Count <= 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); return(Json(res)); } } else if (!CommonUtil.IsNullOrEmpty(param.BillingOCC) && !CommonUtil.IsNullOrEmpty(param.ContractCode)) { //GetBillingDetailOfBillingCode string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); List <dtTbt_BillingBasicForView> listBillingBasicForView = handlerBilling.GetTbt_BillingBasicForView(strContractCode, param.BillingOCC); if (listBillingBasicForView.Count <= 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); return(Json(res)); } } else if (!CommonUtil.IsNullOrEmpty(param.InvoiceNo)) { List <dtViewBillingDetailListOfLastInvoiceOCC> listBillingDetailListOfLastInvoiceOCC = handlerViewBilling.GetViewBillingDetailListOfLastInvoiceOCC(param.InvoiceNo, null, null, null, null); if (listBillingDetailListOfLastInvoiceOCC.Count <= 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); return(Json(res)); } } else { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0156); return(Json(res)); } } catch (Exception ex) { res.AddErrorMessage(ex); } return(InitialScreenEnvironment <CMS450_ScreenParameter>("CMS450", param, res)); }
public ActionResult CMS450() { ObjectResultData res = new ObjectResultData(); CMS450_ScreenParameter param = GetScreenObject <CMS450_ScreenParameter>(); CommonUtil cm = new CommonUtil(); // Prepare for show section ViewBag._ContractCode = param.ContractCode; ViewBag._BillingOCC = param.BillingOCC; ViewBag._BillingTargetCode = param.BillingTargetCode; ViewBag._InvoiceNo = param.InvoiceNo; try { IBillingHandler handlerBilling = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler; IViewBillingHandler handlerViewBilling = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; if (!CommonUtil.IsNullOrEmpty(param.BillingTargetCode)) { List <dtTbt_BillingTargetForView> listBillingTarget = handlerBilling.GetTbt_BillingTargetForView(cm.ConvertBillingTargetCode(param.BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG), MiscType.C_CUST_TYPE); if (listBillingTarget.Count > 0) { ViewBag.txtBillingTargetCode = listBillingTarget[0].BillingTargetCode_Short; ViewBag.txtBillingClientNameEnglish = listBillingTarget[0].FullNameEN; ViewBag.txtBillingClientAddressEnglish = listBillingTarget[0].AddressEN; ViewBag.txtBillingClientNameLocal = listBillingTarget[0].FullNameLC; ViewBag.txtBillingClientAddressLocal = listBillingTarget[0].AddressLC; } } else if (!CommonUtil.IsNullOrEmpty(param.BillingOCC) && !CommonUtil.IsNullOrEmpty(param.ContractCode)) { //GetBillingDetailOfBillingCode string strContractCode = cm.ConvertContractCode(param.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); List <dtTbt_BillingBasicForView> listBillingBasicForView = handlerBilling.GetTbt_BillingBasicForView(strContractCode, param.BillingOCC); if (listBillingBasicForView.Count > 0) { ViewBag.txtBillingCode = cm.ConvertBillingCode(listBillingBasicForView[0].BillingCode, CommonUtil.CONVERT_TYPE.TO_SHORT); ViewBag.txtBillingOffice = listBillingBasicForView[0].OfficeName; ViewBag.txtBillingTargetCode = cm.ConvertBillingTargetCode(listBillingBasicForView[0].BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_SHORT); ViewBag.txtBillingClientNameEnglish = listBillingBasicForView[0].FullNameEN; ViewBag.txtBillingClientAddressEnglish = listBillingBasicForView[0].AddressEN; ViewBag.txtBillingClientNameLocal = listBillingBasicForView[0].FullNameLC; ViewBag.txtBillingClientAddressLocal = listBillingBasicForView[0].AddressLC; } } else if (!CommonUtil.IsNullOrEmpty(param.InvoiceNo)) { List <dtViewBillingDetailListOfLastInvoiceOCC> listBillingDetailListOfLastInvoiceOCC = handlerViewBilling.GetViewBillingDetailListOfLastInvoiceOCC(param.InvoiceNo, null, null, null, null); if (listBillingDetailListOfLastInvoiceOCC.Count > 0) { ViewBag.txtInvoiceNo = listBillingDetailListOfLastInvoiceOCC[0].InvoiceNo; ViewBag.txtBillingTargetCode = cm.ConvertBillingTargetCode(listBillingDetailListOfLastInvoiceOCC[0].BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_SHORT); ViewBag.txtBillingClientNameEnglish = listBillingDetailListOfLastInvoiceOCC[0].FullNameEN; ViewBag.txtBillingClientAddressEnglish = listBillingDetailListOfLastInvoiceOCC[0].AddressEN; ViewBag.txtBillingClientNameLocal = listBillingDetailListOfLastInvoiceOCC[0].FullNameLC; ViewBag.txtBillingClientAddressLocal = listBillingDetailListOfLastInvoiceOCC[0].AddressLC; } } else { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0040); return(Json(res)); } } catch (Exception ex) { res.AddErrorMessage(ex); } return(View()); }
/// <summary> /// If user input ContractCode or UserCode retrieve contract data from tbt_RentalContractBasic or tbt_SaleBasic.<br /> /// Else if user input ProjectCode retrieve project data from tbt_Project.<br /> /// Else if user input InvoiceNo get billing details of last invoice OCC. /// </summary> /// <param name="ContractCode"></param> /// <param name="UserCode"></param> /// <param name="InvoiceNo"></param> /// <param name="ProjectCode"></param> /// <returns></returns> public ActionResult CMS020_Retrive(string ContractCode, string UserCode, string InvoiceNo, string ProjectCode) { CommonUtil cm = new CommonUtil(); dtSearchBarData data = new dtSearchBarData(); ObjectResultData res = new ObjectResultData(); res.MessageType = MessageModel.MESSAGE_TYPE.WARNING_DIALOG; List <string> list = new List <string>(); if (CommonUtil.IsNullOrEmpty(ContractCode) == false) { list.Add(ContractCode); } if (CommonUtil.IsNullOrEmpty(UserCode) == false) { list.Add(UserCode); } if (CommonUtil.IsNullOrEmpty(InvoiceNo) == false) { list.Add(InvoiceNo); } if (CommonUtil.IsNullOrEmpty(ProjectCode) == false) { list.Add(ProjectCode); } if (list.Count > 1) { // Input more than one criteria --> Retrun message res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0117); return(Json(res)); } else if (list.Count == 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0006); return(Json(res)); } try { // Case goto CMS190 if (CommonUtil.IsNullOrEmpty(ContractCode) == false || CommonUtil.IsNullOrEmpty(UserCode) == false) { dsContractData contractData = new dsContractData(); contractData = CMS020_RetrieveContract(ContractCode, UserCode); if (contractData.dtRCB == null && contractData.dtSB == null) { // Return message MSG0102 // This contract code does not exist. res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0133); return(Json(res)); } bool isRCBNull = true; if (contractData.dtRCB != null) { if (CommonUtil.IsNullOrEmpty(UserCode) == false && contractData.dtRCB.Count > 1) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0157); return(Json(res)); } else if (contractData.dtRCB.Count > 0) { data.ContractCode = cm.ConvertContractCode(contractData.dtRCB[0].ContractCode, CommonUtil.CONVERT_TYPE.TO_SHORT); data.ServiceType = contractData.dtRCB[0].ServiceTypeCode; data.Mode = "CMS190"; isRCBNull = false; } } if (isRCBNull == true) { if (contractData.dtSB != null) { if (contractData.dtSB.Count > 0) { data.ContractCode = cm.ConvertContractCode(contractData.dtSB[0].ContractCode, CommonUtil.CONVERT_TYPE.TO_SHORT); data.ServiceType = contractData.dtSB[0].ServiceTypeCode; data.Mode = "CMS190"; } } } //if (data.ContractCode != null) // CommonUtil.dsTransData.dtCommonSearch.ContractCode = data.ContractCode; } else if (CommonUtil.IsNullOrEmpty(ProjectCode) == false) { IProjectHandler pHandler = ServiceContainer.GetService <IProjectHandler>() as IProjectHandler; List <tbt_Project> lst = pHandler.GetTbt_Project(ProjectCode); if (lst.Count == 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0091, new string[] { ProjectCode }); return(Json(res)); } data.ProjectCode = ProjectCode; data.Mode = "CTS260"; //CommonUtil.dsTransData.dtCommonSearch.ProjectCode = ProjectCode; } else if (CommonUtil.IsNullOrEmpty(InvoiceNo) == false) { IViewBillingHandler bHandler = ServiceContainer.GetService <IViewBillingHandler>() as IViewBillingHandler; List <dtViewBillingDetailListOfLastInvoiceOCC> lst = bHandler.GetViewBillingDetailListOfLastInvoiceOCC(InvoiceNo, null, null, null, null); if (lst.Count == 0) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0150, new string[] { InvoiceNo }); return(Json(res)); } data.InvoiceNo = InvoiceNo; data.Mode = "CMS450"; //CommonUtil.dsTransData.dtCommonSearch.InvoiceNo = InvoiceNo; } } catch (Exception ex) { res.AddErrorMessage(ex); return(Json(res)); } return(Json(data)); }