protected void btnDelete_Click(object sender, EventArgs e)
    {
        contact_id = Convert.ToInt32(Request.QueryString["contactID"]);
        qCom_Contact contact = new qCom_Contact(contact_id);
        contact.Available = "No";
        contact.MarkAsDelete = 1;
        contact.OKEmail = "No";
        contact.Update();

        if (Request.QueryString["edit-mode"] == "in-place")
            Response.Redirect(Request.QueryString["returnURL"]);
        else
            Response.Redirect("contacts-list.aspx");
    }
Пример #2
0
        public static bool DoesContactExist(string email)
        {
            bool contact_exists = false;

            qCom_Contact contact = new qCom_Contact();

            contact = GetContactByEmail(email);

            if (contact != null)
            {
                if (contact.ContactID > 0)
                {
                    contact_exists = true;
                }
            }
            return(contact_exists);
        }
    protected void ProcessContacts(string[] to_pass)
    {
        string mode = to_pass[0];
        string f_name = to_pass[1];
        lblFileName.Text = fileFullName;
        string fileName = string.Format("{0}{1}", Server.MapPath(Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Resources_PDFFolder"])), f_name);
        string message = string.Empty;

        if (File.Exists(fileName))
        {
            List<string[]> contacts = parseCSV(fileName);

            message = "RESULTS<br>";

            //try
            //{
                int i = 0;
                foreach (string[] c in contacts)
                {

                    string first_name = string.Empty;
                    string last_name = string.Empty;
                    string email = string.Empty;
                    string keywords = string.Empty;
                    string source = string.Empty;
                    string ok_email = string.Empty;
                    string did = string.Empty;
                    string partner = string.Empty;
                    string main_group = string.Empty;
                    string sub_group = string.Empty;
                    string custom_html_element = string.Empty;

                    first_name = c[0];
                    last_name = c[1];
                    email = c[2];
                    keywords = c[3];
                    source = c[4];
                    ok_email = c[5];
                    partner = c[6];
                    main_group = c[7];
                    sub_group = c[8];
                    custom_html_element = c[9];

                    bool success = false;
                    string reason = string.Empty;

                    if (i > 0)
                    {
                        // check to see if valid email
                        string pat = @"^([0-9a-zA-Z]+[-._+&amp;])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$";
                        Regex r = new Regex(pat, RegexOptions.IgnoreCase);

                        Match m = r.Match(email);
                        if (m.Success && mode == "process")
                        {
                            // check to see if already exists
                            qCom_Contact e_contact = qCom_Contact.GetContactByEmail(email);

                            if (e_contact != null)
                            {
                                if (e_contact.ContactID > 0)
                                {
                                    // update existing contact (except email address)
                                    string curr_keywords = e_contact.Keywords;
                                    string curr_source = e_contact.Source;
                                    e_contact.FirstName = first_name;
                                    e_contact.LastName = last_name;
                                    e_contact.Email = email;
                                    e_contact.Keywords = keywords;
                                    e_contact.Source = source;
                                    // run check to insure that OkEmail is carried over from existing record
                                    if (e_contact.OKEmail == "No")
                                        e_contact.OKEmail = "No";
                                    else
                                        e_contact.OKEmail = ok_email;
                                    e_contact.LastModified = DateTime.Now;
                                    e_contact.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                                    if (!String.IsNullOrEmpty(main_group))
                                    {
                                        int int_main_group;
                                        if (int.TryParse(main_group, out int_main_group))
                                            e_contact.MainGroup = Convert.ToInt32(int_main_group);
                                    }
                                    if (!String.IsNullOrEmpty(sub_group))
                                    {
                                        int int_sub_group;
                                        if (int.TryParse(sub_group, out int_sub_group))
                                            e_contact.SubGroup = Convert.ToInt32(int_sub_group);
                                    }
                                    e_contact.CustomHTMLElement = custom_html_element;

                                    // does a registered user with the same email exist? only perform this check if the conctact does NOT have a valid userID
                                    if (!String.IsNullOrEmpty(Convert.ToString(e_contact.UserID)) && Convert.ToString(e_contact.UserID) != "0")
                                    {
                                        qPtl_User user = new qPtl_User(email);
                                        if (user != null)
                                        {
                                            if (user.UserID > 0)
                                                e_contact.UserID = user.UserID;
                                        }
                                        else
                                            e_contact.UserID = 0;
                                    }

                                    e_contact.Update();
                                    success = true;
                                }
                            }
                            else
                            {
                                // create new contact
                                qCom_Contact n_contact = new qCom_Contact();
                                n_contact.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                                n_contact.Available = "Yes";
                                n_contact.Created = DateTime.Now;
                                n_contact.CreatedBy = Convert.ToInt32(Context.Items["UserID"]);
                                n_contact.LastModified = DateTime.Now;
                                n_contact.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                                n_contact.MarkAsDelete = 0;
                                n_contact.FirstName = first_name;
                                n_contact.LastName = last_name;
                                n_contact.Email = email;
                                n_contact.Keywords = keywords;
                                n_contact.Source = source;
                                n_contact.OKEmail = ok_email;
                                n_contact.Partner = partner;
                                n_contact.CustomHTMLElement = custom_html_element;
                                if (!String.IsNullOrEmpty(main_group))
                                {
                                    int int_main_group;
                                    if (int.TryParse(main_group, out int_main_group))
                                        n_contact.MainGroup = Convert.ToInt32(int_main_group);
                                }
                                if (!String.IsNullOrEmpty(sub_group))
                                {
                                    int int_sub_group;
                                    if (int.TryParse(sub_group, out int_sub_group))
                                        n_contact.SubGroup = Convert.ToInt32(int_sub_group);
                                }

                                // does a registered user with the same email exist?
                                qPtl_User user = new qPtl_User(email);
                                if (user != null)
                                {
                                    if (user.UserID > 0)
                                        n_contact.UserID = user.UserID;
                                }
                                else
                                    n_contact.UserID = 0;

                                n_contact.Insert();
                                success = true;
                            }
                        }
                        else if (m.Success && mode == "test")
                        {
                            success = true;
                        }
                        else if (m.Success == false)
                        {
                            reason = " bad email address";
                        }
                    }

                    i++;

                    if (mode == "process" && success == true)
                    {
                        message += "Line " + i + " SUCCESS - " + email + " successfully added to contact list<br>";
                    }
                    else if (mode == "test" && success == true)
                    {
                        message += "Line " + i + " SUCCESS - " + email + " will be processed<br>";
                    }
                    else if (i > 1)
                    {
                        message += "Line " + i + " FAILURE - " + email + " could not be added for the following reason: " + reason + "<br>";
                    }
                    else
                        message += "Line " + i + " LINE NOT PROCESSED - header line in the file<br>";
                }

                if (mode == "process")
                {
                    lblMessage.Text = message;
                    plhStep3.Visible = false;
                    plhStep3Completed.Visible = true;
                }
                else if (mode == "test")
                {
                    lblTestOutput.Text = message;
                    plhStep3.Visible = true;
                    plhStep2Completed.Visible = true;
                    lblUploadFail.Text = "";
                }
            //}
            //catch
            //{
                //lblTestOutput.Text = "WARNING: File processing failed. Make sure to use a properly formatted .csv file. You can download an example from the top of the page.";
            //}
        }
    }
    protected void btnSave_OnClick(object sender, System.EventArgs e)
    {
        Page.Validate("form");

        if (Page.IsValid)
        {
            int user_id = Convert.ToInt32(Context.Items["UserID"]);

            if (!String.IsNullOrEmpty(Request.QueryString["contactID"]))
            {
                contact_id = Convert.ToInt32(Request.QueryString["contactID"]);
                qCom_Contact contact = new qCom_Contact(contact_id);
                contact.FirstName = txtFirstName.Text;
                contact.LastName = txtLastName.Text;
                contact.Email = txtEmail.Text;
                contact.Keywords = txtKeywords.Text;
                contact.Source = txtSource.Text;
                contact.MainGroup = Convert.ToInt32(txtMainGroup.Text);
                contact.SubGroup = Convert.ToInt32(txtSubGroup.Text);
                contact.DID = txtDID.Text;
                contact.Partner = txtPartner.Text;
                contact.CustomHTMLElement = txtCustomHTMLElement.Text;

                if (!String.IsNullOrEmpty(Convert.ToString(rdtUnsubscribed.SelectedDate)))
                    contact.Unsubscribed = Convert.ToDateTime(rdtUnsubscribed.SelectedDate);
                if (!String.IsNullOrEmpty(Convert.ToString(rdtReportedAsSpam.SelectedDate)))
                    contact.ReportedAsSpam = Convert.ToDateTime(rdtReportedAsSpam.SelectedDate);
                if (!String.IsNullOrEmpty(Convert.ToString(ddlCampaigns.SelectedValue)))
                    contact.UnsubscribedCampaignID = Convert.ToInt32(ddlCampaigns.SelectedValue);
                if (!String.IsNullOrEmpty(Convert.ToString(ddlCampaignsSPAM.SelectedValue)))
                    contact.ReportedAsSpamCampaignID = Convert.ToInt32(ddlCampaignsSPAM.SelectedValue);

                contact.OKEmail = rblOkEmail.SelectedValue;
                contact.Available = rblAvailable.SelectedValue;
                contact.Update();
            }
            else
            {
                qCom_Contact contact = new qCom_Contact();
                contact.FirstName = txtFirstName.Text;
                contact.LastName = txtLastName.Text;
                contact.Email = txtEmail.Text;
                contact.Keywords = txtKeywords.Text;
                contact.Source = txtSource.Text;
                contact.MainGroup = Convert.ToInt32(txtMainGroup.Text);
                contact.SubGroup = Convert.ToInt32(txtSubGroup.Text);
                contact.DID = txtDID.Text;
                contact.Partner = txtPartner.Text;
                contact.CustomHTMLElement = txtCustomHTMLElement.Text;

                if (!String.IsNullOrEmpty(Convert.ToString(rdtUnsubscribed.SelectedDate)))
                    contact.Unsubscribed = Convert.ToDateTime(rdtUnsubscribed.SelectedDate);
                if (!String.IsNullOrEmpty(Convert.ToString(rdtReportedAsSpam.SelectedDate)))
                    contact.ReportedAsSpam = Convert.ToDateTime(rdtReportedAsSpam.SelectedDate);
                if (!String.IsNullOrEmpty(Convert.ToString(ddlCampaigns.SelectedValue)))
                    contact.UnsubscribedCampaignID = Convert.ToInt32(ddlCampaigns.SelectedValue);
                if (!String.IsNullOrEmpty(Convert.ToString(ddlCampaignsSPAM.SelectedValue)))
                    contact.ReportedAsSpamCampaignID = Convert.ToInt32(ddlCampaignsSPAM.SelectedValue);

                contact.OKEmail = rblOkEmail.SelectedValue;
                contact.Available = rblAvailable.SelectedValue;
                contact.Insert();

                contact_id = contact.ContactID;
            }

            if (!String.IsNullOrEmpty(Request.QueryString["contactID"]))
            {
                lblMessage.Text = "*** Record Successfully Updated ***";
                lblMessageBottom.Text = "*** Record Successfully Updated ***";
                if (Request.QueryString["edit-mode"] == "in-place")
                    Response.Redirect(Request.QueryString["returnURL"]);
                else
                    Response.Redirect("contacts-list.aspx");
            }
            else
            {
                Response.Redirect(Request.Url.ToString() + "?mode=add-successful&contactID=" + contact_id);
            }
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (!String.IsNullOrEmpty(Request.QueryString["contactID"]))
            {
                populateCampaigns();

                contact_id = Convert.ToInt32(Request.QueryString["contactID"]);
                ViewState.Add("vsContactID", contact_id);

                qCom_Contact contact = new qCom_Contact(contact_id);

                lblTitle.Text = "Edit Contact (ID: " + contact.ContactID + ")";
                txtFirstName.Text = contact.FirstName;
                txtLastName.Text = contact.LastName;
                txtEmail.Text = contact.Email;
                txtKeywords.Text = contact.Keywords;
                txtSource.Text = contact.Source;
                rblOkEmail.SelectedValue = contact.OKEmail;
                txtPartner.Text = contact.Partner;
                txtMainGroup.Text = Convert.ToString(contact.MainGroup);
                txtSubGroup.Text = Convert.ToString(contact.SubGroup);
                rblAvailable.SelectedValue = contact.Available;
                txtCustomHTMLElement.Text = contact.CustomHTMLElement;
                if (!String.IsNullOrEmpty(Convert.ToString(contact.Unsubscribed)))
                    rdtUnsubscribed.SelectedDate = Convert.ToDateTime(contact.Unsubscribed);
                if (!String.IsNullOrEmpty(Convert.ToString(contact.UnsubscribedCampaignID)))
                {
                    qSoc_Campaign campaign = new qSoc_Campaign(contact.UnsubscribedCampaignID);
                    ddlCampaigns.SelectedValue = Convert.ToString(contact.UnsubscribedCampaignID);

                    if (campaign.CampaignID > 0)
                    {
                        litUnsubscribedCampaignInfo.Text = "Unsubscribed from campaign: " + campaign.CampaignName;
                    }
                }
                if (!String.IsNullOrEmpty(Convert.ToString(contact.ReportedAsSpam)))
                    rdtReportedAsSpam.SelectedDate = Convert.ToDateTime(contact.ReportedAsSpam);
                if (!String.IsNullOrEmpty(Convert.ToString(contact.ReportedAsSpam)))
                {
                    if (!String.IsNullOrEmpty(Convert.ToString(contact.ReportedAsSpamCampaignID)))
                    {
                        qSoc_Campaign campaign = new qSoc_Campaign(contact.ReportedAsSpamCampaignID);
                        ddlCampaignsSPAM.SelectedValue = Convert.ToString(contact.ReportedAsSpamCampaignID);

                        if (campaign.CampaignID > 0)
                        {
                            litReportedAsSPAMCampaignInfo.Text = "Reported as SPAM from campaign <strong>" + campaign.CampaignName + "</strong> at <strong>" + contact.ReportedAsSpam + "</strong>";
                        }
                    }
                    else
                    {
                        litReportedAsSPAMCampaignInfo.Text = "Reported as SPAM at <strong>" + contact.ReportedAsSpam + "</strong>";
                    }
                }

                if (Convert.ToString(Request.QueryString["mode"]) == "add-successful")
                {
                    lblMessage.Text = "*** Record Successfully Added ***";
                }
            }

            else
            {
                lblTitle.Text = "New Contact";
                btnDelete.Visible = false;
                rblAvailable.SelectedValue = "Yes";
                plhTools.Visible = false;
            }
        }

        if (String.IsNullOrEmpty(Convert.ToString(contact_id)))
            contact_id = (Int32)ViewState["vsContactID"];
    }
        public static bool DoesContactExist(string email)
        {
            bool contact_exists = false;

            qCom_Contact contact = new qCom_Contact();
            contact = GetContactByEmail(email);

            if (contact != null)
            {
                if (contact.ContactID > 0)
                    contact_exists = true;
            }
            return contact_exists;
        }