private AuditDuplicateRes savebfsend(AuditPostReq dataReq, AuditDuplicateRes res, string conStr = null)
{
try
{
AUDITPOSTMSTReq req1 = new AUDITPOSTMSTReq()
{
MODE = "update",
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
UCODE = dataReq.UCODE,
FINDY = dataReq.FINDY,
PCODE = dataReq.PCODE,
PNAME = dataReq.PNAME,
MEMO1 = dataReq.MEMO1,
poth = dataReq.poth,
snnstdt = dataReq.snnstdt,
expstdt = dataReq.expstdt
};
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().SP_AUDITPOSTMSTTOTEMP(req1, null, null, conStr);
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var lstPostMSTToTEMP = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().getDataToSendDep(dataReq, null, null, conStr);
res.AuditToTEMPLST = lstPostMSTToTEMP;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRN(dataReq, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
var lstNoAudit = ASSETKKF_ADO.Mssql.Audit.AUDITCUTDATEAdo.GetInstant().getNoAudit(dataReq, null, null, conStr);
//var lstNoAudit = lstPostMSTToTEMP.Where(p => String.IsNullOrEmpty(p.PCODE)).ToList();
res.NoAuditLST = lstNoAudit;
}
return(res);
}
private AuditDuplicateRes getauditassetno(AuditPostReq dataReq, AuditDuplicateRes res, string conStr = null)
{
try
{
var lst = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().getAuditAssetNo(dataReq, null, conStr);
res.AUDITPOSTMSTTOTEMP = lst != null?lst.FirstOrDefault() : null;
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private AuditDuplicateRes getDuplicate(AuditPostReq dataReq, AuditDuplicateRes res, string conStr = null)
{
try
{
var lstPostMST = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTAdo.GetInstant().getPOSTMSTDuplicate(dataReq, null, null, conStr);
res.POSTMSTDuplicateLST = lstPostMST;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRNDuplicate(dataReq, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private AuditDuplicateRes uploadfile(AuditPostReq dataReq, AuditDuplicateRes res, string conStr = null)
{
try
{
if (dataReq.FileToUpload != null)
{
res.FILEPATH = FilesUtilSvc.uploadAttachFile(dataReq.FileToUpload);
dataReq.IMGPATH = res.FILEPATH;
}
if (!String.IsNullOrEmpty(dataReq.IMGPATH))
{
var attachedFile = "";
var task1 = System.Threading.Tasks.Task.Factory.StartNew(() => attachedFile = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().getAttachedFile(dataReq, null, null, conStr));
task1.Wait();
if (!String.IsNullOrEmpty(attachedFile))
{
FilesUtilSvc.deleteFile(attachedFile);
}
var mode = String.IsNullOrEmpty(attachedFile) ? "attach_FILE" : "update_FILE";
AUDITPOSTMSTReq req = new AUDITPOSTMSTReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
INPID = dataReq.INPID,
UCODE = dataReq.UCODE,
FLAG = "",
IMGPATH = dataReq.IMGPATH,
MODE = mode
};
//var updateFILE = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().SP_AUDITPOSTMSTTODEPPHONE(req);
var task3 = System.Threading.Tasks.Task.Factory.StartNew(() => ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().SP_AUDITPOSTMSTTODEPPHONE(req, null, null, conStr));
task3.Wait();
res.FILEPATH = dataReq.IMGPATH;
res.FileSRC = FilesUtilSvc.getFile(res.FILEPATH);
}
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var lstPostMSTToTEMP = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().getDataToSendDep(dataReq, null, null, conStr);
res.AuditToTEMPLST = lstPostMSTToTEMP;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRN(dataReq, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
var lstNoAudit = ASSETKKF_ADO.Mssql.Audit.AUDITCUTDATEAdo.GetInstant().getNoAudit(dataReq, null, null, conStr);
//var lstNoAudit = lstPostMSTToTEMP.Where(p => String.IsNullOrEmpty(p.PCODE)).ToList();
res.NoAuditLST = lstNoAudit;
}
return(res);
}
private AuditDuplicateRes sendaudit2dep(AuditPostReq dataReq, AuditDuplicateRes res, string conStr = null)
{
try
{
updateCUTDT(dataReq, conStr);
updatePOSTMST_SNDST_Y(dataReq, conStr);
addPOSTTEMP_NotExists_PCODE_SNDST_Y(dataReq, conStr);
addPOSTTEMP_NotExists_PCODE(dataReq, conStr);
addPOSTTEMP_NotExists(dataReq, conStr);
updatePOSTTEMP_SNDST_Y(dataReq, conStr);
updatePOSTTEMP_PCODE_PostMST(dataReq, conStr);
updatePOSTDEP_PCODE_PostMST(dataReq, conStr);
updatePOSTTEMP_PCODE_PostMST_Dup(dataReq, conStr);
updatePOSTDEP_PCODE_PostMST_Dup(dataReq, conStr);
var lstPostMSTToTEMP = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().getDataToSendDep(dataReq, null, null, conStr);
if (lstPostMSTToTEMP == null || lstPostMSTToTEMP != null && lstPostMSTToTEMP.Count == 0)
{
InSdataToTEMP(dataReq, conStr);
}
AUDITPOSTTRNReq req = new AUDITPOSTTRNReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
UCODE = dataReq.UCODE,
INPID = dataReq.INPID,
MODE = "update_senddep"
};
var updateSNDST = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().saveAUDITPOSTTRN(req, null, conStr);
AUDITPOSTMSTReq req1 = new AUDITPOSTMSTReq()
{
MODE = "insert_PostTEMP",
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
UCODE = dataReq.UCODE,
FINDY = dataReq.FINDY,
PCODE = dataReq.PCODE,
PNAME = dataReq.PNAME,
MEMO1 = dataReq.MEMO1,
poth = dataReq.poth,
snnstdt = dataReq.snnstdt,
expstdt = dataReq.expstdt
};
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().SP_AUDITPOSTMSTTODEP(req1, null, null, conStr);
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var lstPostMSTToTEMP = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().getDataToSendDep(dataReq, null, null, conStr);
res.AuditToTEMPLST = lstPostMSTToTEMP;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRN(dataReq, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
var lstNoAudit = ASSETKKF_ADO.Mssql.Audit.AUDITCUTDATEAdo.GetInstant().getNoAudit(dataReq, null, null, conStr);
//var lstNoAudit = lstPostMSTToTEMP.Where(p => String.IsNullOrEmpty(p.PCODE)).ToList();
res.NoAuditLST = lstNoAudit;
}
return(res);
}
private AuditDuplicateRes savemst2tmp(AuditPostReq dataReq, AuditDuplicateRes res, string conStr = null)
{
try
{
int action = 0;
var lstNoDuplicate = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTAdo.GetInstant().getNoDuplicateAll(dataReq, null, null, conStr);
var lstDuplicate = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTAdo.GetInstant().getDuplicateAll(dataReq, null, null, conStr);
if (lstNoDuplicate != null && lstNoDuplicate.Count > 0)
{
action += 1;
lstNoDuplicate.ForEach(c => {
AUDITPOSTMSTReq req1 = new AUDITPOSTMSTReq()
{
MODE = "deleteByAssetno",
SQNO = c.SQNO,
COMPANY = c.COMPANY,
ASSETNO = c.ASSETNO,
UCODE = c.INPID,
FINDY = c.FINDY,
PCODE = c.PCODE,
PNAME = c.PNAME
};
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().SP_AUDITPOSTMSTTOTEMP(req1, null, null, conStr);
var req2 = req1;
req2.MODE = "addByAssetnoInpid";
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().SP_AUDITPOSTMSTTOTEMP(req2, null, null, conStr);
});
}
if (lstDuplicate != null && lstDuplicate.Count > 0)
{
action += 1;
lstDuplicate.ForEach(c => {
AUDITPOSTMSTReq req3 = new AUDITPOSTMSTReq()
{
MODE = "deleteByAssetno",
SQNO = c.SQNO,
COMPANY = c.COMPANY,
ASSETNO = c.ASSETNO,
UCODE = c.INPID,
FINDY = c.FINDY,
PCODE = c.PCODE,
PNAME = c.PNAME
};
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().SP_AUDITPOSTMSTTOTEMP(req3, null, null, conStr);
var req4 = req3;
req4.MODE = "addByAssetnoInpid";
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().SP_AUDITPOSTMSTTOTEMP(req4, null, null, conStr);
});
}
if (action > 0)
{
AUDITPOSTMSTReq req5 = new AUDITPOSTMSTReq()
{
MODE = "updateSNDST",
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
UCODE = dataReq.UCODE
};
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().SP_AUDITPOSTMSTTOTEMP(req5, null, null, conStr);
}
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var lstPostMST = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTAdo.GetInstant().getPOSTMSTDuplicate(dataReq, null, null, conStr);
res.POSTMSTDuplicateLST = lstPostMST;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRNDuplicate(dataReq, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
}
return(res);
}
protected override void ExecuteChild(AuditPostReq dataReq, ResponseAPI dataRes)
{
var res = new AuditDuplicateRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var mode = !String.IsNullOrEmpty(dataReq.mode) ? dataReq.mode.Trim().ToLower() : dataReq.mode;
switch (mode)
{
case "getduplicate":
res = getDuplicate(dataReq, res, conString);
break;
case "confirmduplicatemst":
res = confirmDuplicateMST(dataReq, res, conString);
break;
case "confirmduplicatetrn":
res = confirmDuplicateTRN(dataReq, res, conString);
break;
case "savemst2tmp":
res = savemst2tmp(dataReq, res, conString);
break;
case "getdata2dep":
res = getdata2dep(dataReq, res, conString);
break;
case "getauditassetno":
res = getauditassetno(dataReq, res, conString);
break;
case "updateaudittotemp":
res = updateaudittotemp(dataReq, res, conString);
break;
case "savebfsend":
res = savebfsend(dataReq, res, conString);
break;
case "confirmduplicatetotemp":
res = confirmDuplicateTOTEMP(dataReq, res, conString);
break;
case "sendaudit2dep":
res = sendaudit2dep(dataReq, res, conString);
break;
case "uploadfile":
res = uploadfile(dataReq, res, conString);
break;
case "auditcomparetotmp":
res = auditcomparetotmp(dataReq, res, conString);
break;
case "confirmtrntotmp":
res = confirmtrntotmp(dataReq, res, conString);
break;
case "audittmptofixedasset":
res = audittmptofixedasset(dataReq, res, conString);
break;
case "audittrntofixedasset":
res = audittrntofixedasset(dataReq, res, conString);
break;
case "confirmtmptofixedasset":
res = confirmtmptofixedasset(dataReq, res, conString);
break;
case "confirmtrntofixedasset":
res = confirmtrntofixedasset(dataReq, res, conString);
break;
}
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
if (res != null)
{
if (res.AuditToTEMPLST != null && res.AuditToTEMPLST.Count > 0)
{
var obj = res.AuditToTEMPLST.Where(x => !String.IsNullOrEmpty(x.FILEPATH)).FirstOrDefault();
var attachedFile = obj != null ? obj.FILEPATH : null;
res.FILEPATH = attachedFile;
}
}
}
dataRes.data = res;
}
