public virtual List <dtInstallationHistoryForView> GetTbt_InstallationHistoryForView(string c_SERVICE_TYPE_SALE, string c_SERVICE_TYPE_RENTAL, string c_SALE_INSTALL_TYPE, string c_RENTAL_INSTALL_TYPE, string c_CHANGE_REASON_TYPE_CUSTOMER, string c_CHANGE_REASON_TYPE_SECOM, string c_CUSTOMER_REASON, string c_SECOM_REASON, string contractProjectCode, string maintenanceNo, string slipNo, string c_CURRENCY_LOCAL, string c_CURRENCY_US)
{
ISDataEntities context = new ISDataEntities();
return(context.GetTbt_InstallationHistoryForView(c_SERVICE_TYPE_SALE, c_SERVICE_TYPE_RENTAL, c_SALE_INSTALL_TYPE, c_RENTAL_INSTALL_TYPE, c_CHANGE_REASON_TYPE_CUSTOMER, c_CHANGE_REASON_TYPE_SECOM, c_CUSTOMER_REASON, c_SECOM_REASON, contractProjectCode, maintenanceNo, slipNo, c_CURRENCY_LOCAL, c_CURRENCY_US).ToList());
}
public virtual List <tbt_InstallationBasic> GetTbt_InstallationBasic(string pContractProjectCode)
{
ISDataEntities context = new ISDataEntities();
return(context.GetTbt_InstallationBasic(pContractProjectCode).ToList());
}
public virtual List <tbt_InstallationManagement> InsertTbt_InstallationManagement(string maintenanceNo, string contractProjectCode, string managementStatus, Nullable <System.DateTime> proposeInstallStartDate, Nullable <System.DateTime> proposeInstallCompleteDate, string customerStaffBelonging, string customerStaffName, string customerStaffPhoneNo, Nullable <System.DateTime> newPhoneLineOpenDate, string newConnectionPhoneNo, string newPhoneLineOwnerTypeCode, string iEStaffEmpNo1, string iEStaffEmpNo2, Nullable <int> iEManPower, Nullable <decimal> materialFee, Nullable <decimal> materialFeeUsd, string materialFeeCurrencyType, string requestMemo, string pOMemo, string changeReasonCode, string changeReasonOther, string changeRequestorCode, string changeRequestorOther, Nullable <bool> newBldMgmtFlag, Nullable <decimal> newBldMgmtCost, Nullable <decimal> newBldMgmtCostUsd, string newBldMgmtCostCurrencyType, Nullable <System.DateTime> createDate, string createBy, Nullable <System.DateTime> updateDate, string updateBy, string approveNo)
{
ISDataEntities context = new ISDataEntities();
return(context.InsertTbt_InstallationManagement(maintenanceNo, contractProjectCode, managementStatus, proposeInstallStartDate, proposeInstallCompleteDate, customerStaffBelonging, customerStaffName, customerStaffPhoneNo, newPhoneLineOpenDate, newConnectionPhoneNo, newPhoneLineOwnerTypeCode, iEStaffEmpNo1, iEStaffEmpNo2, iEManPower, materialFee, materialFeeUsd, materialFeeCurrencyType, requestMemo, pOMemo, changeReasonCode, changeReasonOther, changeRequestorCode, changeRequestorOther, newBldMgmtFlag, newBldMgmtCost, newBldMgmtCostUsd, newBldMgmtCostCurrencyType, createDate, createBy, updateDate, updateBy, approveNo).ToList());
}
public virtual List <tbt_InstallationHistory> UpdateTbt_InstallationHistory(string xmlTbt_InstallationHistory)
{
ISDataEntities context = new ISDataEntities();
return(context.UpdateTbt_InstallationHistory(xmlTbt_InstallationHistory).ToList());
}
public virtual List <RptISR110InstallCompleteConfirmDo> GetRptISR110InstallCompleteConfirmData(string pSlipNo, string c_SERVICE_TYPE_SALE, string c_SERVICE_TYPE_RENTAL, string c_SALE_INSTALL_TYPE, string c_RENTAL_INSTALL_TYPE)
{
ISDataEntities context = new ISDataEntities();
return(context.GetRptISR110InstallCompleteConfirmData(pSlipNo, c_SERVICE_TYPE_SALE, c_SERVICE_TYPE_RENTAL, c_SALE_INSTALL_TYPE, c_RENTAL_INSTALL_TYPE).ToList());
}
public virtual List <InstallationBooking> GetInstallationBooking(string slipNo)
{
ISDataEntities context = new ISDataEntities();
return(context.GetInstallationBooking(slipNo).ToList());
}
public virtual List <dtGetInstallationReport> GetInstallationReport(string subConstractor, Nullable <System.DateTime> lastPaidDateFrom, Nullable <System.DateTime> lastPaidDateTo)
{
ISDataEntities context = new ISDataEntities();
return(context.GetInstallationReport(subConstractor, lastPaidDateFrom, lastPaidDateTo).ToList());
}
public virtual List <doPrepareCompleteInstallationData> Temp_CompleteInstallation_Sale(string vcContractCode)
{
ISDataEntities context = new ISDataEntities();
return(context.Temp_CompleteInstallation_Sale(vcContractCode).ToList());
}
public virtual List <doRentalInstrumentdataList> GetRentalInstrumentdataList(string vcContractCode, string vcOCC, string vcSlipNo, string vcInstrumentTyepCode, string vcRentalInstallationType, string c_RENTAL_INSTALL_TYPE_MAINTENANCE_EXCHANGE, string c_RENTAL_INSTALL_TYPE_PERIODICAL_MAINTENANCE)
{
ISDataEntities context = new ISDataEntities();
return(context.GetRentalInstrumentdataList(vcContractCode, vcOCC, vcSlipNo, vcInstrumentTyepCode, vcRentalInstallationType, c_RENTAL_INSTALL_TYPE_MAINTENANCE_EXCHANGE, c_RENTAL_INSTALL_TYPE_PERIODICAL_MAINTENANCE).ToList());
}
public virtual List <dtInstallationSlipDetailsForView> GetTbt_InstallationSlipDetailsForView(string slipNo, string instrumentCode)
{
ISDataEntities context = new ISDataEntities();
return(context.GetTbt_InstallationSlipDetailsForView(slipNo, instrumentCode).ToList());
}
public virtual List <tbt_InstallationSlipExpansion> InsertTbt_InstallationSlipExpansion(string xml_SlipExpansion)
{
ISDataEntities context = new ISDataEntities();
return(context.InsertTbt_InstallationSlipExpansion(xml_SlipExpansion).ToList());
}
public virtual List <doInstallationDetailForCompleteInstallation> GetInstallationDetailForCompleteInstallation(string pC_INST_TYPE_GENERAL, string pSlipNo)
{
ISDataEntities context = new ISDataEntities();
return(context.GetInstallationDetailForCompleteInstallation(pC_INST_TYPE_GENERAL, pSlipNo).ToList());
}
public virtual List <tbt_InstallationAttachFile> GetTbt_InstallationAttachFile(Nullable <int> attachFileID, string maintenanceNo, string objectID)
{
ISDataEntities context = new ISDataEntities();
return(context.GetTbt_InstallationAttachFile(attachFileID, maintenanceNo, objectID).ToList());
}
public virtual List <dtInstallation> GetInstallationDataListForCsvFile(string c_SERVICE_TYPE_SALE, string c_SERVICE_TYPE_RENTAL, string c_INSTALL_STATUS_COMPLETED, string c_RENTAL_INSTALL_TYPE_REMOVE_ALL, string c_SALE_INSTALL_TYPE_REMOVE_ALL, string c_SALE_INSTALL_TYPE, string c_RENTAL_INSTALL_TYPE, Nullable <bool> slipNoNullFlag, string c_INSTALL_STATUS_INSTALL_NOT_REGISTERED)
{
ISDataEntities context = new ISDataEntities();
return(context.GetInstallationDataListForCsvFile(c_SERVICE_TYPE_SALE, c_SERVICE_TYPE_RENTAL, c_INSTALL_STATUS_COMPLETED, c_RENTAL_INSTALL_TYPE_REMOVE_ALL, c_SALE_INSTALL_TYPE_REMOVE_ALL, c_SALE_INSTALL_TYPE, c_RENTAL_INSTALL_TYPE, slipNoNullFlag, c_INSTALL_STATUS_INSTALL_NOT_REGISTERED).ToList());
}
public virtual List <dtInsHistory> GetSlipNoHistory(string slipNo)
{
ISDataEntities context = new ISDataEntities();
return(context.GetSlipNoHistory(slipNo).ToList());
}
public virtual List <doSaleInstrumentdataList> GetSaleInstrumentdataList(string vcContractCode, string vcOCC, string vcSlipNo, string vcInstrumentTyepCode, string vcChangeType, Nullable <bool> vcInstallCompleteFlag, string vcSaleInstallationType, string vcSaleProcessManageStatus, string c_SALE_CHANGE_TYPE_ADD_SALE, string c_SALE_CHANGE_TYPE_NEW_SALE, string c_SALE_INSTALL_TYPE_MAINTENANCE_EXCHANGE, string c_SALE_PROCESS_STATUS_CANCEL)
{
ISDataEntities context = new ISDataEntities();
return(context.GetSaleInstrumentdataList(vcContractCode, vcOCC, vcSlipNo, vcInstrumentTyepCode, vcChangeType, vcInstallCompleteFlag, vcSaleInstallationType, vcSaleProcessManageStatus, c_SALE_CHANGE_TYPE_ADD_SALE, c_SALE_CHANGE_TYPE_NEW_SALE, c_SALE_INSTALL_TYPE_MAINTENANCE_EXCHANGE, c_SALE_PROCESS_STATUS_CANCEL).ToList());
}
public virtual List <doGenerateInstallationSlipNo> GenerateInstallationSlipNo(string officeCode, string slipID, string year, string month, Nullable <System.DateTime> createDate, string createBy)
{
ISDataEntities context = new ISDataEntities();
return(context.GenerateInstallationSlipNo(officeCode, slipID, year, month, createDate, createBy).ToList());
}
public virtual List <ContractCodeList> GetInstallationBasicContractByProject(string cProjectCode)
{
ISDataEntities context = new ISDataEntities();
return(context.GetInstallationBasicContractByProject(cProjectCode).ToList());
}
public virtual int InsertTbs_InstallationSlipRunningNo(string officeCode, string slipID, string year, string month, Nullable <int> runningNo, Nullable <System.DateTime> createDate, string createBy, Nullable <System.DateTime> updateDate, string updateBy)
{
ISDataEntities context = new ISDataEntities();
return(context.InsertTbs_InstallationSlipRunningNo(officeCode, slipID, year, month, runningNo, createDate, createBy, updateDate, updateBy));
}
public virtual List <doRentalFeeResult> GetRentalFee(string vcContractCode, string c_CURRENCY_LOCAL, string c_CURRENCY_US)
{
ISDataEntities context = new ISDataEntities();
return(context.GetRentalFee(vcContractCode, c_CURRENCY_LOCAL, c_CURRENCY_US).ToList());
}
public virtual List <dtGetInstallationReportMonthly> GetInstallationReportMonthly(string reportType, Nullable <System.DateTime> receiveDateFrom, Nullable <System.DateTime> receiveDateTo, Nullable <System.DateTime> completeDateFrom, Nullable <System.DateTime> completeDateTo, Nullable <System.DateTime> expectedStartDateFrom, Nullable <System.DateTime> expectedStartDateTo, Nullable <System.DateTime> expectedCompleteDateFrom, Nullable <System.DateTime> expectedCompleteDateTo, string contractCode, string siteName, string subContractorCode, string productName, string installationStatus, string buildingType)
{
ISDataEntities context = new ISDataEntities();
return(context.GetInstallationReportMonthly(reportType, receiveDateFrom, receiveDateTo, completeDateFrom, completeDateTo, expectedStartDateFrom, expectedStartDateTo, expectedCompleteDateFrom, expectedCompleteDateTo, contractCode, siteName, subContractorCode, productName, installationStatus, buildingType).ToList());
}
public virtual List <doGetRemovalData> GetRemovalData(string vcContractCode, string c_RENTAL_INSTALL_TYPE_REMOVE_ALL, string c_RENTAL_INSTALL_TYPE_REMOVE_DURING_STOP_REMOVE_ALL, string c_INSTALL_STATUS_INSTALL_CANCELLED)
{
ISDataEntities context = new ISDataEntities();
return(context.GetRemovalData(vcContractCode, c_RENTAL_INSTALL_TYPE_REMOVE_ALL, c_RENTAL_INSTALL_TYPE_REMOVE_DURING_STOP_REMOVE_ALL, c_INSTALL_STATUS_INSTALL_CANCELLED).ToList());
}
public virtual List <RptSignatureDo> GetRptSignature(string c_RPT_CODE, string c_RPT_Position)
{
ISDataEntities context = new ISDataEntities();
return(context.GetRptSignature(c_RPT_CODE, c_RPT_Position).ToList());
}
public virtual List <tbt_InstallationEmail> DeleteTbt_InstallationEmail(string referenceID)
{
ISDataEntities context = new ISDataEntities();
return(context.DeleteTbt_InstallationEmail(referenceID).ToList());
}
public virtual List <CheckInstallationRegistered_Result> CheckInstallationRegistered(string strContractCode, string c_INSTALL_STATUS_INSTALLATION_NOT_REQUESTED)
{
ISDataEntities context = new ISDataEntities();
return(context.CheckInstallationRegistered(strContractCode, c_INSTALL_STATUS_INSTALLATION_NOT_REQUESTED).ToList());
}
public virtual List <doAllSlipNoSeries> GetAllSlipNoSeries(string pContractProjectCode, string pOCC, string pLatestSlipNo)
{
ISDataEntities context = new ISDataEntities();
return(context.GetAllSlipNoSeries(pContractProjectCode, pOCC, pLatestSlipNo).ToList());
}
public virtual List <CheckAllRemoval_Result> CheckAllRemoval(string strContractCode, string c_RENTAL_INSTALL_TYPE_REMOVE_ALL, string c_SALE_INSTALL_TYPE_REMOVE_ALL, string c_INSTALL_STATUS_COMPLETED)
{
ISDataEntities context = new ISDataEntities();
return(context.CheckAllRemoval(strContractCode, c_RENTAL_INSTALL_TYPE_REMOVE_ALL, c_SALE_INSTALL_TYPE_REMOVE_ALL, c_INSTALL_STATUS_COMPLETED).ToList());
}
public virtual List <string> GetInstallationSlipNoForAcceptant(string pContractProjectCode, string pOCC, string pC_SALE_INSTALL_TYPE_ADD, string pC_SALE_INSTALL_TYPE_NEW, string pC_INSTALL_STATUS_INSTALL_CANCELLED)
{
ISDataEntities context = new ISDataEntities();
return(context.GetInstallationSlipNoForAcceptant(pContractProjectCode, pOCC, pC_SALE_INSTALL_TYPE_ADD, pC_SALE_INSTALL_TYPE_NEW, pC_INSTALL_STATUS_INSTALL_CANCELLED).ToList());
}
public virtual List <tbt_InstallationBasic> UpdateTbt_InstallationBasic(string pContractProjectCode, string pOCC, string pServiceTypeCode, string pInstallationStatus, string pInstallationType, string pPlanCode, string pSlipNo, string pMaintenanceNo, string pOperationOfficeCode, string pSecurityTypeCode, string pChangeReasonTypeCode, Nullable <decimal> pNormalInstallFee, Nullable <decimal> pBillingInstallFee, string pInstallFeeBillingType, Nullable <decimal> pNormalSaleProductPrice, Nullable <decimal> pBillingSalePrice, Nullable <System.DateTime> pInstallationSlipProcessingDate, Nullable <System.DateTime> pInstallationCompleteDate, Nullable <System.DateTime> pInstallationCompleteProcessingDate, string pInstallationBy, string pSalesmanEmpNo1, string pSalesmanEmpNo2, string pApproveNo1, string pApproveNo2, Nullable <System.DateTime> pInstallationStartDate, Nullable <System.DateTime> pInstallationFinishDate, Nullable <decimal> pNormalContractFee, string pBillingOCC, Nullable <System.DateTime> pCreateDate, string pCreateBy, Nullable <System.DateTime> pUpdateDate, string pUpdateBy, Nullable <decimal> pNormalInstallFeeUsd, Nullable <decimal> pBillingInstallFeeUsd, Nullable <decimal> pNormalSaleProductPriceUsd, Nullable <decimal> pNormalContractFeeUsd, string pNormalInstallFeeCurrencyType, string pBillingInstallFeeCurrencyType, string pNormalSaleProductPriceCurrencyType, string pNormalContractFeeCurrencyType)
{
ISDataEntities context = new ISDataEntities();
return(context.UpdateTbt_InstallationBasic(pContractProjectCode, pOCC, pServiceTypeCode, pInstallationStatus, pInstallationType, pPlanCode, pSlipNo, pMaintenanceNo, pOperationOfficeCode, pSecurityTypeCode, pChangeReasonTypeCode, pNormalInstallFee, pBillingInstallFee, pInstallFeeBillingType, pNormalSaleProductPrice, pBillingSalePrice, pInstallationSlipProcessingDate, pInstallationCompleteDate, pInstallationCompleteProcessingDate, pInstallationBy, pSalesmanEmpNo1, pSalesmanEmpNo2, pApproveNo1, pApproveNo2, pInstallationStartDate, pInstallationFinishDate, pNormalContractFee, pBillingOCC, pCreateDate, pCreateBy, pUpdateDate, pUpdateBy, pNormalInstallFeeUsd, pBillingInstallFeeUsd, pNormalSaleProductPriceUsd, pNormalContractFeeUsd, pNormalInstallFeeCurrencyType, pBillingInstallFeeCurrencyType, pNormalSaleProductPriceCurrencyType, pNormalContractFeeCurrencyType).ToList());
}
public virtual List <InstallationSlipRunningNo_Result> GetTbs_InstallationSlipRunningNo(string officeCode, string slipID, string year, string month)
{
ISDataEntities context = new ISDataEntities();
return(context.GetTbs_InstallationSlipRunningNo(officeCode, slipID, year, month).ToList());
}