public virtual Homepage Update(Homepage homepage)
{
if (!homepage.IsDirty || homepage.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(homepage);
}
IDbCommand command = CreateCommand();
if (homepage.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [Homepage] ([BrandId], [IntroText], [Url1], [Url2], [Url3], [Url4], [BumperPageHtml], [BumperPageSkip], [CustomHtml], [HomepageTypeId], [IsPublished], [LastModifiedByUserId], [LastModifiedDate]) VALUES (@brandId, @introText, @url1, @url2, @url3, @url4, @bumperPageHtml, @bumperPageSkip, @customHtml, @homepageTypeId, @isPublished, @lastModifiedByUserId, @lastModifiedDate) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [Homepage] SET [BrandId] = @brandId, [IntroText] = @introText, [Url1] = @url1, [Url2] = @url2, [Url3] = @url3, [Url4] = @url4, [BumperPageHtml] = @bumperPageHtml, [BumperPageSkip] = @bumperPageSkip, [CustomHtml] = @customHtml, [HomepageTypeId] = @homepageTypeId, [IsPublished] = @isPublished, [LastModifiedByUserId] = @lastModifiedByUserId, [LastModifiedDate] = @lastModifiedDate WHERE HomepageId = @homepageId";
}
command.Parameters.Add(CreateParameter("@brandId", homepage.BrandId));
command.Parameters.Add(CreateParameter("@introText", homepage.IntroText));
command.Parameters.Add(CreateParameter("@url1", homepage.Url1));
command.Parameters.Add(CreateParameter("@url2", homepage.Url2));
command.Parameters.Add(CreateParameter("@url3", homepage.Url3));
command.Parameters.Add(CreateParameter("@url4", homepage.Url4));
command.Parameters.Add(CreateParameter("@bumperPageHtml", homepage.BumperPageHtml));
command.Parameters.Add(CreateParameter("@bumperPageSkip", homepage.BumperPageSkip));
command.Parameters.Add(CreateParameter("@customHtml", homepage.CustomHtml));
command.Parameters.Add(CreateParameter("@homepageTypeId", homepage.HomepageTypeId));
command.Parameters.Add(CreateParameter("@isPublished", homepage.IsPublished));
command.Parameters.Add(CreateParameter("@lastModifiedByUserId", homepage.LastModifiedByUserId));
command.Parameters.Add(CreateParameter("@lastModifiedDate", homepage.LastModifiedDate));
if (homepage.IsNew)
{
homepage.HomepageId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@homepageId", homepage.HomepageId));
ExecuteCommand(command);
}
homepage.IsDirty = false;
homepage.ChangedProperties.Clear();
return(homepage);
}
public static Homepage FindOne(HomepageFinder finder)
{
Homepage Homepage = HomepageMapper.Instance.FindOne(finder);
return(Homepage ?? Empty);
}
public static Homepage Update(Homepage homepage)
{
return(HomepageMapper.Instance.Update(homepage));
}
public static Homepage Get(Nullable <Int32> HomepageId)
{
Homepage Homepage = HomepageMapper.Instance.Get(HomepageId);
return(Homepage ?? Empty);
}