/// <summary>
/// Get with transaction
/// </summary>
public Plat_util_CodeDetail Get(object entityId, DbTransaction transaction)
{
ArgumentValidator.CheckForNullArgument(entityId, "entityId");
ArgumentValidator.CheckForNullArgument(transaction, "transaction");
Plat_util_CodeDetail Plat_util_CodeDetailEntity = null;
try
{
Database db = GetDatabaseInstance();
DbCommand dbCommand = db.GetSqlStringCommand(Plat_util_CodeDetailDAO.SqlGet);
db.AddInParameter(dbCommand, "@CodeDetailGuid", DbType.Guid, entityId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand, transaction))
{
if (dataReader.Read())
{
Plat_util_CodeDetailEntity = ReadEntity(dataReader);
}
}
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
}
return(Plat_util_CodeDetailEntity);
}
private void UpdateAll(Plat_util_CodeDetail entity, DbTransaction transaction)
{
ArgumentValidator.CheckForNullArgument(entity, "entity");
ArgumentValidator.CheckForNullArgument(transaction, "transaction");
PersistentPlat_util_CodeDetail Plat_util_CodeDetailEntity = entity as PersistentPlat_util_CodeDetail;
try
{
Database db = GetDatabaseInstance();
DbCommand dbCommand = db.GetSqlStringCommand(Plat_util_CodeDetailDAO.SqlUpdate);
db.AddInParameter(dbCommand, "@CodeDetailGuid", DbType.Guid, Plat_util_CodeDetailEntity.CodeDetailGuid);
db.AddInParameter(dbCommand, "@CodeBaseCode", DbType.String, Plat_util_CodeDetailEntity.CodeBaseCode);
db.AddInParameter(dbCommand, "@CodeDetailCode", DbType.String, Plat_util_CodeDetailEntity.CodeDetailCode);
db.AddInParameter(dbCommand, "@CodeDetailName", DbType.String, Plat_util_CodeDetailEntity.CodeDetailName);
db.AddInParameter(dbCommand, "@CodeDetailDesc", DbType.String, Plat_util_CodeDetailEntity.CodeDetailDesc);
db.AddInParameter(dbCommand, "@CodeDetailValue", DbType.String, Plat_util_CodeDetailEntity.CodeDetailValue);
db.AddInParameter(dbCommand, "@MySequence", DbType.Int32, Plat_util_CodeDetailEntity.MySequence);
db.AddInParameter(dbCommand, "@IsDefault", DbType.Boolean, Plat_util_CodeDetailEntity.IsDefault);
db.AddInParameter(dbCommand, "@IsDisplay", DbType.Boolean, Plat_util_CodeDetailEntity.IsDisplay);
db.AddInParameter(dbCommand, "@IsActive", DbType.Boolean, Plat_util_CodeDetailEntity.IsActive);
int result = db.ExecuteNonQuery(dbCommand, transaction);
if (result == 0)
{
throw new EntityNotFoundException();
}
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
}
}
/// <summary>
/// Insert
/// </summary>
public Plat_util_CodeDetail Insert(Plat_util_CodeDetail entity)
{
ArgumentValidator.CheckForNullArgument(entity, "entity");
PersistentPlat_util_CodeDetail Plat_util_CodeDetailEntity = entity as PersistentPlat_util_CodeDetail;
try
{
Database db = GetDatabaseInstance();
DbCommand dbCommand = db.GetSqlStringCommand(Plat_util_CodeDetailDAO.SqlInsert);
db.AddInParameter(dbCommand, "@CodeDetailGuid", DbType.Guid, Plat_util_CodeDetailEntity.CodeDetailGuid);
db.AddInParameter(dbCommand, "@CodeBaseCode", DbType.String, Plat_util_CodeDetailEntity.CodeBaseCode);
db.AddInParameter(dbCommand, "@CodeDetailCode", DbType.String, Plat_util_CodeDetailEntity.CodeDetailCode);
db.AddInParameter(dbCommand, "@CodeDetailName", DbType.String, Plat_util_CodeDetailEntity.CodeDetailName);
db.AddInParameter(dbCommand, "@CodeDetailDesc", DbType.String, Plat_util_CodeDetailEntity.CodeDetailDesc);
db.AddInParameter(dbCommand, "@CodeDetailValue", DbType.String, Plat_util_CodeDetailEntity.CodeDetailValue);
db.AddInParameter(dbCommand, "@MySequence", DbType.Int32, Plat_util_CodeDetailEntity.MySequence);
db.AddInParameter(dbCommand, "@IsDefault", DbType.Boolean, Plat_util_CodeDetailEntity.IsDefault);
db.AddInParameter(dbCommand, "@IsDisplay", DbType.Boolean, Plat_util_CodeDetailEntity.IsDisplay);
db.AddInParameter(dbCommand, "@IsActive", DbType.Boolean, Plat_util_CodeDetailEntity.IsActive);
int result = db.ExecuteNonQuery(dbCommand);
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
}
return(Plat_util_CodeDetailEntity as Plat_util_CodeDetail);
}
public void Update(Plat_util_CodeDetail entity, bool updateAll, DbTransaction transaction)
{
if (!updateAll)
{
UpdateSome(entity, transaction);
}
else
{
UpdateAll(entity, transaction);
}
}
public void Update(Plat_util_CodeDetail entity, bool updateAll)
{
if (!updateAll)
{
UpdateSome(entity);
}
else
{
UpdateAll(entity);
}
}
public void UpdateSome(Plat_util_CodeDetail entity)
{
try
{
ArgumentValidator.CheckForNullArgument(entity, "Plat_util_CodeDetail Entity");
plat_util_CodeDetailDAO.Update(entity, false);
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy);
}
}
public Plat_util_CodeDetail GetEntity(Guid entityGuid)
{
Plat_util_CodeDetail entity = null;
try
{
ArgumentValidator.CheckForNullArgument(entityGuid, "Plat_util_CodeDetail Guid");
entity = plat_util_CodeDetailDAO.Get(entityGuid);
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy);
}
return(entity);
}
public Plat_util_CodeDetail Insert(Plat_util_CodeDetail entity)
{
Plat_util_CodeDetail newEntity = null;
try
{
ArgumentValidator.CheckForNullArgument(entity, "Plat_util_CodeDetail Entity");
newEntity = plat_util_CodeDetailDAO.Insert(entity);
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy);
}
return(newEntity);
}
private static Plat_util_CodeDetail ReadEntity(IDataReader dataReader)
{
Plat_util_CodeDetail Plat_util_CodeDetailEntity = new Plat_util_CodeDetail();
object value;
value = dataReader["CodeDetailGuid"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.CodeDetailGuid = (Guid?)value;
}
value = dataReader["CodeBaseCode"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.CodeBaseCode = (String)value;
}
value = dataReader["CodeDetailCode"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.CodeDetailCode = (String)value;
}
value = dataReader["CodeDetailName"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.CodeDetailName = (String)value;
}
value = dataReader["CodeDetailDesc"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.CodeDetailDesc = (String)value;
}
value = dataReader["CodeDetailValue"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.CodeDetailValue = (String)value;
}
value = dataReader["MySequence"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.MySequence = (Int32?)value;
}
value = dataReader["IsDefault"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.IsDefault = (Boolean?)value;
}
value = dataReader["IsDisplay"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.IsDisplay = (Boolean?)value;
}
value = dataReader["IsActive"];
if (value != DBNull.Value)
{
Plat_util_CodeDetailEntity.IsActive = (Boolean?)value;
}
return(Plat_util_CodeDetailEntity);
}
private void UpdateSome(Plat_util_CodeDetail entity, DbTransaction transaction)
{
ArgumentValidator.CheckForNullArgument(entity, "entity");
ArgumentValidator.CheckForNullArgument(transaction, "transaction");
PersistentPlat_util_CodeDetail Plat_util_CodeDetailEntity = entity as PersistentPlat_util_CodeDetail;
StringBuilder sqlUpdateSome = new StringBuilder();
sqlUpdateSome.Append("UPDATE dbo.Plat_util_CodeDetail SET ");
PropertyInfo[] propertyInfos = Plat_util_CodeDetailEntity.GetType().GetProperties();
Hashtable propertyValues = new System.Collections.Hashtable();
int columnCountForUpdate = 0;
foreach (PropertyInfo propertyInfo in propertyInfos)
{
if (EntityMapping.ContainsProperty(propertyInfo.Name))
{
object propertyValue = propertyInfo.GetValue(Plat_util_CodeDetailEntity, null);
ORProperty property = EntityMapping[propertyInfo.Name];
if (!property.IsPrimaryKey)
{
if (!Plat_util_CodeDetailEntity.IsDefaultValue(propertyInfo.Name))
{
propertyValues[propertyInfo.Name] = propertyValue;
sqlUpdateSome.Append(" " + property.ColumnName + " = @" + property.ColumnName + ",");
columnCountForUpdate++;
}
}
else
{
propertyValues[propertyInfo.Name] = propertyValue;
}
}
}
if (columnCountForUpdate == 0)
{
return;
}
sqlUpdateSome.Remove(sqlUpdateSome.Length - 1, 1);
sqlUpdateSome.Append(" WHERE 1 = 1 ");
sqlUpdateSome.Append(" AND CodeDetailGuid = @CodeDetailGuid ");
try
{
Database db = GetDatabaseInstance();
DbCommand dbCommand = db.GetSqlStringCommand(sqlUpdateSome.ToString());
foreach (DictionaryEntry de in propertyValues)
{
ORProperty property = EntityMapping[de.Key.ToString()];
db.AddInParameter(dbCommand, "@" + property.ColumnName, property.DatabaseType, de.Value);
}
int result = db.ExecuteNonQuery(dbCommand, transaction);
if (result == 0)
{
throw new EntityNotFoundException();
}
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
}
}
/// <summary>
/// Update with transaction
/// </summary>
public void Update(Plat_util_CodeDetail entity, DbTransaction transaction)
{
Update(entity, true, transaction);
}
/// <summary>
/// Update
/// </summary>
public void Update(Plat_util_CodeDetail entity)
{
Update(entity, true);
}
