예제 #1
0
        protected void lbtnAssigncampaigntomailing_Click(object sender, EventArgs e)
        {
            objCampaignMaster = new CampaignMaster(ConnectionString);
            if (RgrdSentCampaigns.MasterTableView.Items.Count > 0)
            {
                //Get contact Selection
                rememberContactSelectionForSent("SgrdaddchkSelectRecs", "lblSCampaignId", RgrdSentCampaigns, "Sgrdaddselectall");
                if (ViewState["SentSelectedContacts"] != null)
                {
                    StringBuilder strbEditContacts = new StringBuilder();
                    //adding selected contatIds to stringbuilder
                    for (int i = 0; i < contactsSelected.Count; i++)
                    {
                        strbEditContacts.Append(contactsSelected[i] + ", ");
                        //Bellow code is used to insert or Update assigned Campaign details in to CampaignMailing Table
                        bool mailingInstStatus = false;
                        CampaignMailingBase objCampaignMailingBase = new CampaignMailingBase(ConnectionString);
                        if (ddlCampaigns.SelectedItem.Text != defaultListItem)
                        {
                            if (objCampaignMailingBase.checkAssignedCampaignsId(Convert.ToInt64(contactsSelected[i]), ConnectionString))
                            {
                                mailingInstStatus = objCampaignMailingBase.UpdateAssignedCampaignId(Convert.ToInt64(contactsSelected[i]), (ddlCampaigns.SelectedItem.Text != defaultListItem) ? Convert.ToInt64(ddlCampaigns.SelectedItem.Value) : 0, ConnectionString);
                            }
                            else if (ddlCampaigns.SelectedItem.Text != defaultListItem)
                            {
                                CampaignMailing objCampaignMailing = new CampaignMailing(ConnectionString);
                                objCampaignMailing.CampaignId = Convert.ToInt64(contactsSelected[i]);
                                objCampaignMailing.CampaignsID = Convert.ToInt64(ddlCampaigns.SelectedItem.Value);//Mailing Id
                                objCampaignMailing.CreatedDate = DateTime.Now;
                                objCampaignMailing.ModifiedDate = DateTime.Now;
                                objCampaignMailing.IsActive = true;
                                mailingInstStatus = objCampaignMailing.Insert();
                            }
                        }
                        if (mailingInstStatus == true)
                        {
                            //get campaign details
                            CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(contactsSelected[i]));
                            objCampaignMaster = CampaignMaster.SelectOneWithCampaignJobUsingCampaignMasterID(pk, ConnectionString);

                            if (ddlCampaigns.Text != defaultListItem)
                                objCampaignMaster.AssignedCampaignID = Convert.ToInt64(ddlCampaigns.SelectedItem.Value);
                            else
                                objCampaignMaster.AssignedCampaignID = 0;

                            objCampaignMaster.UpdateCampaignDetails();
                        }

                    }
                    if (ddlCampaigns.SelectedItem.Text != defaultListItem)
                    {
                        strbEditContacts.Remove(strbEditContacts.Length - 2, 1);
                        ViewState["SentSelectedContacts"] = null;
                        hdrchkselected.Clear();
                        if (txtSentMailID.Text != string.Empty || txtSentmailSearch.Text != string.Empty)
                        {
                            SearchCriteria("", 0, 0);
                        }
                        else
                        {
                            bindGrid(string.Empty, 0);
                            bindCampNames();
                        }
                        lblMainMsg.ForeColor = System.Drawing.Color.Green;
                        lblMainMsg.Text = "Campaign to selected mailings(with ids: " + strbEditContacts.ToString() + ")assigned successfully!";
                    }
                }
            }
        }
