private NewsletterResponseObject updateCustomerStormPostId(int cusId, ushort position, int stormPostId)
{
HarperLINQ.AHT_MainDataContext dc;
HarperLINQ.tbl_Customer customer;
string enc_cusId;
List <HarperLINQ.tbl_Customer> existing1st, existing2nd;
int existingMembers = 0;
if (position != 1 && position != 2)
{
throw new ArgumentException(String.Format("{0} is not a valid position (Only 1 or 2 accepted).", position.ToString()));
}
dc = new HarperLINQ.AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString);
customer = dc.tbl_Customers.Single(c => c.cusID == cusId);
// Locate customer records that already have the StormPostId
existing1st = dc.tbl_Customers.Where(c => c.cusStormPostPrimaryID == stormPostId)
.ToList();
existing2nd = dc.tbl_Customers.Where(c => c.cusStormPostSecondaryID == stormPostId)
.ToList();
// Check whether the StormPostId already belongs to an existing *Member*; if so, throw an error
existingMembers += existing1st.Where(c => 1 == 1
// Check that the member isn't deleted
&& !c.cusIsDeleted
// Check that the member has an SFG number
&& dc.SFG_CustomerNumbers.Any(sfg => sfg.cusID == c.cusID)
// Check that the member has an active subscription
&& dc.tbl_NetMemberships.Any(nm => nm.nmbDateEnd > DateTime.Now && nm.cusID == c.cusID)
).Count();
existingMembers += existing2nd.Where(c => 1 == 1
// Check that the member isn't deleted
&& !c.cusIsDeleted
// Check that the member has an SFG number
&& dc.SFG_CustomerNumbers.Any(sfg => sfg.cusID == c.cusID)
// Check that the member has an active subscription
&& dc.tbl_NetMemberships.Any(nm => nm.nmbDateEnd > DateTime.Now && nm.cusID == c.cusID)
).Count();
if (existingMembers > 0)
{
throw new ApplicationException(String.Format("The requested StormPostId {0} is already assigned to another member. Cannot assign to cusId {1}", stormPostId, cusId));
}
// Remove the StormPostId from any existing non-active customers
existing1st.ForEach(e1 => e1.cusStormPostPrimaryID = null);
existing2nd.ForEach(e2 => e2.cusStormPostSecondaryID = null);
if (position == 1)
{
customer.cusStormPostPrimaryID = stormPostId;
}
else if (position == 2)
{
customer.cusStormPostSecondaryID = stormPostId;
}
dc.SubmitChanges();
enc_cusId = HarperCRYPTO.Cryptography.Hash(cusId.ToString(), true);
return(GetSubscriber(enc_cusId, position));
}
public NewsletterResponseObject GetSubscriber(string enccusId, ushort?position)
{
NewsletterResponseObject response = new NewsletterResponseObject();
HarperLINQ.tbl_Customer customer;
HarperLINQ.AHT_MainDataContext dc;
int cusId = 0;
try
{
string strCusId = HarperCRYPTO.Cryptography.DeHash(enccusId, true);
cusId = Int32.Parse(strCusId);
response.PrimarySubscriber = null;
response.SecondarySubscriber = null;
dc = new HarperLINQ.AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString);
customer = dc.tbl_Customers.Where(c => c.cusID == cusId)
.Single();
if (position.HasValue && position.Value != 1 && position.Value != 2)
{
throw new ApplicationException("Position Value is invalid. Use 1 for Primary, 2 for Secondary.");
}
if (!position.HasValue || position.Value == 1)
{
if (customer.cusStormPostPrimaryID.HasValue && customer.cusStormPostPrimaryID.Value > 0)
{
response.PrimarySubscriber = retrieveSubscriber(customer.cusStormPostPrimaryID.Value);
response.PrimarySubscriber.Primary_Email = true;
response.PrimarySubscriber.CusID = cusId;
}
}
if (!position.HasValue || position.Value == 2)
{
if (customer.cusStormPostSecondaryID.HasValue && customer.cusStormPostSecondaryID.Value > 0)
{
response.SecondarySubscriber = retrieveSubscriber(customer.cusStormPostSecondaryID.Value);
response.SecondarySubscriber.CusID = cusId;
}
}
response.Success = true;
return(response);
}
catch (Exception ex)
{
string argString = String.Format("enccusId: {0}; position: {1}", enccusId, position);
new SupportClasses.Mailer().SendEmail(ConfigurationManager.AppSettings["mailserviceuser"],
ConfigurationManager.AppSettings["mailservicepwd"],
"NewsletterService ERROR - " + ex.GetType().Name,
"*****@*****.**",
ConfigurationManager.AppSettings["newsletter-erroremailto"],
"", "", argString + ex.ToString(), false,
ConfigurationManager.AppSettings["erroremailsmtpserver"]);
throw;
}
}
public NewsletterResponseObject CreateSubscriber(string encCusId, ushort position)
{
stormpost.api.SoapRequestProcessorService api;
stormpost.api.Recipient recipient, existing;
HarperLINQ.AHT_MainDataContext dc;
HarperLINQ.tbl_Customer customer;
HarperLINQ.tbl_NetMembership maxMembership;
HarperLINQ.tbl_MembershipType maxMembershipType;
HarperLINQ.tbl_StormPostRecipient newRecipient;
NewsletterResponseObject response;
int cusID = 0;
try
{
cusID = Int32.Parse(HarperCRYPTO.Cryptography.DeHash(encCusId, true));
api = new MemberServices.stormpost.api.SoapRequestProcessorService();
dc = new HarperLINQ.AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString);
response = new NewsletterResponseObject();
response.Success = false;
response.PrimarySubscriber = new NewsletterSubscriber();
// Set the authentication on the SOAP object
api.authenticationValue = new MemberServices.stormpost.api.authentication();
api.authenticationValue.username = ConfigurationManager.AppSettings["newsletter-api-username"];
api.authenticationValue.password = ConfigurationManager.AppSettings["newsletter-api-password"];
// Get the customer and his associated NetMembership record
customer = dc.tbl_Customers.Where(c => c.cusID == cusID)
.Single();
try
{
maxMembership = dc.tbl_NetMemberships.Where(nm => nm.cusID == customer.cusID)
.OrderByDescending(nm => nm.nmbDateEnd)
.First();
}
catch
{
maxMembership = null;
}
try
{
maxMembershipType = dc.tbl_MembershipTypes.Where(mt => mt.mtyCode == maxMembership.mtyCode)
.Single();
}
catch
{
maxMembershipType = null;
}
// "Lazy" coding: look for an excuse not to do any work...
if (position != 1 && position != 2)
{
throw new ApplicationException("Postion specified is unsupported. Currently this operation only selects position 1 or 2.");
}
else if (position == 1 && customer.cusStormPostPrimaryID.HasValue && customer.cusStormPostPrimaryID > 0)
{
throw new ApplicationException(String.Format("The customer selected already has a StormPulse account ({0})", customer.cusStormPostPrimaryID));
}
else if (position == 2 && customer.cusStormPostSecondaryID.HasValue && customer.cusStormPostSecondaryID > 0)
{
throw new ApplicationException(String.Format("The customer selected already has a StormPulse account ({0})", customer.cusStormPostSecondaryID));
}
// Set up the recipient object
recipient = new MemberServices.stormpost.api.Recipient();
recipient.dateJoined = DateTime.Now;
recipient.externalID = customer.cusCustNum;
recipient.SetDemographic("FirstName", customer.cusFirstName);
recipient.SetDemographic("LastName", customer.cusLastName);
recipient.SetDemographic("_Custom01", (maxMembershipType != null) ? maxMembershipType.mtyName : "");
recipient.SetDemographic("_Custom02", customer.csoCode);
recipient.SetDemographic("_Custom03", (maxMembership != null) ? maxMembership.nmbDateEnd.ToShortDateString() : "");
recipient.SetDemographic("_Custom04", position == 1 ? "True" : "False");
if (position == 1)
{
recipient.address = customer.cusEmail;
}
else if (position == 2)
{
recipient.address = customer.cusSecondEmail;
}
// Check whether the recipient already exists at stormpost
existing = null;
try
{
existing = api.getRecipientByAddress(recipient.address);
}
catch { }
if (existing != null)
{
if (!String.IsNullOrEmpty(existing.address) && existing.recipID.HasValue)
{
return(updateCustomerStormPostId(cusID, position, existing.recipID.Value));
}
}
// Make the createRecipient call, and update Nucleus with the new value
response.PrimarySubscriber.UniqueID = api.createRecipientAndReturnRecipID(recipient);
if (position == 1)
{
customer.cusStormPostPrimaryID = response.PrimarySubscriber.UniqueID;
}
else if (position == 2)
{
customer.cusStormPostSecondaryID = response.PrimarySubscriber.UniqueID;
}
// Create the StormPostRecipient object
DateTime tmpDateTime = new DateTime();
newRecipient = new HarperLINQ.tbl_StormPostRecipient()
{
sprEmail = recipient.address,
sprFirstName = recipient.GetDemographics()["FirstName"],
sprLastName = recipient.GetDemographics()["LastName"],
sprMemberType = recipient.GetDemographics()["_Custom01"],
sprMemberSource = recipient.GetDemographics()["_Custom02"],
sprExpireDate = (DateTime.TryParse(recipient.GetDemographics()["_Custom03"], out tmpDateTime) ? (DateTime?)tmpDateTime : (DateTime?)null),
sprPrimaryEmail = recipient.GetDemographics()["_Custom04"] == "True",
sprRecipId = response.PrimarySubscriber.UniqueID,
timestmp = DateTime.Now,
sprJoinDate = DateTime.Now
};
dc.tbl_StormPostRecipients.InsertOnSubmit(newRecipient);
dc.SubmitChanges();
// Construct the response object
response.PrimarySubscriber.CusID = cusID;
response.PrimarySubscriber.EmailAddress = customer.cusEmail;
response.PrimarySubscriber.Subscriptions = new List <Newsletter>();
response.PrimarySubscriber.First_Name = recipient.GetDemographics()["FirstName"];
response.PrimarySubscriber.Last_Name = recipient.GetDemographics()["LastName"];
response.PrimarySubscriber.Member_Source = recipient.GetDemographics()["_Custom02"];
response.PrimarySubscriber.Member_Type = recipient.GetDemographics()["_Custom01"];
response.PrimarySubscriber.Primary_Email = (recipient.GetDemographics()["_Custom04"] == "True");
// Parse the Expire Date
string temp = recipient.GetDemographics()["_Custom03"];
DateTime tmpDate = new DateTime();
response.PrimarySubscriber.Member_Expire_Date = (DateTime.TryParse(temp, out tmpDate)) ? (DateTime?)tmpDate : null;
response.Success = true;
return(response);
}
catch (Exception ex)
{
string argString = String.Format("cusId: {0}\r\n\r\n", cusID.ToString());
new SupportClasses.Mailer().SendEmail(ConfigurationManager.AppSettings["mailserviceuser"],
ConfigurationManager.AppSettings["mailservicepwd"],
"NewsletterService ERROR - " + ex.GetType().Name,
"*****@*****.**",
ConfigurationManager.AppSettings["newsletter-erroremailto"],
"", "", argString + ex.ToString(), false,
ConfigurationManager.AppSettings["erroremailsmtpserver"]);
throw;
}
}
private NewsletterResponseObject updateCustomerStormPostId(int cusId, ushort position, int stormPostId)
{
HarperLINQ.AHT_MainDataContext dc;
HarperLINQ.tbl_Customer customer;
string enc_cusId;
List<HarperLINQ.tbl_Customer> existing1st, existing2nd;
int existingMembers = 0;
if(position != 1 && position != 2)
throw new ArgumentException(String.Format("{0} is not a valid position (Only 1 or 2 accepted).", position.ToString()));
dc = new HarperLINQ.AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString);
customer = dc.tbl_Customers.Single(c => c.cusID == cusId);
// Locate customer records that already have the StormPostId
existing1st = dc.tbl_Customers.Where(c => c.cusStormPostPrimaryID == stormPostId)
.ToList();
existing2nd = dc.tbl_Customers.Where(c => c.cusStormPostSecondaryID == stormPostId)
.ToList();
// Check whether the StormPostId already belongs to an existing *Member*; if so, throw an error
existingMembers += existing1st.Where(c => 1 == 1
// Check that the member isn't deleted
&& !c.cusIsDeleted
// Check that the member has an SFG number
&& dc.SFG_CustomerNumbers.Any(sfg => sfg.cusID == c.cusID)
// Check that the member has an active subscription
&& dc.tbl_NetMemberships.Any(nm => nm.nmbDateEnd > DateTime.Now && nm.cusID == c.cusID)
).Count();
existingMembers += existing2nd.Where(c => 1 == 1
// Check that the member isn't deleted
&& !c.cusIsDeleted
// Check that the member has an SFG number
&& dc.SFG_CustomerNumbers.Any(sfg => sfg.cusID == c.cusID)
// Check that the member has an active subscription
&& dc.tbl_NetMemberships.Any(nm => nm.nmbDateEnd > DateTime.Now && nm.cusID == c.cusID)
).Count();
if (existingMembers > 0)
throw new ApplicationException(String.Format("The requested StormPostId {0} is already assigned to another member. Cannot assign to cusId {1}", stormPostId, cusId));
// Remove the StormPostId from any existing non-active customers
existing1st.ForEach(e1 => e1.cusStormPostPrimaryID = null);
existing2nd.ForEach(e2 => e2.cusStormPostSecondaryID = null);
if (position == 1)
customer.cusStormPostPrimaryID = stormPostId;
else if (position == 2)
customer.cusStormPostSecondaryID = stormPostId;
dc.SubmitChanges();
enc_cusId = HarperCRYPTO.Cryptography.Hash(cusId.ToString(), true);
return GetSubscriber(enc_cusId, position);
}
public NewsletterResponseObject GetSubscriber(string enccusId, ushort? position)
{
NewsletterResponseObject response = new NewsletterResponseObject();
HarperLINQ.tbl_Customer customer;
HarperLINQ.AHT_MainDataContext dc;
int cusId = 0;
try
{
string strCusId = HarperCRYPTO.Cryptography.DeHash(enccusId, true);
cusId = Int32.Parse(strCusId);
response.PrimarySubscriber = null;
response.SecondarySubscriber = null;
dc = new HarperLINQ.AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString);
customer = dc.tbl_Customers.Where(c => c.cusID == cusId)
.Single();
if (position.HasValue && position.Value != 1 && position.Value != 2)
throw new ApplicationException("Position Value is invalid. Use 1 for Primary, 2 for Secondary.");
if (!position.HasValue || position.Value == 1)
{
if (customer.cusStormPostPrimaryID.HasValue && customer.cusStormPostPrimaryID.Value > 0 )
{
response.PrimarySubscriber = retrieveSubscriber(customer.cusStormPostPrimaryID.Value);
response.PrimarySubscriber.Primary_Email = true;
response.PrimarySubscriber.CusID = cusId;
}
}
if (!position.HasValue || position.Value == 2)
{
if (customer.cusStormPostSecondaryID.HasValue && customer.cusStormPostSecondaryID.Value > 0)
{
response.SecondarySubscriber = retrieveSubscriber(customer.cusStormPostSecondaryID.Value);
response.SecondarySubscriber.CusID = cusId;
}
}
response.Success = true;
return response;
}
catch(Exception ex)
{
string argString = String.Format("enccusId: {0}; position: {1}", enccusId, position);
new SupportClasses.Mailer().SendEmail(ConfigurationManager.AppSettings["mailserviceuser"],
ConfigurationManager.AppSettings["mailservicepwd"],
"NewsletterService ERROR - " + ex.GetType().Name,
"*****@*****.**",
ConfigurationManager.AppSettings["newsletter-erroremailto"],
"", "", argString + ex.ToString(), false,
ConfigurationManager.AppSettings["erroremailsmtpserver"]);
throw;
}
}
public NewsletterResponseObject CreateSubscriber(string encCusId, ushort position)
{
stormpost.api.SoapRequestProcessorService api;
stormpost.api.Recipient recipient, existing;
HarperLINQ.AHT_MainDataContext dc;
HarperLINQ.tbl_Customer customer;
HarperLINQ.tbl_NetMembership maxMembership;
HarperLINQ.tbl_MembershipType maxMembershipType;
HarperLINQ.tbl_StormPostRecipient newRecipient;
NewsletterResponseObject response;
int cusID = 0;
try
{
cusID = Int32.Parse(HarperCRYPTO.Cryptography.DeHash(encCusId, true));
api = new MemberServices.stormpost.api.SoapRequestProcessorService();
dc = new HarperLINQ.AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString);
response = new NewsletterResponseObject();
response.Success = false;
response.PrimarySubscriber = new NewsletterSubscriber();
// Set the authentication on the SOAP object
api.authenticationValue = new MemberServices.stormpost.api.authentication();
api.authenticationValue.username = ConfigurationManager.AppSettings["newsletter-api-username"];
api.authenticationValue.password = ConfigurationManager.AppSettings["newsletter-api-password"];
// Get the customer and his associated NetMembership record
customer = dc.tbl_Customers.Where(c => c.cusID == cusID)
.Single();
try
{
maxMembership = dc.tbl_NetMemberships.Where(nm => nm.cusID == customer.cusID)
.OrderByDescending(nm => nm.nmbDateEnd)
.First();
}
catch
{
maxMembership = null;
}
try
{
maxMembershipType = dc.tbl_MembershipTypes.Where(mt => mt.mtyCode == maxMembership.mtyCode)
.Single();
}
catch
{
maxMembershipType = null;
}
// "Lazy" coding: look for an excuse not to do any work...
if (position != 1 && position != 2)
throw new ApplicationException("Postion specified is unsupported. Currently this operation only selects position 1 or 2.");
else if (position == 1 && customer.cusStormPostPrimaryID.HasValue && customer.cusStormPostPrimaryID > 0)
throw new ApplicationException(String.Format("The customer selected already has a StormPulse account ({0})", customer.cusStormPostPrimaryID));
else if (position == 2 && customer.cusStormPostSecondaryID.HasValue && customer.cusStormPostSecondaryID > 0)
throw new ApplicationException(String.Format("The customer selected already has a StormPulse account ({0})", customer.cusStormPostSecondaryID));
// Set up the recipient object
recipient = new MemberServices.stormpost.api.Recipient();
recipient.dateJoined = DateTime.Now;
recipient.externalID = customer.cusCustNum;
recipient.SetDemographic("FirstName", customer.cusFirstName);
recipient.SetDemographic("LastName", customer.cusLastName);
recipient.SetDemographic("_Custom01", (maxMembershipType != null) ? maxMembershipType.mtyName : "");
recipient.SetDemographic("_Custom02", customer.csoCode);
recipient.SetDemographic("_Custom03", (maxMembership != null) ? maxMembership.nmbDateEnd.ToShortDateString() : "");
recipient.SetDemographic("_Custom04", position == 1 ? "True" : "False");
if (position == 1)
recipient.address = customer.cusEmail;
else if (position == 2)
recipient.address = customer.cusSecondEmail;
// Check whether the recipient already exists at stormpost
existing = null;
try
{
existing = api.getRecipientByAddress(recipient.address);
}
catch { }
if (existing != null)
{
if (!String.IsNullOrEmpty(existing.address) && existing.recipID.HasValue)
{
return updateCustomerStormPostId(cusID, position, existing.recipID.Value);
}
}
// Make the createRecipient call, and update Nucleus with the new value
response.PrimarySubscriber.UniqueID = api.createRecipientAndReturnRecipID(recipient);
if (position == 1)
customer.cusStormPostPrimaryID = response.PrimarySubscriber.UniqueID;
else if (position == 2)
customer.cusStormPostSecondaryID = response.PrimarySubscriber.UniqueID;
// Create the StormPostRecipient object
DateTime tmpDateTime = new DateTime();
newRecipient = new HarperLINQ.tbl_StormPostRecipient()
{
sprEmail = recipient.address,
sprFirstName = recipient.GetDemographics()["FirstName"],
sprLastName = recipient.GetDemographics()["LastName"],
sprMemberType = recipient.GetDemographics()["_Custom01"],
sprMemberSource = recipient.GetDemographics()["_Custom02"],
sprExpireDate = (DateTime.TryParse(recipient.GetDemographics()["_Custom03"], out tmpDateTime) ? (DateTime?)tmpDateTime : (DateTime?)null),
sprPrimaryEmail = recipient.GetDemographics()["_Custom04"] == "True",
sprRecipId = response.PrimarySubscriber.UniqueID,
timestmp = DateTime.Now,
sprJoinDate = DateTime.Now
};
dc.tbl_StormPostRecipients.InsertOnSubmit(newRecipient);
dc.SubmitChanges();
// Construct the response object
response.PrimarySubscriber.CusID = cusID;
response.PrimarySubscriber.EmailAddress = customer.cusEmail;
response.PrimarySubscriber.Subscriptions = new List<Newsletter>();
response.PrimarySubscriber.First_Name = recipient.GetDemographics()["FirstName"];
response.PrimarySubscriber.Last_Name = recipient.GetDemographics()["LastName"];
response.PrimarySubscriber.Member_Source = recipient.GetDemographics()["_Custom02"];
response.PrimarySubscriber.Member_Type = recipient.GetDemographics()["_Custom01"];
response.PrimarySubscriber.Primary_Email = (recipient.GetDemographics()["_Custom04"] == "True");
// Parse the Expire Date
string temp = recipient.GetDemographics()["_Custom03"];
DateTime tmpDate = new DateTime();
response.PrimarySubscriber.Member_Expire_Date = (DateTime.TryParse(temp, out tmpDate)) ? (DateTime?)tmpDate : null;
response.Success = true;
return response;
}
catch(Exception ex)
{
string argString = String.Format("cusId: {0}\r\n\r\n", cusID.ToString());
new SupportClasses.Mailer().SendEmail(ConfigurationManager.AppSettings["mailserviceuser"],
ConfigurationManager.AppSettings["mailservicepwd"],
"NewsletterService ERROR - " + ex.GetType().Name,
"*****@*****.**",
ConfigurationManager.AppSettings["newsletter-erroremailto"],
"", "", argString + ex.ToString(), false,
ConfigurationManager.AppSettings["erroremailsmtpserver"]);
throw;
}
}