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));
}
