private AuditDepRes getauditassetno(AuditPostReq dataReq, AuditDepRes res, string conStr = null)
{
try
{
var lst = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().getAuditAssetNo(dataReq, null, conStr);
res.AUDITPOSTMSTTODEP = lst != null?lst.FirstOrDefault() : null;
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
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";
}
return(res);
}
private AuditDepRes depimgtrn(AuditPostReq dataReq, AuditDepRes 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_IMG"
};
var updateSTY = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().SP_AUDITPOSTTRNPHONE(req, null, null, conStr);
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
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
{
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);
}
protected override void ExecuteChild(AuditResultReq dataReq, ResponseAPI dataRes)
{
var res = new AuditDepRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
List <AuditDep> auditLst = new List <AuditDep>();
var mode = String.IsNullOrEmpty(dataReq.MODE) ? dataReq.MODE : dataReq.MODE.ToLower();
switch (mode)
{
default:
auditLst = AuditDepAdo.GetInstant().GetData(dataReq, null, conString);
break;
}
res.AuditDepLst = 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 (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";
}
dataRes.data = res;
}
private AuditDepRes confirminformedtrn(AuditPostReq dataReq, AuditDepRes 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 = dataReq.FLAG,
MODE = "updateTRN_STY"
};
var updateSNDST = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().SP_AUDITPOSTTRNPHONE(req, null, null, conStr);
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
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";
}
return(res);
}
private AuditDepRes getaudittoclear(AuditPostReq dataReq, AuditDepRes res, string conStr = null)
{
try
{
var lst = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTODEPAdo.GetInstant().getDataToClear(dataReq, null, null, conStr);
res.AUDITPOSTMSTTODEPLST = lst;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRNDep(dataReq, null, null, conStr);
res.POSTTRNDuplicateLST = lstPostTRN;
var summaryAudit = AuditManagerAdo.GetInstant().GetSummaryAudit(dataReq, null, conStr);
res.AuditSummary = summaryAudit;
var lstResult = AuditManagerAdo.GetInstant().GetSummaryResult(dataReq, null, conStr);
res.SummaryResultLst = lstResult;
}
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";
}
return(res);
}
protected override void ExecuteChild(AuditPostReq dataReq, ResponseAPI dataRes)
{
var res = new AuditDepRes();
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 "getaudittoclear":
res = getaudittoclear(dataReq, res, conString);
break;
case "getaudittoconfirm":
res = getaudittoconfirm(dataReq, res, conString);
break;
case "getauditassetno":
res = getauditassetno(dataReq, res, conString);
break;
case "confirminformedmst":
res = confirminformedmst(dataReq, res, conString);
break;
case "confirminformedtrn":
res = confirminformedtrn(dataReq, res, conString);
break;
case "depeditmst":
res = depeditmst(dataReq, res, conString);
break;
case "depedittrn":
res = depedittrn(dataReq, res, conString);
break;
case "depimgmst":
res = depimgmst(dataReq, res, conString);
break;
case "depimgtrn":
res = depimgtrn(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.AUDITPOSTMSTTODEPLST != null && res.AUDITPOSTMSTTODEPLST.Count > 0)
{
var obj = res.AUDITPOSTMSTTODEPLST.Where(x => !String.IsNullOrEmpty(x.FILEPATH)).FirstOrDefault();
var attachedFile = obj != null ? obj.FILEPATH : null;
res.FILEPATH = attachedFile;
}
}
}
dataRes.data = res;
}
