private void Confirm(string Merchant_trans_id, string sTrans_Id) { ConfirmTransactionResultInfo oConfirmInfo = new ConfirmTransactionResultInfo() { CreateDate = DateTime.Now }; try { string sConfirm = BanknetHelper.ConfirmTransactionResult(Merchant_trans_id, sTrans_Id, "0", ref oConfirmInfo);// quá lâu oConfirmInfo.ResultId = BanknetHelper.getCodeResult(sConfirm); oConfirmInfo.OutString = sConfirm; //if (oConfirmInfo.ResultId == "00") //{ // //ok //} //else //{ // //Response.Redirect("/Banknet/#" + Good_Code + "|F|N"); //} } catch (Exception ex) { oConfirmInfo.ResultId = ex.GetHashCode().ToString(); oConfirmInfo.OutString = ex.Message; //Response.Redirect("/Banknet/#" + Good_Code + "|F|N"); //throw; } finally { ConfirmTransactionResultData.instance.Add(oConfirmInfo); } }
public int Add(ConfirmTransactionResultInfo info) { SqlParameter[] param = { new SqlParameter("@Merchant_trans_id", info.Merchant_trans_id), new SqlParameter("@Trans_id", info.Trans_id), new SqlParameter("@Merchant_code", info.Merchant_code), new SqlParameter("@Trans_key", info.Trans_key), new SqlParameter("@Trans_result", info.Trans_result), new SqlParameter("@ResultId", info.ResultId), new SqlParameter("@OutString", info.OutString), new SqlParameter("@CreateDate", info.CreateDate) }; return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_ConfirmTransactionResult_Add", param).ToString())); }
public int Update(ConfirmTransactionResultInfo info) { SqlParameter[] param = { new SqlParameter("@id", info.id) , new SqlParameter("@Merchant_trans_id",info.Merchant_trans_id), new SqlParameter("@Trans_id", info.Trans_id), new SqlParameter("@Merchant_code", info.Merchant_code), new SqlParameter("@Trans_key", info.Trans_key), new SqlParameter("@Trans_result", info.Trans_result), new SqlParameter("@ResultId", info.ResultId), new SqlParameter("@OutString", info.OutString), new SqlParameter("@CreateDate", info.CreateDate) }; return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_ConfirmTransactionResult_Update", param)); }
private ConfirmTransactionResultInfo FillData(IDataReader r) { ConfirmTransactionResultInfo info = new ConfirmTransactionResultInfo(); if (!r.IsDBNull(r.GetOrdinal("id"))) { info.id = r.GetInt32(r.GetOrdinal("id")); } if (!r.IsDBNull(r.GetOrdinal("Merchant_trans_id"))) { info.Merchant_trans_id = r.GetString(r.GetOrdinal("Merchant_trans_id")); } if (!r.IsDBNull(r.GetOrdinal("Trans_id"))) { info.Trans_id = r.GetString(r.GetOrdinal("Trans_id")); } if (!r.IsDBNull(r.GetOrdinal("Merchant_code"))) { info.Merchant_code = r.GetString(r.GetOrdinal("Merchant_code")); } if (!r.IsDBNull(r.GetOrdinal("Trans_key"))) { info.Trans_key = r.GetString(r.GetOrdinal("Trans_key")); } if (!r.IsDBNull(r.GetOrdinal("Trans_result"))) { info.Trans_result = r.GetString(r.GetOrdinal("Trans_result")); } if (!r.IsDBNull(r.GetOrdinal("ResultId"))) { info.ResultId = r.GetString(r.GetOrdinal("ResultId")); } if (!r.IsDBNull(r.GetOrdinal("OutString"))) { info.OutString = r.GetString(r.GetOrdinal("OutString")); } if (!r.IsDBNull(r.GetOrdinal("CreateDate"))) { info.CreateDate = r.GetDateTime(r.GetOrdinal("CreateDate")); } return(info); }
public ConfirmTransactionResultInfo GetInfo(int id) { ConfirmTransactionResultInfo info = null; SqlParameter[] param = { new SqlParameter("@id", id) }; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_ConfirmTransactionResult_GetById", param); if (r != null) { info = new ConfirmTransactionResultInfo(); while (r.Read()) { info = FillData(r); } r.Close(); r.Dispose(); } return(info); }
public static string ConfirmTransactionResult(string Merchant_trans_id, string Trans_id, string Trans_result, ref ConfirmTransactionResultInfo oConfirmInfo) { string TransHash = Security.GetMD5Hash(Merchant_trans_id + Trans_id + Merchant_code + Trans_result + Merchant_trans_key); oConfirmInfo.Merchant_trans_id = Merchant_trans_id; oConfirmInfo.Trans_id = Trans_id; oConfirmInfo.Merchant_code = Merchant_code; oConfirmInfo.Trans_key = TransHash; oConfirmInfo.Trans_result = Trans_result; return(instance.ConfirmTransactionResult(Merchant_trans_id, Trans_id, Merchant_code, Trans_result, TransHash)); }