//select *,(select COUNT(IsMailSent) from dbo.EC_CampaignQueue where FK_CampaignID =65 and IsMailSent = 1) as MailSent,(select count(isBounced) from dbo.EC_CampaignQueue where FK_CampaignID =65 and isBounced = 1) as softbounce, (select count(IsHardBounce) from dbo.EC_CampaignQueue where FK_CampaignID =65 and IsHardBounce = 1) as hardbounce, (select COUNT(IsRead) from dbo.EC_CampaignQueue where FK_CampaignID =65 and IsRead = 1) as IsRead, (select COUNT(ReadCount) from dbo.EC_CampaignQueue where FK_CampaignID =65 and ReadCount = 1) as ReadCount, (select sum(ReadCount) from dbo.EC_CampaignQueue where FK_CampaignID =65) as TotalReadCount,(select COUNT(PK_CampaignQueueID) from dbo.EC_CampaignQueue where FK_CampaignID =65) as Recipients from dbo.EC_Campaign where CampaignStatus = 1 and PK_CampaignID = 65
private void Chilkitmail()
{
Chilkat.MailMan mailman = new Chilkat.MailMan();
mailman.UnlockComponent("MailUnlockCode");
mailman.MailHost = "pop.gmail.com";
mailman.MailPort = 995;
mailman.PopUsername = System.Configuration.ConfigurationSettings.AppSettings["AryvartAdminEmailID"].ToString();
mailman.PopPassword = System.Configuration.ConfigurationSettings.AppSettings["AryvartAdminEmailPassword"].ToString();
mailman.ConnectTimeout = 200000;
mailman.ReadTimeout = 200000;
Chilkat.Bounce bounce = new Chilkat.Bounce();
bool success = bounce.UnlockComponent("MailUnlockCode");
if (!success)
{
//TextBox1.Text = bounce.LastErrorText;
return;
}
Chilkat.EmailBundle bundle;
//object bndlmail;
bundle = mailman.CopyMail();
//int numBodyLines = 1;
//bundle = mailman.GetAllHeaders(numBodyLines);
if (bundle != null)
{
// Loop over each email...
Chilkat.Email email;
int i;
bool success1;
for (i = 0; i < bundle.MessageCount; i++)
{
email = bundle.GetEmail(i);
string gmailuid = email.Uidl;
string content = "";
success1 = bounce.ExamineEmail(email);
string bouncecolumn = "";
//if (!success1)
// listBox1.Items.Add("Failed to classify email");
if (bounce.BounceType == 1)
{
// Hard bounce, log the email address
content = pop3recievecontent(gmailuid);
bouncecolumn = "IsHardBounce";
}
else if (bounce.BounceType == 2)
{
// Soft bounce, log the email address
content = pop3recievecontent(gmailuid);
bouncecolumn = "isBounced";
}
else if (bounce.BounceType == 3)
{
// General bounce, no email address available.
content = pop3recievecontent(gmailuid);
bouncecolumn = "isBounced";
}
email = null;
if (content != "")
{
if (content.Contains("Disposition-Notification-To: <"))
{
string ll = "Disposition-Notification-To: <";
int posA = content.IndexOf("Disposition-Notification-To: <");
int posB = content.LastIndexOf(">");
int adjustedPosA = posA + ll.Length;
string uu = content.Substring(adjustedPosA, posB - adjustedPosA);
string isexist = objBL_Common.IsValidUser("MailFailedContent", "EC_CampaignQueue", "PK_CampaignQueueID =" + Convert.ToInt32(uu) + "");
SqlParameter param = new SqlParameter();
param.ParameterName = "@UserName";
param.Value = content;
if (isexist == "")
objBL_Common.AccessUpdatecampue("EC_CampaignQueue", "" + bouncecolumn + "= 'true', MailFailedContent = @UserName ", "PK_CampaignQueueID =" + Convert.ToInt32(uu) + "" ,content);
}
}
}
bundle = null;
}
mailman = null;
}
//select *,(select COUNT(IsMailSent) from dbo.EC_CampaignQueue where FK_CampaignID =65 and IsMailSent = 1) as MailSent,(select count(isBounced) from dbo.EC_CampaignQueue where FK_CampaignID =65 and isBounced = 1) as softbounce, (select count(IsHardBounce) from dbo.EC_CampaignQueue where FK_CampaignID =65 and IsHardBounce = 1) as hardbounce, (select COUNT(IsRead) from dbo.EC_CampaignQueue where FK_CampaignID =65 and IsRead = 1) as IsRead, (select COUNT(ReadCount) from dbo.EC_CampaignQueue where FK_CampaignID =65 and ReadCount = 1) as ReadCount, (select sum(ReadCount) from dbo.EC_CampaignQueue where FK_CampaignID =65) as TotalReadCount,(select COUNT(PK_CampaignQueueID) from dbo.EC_CampaignQueue where FK_CampaignID =65) as Recipients from dbo.EC_Campaign where CampaignStatus = 1 and PK_CampaignID = 65
private void Chilkitmail()
{
Chilkat.MailMan mailman = new Chilkat.MailMan();
mailman.UnlockComponent("MailUnlockCode");
mailman.MailHost = "pop.gmail.com";
mailman.MailPort = 995;
mailman.PopUsername = System.Configuration.ConfigurationSettings.AppSettings["AryvartAdminEmailID"].ToString();
mailman.PopPassword = System.Configuration.ConfigurationSettings.AppSettings["AryvartAdminEmailPassword"].ToString();
mailman.ConnectTimeout = 200000;
mailman.ReadTimeout = 200000;
Chilkat.Bounce bounce = new Chilkat.Bounce();
bool success = bounce.UnlockComponent("MailUnlockCode");
if (!success)
{
//TextBox1.Text = bounce.LastErrorText;
return;
}
Chilkat.EmailBundle bundle;
//object bndlmail;
bundle = mailman.CopyMail();
//int numBodyLines = 1;
//bundle = mailman.GetAllHeaders(numBodyLines);
if (bundle != null)
{
// Loop over each email...
Chilkat.Email email;
int i;
bool success1;
for (i = 0; i < bundle.MessageCount; i++)
{
email = bundle.GetEmail(i);
string gmailuid = email.Uidl;
string content = "";
success1 = bounce.ExamineEmail(email);
string bouncecolumn = "";
//if (!success1)
// listBox1.Items.Add("Failed to classify email");
if (bounce.BounceType == 1)
{
// Hard bounce, log the email address
content = pop3recievecontent(gmailuid);
bouncecolumn = "IsHardBounce";
}
else if (bounce.BounceType == 2)
{
// Soft bounce, log the email address
content = pop3recievecontent(gmailuid);
bouncecolumn = "isBounced";
}
else if (bounce.BounceType == 3)
{
// General bounce, no email address available.
content = pop3recievecontent(gmailuid);
bouncecolumn = "isBounced";
}
email = null;
if (content != "")
{
if (content.Contains("Disposition-Notification-To: <"))
{
string ll = "Disposition-Notification-To: <";
int posA = content.IndexOf("Disposition-Notification-To: <");
int posB = content.LastIndexOf(">");
int adjustedPosA = posA + ll.Length;
string uu = content.Substring(adjustedPosA, posB - adjustedPosA);
string isexist = objBL_Common.IsValidUser("MailFailedContent", "EC_CampaignQueue", "PK_CampaignQueueID =" + Convert.ToInt32(uu) + "");
SqlParameter param = new SqlParameter();
param.ParameterName = "@UserName";
param.Value = content;
if (isexist == "")
{
objBL_Common.AccessUpdatecampue("EC_CampaignQueue", "" + bouncecolumn + "= 'true', MailFailedContent = @UserName ", "PK_CampaignQueueID =" + Convert.ToInt32(uu) + "", content);
}
}
}
}
bundle = null;
}
mailman = null;
}
