private Boolean SaveDataToReportDB()
{
bool blnDataSaved = false;
try
{
string FirstName = "";
string Surname = "";
if (txtName.Value.IndexOf(" ") != -1)
{
FirstName = txtName.Value.Substring(0, txtName.Value.IndexOf(" ")).Trim();
Surname = txtName.Value.Substring(txtName.Value.IndexOf(" ") + 1).Trim();
}
else
{
FirstName = txtName.Value.Trim();
}
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = txtEmail.Value.Trim();
objCustomer.Firstname = FirstName;
objCustomer.Surname = Surname;
objCustomer.HomeClubID = currentClub.ClubId.Rendered;
objCustomer.SubscribeToNewsletter = chkSubscribe.Checked;
objCustomer.TelephoneNumber = txtPhone.Value.Trim();
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = "Club Enquiry";
objFeedback.FeedbackSubjectDetail = "Virgin Active Website";
objFeedback.FeedbackTypeID = Constants.FeedbackType.ClubEnquiry;
objFeedback.PrimaryClubID = currentClub.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = drpHowDidYouFindUs.SelectedValue.ToString();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = "How did you find out about us";
List<Comment> objComments = new List<Comment>();
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
if (dal.SaveFeedback(Context.User.Identity.Name, enquiryItem.DisplayName, objFeedback) > 0)
{
blnDataSaved = true;
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error saving form data to reports db {1}: {0}", ex.Message, currentClub.Clubname.Raw), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
return blnDataSaved;
}
private Boolean SaveDataToReportDB()
{
bool blnDataSaved = false;
try
{
string FirstName = "";
string Surname = "";
if (txtName.Value.IndexOf(" ") != -1)
{
FirstName = txtName.Value.Substring(0, txtName.Value.IndexOf(" ")).Trim();
Surname = txtName.Value.Substring(txtName.Value.IndexOf(" ") + 1).Trim();
}
else
{
FirstName = txtName.Value.Trim();
}
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = txtEmail.Value.Trim();
objCustomer.Firstname = FirstName;
objCustomer.Surname = Surname;
objCustomer.MembershipNumber = txtMembership.Value.Trim();
objCustomer.HomeClubID = club.ClubId.Rendered;
objCustomer.TelephoneNumber = txtPhone.Value;
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = "Health And Beauty Enquiry";
objFeedback.FeedbackSubjectDetail = "Virgin Active Website";
objFeedback.FeedbackTypeID = Constants.FeedbackType.HealthAndBeautyFeedback;
objFeedback.PrimaryClubID = club.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
//objFeedback.PreferredCallbackDate = Convert.ToDateTime(txtPreferredDay.Value.Trim(), System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
//objFeedback.PreferredCallbackTime = drpPreferredTime.SelectedValue.ToString() != Translate.Text("Select") ? drpPreferredTime.SelectedValue.ToString() : "";
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = drpTreatment.SelectedValue.ToString() != Translate.Text("Select") ? drpTreatment.SelectedValue.ToString() : "";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = "Treatment";
List<Comment> objComments = new List<Comment>();
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = txtPreferredDay.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 2;
objComment.Subject = "Preferred Treatment Day";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = drpPreferredTime.SelectedValue.ToString() != Translate.Text("Select") ? drpPreferredTime.SelectedValue.ToString() : "";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 3;
objComment.Subject = "Preferred Treatment Time";
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
if (dal.SaveFeedback(Context.User.Identity.Name, listing.DisplayName, objFeedback) > 0)
{
blnDataSaved = true;
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error saving form data to reports db {1}: {0}", ex.Message, club.Clubname.Raw), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
return blnDataSaved;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
//Get User from Session
//Check Session
User objUser = new User();
if (Session["sess_User_landing"] != null)
{
objUser = (User)Session["sess_User_landing"];
clubId = objUser.BrowsingHistory.LandingClubID;
profile = objUser.BrowsingHistory.LandingProfile;
region = objUser.BrowsingHistory.LandingRegion;
}
//Get Club Data
if (!String.IsNullOrEmpty(clubId))
{
clubItem = SitecoreHelper.GetClubOnClubId(clubId);
if (clubItem != null)
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
string FirstName = "";
string Surname = "";
if (txtName.Value.IndexOf(" ") != -1)
{
FirstName = txtName.Value.Substring(0, txtName.Value.IndexOf(" ")).Trim();
Surname = txtName.Value.Substring(txtName.Value.IndexOf(" ") + 1).Trim();
}
else
{
FirstName = txtName.Value.Trim();
}
objCustomer.EmailAddress = txtEmail.Value;
objCustomer.Firstname = FirstName;
objCustomer.Surname = Surname;
objCustomer.HomeClubID = clubItem.ClubId.Rendered;
objCustomer.TelephoneNumber = txtPhone.Value;
objCustomer.SubscribeToNewsletter = chkSubscribe.Checked;
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = "Landing Enquiry"; //Landing Enquiry
objFeedback.FeedbackSubjectDetail = "Virgin Active Website Landing Page"; //Virgin Active Website Landing Page
objFeedback.FeedbackTypeID = Convert.ToInt32(currentLanding.LandingBase.LandingId.Rendered);
objFeedback.PrimaryClubID = clubItem.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
//Add Comment
Comment objComment = new Comment();
//objComment.CommentDetail = source.Items[source.SelectedIndex].Value;
objComment.CommentDetail = currentLanding.LandingBase.LandingIdName.Rendered;// "Q1 Landing Page -2013"; //Other
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = Translate.Text("How did you hear about us?");
List<Comment> objComments = new List<Comment>();
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, currentItem.DisplayName, objFeedback);
if (successFlag > 0)
{
//Data is sent to client via email
SendAdminEmail();
//Data is sent to client via service
SendEnquiryDataService();
//Data is sent to customer via email
SendConfirmationEmail();
//Save objFeedback back to session
Session["sess_Customer"] = objCustomer;
//Redirect to 'Whats Next' Page
Sitecore.Links.UrlOptions urlOptions = new Sitecore.Links.UrlOptions();
urlOptions.AlwaysIncludeServerUrl = true;
urlOptions.AddAspxExtension = false;
urlOptions.LanguageEmbedding = LanguageEmbedding.Never;
Item whatNextItem = currentItem.InnerItem.Parent.Axes.SelectSingleItem(String.Format("descendant-or-self::*[@@tid = '{0}']", Settings.LandingPagesWhatsNextTemplate));
string whatNextUrl = Sitecore.Links.LinkManager.GetItemUrl(whatNextItem, urlOptions)+"?_clubid=" + clubItem.ClubId.Rendered;
Response.Redirect(whatNextUrl);
}
else
{
//imageStatic.Attributes.Add("style", "display:none;");
//formToComplete.Attributes.Add("style", "display:block;");
//formCompleted.Attributes.Add("style", "display:none;");
//pnlForm.Update();
Log.Error(String.Format("Error storing campaign details"), this);
}
}
else
{
//imageStatic.Attributes.Add("style", "display:none;");
//formToComplete.Attributes.Add("style", "display:block;");
//formCompleted.Attributes.Add("style", "display:none;");
//pnlForm.Update();
}
}
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error processing club enquiry form {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = email.Value;
//objCustomer.Firstname = "";
//objCustomer.Surname = "";
//objCustomer.HomeClubID = "";
//objCustomer.SubscribeToNewsletter = false;
//objCustomer.TelephoneNumber = "";
//objCustomer.MembershipNumber = "";
//objCustomer.Gender = "";
//objCustomer.AddressLine1 = "";
//objCustomer.AddressLine2 = "";
//objCustomer.AddressLine3 = "";
//objCustomer.AddressLine4 = "";
//objCustomer.Postcode = "";
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = campaign.CampaignBase.Campaigntype.Raw;
objFeedback.FeedbackSubjectDetail = campaign.CampaignBase.Campaignname.Rendered;
objFeedback.FeedbackTypeID = Convert.ToInt32(campaign.CampaignBase.CampaignId.Rendered);
objFeedback.PrimaryClubID = "";
objFeedback.SubmissionDate = DateTime.Now;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, campaign.DisplayName, objFeedback);
//Data is sent to client via email
SendAdminEmail();
if (campaign.CampaignBase.Sendconfirmationemail.Checked == true)
{
//Data is sent to customer via email
SendConfirmationEmail();
}
formToComplete.Visible = false;
formCompleted.Visible = true;
//System.Threading.Thread.Sleep(5000);
pnlForm.Update();
//ClearFormFields();
}
catch (Exception ex)
{
Log.Error(String.Format("Error storing campaign details: {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
}
private Boolean SaveDataToReportDB()
{
bool blnDataSaved = false;
try
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = txtEmail.Value.Trim();
objCustomer.Firstname = txtFirstName.Value.Trim();
objCustomer.Surname = txtSurname.Value.Trim();
objCustomer.MembershipNumber = txtMembership.Value.Trim();
objCustomer.HomeClubID = "";
DateTime datDateOfBirth;
if (DateTime.TryParse(drpDOBDay.SelectedValue + "/" + drpDOBMonth.SelectedValue + "/" + drpDOBYear.SelectedValue, out datDateOfBirth))
{
objCustomer.DateOfBirth = datDateOfBirth;
}
objCustomer.AddressLine1 = txtAddress1.Value.Trim();
objCustomer.AddressLine2 = txtAddress2.Value.Trim();
objCustomer.AddressLine3 = txtAddress3.Value.Trim();
objCustomer.AddressLine4 = (txtAddress4.Value.Trim() + " " + txtAddress5.Value.Trim()).Trim();
objCustomer.Postcode = txtPostcode2.Value.Trim();
//objCustomer.PublishDetails = false;
//objCustomer.SubscribeToNewsletter = false;
objCustomer.TelephoneNumber = txtHomeNo.Value.Trim();
objCustomer.AlternativeTelephoneNumber = txtMobileNo.Value.Trim();
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = "Personal Details Update";
objFeedback.FeedbackSubjectDetail = "Virgin Active Website";
objFeedback.FeedbackTypeID = Constants.FeedbackType.PersonalDetails;
objFeedback.PrimaryClubID = "";
objFeedback.SubmissionDate = DateTime.Now;
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = hdnRecordId.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = "Record ID";
List<Comment> objComments = new List<Comment>();
objComments.Add(objComment);
//Add Comment
objComment = new Comment();
objComment.CommentDetail = txtHomeNo.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 2;
objComment.Subject = "Home Telephone No.";
objComments.Add(objComment);
//Add Comment
objComment = new Comment();
objComment.CommentDetail = txtMobileNo.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 3;
objComment.Subject = "Mobile Telephone No.";
objComments.Add(objComment);
//Add Comment
objComment = new Comment();
objComment.CommentDetail = txtWorkNo.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 4;
objComment.Subject = "Work Telephone No.";
objComments.Add(objComment);
//Add Comment
objComment = new Comment();
objComment.CommentDetail = chkContactByMarketing.Checked == true ? "Y" : "N";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 5;
objComment.Subject = "Contact By Marketing";
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
if (dal.SaveFeedback(Context.User.Identity.Name, currentItem.DisplayName, objFeedback) > 0)
{
blnDataSaved = true;
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error saving form data to reports db: {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
return blnDataSaved;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
//check if we have a valid club selected
Boolean blnClubSuccessfullySelected = clubFindSelect.SelectedIndex != 0;
if (blnClubSuccessfullySelected == true)
{
//Guid id = new Guid(
currentClub = (ClubItem)Sitecore.Context.Database.GetItem(clubFindSelect.SelectedValue);
if (currentClub != null)
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
string FirstName = "";
string Surname = "";
if (txtName.Value.IndexOf(" ") != -1)
{
FirstName = txtName.Value.Substring(0, txtName.Value.IndexOf(" ")).Trim();
Surname = txtName.Value.Substring(txtName.Value.IndexOf(" ") + 1).Trim();
}
else
{
FirstName = txtName.Value.Trim();
}
objCustomer.EmailAddress = txtEmail.Value;
objCustomer.Firstname = FirstName;
objCustomer.Surname = Surname;
objCustomer.HomeClubID = currentClub.ClubId.Rendered;
objCustomer.TelephoneNumber = txtPhone.Value;
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = currentCampaign.CampaignBase.Campaigntype.Raw;
objFeedback.FeedbackSubjectDetail = currentCampaign.CampaignBase.Campaignname.Rendered;
objFeedback.FeedbackTypeID = Convert.ToInt32(currentCampaign.CampaignBase.CampaignId.Rendered);
objFeedback.PrimaryClubID = currentClub.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
//Add Comment
Comment objComment = new Comment();
//objComment.CommentDetail = source.Items[source.SelectedIndex].Value;
objComment.CommentDetail = drpHowDidYouFindUs.SelectedValue;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = Translate.Text("How did you hear about us?");
List<Comment> objComments = new List<Comment>();
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, currentCampaign.DisplayName, objFeedback);
if (successFlag > 0)
{
//Data is sent to client via email
SendAdminEmail();
if (currentCampaign.CampaignBase.Isweblead.Checked == true)
{
//Data is sent to client via service
SendEnquiryDataService();
}
//get managers info
List<ManagerItem> staffMembers = null;
if (currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)) != null)
{
staffMembers = currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)).ToList().ConvertAll(x => new ManagerItem(x));
manager = staffMembers.First();
}
if (currentCampaign.CampaignBase.Sendconfirmationemail.Checked == true)
{
//Data is sent to customer via email
SendConfirmationEmail();
}
//imageStatic.Attributes.Add("style", "display:none;");
formToComplete.Attributes.Add("style", "display:none;");
pnlEnquiryPanel.Visible = false;
formCompleted.Visible = true;
formCompleted.Attributes.Add("style", "display:block;");
//ClearFormFields();
pnlForm.Update();
}
else
{
//imageStatic.Attributes.Add("style", "display:none;");
formToComplete.Attributes.Add("style", "display:block;");
formCompleted.Attributes.Add("style", "display:none;");
pnlForm.Update();
Log.Error(String.Format("Error storing campaign details"), this);
}
}
else
{
//imageStatic.Attributes.Add("style", "display:none;");
formToComplete.Attributes.Add("style", "display:block;");
formCompleted.Attributes.Add("style", "display:none;");
pnlForm.Update();
}
}
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error processing club enquiry form {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
bool blnIsValid = clubFindSelect.SelectedIndex != 0;
if (blnIsValid == true)
{
currentClub = (ClubItem)Sitecore.Context.Database.GetItem(clubFindSelect.SelectedValue);
if (currentClub != null)
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
string FirstName = "";
string Surname = "";
if (yourname.Value.IndexOf(" ") != -1)
{
FirstName = yourname.Value.Substring(0, yourname.Value.IndexOf(" ")).Trim();
Surname = yourname.Value.Substring(yourname.Value.IndexOf(" ") + 1).Trim();
}
else
{
FirstName = yourname.Value.Trim();
}
objCustomer.EmailAddress = email.Value;
objCustomer.Firstname = FirstName;
objCustomer.Surname = Surname;
//objCustomer.HomeClubID = txtClubCode.Value;
objCustomer.HomeClubID = currentClub.ClubId.Rendered;
objCustomer.SubscribeToNewsletter = false;
objCustomer.TelephoneNumber = contact.Value;
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = campaign.CampaignBase.Campaigntype.Raw;
objFeedback.FeedbackSubjectDetail = campaign.CampaignBase.Campaignname.Rendered;
objFeedback.FeedbackTypeID = Convert.ToInt32(campaign.CampaignBase.CampaignId.Rendered);
objFeedback.PrimaryClubID = currentClub.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, campaign.DisplayName, objFeedback);
if (successFlag > 0)
{
//Data is sent to client via email
SendAdminEmail();
if (campaign.CampaignBase.Isweblead.Checked == true)
{
//Data is sent to client via service
SendEnquiryDataService();
}
//get managers info
List<ManagerItem> staffMembers = null;
if (currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)) != null)
{
staffMembers = currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)).ToList().ConvertAll(x => new ManagerItem(x));
manager = staffMembers.First();
}
if (campaign.CampaignBase.Sendconfirmationemail.Checked == true)
{
//Data is sent to customer via email
SendConfirmationEmail();
}
imageStatic.Attributes.Add("style", "display:none;");
innerForm.Attributes.Add("style", "display:none;");
formCompleted.Attributes.Add("style", "display:block;");
string classNames = article.Attributes["class"];
article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
ClearFormFields();
}
else
{
imageStatic.Attributes.Add("style", "display:none;");
innerForm.Attributes.Add("style", "display:block;");
formCompleted.Attributes.Add("style", "display:none;");
string classNames = article.Attributes["class"];
article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
Log.Error(String.Format("Error storing campaign details"), this);
}
}
else
{
imageStatic.Attributes.Add("style", "display:none;");
innerForm.Attributes.Add("style", "display:block;");
formCompleted.Attributes.Add("style", "display:none;");
string classNames = article.Attributes["class"];
article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
}
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error storing campaign details: {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//check if we have a valid club selected
Boolean blnClubSuccessfullySelected = clubFindSelect.SelectedIndex != 0;
if (blnClubSuccessfullySelected == true)
{
if (clubFindSelect.SelectedValue != "Head Office")
{
currentClub = (ClubItem)Sitecore.Context.Database.GetItem(clubFindSelect.SelectedValue);
if (currentClub != null)
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = email.Value;
objCustomer.Firstname = firstName.Value;
objCustomer.Surname = surname.Value;
objCustomer.HomeClubID = currentClub.ClubId.Rendered;
objCustomer.SubscribeToNewsletter = subscribe.Checked;
objCustomer.TelephoneNumber = number.Value.Trim();
objCustomer.MembershipNumber = memberNo.Value.Trim();
objCustomer.Gender = male.Checked == true ? "M" : "F";
objCustomer.AddressLine1 = address1.Value.Trim();
objCustomer.AddressLine2 = address2.Value.Trim();
objCustomer.AddressLine3 = "";
objCustomer.AddressLine4 = address3.Value.Trim();
objCustomer.Postcode = postcode.Value.Trim();
if (dob.Value.Trim() != "")
{
objCustomer.DateOfBirth = Convert.ToDateTime(dob.Value.Trim(), System.Globalization.CultureInfo.CreateSpecificCulture("en-GB"));
}
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = campaign.CampaignBase.Campaigntype.Raw;
objFeedback.FeedbackSubjectDetail = campaign.CampaignBase.Campaignname.Rendered;
objFeedback.FeedbackTypeID = Convert.ToInt32(campaign.CampaignBase.CampaignId.Rendered);
objFeedback.PrimaryClubID = currentClub.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
List<Comment> objComments = new List<Comment>();
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = member.Checked == true ? "Member" : "Staff";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = "Entrant Type";
objComments.Add(objComment);
objComment = new Comment();
//objComment.CommentDetail = drpEvent.Items[drpEvent.SelectedIndex].Value;
objComment.CommentDetail = drpEvent.SelectedValue;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 2;
objComment.Subject = "Event";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = drpTopsize.SelectedValue;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 3;
objComment.Subject = "Top Size";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = teamname.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 4;
objComment.Subject = "Team Name";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = nextofkin.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 5;
objComment.Subject = "Next Of Kin";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = nextofkinnumber.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 6;
objComment.Subject = "Next Of Kin Contact No.";
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, campaign.DisplayName, objFeedback);
if (successFlag > 0)
{
//get managers info
List<ManagerItem> staffMembers = null;
if (currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)) != null)
{
staffMembers = currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)).ToList().ConvertAll(x => new ManagerItem(x));
manager = staffMembers.First();
}
if (campaign.CampaignBase.Sendconfirmationemail.Checked == true)
{
//Data is sent to customer via email
SendConfirmationEmail();
}
pnlForm.Attributes.Add("style", "display:none;");
pnlThanks.Attributes.Add("style", "display:block;");
string classNames = wrapper.Attributes["class"];
wrapper.Attributes.Add("class", "wrapper-thanks");
//ClearFormFields();
}
else
{
pnlForm.Attributes.Add("style", "display:block;");
pnlThanks.Attributes.Add("style", "display:none;");
//string classNames = article.Attributes["class"];
//article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
Log.Error(String.Format("Error storing campaign details"), this);
}
}
else
{
pnlForm.Attributes.Add("style", "display:block;");
pnlThanks.Attributes.Add("style", "display:none;");
//string classNames = article.Attributes["class"];
//article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
}
}
else
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = email.Value;
objCustomer.Firstname = firstName.Value;
objCustomer.Surname = surname.Value;
objCustomer.HomeClubID = "N/A";
objCustomer.SubscribeToNewsletter = subscribe.Checked;
objCustomer.TelephoneNumber = number.Value.Trim();
objCustomer.MembershipNumber = memberNo.Value.Trim();
objCustomer.Gender = male.Checked == true ? "M" : "F";
objCustomer.AddressLine1 = address1.Value.Trim();
objCustomer.AddressLine2 = address2.Value.Trim();
objCustomer.AddressLine3 = "";
objCustomer.AddressLine4 = address3.Value.Trim();
objCustomer.Postcode = postcode.Value.Trim();
if (dob.Value.Trim() != "")
{
objCustomer.DateOfBirth = Convert.ToDateTime(dob.Value.Trim(), System.Globalization.CultureInfo.CreateSpecificCulture("en-GB"));
}
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = campaign.CampaignBase.Campaigntype.Raw;
objFeedback.FeedbackSubjectDetail = campaign.CampaignBase.Campaignname.Rendered;
objFeedback.FeedbackTypeID = Convert.ToInt32(campaign.CampaignBase.CampaignId.Rendered);
objFeedback.PrimaryClubID = "N/A";
objFeedback.SubmissionDate = DateTime.Now;
List<Comment> objComments = new List<Comment>();
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = member.Checked == true ? "Member" : "Staff";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = "Entrant Type";
objComments.Add(objComment);
objComment = new Comment();
//objComment.CommentDetail = drpEvent.Items[drpEvent.SelectedIndex].Value;
objComment.CommentDetail = drpEvent.SelectedValue;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 2;
objComment.Subject = "Event";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = drpTopsize.SelectedValue;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 3;
objComment.Subject = "Top Size";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = teamname.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 4;
objComment.Subject = "Team Name";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = nextofkin.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 5;
objComment.Subject = "Next Of Kin";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = nextofkinnumber.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 6;
objComment.Subject = "Next Of Kin Contact No.";
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, campaign.DisplayName, objFeedback);
if (successFlag > 0)
{
if (campaign.CampaignBase.Sendconfirmationemail.Checked == true)
{
//Data is sent to customer via email
SendConfirmationEmail();
}
pnlForm.Attributes.Add("style", "display:none;");
pnlThanks.Attributes.Add("style", "display:block;");
string classNames = wrapper.Attributes["class"];
wrapper.Attributes.Add("class", "wrapper-thanks");
//ClearFormFields();
}
else
{
pnlForm.Attributes.Add("style", "display:block;");
pnlThanks.Attributes.Add("style", "display:none;");
//string classNames = article.Attributes["class"];
//article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
Log.Error(String.Format("Error storing campaign details"), this);
}
}
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error storing campaign details: {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
bool blnIsValid = true;
mm.virginactive.screportdal.Models.Image objImage = null;
string strMIME = filename.PostedFile.ContentType;
//validate image
if ((filename.HasFile) && (strMIME.ToUpper() == "IMAGE/JPEG" || strMIME.ToUpper() == "IMAGE/PJPEG" || strMIME.ToUpper() == "IMAGE/JPG" || strMIME.ToUpper() == "IMAGE/GIF"))
{
byte[] imageBytes = new byte[filename.PostedFile.InputStream.Length + 1];
filename.PostedFile.InputStream.Read(imageBytes, 0, imageBytes.Length);
if (imageBytes.Length <= 5000000) //Check if number of bytes greater than 5mb
{
objImage = new mm.virginactive.screportdal.Models.Image();
//Add Image
objImage.CommentImageTypeID = Constants.CommentImageType.CompetitionImage;
objImage.SortOrder = 1;
objImage.Subject = "Your Story";
objImage.ImageFile = imageBytes;
objImage.ImageMIMEType = strMIME;
ImageFileProvided = true;
}
else
{
blnIsValid = false;
}
}
//check if we have a valid club selected
blnIsValid = clubFindSelect.SelectedIndex != 0;
if (blnIsValid == true)
{
currentClub = (ClubItem)Sitecore.Context.Database.GetItem(clubFindSelect.SelectedValue);
if (currentClub != null)
{
ClubID = currentClub.ClubId.Rendered;
}
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = email.Value;
string FirstName = "";
string Surname = "";
if (yourname.Value.IndexOf(" ") != -1)
{
FirstName = yourname.Value.Substring(0, yourname.Value.IndexOf(" ")).Trim();
Surname = yourname.Value.Substring(yourname.Value.IndexOf(" ") + 1).Trim();
}
else
{
FirstName = yourname.Value.Trim();
}
objCustomer.Firstname = FirstName;
objCustomer.Surname = Surname;
//objCustomer.HomeClubID = txtClubCode.Value;
objCustomer.HomeClubID = clubID;
objCustomer.SubscribeToNewsletter = subscribe.Checked;
objCustomer.TelephoneNumber = contact.Value;
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = "Your Story";
objFeedback.FeedbackSubjectDetail = "Share Your Success";
objFeedback.FeedbackTypeID = Constants.FeedbackType.ShareYourSuccessCompetition;
//objFeedback.PrimaryClubID = txtClubCode.Value;
objFeedback.PrimaryClubID = ClubID;
objFeedback.SubmissionDate = DateTime.Now;
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = story.Value;
objComment.CommentImageTypeID = Constants.CommentImageType.CompetitionAnswer;
objComment.SortOrder = 1;
objComment.Subject = "Your Story";
List<Comment> objComments = new List<Comment>();
objComments.Add(objComment);
objFeedback.Comments = objComments;
////Add Image
if (objImage != null)
{
List<mm.virginactive.screportdal.Models.Image> objImages = new List<mm.virginactive.screportdal.Models.Image>();
objImages.Add(objImage);
objFeedback.Images = objImages;
}
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, campaign.DisplayName, objFeedback);
// Successfully deleted
if (successFlag > 0)
{
//Data is sent to client via email
SendAdminEmail();
imageCarousel.Attributes.Add("style", "display:none;");
innerstory.Attributes.Add("style", "display:none;");
innerform.Attributes.Add("style", "display:none;");
formSummary.Attributes.Add("style", "display:none;");
formCompleted.Attributes.Add("style", "display:block;");
string classNames = article.Attributes["class"];
article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
ClearFormFields();
}
else
{
imageCarousel.Attributes.Add("style", "display:none;");
innerstory.Attributes.Add("style", "display:none;");
innerform.Attributes.Add("style", "display:none;");
formSummary.Attributes.Add("style", "display:block;");
formCompleted.Attributes.Add("style", "display:none;");
string classNames = article.Attributes["class"];
article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
cvFormSubmission.IsValid = false;
cvFormSubmission.ErrorMessage = Translate.Text("Error uploading details");
Log.Error(String.Format("Error storing campaign details"), this);
}
}
else
{
imageCarousel.Attributes.Add("style", "display:none;");
innerstory.Attributes.Add("style", "display:none;");
innerform.Attributes.Add("style", "display:block;");
formSummary.Attributes.Add("style", "display:none;");
formCompleted.Attributes.Add("style", "display:none;");
string classNames = article.Attributes["class"];
article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
cvImageSubmission.IsValid = false;
cvImageSubmission.ErrorMessage = Translate.Text("File size limit 5Mb");
cvImageSubmission.Attributes.Add("style", "display:none;");
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error storing campaign details: {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
}
private Boolean SaveDataToReportDB()
{
bool blnDataSaved = false;
try
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = txtEmail.Value.Trim();
objCustomer.Firstname = txtFirstName.Value.Trim();
objCustomer.Surname = txtSurname.Value.Trim();
//objCustomer.JobTitle = txtJobTitle.Value.Trim();
//objCustomer.CompanyName = txtCompanyName.Value.Trim();
//objCustomer.CompanyWebsite = txtCompanyWebsite.Value.Trim();
//objCustomer.CompanyLocation = txtLocation.Value.Trim();
//objCustomer.HomeClubID = currentClub.ClubId.Rendered;
//objCustomer.SubscribeToNewsletter = chkSubscribe.Checked;
objCustomer.TelephoneNumber = txtPhoneNumber.Value.Trim();
objCustomer.AddressLine1 = txtAddressLine1.Value.Trim();
objCustomer.AddressLine2 = txtAddressLine2.Value.Trim() != "Address Line 2" ? txtAddressLine2.Value.Trim() : "";
objCustomer.AddressLine3 = txtAddressLine3.Value.Trim();
objCustomer.Postcode = txtPostcode.Value.Trim();
objCustomer.DateOfBirth = Convert.ToDateTime(txtDOBDay.Value.Trim() + "/" + txtDOBMonth.Value.Trim() + "/" + txtDOBYear.Value.Trim(), System.Globalization.CultureInfo.CreateSpecificCulture("en-GB"));
objCustomer.Gender = radMale.Checked ? "M" : "F";
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = "Indoor Triathlon Registration";
objFeedback.FeedbackSubjectDetail = "Virgin Active Website";
objFeedback.FeedbackTypeID = Constants.FeedbackType.IndoorTriathlonRegistration;
//objFeedback.PrimaryClubID = currentClub.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = clubFindSelect.SelectedItem.Text;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = "Club";
List<Comment> objComments = new List<Comment>();
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = raceType;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 2;
objComment.Subject = "Race";
objComments.Add(objComment);
objComment = new Comment();
//objComment.CommentDetail = drpExistingMembers.SelectedValue.ToString() != Translate.Text("Select") ? drpExistingMembers.SelectedValue.ToString() : "";
objComment.CommentDetail = drpRaceDate.SelectedValue;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 3;
objComment.Subject = "Race Day";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = drpTimeSlot.SelectedValue;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 4;
objComment.Subject = "Time Slot";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = radIndividual.Checked ? "Individual" : "Team";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 5;
objComment.Subject = "Individual or Team";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = vaStatus;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 6;
objComment.Subject = "Virgin Active Status";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = txtTeamName.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 7;
objComment.Subject = "Team Name";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = txtFirstName2.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 8;
objComment.Subject = "Team Member 2 First Name";
objComment = new Comment();
objComment.CommentDetail = txtSurname2.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 9;
objComment.Subject = "Team Member 2 Surname";
objComments.Add(objComment);
objComment = new Comment();
if(txtDOBDay2.Value != "DD")
{
objComment.CommentDetail = txtDOBDay2.Value.Trim() != "" ? txtDOBDay2.Value.Trim() + "/" + txtDOBMonth2.Value.Trim() + "/" + txtDOBYear2.Value.Trim() : "";
}
else
{
objComment.CommentDetail = "";
}
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 10;
objComment.Subject = "Team Member 2 Date of Birth";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = radMale2.Checked ? "M" : radFemale2.Checked ? "F" : "";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 11;
objComment.Subject = "Team Member 2 Gender";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = txtFirstName3.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 12;
objComment.Subject = "Team Member 3 First Name";
objComment = new Comment();
objComment.CommentDetail = txtSurname3.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 13;
objComment.Subject = "Team Member 3 Surname";
objComments.Add(objComment);
objComment = new Comment();
if (txtDOBDay3.Value != "DD")
{
objComment.CommentDetail = txtDOBDay3.Value.Trim() != "" ? txtDOBDay3.Value.Trim() + "/" + txtDOBMonth3.Value.Trim() + "/" + txtDOBYear3.Value.Trim() : "";
}
else
{
objComment.CommentDetail = "";
}
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 14;
objComment.Subject = "Team Member 3 Date of Birth";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = radMale3.Checked ? "M" : radFemale3.Checked ? "F" : "";
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 15;
objComment.Subject = "Team Member 3 Gender";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = txtNOKFirstName.Value.Trim() + " " + txtNOKSurname.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 16;
objComment.Subject = "Next of Kin Name";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = txtNOKRelationship.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 17;
objComment.Subject = "Next of Kin Relationship";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = txtNOKPhoneNumber.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 18;
objComment.Subject = "Next of Kin Phone Number";
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
if (dal.SaveFeedback(Context.User.Identity.Name, currentItem.DisplayName, objFeedback) > 0)
{
blnDataSaved = true;
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error saving form data to reports db: {0}", ex.Message), this);
}
return blnDataSaved;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (clubFindSelect1.SelectedIndex != 0 && clubFindSelect2.SelectedIndex != 0)
{
primaryClub = (ClubItem)Sitecore.Context.Database.GetItem(clubFindSelect1.SelectedValue);
secondaryClub = (ClubItem)Sitecore.Context.Database.GetItem(clubFindSelect2.SelectedValue);
if (primaryClub != null && secondaryClub != null)
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer (Referer's) Entitiy Details
Customer objCustomer = new Customer();
objCustomer.EmailAddress = email1.Value;
objCustomer.Firstname = firstName1.Value;
objCustomer.Surname = surname1.Value;
objCustomer.HomeClubID = primaryClub.ClubId.Rendered;
objCustomer.SubscribeToNewsletter = subscribe.Checked;
objCustomer.TelephoneNumber = number1.Value.Trim();
objCustomer.MembershipNumber = memberNo.Value.Trim();
objFeedback.Customer = objCustomer;
objFeedback.FeedbackSubject = campaign.CampaignBase.Campaigntype.Raw;
objFeedback.FeedbackSubjectDetail = campaign.CampaignBase.Campaignname.Rendered;
objFeedback.FeedbackTypeID = Convert.ToInt32(campaign.CampaignBase.CampaignId.Rendered);
objFeedback.PrimaryClubID = primaryClub.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
//Store Referee's Details
List<Comment> objComments = new List<Comment>();
//Add Comment
Comment objComment = new Comment();
objComment.CommentDetail = secondaryClub.ClubId.Rendered;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 1;
objComment.Subject = "Friend's Preferred Club";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = firstName2.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 2;
objComment.Subject = "Friend's First Name";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = surname2.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 3;
objComment.Subject = "Friend's Surname";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = email2.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 4;
objComment.Subject = "Friend's Email";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = number2.Value.Trim();
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 5;
objComment.Subject = "Friend's Number";
objComments.Add(objComment);
objComment = new Comment();
objComment.CommentDetail = permission.Checked == true? "Y" : "N" ;
objComment.CommentImageTypeID = Constants.CommentImageType.QuestionnaireAnswer;
objComment.SortOrder = 6;
objComment.Subject = "Permission to be contacted";
objComments.Add(objComment);
objFeedback.Comments = objComments;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, campaign.DisplayName, objFeedback);
if (successFlag > 0)
{
//Data is sent to client via email
SendAdminEmail();
if (campaign.CampaignBase.Isweblead.Checked == true)
{
//Data is sent to client via service
SendEnquiryDataService();
}
//get managers info
List<ManagerItem> staffMembers = null;
if (primaryClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)) != null)
{
staffMembers = primaryClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)).ToList().ConvertAll(x => new ManagerItem(x));
primaryManager = staffMembers.First();
}
staffMembers = null;
if (secondaryClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)) != null)
{
staffMembers = secondaryClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)).ToList().ConvertAll(x => new ManagerItem(x));
secondaryManager = staffMembers.First();
}
if (campaign.CampaignBase.Sendconfirmationemail.Checked == true)
{
//Data is sent to referer via email
SendPrimaryConfirmationEmail();
if (campaign.CampaignBase.Secondaryemailtemplate.Item != null)
{
//Data is sent to referee via email
SendSecondaryConfirmationEmail();
}
}
pnlForm.Attributes.Add("style", "display:none;");
pnlThanks.Attributes.Add("style", "display:block;");
string classNames = wrapper.Attributes["class"];
wrapper.Attributes.Add("class", "wrapper-thanks");
}
else
{
pnlForm.Attributes.Add("style", "display:block;");
pnlThanks.Attributes.Add("style", "display:none;");
Log.Error(String.Format("Error storing campaign details"), this);
}
}
else
{
pnlForm.Attributes.Add("style", "display:block;");
pnlThanks.Attributes.Add("style", "display:none;");
//string classNames = article.Attributes["class"];
//article.Attributes.Add("class", classNames.Length > 0 ? classNames + " ImageOverlay" : "ImageOverlay");
}
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error storing campaign details: {0}", ex.Message), this);
mm.virginactive.common.EmailMessagingService.ErrorEmailNotification.SendMail(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
//check if we have a valid club selected
Boolean blnClubSuccessfullySelected = clubFindSelect.SelectedIndex != 0;
currentClub = (ClubItem)Sitecore.Context.Database.GetItem(clubFindSelect.SelectedValue);
if (currentClub != null)
{
//Store Feedback Entitiy Details
Feedback objFeedback = new Feedback();
//Store Customer Entitiy Details
Customer objCustomer = new Customer();
string FirstName = "";
string Surname = "";
if (txtName.Value.IndexOf(" ") != -1)
{
FirstName = txtName.Value.Substring(0, txtName.Value.IndexOf(" ")).Trim();
Surname = txtName.Value.Substring(txtName.Value.IndexOf(" ") + 1).Trim();
}
else
{
FirstName = txtName.Value.Trim();
}
objCustomer.EmailAddress = txtEmail.Value;
objCustomer.Firstname = FirstName;
objCustomer.Surname = Surname;
//objCustomer.HomeClubID = txtClubCode.Value;
objCustomer.HomeClubID = currentClub.ClubId.Rendered;
objCustomer.SubscribeToNewsletter = chkSubscribe.Checked;
objCustomer.TelephoneNumber = txtPhone.Value;
objFeedback.Customer = objCustomer;
//objFeedback.FeedbackSubject = campaign.CampaignBase.Campaigntype.Raw;
objFeedback.FeedbackSubject = !String.IsNullOrEmpty(campaign.CampaignBase.Campaigntype.Raw) ? campaign.CampaignBase.Campaigntype.Raw : "";
objFeedback.FeedbackSubjectDetail = campaign.CampaignBase.Campaignname.Rendered;
objFeedback.FeedbackTypeID = Convert.ToInt32(campaign.CampaignBase.CampaignId.Rendered);
objFeedback.PrimaryClubID = currentClub.ClubId.Rendered;
objFeedback.SubmissionDate = DateTime.Now;
//Save to session (required for confirmation page)
Session["sess_FormSubmission"] = objFeedback;
string connection = Sitecore.Configuration.Settings.GetSetting("ConnectionString_VirginActiveReports");
DataAccessLayer dal = new DataAccessLayer(connection);
int successFlag = dal.SaveFeedback(Context.User.Identity.Name, campaign.DisplayName, objFeedback);
if (successFlag > 0)
{
//Data is sent to client via email
SendAdminEmail();
if (campaign.CampaignBase.Isweblead.Checked == true)
{
//Data is sent to client via service
SendEnquiryDataService();
}
//get managers info
List<ManagerItem> staffMembers = null;
if (currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)) != null)
{
staffMembers = currentClub.InnerItem.Axes.SelectItems(String.Format("descendant-or-self::*[@@tid = '{0}']", ManagerItem.TemplateId)).ToList().ConvertAll(x => new ManagerItem(x));
manager = staffMembers.First();
}
if (campaign.CampaignBase.Sendconfirmationemail.Checked == true)
{
//Data is sent to customer via email
SendConfirmationEmail();
}
//Get enquiries link
string ClubEnquiriesUrl = "";
PageSummaryItem enqForm = new PageSummaryItem(Sitecore.Context.Database.GetItem(ItemPaths.EnquiryForm));
if (enqForm != null)
{
ClubEnquiriesUrl = enqForm.Url;
}
Response.Redirect(ClubEnquiriesUrl + "?action=confirm");
}
else
{
Log.Error(String.Format("Error submitting campaign form (mobile) -save to db"), this);
}
}
else
{
Log.Error(String.Format("Error submitting campaign form (mobile) -setting current club"), this);
}
}
}
catch (Exception ex)
{
Log.Error(String.Format("Error submitting campaign form (mobile): {0}", ex.Message), this);
}
}