예제 #2
0
        public void updateCampaignDetailsTab()
        {
            try
            {
                CampaignMasterPrimaryKey objCampaignMasterPrimaryKey = new CampaignMasterPrimaryKey(Convert.ToInt64(hiddenCampaignID.Value));
                objCampaignMaster = CampaignMaster.SelectOne(objCampaignMasterPrimaryKey, ConnectionString);
                DataTable campMaster = CampaignMasterBase.SelectByName("CampaignName", txtCampaignName.Text.ToString(), ConnectionString);
                if (campMaster.Rows.Count == 0)
                {
                    objCampaignMaster.CampaignName = txtCampaignName.Text;
                }
                else
                {
                    txtCampaignName.Text = objCampaignMaster.CampaignName;
                }
                objCampaignMaster.FromAddress = ddlFromAddress.SelectedItem.Text;
                objCampaignMaster.FromName = txtFromName.Text.ToString().Trim();
                objCampaignMaster.CampaignDescription = txtCampaignDescription.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.ModifiedDate = DateTime.Now;
                if (txtUnsubscribe.Text != string.Empty)
                {
                    hdUnsubscribeText.Value = lblunsubinfo.Text;
                    hdUnsubscribeLinkText.Value = lblunsublinktext.Text;
                    objCampaignMaster.UnsubscribeText = txtUnsubscribe.Text;
                    objCampaignMaster.UnsubscribeLinkText = DDLinktext.SelectedItem.Text;
                    lblunsubinfo.Text = txtUnsubscribe.Text;
                    lblunsublinktext.Text = DDLinktext.SelectedItem.Text;
                    DivUnsubtext.InnerHtml = lblunsubinfo.Text + " \n" + lblunsublinktext.Text;
                }
                //Bellow code is used to insert or Update assigned Campaign details in to CampaignMailing Table
                bool mailingInstStatus = false;
                if (hdCampMailingFlag.Value == "1")
                {
                    CampaignMailingBase objCampaignMailingBase = new CampaignMailingBase(ConnectionString);
                    if (AssCampIdDb.Value.ToString().Length != 0 && AssCampIdDb.Value != null)
                    {
                        if (objCampaignMailingBase.checkAssignedCampaignId(Convert.ToInt64(hiddenCampaignID.Value), Convert.ToInt64(AssCampIdDb.Value.ToString()), ConnectionString))
                        {
                            mailingInstStatus = objCampaignMailingBase.UpdateAssignedCampaignId(Convert.ToInt64(hiddenCampaignID.Value), (ddlCampsNames.SelectedItem.Text != defaultListItem) ? Convert.ToInt64(ddlCampsNames.SelectedItem.Value) : 0, ConnectionString);
                        }
                        else if (ddlCampsNames.SelectedItem.Text != defaultListItem)
                        {
                            CampaignMailing objCampaignMailing = new CampaignMailing(ConnectionString);
                            objCampaignMailing.CampaignId = Convert.ToInt64(hiddenCampaignID.Value);
                            objCampaignMailing.CampaignsID = Convert.ToInt64(ddlCampsNames.SelectedItem.Value);//Mailing Id
                            objCampaignMailing.CreatedDate = DateTime.Now;
                            objCampaignMailing.ModifiedDate = DateTime.Now;
                            objCampaignMailing.IsActive = true;
                            mailingInstStatus = objCampaignMailing.Insert();
                        }
                    }
                }

                if (hdCampMailingFlag.Value == "1" && mailingInstStatus == true)
                {
                    if (ddlCampsNames.Text != defaultListItem)
                        objCampaignMaster.AssignedCampaignID = Convert.ToInt64(ddlCampsNames.SelectedItem.Value);
                    else
                        objCampaignMaster.AssignedCampaignID = 0;
                    objCampaignMaster.UpdateCampaignDetails();
                }
                else
                {
                    objCampaignMaster.UpdateCampaignDetails();
                }

                checkCampaignStatus();
                hdCampDetailsTab1.Value = "0";
                lblCampName.Text = txtCampaignName.Text.Trim();
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }
예제 #3
0
        /// <summary>
        /// Populates the fields of a single objects from the columns found in an open reader.
        /// </summary>
        /// <param name="obj" type="CampaignMailing">Object of CampaignMailing to populate</param>
        /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			6/25/2012 02:05:58 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        internal static void PopulateObjectFromReader(CampaignMailingBase obj,IDataReader rdr)
        {
            obj.CampaignMailId = rdr.GetInt64(rdr.GetOrdinal(CampaignMailingFields.CampaignMailId));
            if (!rdr.IsDBNull(rdr.GetOrdinal(CampaignMailingFields.CampaignId)))
            {
                obj.CampaignId = rdr.GetInt64(rdr.GetOrdinal(CampaignMailingFields.CampaignId));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(CampaignMailingFields.CampaignsID)))
            {
                obj.CampaignsID = rdr.GetInt64(rdr.GetOrdinal(CampaignMailingFields.CampaignsID));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(CampaignMailingFields.CreatedDate)))
            {
                obj.CreatedDate = rdr.GetDateTime(rdr.GetOrdinal(CampaignMailingFields.CreatedDate));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(CampaignMailingFields.ModifiedDate)))
            {
                obj.ModifiedDate = rdr.GetDateTime(rdr.GetOrdinal(CampaignMailingFields.ModifiedDate));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(CampaignMailingFields.IsActive)))
            {
                obj.IsActive = rdr.GetBoolean(rdr.GetOrdinal(CampaignMailingFields.IsActive));
            }
        }