protected override object ReadRow(IRowReader reader)
{
HomepageType homepageType = HomepageType.New();
// Table Fields
homepageType.HomepageTypeId = reader.GetInt32("HomepageTypeId");
homepageType.Description = reader.GetString("Description");
homepageType.ShortName = reader.GetString("ShortName");
homepageType.IsDirty = false;
homepageType.ChangedProperties.Clear();
return(homepageType);
}
public virtual HomepageType Update(HomepageType homepageType)
{
if (!homepageType.IsDirty || homepageType.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(homepageType);
}
IDbCommand command = CreateCommand();
if (homepageType.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [HomepageType] ([Description], [ShortName]) VALUES (@description, @shortName) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [HomepageType] SET [Description] = @description, [ShortName] = @shortName WHERE HomepageTypeId = @homepageTypeId";
}
command.Parameters.Add(CreateParameter("@description", homepageType.Description));
command.Parameters.Add(CreateParameter("@shortName", homepageType.ShortName));
if (homepageType.IsNew)
{
homepageType.HomepageTypeId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@homepageTypeId", homepageType.HomepageTypeId));
ExecuteCommand(command);
}
homepageType.IsDirty = false;
homepageType.ChangedProperties.Clear();
return(homepageType);
}
public static HomepageType Update(HomepageType homepageType)
{
return(HomepageTypeMapper.Instance.Update(homepageType));
}
public static HomepageType FindOne(HomepageTypeFinder finder)
{
HomepageType HomepageType = HomepageTypeMapper.Instance.FindOne(finder);
return(HomepageType ?? Empty);
}
public static HomepageType Get(Nullable <Int32> HomepageTypeId)
{
HomepageType HomepageType = HomepageTypeMapper.Instance.Get(HomepageTypeId);
return(HomepageType ?? Empty);
}
