public ContentMeta Fetch(Guid guid)
{
using (IDataReader reader = DBContentMeta.GetOne(guid))
{
if (reader.Read())
{
ContentMeta contentMeta = new ContentMeta();
contentMeta.Guid = new Guid(reader["Guid"].ToString());
contentMeta.SiteGuid = new Guid(reader["SiteGuid"].ToString());
contentMeta.ModuleGuid = new Guid(reader["ModuleGuid"].ToString());
contentMeta.ContentGuid = new Guid(reader["ContentGuid"].ToString());
contentMeta.Name = reader["Name"].ToString();
contentMeta.Scheme = reader["Scheme"].ToString();
contentMeta.LangCode = reader["LangCode"].ToString();
contentMeta.Dir = reader["Dir"].ToString();
contentMeta.MetaContent = reader["MetaContent"].ToString();
contentMeta.SortRank = Convert.ToInt32(reader["SortRank"]);
contentMeta.CreatedUtc = Convert.ToDateTime(reader["CreatedUtc"]);
contentMeta.CreatedBy = new Guid(reader["CreatedBy"].ToString());
contentMeta.LastModUtc = Convert.ToDateTime(reader["LastModUtc"]);
contentMeta.LastModBy = new Guid(reader["LastModBy"].ToString());
return(contentMeta);
}
}
return(null);
}
/// <summary>
/// Persists a ContentMeta
/// </summary>
/// <returns></returns>
public void Save(ContentMeta contentMeta)
{
if (contentMeta == null)
{
return;
}
if (contentMeta.Guid == Guid.Empty)
{
contentMeta.Guid = Guid.NewGuid();
DBContentMeta.Create(
contentMeta.Guid,
contentMeta.SiteGuid,
contentMeta.ModuleGuid,
contentMeta.ContentGuid,
contentMeta.Name,
contentMeta.NameProperty,
contentMeta.Scheme,
contentMeta.LangCode,
contentMeta.Dir,
contentMeta.MetaContent,
contentMeta.ContentProperty,
contentMeta.SortRank,
contentMeta.CreatedUtc,
contentMeta.CreatedBy
);
}
else
{
DBContentMeta.Update(
contentMeta.Guid,
contentMeta.Name,
contentMeta.NameProperty,
contentMeta.Scheme,
contentMeta.LangCode,
contentMeta.Dir,
contentMeta.MetaContent,
contentMeta.ContentProperty,
contentMeta.SortRank,
contentMeta.LastModUtc,
contentMeta.LastModBy
);
}
}
/// <summary>
/// gets the next sort rank
/// </summary>
/// <param name="contentGuid"></param>
/// <returns>int</returns>
public int GetNextSortRank(Guid contentGuid)
{
int nextSort = DBContentMeta.GetMaxSortRank(contentGuid) + 2;
return(nextSort);
}
/// <summary>
/// Deletes ContentMeta. Returns true on success.
/// </summary>
/// <param name="contentGuid"> contentGuid </param>
/// <returns>bool</returns>
public bool DeleteByContent(Guid contentGuid)
{
DBContentMetaLink.DeleteByContent(contentGuid);
return(DBContentMeta.DeleteByContent(contentGuid));
}
/// <summary>
/// Deletes ContentMeta. Returns true on success.
/// </summary>
/// <param name="moduleGuid"> moduleGuid </param>
/// <returns>bool</returns>
public bool DeleteByModule(Guid moduleGuid)
{
DBContentMetaLink.DeleteByModule(moduleGuid);
return(DBContentMeta.DeleteByModule(moduleGuid));
}
/// <summary>
/// Deletes ContentMeta. Returns true on success.
/// </summary>
public bool DeleteBySite(Guid siteGuid)
{
DBContentMetaLink.DeleteBySite(siteGuid);
return(DBContentMeta.DeleteBySite(siteGuid));
}
/// <summary>
/// Deletes an instance of ContentMeta. Returns true on success.
/// </summary>
/// <param name="guid"> guid </param>
/// <returns>bool</returns>
public bool Delete(Guid guid)
{
return(DBContentMeta.Delete(guid));
}
public List <ContentMeta> FetchByContent(Guid contentGuid)
{
IDataReader reader = DBContentMeta.GetByContent(contentGuid);
return(LoadListFromReader(reader));
}
