/// <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="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> /// 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); }