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); }