/// <summary>
/// Add common parameters before calling a procedure
/// </summary>
/// <param name="cmd">command object, where parameters will be added</param>
/// <param name="userActivityObject"></param>
private void AddCommonParams(SqlCommand cmd, UserActivityBase userActivityObject)
{
AddParameter(cmd, pNVarChar(UserActivityBase.Property_PageUrl, userActivityObject.PageUrl));
AddParameter(cmd, pNVarChar(UserActivityBase.Property_ReferrerUrl, userActivityObject.ReferrerUrl));
AddParameter(cmd, pNVarChar(UserActivityBase.Property_Action, 50, userActivityObject.Action));
AddParameter(cmd, pNVarChar(UserActivityBase.Property_ActionDisplyText, 250, userActivityObject.ActionDisplyText));
AddParameter(cmd, pNVarChar(UserActivityBase.Property_UserIp, 100, userActivityObject.UserIp));
AddParameter(cmd, pNVarChar(UserActivityBase.Property_UserAgent, userActivityObject.UserAgent));
AddParameter(cmd, pGuid(UserActivityBase.Property_UserId, userActivityObject.UserId));
AddParameter(cmd, pDateTime(UserActivityBase.Property_StatsDate, userActivityObject.StatsDate));
}
/// <summary>
/// Fills UserActivity object
/// </summary>
/// <param name="userActivityObject">The object to be filled</param>
/// <param name="reader">The reader to use to fill a single object</param>
/// <param name="start">The ordinal position from which to start reading the reader</param>
protected void FillObject(UserActivityBase userActivityObject, SqlDataReader reader, int start)
{
userActivityObject.Id = reader.GetInt32(start + 0);
userActivityObject.PageUrl = reader.GetString(start + 1);
userActivityObject.ReferrerUrl = reader.GetString(start + 2);
userActivityObject.Action = reader.GetString(start + 3);
userActivityObject.ActionDisplyText = reader.GetString(start + 4);
userActivityObject.UserIp = reader.GetString(start + 5);
userActivityObject.UserAgent = reader.GetString(start + 6);
userActivityObject.UserId = reader.GetGuid(start + 7);
userActivityObject.StatsDate = reader.GetDateTime(start + 8);
FillBaseObject(userActivityObject, reader, (start + 9));
userActivityObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow;
}
/// <summary>
/// Updates UserActivity
/// </summary>
/// <param name="userActivityObject">Object to be updated</param>
/// <returns>Number of rows affected</returns>
public long Update(UserActivityBase userActivityObject)
{
try
{
SqlCommand cmd = GetSPCommand(UPDATEUSERACTIVITY);
AddParameter(cmd, pInt32(UserActivityBase.Property_Id, userActivityObject.Id));
AddCommonParams(cmd, userActivityObject);
long result = UpdateRecord(cmd);
if (result > 0)
{
userActivityObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow;
}
return(result);
}
catch (SqlException x)
{
throw new ObjectUpdateException(userActivityObject, x);
}
}
/// <summary>
/// Inserts UserActivity
/// </summary>
/// <param name="userActivityObject">Object to be inserted</param>
/// <returns>Number of rows affected</returns>
public long Insert(UserActivityBase userActivityObject)
{
try
{
SqlCommand cmd = GetSPCommand(INSERTUSERACTIVITY);
AddParameter(cmd, pInt32Out(UserActivityBase.Property_Id));
AddCommonParams(cmd, userActivityObject);
long result = InsertRecord(cmd);
if (result > 0)
{
userActivityObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow;
userActivityObject.Id = (Int32)GetOutParameter(cmd, UserActivityBase.Property_Id);
}
return(result);
}
catch (SqlException x)
{
throw new ObjectInsertException(userActivityObject, x);
}
}
/// <summary>
/// Fills UserActivity object
/// </summary>
/// <param name="userActivityObject">The object to be filled</param>
/// <param name="reader">The reader to use to fill a single object</param>
protected void FillObject(UserActivityBase userActivityObject, SqlDataReader reader)
{
FillObject(userActivityObject, reader, 0);
}
