private TrackOfflineRes SetAuditPostMST(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
List <ASAUDITPOSTMST> lst = new List <ASAUDITPOSTMST>();
lst = GetCutPostMST(dataReq, conStr);
if (lst != null && lst.Count == 0)
{
var req = new AuditPostReq
{
COMPANY = dataReq.company,
SQNO = dataReq.sqno,
INPID = dataReq.ucode
};
InsertAuditPostMST(req, conStr);
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes GetProblem(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
var obj = GetProblemBase(dataReq, conStr);
if (obj != null)
{
res.problem = obj;
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes addPostTRN(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
var obj = InsertTrackPostTRN(dataReq, conStr);
if (obj.Result > 0)
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "400";
res._result._message = "พบความผิดพลาดระหว่างประมวลผลข้อมูล " + obj.Result.ToString();
res._result._status = "Bad Request";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes getSQNO(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
var obj = GetAUDITCUTDATEMST(dataReq, conStr);
if (obj != null)
{
res.sqno = obj.SQNO;
res.yr = obj.YR.ToString();
res.mn = obj.MN.ToString();
res.yrmn = obj.YRMN.ToString();
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes getTrackOffline(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
List <TrackPostMSTRes> lstTrackPostMST = new List <TrackPostMSTRes>();
List <TrackPostTRNRes> lstTrackPostTRN = new List <TrackPostTRNRes>();
lstTrackPostMST = GetTrackPostMST(dataReq, conStr);
lstTrackPostTRN = GetTrackPostTRN(dataReq, conStr);
res.lstTrackPostMST = lstTrackPostMST;
res.lstTrackPostTRN = lstTrackPostTRN;
if ((lstTrackPostMST != null && lstTrackPostMST.Count > 0) || (lstTrackPostTRN != null && lstTrackPostTRN.Count > 0))
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes GetTrackOfflineHD(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
List <TrackHDRes> lstTrackHD = new List <TrackHDRes>();
lstTrackHD = GetTrackHD(dataReq, conStr);
res.lstTrackHD = lstTrackHD;
if (lstTrackHD != null && lstTrackHD.Count > 0)
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes addPostMST(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
ASSETKKF_MODEL.Data.Mssql.Asset.AsFixedAsset req1 = new AsFixedAsset()
{
ASSETNO = dataReq.assetno
};
AsFixedAsset asset = ASSETKKF_ADO.Mssql.Asset.AsFixedAssetAdo.GetInstant().Search(req1, null, conStr).FirstOrDefault();
if (asset != null)
{
dataReq.assetname = asset.ASSETNAME;
}
var obj = InsertTrackPostMST(dataReq, conStr);
if (obj.Result > 0)
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "400";
res._result._message = "พบความผิดพลาดระหว่างประมวลผลข้อมูล " + obj.Result.ToString();
res._result._status = "Bad Request";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes auditPostTRN(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
string msg, flag, transy;
flag = "1";
transy = "";
msg = "";
ASAUDITPOSTTRN objTRN = new ASAUDITPOSTTRN();
if (String.IsNullOrEmpty(dataReq.sqno))
{
msg = "เลขที่เอกสารไม่ถูกต้อง";
res._result._code = "404";
res._result._message = msg;
res._result._status = "Bad Request";
}
else
{
objTRN = GetASAUDITPOSTTRN(dataReq, conStr);
if (objTRN == null)
{
transy = "Y";
res._result._code = "200";
res._result._message = msg;
res._result._status = "OK";
}
else
{
msg = "ไม่สามารถบันทึกผลการตรวจสอบได้ เนื่องจากรหัสทรัพย์สินนี้เคยถูกบันทึกผลแล้ว";
res._result._code = "501";
res._result._message = msg;
res._result._status = "Not Implemented";
}
}
dataReq.flag = flag;
dataReq.remark = msg;
UpdateTransferTrackPostTRN(dataReq, conStr);
if (!String.IsNullOrEmpty(transy))
{
int yr, mn, yrmn;
Int32.TryParse(dataReq.yr, out yr);
Int32.TryParse(dataReq.mn, out mn);
Int32.TryParse(dataReq.yrmn, out yrmn);
var reqPostTrn = new AUDITPOSTTRNReq()
{
SQNO = dataReq.sqno,
COMPANY = dataReq.company,
DEPCODEOL = dataReq.depcodeol,
YR = yr,
MN = mn,
YRMN = yrmn,
MEMO1 = dataReq.memo1,
ASSETNO = dataReq.assetno,
ASSETNAME = dataReq.assetname,
OFFICECODE = dataReq.officecode,
OFNAME = dataReq.ofname,
POSITNAME = dataReq.positname,
MODE = "ADD",
UCODE = dataReq.inpid
};
if (!String.IsNullOrEmpty(dataReq.transy) && dataReq.transy.ToLower().Equals("y"))
{
var stSave = UpdateAuditPostTRN(reqPostTrn, conStr);
if (stSave.Result != 0)
{
flag = "2";
msg = "บันทึกผลการตรวจสอบเรียบร้อยแล้ว";
}
else
{
msg = "พบข้อผิดพลาดจากการบันทึกผลการตรวจสอบ";
}
}
else
{
msg = "ไม่บันทึกผลการตรวจสอบ";
}
dataReq.remark = msg;
dataReq.flag = flag;
}
dataReq.transy = !String.IsNullOrEmpty(dataReq.transy) ? dataReq.transy.ToUpper() : dataReq.transy;
UpdateAuditTrackPostTRN(dataReq, conStr);
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private TrackOfflineRes auditPostMST(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
{
try
{
string msg, flag, transy;
flag = "1";
transy = "";
msg = "";
ASAUDITPOSTMST objMst = new ASAUDITPOSTMST();
if (String.IsNullOrEmpty(dataReq.sqno))
{
msg = "เลขที่เอกสารไม่ถูกต้อง";
res._result._code = "404";
res._result._message = msg;
res._result._status = "Bad Request";
}
else
{
objMst = GetASAUDITPOSTMST(dataReq, conStr);
if (objMst != null)
{
if (!String.IsNullOrEmpty(objMst.PCODE))
{
msg = "ไม่สามารถบันทึกผลการตรวจสอบได้ เนื่องจากรหัสทรัพย์สินนี้เคยถูกบันทึกผลเป็น" + objMst.PCODE + " : " + objMst.PNAME;
res._result._code = "501";
res._result._message = msg;
res._result._status = "Not Implemented";
}
else
{
transy = "Y";
res._result._code = "200";
res._result._message = msg;
res._result._status = "OK";
}
}
else
{
msg = "ไม่พบข้อมูล";
res._result._code = "404";
res._result._message = msg;
res._result._status = "Bad Request";
}
}
dataReq.flag = flag;
dataReq.remark = msg;
UpdateTransferTrackPostMST(dataReq, conStr);
if (!String.IsNullOrEmpty(transy))
{
var reqPostMst = new AUDITPOSTMSTReq
{
SQNO = dataReq.sqno,
DEPCODEOL = objMst != null? objMst.DEPCODEOL:null,
COMPANY = dataReq.company,
LEADERCODE = objMst != null ? objMst.LEADERCODE:null,
LEADERNAME = objMst != null ? objMst.LEADERNAME:null,
AREACODE = objMst != null ? objMst.AREACODE:null,
AREANAME = null,
ASSETNO = dataReq.assetno,
FINDY = dataReq.findy,
PCODE = dataReq.pcode,
PNAME = dataReq.pname,
UCODE = dataReq.inpid,
PFLAG = dataReq.pflag,
MEMO1 = dataReq.memo1
};
if (!String.IsNullOrEmpty(dataReq.transy) && dataReq.transy.ToLower().Equals("y"))
{
var stSave = UpdateAuditPostMST(reqPostMst, conStr);
if (stSave.Result != 0)
{
flag = "2";
msg = "บันทึกผลการตรวจสอบเรียบร้อยแล้ว";
}
else
{
msg = "พบข้อผิดพลาดจากการบันทึกผลการตรวจสอบ";
}
}
else
{
msg = "ไม่บันทึกผลการตรวจสอบ";
}
dataReq.remark = msg;
dataReq.flag = flag;
}
dataReq.transy = !String.IsNullOrEmpty(dataReq.transy) ? dataReq.transy.ToUpper() : dataReq.transy;
UpdateAuditTrackPostMST(dataReq, conStr);
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
protected override void ExecuteChild(TrackOfflineReq dataReq, ResponseAPI dataRes)
{
var res = new TrackOfflineRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var mode = String.IsNullOrEmpty(dataReq.mode) ? dataReq.mode : dataReq.mode.ToLower();
switch (mode)
{
case "getsqno":
getSQNO(dataReq, res, conString);
break;
case "getproblem":
GetProblem(dataReq, res, conString);
break;
case "addpostmst":
addPostMST(dataReq, res, conString);
break;
case "addposttrn":
addPostTRN(dataReq, res, conString);
break;
case "updatepostmst":
auditPostMST(dataReq, res, conString);
break;
case "updateposttrn":
auditPostTRN(dataReq, res, conString);
break;
case "gettrackhd":
GetTrackOfflineHD(dataReq, res, conString);
break;
case "setauditpostmst":
SetAuditPostMST(dataReq, res, conString);
break;
default:
getTrackOffline(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";
}
dataRes.data = res;
}
