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");
}
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]+[-._+&])*[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;
}