private DBActivityLog GetActivityLogFromReader(IDataReader dataReader)
{
var item = new DBActivityLog();
item.ActivityLogId = NopSqlDataHelper.GetInt(dataReader, "ActivityLogID");
item.ActivityLogTypeId = NopSqlDataHelper.GetInt(dataReader, "ActivityLogTypeID");
item.CustomerId = NopSqlDataHelper.GetInt(dataReader, "CustomerID");
item.Comment = NopSqlDataHelper.GetString(dataReader, "Comment");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(item);
}
/// <summary>
/// Gets an activity log item
/// </summary>
/// <param name="activityLogId">Activity log identifier</param>
/// <returns>Activity log item</returns>
public override DBActivityLog GetActivityById(int activityLogId)
{
DBActivityLog item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ActivityLogLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ActivityLogID", DbType.Int32, activityLogId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetActivityLogFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Updates an activity log
/// </summary>
/// <param name="activityLogId">Activity log identifier</param>
/// <param name="activityLogTypeId">Activity log type identifier</param>
/// <param name="customerId">The customer identifier</param>
/// <param name="comment">The activity comment</param>
/// <param name="createdOn">The date and time of instance creation</param>
/// <returns>Activity log item</returns>
public override DBActivityLog UpdateActivity(int activityLogId,
int activityLogTypeId, int customerId, string comment, DateTime createdOn)
{
DBActivityLog item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ActivityLogUpdate");
db.AddInParameter(dbCommand, "ActivityLogID", DbType.Int32, activityLogId);
db.AddInParameter(dbCommand, "ActivityLogTypeID", DbType.Int32, activityLogTypeId);
db.AddInParameter(dbCommand, "CustomerID", DbType.Int32, customerId);
db.AddInParameter(dbCommand, "Comment", DbType.String, comment);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetActivityById(activityLogId);
}
return(item);
}
