jongha/clickoncedm

ClickOnceDM is a mass email sending system. This program is written by C# on Microsoft.NET framework. It supports history, HTML preview and multiple SMTP server binding for fast sending. This program also supports retrieving a recipients list on remote databases (MySQL, SQL Server, etc..). Currently only support data source from MySQL and manual text.

ClickOnceDM

ClickOnceDM is a mass email sending system. This program is written by C# on Microsoft.NET framework. It supports history, HTML preview and multiple SMTP server binding for fast sending. This program also supports retrieving a recipients list on remote databases (MySQL, SQL Server, etc..). Currently only support data source from MySQL and manual text.

Requirements

Microsoft Enterprise Library

Microsoft Enterprise Library 5.0 Download

System.Data.SQLite

System.Data.SQLite Download

or Use NuGet Package.

Composition

This project has two sub-projects. These two projects based on Microsoft .NET Framework and written using C#. It is ClickOnceDMAdmin and ClickOnceDMService. ClickOnceDMAdmin is web application that can manage mail sending, log and status. ClickOnceDMService is service application that can install in Windows OS. You can install this service using Installutil.exe. (see more http://msdn.microsoft.com/en-us/library/50614e95(v=vs.110).aspx)

Configuration

App.config in ClickOnceDMService

AppSettings

<appSettings>
  <add key="SMTPServer" value="smtp.server.com:25"/>
  <add key="Workspace" value="C:\Workspace\"/>
  <add key="BlockCount" value="200"/>
  <add key="BlockSleep" value="3000"/>
  <add key="StatisticsDatabase" value="C:\ClickOnceDM\db\Statistics.db" />
</appSettings>

• SMTPServer: SMTP Server and Post list. It can be multiple SMTP Servers separated by semicolon(;).
• Workspace: Workspace is managed directory by this application. It can be contained queue file, success and error logs.
• BlockCount: Sending count per one program loop.
• BlockSleep: Delay time after sending. (Millisecond)

Web.config in ClickOnceDMAdmin

Plugins

<plugins>
  <add name="None" source="Liternal" value="" />
  <add name="Test User" source="Liternal" value="[email protected]" />
  <add name="Total User" source="Member" value="select userName as name, userEmail as address from Member'" />
</plugins>

AppSettings

<appSettings>
  <add key="Workspace" value="C:\Workspace\" />
  <add key="Database" value="C:\ClickOnceDM\db\ClickOnceDM.db" />
  <add key="StatisticsDatabase" value="C:\ClickOnceDM\db\Statistics.db" />
</appSettings>

• Workspace: Workspace is managed directory by this application. It can be contained queue file, success and error logs. It must be same with App.config setting.
• Database: SQLite log database file path.

ConnectionStrings

ConnectionString is related to Plugin section. The source value of Plugin section reference this setting.

<connectionStrings>
  <add name="Member"
       providerName="System.Data.SqlClient"
       connectionString="Data Source=db;Initial Catalog=db;Integrated Security=False;User Id=user;Password=passwd;MultipleActiveResultSets=True" />
  <add name="Liternal"
       providerName="System.String[]"
       connectionString="NODATA" />
</connectionStrings>

License

ClickOnceDM is available under the terms of the MIT License.

clickoncedm's Issues

Zero size ticket file problem.

Application: ClickOnceDMService.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Runtime.Serialization.SerializationException
Stack:
at System.Runtime.Serialization.Json.DataContractJsonSerializer.InternalReadObject(System.Runtime.Serialization.XmlReaderDelegator, Boolean)
at System.Runtime.Serialization.XmlObjectSerializer.InternalReadObject(System.Runtime.Serialization.XmlReaderDelegator, Boolean, System.Runtime.Serialization.DataContractResolver)
at System.Runtime.Serialization.XmlObjectSerializer.ReadObjectHandleExceptions(System.Runtime.Serialization.XmlReaderDelegator, Boolean, System.Runtime.Serialization.DataContractResolver)
at System.Runtime.Serialization.Json.DataContractJsonSerializer.ReadObject(System.Xml.XmlDictionaryReader)
at System.Runtime.Serialization.Json.DataContractJsonSerializer.ReadObject(System.IO.Stream)
at ClickOnceDMLib.Process.TicketProcess.GetTickets()
at ClickOnceDMLib.Process.QueueProcess.BuildQueueFromTicket(ClickOnceDMLib.Process.TicketProcess, Int32)
at ClickOnceDMService.QueueService.Process()
at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()