public void Delete(IEnumerable <int> userIds, UserTempDataType dataType)
{
if (ValidateUtil.HasItems <int>(userIds))
{
UserTempDataDao.Instance.Delete(userIds, dataType);
}
}
public void Delete(int userID, UserTempDataType dataType)
{
if (userID <= 0)
{
return;
}
UserTempDataDao.Instance.Delete(userID, dataType);
}
public void SaveData(int userID, UserTempDataType dataType, object data, bool overrideOld)
{
if (userID <= 0)
{
return;
}
UserTempDataDao.Instance.SaveData(userID, dataType, data, overrideOld);
}
public override void DeleteByType(UserTempDataType dataType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = " DELETE FROM bx_UserTempData WHERE DataType = @DataType";
query.CreateParameter<short>("@DataType", (short)dataType, SqlDbType.SmallInt);
query.CommandType = CommandType.Text;
query.ExecuteNonQuery();
}
}
public override void DeleteByType(UserTempDataType dataType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = " DELETE FROM bx_UserTempData WHERE DataType = @DataType";
query.CreateParameter <short>("@DataType", (short)dataType, SqlDbType.SmallInt);
query.CommandType = CommandType.Text;
query.ExecuteNonQuery();
}
}
public override void Delete(IEnumerable<int> userIds, UserTempDataType dataType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "DELETE FROM bx_UserTempData WHERE UserID IN (@UserIds) AND DataType = @DataType";
query.CommandType = CommandType.Text;
query.CreateParameter<short>("@DataType" ,(short)dataType , SqlDbType.SmallInt );
query.CreateInParameter<int>("@UserIds" ,userIds);
query.ExecuteNonQuery();
}
}
public override void Delete(IEnumerable <int> userIds, UserTempDataType dataType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "DELETE FROM bx_UserTempData WHERE UserID IN (@UserIds) AND DataType = @DataType";
query.CommandType = CommandType.Text;
query.CreateParameter <short>("@DataType", (short)dataType, SqlDbType.SmallInt);
query.CreateInParameter <int>("@UserIds", userIds);
query.ExecuteNonQuery();
}
}
public override void SaveData(int userID, UserTempDataType dataType, object data, bool overrideOldData)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_SaveUserTemporaryData";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter <short>("@DataType", (short)dataType, SqlDbType.SmallInt);
query.CreateParameter <string>("@Data", data.ToString(), SqlDbType.NText);
query.CreateParameter <bool>("@OverrideOld", overrideOldData, SqlDbType.Bit);
query.ExecuteNonQuery();
}
}
public void ProcessRequest(System.Web.HttpContext context)
{
UserTempDataType type = StringUtil.TryParse <UserTempDataType>(context.Request.QueryString["type"], UserTempDataType.None);
string action = context.Request.QueryString["action"];
User user = User.Current;
context.Response.CacheControl = "no-cache";
if (user != null)
{
if (type != UserTempDataType.None &&
type != UserTempDataType.Avatar
)
{
if (action == "get")
{
UserTempData data = UserTempDataBO.Instance.GetTempData(user.UserID, type);
if (data != null)
{
string value = data.Data.ToString();
context.Response.Write(value);
context.Response.End();
}
}
else if (action == "save")
{
string format = context.Request.Form["format"];
string value = context.Request.Form["data"] + "";
if (!string.IsNullOrEmpty(format))
{
value = format + "|" + value;
}
UserTempDataBO.Instance.SaveData(user.UserID, type, value, true);
}
else if (action == "delete")
{
UserTempDataBO.Instance.Delete(user.UserID, type);
}
}
}
}
public override UserTempData GetTemporaryDataWithExpiresDate(int userID, UserTempDataType dataType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "SELECT * FROM bx_UserTempData WHERE UserID = @UserID AND DataType = @DataType AND ExpiresDate>=GetDate()";
query.CommandType = CommandType.Text;
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter <short>("@DataType", (short)dataType, SqlDbType.SmallInt);
using (XSqlDataReader reader = query.ExecuteReader())
{
if (reader.Read())
{
return(new UserTempData(reader));
}
}
return(null);
}
}
public override UserTempData GetTemporaryData(int userID, UserTempDataType dataType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "SELECT * FROM bx_UserTempData WHERE UserID = @UserID AND DataType = @DataType";
query.CommandType = CommandType.Text;
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter<short>("@DataType", (short)dataType, SqlDbType.SmallInt);
using (XSqlDataReader reader = query.ExecuteReader())
{
if (reader.Read())
{
return new UserTempData(reader);
}
}
return null;
}
}
public abstract UserTempData GetTemporaryData(int userID, UserTempDataType dataType);
public abstract void Delete(int userID, UserTempDataType dataType);
public abstract void Delete(IEnumerable <int> userIds, UserTempDataType dataType);
public abstract void DeleteByType(UserTempDataType dataType);
public abstract void SaveData(int userID, UserTempDataType dataType, object data, bool overrideOld);
public UserTempData GetTempData(int targetUserID, UserTempDataType dataType)
{
return(UserTempDataDao.Instance.GetTemporaryData(targetUserID, dataType));
}
public override void SaveData(int userID, UserTempDataType dataType, object data, bool overrideOldData)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_SaveUserTemporaryData";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter<short>("@DataType", (short)dataType, SqlDbType.SmallInt);
query.CreateParameter<string>("@Data", data.ToString(), SqlDbType.NText);
query.CreateParameter<bool>("@OverrideOld", overrideOldData, SqlDbType.Bit);
query.ExecuteNonQuery();
}
}
public void GetDataByUserIds(IEnumerable <int> userIds, UserTempDataType dataType)
{
}
public void Delete(UserTempDataType dataType)
{
UserTempDataDao.Instance.Delete(dataType);
}
public abstract UserTempData GetTemporaryDataWithExpiresDate(int userID, UserTempDataType dataType);
