public override bool IsValidClick(string userOrGuestID, int targetId, string Ip, ClickSourceType type, int availibleUserInterval, DateTime AllowIpLastClickDateTime, int availibleIpClickCount)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_IsAvailibleClick";
query.CommandType = System.Data.CommandType.StoredProcedure;
query.CreateParameter<string>("@Ip", Ip, SqlDbType.VarChar, 50);
query.CreateParameter<string>("@UserIdentify", userOrGuestID, SqlDbType.VarChar, 200);
query.CreateParameter<DateTime>("@AllowUserLastClickDateTime", DateTimeUtil.Now.AddSeconds(-availibleUserInterval), SqlDbType.DateTime);
query.CreateParameter<DateTime>("@AllowIpLastClickDateTime", AllowIpLastClickDateTime, SqlDbType.DateTime);
query.CreateParameter<int>("@AllowIpTotalClicks", availibleIpClickCount, SqlDbType.Int);
query.CreateParameter<int>("@SourceType", (int)type, SqlDbType.Int);
query.CreateParameter<int>("@TargetID", targetId, SqlDbType.Int);
return (int)query.ExecuteScalar() == 1;
}
}
public abstract bool IsValidClick(string userOrGuestID, int targetId, string Ip, ClickSourceType type, int availibleUserInterval, DateTime AllowIpLastClickDateTime, int availibleIpClickCount);
public override bool IsValidClick(string userOrGuestID, int targetId, string Ip, ClickSourceType type, int availibleUserInterval, DateTime AllowIpLastClickDateTime, int availibleIpClickCount)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_IsAvailibleClick";
query.CommandType = System.Data.CommandType.StoredProcedure;
query.CreateParameter <string>("@Ip", Ip, SqlDbType.VarChar, 50);
query.CreateParameter <string>("@UserIdentify", userOrGuestID, SqlDbType.VarChar, 200);
query.CreateParameter <DateTime>("@AllowUserLastClickDateTime", DateTimeUtil.Now.AddSeconds(-availibleUserInterval), SqlDbType.DateTime);
query.CreateParameter <DateTime>("@AllowIpLastClickDateTime", AllowIpLastClickDateTime, SqlDbType.DateTime);
query.CreateParameter <int>("@AllowIpTotalClicks", availibleIpClickCount, SqlDbType.Int);
query.CreateParameter <int>("@SourceType", (int)type, SqlDbType.Int);
query.CreateParameter <int>("@TargetID", targetId, SqlDbType.Int);
return((int)query.ExecuteScalar() == 1);
}
}
