public void SetSystemFields(VersionLock versionLock, DateTime modified)
{
_versionLock = versionLock;
_versionId = versionLock.Id;
_modified = modified;
_modifiedBy = VersionLock.SessionUser;
}
private Address(Guid id, VersionLock version, Guid customerId, string street, string city, string country, int zipCode)
: base(id)
{
CustomerId = customerId;
Street = street;
City = city;
ZipCode = zipCode;
this.SetSystemFields(version, DateTime.Now);
}
public static VersionLock Create(SqlConnection dbConnection, SqlTransaction transaction)
{
var selectCommand = new SqlCommand("SELECT IIF(MAX(Id) is NULL, -1, MAX(Id)) + 1 FROM VersionLock", dbConnection, transaction);
var reader = selectCommand.ExecuteReader();
reader.Read();
var newId = reader.GetInt64(0);
reader.Close();
VersionLock version = new VersionLock(newId, 0, SessionUser, DateTime.Now);
version.isNew = true;
return version;
}
private static VersionLock Load(long id, SqlConnection dbConnection)
{
VersionLock versionLock = null;
try
{
var query = string.Format(LOAD_SQL, id);
using (var selectCommand = new SqlCommand(query, dbConnection))
{
var reader = selectCommand.ExecuteReader();
if (reader.HasRows)
{
var value = reader.GetInt64(1);
var modifiedBy = reader.GetString(2);
var modified = reader.GetDateTime(3);
versionLock = new VersionLock(id, value, modifiedBy, modified);
Versions.Add(versionLock, SessionUser);
}
else
{
throw new SystemException(string.Format("Version {0} not found.", id));
}
reader.Close();
}
}
catch (SqlException sqlEx)
{
throw new SystemException("unexpected sql error loading version", sqlEx);
}
return versionLock;
}
public static Address Create(Guid customerId, VersionLock version, string street, string city, string country, int zipCode)
{
return new Address(Guid.NewGuid(), version, customerId, street, city, country, zipCode);
}