private void Child_Update()
{
if (!IsDirty)
{
return;
}
var dto = new C06_CountryDto();
dto.Country_ID = Country_ID;
dto.Country_Name = Country_Name;
dto.ParentSubContinentID = ParentSubContinentID;
dto.RowVersion = _rowVersion;
using (var dalManager = DalFactorySelfLoad.GetManager())
{
var args = new DataPortalHookArgs(dto);
OnUpdatePre(args);
var dal = dalManager.GetProvider <IC06_CountryDal>();
using (BypassPropertyChecks)
{
var resultDto = dal.Update(dto);
_rowVersion = resultDto.RowVersion;
args = new DataPortalHookArgs(resultDto);
}
OnUpdatePost(args);
// flushes all pending data operations
FieldManager.UpdateChildren(this);
}
}
/// <summary>
/// Factory method. Loads a <see cref="C06_Country"/> object from the given C06_CountryDto.
/// </summary>
/// <param name="data">The <see cref="C06_CountryDto"/>.</param>
/// <returns>A reference to the fetched <see cref="C06_Country"/> object.</returns>
internal static C06_Country GetC06_Country(C06_CountryDto data)
{
C06_Country obj = new C06_Country();
obj.Fetch(data);
return(obj);
}
/// <summary>
/// Factory method. Loads a <see cref="C06_Country"/> object from the given C06_CountryDto.
/// </summary>
/// <param name="data">The <see cref="C06_CountryDto"/>.</param>
/// <returns>A reference to the fetched <see cref="C06_Country"/> object.</returns>
internal static C06_Country GetC06_Country(C06_CountryDto data)
{
C06_Country obj = new C06_Country();
// show the framework that this is a child object
obj.MarkAsChild();
obj.Fetch(data);
obj.MarkOld();
return(obj);
}
/// <summary>
/// Loads a <see cref="C06_Country"/> object from the given <see cref="C06_CountryDto"/>.
/// </summary>
/// <param name="data">The C06_CountryDto to use.</param>
private void Fetch(C06_CountryDto data)
{
// Value properties
LoadProperty(Country_IDProperty, data.Country_ID);
LoadProperty(Country_NameProperty, data.Country_Name);
LoadProperty(ParentSubContinentIDProperty, data.ParentSubContinentID);
_rowVersion = data.RowVersion;
var args = new DataPortalHookArgs(data);
OnFetchRead(args);
}
private C06_CountryDto Fetch(SafeDataReader dr)
{
var c06_Country = new C06_CountryDto();
// Value properties
c06_Country.Country_ID = dr.GetInt32("Country_ID");
c06_Country.Country_Name = dr.GetString("Country_Name");
c06_Country.ParentSubContinentID = dr.GetInt32("Parent_SubContinent_ID");
c06_Country.RowVersion = dr.GetValue("RowVersion") as byte[];
return(c06_Country);
}
/// <summary>
/// Inserts a new C06_Country object in the database.
/// </summary>
/// <param name="c06_Country">The C06 Country DTO.</param>
/// <returns>The new <see cref="C06_CountryDto"/>.</returns>
public C06_CountryDto Insert(C06_CountryDto c06_Country)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager("DeepLoad"))
{
using (var cmd = new SqlCommand("AddC06_Country", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Parent_SubContinent_ID", c06_Country.Parent_SubContinent_ID).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@Country_ID", c06_Country.Country_ID).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Country_Name", c06_Country.Country_Name).DbType = DbType.String;
cmd.Parameters.Add("@NewRowVersion", SqlDbType.Timestamp).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
c06_Country.Country_ID = (int)cmd.Parameters["@Country_ID"].Value;
c06_Country.RowVersion = (byte[])cmd.Parameters["@NewRowVersion"].Value;
}
}
return(c06_Country);
}
private void Child_Insert(C04_SubContinent parent)
{
var dto = new C06_CountryDto();
dto.Parent_SubContinent_ID = parent.SubContinent_ID;
dto.Country_Name = Country_Name;
using (var dalManager = DalFactorySelfLoad.GetManager())
{
var args = new DataPortalHookArgs(dto);
OnInsertPre(args);
var dal = dalManager.GetProvider <IC06_CountryDal>();
using (BypassPropertyChecks)
{
var resultDto = dal.Insert(dto);
LoadProperty(Country_IDProperty, resultDto.Country_ID);
_rowVersion = resultDto.RowVersion;
args = new DataPortalHookArgs(resultDto);
}
OnInsertPost(args);
// flushes all pending data operations
FieldManager.UpdateChildren(this);
}
}
/// <summary>
/// Updates in the database all changes made to the C06_Country object.
/// </summary>
/// <param name="c06_Country">The C06 Country DTO.</param>
/// <returns>The updated <see cref="C06_CountryDto"/>.</returns>
public C06_CountryDto Update(C06_CountryDto c06_Country)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager("DeepLoad"))
{
using (var cmd = new SqlCommand("UpdateC06_Country", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Country_ID", c06_Country.Country_ID).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@Country_Name", c06_Country.Country_Name).DbType = DbType.String;
cmd.Parameters.AddWithValue("@Parent_SubContinent_ID", c06_Country.ParentSubContinentID).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@RowVersion", c06_Country.RowVersion).DbType = DbType.Binary;
cmd.Parameters.Add("@NewRowVersion", SqlDbType.Timestamp).Direction = ParameterDirection.Output;
var rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new DataNotFoundException("C06_Country");
}
c06_Country.RowVersion = (byte[])cmd.Parameters["@NewRowVersion"].Value;
}
}
return(c06_Country);
}
