protected bool CheckInsertGameLog(string IDNo, string Ball)
{
if (CheckTimeout.IsEbankEnd())
{
return(true);
}
else
{
string IP;
IP = "[" + Request.ServerVariables["REMOTE_ADDR"] + "]";
if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != "")
{
IP += "[" + Request.ServerVariables["HTTP_X_FORWARDED_FOR"] + "]";
}
ConnectionStringSettings connSettings = ConfigurationManager.ConnectionStrings["ConnString"];
SqlConnection conn = new SqlConnection(connSettings.ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("usp_InsertMember", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parm_IDNo = new SqlParameter("@ID", SqlDbType.VarChar, 50);
SqlParameter parm_Times = new SqlParameter("@Times", SqlDbType.Int);
SqlParameter parm_IP = new SqlParameter("@IP", SqlDbType.VarChar, 40);
parm_IDNo.Value = IDNo;
parm_Times.Value = Int16.Parse(Ball);
parm_IP.Value = IP.Replace("[]", "");
cmd.Parameters.Add(parm_IDNo);
cmd.Parameters.Add(parm_Times);
cmd.Parameters.Add(parm_IP);
//Response.Write("ID=" + IDNo + "<BR>");
//Response.Write("Ball=" + Int16.Parse(Ball).ToString() + "<BR>");
//Response.Write("IP=" + IP + "<BR>");
string ReturnValue = cmd.ExecuteScalar().ToString();
//Response.Write("ReturnValue=" + ReturnValue + "<BR>");
cmd.Dispose();
conn.Close();
conn.Dispose();
if (ReturnValue == "y")
{
return(true);
}
else
{
return(false);
}
}
}
