public void ProcessPayment(String MEMBER_NO, String COOP_ID, String ACCOUNT_NO, Decimal ITEM_AMT, DateTime CCS_OPERATE_DATE, String SYSTEM_CODE, String OPERATE_CODE, String CASH_TYPE, String ATM_NO, String ATM_SEQNO, String SAVING_ACC, LogMessage LogMessage, Sta ta)
{
try
{
if (SYSTEM_CODE == "01") //เงินกู้
{
String SqlUpdateATMLOAN = "UPDATE ATMLOAN SET PAY_AMT=PAY_AMT + {0} WHERE ATMLOAN.MEMBER_NO={1} AND ATMLOAN.COOP_ID={2} AND ATMLOAN.LOANCONTRACT_NO={3}";
SqlUpdateATMLOAN = WebUtil.SQLFormat(SqlUpdateATMLOAN, ITEM_AMT, MEMBER_NO, COOP_ID, ACCOUNT_NO);
LogMessage.WriteLog("UPDATE ATMLOAN", SqlUpdateATMLOAN);
ta.Exe(SqlUpdateATMLOAN);
}
else if (SYSTEM_CODE == "02") //เงินฝาก
{
String SqlUpdateATMDEPT = "UPDATE ATMDEPT SET PAY_AMT=PAY_AMT + {0} WHERE ATMDEPT.MEMBER_NO={1} AND ATMDEPT.COOP_ID={2} AND ATMDEPT.DEPTACCOUNT_NO={3}";
SqlUpdateATMDEPT = WebUtil.SQLFormat(SqlUpdateATMDEPT, ITEM_AMT, MEMBER_NO, COOP_ID, ACCOUNT_NO);
LogMessage.WriteLog("UPDATE ATMDEPT", SqlUpdateATMDEPT);
ta.Exe(SqlUpdateATMDEPT);
}
else
{
throw new Exception("SYSTEM_CODE NOT VALUE (ไม่ถูกต้อง)");
}
String SqlInsertATMTRANSACTION = @"INSERT INTO ATMTRANSACTION
( MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE,
ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC )
VALUES ( {0}, {1}, {2}, {3}, {4}, {5}, {6},
{7}, {8}, {9}, {10})";
SqlInsertATMTRANSACTION = WebUtil.SQLFormat(SqlInsertATMTRANSACTION, MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE, ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC);
LogMessage.WriteLog("INSERT ATMTRAN", SqlInsertATMTRANSACTION);
ta.Exe(SqlInsertATMTRANSACTION);
}
catch (Exception ex)
{
throw ex;
}
}
public void ProcessCancelPayment(String MEMBER_NO, String COOP_ID, String ACCOUNT_NO, Decimal ITEM_AMT, DateTime CCS_OPERATE_DATE, String SYSTEM_CODE, String OPERATE_CODE, String CASH_TYPE, String ATM_NO, String ATM_SEQNO, String SAVING_ACC, LogMessage LogMessage, Sta ta)
{
try
{
String SqlInsertATMTRANSACTIONCANCEL = @"INSERT INTO ATMTRANSACTIONCANCEL
( MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE,
ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC )
VALUES ( {0}, {1}, {2}, {3}, {4}, {5}, {6},
{7}, {8}, {9}, {10})";
SqlInsertATMTRANSACTIONCANCEL = WebUtil.SQLFormat(SqlInsertATMTRANSACTIONCANCEL, MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE, ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC);
LogMessage.WriteLog("INSERT TRNCANCEL", SqlInsertATMTRANSACTIONCANCEL);
ta.Exe(SqlInsertATMTRANSACTIONCANCEL);
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
String SqlRequest = String.Empty;
String SqlResponse = String.Empty;
Sta ta = new Sta();
Sta taCommit = new Sta();
String LogFileName = DateTime.Now.ToString("yyyyMMdd") + ".txt";
try
{
String DataMessage = Request["DataMassage"];
try
{
LogFileName = DateTime.Now.ToString("yyyyMMdd") + DataMessage.Substring(157, 10) + ".txt";
}
catch { }
LogMessage = new LogMessage(LogFileName);
LogMessage.WriteLog("Request", DataMessage);
//เชค Online ใน AppTest
if (DataMessage == "TestWCF")
{
Result = "1";
return;
}
//ตรวจสอบข้อมูล
CheckLength(ref DataMessage);
//จัดการข้อมูล
DataEncode DataRequest = new DataEncode(DataMessage);
DataEncode DataResponse = new DataEncode(DataMessage);
try
{
taCommit.Transection();
ta.Transection();
}
catch (Exception ex)
{
DataResponse.ResponseCode = ResponseCode.DatabaseProblem;
Result = DataResponse.DataMassage;
LogMessage.WriteLog("Database Problem", "");
throw ex;
}
//#############################################################################
DataResponse.ResponseCode = ResponseCode.SystemError; //ป้องกันการ Error Exception
SqlResponse = DataResponse.GetInsertATMACT();
Result = DataResponse.DataMassage;
DataResponse.ResponseCode = ResponseCode.Approve;
//#############################################################################
SqlRequest = DataRequest.GetInsertATMACT();//บันทึกลงตาราง ATMACT เก็บ LOG การ Request
LogMessage.WriteLog("LOGREQ SQL", SqlRequest);
taCommit.Exe(SqlRequest);
//#############################################################################
try
{
//ตรวจสอบ Request
switch (DataRequest.TransactionMessageCode)
{
case "0100": // Account Name Inquiry [ถามชื่อบัญชี]
AccountNameInquiry(DataRequest, ref DataResponse, ta, LogMessage);
break;
case "0700": //Balance Inquiry
BalanceInquiry(DataRequest, ref DataResponse, ta, LogMessage);
break;
case "0200": // Fund Transfer //Money Withdraw
Transaction(DataRequest, ref DataResponse, ta, LogMessage);
break;
case "0400": //Fund Transfer/ Cash Withdraw Reversal Request[ยกเลิกรายการทันที]
CancelTransaction(DataRequest, ref DataResponse, ta, LogMessage);
break;
default: break;
}
}
catch (Exception ex)
{
if (DataResponse.ResponseCode == 0)
{
DataResponse.ResponseCode = ResponseCode.SystemError;
}
LogMessage.WriteLog("ResponseCode", "[" + DataResponse.ResponseCode + "]");
Result = DataResponse.DataMassage;
SqlResponse = DataResponse.GetInsertATMACT();
throw ex;
}
Result = DataResponse.DataMassage;
SqlResponse = DataResponse.GetInsertATMACT();//บันทึกลงตาราง ATMACT เก็บ LOG การ Response
LogMessage.WriteLog("LOGRES SQL", SqlResponse);
taCommit.Exe(SqlResponse);
taCommit.Commit();
ta.Commit();
taCommit.Close();
ta.Close();
}
catch (Exception ex)
{
LogMessage.WriteLog("ExceptionErr", ex.Message.Trim());
try
{
ta.RollBack();
ta.Close();
}
catch { }
try
{
try { LogMessage.WriteLog("LOGRES SQL", SqlResponse); taCommit.Exe(SqlResponse); }
catch { }
taCommit.Commit();
taCommit.Close();
}
catch { }
}
LogMessage.WriteLog("Response", Result);
LogMessage.WriteLog("", "-------------------------------------------------------------------------------\r\n");
}
