/// <summary> /// Search data and send to show in grid search result /// </summary> /// <param name="searchCriteria"></param> /// <returns></returns> public ActionResult ISS080_SearchDataToGrid(doSearchInstallManageCriteria searchCriteria) { ObjectResultData res = new ObjectResultData(); res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; CommonUtil comUtil = new CommonUtil(); string lang = CommonUtil.GetCurrentLanguage(); ISS080_RegisterStartResumeTargetData result = new ISS080_RegisterStartResumeTargetData(); try { searchCriteria.ContractCode = comUtil.ConvertContractCode(searchCriteria.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); searchCriteria.ProjectCode = comUtil.ConvertProjectCode(searchCriteria.ProjectCode, CommonUtil.CONVERT_TYPE.TO_LONG); if (searchCriteria.ContractCode == null && searchCriteria.IEStaffCode == null && searchCriteria.InstallationCompleteDateFrom == null && searchCriteria.InstallationCompleteDateTo == null && searchCriteria.InstallationFinishDateFrom == null && searchCriteria.InstallationFinishDateTo == null && searchCriteria.InstallationManagementStatus == null && searchCriteria.InstallationStartDateFrom == null && searchCriteria.InstallationStartDateTo == null && searchCriteria.InstallationType == null && searchCriteria.OperationOfficeCode == null && searchCriteria.ProjectCode == null && searchCriteria.ProposedInstallationCompleteDateFrom == null && searchCriteria.ProposedInstallationCompleteDateTo == null && searchCriteria.SiteAddress == null && searchCriteria.SiteName == null && searchCriteria.SubcontractorCode == null && searchCriteria.SubcontractorGroupName == null && searchCriteria.InstallationRequestDateFrom == null && //Add by Jutarat A. on 22102013 searchCriteria.InstallationRequestDateTo == null && //Add by Jutarat A. on 22102013 searchCriteria.ExpectedInstallationStartDateFrom == null && searchCriteria.ExpectedInstallationStartDateTo == null && searchCriteria.ExpectedInstallationFinishDateFrom == null && searchCriteria.ExpectedInstallationFinishDateTo == null ) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0006); return(Json(res)); } res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; ///////////// START RETRIEVE DATA //////////////////////// IInstallationHandler iHandler = ServiceContainer.GetService <IInstallationHandler>() as IInstallationHandler; List <doSearchInstallManagementResult> dtSearchResult = iHandler.SearchInstallationManagementList(searchCriteria); if (dtSearchResult == null) { //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); //return Json(res); } else { foreach (doSearchInstallManagementResult dtSearchData in dtSearchResult) { //================== Get Installation Type Name =================== if (!CommonUtil.IsNullOrEmpty(dtSearchData.InstallationType)) { List <doMiscTypeCode> miscs = new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = "RentalInstallationType", ValueCode = dtSearchData.InstallationType } }; ICommonHandler hand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> lst = hand.GetMiscTypeCodeList(miscs); if (lst.Count > 0) { dtSearchData.InstallationType = lst[0].ValueDisplay; } else { miscs = new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = "SaleInstallationType", ValueCode = dtSearchData.InstallationType } }; lst = hand.GetMiscTypeCodeList(miscs); if (lst.Count > 0) { dtSearchData.InstallationType = lst[0].ValueDisplay; } } } //======================================================= //================ Get management Status Name ============== dtSearchData.InstallationManagementStatus = ISS080_GetMiscDisplayByValueCode("InstallationManagementStatus", dtSearchData.InstallationManagementStatus); //========================================================== //=================== Convert Contract Code ======================== if (dtSearchData.ServiceTypeCode == ServiceType.C_SERVICE_TYPE_PROJECT) { dtSearchData.ContractProjectCode = comUtil.ConvertProjectCode(dtSearchData.ContractProjectCode, CommonUtil.CONVERT_TYPE.TO_SHORT); } else { dtSearchData.ContractProjectCode = comUtil.ConvertContractCode(dtSearchData.ContractProjectCode, CommonUtil.CONVERT_TYPE.TO_SHORT); } //================================================================== if (lang == SECOM_AJIS.Common.Util.ConstantValue.CommonValue.DEFAULT_LANGUAGE_EN) { dtSearchData.IEStaffName1 = dtSearchData.IEStaffName1EN; dtSearchData.IEStaffName2 = dtSearchData.IEStaffName2EN; dtSearchData.SubcontractorName = dtSearchData.SubcontractorNameEN; dtSearchData.OperationOfficeName = dtSearchData.OperationOfficeNameEN; } else if (lang == SECOM_AJIS.Common.Util.ConstantValue.CommonValue.DEFAULT_LANGUAGE_JP) { dtSearchData.IEStaffName1 = dtSearchData.IEStaffName1EN; dtSearchData.IEStaffName2 = dtSearchData.IEStaffName2EN; dtSearchData.SubcontractorName = dtSearchData.SubcontractorNameEN; dtSearchData.OperationOfficeName = dtSearchData.OperationOfficeNameEN; } else if (lang == SECOM_AJIS.Common.Util.ConstantValue.CommonValue.DEFAULT_LANGUAGE_LC) { dtSearchData.IEStaffName1 = dtSearchData.IEStaffName1LC; dtSearchData.IEStaffName2 = dtSearchData.IEStaffName2LC; dtSearchData.SubcontractorName = dtSearchData.SubcontractorNameLC; dtSearchData.OperationOfficeName = dtSearchData.OperationOfficeNameLC; } } } result.doSearchData = dtSearchResult; if (dtSearchResult != null && dtSearchResult.Count > 0) { foreach (doSearchInstallManagementResult data in dtSearchResult) { string strInstallationStartDate = (CommonUtil.IsNullOrEmpty(data.InstallationStartDate) ? "-" : ((DateTime)data.InstallationStartDate).ToString("dd-MMM-yyyy")); string strInstallationFinishDate = (CommonUtil.IsNullOrEmpty(data.InstallationFinishDate) ? "-" : ((DateTime)data.InstallationFinishDate).ToString("dd-MMM-yyyy")); string strProposedInstallationCompleteDate = (CommonUtil.IsNullOrEmpty(data.ProposedInstallationCompleteDate) ? "-" : ((DateTime)data.ProposedInstallationCompleteDate).ToString("dd-MMM-yyyy")); string strActualInstallationCompleteDate = (CommonUtil.IsNullOrEmpty(data.ActualInstallationCompleteDate) ? "-" : ((DateTime)data.ActualInstallationCompleteDate).ToString("dd-MMM-yyyy")); string strInstallationRequestDate = (CommonUtil.IsNullOrEmpty(data.InstallationRequestDate) ? "-" : ((DateTime)data.InstallationRequestDate).ToString("dd-MMM-yyyy")); //Add by Jutarat A. on 22102013 if (CommonUtil.IsNullOrEmpty(data.ContractProjectCode)) { data.ContractProjectCode = "-"; } if (CommonUtil.IsNullOrEmpty(data.InstallationType)) { data.InstallationType = "-"; } if (CommonUtil.IsNullOrEmpty(data.IEStaffName1)) { data.IEStaffName1 = "-"; } if (CommonUtil.IsNullOrEmpty(data.IEStaffName2)) { data.IEStaffName2 = "-"; } if (CommonUtil.IsNullOrEmpty(data.SubcontractorName)) { data.SubcontractorName = "-"; } if (CommonUtil.IsNullOrEmpty(data.SubcontractorGroupName)) { data.SubcontractorGroupName = "-"; } if (CommonUtil.IsNullOrEmpty(data.SiteCode)) { data.SiteCode = "-"; } else { data.SiteCode = comUtil.ConvertSiteCode(data.SiteCode, CommonUtil.CONVERT_TYPE.TO_SHORT); } if (CommonUtil.IsNullOrEmpty(data.SiteNameEN)) { data.SiteNameEN = "-"; } if (CommonUtil.IsNullOrEmpty(data.SiteNameLC)) { data.SiteNameLC = "-"; } if (CommonUtil.IsNullOrEmpty(data.OperationOfficeName)) { data.OperationOfficeName = "-"; } if (CommonUtil.IsNullOrEmpty(data.InstallationManagementStatus)) { data.InstallationManagementStatus = "-"; } data.ContractProjectCode = data.ContractProjectCode + "<br />" + data.InstallationType; data.IEStaffName = "(1) " + data.IEStaffName1 + "<br />" + "(2) " + data.IEStaffName2; data.Subcontractor = "(1) " + data.SubcontractorName + "<br />" + "(2) " + data.SubcontractorGroupName + "<br />" + "(3) " + data.NoOfSubcontractor; //data.IntsallationDate = "(1) " + strInstallationStartDate + "<br />" + // "(2) " + strInstallationFinishDate + // "<br />(3) " + strProposedInstallationCompleteDate + "<br />" + // "(4) " + strActualInstallationCompleteDate; data.IntsallationDate = "(1) " + strInstallationRequestDate + "<br />" + "(2) " + strProposedInstallationCompleteDate + "<br />" + "(3) " + data.ExpectInstallStartDate + "<br />" + "(4) " + data.ExpectInstallFinishDate + "<br />" + "(5) " + strInstallationStartDate + "<br />" + "(6) " + strInstallationFinishDate + "<br />" + "(7) " + strActualInstallationCompleteDate; //Modify (Add InstallationRequestDate) by Jutarat A. on 22102013 data.Site = "(1) " + data.SiteCode + "<br />" + "(2) " + data.SiteNameEN + "<br />" + "(3) " + data.SiteNameLC; data.OperationOffice = data.OperationOfficeName; } } //res.ResultData = result; res.ResultData = CommonUtil.ConvertToXml <doSearchInstallManagementResult>(dtSearchResult, "Installation\\ISS080_InstallManagementList", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } catch (Exception ex) { res.AddErrorMessage(ex); } return(Json(res)); }
/// <summary> /// ISS080 retrieve data /// </summary> /// <param name="searchCriteria"></param> /// <returns></returns> public ActionResult ISS080_RetrieveData(doSearchInstallManageCriteria searchCriteria) { ObjectResultData res = new ObjectResultData(); res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; CommonUtil comUtil = new CommonUtil(); string lang = CommonUtil.GetCurrentLanguage(); ISS080_RegisterStartResumeTargetData result = new ISS080_RegisterStartResumeTargetData(); try { searchCriteria.ContractCode = comUtil.ConvertContractCode(searchCriteria.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); searchCriteria.ProjectCode = comUtil.ConvertProjectCode(searchCriteria.ProjectCode, CommonUtil.CONVERT_TYPE.TO_LONG); if (searchCriteria.ContractCode == null && searchCriteria.IEStaffCode == null && searchCriteria.InstallationCompleteDateFrom == null && searchCriteria.InstallationCompleteDateTo == null && searchCriteria.InstallationFinishDateFrom == null && searchCriteria.InstallationFinishDateTo == null && searchCriteria.InstallationManagementStatus == null && searchCriteria.InstallationStartDateFrom == null && searchCriteria.InstallationStartDateTo == null && searchCriteria.InstallationType == null && searchCriteria.OperationOfficeCode == null && searchCriteria.ProjectCode == null && searchCriteria.ProposedInstallationCompleteDateFrom == null && searchCriteria.ProposedInstallationCompleteDateTo == null && searchCriteria.SiteAddress == null && searchCriteria.SiteName == null && searchCriteria.SubcontractorCode == null && searchCriteria.SubcontractorGroupName == null && searchCriteria.InstallationRequestDateFrom == null && //Add by Jutarat A. on 22102013 searchCriteria.InstallationRequestDateTo == null //Add by Jutarat A. on 22102013 ) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0006); return(Json(res)); } res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; ///////////// START RETRIEVE DATA //////////////////////// IInstallationHandler iHandler = ServiceContainer.GetService <IInstallationHandler>() as IInstallationHandler; List <doSearchInstallManagementResult> dtSearchResult = iHandler.SearchInstallationManagementList(searchCriteria); if (dtSearchResult == null) { //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0001); //return Json(res); } else { foreach (doSearchInstallManagementResult dtSearchData in dtSearchResult) { //================== Get Installation Type Name =================== if (!CommonUtil.IsNullOrEmpty(dtSearchData.InstallationType)) { List <doMiscTypeCode> miscs = new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = "RentalInstallationType", ValueCode = dtSearchData.InstallationType } }; ICommonHandler hand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <doMiscTypeCode> lst = hand.GetMiscTypeCodeList(miscs); if (lst.Count > 0) { dtSearchData.InstallationType = lst[0].ValueDisplay; } else { miscs = new List <doMiscTypeCode>() { new doMiscTypeCode() { FieldName = "SaleInstallationType", ValueCode = dtSearchData.InstallationType } }; lst = hand.GetMiscTypeCodeList(miscs); if (lst.Count > 0) { dtSearchData.InstallationType = lst[0].ValueDisplay; } } } //======================================================= //================ Get management Status Name ============== if (dtSearchData.InstallationManagementStatus == InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_PROCESSING) { dtSearchData.InstallationManagementStatus = ISS080_GetMiscDisplayByValueCode("InstallationManagementStatus", InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_PROCESSING);//"Processing"; } else if (dtSearchData.InstallationManagementStatus == InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_REQUEST_APPROVE) { dtSearchData.InstallationManagementStatus = ISS080_GetMiscDisplayByValueCode("InstallationManagementStatus", InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_REQUEST_APPROVE);//"Request approve"; } else if (dtSearchData.InstallationManagementStatus == InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_APPROVED) { dtSearchData.InstallationManagementStatus = ISS080_GetMiscDisplayByValueCode("InstallationManagementStatus", InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_APPROVED);//"Approved"; } else if (dtSearchData.InstallationManagementStatus == InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_REJECTED) { dtSearchData.InstallationManagementStatus = ISS080_GetMiscDisplayByValueCode("InstallationManagementStatus", InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_REJECTED);//"Rejected"; } else if (dtSearchData.InstallationManagementStatus == InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_COMPLETED) { dtSearchData.InstallationManagementStatus = ISS080_GetMiscDisplayByValueCode("InstallationManagementStatus", InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_COMPLETED);//"Completed"; } else if (dtSearchData.InstallationManagementStatus == InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_CANCELED) { dtSearchData.InstallationManagementStatus = ISS080_GetMiscDisplayByValueCode("InstallationManagementStatus", InstallationManagementStatus.C_INSTALL_MANAGE_STATUS_CANCELED);//"Canceled"; } //========================================================== //=================== Convert Contract Code ======================== if (dtSearchData.ServiceTypeCode == ServiceType.C_SERVICE_TYPE_PROJECT) { dtSearchData.ContractProjectCode = comUtil.ConvertProjectCode(dtSearchData.ContractProjectCode, CommonUtil.CONVERT_TYPE.TO_SHORT); } else { dtSearchData.ContractProjectCode = comUtil.ConvertContractCode(dtSearchData.ContractProjectCode, CommonUtil.CONVERT_TYPE.TO_SHORT); } //================================================================== if (lang == SECOM_AJIS.Common.Util.ConstantValue.CommonValue.DEFAULT_LANGUAGE_EN) { dtSearchData.IEStaffName1 = dtSearchData.IEStaffName1EN; dtSearchData.IEStaffName2 = dtSearchData.IEStaffName2EN; dtSearchData.SubcontractorName = dtSearchData.SubcontractorNameEN; dtSearchData.OperationOfficeName = dtSearchData.OperationOfficeNameEN; } else if (lang == SECOM_AJIS.Common.Util.ConstantValue.CommonValue.DEFAULT_LANGUAGE_JP) { dtSearchData.IEStaffName1 = dtSearchData.IEStaffName1EN; dtSearchData.IEStaffName2 = dtSearchData.IEStaffName2EN; dtSearchData.SubcontractorName = dtSearchData.SubcontractorNameEN; dtSearchData.OperationOfficeName = dtSearchData.OperationOfficeNameEN; } else if (lang == SECOM_AJIS.Common.Util.ConstantValue.CommonValue.DEFAULT_LANGUAGE_LC) { dtSearchData.IEStaffName1 = dtSearchData.IEStaffName1LC; dtSearchData.IEStaffName2 = dtSearchData.IEStaffName2LC; dtSearchData.SubcontractorName = dtSearchData.SubcontractorNameLC; dtSearchData.OperationOfficeName = dtSearchData.OperationOfficeNameLC; } } } result.doSearchData = dtSearchResult; res.ResultData = result; } catch (Exception ex) { res.AddErrorMessage(ex); } return(Json(res)); }