protected void BindCampaignName() { try { CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable dtCampaignname = objCampaignJob.getAllCampaignsWithStatus(ConnectionString, "CreatedDate", "DESC", 1); ddlCampaignName.DataSource = dtCampaignname; ddlCampaignName.DataTextField = CampaignMasterFields.CampaignName; ddlCampaignName.DataValueField = CampaignMasterFields.CampaignId; ddlCampaignName.DataBind(); //add default list item as first item ddlCampaignName.Items.Insert(0, defaultListItem); if (Session["CampaignID"] != null) { CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(Session["CampaignID"])); objCampaignMaster = CampaignMaster.SelectOneWithCampaignJobUsingCampaignMasterID(pk, ConnectionString); if (ddlCampaignName.Items.FindByValue(objCampaignMaster.CampaignId.ToString()) != null) { ddlCampaignName.Items.FindByValue(objCampaignMaster.CampaignId.ToString()).Selected = true; } } } catch (Exception ex) { throw ex; } }
public void bindGrid(string fillflag, int pageIndex) { try { string sortdir = (fillflag == "sort" ? GetSortDirection() : GridViewSortDirection); CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable campaignJobs = new DataTable(); campaignJobs = objCampaignJob.getAllSentCampaignsByDateRange(ConnectionString, txtStartDate.Text, txtEndDate.Text, GridSortExpression, sortdir, pageIndex, 10, out rowCount, out targetedCount, out sentCount, out bounceCount); RgrdSentCampaigns.VirtualItemCount = rowCount; lblBounces.Text = bounceCount.ToString(); lblcampaignsent.Text = rowCount.ToString(); lblContactsTargeted.Text = targetedCount.ToString(); lblSuccessfulDeliveries.Text = sentCount.ToString(); RgrdSentCampaigns.CurrentPageIndex = pageIndex; RgrdSentCampaigns.DataSource = campaignJobs; RgrdSentCampaigns.DataBind(); GridPrevSortExpression = GridSortExpression; if (campaignJobs.Rows.Count == 0) { lblMsg.Text = "No Records Found in given Date Range!"; } } catch (Exception ex) { throw ex; } }
//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 void bindGrid(int pageIndex,int assignId) { CampaignJob objCampJobs = new CampaignJob(ConnectionString);//long totalMailings=-1,totalOpens = -1, totalClicks = -1, totalSubmits = -1; DataTable dtRecs = objCampJobs.getAllSentMailingsByCampId_PageWise(ConnectionString, "CreatedDate", "desc", assignId, pageIndex, 10,out totalMailings, out totalOpens, out totalClicks, out totalSubmits); RgrdSentCampaigns.CurrentPageIndex = pageIndex; RgrdSentCampaigns.VirtualItemCount =Convert.ToInt32(totalMailings); RgrdSentCampaigns.DataSource = dtRecs; RgrdSentCampaigns.DataBind(); lblMailingCount.Text = totalMailings.ToString(); lblOpenCount.Text = totalOpens.ToString(); lblTotalClicks.Text = totalClicks.ToString(); lblTotalSubmits.Text =totalSubmits.ToString(); }
public void insertCampainJobUpdateCampaignMaster(CampaignMaster objCampaignMaster, string ScheduledTime, int CampaignMasterID) { //int CampaignMasterID = insertCampainMaster(objCampaignMaster); if (CampaignMasterID != 0) { CampaignJob objCampaignJob = new CampaignJob(ConnectionString); //objCampaignJob.CampaignMasterID = CampaignMasterID; //objCampaignJob.CreatedDatetime = DateTime.Now; objCampaignJob.ScheduledDatetime = Convert.ToDateTime(ScheduledTime); //objCampaignJob.ModifiedDate = Convert.ToDateTime(DateTime.Now); //objCampaignJob.Status = 1; objCampaignJob.Update(); } }
public void bindGrid(string fillflag, int pageIndex, string ConnectionString) { try { string sortdir = (fillflag == "sort" ? GetSortDirection() : GridViewSortDirection); CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable FblContacts = new DataTable(); FblContacts = objCampaignJob.getAllFblContactsByDateClient_Pagewise(ConnectionString, GridSortExpression, sortdir, pageIndex, 10, out rowCount); RgrdFblRecipients.CurrentPageIndex = pageIndex; RgrdFblRecipients.DataSource = FblContacts; RgrdFblRecipients.VirtualItemCount = rowCount; RgrdFblRecipients.DataBind(); GridPrevSortExpression = GridSortExpression; if (FblContacts.Rows.Count == 0) lblMsg.Text = "No Records Found in given Date Range!"; } catch (Exception ex) { throw ex; } }
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 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; }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of CampaignJobs</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 2/3/2010 4:14:00 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static CampaignJobs PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper, string ConnectionString) { CampaignJobs list = new CampaignJobs(); if (rdr.Read()) { CampaignJob obj = new CampaignJob(ConnectionString); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new CampaignJob(ConnectionString); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return list; } else { oDatabaseHelper.Dispose(); return null; } }
protected void ddlCampaignsNames_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCampaignsNames.SelectedItem.Text != defaultListItem) { try { CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable dtMailingNames = objCampaignJob.getAllMailingsWithStatusCampaignID(ConnectionString, "CreatedDate", "DESC", 1, Convert.ToInt32(ddlCampaignsNames.SelectedItem.Value)); ddlMailingNames.DataSource = dtMailingNames; ddlMailingNames.DataTextField = CampaignMasterFields.CampaignName; ddlMailingNames.DataValueField = CampaignMasterFields.CampaignId; ddlMailingNames.DataBind(); //add default list item as first item ddlMailingNames.Items.Insert(0, defaultListItem); Session["CampId"] = ddlCampaignsNames.SelectedValue; hdfCampaignID.Value = ddlCampaignsNames.SelectedValue.ToString(); lblCampaignTitle.Text = ddlCampaignsNames.SelectedItem.Text.ToString().Trim(); Session["TitleName"] = lblCampaignTitle.Text; #region Bellow Region to Clear the PrivousChart and Counts lblsentDateTime.Text = string.Empty; Session["MailingID"] = null; hdfMailingID.Value = ""; bindReport(); #endregion } catch (Exception ex) { throw ex; } } else { #region Bellow Region to Clear the PrivousChart and Counts lblCampaignTitle.Text = string.Empty; lblsentDateTime.Text = string.Empty; lblTotalBounces.Text = "0"; lblSoftBounces.Text = "0"; lblHardBounces.Text = "0"; lblTotalopens.Text = "0"; lbluniqueopens.Text = "0"; lblTotalClicks.Text = "0"; lbluniqueclicks.Text = "0"; lblNeverOptedintoList.Text = "0"; lblToofreequentCommunication.Text = "0"; lblNotinsertedinmaterial.Text = "0"; lblOther.Text = "0"; Session["CampId"] = null; Session["MailingID"] = null; bindMailingNames(); ddlMailingNames.SelectedIndex = 0; hdfMailingID.Value = string.Empty; hdfCampaignID.Value = string.Empty; bindReport(); #endregion } }
protected void btnForward_Click(object sender, EventArgs e) { try { //get campaign details if (lblSendersEmail.Text != "") { CampaignMasterPrimaryKey objCampaignMasterPrimaryKey = new CampaignMasterPrimaryKey(Convert.ToInt64(Request.QueryString["CampaignID"])); CampaignMaster objCampaignMaster = CampaignMaster.SelectOneWithCampaignJobUsingCampaignMasterID(objCampaignMasterPrimaryKey, clientConnectionString); //templateID = Convert.ToInt64(objCampaignMaster.TemplateId); htmlContent =txtCustomMessage.Value+objCampaignMaster.HTMLContent; //build datatable from the recipients grid. DataTable dtRecipeintsForwarded = buildDatatableOfRecipientsGrid(userAgent, ipAddress, campaignID, contactID); ProcessSingleEmailMessageJob(dtRecipeintsForwarded, objCampaignMaster.Subject.ToString()); //Bul insert forward details to ForwardDetails table and insert forward count in campaignjob table. CampaignJob objCampaignJob = new CampaignJob(clientConnectionString); string ForwardXmlString = buildXmlFromDatatable(dtRecipeintsForwarded, "ForwardDetails"); objCampaignJob.InsertForwardDetails(Convert.ToInt64(objCampaignMaster.CampaignId), ForwardXmlString, dtRecipeintsForwarded.Rows.Count, clientConnectionString); divMain.InnerHtml = "Successfully forwarded email to recipients."; } } catch (Exception ex) { throw ex; } }
protected void ddlCampaignsNames_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCampaignsNames.SelectedItem.Text != defaultCampItem) { try { lblCampaignTitle.Text = ddlCampaignsNames.SelectedItem.Text; CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable dtMailingNames = objCampaignJob.getAllMailingsWithStatusCampaignID(ConnectionString, "CompletionTime", "DESC", 1, Convert.ToInt32(ddlCampaignsNames.SelectedItem.Value)); ddlMailingNames.DataSource = dtMailingNames; ddlMailingNames.DataTextField = CampaignMasterFields.CampaignName; ddlMailingNames.DataValueField = CampaignMasterFields.CampaignId; ddlMailingNames.DataBind(); ddlMailingNames.Items.Insert(0, defaultMailingItem); Session["CampId"] = ddlCampaignsNames.SelectedValue; hdfCampaignID.Value = ddlCampaignsNames.SelectedValue.ToString(); #region Bellow Region to Clear the PrivousChart and Counts lblsentDateTime.Text = string.Empty; lblSelectedList.Text = string.Empty; lblSubject.Text = string.Empty; Session["MailingID"] = null; Session["ContactsTargeted"] = null; hdfMailingID.Value = string.Empty; SingleMailingCounts(hdfCampaignID.Value, hdfMailingID.Value); #endregion } catch (Exception ex) { throw ex; } } else { Session["CampId"] = null; Session["MailingID"] = null; bindMailingNames(); ddlMailingNames.SelectedIndex = 0; hdfMailingID.Value = string.Empty; hdfCampaignID.Value = string.Empty; SingleMailingCounts(hdfCampaignID.Value, hdfMailingID.Value); } }
private void buildSegmentFromCampaigns(string fillFlag, int pageIndex) { string sortdir = (fillFlag == "sort" ? GetSortDirection() : GridViewSortDirection); if (flagreset == true) { sortdir = "ASC"; GridSortExpression = "CreatedDate"; } CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable campaignJobs = new DataTable(); campaignJobs = objCampaignJob.getAllSentCampaignsForCampaignSegment(ConnectionString, GridSortExpression, sortdir, 4); rgdCampaignSegment.DataSource = campaignJobs; rgdCampaignSegment.CurrentPageIndex = pageIndex; rgdCampaignSegment.DataBind(); lblCampMember.Text = ""; lblCampasSelected.Text = ""; divLists.Style.Add("display", "none"); divListFiletr.Style.Add("display", "none"); divCampaigns.Style.Add("display", "block"); divCampaignFilter.Style.Add("display", "none"); }
protected void bindClienInfo(string cName) { if (ddlClients.SelectedIndex > 0) { MembershipUser objMembershipUser = Membership.GetUser(cName); ProfileBase objProfileBase = ProfileBase.Create(cName, true); StringBuilder clientInfo = new StringBuilder(); clientInfo.AppendLine(objProfileBase.GetPropertyValue("FName").ToString() + " " + objProfileBase.GetPropertyValue("LName").ToString()); clientInfo.AppendLine(objProfileBase.GetPropertyValue("Address").ToString()); clientInfo.AppendLine(objProfileBase.GetPropertyValue("State").ToString()); clientInfo.AppendLine(objProfileBase.GetPropertyValue("Country").ToString() + "-" + objProfileBase.GetPropertyValue("PostalCode").ToString()); clientInfo.AppendLine(objMembershipUser.Email.ToString()); clientEmail = objMembershipUser.Email.ToString(); txtClientInfo.Text = clientInfo.ToString(); string dbName = objProfileBase.GetPropertyValue("DBName").ToString(); string dbUserID = objProfileBase.GetPropertyValue("DBUserID").ToString(); string dbPassword = objProfileBase.GetPropertyValue("DBPassword").ToString(); string dbServerName = objProfileBase.GetPropertyValue("DBServerName").ToString(); string ConString = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3};Pooling=True", dbServerName, dbName, dbUserID, dbPassword); CampaignJob objCampaignJob = new CampaignJob(ConString); DataTable campaignJobs = new DataTable(); campaignJobs = objCampaignJob.getAllSentCampaignsByDateRange(ConString, Convert.ToDateTime(calExSDate.SelectedDate.ToString()).ToShortDateString(), Convert.ToDateTime(calExEDate.SelectedDate.ToString()).ToShortDateString(), "CreatedDate", "desc", 0, 10, out rowCount, out targetedCount, out sentCount, out bounceCount); lblnoofemailsent.Text = targetedCount.ToString(); double amount = Math.Round(Convert.ToDouble(lblnoofemailsent.Text.ToString()) * Convert.ToDouble(lblprice.Text), 2); lblamount.Text = amount.ToString(); lbltotal.Text = amount.ToString(); if (amount > 0) { double discountAmt = 0.0; double taxAmt = 0.0; double gAmt = 0.0; if (txtdiscount.Text != string.Empty && txtTax.Text != string.Empty) { discountAmt = amount - Convert.ToDouble(txtdiscount.Text); lblamtdiscount.Text = discountAmt.ToString(); taxAmt = Math.Round((Convert.ToDouble(discountAmt.ToString()) * Convert.ToDouble(txtTax.Text.ToString())) / 100, 2); lblamttax.Text = taxAmt.ToString(); gAmt = Math.Round(discountAmt + taxAmt, 2); lblgrandtotal.Text = gAmt.ToString(); } } else clearValues(); pnlControls.Controls.Clear(); pnlAmount.Controls.Clear(); hdDynamicAmt.Value = "0"; for (int i = 1; i <= tblDesc.Rows.Count && i <= tblAmount.Rows.Count; i++) { tblDesc.Rows[i - 1].Style["display"] = "none"; tblAmount.Rows[i - 1].Style["display"] = "none"; pnlControls.Controls.Add(tblDesc); pnlAmount.Controls.Add(tblAmount); Session["tableDesc"] = tblDesc; Session["tableAmount"] = tblAmount; TextBox txtAmount = (TextBox)this.FindControlRecursive(this, "txtAmt" + i.ToString()); if (txtAmount != null) txtAmount.Text = string.Empty; } } }
public void bindGrid(string fillflag, int pageIndex) { try { string sortdir = (fillflag == "sort" ? GetSortDirection() : GridViewSortDirection); CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable campaignJobs = new DataTable(); if (hdfDraft.Value == "0" && hdSummaryValueChecker.Value == "0") { lbtnDraft.CssClass = "selected"; lbtnSent.CssClass = "button-tab"; RDraft.Style.Add("display", "Block"); Rsent.Style.Add("display", "None"); campaignJobs = objCampaignJob.getAllDraftSentCampaignsWithFilter_StatusName(ConnectionString, GridSortExpression, sortdir, 0, pageIndex, 10, out rowCount); RGridPendingMails.CurrentPageIndex = pageIndex; RGridPendingMails.VirtualItemCount = rowCount; RGridPendingMails.DataSource = campaignJobs; RGridPendingMails.DataBind(); } else { lbtnDraft.CssClass = "button-tab"; lbtnSent.CssClass = "selected"; RDraft.Style.Add("display", "None"); Rsent.Style.Add("display", "Block"); campaignJobs = objCampaignJob.getAllDraftSentCampaignsWithFilter_StatusName(ConnectionString, GridSortExpression, sortdir, 1, pageIndex, 10, out rowCount); RgrdSentCampaigns.CurrentPageIndex = pageIndex; RgrdSentCampaigns.VirtualItemCount = rowCount; RgrdSentCampaigns.DataSource = campaignJobs; RgrdSentCampaigns.DataBind(); hdSummaryValueChecker.Value = "0"; hdSummaryValue.Value = "1"; } campaignJobs.AsEnumerable().ToList().ForEach(delegate(DataRow row) { if (row["CampaignName"].ToString().Contains("""))row["CampaignName"] = Server.HtmlEncode(row["CampaignName"].ToString()); }); GridPrevSortExpression = GridSortExpression; } catch (Exception ex) { throw ex; } }
//Anwar 23rd Jan,2012 protected void ddlCampaignsNames_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCampaignsNames.SelectedItem.Text != defaultListItem) { try { CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable dtMailingNames = objCampaignJob.getAllMailingsWithStatusCampaignID(ConnectionString, "CreatedDate", "DESC", 1, Convert.ToInt32(ddlCampaignsNames.SelectedItem.Value)); ddlMailingNames.DataSource = dtMailingNames; ddlMailingNames.DataTextField = CampaignMasterFields.CampaignName; ddlMailingNames.DataValueField = CampaignMasterFields.CampaignId; ddlMailingNames.DataBind(); //add default list item as first item ddlMailingNames.Items.Insert(0, defaultListItem); lblCampaignTitle.Text = ddlCampaignsNames.SelectedItem.Text.ToString().Trim(); Session["TitleName"] = lblCampaignTitle.Text; Session["CampId"] = ddlCampaignsNames.SelectedValue; hdfCampaignID.Value = ddlCampaignsNames.SelectedValue.ToString(); lblsentDateTime.Text = string.Empty; Session["MailingID"] = null; hdfMailingID.Value = ""; bindGrid(); } catch (Exception ex) { throw ex; } } else { lblCampaignTitle.Text = string.Empty; lblsentDateTime.Text = string.Empty; Session["TitleName"] = null; Session["SentDateTime"] = null; bindMailingNames(); ddlMailingNames.SelectedIndex = 0; Session["CampId"] = null; Session["MailingID"] = null; bindGrid(); } }
private void buildSentMailings(string fillFlag, int pageIndex) { string sortdir = (fillFlag == "sort" ? GetSortDirection() : GridViewSortDirection); if (flagreset == true) { sortdir = "desc"; GridSortExpression = "CreatedDate"; } CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable campaignJobs = new DataTable(); campaignJobs = objCampaignJob.getAllSentCampaignsForCampaignSegment(ConnectionString, GridSortExpression, sortdir, 4); rgdCampaignCompare.DataSource = campaignJobs; rgdCampaignCompare.CurrentPageIndex = pageIndex; rgdCampaignCompare.DataBind(); lblCampMember.Text = ""; lblCampasSelected.Text = ""; }
protected void imgbtnExport_Click(object sender, ImageClickEventArgs e) { try { DataTable table; Export Export = new Export("Web"); CampaignJob objCampaignJob = new CampaignJob(ConnectionString); table = objCampaignJob.getAllSentCampaignsByDateRangeDownload(ConnectionString, HttpContext.Current.Request.QueryString["StartDate"].ToString(), HttpContext.Current.Request.QueryString["EndDate"].ToString()); int[] columns = new int[table.Columns.Count]; if (table.Rows.Count != 0) { for (int i = 0; i < table.Columns.Count; i++) { columns[i] = i; } } if (dpExport.SelectedValue.Equals("CSV")) Export.ExportDetails(table, columns, Export.ExportFormat.CSV, "AdminActivityReport_" + DateTime.Now.ToShortDateString() + ".csv"); else if (dpExport.SelectedValue.Equals("Excel")) Export.ExportDetails(table, columns, Export.ExportFormat.Excel, "AdminActivityReport_" + DateTime.Now.ToShortDateString() + ".xls"); else if (dpExport.SelectedValue.Equals("Text")) { Export.ExportDetails(table, Export.ExportFormat.Text, "AdminActivityReport_" + DateTime.Now.ToShortDateString() + ".txt"); } else ExportToPDF(table, "AdminActivityReport_" + DateTime.Now.ToShortDateString() + ".pdf"); } catch (Exception ex) { throw ex; } }
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 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; }
protected void imgbtnExport_Click(object sender, ImageClickEventArgs e) { try { string userName = HttpContext.Current.Request.QueryString["UserName"].ToString(); string TabName = string.Empty; DataTable table = new DataTable(); Export Export = new Export("Web"); #region download using Dll CampaignJob objCampaignJob = new CampaignJob(ConnectionString); table = objCampaignJob.getAllFblContactsByDateClient(ConnectionString); if (dpExport.SelectedValue.Equals("CSV")) Export.ExportDetails(table, Export.ExportFormat.CSV, userName + "_" + DateTime.Now.ToShortDateString() + ".csv"); else if (dpExport.SelectedValue.Equals("Excel")) Export.ExportDetails(table, Export.ExportFormat.Excel, userName + "_" + DateTime.Now.ToShortDateString() + ".xls"); else if (dpExport.SelectedValue.Equals("Text")) { Export.ExportDetails(table, Export.ExportFormat.Text, userName + "_" + DateTime.Now.ToShortDateString() + ".txt"); } else ExportToPDF(table, TabName + "_" + userName + "_" + DateTime.Now.ToShortDateString() + ".pdf"); #endregion } catch (Exception ex) { throw ex; } }
protected void bindMialingNameswithSeletedCamp() { CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable dtMailingNames = objCampaignJob.getAllMailingsWithStatusCampaignID(ConnectionString, "CreatedDate", "DESC", 1, Convert.ToInt32(Session["CampId"].ToString())); ddlMailingNames.DataSource = dtMailingNames; ddlMailingNames.DataTextField = CampaignMasterFields.CampaignName; ddlMailingNames.DataValueField = CampaignMasterFields.CampaignId; ddlMailingNames.DataBind(); //add default list item as first item ddlMailingNames.Items.Insert(0, defaultListItem); if (Session["MailingID"] != null) ddlMailingNames.Items.FindByValue(Session["MailingID"].ToString()).Selected = true; }
public XmlDocument GetAllMailings(string UserID, string Password) { XmlDocument doc = new System.Xml.XmlDocument(); StringBuilder str = new StringBuilder(); str.Append("<CampaignInfo>"); string ConnectionString = GetConnectionString(UserID, Password); if (ConnectionString.Trim().Length != 0) { CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable campaignDt = new DataTable(); campaignDt = objCampaignJob.getAllCampaigns(ConnectionString, "CreatedDate", "asc"); if (campaignDt != null) { for (int i = 0; i < campaignDt.Rows.Count; i++) { str.Append("<Campaign Row=\"" + i.ToString() + "\"> "); str.Append("<CampaignId>" + campaignDt.Rows[i]["CampaignId"].ToString() + "</CampaignId> "); str.Append("<CampaignName>" + Server.HtmlEncode(campaignDt.Rows[i]["CampaignName"].ToString()) + "</CampaignName>"); str.Append("<CampaignStatus>" + campaignDt.Rows[i]["Status"].ToString() + "</CampaignStatus>"); str.Append("<CampaignCreatedDatetime>" + campaignDt.Rows[i]["CreatedDatetime"].ToString() + "</CampaignCreatedDatetime>"); str.Append("<CampaignScheduledDatetime>" + campaignDt.Rows[i]["ScheduledDatetime"].ToString() + "</CampaignScheduledDatetime>"); str.Append("<CampaignDeliveredCount>" + campaignDt.Rows[i]["DeliveredCount"].ToString() + "</CampaignDeliveredCount>"); str.Append("<CampaignBounceCount>" + campaignDt.Rows[i]["BounceCount"].ToString() + "</CampaignBounceCount>"); if (!string.IsNullOrEmpty(campaignDt.Rows[i]["SelectCondition"].ToString())) { string[] arrList = campaignDt.Rows[i]["SelectCondition"].ToString().Split(','); foreach (string arr in arrList) { ListMasterPrimaryKey listpk = new ListMasterPrimaryKey(Convert.ToInt64(arr)); ListMaster listMaster = ListMaster.SelectOne(listpk, ConnectionString); if (listMaster != null) { str.Append("<ListId>" + listMaster.ListMasterID.ToString() + "</ListId>"); str.Append("<ListName>" + Server.HtmlDecode(listMaster.ListName.ToString() + "</ListName>")); } } } str.Append("<Errormessage></Errormessage>"); str.Append("</Campaign>"); string ss = str.ToString(); } } else { str.Append("<Message> Please Enter Valid Inputs</Message>"); } } str.Append("</CampaignInfo>"); doc.LoadXml(str.ToString()); return doc; }
internal static CampaignJobs PopulateObjectsFromReaderNew(IDataReader rdr, string ConnectionString) { CampaignJobs list = new CampaignJobs(); while (rdr.Read()) { CampaignJob obj = new CampaignJob(ConnectionString); PopulateObjectFromReaderNew(obj, rdr); list.Add(obj); } return list; }
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"); } }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="CampaignJobPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class CampaignJob</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 2/3/2010 4:14:00 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static CampaignJob SelectOne(CampaignJobPrimaryKey pk, String ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // Pass the values of all key parameters to the stored procedure. System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues(); foreach (string key in nvc.Keys) { oDatabaseHelper.AddParameter("@" + key,nvc[key] ); } // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("sp_CampaignJob_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { CampaignJob obj=new CampaignJob(ConnectionString); PopulateObjectFromReader(obj,dr); dr.Close(); oDatabaseHelper.Dispose(); return obj; } else { dr.Close(); oDatabaseHelper.Dispose(); return null; } }
protected void ddlCampaignsNames_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCampaignsNames.SelectedItem.Text != defaultListItem) { try { CampaignJob objCampaignJob = new CampaignJob(ConnectionString); DataTable dtMailingNames = objCampaignJob.getAllMailingsWithStatusCampaignID(ConnectionString, "CreatedDate", "DESC", 1, Convert.ToInt32(ddlCampaignsNames.SelectedItem.Value)); ddlMailingNames.DataSource = dtMailingNames; ddlMailingNames.DataTextField = CampaignMasterFields.CampaignName; ddlMailingNames.DataValueField = CampaignMasterFields.CampaignId; ddlMailingNames.DataBind(); //add default list item as first item ddlMailingNames.Items.Insert(0, defaultListItem); Session["CampId"] = ddlCampaignsNames.SelectedValue; hdfCampaignID.Value = ddlCampaignsNames.SelectedValue.ToString(); lblCampaignTitle.Text = ddlCampaignsNames.SelectedItem.Text.ToString().Trim(); Session["TitleName"] = lblCampaignTitle.Text; #region Bellow Region to Clear the PrivousChart and Counts lblsentDateTime.Text = string.Empty; Session["MailingID"] = null; hdfMailingID.Value = ""; bindRecipientDomainsCount(0, "Targeted"); rgdAdvanced.Rebind(); bindChartDomainsCount("Targeted"); #endregion chartAdvanced.Titles[0].Text = "Domains Targeted"; } catch (Exception ex) { throw ex; } } else { bindMailingNames(); ddlMailingNames.SelectedIndex = 0; lblCampaignTitle.Text = string.Empty; lblsentDateTime.Text = string.Empty; Session["TitleName"] = null; Session["SentDateTime"] = null; Session["CampId"] = null; Session["MailingID"] = null; bindRecipientDomainsCount(0, "Targeted"); rgdAdvanced.Rebind(); bindChartDomainsCount("Targeted"); } }