protected override void ExecuteChild(AUDITPOSTTRNReq dataReq, ResponseAPI dataRes)
{
var res = new AuditPostTRNRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
if (dataReq.MODE.Trim().ToLower() == "add")
{
var objTRN = ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().getAuditPostTRN(dataReq, null, conString);
if (objTRN != null && objTRN.Count > 0)
{
throw new Exception("คุณได้บันทึกตรวจสอบรหัสทรัพย์สินนี้แล้ว กรุณาตรวจสอบข้อมูล");
}
}
var updateAuditPost = ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().addAUDITPOSTTRN(dataReq, null, conString);
if (!String.IsNullOrEmpty(dataReq.IMGPATH))
{
res.IMGPATH = FilesUtilSvc.uploadCamera(dataReq.IMGPATH);
dataReq.IMGPATH = res.IMGPATH;
}
if (dataReq.FileToUpload != null)
{
res.IMGPATH = FilesUtilSvc.uploadImgFile(dataReq.FileToUpload);
dataReq.IMGPATH = res.IMGPATH;
}
if (!String.IsNullOrEmpty(res.IMGPATH))
{
ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().UpdateAUDITPOSTTRNIMG(dataReq, null, conString);
res.IMGSRC = FilesUtilSvc.getImageURL(res.IMGPATH);
}
if (dataReq.MODE.Trim().ToLower() == "editnew")
{
AuditPostReq req1 = new AuditPostReq()
{
COMPANY = dataReq.COMPANY,
SQNO = dataReq.SQNO,
isdept = dataReq.isdept
};
var lstPostMSTToTEMP = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTMSTTOTEMPAdo.GetInstant().getDataToSendDep(req1, null, null, conString);
res.AuditToTEMPLST = lstPostMSTToTEMP;
var lstPostTRN = ASSETKKF_ADO.Mssql.Audit.AUDITPOSTTRNAdo.GetInstant().getPOSTTRN(req1, null, null, conString);
res.POSTTRNDuplicateLST = lstPostTRN;
var lstNoAudit = ASSETKKF_ADO.Mssql.Audit.AUDITCUTDATEAdo.GetInstant().getNoAudit(req1, null, null, conString);
res.NoAuditLST = lstNoAudit;
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
var req1 = new ASSETKKF_MODEL.Request.Asset.AuditPostReq()
{
SQNO = dataReq.SQNO,
DEPCODEOL = dataReq.DEPCODEOL,
COMPANY = dataReq.COMPANY,
LEADERCODE = dataReq.LEADERCODE,
AREACODE = dataReq.AREACODE,
UCODE = dataReq.UCODE,
isdept = dataReq.isdept
};
res.AUDITPOSTTRNLST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTTRN(req1, null, conString);
var lstAUDITPOSTMST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST(req1, null, null, conString);
//var lstWait = lstAUDITPOSTMST.Where(p => String.IsNullOrEmpty(p.PCODE)).ToList();
var lstChecked = lstAUDITPOSTMST.Where(p => !String.IsNullOrEmpty(p.PCODE)).ToList();
var lstWait = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST_WAIT(req1, null, null, conString);
res.AUDITPOSTMSTWAITLST = lstWait;
res.AUDITPOSTMSTCHECKEDLST = lstChecked;
res.AUDITPOSTMSTNOPROBLEMLST = lstChecked.Where(x => x.PFLAG != "Y").ToList();
res.AUDITPOSTMSTPROBLEMLST = lstChecked.Where(x => x.PFLAG == "Y").ToList();
var lstAUDITCUTDATE = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITCUTDATE(req1, null, conString);
res.AUDITCUTDATELST = lstAUDITCUTDATE;
res.AREACODE = dataReq.AREACODE;
res.COMPANY = dataReq.COMPANY;
res.DEPCODEOL = dataReq.DEPCODEOL;
res.LEADERCODE = dataReq.LEADERCODE;
res.SQNO = dataReq.SQNO;
res._result._code = "201";
res._result._message = "";
res._result._status = "Created";
}
}
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;
}
protected override void ExecuteChild(AUDITPOSTMSTReq dataReq, ResponseAPI dataRes)
{
var res = new AuditPostRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var req = new ASSETKKF_MODEL.Request.Asset.AUDITPOSTMSTReq()
{
SQNO = dataReq.SQNO,
DEPCODEOL = dataReq.DEPCODEOL,
COMPANY = dataReq.COMPANY,
LEADERCODE = dataReq.LEADERCODE,
LEADERNAME = dataReq.LEADERNAME,
AREACODE = dataReq.AREACODE,
AREANAME = dataReq.AREANAME,
UCODE = dataReq.UCODE,
ASSETNO = dataReq.ASSETNO,
FINDY = dataReq.FINDY,
PCODE = dataReq.PCODE,
PNAME = dataReq.PNAME,
MEMO1 = dataReq.MEMO1,
IMGPATH = dataReq.IMGPATH,
FileToUpload = dataReq.FileToUpload,
PFLAG = dataReq.PFLAG,
isdept = dataReq.isdept
};
//var updateAuditPost = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().updateAUDITPOSTMST(dataReq);
var updateAuditPost = System.Threading.Tasks.Task.Factory.StartNew(() => ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().updateAUDITPOSTMST(dataReq, null, conString));
updateAuditPost.Wait();
if (!String.IsNullOrEmpty(req.IMGPATH))
{
res.IMGPATH = FilesUtilSvc.uploadCamera(req.IMGPATH);
req.IMGPATH = res.IMGPATH;
dataReq.IMGPATH = res.IMGPATH;
}
if (req.FileToUpload != null)
{
res.IMGPATH = FilesUtilSvc.uploadImgFile(req.FileToUpload);
req.IMGPATH = res.IMGPATH;
}
if (!String.IsNullOrEmpty(res.IMGPATH))
{
//ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().UpdateAUDITPOSTMSTImage(dataReq);
var task2 = System.Threading.Tasks.Task.Factory.StartNew(() => ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().UpdateAUDITPOSTMSTImage(dataReq, null, conString));
task2.Wait();
res.IMGSRC = FilesUtilSvc.getImageURL(res.IMGPATH);
}
res._result._code = "201";
res._result._message = "";
res._result._status = "Created";
}
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
{
var req1 = new ASSETKKF_MODEL.Request.Asset.AuditPostReq()
{
SQNO = dataReq.SQNO,
DEPCODEOL = dataReq.DEPCODEOL,
COMPANY = dataReq.COMPANY,
LEADERCODE = dataReq.LEADERCODE,
AREACODE = dataReq.AREACODE,
UCODE = dataReq.UCODE,
isdept = dataReq.isdept
};
res.AUDITPOSTTRNLST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTTRN(req1, null, conString);
var lstAUDITPOSTMST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST(req1, null, null, conString);
//var lstWait = lstAUDITPOSTMST.Where(p => String.IsNullOrEmpty(p.PCODE)).ToList();
var lstChecked = lstAUDITPOSTMST.Where(p => !String.IsNullOrEmpty(p.PCODE)).ToList();
var lstWait = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST_WAIT(req1, null, null, conString);
res.AUDITPOSTMSTWAITLST = lstWait;
res.AUDITPOSTMSTCHECKEDLST = lstChecked;
res.AUDITPOSTMSTNOPROBLEMLST = lstChecked.Where(x => x.PFLAG != "Y").ToList();
res.AUDITPOSTMSTPROBLEMLST = lstChecked.Where(x => x.PFLAG == "Y").ToList();
var lstAUDITCUTDATE = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITCUTDATE(req1, null, conString);
res.AUDITCUTDATELST = lstAUDITCUTDATE;
res.AUDITPOSTMST = lstAUDITPOSTMST.Where(x => x.INPID == dataReq.UCODE && x.ASSETNO == dataReq.ASSETNO && x.SQNO == dataReq.SQNO).FirstOrDefault();
AuditSummaryReq reqSum = new AuditSummaryReq()
{
Company = dataReq.COMPANY,
year = res.AUDITPOSTMST.YR.ToString(),
mn = res.AUDITPOSTMST.MN.ToString(),
sqno = dataReq.SQNO,
isdept = dataReq.isdept
};
//var lstSum = ASSETKKF_ADO.Mssql.Asset.DashboardADO.GetInstant().getInspectionByDEPMST(reqSum, null, conString);
//res.DashboardInspectionLST = lstSum;
res.AREACODE = dataReq.AREACODE;
res.COMPANY = dataReq.COMPANY;
res.DEPCODEOL = dataReq.DEPCODEOL;
res.LEADERCODE = dataReq.LEADERCODE;
res.SQNO = dataReq.SQNO;
}
dataRes.data = res;
}