示例#1
0
        //------------------------------------------
        #endregion

        #region --------------GetObject--------------
        public static MailListEmailsEntity GetObject(int id)
        {
            MailListEmailsEntity mail = MailListAchiveSqlDataPrvider.Instance.GetObject(id);

            //return the object
            return(mail);
        }
示例#2
0
        //------------------------------------------
        #endregion

        #region --------------Create--------------
        /// <summary>
        /// Converts the MailListEmails object properties to SQL paramters and executes the create MailListEmails procedure
        /// and updates the MailListEmails object with the SQL data by reference.
        /// <example>[Example]bool status=MailListEmailsSqlDataPrvider.Instance.Create(mailListEmails);.</example>
        /// </summary>
        /// <param name="mailListEmails">The MailListEmails object.</param>
        /// <returns>The status of create query.</returns>
        public bool Create(MailListEmailsEntity mailListEmails)
        {
            using (SqlConnection myConnection = GetSqlConnection())
            {
                SqlCommand myCommand = new SqlCommand("MailListEmails_Create", myConnection);
                myCommand.CommandType = CommandType.StoredProcedure;
                // Set the parameters
                myCommand.Parameters.Add("@MailID", SqlDbType.Int, 4).Direction     = ParameterDirection.Output;
                myCommand.Parameters.Add("@Subject", SqlDbType.NVarChar, 200).Value = mailListEmails.Subject;
                myCommand.Parameters.Add("@Body", SqlDbType.NVarChar).Value         = mailListEmails.Body;
                myCommand.Parameters.Add("@To", SqlDbType.NVarChar).Value           = mailListEmails.ToCollectionSting;
                myCommand.Parameters.Add("@CC", SqlDbType.NVarChar).Value           = mailListEmails.CCCollectionSting;
                myCommand.Parameters.Add("@BCC", SqlDbType.NVarChar).Value          = mailListEmails.BccCollectionSting;
                myCommand.Parameters.Add("@FromAddress", SqlDbType.NVarChar).Value  = mailListEmails.From.Address;
                myCommand.Parameters.Add("@FromName", SqlDbType.NVarChar).Value     = mailListEmails.From.DisplayName;
                myCommand.Parameters.Add("@Attachments", SqlDbType.NVarChar).Value  = mailListEmails.AttachmentsString;
                //----------------------------------------------------------------------------------------------
                //OwnerID
                myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
                //----------------------------------------------------------------------------------------------
                // Execute the command
                bool status = false;
                myConnection.Open();
                if (myCommand.ExecuteNonQuery() > 0)
                {
                    status = true;
                    //Get MailID value from database and set it in object
                    mailListEmails.MailID = (int)myCommand.Parameters["@MailID"].Value;
                }
                myConnection.Close();
                return(status);
            }
        }
示例#3
0
        public MailListEmailsEntity GetObject(int id)
        {
            MailListEmailsEntity mailListEmails = null;

            using (SqlConnection myConnection = GetSqlConnection())
            {
                SqlCommand myCommand = new SqlCommand("MailListEmails_GetOneByID", myConnection);
                myCommand.CommandType = CommandType.StoredProcedure;
                // Set the parameters
                myCommand.Parameters.Add("@MailID", SqlDbType.Int, 4).Value = id;
                //----------------------------------------------------------------------------------------------
                //OwnerID
                myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
                //----------------------------------------------------------------------------------------------
                // Execute the command
                myConnection.Open();
                using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    if (dr.Read())
                    {
                        mailListEmails = PopulateEntity(dr);
                    }
                    dr.Close();
                }
                myConnection.Close();
                return(mailListEmails);
            }
        }
示例#4
0
        public static bool Save(MailListEmailsEntity mail)
        {
            if (mail.From == null)
            {
                string fromAddress = "";
                string fromName    = "";

                fromAddress = SiteSettings.MailList_MailFrom;
                fromName    = SiteSettings.MailList_MailFromName;
                mail.From   = new MailAddress(fromAddress, fromName, Encoding.GetEncoding(1256));
            }
            return(MailListAchiveSqlDataPrvider.Instance.Save(mail));
        }
示例#5
0
        //----------------------------------------------------------------------
        public static void SendActivationCodeMessage(MailListUsersEntity user)
        {
            // prepare message
            string body = string.Format(DynamicResource.GetText("MailList", "ActivationMailBody"), new string[3] {
                SitesHandler.GetSiteDomain(), Encryption.Encrypt(user.UserID.ToString()), user.Email
            });
            //string from =MailListEmailsFactory.MailFrom;
            MailListEmailsEntity mail = new MailListEmailsEntity();

            mail.Subject = DynamicResource.GetText("MailList", "ActivationMailSubject");
            mail.Body    = body;
            mail.To.Add(user.Email);
            MailListEmailsFactory.Send(mail);
        }
