/// <summary>
/// Gets an IList with page of instances of LetterHtmlTemplate.
/// </summary>
public static List <LetterHtmlTemplate> GetPage(
Guid siteGuid,
int pageNumber,
int pageSize,
out int totalPages)
{
totalPages = 1;
List <LetterHtmlTemplate> letterHtmlTemplateList = new List <LetterHtmlTemplate>();
using (IDataReader reader = DBLetterHtmlTemplate.GetPage(siteGuid, pageNumber, pageSize, out totalPages))
{
while (reader.Read())
{
LetterHtmlTemplate letterHtmlTemplate = new LetterHtmlTemplate();
letterHtmlTemplate.guid = new Guid(reader["Guid"].ToString());
letterHtmlTemplate.siteGuid = new Guid(reader["SiteGuid"].ToString());
letterHtmlTemplate.title = reader["Title"].ToString();
letterHtmlTemplate.html = reader["Html"].ToString();
letterHtmlTemplate.lastModUTC = Convert.ToDateTime(reader["LastModUTC"]);
letterHtmlTemplateList.Add(letterHtmlTemplate);
}
}
return(letterHtmlTemplateList);
}
/// <summary>
/// Updates this instance of LetterHtmlTemplate. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
this.lastModUTC = DateTime.UtcNow;
return(DBLetterHtmlTemplate.Update(
this.guid,
this.title,
this.html,
this.lastModUTC));
}
/// <summary>
/// Gets an instance of LetterHtmlTemplate.
/// </summary>
/// <param name="guid"> guid </param>
private void GetLetterHtmlTemplate(Guid guid)
{
using (IDataReader reader = DBLetterHtmlTemplate.GetOne(guid))
{
if (reader.Read())
{
this.guid = new Guid(reader["Guid"].ToString());
this.siteGuid = new Guid(reader["SiteGuid"].ToString());
this.title = reader["Title"].ToString();
this.html = reader["Html"].ToString();
this.lastModUTC = Convert.ToDateTime(reader["LastModUTC"]);
}
}
}
/// <summary>
/// Persists a new instance of LetterHtmlTemplate. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
Guid newID = Guid.NewGuid();
this.guid = newID;
int rowsAffected = DBLetterHtmlTemplate.Create(
this.guid,
this.siteGuid,
this.title,
this.html,
this.lastModUTC);
return(rowsAffected > 0);
}
/// <summary>
/// Gets an IList with all instances of LetterHtmlTemplate.
/// </summary>
public static List <LetterHtmlTemplate> GetAll(Guid siteGuid)
{
List <LetterHtmlTemplate> letterHtmlTemplateList
= new List <LetterHtmlTemplate>();
using (IDataReader reader = DBLetterHtmlTemplate.GetAll(siteGuid))
{
while (reader.Read())
{
LetterHtmlTemplate letterHtmlTemplate = new LetterHtmlTemplate();
letterHtmlTemplate.guid = new Guid(reader["Guid"].ToString());
letterHtmlTemplate.siteGuid = new Guid(reader["SiteGuid"].ToString());
letterHtmlTemplate.title = reader["Title"].ToString();
letterHtmlTemplate.html = reader["Html"].ToString();
letterHtmlTemplate.lastModUTC = Convert.ToDateTime(reader["LastModUTC"]);
letterHtmlTemplateList.Add(letterHtmlTemplate);
}
}
return(letterHtmlTemplateList);
}
/// <summary>
/// Deletes an instance of LetterHtmlTemplate. Returns true on success.
/// </summary>
/// <param name="guid"> guid </param>
/// <returns>bool</returns>
public static bool Delete(Guid guid)
{
return(DBLetterHtmlTemplate.Delete(guid));
}
