// insert all object members as a new row in table, in a transaction
// the transaction and or connection state is not changed in any way other than what SqlClient does to it.
// it is the callers responsibility to commit or rollback the transaction
// links:
// docLink: http://sql2x.org/documentationLink/542f9458-c3b9-4edf-8575-0870086f3a7f
public void Insert(CrudeDefaultUserActivityContract contract, SqlConnection connection, SqlTransaction transaction)
{
var data = new CrudeDefaultUserActivityData();
ContractToData(contract, data);
data.Insert(connection, transaction);
}
// insert all object members as a new row in table
// links:
// docLink: http://sql2x.org/documentationLink/75aad010-e6aa-4f19-a6e5-597456aa20d8
public void Insert(CrudeDefaultUserActivityContract contract)
{
var data = new CrudeDefaultUserActivityData();
ContractToData(contract, data);
data.Insert();
}
// transfer model to data and insert
// links:
// docLink: http://sql2x.org/documentationLink/17cd8423-3c78-459f-a45b-773fcfbc3b7d
public void Insert(CrudeDefaultUserActivityModel model)
{
var data = new CrudeDefaultUserActivityData();
ModelToData(model, data);
data.Insert();
}
// transfer model to data and insert, on transaction
// links:
// docLink: http://sql2x.org/documentationLink/fbeb7c34-b2d7-403b-a9fd-503ab705ef81
public void Insert(CrudeDefaultUserActivityModel model, SqlConnection connection, SqlTransaction transaction)
{
var data = new CrudeDefaultUserActivityData();
ModelToData(model, data);
data.Insert(connection, transaction);
}
/// <summary>
/// Add an activity
/// </summary>
/// <param name="userId">User who triggered the activity</param>
public void AddActivity(
Guid userId,
string userActivityTypeRcd,
string activityNote,
string originatingAddress
)
{
var defaultUserActivity = new CrudeDefaultUserActivityData();
defaultUserActivity.DefaultUserActivityId = Guid.NewGuid();
defaultUserActivity.DefaultUserActivityTypeRcd = userActivityTypeRcd;
defaultUserActivity.UserActivityNote = activityNote;
defaultUserActivity.OriginatingAddress = originatingAddress;
defaultUserActivity.DefaultUserId = userId;
defaultUserActivity.DateTime = DateTime.UtcNow;
defaultUserActivity.Insert();
var defaultUser = new CrudeDefaultUserData();
defaultUser.FetchByDefaultUserId(userId);
defaultUser.LastActivityDateTime = DateTime.UtcNow;
defaultUser.Update(); // todo, possible to only update LastActivityDateTime?
}