/// <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));
}