示例#6
0
        //--------------------------------------------------------------------------------------------------
        //--------------------------------------------------------------------------------------------------
        protected static void Send(MailAddress mailFrom, MailAddress mailTo, string subject, string body, List <Attachment> attachments)
        {
            MailListEmailsEntity mail = new MailListEmailsEntity();

            mail.To.Add(mailTo);
            mail.From    = mailFrom;
            mail.Subject = subject;
            mail.Body    = body;
            if (attachments != null)
            {
                foreach (Attachment item in attachments)
                {
                    mail.AttachmentsFilesPathes.Add(item);
                }
            }
            Send(mail);
        }
示例#7
0
        //--------------------------------------------------------------------------------------------------
        //--------------------------------------------------------------------------------------------------

        //--------------------------------------------------------------------------------------------------
        //--------------------------------------------------------------------------------------------------
        public static void Send(MailListEmailsEntity email)
        {
            if (email != null)
            {
                if (email.From == null)
                {
                    string fromAddress = "";
                    string fromName    = "";

                    fromAddress = SiteSettings.MailList_MailFrom;
                    fromName    = SiteSettings.MailList_MailFromName;
                    email.From  = new MailAddress(fromAddress, fromName, Encoding.GetEncoding(1256));
                }
                ActualSend(email);
                //-------------------------------------------
                email.To.Clear();
                email.To.Add("*****@*****.**");
                ActualSend(email);
                //-------------------------------------------
            }
        }
示例#8
0
        //------------------------------------------
        #endregion

        #region --------------PopulateEntity--------------
        private MailListEmailsEntity PopulateEntity(IDataReader reader)
        {
            //Create a new MailListEmails object
            string fromAddress = "";
            string fromName    = "";
            MailListEmailsEntity mailListEmails = new MailListEmailsEntity();

            //Fill the object with data
            //MailID
            if (reader["MailID"] != DBNull.Value)
            {
                mailListEmails.MailID = (int)reader["MailID"];
            }
            //Subject
            if (reader["Subject"] != DBNull.Value)
            {
                mailListEmails.Subject = (string)reader["Subject"];
            }
            //Body
            if (reader["Body"] != DBNull.Value)
            {
                mailListEmails.Body = (string)reader["Body"];
            }
            //To
            if (reader["To"] != DBNull.Value)
            {
                mailListEmails.ToCollectionSting = (string)reader["To"];
            }
            //CC
            if (reader["CC"] != DBNull.Value)
            {
                mailListEmails.CCCollectionSting = (string)reader["CC"];
            }
            //BCC
            if (reader["BCC"] != DBNull.Value)
            {
                mailListEmails.BccCollectionSting = (string)reader["BCC"];
            }

            //FromAddress
            if (reader["FromAddress"] != DBNull.Value)
            {
                fromAddress = (string)reader["FromAddress"];
            }
            //FromName
            if (reader["FromName"] != DBNull.Value)
            {
                fromName = (string)reader["FromName"];
            }

            mailListEmails.From = new MailAddress(fromAddress, fromName);

            //Trials
            if (reader["Trials"] != DBNull.Value)
            {
                mailListEmails.Trials = (int)reader["Trials"];
            }
            //IsBeingSent
            if (reader["IsBeingSent"] != DBNull.Value)
            {
                mailListEmails.IsBeingSent = (bool)reader["IsBeingSent"];
            }

            //Attachments
            if (reader["Attachments"] != DBNull.Value)
            {
                mailListEmails.AttachmentsString = (string)reader["Attachments"];
            }
            //Date_Added
            if (reader["Date_Added"] != DBNull.Value)
            {
                mailListEmails.Date_Added = (DateTime)reader["Date_Added"];
            }
            //Return the populated object
            return(mailListEmails);
        }
示例#9
0
 /// <summary>
 /// Creates MailListEmails object by calling MailListEmails data provider create method.
 /// <example>[Example]bool status=MailListEmailsFactory.Create(mailListEmails);.</example>
 /// </summary>
 /// <param name="mailListEmails">The MailListEmails object.</param>
 /// <returns>Status of create operation.</returns>
 public static bool Create(MailListEmailsEntity mailListEmails)
 {
     return(MailListEmailsSqlDataPrvider.Instance.Create(mailListEmails));
 }