/// <summary>
/// Create a new recipientlist.
/// </summary>
/// <param name="listType">Enum, list type</param>
/// <param name="name">List name</param>
/// <param name="description">List description</param>
/// <returns></returns>
public int RecipientListCreate(RecipientListType listType, string name, string description)
{
int recipientId = 0;
Executor.Execute(() =>
{
DbCommand cmd = base.CreateCommand("NewsletterRecipientListCreate");
cmd.Parameters.Add(base.CreateParameter("listType", listType));
cmd.Parameters.Add(base.CreateParameter("name", name));
cmd.Parameters.Add(base.CreateParameter("description", description));
object objId = cmd.ExecuteScalar();
if (objId == null)
{
throw new ApplicationException(
"Unable to create recipient list. No Id returned.");
}
if (int.TryParse(objId.ToString(), out recipientId) == false)
{
throw new ApplicationException(
"Unable to create recipient list. Unexpected return value: " +
objId.ToString());
}
});
return(recipientId);
}
/// <summary>
/// Create a new recipientlist.
/// </summary>
/// <param name="listType">Enum, list type</param>
/// <param name="name">List name</param>
/// <param name="description">List description</param>
/// <returns></returns>
public int RecipientListCreate(RecipientListType listType, string name, string description)
{
int recipientId = 0;
Database.Execute(() =>
{
DbCommand cmd = base.CreateCommand("NewsletterRecipientListCreate");
cmd.Parameters.Add(base.CreateParameter("listType", listType));
cmd.Parameters.Add(base.CreateParameter("name", name));
cmd.Parameters.Add(base.CreateParameter("description", description));
object objId = cmd.ExecuteScalar();
if (objId == null)
{
throw new ApplicationException(
"Unable to create recipient list. No Id returned.");
}
if (int.TryParse(objId.ToString(), out recipientId) == false)
{
throw new ApplicationException(
"Unable to create recipient list. Unexpected return value: " +
objId.ToString());
}
});
return recipientId;
}
/// <summary>
/// Initializes a new instance of the <see cref="RecipientList"/> class.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="listType">Type of the list.</param>
/// <param name="created">The created.</param>
/// <param name="name">The name.</param>
/// <param name="description">The description.</param>
internal RecipientList(int id, RecipientListType listType, DateTime created, string name, string description)
{
_id = id;
_type = listType;
_created = created;
_name = name;
_description = description;
}
/// <summary>
/// Initializes a new instance of the <see cref="RecipientList"/> class.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="listType">Type of the list.</param>
/// <param name="created">The created.</param>
/// <param name="name">The name.</param>
/// <param name="description">The description.</param>
internal RecipientList(int id, RecipientListType listType, DateTime created, string name, string description)
{
_id = id;
_type = listType;
_created = created;
_name = name;
_description = description;
}
/// <summary>
/// Initializes a new instance of the <see cref="RecipientList"/> class.
/// </summary>
/// <param name="dataRow">The data row.</param>
internal RecipientList(DataRow dataRow)
{
_id = (int)dataRow["pkRecipientListId"];
_name = dataRow["Name"] != null ? dataRow["Name"].ToString() : null;
_description = dataRow["Description"] != null ? dataRow["Description"].ToString() : null;
_created = dataRow["Created"] != null ? (DateTime)dataRow["Created"] : DateTime.MinValue;
_type = dataRow["ListType"] != null ? (RecipientListType)dataRow["ListType"] : RecipientListType.PrivateList;
_emailAddressCount = (dataRow["Count"] != null && dataRow["Count"] != DBNull.Value) ? (int)dataRow["Count"] : -1;
}
/// <summary>
/// Initializes a new instance of the <see cref="RecipientList"/> class.
/// </summary>
/// <param name="listType">Type of the list.</param>
/// <param name="name">The name.</param>
/// <param name="description">The description.</param>
public RecipientList(RecipientListType listType, string name, string description)
{
_type = listType;
_name = name;
if (string.IsNullOrEmpty(description))
_description = null;
else
_description = description;
}
/// <summary>
/// Initializes a new instance of the <see cref="RecipientList"/> class.
/// </summary>
/// <param name="dataRow">The data row.</param>
internal RecipientList(DataRow dataRow)
{
_id = (int)dataRow["pkRecipientListId"];
_name = dataRow["Name"] != null ? dataRow["Name"].ToString() : null;
_description = dataRow["Description"] != null ? dataRow["Description"].ToString() : null;
_created = dataRow["Created"] != null ? (DateTime)dataRow["Created"] : DateTime.MinValue;
_type = dataRow["ListType"] != null ? (RecipientListType)dataRow["ListType"] : RecipientListType.PrivateList;
_emailAddressCount = (dataRow["Count"] != null && dataRow["Count"] != DBNull.Value) ? (int)dataRow["Count"] : -1;
}
/// <summary>
/// Edit the recipient list
/// </summary>
/// <param name="recipientListId">The recipient list id.</param>
/// <param name="listType">Enum, list type.</param>
/// <param name="name">Name of recipient list.</param>
/// <param name="description"></param>
public void RecipientListEdit(int recipientListId, RecipientListType listType, string name, string description)
{
Executor.Execute(() =>
{
DbCommand cmd = base.CreateCommand("NewsletterRecipientListEdit");
cmd.Parameters.Add(base.CreateParameter("recipientlistid", recipientListId));
cmd.Parameters.Add(base.CreateParameter("listType", listType));
cmd.Parameters.Add(base.CreateParameter("name", name));
cmd.Parameters.Add(base.CreateParameter("description", description));
cmd.ExecuteNonQuery();
});
}
/// <summary>
/// Initializes a new instance of the <see cref="RecipientList"/> class.
/// </summary>
/// <param name="listType">Type of the list.</param>
/// <param name="name">The name.</param>
/// <param name="description">The description.</param>
public RecipientList(RecipientListType listType, string name, string description)
{
_type = listType;
_name = name;
if (string.IsNullOrEmpty(description))
{
_description = null;
}
else
{
_description = description;
}
}
public string GetRecipientListTypeString(RecipientListType listType)
{
return(NewsLetterUtil.GetEnumLanguageName(listType));
}
/// <summary>
/// Edit the recipient list
/// </summary>
/// <param name="recipientListId">The recipient list id.</param>
/// <param name="listType">Enum, list type.</param>
/// <param name="name">Name of recipient list.</param>
/// <param name="description"></param>
public void RecipientListEdit(int recipientListId, RecipientListType listType, string name, string description)
{
Database.Execute(() =>
{
DbCommand cmd = base.CreateCommand("NewsletterRecipientListEdit");
cmd.Parameters.Add(base.CreateParameter("recipientlistid", recipientListId));
cmd.Parameters.Add(base.CreateParameter("listType", listType));
cmd.Parameters.Add(base.CreateParameter("name", name));
cmd.Parameters.Add(base.CreateParameter("description", description));
cmd.ExecuteNonQuery();
});
}
public string GetRecipientListTypeString(RecipientListType listType)
{
return NewsLetterUtil.GetEnumLanguageName(listType);
}
