//Ganesh on 30nov09
//This method will insert a new job in CampaignJob table.
public void insertCampainJob(CampaignMaster objCampaignMaster, string ScheduledTime, string sendType, Int64 campaignMasterID)
{
CampaignJob objCampaignJob = new CampaignJob(ConnectionString);
objCampaignJob.CampaignMasterID = campaignMasterID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = Convert.ToDateTime(ScheduledTime);
objCampaignJob.SendType = sendType;
objCampaignJob.Status = 1;
objCampaignJob.Insert();
}
public XmlDocument AddCampaign(string UserID, string Password, string CampName, string FromAdd, string FromName, string ReplyEmailAdd, string Subject, int TempId, string ListIds, DateTime LaunchDateTime)
{
XmlDocument doc = new System.Xml.XmlDocument();
StringBuilder str = new StringBuilder();
str.Append("<CampaignInfo>");
string ConnectionString = GetConnectionString(UserID, Password);
if (ConnectionString.Trim().Length != 0 && CampName.Trim().Length != 0 && FromAdd.Trim().Length != 0 && FromName.Trim().Length != 0 && Subject.Trim().Length != 0 && ReplyEmailAdd.Trim().Length != 0 && TempId != 0 && ListIds.Trim().Length != 0 && LaunchDateTime != null)//(Convert.ToDateTime(LaunchDateTime) > DateTime.Now))
{
//ListMasters list = ListMaster.SelectByField("ListName", ListName, ConnectionString);
CampaignMasters camp = CampaignMaster.SelectByField("CampaignName", CampName, ConnectionString);
if (camp.Count > 0)
{
str.Append("<Message>Campaign Name AllRedy Existed</Message>");
}
else
{
TemplateMasterPrimaryKey pk = new TemplateMasterPrimaryKey(TempId);
TemplateMaster tempMaster = TemplateMaster.SelectOne(pk, ConnectionString);
if (tempMaster != null)
{
CampaignMaster objCampaignMaster = new CampaignMaster(ConnectionString);
objCampaignMaster.CampaignName = CampName;
objCampaignMaster.CampaignDescription = "";
objCampaignMaster.FromAddress = FromAdd;
objCampaignMaster.FromName = FromName;
objCampaignMaster.ReplytoAddress = ReplyEmailAdd;
objCampaignMaster.ReplaytoName = "";
objCampaignMaster.Subject = Subject;
objCampaignMaster.TrackReads = true;//"1";
objCampaignMaster.SelectCondition = ListIds;
objCampaignMaster.TemplateId = TempId;
objCampaignMaster.ModifiedDate = DateTime.Now;
objCampaignMaster.CreatedDate = DateTime.Now;
objCampaignMaster.HTMLContent = tempMaster.HTMLContent;
objCampaignMaster.TextContent = "";
objCampaignMaster.SuppressDomain = "";
Int64 campaignMasterID = objCampaignMaster.insertCampainMaster(objCampaignMaster);
if (campaignMasterID > 0)
{
CampaignJob objCampaignJob = new CampaignJob(ConnectionString);
objCampaignJob.CampaignMasterID = campaignMasterID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = LaunchDateTime.AddMinutes(2);// DateTime.Now.AddMinutes(2);//Convert.ToDateTime(LaunchDateTime);
objCampaignJob.SendType = "IMMEDIATE";
objCampaignJob.Status = 1;
objCampaignJob.Insert();
}
str.Append("<Message>Campaign Inserted Succefully</Message>");
}
else
{
str.Append("<Message>Enter Valid TemplateId</Message>");
}
}
}
else
{
str.Append("<Message>Enter Valid Inputs</Message>");
}
str.Append("</CampaignInfo>");
doc.LoadXml(str.ToString());
return doc;
}
public string ScheduleMailingWithSuppressList(string Con, string CampaignName, string Subject, string FromName, string ReplyToAddress, string FromAddress, string TemplateName, string ListID, string SupListId, string SeedId, string scheduleTime, string sendType)
{
TemplateMaster tempMaster = null;
try
{
long listid = 0;
TemplateMasters obj = TemplateMaster.SelectByField("TemplateName", TemplateName, Con);
if (obj.Count > 0)
{
TemplateMasterPrimaryKey template = new TemplateMasterPrimaryKey(Convert.ToInt64(obj[0].TemplateId.ToString()));
tempMaster = TemplateMaster.SelectOne(template, Con);
CampaignMaster objCampaignMaster = new CampaignMaster(Con);
objCampaignMaster.CampaignName = CampaignName;
objCampaignMaster.CampaignDescription = "";
objCampaignMaster.FromAddress = FromAddress;
objCampaignMaster.FromName = FromName;
objCampaignMaster.ReplytoAddress = ReplyToAddress;
objCampaignMaster.ReplaytoName = FromName;
objCampaignMaster.Subject = Subject;
objCampaignMaster.TrackReads = true;//"1";
objCampaignMaster.SelectCondition = ListID;
objCampaignMaster.TemplateId = tempMaster.TemplateId;
objCampaignMaster.ModifiedDate = DateTime.Now;
objCampaignMaster.CreatedDate = DateTime.Now;
objCampaignMaster.HTMLContent = tempMaster.HTMLContent;
objCampaignMaster.TextContent = "";
objCampaignMaster.SuppressDomain = "";
objCampaignMaster.UnsubscribeText = "If you no longer wish to receive these emails, simply click on the following link:";
objCampaignMaster.UnsubscribeLinkText = "Unsubscribe";
objCampaignMaster.AssignedCampaignID = 0;
objCampaignMaster.SuppressSelection = SupListId.ToString();
objCampaignMaster.htmlHasUnsubLink = true;
objCampaignMaster.txtHasUnsubLink = false;
Int64 campaignMasterID = objCampaignMaster.insertMailing(objCampaignMaster);
if (campaignMasterID > 0)
{
CampaignJob objCampaignJob = new CampaignJob(Con);
objCampaignJob.CampaignMasterID = campaignMasterID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = Convert.ToDateTime(scheduleTime);// DateTime.Now.AddMinutes(2);//Convert.ToDateTime(LaunchDateTime);
Logger.logdata(logforRpService, "Mailing Schedule Date Time :" + scheduleTime + "");
objCampaignJob.SendType = sendType;
objCampaignJob.Status = 5;
objCampaignJob.Insert();
}
Logger.logdata(logforRpService, "Mailing Inserted Succefully");
return (campaignMasterID.ToString());
}
else
{
return ("False");
}
}
catch (Exception ex)
{
Logger.logdata(logforRpService, ex.Message);
return ("False");
}
}
//[WebMethod(EnableSession = true)]
//public XmlDocument SendCampaign(string UserID, string Password, string CampaignName, string Subject, string FromName, string ReplyToAddress, string FromAddress, string TemplateName, DataSet ds)
//{
// StringBuilder str = new StringBuilder();
// try
// {
// string Con = GetConnectionString(UserID, Password);
// #region Contacts
// str.Append("<CampaignDetails>");
// LogStartInfo("AddRecipient", Con, UserID);
// DataTable contacts = ds.Tables[0];
// string ContactIds = "";
// if (Con.Trim().Length != 0)
// {
// if (contacts.Rows.Count > 0 && !(contacts.Columns.IndexOf("EmailAddress") == -1))
// {
// Logger.logdata(logforRpService, "SendCampaign() at Contacts region");
// foreach (DataRow contact in contacts.Rows)
// {
// ContactMasters contemail = ContactMaster.SelectByField("EmailAddress", contact["EmailAddress"].ToString(), Con);
// if (contemail.Count > 0)
// {
// try
// {
// ContactIds = ContactIds + contemail[0].ContactId.ToString() + ",";
// ContactMasterPrimaryKey pk = new ContactMasterPrimaryKey(Convert.ToInt64(contemail[0].ContactId.ToString()));
// ContactMaster objContactMaster = ContactMaster.SelectOne(pk, Con);
// objContactMaster.FirstName = contact["FirstName"].ToString();
// objContactMaster.LastName = contact["LastName"].ToString();
// #region Handling Custom fields
// foreach (DataColumn column in contacts.Columns)
// {
// DataTable customFieldDt = ManageFieldsBase.SelectByField("FieldName", column.ColumnName, Con);
// string custField = "";
// if (customFieldDt.Rows.Count > 0)
// {
// custField = customFieldDt.Rows[0]["ContactFieldName"].ToString();
// }
// if (custField != "" && customFieldDt.Rows.Count > 0 && contact[column.ColumnName] != "")
// {
// switch (custField)
// {
// case "CustomField1":
// objContactMaster.CustomField1 = contact[column.ColumnName].ToString();
// break;
// case "CustomField2":
// objContactMaster.CustomField2 = contact[column.ColumnName].ToString();
// break;
// case "CustomField3":
// objContactMaster.CustomField3 = contact[column.ColumnName].ToString();
// break;
// case "CustomField4":
// objContactMaster.CustomField4 = contact[column.ColumnName].ToString();
// break;
// case "CustomField5":
// objContactMaster.CustomField5 = contact[column.ColumnName].ToString();
// break;
// case "CustomField6":
// objContactMaster.CustomField6 = contact[column.ColumnName].ToString();
// break;
// case "CustomField7":
// objContactMaster.CustomField7 = contact[column.ColumnName].ToString();
// break;
// case "CustomField8":
// objContactMaster.CustomField8 = contact[column.ColumnName].ToString();
// break;
// case "CustomField9":
// objContactMaster.CustomField9 = contact[column.ColumnName].ToString();
// break;
// case "CustomField10":
// objContactMaster.CustomField10 = contact[column.ColumnName].ToString();
// break;
// case "CustomField11":
// objContactMaster.CustomField11 = contact[column.ColumnName].ToString();
// break;
// case "CustomField12":
// objContactMaster.CustomField12 = contact[column.ColumnName].ToString();
// break;
// case "CustomField13":
// objContactMaster.CustomField13 = contact[column.ColumnName].ToString();
// break;
// case "CustomField14":
// objContactMaster.CustomField14 = contact[column.ColumnName].ToString();
// break;
// case "CustomField15":
// objContactMaster.CustomField15 = contact[column.ColumnName].ToString();
// break;
// case "CustomField16":
// objContactMaster.CustomField16 = contact[column.ColumnName].ToString();
// break;
// case "CustomField17":
// objContactMaster.CustomField17 = contact[column.ColumnName].ToString();
// break;
// case "CustomField18":
// objContactMaster.CustomField18 = contact[column.ColumnName].ToString();
// break;
// case "CustomField19":
// objContactMaster.CustomField19 = contact[column.ColumnName].ToString();
// break;
// case "CustomField20":
// objContactMaster.CustomField20 = contact[column.ColumnName].ToString();
// break;
// case "CustomField21":
// objContactMaster.CustomField21 = contact[column.ColumnName].ToString();
// break;
// case "CustomField22":
// objContactMaster.CustomField22 = contact[column.ColumnName].ToString();
// break;
// case "CustomField23":
// objContactMaster.CustomField23 = contact[column.ColumnName].ToString();
// break;
// case "CustomField24":
// objContactMaster.CustomField24 = contact[column.ColumnName].ToString();
// break;
// case "CustomField25":
// objContactMaster.CustomField25 = contact[column.ColumnName].ToString();
// break;
// case "CustomField26":
// objContactMaster.CustomField26 = contact[column.ColumnName].ToString();
// break;
// case "CustomField27":
// objContactMaster.CustomField27 = contact[column.ColumnName].ToString();
// break;
// case "CustomField28":
// objContactMaster.CustomField28 = contact[column.ColumnName].ToString();
// break;
// case "CustomField29":
// objContactMaster.CustomField29 = contact[column.ColumnName].ToString();
// break;
// case "CustomField30":
// objContactMaster.CustomField30 = contact[column.ColumnName].ToString();
// break;
// case "CustomField31":
// objContactMaster.CustomField31 = contact[column.ColumnName].ToString();
// break;
// case "CustomField32":
// objContactMaster.CustomField32 = contact[column.ColumnName].ToString();
// break;
// case "CustomField33":
// objContactMaster.CustomField33 = contact[column.ColumnName].ToString();
// break;
// case "CustomField34":
// objContactMaster.CustomField34 = contact[column.ColumnName].ToString();
// break;
// case "CustomField35":
// objContactMaster.CustomField35 = contact[column.ColumnName].ToString();
// break;
// case "CustomField36":
// objContactMaster.CustomField36 = contact[column.ColumnName].ToString();
// break;
// case "CustomField37":
// objContactMaster.CustomField37 = contact[column.ColumnName].ToString();
// break;
// case "CustomField38":
// objContactMaster.CustomField38 = contact[column.ColumnName].ToString();
// break;
// case "CustomField39":
// objContactMaster.CustomField39 = contact[column.ColumnName].ToString();
// break;
// case "CustomField40":
// objContactMaster.CustomField40 = contact[column.ColumnName].ToString();
// break;
// case "CustomField41":
// objContactMaster.CustomField41 = contact[column.ColumnName].ToString();
// break;
// case "CustomField42":
// objContactMaster.CustomField42 = contact[column.ColumnName].ToString();
// break;
// case "CustomField43":
// objContactMaster.CustomField43 = contact[column.ColumnName].ToString();
// break;
// case "CustomField44":
// objContactMaster.CustomField44 = contact[column.ColumnName].ToString();
// break;
// case "CustomField45":
// objContactMaster.CustomField45 = contact[column.ColumnName].ToString();
// break;
// case "CustomField46":
// objContactMaster.CustomField46 = contact[column.ColumnName].ToString();
// break;
// case "CustomField47":
// objContactMaster.CustomField47 = contact[column.ColumnName].ToString();
// break;
// case "CustomField48":
// objContactMaster.CustomField48 = contact[column.ColumnName].ToString();
// break;
// case "CustomField49":
// objContactMaster.CustomField49 = contact[column.ColumnName].ToString();
// break;
// case "CustomField50":
// objContactMaster.CustomField50 = contact[column.ColumnName].ToString();
// break;
// }
// }
// }
// #endregion
// if (objContactMaster.Update() == true)
// {
// //str.Append("<Message>Recipient Updated Successfully</Message>");
// Logger.logdata(logforRpService, "Recipient Updated Successfully");
// }
// else
// {
// //str.Append("<Error>Recipient Update Failed</Error>");
// Logger.logdata(logforRpService, "Recipient Update Failed");
// }
// }
// catch (Exception ex)
// {
// str.Append("<Error>Edit Contact: Problem at updating contact</Error>");
// Logger.logdata(logforRpService, ex.Message);
// }
// }
// else
// {
// try
// {
// ContactMaster objContactMaster = new ContactMaster(Con);
// objContactMaster.EmailAddress = contact["EmailAddress"].ToString(); ;
// objContactMaster.EmailContentType = "Html";
// objContactMaster.CreatedDate = DateTime.Now;
// objContactMaster.FirstName = contact["FirstName"].ToString();
// objContactMaster.LastName = contact["LastName"].ToString();
// #region Handling Custom fields
// foreach (DataColumn column in contacts.Columns)
// {
// DataTable customFieldDt = ManageFieldsBase.SelectByField("FieldName", column.ColumnName, Con);
// string custField = "";
// if (customFieldDt.Rows.Count > 0)
// {
// custField = customFieldDt.Rows[0]["ContactFieldName"].ToString();
// }
// if (custField != "" && customFieldDt.Rows.Count > 0 && contact[column.ColumnName] != "")
// {
// switch (custField)
// {
// case "CustomField1":
// objContactMaster.CustomField1 = contact[column.ColumnName].ToString();
// break;
// case "CustomField2":
// objContactMaster.CustomField2 = contact[column.ColumnName].ToString();
// break;
// case "CustomField3":
// objContactMaster.CustomField3 = contact[column.ColumnName].ToString();
// break;
// case "CustomField4":
// objContactMaster.CustomField4 = contact[column.ColumnName].ToString();
// break;
// case "CustomField5":
// objContactMaster.CustomField5 = contact[column.ColumnName].ToString();
// break;
// case "CustomField6":
// objContactMaster.CustomField6 = contact[column.ColumnName].ToString();
// break;
// case "CustomField7":
// objContactMaster.CustomField7 = contact[column.ColumnName].ToString();
// break;
// case "CustomField8":
// objContactMaster.CustomField8 = contact[column.ColumnName].ToString();
// break;
// case "CustomField9":
// objContactMaster.CustomField9 = contact[column.ColumnName].ToString();
// break;
// case "CustomField10":
// objContactMaster.CustomField10 = contact[column.ColumnName].ToString();
// break;
// case "CustomField11":
// objContactMaster.CustomField11 = contact[column.ColumnName].ToString();
// break;
// case "CustomField12":
// objContactMaster.CustomField12 = contact[column.ColumnName].ToString();
// break;
// case "CustomField13":
// objContactMaster.CustomField13 = contact[column.ColumnName].ToString();
// break;
// case "CustomField14":
// objContactMaster.CustomField14 = contact[column.ColumnName].ToString();
// break;
// case "CustomField15":
// objContactMaster.CustomField15 = contact[column.ColumnName].ToString();
// break;
// case "CustomField16":
// objContactMaster.CustomField16 = contact[column.ColumnName].ToString();
// break;
// case "CustomField17":
// objContactMaster.CustomField17 = contact[column.ColumnName].ToString();
// break;
// case "CustomField18":
// objContactMaster.CustomField18 = contact[column.ColumnName].ToString();
// break;
// case "CustomField19":
// objContactMaster.CustomField19 = contact[column.ColumnName].ToString();
// break;
// case "CustomField20":
// objContactMaster.CustomField20 = contact[column.ColumnName].ToString();
// break;
// case "CustomField21":
// objContactMaster.CustomField21 = contact[column.ColumnName].ToString();
// break;
// case "CustomField22":
// objContactMaster.CustomField22 = contact[column.ColumnName].ToString();
// break;
// case "CustomField23":
// objContactMaster.CustomField23 = contact[column.ColumnName].ToString();
// break;
// case "CustomField24":
// objContactMaster.CustomField24 = contact[column.ColumnName].ToString();
// break;
// case "CustomField25":
// objContactMaster.CustomField25 = contact[column.ColumnName].ToString();
// break;
// case "CustomField26":
// objContactMaster.CustomField26 = contact[column.ColumnName].ToString();
// break;
// case "CustomField27":
// objContactMaster.CustomField27 = contact[column.ColumnName].ToString();
// break;
// case "CustomField28":
// objContactMaster.CustomField28 = contact[column.ColumnName].ToString();
// break;
// case "CustomField29":
// objContactMaster.CustomField29 = contact[column.ColumnName].ToString();
// break;
// case "CustomField30":
// objContactMaster.CustomField30 = contact[column.ColumnName].ToString();
// break;
// case "CustomField31":
// objContactMaster.CustomField31 = contact[column.ColumnName].ToString();
// break;
// case "CustomField32":
// objContactMaster.CustomField32 = contact[column.ColumnName].ToString();
// break;
// case "CustomField33":
// objContactMaster.CustomField33 = contact[column.ColumnName].ToString();
// break;
// case "CustomField34":
// objContactMaster.CustomField34 = contact[column.ColumnName].ToString();
// break;
// case "CustomField35":
// objContactMaster.CustomField35 = contact[column.ColumnName].ToString();
// break;
// case "CustomField36":
// objContactMaster.CustomField36 = contact[column.ColumnName].ToString();
// break;
// case "CustomField37":
// objContactMaster.CustomField37 = contact[column.ColumnName].ToString();
// break;
// case "CustomField38":
// objContactMaster.CustomField38 = contact[column.ColumnName].ToString();
// break;
// case "CustomField39":
// objContactMaster.CustomField39 = contact[column.ColumnName].ToString();
// break;
// case "CustomField40":
// objContactMaster.CustomField40 = contact[column.ColumnName].ToString();
// break;
// case "CustomField41":
// objContactMaster.CustomField41 = contact[column.ColumnName].ToString();
// break;
// case "CustomField42":
// objContactMaster.CustomField42 = contact[column.ColumnName].ToString();
// break;
// case "CustomField43":
// objContactMaster.CustomField43 = contact[column.ColumnName].ToString();
// break;
// case "CustomField44":
// objContactMaster.CustomField44 = contact[column.ColumnName].ToString();
// break;
// case "CustomField45":
// objContactMaster.CustomField45 = contact[column.ColumnName].ToString();
// break;
// case "CustomField46":
// objContactMaster.CustomField46 = contact[column.ColumnName].ToString();
// break;
// case "CustomField47":
// objContactMaster.CustomField47 = contact[column.ColumnName].ToString();
// break;
// case "CustomField48":
// objContactMaster.CustomField48 = contact[column.ColumnName].ToString();
// break;
// case "CustomField49":
// objContactMaster.CustomField49 = contact[column.ColumnName].ToString();
// break;
// case "CustomField50":
// objContactMaster.CustomField50 = contact[column.ColumnName].ToString();
// break;
// }
// }
// }
// #endregion
// objContactMaster.IsActive = true;
// objContactMaster.InsertWithDefaultValues(true);
// Int64 ContactId = Convert.ToInt64(objContactMaster.ContactId);
// ContactIds = ContactIds + ContactId + ",";
// Logger.logdata(logforRpService, "Recipient Added Successfully");
// }
// catch (Exception ex)
// {
// str.Append("<Error>Add New Contact: Problem at adding contact</Error>");
// Logger.logdata(logforRpService, ex.Message);
// }
// }
// }
// Logger.logdata(logforRpService, "SendCampaign() at Contacts region end");
// }
// else
// {
// str.Append("<Error>No records found to send Campaign</Error>");
// }
// LogEndInfo("AddRecipient");
// #endregion
// TemplateMaster tempMaster = null;
// #region Template
// try
// {
// Logger.logdata(logforRpService, "SendCampaign() at Template region");
// TemplateMasters obj = TemplateMaster.SelectByField("TemplateName", TemplateName, Con);
// if (obj.Count > 0)
// {
// TemplateMasterPrimaryKey template = new TemplateMasterPrimaryKey(Convert.ToInt64(obj[0].TemplateId.ToString()));
// tempMaster = TemplateMaster.SelectOne(template, Con);
// }
// else
// {
// str.Append("<Error>" + TemplateName + " Template Not found</Error>");
// }
// Logger.logdata(logforRpService, "SendCampaign() at Template region end");
// }
// catch (Exception ex)
// {
// str.Append("<Error>Template: Problem at getting mail content</Error>");
// Logger.logdata(logforRpService, ex.Message);
// }
// #endregion
// ListMasterBase listMaster = null;
// Int64 listid = 0;
// #region List
// try
// {
// Logger.logdata(logforRpService, "SendCampaign() at List region");
// if (str.ToString().IndexOf("Error") == -1)
// {
// listMaster = new ListMasterBase(Con);
// listMaster.ListName = "4VL_" + DateTime.Now;
// listMaster.CreatedDate = System.DateTime.Now;
// listMaster.InsertWithDefaultValues(true);
// listid = Convert.ToInt64(listMaster.ListMasterID);
// str.Append("<ListId>" + listid.ToString() + "</ListId>");
// ContactIds = ContactIds.Substring(0, ContactIds.Length - 1);
// string[] selectContact = ContactIds.Split(',');
// if (listid > 0)
// {
// DataTable dtListContactMaster = new DataTable();
// dtListContactMaster.Columns.Add(new DataColumn("ListMasterID", typeof(string)));
// dtListContactMaster.Columns.Add(new DataColumn("ContactId", typeof(string)));
// dtListContactMaster.Columns.Add(new DataColumn("CreatedDate", typeof(string)));
// dtListContactMaster.Columns.Add(new DataColumn("ModifiedDate", typeof(string)));
// StringBuilder strbAddedContacts = new StringBuilder();
// //ArrayList contactsSelected = (ArrayList)Session["SelectedContacts"];
// foreach (string contactID in selectContact)
// {
// DataRow rowListContactMaster = dtListContactMaster.NewRow();
// rowListContactMaster["ListMasterID"] = listid;
// rowListContactMaster["ContactId"] = contactID;
// rowListContactMaster["CreatedDate"] = DateTime.Now.ToString();
// rowListContactMaster["ModifiedDate"] = DateTime.Now.ToString();
// dtListContactMaster.Rows.Add(rowListContactMaster);
// }
// string[] SourceColumn = new[] { "ListMasterID", "ContactId", "CreatedDate", "ModifiedDate" };
// string[] DestinationColumn = new[] { "ListMasterID", "ContactId", "CreatedDate", "ModifiedDate" };
// ListContactMaster.BulkCopy(dtListContactMaster, "ListContactMaster", SourceColumn, DestinationColumn, Con);
// str.Append("<Message>Recipients Add Successfully to Lists</Message>");
// }
// }
// Logger.logdata(logforRpService, "SendCampaign() at List region end");
// }
// catch (Exception ex)
// {
// str.Append("<Error>List: Problem at ListCreation contact</Error>");
// Logger.logdata(logforRpService, ex.Message);
// }
// #endregion
// #region SendCampaign
// if (listMaster != null && listid > 0 && str.ToString().IndexOf("Error") == -1)
// {
// try
// {
// Logger.logdata(logforRpService, "SendCampaign() at SendCampaign region");
// CampaignMasters camp = CampaignMaster.SelectByField("CampaignName", CampaignName, Con);
// if (camp.Count > 0)
// {
// str.Append("<CampaignId>" + camp[0].CampaignId.ToString() + "</CampaignId>");
// str.Append("<Message>Campaign Name AllReady Exist</Message>");
// }
// else
// {
// CampaignMaster objCampaignMaster = new CampaignMaster(Con);
// objCampaignMaster.CampaignName = CampaignName;
// objCampaignMaster.CampaignDescription = "";
// objCampaignMaster.FromAddress = FromAddress;
// objCampaignMaster.FromName = FromName;
// objCampaignMaster.ReplytoAddress = ReplyToAddress;
// objCampaignMaster.ReplaytoName = "";
// objCampaignMaster.Subject = Subject;
// objCampaignMaster.TrackReads = true;//"1";
// objCampaignMaster.SelectCondition = listid.ToString();
// objCampaignMaster.TemplateId = tempMaster.TemplateId;
// objCampaignMaster.ModifiedDate = DateTime.Now;
// objCampaignMaster.CreatedDate = DateTime.Now;
// objCampaignMaster.HTMLContent = tempMaster.HTMLContent;
// objCampaignMaster.TextContent = "";
// objCampaignMaster.SuppressDomain = "";
// objCampaignMaster.UnsubscribeText = "";
// objCampaignMaster.UnsubscribeLinkText = "";
// objCampaignMaster.SuppressSelection = "";
// Int64 campaignMasterID = objCampaignMaster.insertCampainMaster(objCampaignMaster);
// if (campaignMasterID > 0)
// {
// CampaignJob objCampaignJob = new CampaignJob(Con);
// objCampaignJob.CampaignMasterID = campaignMasterID;
// objCampaignJob.CreatedDatetime = DateTime.Now;
// objCampaignJob.ScheduledDatetime = DateTime.Now.AddMinutes(2);// DateTime.Now.AddMinutes(2);//Convert.ToDateTime(LaunchDateTime);
// objCampaignJob.SendType = "IMMEDIATE";
// objCampaignJob.Status = 1;
// objCampaignJob.Insert();
// }
// str.Append("<TemplateID>" + tempMaster.TemplateId.ToString() + "</TemplateID>");
// str.Append("<CampaignId>" + campaignMasterID.ToString() + "</CampaignId>");
// str.Append("<Message>Campaign Inserted Succefully</Message>");
// Logger.logdata(logforRpService, "SendCampaign() at SendCampaign region end");
// }
// }
// catch (Exception ex)
// {
// str.Append("<Error>Send Campaign :" + ex.Message + "</Error>");
// Logger.logdata(logforRpService, ex.Message);
// }
// }
// }
// else
// {
// str.Append("<Error>Failed to Connect Database</Error>");
// Logger.logdata(logforRpService, "Please Enter Valid Inputs");
// }
// #endregion
// }
// catch (Exception ex)
// {
// str.Append("<Error>" + ex.Message + "</Error>");
// Logger.logError(logforRpService, ex);
// }
// str.Append("</CampaignDetails>");
// doc.LoadXml(str.ToString());
// return doc;
//}
public string ScheduleCampaign(string Con, string CampaignName, string Subject, string FromName, string ReplyToAddress, string FromAddress, string TemplateName, string ListID)
{
TemplateMaster tempMaster = null;
try
{
TemplateMasters obj = TemplateMaster.SelectByField("TemplateName", TemplateName, Con);
if (obj.Count > 0)
{
TemplateMasterPrimaryKey template = new TemplateMasterPrimaryKey(Convert.ToInt64(obj[0].TemplateId.ToString()));
tempMaster = TemplateMaster.SelectOne(template, Con);
CampaignMaster objCampaignMaster = new CampaignMaster(Con);
objCampaignMaster.CampaignName = CampaignName;
objCampaignMaster.CampaignDescription = "";
objCampaignMaster.FromAddress = FromAddress;
objCampaignMaster.FromName = FromName;
objCampaignMaster.ReplytoAddress = ReplyToAddress;
objCampaignMaster.ReplaytoName = FromName;
objCampaignMaster.Subject = Subject;
objCampaignMaster.TrackReads = true;//"1";
objCampaignMaster.SelectCondition = ListID;
objCampaignMaster.TemplateId = tempMaster.TemplateId;
objCampaignMaster.ModifiedDate = DateTime.Now;
objCampaignMaster.CreatedDate = DateTime.Now;
objCampaignMaster.HTMLContent = tempMaster.HTMLContent;
objCampaignMaster.TextContent = "";
objCampaignMaster.SuppressDomain = "";
objCampaignMaster.UnsubscribeText = "";
objCampaignMaster.UnsubscribeLinkText = "";
objCampaignMaster.SuppressSelection = "";
objCampaignMaster.AssignedCampaignID = 0;
Int64 campaignMasterID = objCampaignMaster.insertCampainMaster(objCampaignMaster);
if (campaignMasterID > 0)
{
CampaignJob objCampaignJob = new CampaignJob(Con);
objCampaignJob.CampaignMasterID = campaignMasterID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = DateTime.Now.AddMinutes(2);// DateTime.Now.AddMinutes(2);//Convert.ToDateTime(LaunchDateTime);
objCampaignJob.SendType = "IMMEDIATE";
objCampaignJob.Status = 1;
objCampaignJob.Insert();
}
Logger.logdata(logforRpService, "Campaign Inserted Succefully");
return (campaignMasterID.ToString());
}
else
{
return ("False");
}
}
catch (Exception ex)
{
Logger.logdata(logforRpService, ex.Message);
return ("False");
}
}
public string ScheduleMailingWithCampaignID(string Con, long CampaignID, string CampaignName, string Subject, string FromName, string ReplyToAddress, string FromAddress, string TemplateName, string ListID, string SuppressDomain)
{
TemplateMaster tempMaster = null;
try
{
TemplateMasters obj = TemplateMaster.SelectByField("TemplateName", TemplateName, Con);
if (obj.Count > 0)
{
TemplateMasterPrimaryKey template = new TemplateMasterPrimaryKey(Convert.ToInt64(obj[0].TemplateId.ToString()));
tempMaster = TemplateMaster.SelectOne(template, Con);
CampaignMaster objCampaignMaster = new CampaignMaster(Con);
objCampaignMaster.CampaignName = CampaignName;
objCampaignMaster.CampaignDescription = "";
objCampaignMaster.FromAddress = FromAddress;
objCampaignMaster.FromName = FromName;
objCampaignMaster.ReplytoAddress = ReplyToAddress;
objCampaignMaster.ReplaytoName = FromName;
objCampaignMaster.Subject = Subject;
objCampaignMaster.TrackReads = true;//"1";
objCampaignMaster.SelectCondition = ListID;
objCampaignMaster.TemplateId = tempMaster.TemplateId;
objCampaignMaster.ModifiedDate = DateTime.Now;
objCampaignMaster.CreatedDate = DateTime.Now;
objCampaignMaster.HTMLContent = tempMaster.HTMLContent;
objCampaignMaster.TextContent = "";
objCampaignMaster.SuppressDomain = (SuppressDomain == null) ? "" : SuppressDomain;
objCampaignMaster.UnsubscribeText = "";
objCampaignMaster.UnsubscribeLinkText = "";
objCampaignMaster.SuppressSelection = "";
objCampaignMaster.AssignedCampaignID = CampaignID;
Int64 MailingID = objCampaignMaster.insertCampainMaster(objCampaignMaster);
#region Domine suppress
//Create a DataTable for as a parameter to sp
DataTable dtDomains = new DataTable();
//DataColumn
dtDomains.Columns.Add("DomainName", typeof(string));
if (SuppressDomain.Trim().Length > 0)
{
if (SuppressDomain.Contains(","))
{
string[] domains = SuppressDomain.Split(',');
for (int i = 0; i < domains.Length; i++)
dtDomains.Rows.Add(domains[i]);
}
else
dtDomains.Rows.Add(SuppressDomain);
}
ListContactMaster objListContactMaster = new ListContactMaster(Con);
objListContactMaster.InsertInToDomainSuppress_Bulk((int)MailingID, ListID.ToString(), dtDomains); //CampaignMasterIDforUddate, id, ListOfContactIds.ToString(), SuppressDomain);
#endregion
if (MailingID > 0)
{
CampaignJob objCampaignJob = new CampaignJob(Con);
objCampaignJob.CampaignMasterID = MailingID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = DateTime.Now.AddMinutes(2);// DateTime.Now.AddMinutes(2);//Convert.ToDateTime(LaunchDateTime);
objCampaignJob.SendType = "IMMEDIATE";
objCampaignJob.Status = 1;
objCampaignJob.Insert();
}
Logger.logdata(logforRpService, "Mailing Inserted Succefully");
return (MailingID.ToString());
}
else
{
return ("False");
}
}
catch (Exception ex)
{
Logger.logdata(logforRpService, ex.Message);
return ("False");
}
}
public bool saveCampaignDetailsTab(bool Rflag)
{
if (txtCampaignName.Text == string.Empty)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Success", "alert('Please enter Mailing name in Mailing Details Tab.')", true);
Rflag = false;
}
else if (ddlFromAddress.SelectedItem.Text == string.Empty)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Success", "alert('Please enter FromAddress.')", true);
Rflag = false;
}
else if (txtFromName.Text == string.Empty)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Success", "alert('Please enter FromName.')", true);
Rflag = false;
}
else if (txtSubject.Text == string.Empty)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Success", "alert('Please enter subject from Mailing Details tab.')", true);
Rflag = false;
}
else
{
if (hiddenCampaignID.Value == string.Empty)
{
objCampaignMaster = new CampaignMaster(ConnectionString);
DataTable campMaster = CampaignMasterBase.SelectByName("CampaignName", txtCampaignName.Text.ToString(), ConnectionString);
if (campMaster.Rows.Count != 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Success", "alert('Mailing already Exists with this Name.')", true);
Rflag = false;
}
else
{
objCampaignMaster.CampaignName = txtCampaignName.Text;
objCampaignMaster.CampaignDescription = txtCampaignDescription.Text;
objCampaignMaster.FromAddress = ddlFromAddress.SelectedItem.Text;
objCampaignMaster.FromName = txtFromName.Text;
objCampaignMaster.ReplytoAddress = txtReplytoAddress.Text;
objCampaignMaster.ReplaytoName = txtReplaytoName.Text;
objCampaignMaster.Subject = txtSubject.Text;
objCampaignMaster.TrackReads = chkTrackReads.Checked;
if (RadEditor1.Content.ToString().Trim().Length != 0)
objCampaignMaster.htmlHasUnsubLink = chkAddress.Checked;
else
objCampaignMaster.htmlHasUnsubLink = false;
if (textRadEditor.Content.ToString().Trim().Length != 0)
objCampaignMaster.txtHasUnsubLink = chkTxtAddress.Checked;
else
objCampaignMaster.txtHasUnsubLink = false;
objCampaignMaster.UnsubscribeText = txtUnsubscribe.Text;
objCampaignMaster.UnsubscribeLinkText = DDLinktext.SelectedItem.Text;
if (ddlCampsNames.Text != defaultListItem)
objCampaignMaster.AssignedCampaignID = Convert.ToInt64(ddlCampsNames.SelectedItem.Value);
else
objCampaignMaster.AssignedCampaignID = 0;
lblunsubinfo.Text = txtUnsubscribe.Text;
lblunsublinktext.Text = DDLinktext.SelectedItem.Text;
DivUnsubtext.InnerHtml = lblunsubinfo.Text + " \n" + lblunsublinktext.Text;
objCampaignMaster.TemplateId = 0;
objCampaignMaster.HTMLContent = string.Empty;
objCampaignMaster.TextContent = string.Empty;
objCampaignMaster.SelectCondition = string.Empty;
objCampaignMaster.SuppressDomain = string.Empty;
objCampaignMaster.SuppressSelection = string.Empty;
Int64 campaignMasterID = objCampaignMaster.insertMailing(objCampaignMaster);
if (campaignMasterID > 0)
{
//Insert In CampaignJob Table
CampaignJob objCampaignJob = new CampaignJob(ConnectionString);
objCampaignJob.CampaignMasterID = campaignMasterID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = DateTime.Now; //Convert.ToDateTime(scheduledTime);
objCampaignJob.SendType = sendType;
objCampaignJob.Status = 5;
objCampaignJob.Insert();
//Insert in CampaignMailing Table
if (ddlCampsNames.Text != defaultListItem)
{
CampaignMailing objCampaignMailing = new CampaignMailing(ConnectionString);
objCampaignMailing.CampaignId = campaignMasterID;
objCampaignMailing.CampaignsID = Convert.ToInt64(ddlCampsNames.SelectedItem.Value);//Mailing Id
objCampaignMailing.CreatedDate = DateTime.Now;
objCampaignMailing.ModifiedDate = DateTime.Now;
objCampaignMailing.IsActive = true;
objCampaignMailing.Insert();
}
status = true;
insert = true;
}
hiddenCampaignID.Value = campaignMasterID.ToString();
lblCampName.Text = objCampaignMaster.CampaignName.ToString().Trim();
Rflag = true;
statusType = "Inserted";
//statusType = "Updated";
ViewState["statusType"] = "Inserted";
hdCampDetailsTab1.Value = "0"; //After Save CampaignDetails Iam Change the Value of Hidden Variable value to Zero.
}
}
else
{
updateCampaignDetailsTab();
Rflag = true;
}
}
return Rflag;
}
public XmlDocument AddMailingWithMinData(string UserID, string Password, string MailingName, string FromName, string FromAddress, string Subject, DataSet Recipients)
{
XmlDocument doc = new System.Xml.XmlDocument();
StringBuilder str = new StringBuilder();
StringBuilder unDeleverdInfo = new StringBuilder();
bool isTargetListHavingEmailIds = false;
List<string> emailColumns = new List<string>();
emailColumns.Add("Email Address");
emailColumns.Add("emailaddress");
emailColumns.Add("email");
emailColumns.Add("e-mail");
emailColumns.Add("Email");
emailColumns.Add("e-mailaddress");
emailColumns.Add("emailaddress");
emailColumns.Add("emailadd");
emailColumns.Add("e-mailadd");
emailColumns.Add("emailaddress");
List<string> fnameColumns = new List<string>();
fnameColumns.Add("firstname");
fnameColumns.Add("first name");
fnameColumns.Add("fname");
List<string> lnameColumns = new List<string>();
lnameColumns.Add("lastname");
lnameColumns.Add("last name");
lnameColumns.Add("lname");
foreach (DataColumn clm in Recipients.Tables[0].Columns)
{
if (emailColumns.Contains(clm.ToString().ToLower()))
{
Recipients.Tables[0].Columns[clm.ToString()].ColumnName = "EmailAddress";
isTargetListHavingEmailIds = true;
}
else if (fnameColumns.Contains(clm.ToString().ToLower()))
Recipients.Tables[0].Columns[clm.ToString()].ColumnName = "FirstName";
else if (lnameColumns.Contains(clm.ToString().ToLower()))
Recipients.Tables[0].Columns[clm.ToString()].ColumnName = "LastName";
}
str.Append("<MailingInfo>");
string ConnectionString = GetConnectionString(UserID, Password);
string validEmailIds = string.Empty;
string unsubEmailIds = string.Empty;
string hardBounceEmailIds = string.Empty;
string softBounceEmailIds = string.Empty;
string duplicateEmailids = string.Empty;
Hashtable contatcInfo = new Hashtable();
if (ConnectionString.Trim().Length != 0)
{
LogStartInfo("AddMailingWithMinData", ConnectionString, UserID);
Logger.logdata(logforRpService, "Input Paramiters :Mailing Name = " + MailingName + "; No.of Contacts=" + Recipients.Tables[0].Rows.Count);
if (isTargetListHavingEmailIds)
{
if (MailingName.Trim().Length != 0 && Recipients.Tables.Count > 0 && Recipients.Tables[0].Rows.Count > 0)
{
Int64 listid = 0;
ListMasterBase listMaster = null;
DataTable contacts = Recipients.Tables[0];
CampaignMasters camp = CampaignMaster.SelectByField("CampaignName", MailingName, ConnectionString);
if (camp.Count > 0)
{
str.Append("<Message>Mailing With Name " + MailingName + " Allready Exist,Please Enter Other Name</Message>");
Logger.logdata(logforRpService, "Mailing With Name " + MailingName + " Allready Exist,Please Enter Other Name");
}
else
{
#region TargetList
if (contacts.Rows.Count > 0)
{
//string[] EmailIds = contacts.AsEnumerable().Select(row => row.Field<string>("EmailAddress")).ToArray();
unDeleverdInfo.Append("<UndeliveredList>");
foreach (DataRow contact in contacts.Rows)
{
ContactMasters contemail = ContactMaster.SelectByField("EmailAddress", contact["EmailAddress"].ToString(), ConnectionString);
DataTable unSubDetails = new DataTable();
DataTable contactMasters = ContactMaster.GetBouceStatusByEmailIds(ConnectionString, contact["EmailAddress"].ToString());
if (contemail.Count > 0)
{
unSubDetails = UnSubscribeDetail.GetUnSubDetailsByContactId(ConnectionString, contemail[0].ContactId.ToString(), string.Empty);
}
if (unSubDetails.Rows.Count > 0)
{
unDeleverdInfo.Append("<Undelivered>");
if (unSubDetails.Rows[0]["Reason"].ToString() == "GlobalUnSub")
{
unDeleverdInfo.Append("<EMailAddress>" + contact["EmailAddress"].ToString() + "</EMailAddress>");
unDeleverdInfo.Append("<RecipientStatus>Unsubscribe</RecipientStatus>");
unsubEmailIds = unsubEmailIds + contact["EmailAddress"].ToString() + ";";
}
else if (unSubDetails.Rows[0]["Reason"].ToString() == "bad-mailbox" || unSubDetails.Rows[0]["Reason"].ToString() == "bad-domain")
{
unDeleverdInfo.Append("<EMailAddress>" + contact["EmailAddress"].ToString() + "</EMailAddress>");
unDeleverdInfo.Append("<RecipientStatus>HardBounce</RecipientStatus>");
hardBounceEmailIds = hardBounceEmailIds + contact["EmailAddress"].ToString() + ";";
}
unDeleverdInfo.Append("</Undelivered>");
}
else if (contactMasters.Rows.Count > 0 && contactMasters.Rows[0]["IsActive"].ToString() == "False" && Convert.ToInt32(contactMasters.Rows[0]["SoftBounceCount"].ToString()) >= SoftBounceCount)
{
unDeleverdInfo.Append("<Undelivered>");
unDeleverdInfo.Append("<EMailAddress>" + contact["EmailAddress"].ToString() + "</EMailAddress>");
unDeleverdInfo.Append("<RecipientStatus>SoftBounce</RecipientStatus>");
unDeleverdInfo.Append("</Undelivered>");
softBounceEmailIds = softBounceEmailIds + contact["EmailAddress"].ToString() + ";";
}
else if (contemail.Count > 0 && contemail[0].EmailAddress.Trim().Length > 0)
{
try
{
if (contemail[0].IsActive == true)
{
if (!contatcInfo.ContainsKey(contemail[0].ContactId))
{
contatcInfo.Add(contemail[0].ContactId, "");
validEmailIds = validEmailIds + contemail[0].EmailAddress + ";";
}
else
duplicateEmailids = duplicateEmailids + contemail[0].EmailAddress + ";";
ContactMasterPrimaryKey pk = new ContactMasterPrimaryKey(Convert.ToInt64(contemail[0].ContactId.ToString()));
ContactMaster objContactMaster = ContactMaster.SelectOne(pk, ConnectionString);
#region Handling Custom fields
foreach (DataColumn column in contacts.Columns)
{
DataTable customFieldDt = ManageFieldsBase.SelectByField("FieldName", column.ColumnName, ConnectionString);
string custField = "";
if (customFieldDt.Rows.Count > 0)
{
custField = customFieldDt.Rows[0]["ContactFieldName"].ToString();
}
else
custField = column.ColumnName;
if (custField != "" && !string.IsNullOrEmpty(contact[column.ColumnName].ToString()))
{
switch (custField)
{
case "EmailAddress":
objContactMaster.EmailAddress = contact[column.ColumnName].ToString();
break;
case "FirstName":
objContactMaster.FirstName = contact[column.ColumnName].ToString();
break;
case "LastName":
objContactMaster.LastName = contact[column.ColumnName].ToString();
break;
case "Address1":
objContactMaster.Address1 = contact[column.ColumnName].ToString();
break;
case "City":
objContactMaster.City = contact[column.ColumnName].ToString();
break;
case "State":
objContactMaster.State = contact[column.ColumnName].ToString();
break;
case "PostalCode":
objContactMaster.PostalCode = contact[column.ColumnName].ToString();
break;
case "Country":
objContactMaster.Country = contact[column.ColumnName].ToString();
break;
case "WorkPhone":
objContactMaster.WorkPhone = contact[column.ColumnName].ToString();
break;
case "HomePhone":
objContactMaster.HomePhone = contact[column.ColumnName].ToString();
break;
case "MobilePhone":
objContactMaster.MobilePhone = contact[column.ColumnName].ToString();
break;
case "CustomField1":
objContactMaster.CustomField1 = contact[column.ColumnName].ToString();
break;
case "CustomField2":
objContactMaster.CustomField2 = contact[column.ColumnName].ToString();
break;
case "CustomField3":
objContactMaster.CustomField3 = contact[column.ColumnName].ToString();
break;
case "CustomField4":
objContactMaster.CustomField4 = contact[column.ColumnName].ToString();
break;
case "CustomField5":
objContactMaster.CustomField5 = contact[column.ColumnName].ToString();
break;
case "CustomField6":
objContactMaster.CustomField6 = contact[column.ColumnName].ToString();
break;
case "CustomField7":
objContactMaster.CustomField7 = contact[column.ColumnName].ToString();
break;
case "CustomField8":
objContactMaster.CustomField8 = contact[column.ColumnName].ToString();
break;
case "CustomField9":
objContactMaster.CustomField9 = contact[column.ColumnName].ToString();
break;
case "CustomField10":
objContactMaster.CustomField10 = contact[column.ColumnName].ToString();
break;
case "CustomField11":
objContactMaster.CustomField11 = contact[column.ColumnName].ToString();
break;
case "CustomField12":
objContactMaster.CustomField12 = contact[column.ColumnName].ToString();
break;
case "CustomField13":
objContactMaster.CustomField13 = contact[column.ColumnName].ToString();
break;
case "CustomField14":
objContactMaster.CustomField14 = contact[column.ColumnName].ToString();
break;
case "CustomField15":
objContactMaster.CustomField15 = contact[column.ColumnName].ToString();
break;
case "CustomField16":
objContactMaster.CustomField16 = contact[column.ColumnName].ToString();
break;
case "CustomField17":
objContactMaster.CustomField17 = contact[column.ColumnName].ToString();
break;
case "CustomField18":
objContactMaster.CustomField18 = contact[column.ColumnName].ToString();
break;
case "CustomField19":
objContactMaster.CustomField19 = contact[column.ColumnName].ToString();
break;
case "CustomField20":
objContactMaster.CustomField20 = contact[column.ColumnName].ToString();
break;
case "CustomField21":
objContactMaster.CustomField21 = contact[column.ColumnName].ToString();
break;
case "CustomField22":
objContactMaster.CustomField22 = contact[column.ColumnName].ToString();
break;
case "CustomField23":
objContactMaster.CustomField23 = contact[column.ColumnName].ToString();
break;
case "CustomField24":
objContactMaster.CustomField24 = contact[column.ColumnName].ToString();
break;
case "CustomField25":
objContactMaster.CustomField25 = contact[column.ColumnName].ToString();
break;
case "CustomField26":
objContactMaster.CustomField26 = contact[column.ColumnName].ToString();
break;
case "CustomField27":
objContactMaster.CustomField27 = contact[column.ColumnName].ToString();
break;
case "CustomField28":
objContactMaster.CustomField28 = contact[column.ColumnName].ToString();
break;
case "CustomField29":
objContactMaster.CustomField29 = contact[column.ColumnName].ToString();
break;
case "CustomField30":
objContactMaster.CustomField30 = contact[column.ColumnName].ToString();
break;
case "CustomField31":
objContactMaster.CustomField31 = contact[column.ColumnName].ToString();
break;
case "CustomField32":
objContactMaster.CustomField32 = contact[column.ColumnName].ToString();
break;
case "CustomField33":
objContactMaster.CustomField33 = contact[column.ColumnName].ToString();
break;
case "CustomField34":
objContactMaster.CustomField34 = contact[column.ColumnName].ToString();
break;
case "CustomField35":
objContactMaster.CustomField35 = contact[column.ColumnName].ToString();
break;
case "CustomField36":
objContactMaster.CustomField36 = contact[column.ColumnName].ToString();
break;
case "CustomField37":
objContactMaster.CustomField37 = contact[column.ColumnName].ToString();
break;
case "CustomField38":
objContactMaster.CustomField38 = contact[column.ColumnName].ToString();
break;
case "CustomField39":
objContactMaster.CustomField39 = contact[column.ColumnName].ToString();
break;
case "CustomField40":
objContactMaster.CustomField40 = contact[column.ColumnName].ToString();
break;
case "CustomField41":
objContactMaster.CustomField41 = contact[column.ColumnName].ToString();
break;
case "CustomField42":
objContactMaster.CustomField42 = contact[column.ColumnName].ToString();
break;
case "CustomField43":
objContactMaster.CustomField43 = contact[column.ColumnName].ToString();
break;
case "CustomField44":
objContactMaster.CustomField44 = contact[column.ColumnName].ToString();
break;
case "CustomField45":
objContactMaster.CustomField45 = contact[column.ColumnName].ToString();
break;
case "CustomField46":
objContactMaster.CustomField46 = contact[column.ColumnName].ToString();
break;
case "CustomField47":
objContactMaster.CustomField47 = contact[column.ColumnName].ToString();
break;
case "CustomField48":
objContactMaster.CustomField48 = contact[column.ColumnName].ToString();
break;
case "CustomField49":
objContactMaster.CustomField49 = contact[column.ColumnName].ToString();
break;
case "CustomField50":
objContactMaster.CustomField50 = contact[column.ColumnName].ToString();
break;
}
}
}
#endregion
if (objContactMaster.Update() == true)
{
//str.Append("<Message>Recipient Updated Successfully</Message>");
}
else
{
//str.Append("<Error>Recipient Update Failed</Error>");
Logger.logdata(logforRpService, "Recipient Update Failed");
}
}
}
catch (Exception ex)
{
str.Append("<Error>Edit Contact: Problem at updating contact</Error>");
Logger.logdata(logforRpService, "Update Contact :" + ex.Message);
}
}
else if (contact["EmailAddress"] != null && contact["EmailAddress"].ToString().Trim().Length > 0)
{
try
{
ContactMaster objContactMaster = new ContactMaster(ConnectionString);
objContactMaster.EmailAddress = contact["EmailAddress"].ToString();
objContactMaster.EmailContentType = "Html";
objContactMaster.CreatedDate = DateTime.Now;
#region Handling Custom fields
foreach (DataColumn column in contacts.Columns)
{
DataTable customFieldDt = ManageFieldsBase.SelectByField("FieldName", column.ColumnName, ConnectionString);
string custField = "";
if (customFieldDt.Rows.Count > 0)
{
custField = customFieldDt.Rows[0]["ContactFieldName"].ToString();
}
else
custField = column.ColumnName;
if (custField != "" && !string.IsNullOrEmpty(contact[column.ColumnName].ToString()))
{
switch (custField)
{
case "EmailAddress":
objContactMaster.EmailAddress = contact[column.ColumnName].ToString();
break;
case "FirstName":
objContactMaster.FirstName = contact[column.ColumnName].ToString();
break;
case "LastName":
objContactMaster.LastName = contact[column.ColumnName].ToString();
break;
case "Address1":
objContactMaster.Address1 = contact[column.ColumnName].ToString();
break;
case "City":
objContactMaster.City = contact[column.ColumnName].ToString();
break;
case "State":
objContactMaster.State = contact[column.ColumnName].ToString();
break;
case "PostalCode":
objContactMaster.PostalCode = contact[column.ColumnName].ToString();
break;
case "Country":
objContactMaster.Country = contact[column.ColumnName].ToString();
break;
case "WorkPhone":
objContactMaster.WorkPhone = contact[column.ColumnName].ToString();
break;
case "HomePhone":
objContactMaster.HomePhone = contact[column.ColumnName].ToString();
break;
case "MobilePhone":
objContactMaster.MobilePhone = contact[column.ColumnName].ToString();
break;
case "CustomField1":
objContactMaster.CustomField1 = contact[column.ColumnName].ToString();
break;
case "CustomField2":
objContactMaster.CustomField2 = contact[column.ColumnName].ToString();
break;
case "CustomField3":
objContactMaster.CustomField3 = contact[column.ColumnName].ToString();
break;
case "CustomField4":
objContactMaster.CustomField4 = contact[column.ColumnName].ToString();
break;
case "CustomField5":
objContactMaster.CustomField5 = contact[column.ColumnName].ToString();
break;
case "CustomField6":
objContactMaster.CustomField6 = contact[column.ColumnName].ToString();
break;
case "CustomField7":
objContactMaster.CustomField7 = contact[column.ColumnName].ToString();
break;
case "CustomField8":
objContactMaster.CustomField8 = contact[column.ColumnName].ToString();
break;
case "CustomField9":
objContactMaster.CustomField9 = contact[column.ColumnName].ToString();
break;
case "CustomField10":
objContactMaster.CustomField10 = contact[column.ColumnName].ToString();
break;
case "CustomField11":
objContactMaster.CustomField11 = contact[column.ColumnName].ToString();
break;
case "CustomField12":
objContactMaster.CustomField12 = contact[column.ColumnName].ToString();
break;
case "CustomField13":
objContactMaster.CustomField13 = contact[column.ColumnName].ToString();
break;
case "CustomField14":
objContactMaster.CustomField14 = contact[column.ColumnName].ToString();
break;
case "CustomField15":
objContactMaster.CustomField15 = contact[column.ColumnName].ToString();
break;
case "CustomField16":
objContactMaster.CustomField16 = contact[column.ColumnName].ToString();
break;
case "CustomField17":
objContactMaster.CustomField17 = contact[column.ColumnName].ToString();
break;
case "CustomField18":
objContactMaster.CustomField18 = contact[column.ColumnName].ToString();
break;
case "CustomField19":
objContactMaster.CustomField19 = contact[column.ColumnName].ToString();
break;
case "CustomField20":
objContactMaster.CustomField20 = contact[column.ColumnName].ToString();
break;
case "CustomField21":
objContactMaster.CustomField21 = contact[column.ColumnName].ToString();
break;
case "CustomField22":
objContactMaster.CustomField22 = contact[column.ColumnName].ToString();
break;
case "CustomField23":
objContactMaster.CustomField23 = contact[column.ColumnName].ToString();
break;
case "CustomField24":
objContactMaster.CustomField24 = contact[column.ColumnName].ToString();
break;
case "CustomField25":
objContactMaster.CustomField25 = contact[column.ColumnName].ToString();
break;
case "CustomField26":
objContactMaster.CustomField26 = contact[column.ColumnName].ToString();
break;
case "CustomField27":
objContactMaster.CustomField27 = contact[column.ColumnName].ToString();
break;
case "CustomField28":
objContactMaster.CustomField28 = contact[column.ColumnName].ToString();
break;
case "CustomField29":
objContactMaster.CustomField29 = contact[column.ColumnName].ToString();
break;
case "CustomField30":
objContactMaster.CustomField30 = contact[column.ColumnName].ToString();
break;
case "CustomField31":
objContactMaster.CustomField31 = contact[column.ColumnName].ToString();
break;
case "CustomField32":
objContactMaster.CustomField32 = contact[column.ColumnName].ToString();
break;
case "CustomField33":
objContactMaster.CustomField33 = contact[column.ColumnName].ToString();
break;
case "CustomField34":
objContactMaster.CustomField34 = contact[column.ColumnName].ToString();
break;
case "CustomField35":
objContactMaster.CustomField35 = contact[column.ColumnName].ToString();
break;
case "CustomField36":
objContactMaster.CustomField36 = contact[column.ColumnName].ToString();
break;
case "CustomField37":
objContactMaster.CustomField37 = contact[column.ColumnName].ToString();
break;
case "CustomField38":
objContactMaster.CustomField38 = contact[column.ColumnName].ToString();
break;
case "CustomField39":
objContactMaster.CustomField39 = contact[column.ColumnName].ToString();
break;
case "CustomField40":
objContactMaster.CustomField40 = contact[column.ColumnName].ToString();
break;
case "CustomField41":
objContactMaster.CustomField41 = contact[column.ColumnName].ToString();
break;
case "CustomField42":
objContactMaster.CustomField42 = contact[column.ColumnName].ToString();
break;
case "CustomField43":
objContactMaster.CustomField43 = contact[column.ColumnName].ToString();
break;
case "CustomField44":
objContactMaster.CustomField44 = contact[column.ColumnName].ToString();
break;
case "CustomField45":
objContactMaster.CustomField45 = contact[column.ColumnName].ToString();
break;
case "CustomField46":
objContactMaster.CustomField46 = contact[column.ColumnName].ToString();
break;
case "CustomField47":
objContactMaster.CustomField47 = contact[column.ColumnName].ToString();
break;
case "CustomField48":
objContactMaster.CustomField48 = contact[column.ColumnName].ToString();
break;
case "CustomField49":
objContactMaster.CustomField49 = contact[column.ColumnName].ToString();
break;
case "CustomField50":
objContactMaster.CustomField50 = contact[column.ColumnName].ToString();
break;
}
}
}
#endregion
objContactMaster.IsActive = true;
objContactMaster.InsertWithDefaultValues(true);
Int64 ContactId = Convert.ToInt64(objContactMaster.ContactId);
// ContactIds = ContactIds + ContactId + ",";
if (!contatcInfo.ContainsKey(ContactId))
{
contatcInfo.Add(ContactId, "");
validEmailIds = validEmailIds + contact["EmailAddress"].ToString() + ";";
}
else
duplicateEmailids = duplicateEmailids + contact["EmailAddress"].ToString() + ";";
}
catch (Exception ex)
{
str.Append("<Error>Add New Contact: Problem at adding contact</Error>");
Logger.logdata(logforRpService, "Add New Contact: " + ex.Message);
}
}
}
unDeleverdInfo.Append("</UndeliveredList>");
}
try
{
if (str.ToString().IndexOf("<Error>") == -1 && contatcInfo.Count > 0)
{
listMaster = new ListMasterBase(ConnectionString);
listMaster.ListName = "TL_" + DateTime.Now.ToString("yyyy.MM.dd HH:mm:ss");
listMaster.CreatedDate = System.DateTime.Now;
listMaster.InsertWithDefaultValues(true);
listid = Convert.ToInt64(listMaster.ListMasterID);
Logger.logdata(logforRpService, "List Created,ListID = " + listid + "; ListName=" + listMaster.ListName);
//ContactIds = ContactIds.Substring(0, ContactIds.Length - 1);
//string[] selectContact = ContactIds.Split(',');
if (listid > 0)
{
DataTable dtListContactMaster = new DataTable();
dtListContactMaster.Columns.Add(new DataColumn("ListMasterID", typeof(string)));
dtListContactMaster.Columns.Add(new DataColumn("ContactId", typeof(string)));
dtListContactMaster.Columns.Add(new DataColumn("CreatedDate", typeof(string)));
dtListContactMaster.Columns.Add(new DataColumn("ModifiedDate", typeof(string)));
dtListContactMaster.Columns.Add(new DataColumn("IsActive", typeof(bool)));
StringBuilder strbAddedContacts = new StringBuilder();
foreach (DictionaryEntry item in contatcInfo)
{
DataRow rowListContactMaster = dtListContactMaster.NewRow();
rowListContactMaster["ListMasterID"] = listid;
rowListContactMaster["ContactId"] = item.Key;
rowListContactMaster["CreatedDate"] = DateTime.Now.ToString();
rowListContactMaster["ModifiedDate"] = DateTime.Now.ToString();
rowListContactMaster["IsActive"] = true;
dtListContactMaster.Rows.Add(rowListContactMaster);
}
string[] SourceColumn = new[] { "ListMasterID", "ContactId", "CreatedDate", "ModifiedDate", "IsActive" };
string[] DestinationColumn = new[] { "ListMasterID", "ContactId", "CreatedDate", "ModifiedDate", "IsActive" };
ListContactMaster.BulkCopy(dtListContactMaster, "ListContactMaster", SourceColumn, DestinationColumn, ConnectionString);
Logger.logdata(logforRpService, "Added Given Contacts to Created List(ListId :" + listid + ")");
}
}
}
catch (Exception ex)
{
str.Append("<Error>List: Problem at ListCreation contact</Error>");
Logger.logdata(logforRpService, "List: " + ex.Message);
}
#endregion
try
{
if (str.ToString().IndexOf("<Error>") == -1)
{
MembershipUser objMembershipUser = Membership.GetUser(UserID);
ProfileBase objProfileBase = ProfileBase.Create(UserID, true);
CampaignMaster objCampaignMaster = new CampaignMaster(ConnectionString);
objCampaignMaster.CampaignName = MailingName;
objCampaignMaster.CampaignDescription = "";
objCampaignMaster.FromAddress = FromAddress;
objCampaignMaster.FromName = FromName;
objCampaignMaster.ReplytoAddress = "";
objCampaignMaster.ReplaytoName = "";
objCampaignMaster.Subject = Subject;
objCampaignMaster.TrackReads = true;//"1";
objCampaignMaster.SelectCondition = listid.ToString();
objCampaignMaster.TemplateId = 0;
objCampaignMaster.ModifiedDate = DateTime.Now;
objCampaignMaster.CreatedDate = DateTime.Now;
objCampaignMaster.HTMLContent = "";
objCampaignMaster.TextContent = "";
objCampaignMaster.SuppressDomain = "";
objCampaignMaster.UnsubscribeText = "If you no longer wish to receive these emails, simply click on the following link:";
objCampaignMaster.UnsubscribeLinkText = "Unsubscribe";
objCampaignMaster.SuppressSelection = "";
objCampaignMaster.htmlHasUnsubLink = false;
objCampaignMaster.txtHasUnsubLink = false;
objCampaignMaster.AssignedCampaignID = 0;
Int64 campaignMasterID = objCampaignMaster.insertCampainMaster(objCampaignMaster);
Logger.logdata(logforRpService, "Mailing Inserted Successfully(Mailing Id:" + campaignMasterID + ")");
if (campaignMasterID > 0)
{
CampaignJob objCampaignJob = new CampaignJob(ConnectionString);
objCampaignJob.CampaignMasterID = campaignMasterID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = DateTime.Now;
objCampaignJob.SendType = "IMMEDIATE";
objCampaignJob.Status = 5;
objCampaignJob.Insert();
}
str.Append("<Message>Mailing Inserted Succefully</Message>");
str.Append("<MailingId>" + campaignMasterID.ToString() + "</MailingId>");
str.Append("<MailingName>" + MailingName + "</MailingName>");
str.Append("<ListID>" + listid + "</ListID>");
}
else
{
str.Append("<Message>Mailing Sending Failed</Message>");
Logger.logdata(logforRpService, "Mailing Sending Failed");
}
}
catch (Exception ex)
{
str.Append("<Message>Mailing Sending Failed,Problem At Scheduling The Mailing</Message>");
Logger.logdata(logforRpService, "Mailing Sending Failed:" + ex.Message);
}
}
}
else
{
str.Append("<Message>Please Enter Mailing Name and Ensure Mailing List File Is Not Empty</Message>");
Logger.logdata(logforRpService, "Empty Mailing Not Accepted and Ensure Mailing List File Is Not Empty");
}
}
else
{
str.Append("<Message>No Email Address Field Found in Targeted List</Message>");
Logger.logdata(logforRpService, "No Email Address Field Found in Targeted List");
}
}
else
{
str.Append("<Message>Please Enter Valid UserName and Password</Message>");
Logger.logdata(logforRpService, "Invalid UserName or Password");
}
str.Append(unDeleverdInfo);
str.Append("</MailingInfo>");
doc.LoadXml(str.ToString());
return doc;
}
public XmlDocument AddMailing(string UserID, string Password, string MailingName, string FromAdd, string FromName, string ReplyEmailAdd, string Subject, int TempId, string ListIds, DateTime LaunchDateTime)
{
XmlDocument doc = new System.Xml.XmlDocument();
StringBuilder str = new StringBuilder();
str.Append("<MailingInfo>");
string ConnectionString = GetConnectionString(UserID, Password);
if (ConnectionString.Trim().Length != 0)
{
if (IsValidEmail(FromAdd) && IsValidEmail(ReplyEmailAdd) && MailingName.Trim().Length != 0 && FromAdd.Trim().Length != 0 && FromName.Trim().Length != 0 && Subject.Trim().Length != 0 && ReplyEmailAdd.Trim().Length != 0 && TempId != 0 && ListIds.Trim().Length != 0 && LaunchDateTime != null)
{
CampaignMasters camp = CampaignMaster.SelectByField("CampaignName", MailingName, ConnectionString);
if (camp.Count > 0)
{
str.Append("<MailingId>" + camp[0].CampaignId.ToString() + "</MailingId>");
str.Append("<Message>Mailing Name Allredy Exist</Message>");
}
else
{
TemplateMasterPrimaryKey pk = new TemplateMasterPrimaryKey(TempId);
TemplateMaster tempMaster = TemplateMaster.SelectOne(pk, ConnectionString);
if (tempMaster != null)
{
CampaignMaster objCampaignMaster = new CampaignMaster(ConnectionString);
objCampaignMaster.CampaignName = MailingName;
objCampaignMaster.CampaignDescription = "";
objCampaignMaster.FromAddress = FromAdd;
objCampaignMaster.FromName = FromName;
objCampaignMaster.ReplytoAddress = ReplyEmailAdd;
objCampaignMaster.ReplaytoName = "";
objCampaignMaster.Subject = Subject;
objCampaignMaster.TrackReads = true;//"1";
objCampaignMaster.SelectCondition = ListIds;
objCampaignMaster.TemplateId = TempId;
objCampaignMaster.ModifiedDate = DateTime.Now;
objCampaignMaster.CreatedDate = DateTime.Now;
objCampaignMaster.HTMLContent = tempMaster.HTMLContent;
objCampaignMaster.TextContent = "";
objCampaignMaster.SuppressDomain = "";
objCampaignMaster.UnsubscribeText = "If you no longer wish to receive these emails, simply click on the following link:";
objCampaignMaster.UnsubscribeLinkText = "Unsubscribe";
objCampaignMaster.SuppressSelection = "";
objCampaignMaster.htmlHasUnsubLink = true;
objCampaignMaster.txtHasUnsubLink = true;
objCampaignMaster.AssignedCampaignID = 0;
Int64 campaignMasterID = objCampaignMaster.insertCampainMaster(objCampaignMaster);
if (campaignMasterID > 0)
{
CampaignJob objCampaignJob = new CampaignJob(ConnectionString);
objCampaignJob.CampaignMasterID = campaignMasterID;
objCampaignJob.CreatedDatetime = DateTime.Now;
objCampaignJob.ScheduledDatetime = LaunchDateTime.AddMinutes(2);// DateTime.Now.AddMinutes(2);//Convert.ToDateTime(LaunchDateTime);
objCampaignJob.SendType = "IMMEDIATE";
objCampaignJob.Status = 1;
objCampaignJob.Insert();
}
str.Append("<MailingId>" + campaignMasterID.ToString() + "</MailingId>");
str.Append("<Message>Mailing Inserted Succefully</Message>");
}
else
{
str.Append("<Error>Enter Valid TemplateId</Error>");
}
}
}
else
{
str.Append("<Error>Please Enter Valid Email Addresses and Ensure All The Fields are not empty</Error>");
}
}
else
str.Append("<Message>Please Enter Valid UserName and Password</Message>");
str.Append("</MailingInfo>");
doc.LoadXml(str.ToString());
return doc;
}