public DataSet XmlColumnDefSynonym(String AgainstType, String connString, String FilePath)
{
Pop3DataClient data = new Pop3DataClient();
return(data.GetXmlFileFields(AgainstType, connString, FilePath));
}
/// <summary>
/// Return last mail's content stored in the database
/// </summary>
/// <param name="MailServerName">EMail server name</param>
/// <param name="PortNo">EMail port no</param>
/// <param name="isSslEnabled">Is SSL enabled</param>
/// <param name="loginName">EMail Id for which you want ot get the data</param>
/// <param name="Password">EMail password</param>
/// <returns>Currently return last mail's data</returns>
public DataTable mailcontents(string MailServerName, int PortNo, bool isSslEnabled, string loginName, string Password)
{
Dictionary <int, Message> messages = new Dictionary <int, Message>();
DataTable datatable = new DataTable();
//// This is how you would override the default logger type
//// Here we want to log to a file
DefaultLogger.SetLog(new FileLogger());
FileLogger.LogPath = HttpContext.Current.Server.MapPath("~/Attachments/");
// Enable file logging and include verbose information
FileLogger.Enabled = true;
FileLogger.Verbose = true;
try
{
pop3Client = new Pop3Client();
data = new Pop3DataClient();
if (pop3Client.Connected)
{
pop3Client.Disconnect();
}
pop3Client.Connect(MailServerName, PortNo, isSslEnabled);
pop3Client.Authenticate(loginName, Password);
//DateTime? lastmsgSavedDate = data.GetLastSavedDate(ConnString, loginName);
//messages = pop3Client.GetAllMessages(lastmsgSavedDate); //Used to get all messages from the given EMail Id
//foreach (Message message in messages.Values)
//{
int msgcount = pop3Client.GetMessageCount();
Message message = pop3Client.GetMessage(msgcount);
data.SaveMessageToDatabase(ConnString, message, FileLogger.LogPath);
//}
//Currently return last inserted data
datatable = data.GetMessageFromDatabase(ConnString).Tables[0];
return(datatable);
}
catch (InvalidLoginException)
{
DefaultLogger.Log.LogError("POP3 Server Authentication: The server did not accept the user credentials!");
return(datatable);
}
catch (PopServerNotFoundException)
{
DefaultLogger.Log.LogError("POP3 Retrieval: The server could not be found");
return(datatable);
}
catch (PopServerLockedException)
{
DefaultLogger.Log.LogError("POP3 Account Locked: The mailbox is locked. It might be in use or under maintenance. Are you connected elsewhere?");
return(datatable);
}
catch (LoginDelayException)
{
DefaultLogger.Log.LogError("POP3 Account Login Delay: Login not allowed. Server enforces delay between logins. Have you connected recently?");
return(datatable);
}
catch (Exception ex)
{
DefaultLogger.Log.LogError("Failed Code due to: " + ex.Message + "\r\n" + "Stack trace:\r\n" + ex.StackTrace);
return(datatable);
}
}
