protected override void ExecuteChild(AuditPostReq dataReq, ResponseAPI dataRes)
{
var res = new AuditCompRes();
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 "getaudittoedit":
res = getaudittoedit(dataReq, res, conString);
break;
case "depeditmst":
res = depeditmst(dataReq, res, conString);
break;
case "depimgmst":
res = depimgmst(dataReq, res, conString);
break;
case "depimgtrn":
res = depimgtrn(dataReq, res, conString);
break;
case "depedittrn":
res = depedittrn(dataReq, res, conString);
break;
case "checkacc":
res = checkacc(dataReq, res, conString);
break;
case "compliance_close":
res = compliance_close(dataReq, res, conString);
break;
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
private AuditCompRes compliance_close(AuditPostReq dataReq, AuditCompRes res, string conStr = null)
{
try
{
var updateCutMST = AuditManagerAdo.GetInstant().saveAUDITCUTDATEMST(dataReq, 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";
}
return(res);
}
protected override void ExecuteChild(AuditResultReq dataReq, ResponseAPI dataRes)
{
var res = new AuditCompRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
List <AuditComp> auditLst = new List <AuditComp>();
var mode = String.IsNullOrEmpty(dataReq.MODE) ? dataReq.MODE : dataReq.MODE.ToLower();
switch (mode)
{
default:
auditLst = AuditCompAdo.GetInstant().GetData(dataReq, null, conString);
break;
}
res.AuditCompLst = auditLst;
if (auditLst == null)
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
else
{
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";
}
dataRes.data = res;
}
private AuditCompRes getaudittoedit(AuditPostReq dataReq, AuditCompRes res, string conStr = null)
{
try
{
var lst = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().getDataToCompEdit(dataReq, null, null, conStr);
res.AUDITPOSTMSTTODEPLST = lst;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRNComp(dataReq, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private AuditCompRes checkacc(AuditPostReq dataReq, AuditCompRes res, string conStr = null)
{
try
{
var obj = AuditCompAdo.GetInstant().getAuditAcc(dataReq, null, conString).FirstOrDefault();
if (obj != null)
{
res.send_acc = obj.QTY_TOTAL;
}
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 AuditCompRes depeditmst(AuditPostReq dataReq, AuditCompRes res, string conStr = null)
{
try
{
AUDITPOSTMSTReq req = new AUDITPOSTMSTReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
INPID = dataReq.INPID,
UCODE = dataReq.UCODE,
FLAG = "",
MEMO1 = dataReq.MEMO1,
FINDY = dataReq.FINDY,
PCODE = dataReq.PCODE,
PNAME = dataReq.PNAME,
MODE = "updatePCODE_TODEP",
snnstdt = dataReq.snnstdt,
expstdt = dataReq.expstdt
};
/*var updateDep = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant(conString).SP_AUDITPOSTMSTTODEP(req);*/
ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().SP_AUDITPOSTMSTTOTEMP(req, null, null, conStr);
Thread.Sleep(1000);
AUDITPOSTMSTReq req1 = new AUDITPOSTMSTReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
INPID = dataReq.INPID,
UCODE = dataReq.UCODE,
FLAG = "",
MODE = "updateDEP_STY"
};
var updateSTCY = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().SP_AUDITPOSTMSTTODEPPHONE(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
{
Thread.Sleep(1000);
AuditPostReq req = new AuditPostReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
filter = dataReq.filter
};
var lst = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().getDataToCompEdit(req, null, null, conStr);
res.AUDITPOSTMSTTODEPLST = lst;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRNComp(req, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
}
return(res);
}
private AuditCompRes depedittrn(AuditPostReq dataReq, AuditCompRes res, string conStr = null)
{
try
{
AUDITPOSTTRNReq req = new AUDITPOSTTRNReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
INPID = dataReq.INPID,
UCODE = dataReq.UCODE,
FLAG = "",
MEMO1 = dataReq.MEMO1,
ASSETNAME = dataReq.ASSETNAME,
OFFICECODE = dataReq.OFFICECODE,
OFNAME = dataReq.OFNAME,
ASSETNONEW = dataReq.ASSETNONEW,
MODE = "EDITNEW"
};
var updateAuditPost = ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().addAUDITPOSTTRN(req, null, conStr);
Thread.Sleep(1000);
AUDITPOSTMSTReq req1 = new AUDITPOSTMSTReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
INPID = dataReq.INPID,
UCODE = dataReq.UCODE,
FLAG = "",
MODE = "updateTRN_STY"
};
var updateSNDST = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().SP_AUDITPOSTTRNPHONE(req1, null, null, conStr);
Thread.Sleep(1000);
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
{
AuditPostReq req = new AuditPostReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
filter = dataReq.filter
};
var lst = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().getDataToClear(req, null, null, conStr);
res.AUDITPOSTMSTTODEPLST = lst;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRNDep(req, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
}
return(res);
}
private AuditCompRes depimgmst(AuditPostReq dataReq, AuditCompRes res, string conStr = null)
{
try
{
AUDITPOSTMSTReq req = new AUDITPOSTMSTReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
INPID = dataReq.INPID,
UCODE = dataReq.UCODE,
FLAG = "",
IMGPATH = dataReq.IMGPATH,
MODE = "update_ComIMG"
};
var updateSTY = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().SP_AUDITPOSTMSTTODEPPHONE(req, null, null, conStr);
Thread.Sleep(1000);
AUDITPOSTMSTReq req1 = new AUDITPOSTMSTReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
ASSETNO = dataReq.ASSETNO,
INPID = dataReq.INPID,
UCODE = dataReq.UCODE,
FLAG = "",
MODE = "updateTRN_STY"
};
var updateSNDST = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().SP_AUDITPOSTTRNPHONE(req1, null, null, conStr);
Thread.Sleep(1000);
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
{
AuditPostReq req = new AuditPostReq()
{
SQNO = dataReq.SQNO,
COMPANY = dataReq.COMPANY,
filter = dataReq.filter
};
var lst = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().getDataToCompEdit(req, null, null, conStr);
res.AUDITPOSTMSTTODEPLST = lst;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRNComp(req, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
}
return(res);
}