protected void btnMemberPrev_Click(object sender, EventArgs e)
{
SForce.SforceService sfdcbindingMembership = new SForce.SforceService();
SForce.LoginResult LoginResult = sfdcbindingMembership.login(strUserName, strPasswd);
sfdcbindingMembership.Url = LoginResult.serverUrl;
sfdcbindingMembership.SessionHeaderValue = new SForce.SessionHeader();
sfdcbindingMembership.SessionHeaderValue.sessionId = LoginResult.sessionId;
queryResultMembership = sfdcbindingMembership.query(strQuerySelectFromMembership);
int nMemberIndex = (int)Session["MemberIndex"];
if (nMemberIndex > 0)
{
nMemberIndex--;
}
Session["MemberIndex"] = nMemberIndex;
SForce.Membership__c membership = (SForce.Membership__c)queryResultMembership.records[nMemberIndex];
txtContactId.Text = membership.Id;
txtMembershipName.Text = membership.Name;
txtMembershipStatus.Text = membership.c4g_Membership_Status__c;
}
protected void btnNext_Click(object sender, EventArgs e)
{
rfvMedicareEligibility.Validate();
rfvMedicareAandB.Validate();
rfvParticipantProgram.Validate();
if ((String)Session["AccountId"] != null)
{
strAccountId = (String)Session["AccountId"];
}
if ((String)Session["ContactId"] != null)
{
strPrimaryContactId = (String)Session["ContactId"];
}
else
{
String strQueryForPrimaryContactId = "select Id from Contact where cmm_Household__c = '" + strAccountId + "' " +
"and cmm_Household_Role__c = 'Head of Household'";
SForce.QueryResult qrPrimaryContactId = Sfdcbinding.query(strQueryForPrimaryContactId);
if (qrPrimaryContactId.size > 0)
{
SForce.Contact ctPrimaryContactId = qrPrimaryContactId.records[0] as SForce.Contact;
strPrimaryContactId = ctPrimaryContactId.Id;
}
}
if ((String)Session["SpouseId"] != null)
{
strSpouseId = (String)Session["SpouseId"];
}
else
{
String strQueryForSpouseId = "select Id from Contact where cmm_Household__c = '" + strAccountId + "' " +
"and cmm_Household_Role__c = 'Spouse'";
SForce.QueryResult qrSpouseId = Sfdcbinding.query(strQueryForSpouseId);
if (qrSpouseId.size > 0)
{
SForce.Contact ctSpouseId = qrSpouseId.records[0] as SForce.Contact;
strSpouseId = ctSpouseId.Id;
}
}
SForce.Contact ctUpdate = new SForce.Contact();
ctUpdate.Id = strPrimaryContactId;
ctUpdate.cmm_Household__c = strAccountId;
ctUpdate.cmm_Household_Role__c = "Head of Household";
// whether or not qualifying medicare
if (rbListMedicareYesNo.SelectedIndex == 0)
{
ctUpdate.c4g_Qualifies_for_Medicare__c = true;
ctUpdate.c4g_Qualifies_for_Medicare__cSpecified = true;
}
if (rbListMedicareYesNo.SelectedIndex == 1)
{
ctUpdate.c4g_Qualifies_for_Medicare__c = false;
ctUpdate.c4g_Qualifies_for_Medicare__cSpecified = true;
}
// whether or not qualifying medicare A and B
if (rbListMedicareAandB.SelectedIndex == 0)
{
ctUpdate.c4g_Qualifies_for_Medicare_A_and_B__c = true;
ctUpdate.c4g_Qualifies_for_Medicare_A_and_B__cSpecified = true;
}
if (rbListMedicareAandB.SelectedIndex == 1)
{
ctUpdate.c4g_Qualifies_for_Medicare_A_and_B__c = false;
ctUpdate.c4g_Qualifies_for_Medicare_A_and_B__cSpecified = true;
}
String strPrimaryProgram = ddlParticipantProgram.SelectedValue.Substring(0, ddlParticipantProgram.SelectedValue.IndexOf('(')).Trim();
String strQueryForPrimaryProgramId = "select Id from c4g_Plan__c where Name = '" + strPrimaryProgram + "'";
SForce.QueryResult qrPrimaryProgramId = Sfdcbinding.query(strQueryForPrimaryProgramId);
if (qrPrimaryProgramId.size > 0)
{
SForce.c4g_Plan__c primaryPlan = qrPrimaryProgramId.records[0] as SForce.c4g_Plan__c;
ctUpdate.c4g_Plan__c = primaryPlan.Id;
SForce.SaveResult[] updateResultsPrimary = Sfdcbinding.update(new SForce.sObject[] { ctUpdate });
if (updateResultsPrimary[0].success)
{
// the primary member's program info added successfully
}
}
String strSpouseProgram = String.Empty;
if (ddlSpouseProgram.Items.Count != 0)
{
strSpouseProgram = ddlSpouseProgram.SelectedValue.Substring(0, ddlSpouseProgram.SelectedValue.IndexOf('(')).Trim();
}
String strQueryForSpouseProgramId = "select Id from c4g_Plan__c where Name = '" + strSpouseProgram + "'";
SForce.QueryResult qrSpouseProgramId = Sfdcbinding.query(strQueryForSpouseProgramId);
if (qrSpouseProgramId.size > 0)
{
SForce.c4g_Plan__c spousePlan = qrSpouseProgramId.records[0] as SForce.c4g_Plan__c;
SForce.Contact ctSpouseUpdate = new SForce.Contact();
ctSpouseUpdate.Id = strSpouseId;
ctSpouseUpdate.c4g_Plan__c = spousePlan.Id;
SForce.SaveResult[] updateResultsSpouse = Sfdcbinding.update(new SForce.sObject[] { ctSpouseUpdate });
if (updateResultsSpouse[0].success)
{
// the spouse's program info is added
}
}
String strChildProgram = String.Empty;
if (ddlChildrenProgram.Items.Count != 0)
{
strChildProgram = ddlChildrenProgram.SelectedValue.Substring(0, ddlChildrenProgram.SelectedValue.IndexOf('(')).Trim();
}
String strQueryForChildProgramId = "select Id from c4g_Plan__c where Name = '" + strChildProgram + "'";
SForce.QueryResult qrChildProgramId = Sfdcbinding.query(strQueryForChildProgramId);
if (qrChildProgramId.size > 0)
{
SForce.c4g_Plan__c childPlan = qrChildProgramId.records[0] as SForce.c4g_Plan__c;
foreach (String strChildId in lstChildId)
{
SForce.Contact ctChildUpdate = new SForce.Contact();
ctChildUpdate.Id = strChildId;
ctChildUpdate.c4g_Plan__c = childPlan.Id;
SForce.SaveResult[] updateResultsChild = Sfdcbinding.update(new SForce.sObject[] { ctChildUpdate });
if (updateResultsChild[0].success)
{
// the child's program info is added
}
}
}
///// This section insert church info to membership detail aspx
String strQueryForHeadOfHouseholdId = "select Id from Contact where cmm_Household__c = '" + strAccountId + "' " + "and cmm_Household_Role__c = 'Head of Household'";
SForce.QueryResult qrHeadOfHouseholdId = Sfdcbinding.query(strQueryForHeadOfHouseholdId);
//String strHeadOfHouseholdId = null;
if (qrHeadOfHouseholdId.size > 0)
{
SForce.Contact ctHead = (SForce.Contact)qrHeadOfHouseholdId.records[0];
String strHeadOfHouseholdId = ctHead.Id;
SForce.Account acctChurchInfo = new SForce.Account();
acctChurchInfo.RecordTypeId = "01237000000R6cjAAC";
acctChurchInfo.Name = txtChurchName.Text;
acctChurchInfo.Senior_Pastor_s_Name__c = txtSeniorPastor.Text;
if (txtChurchStreetAddress.Text != String.Empty)
{
acctChurchInfo.ShippingStreet = txtChurchStreetAddress.Text;
}
if (txtChurchZipCode.Text != String.Empty)
{
acctChurchInfo.ShippingPostalCode = txtChurchZipCode.Text;
}
if (ddlChurchState.Items != null)
{
acctChurchInfo.ShippingState = ddlChurchState.SelectedItem.Text;
}
if (ddlChurchCity.Items != null)
{
acctChurchInfo.ShippingCity = ddlChurchCity.SelectedItem.Text;
}
if (txtChurchPhone.Text != String.Empty)
{
acctChurchInfo.Phone = txtChurchPhone.Text;
}
SForce.SaveResult[] saveAcctResults = Sfdcbinding.create(new SForce.sObject[] { acctChurchInfo });
if (saveAcctResults[0].success)
{
SForce.Contact ctHeadOfHousehold = new SForce.Contact();
ctHeadOfHousehold.Id = strHeadOfHouseholdId;
//ctHeadOfHousehold.Referral_Source__c = ddlReferredBy.SelectedValue;
ctHeadOfHousehold.c4g_Church__c = saveAcctResults[0].id;
SForce.SaveResult[] updateResults = Sfdcbinding.update(new SForce.sObject[] { ctHeadOfHousehold });
if (updateResults[0].success)
{
// notify the user that church information added to household
}
}
}
if (ddlReferredBy.SelectedValue != "")
{
if (ddlReferredBy.SelectedValue == "Member Referral" && txtMembershipNumber.Text != "" && ddlReferrerName.SelectedValue != "")
{
String strMembershipNumber = String.Empty;
if (txtMembershipNumber.Text.Contains("MEMB-"))
{
strMembershipNumber = txtMembershipNumber.Text;
}
else
{
strMembershipNumber = txtMembershipNumber.Text;
if (txtMembershipNumber.Text.Length < 7)
{
for (int i = txtMembershipNumber.Text.Length; i < 7; i++)
{
strMembershipNumber = '0' + strMembershipNumber;
}
}
strMembershipNumber = "MEMB-" + strMembershipNumber;
}
String strQueryForContact = "select Id from Contact where c4g_Membership__r.Name = '" + strMembershipNumber + "' and Name = '" + ddlReferrerName.SelectedValue + "'";
SForce.QueryResult qrContactForMembership = Sfdcbinding.query(strQueryForContact);
if (qrContactForMembership.size > 0)
{
SForce.Contact ctReferrer = qrContactForMembership.records[0] as SForce.Contact;
SForce.Membership__c memReferralInfo = new SForce.Membership__c();
memReferralInfo.Paying_Member__c = strPrimaryContactId;
memReferralInfo.Referred_By__c = ddlReferredBy.SelectedValue;
memReferralInfo.Referrer__c = ctReferrer.Id;
if ((String)Session["Email"] != null)
{
memReferralInfo.Email__c = (String)Session["Email"];
}
SForce.SaveResult[] saveResults = Sfdcbinding.create(new SForce.sObject[] { memReferralInfo });
if (saveResults[0].success)
{
// Membership object is created successfully
String strQueryForFamilyMembers = "select Id from Contact where cmm_Household__c = '" + strAccountId + "'";
SForce.QueryResult qrFamilyMembers = Sfdcbinding.query(strQueryForFamilyMembers);
if (qrFamilyMembers.size > 0)
{
for (int i = 0; i < qrFamilyMembers.size; i++)
{
SForce.Contact ctFamilyMemberId = qrFamilyMembers.records[i] as SForce.Contact;
SForce.Contact ctFamilyMember = new SForce.Contact();
ctFamilyMember.Id = ctFamilyMemberId.Id;
ctFamilyMember.c4g_Membership__c = saveResults[0].id;
SForce.SaveResult[] updateResults = Sfdcbinding.update(new SForce.sObject[] { ctFamilyMember });
if (updateResults[0].success)
{
// Membership object added to each member of the household
}
}
}
}
}
}
else
{
SForce.Membership__c memReferralInfo = new SForce.Membership__c();
memReferralInfo.Paying_Member__c = strPrimaryContactId;
memReferralInfo.Referred_By__c = ddlReferredBy.SelectedValue;
if ((String)Session["Email"] != null)
{
memReferralInfo.Email__c = (String)Session["Email"];
}
SForce.SaveResult[] saveResults = Sfdcbinding.create(new SForce.sObject[] { memReferralInfo });
if (saveResults[0].success)
{
// Membership object is created successfully
// Membership object is created successfully
String strQueryForFamilyMembers = "select Id from Contact where cmm_Household__c = '" + strAccountId + "'";
SForce.QueryResult qrFamilyMembers = Sfdcbinding.query(strQueryForFamilyMembers);
if (qrFamilyMembers.size > 0)
{
for (int i = 0; i < qrFamilyMembers.size; i++)
{
SForce.Contact ctFamilyMemberId = qrFamilyMembers.records[i] as SForce.Contact;
SForce.Contact ctFamilyMember = new SForce.Contact();
ctFamilyMember.Id = ctFamilyMemberId.Id;
ctFamilyMember.c4g_Membership__c = saveResults[0].id;
SForce.SaveResult[] updateResults = Sfdcbinding.update(new SForce.sObject[] { ctFamilyMember });
if (updateResults[0].success)
{
// Membership object added to each member of the household
}
}
}
}
}
}
SForce.Account acctPrimary = new SForce.Account();
acctPrimary.Id = strAccountId;
acctPrimary.cmm_Account_Creation_Step_Code__c = "5";
SForce.SaveResult[] srAccount = Sfdcbinding.update(new SForce.sObject[] { acctPrimary });
if (srAccount[0].success)
{
Session["PreviousPage"] = "MembershipDetails";
Response.Redirect("~/PaymentInfo.aspx");
}
}
protected void btnLoad_Click(object sender, EventArgs e)
{
//Sfdcbinding = new SForce.SforceService();
//CurrentLoginResult = Sfdcbinding.login(strUserName, strPasswd);
//Sfdcbinding.Url = CurrentLoginResult.serverUrl;
//Sfdcbinding.SessionHeaderValue = new SForce.SessionHeader();
//Sfdcbinding.SessionHeaderValue.sessionId = CurrentLoginResult.sessionId;
//strQuerySelectFromContact = "select Id, FirstName, LastName, MailingAddress, Email, MobilePhone, Phone from Contact order by LastName nulls last";
//queryResult = Sfdcbinding.query(strQuerySelectFromContact);
//nTotalRecord = queryResult.size - 1;
if (queryResult.size > 0)
{
contact = (SForce.Contact)queryResult.records[nCurrentIndex];
txtIndividualId.Text = contact.Individual_ID__c;
txtId.Text = contact.Id;
//SForce.Membership__c member = (SForce.Membership__c) contact.Memberships__r.records[0];
if (contact.c4g_Membership__r != null)
{
txtMembershipId.Text = contact.c4g_Membership__r.Id;
txtMembershipNameInContact.Text = contact.c4g_Membership__r.Name;
}
else
{
txtMembershipId.Text = "";
txtMembershipNameInContact.Text = "";
}
//if (contact.c4g_Membership__r != null)
//{
// txtMembershipId.Text = contact.c4g_Membership__r.Id;
// txtMembershipInContact.Text = contact.c4g_Membership__r.Name;
//}
//else if (contact.c4g_Membership__r == null)
//{
// txtMembershipId.Text = "";
// txtMembershipInContact.Text = "";
//}
//txtMembershipId.Text = member.Id;
//txtMembershipNameInContact.Text = member.Name; ;
txtFirstName.Text = contact.FirstName;
txtLastName.Text = contact.LastName;
if (contact.MailingAddress != null)
{
txtStreetAddress.Text = contact.MailingAddress.street;
txtCity.Text = contact.MailingAddress.city;
txtState.Text = contact.MailingAddress.state;
txtZip.Text = contact.MailingAddress.postalCode;
}
else if (contact.MailingAddress == null)
{
txtStreetAddress.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtZip.Text = "";
}
txtMobilePhone.Text = contact.MobilePhone;
txtPhone.Text = contact.Phone;
txtEmail.Text = contact.Email;
}
btnFirst.Enabled = false;
btnPrev.Enabled = false;
btnCreateNewContact.Enabled = true;
btnEdit.Enabled = true;
btnDelete.Enabled = true;
lblErrorMessage.Text = "";
////////////////////////////////////////////////////////////////////////////////
// Testing for select from membership
SForce.SforceService sfdcbindingMembership = new SForce.SforceService();
SForce.LoginResult LoginResult = sfdcbindingMembership.login(strUserName, strPasswd);
sfdcbindingMembership.Url = LoginResult.serverUrl;
sfdcbindingMembership.SessionHeaderValue = new SForce.SessionHeader();
sfdcbindingMembership.SessionHeaderValue.sessionId = LoginResult.sessionId;
queryResultMembership = sfdcbindingMembership.query(strQuerySelectFromMembership);
//strQueryMembershipIdInContact
/////////////////////////////////////
// Testing for Membership field in Contact
SForce.QueryResult queryMembershipInContact = sfdcbindingMembership.query(strQueryMembershipIdInContact);
//SForce.QueryResult queryContactInnerJoinMembership = sfdcbindingMembership.query(strQueryContactInnerJoinMembership);
if (queryMembershipInContact.size > 0)
{
SForce.Contact contactMembership = (SForce.Contact)queryMembershipInContact.records[0];
txtMembershipInContact.Text = contactMembership.c4g_Membership__c;
}
if (queryResultMembership.size > 0)
{
SForce.Membership__c membership = (SForce.Membership__c)queryResultMembership.records[0];
//SForce.Contact contact = (SForce.Contact)queryResultMembership.records[0];
txtContactId.Text = membership.Id;
txtMembershipName.Text = membership.Name;
txtMembershipStatus.Text = membership.c4g_Membership_Status__c;
//txtContactId.Text = contact.Id;
//txtMembershipName.Text = contact.Name; ; //membership.Name;
//txtMembershipStatus.Text = contact.c4g_Membership_Status__c; //membership.c4g_Membership_Status__c;
int nMemberIndex = 0;
Session["MemberIndex"] = nMemberIndex;
}
if (queryResultTask.size > 0)
{
SForce.Task task = (SForce.Task)queryResultTask.records[nCurrentIndexTask];
txtTaskName.Text = task.Id;
txtTaskComment.Text = task.Description;
Session["TaskIndex"] = ++nCurrentIndexTask;
Session["CurrentTaskId"] = task.Id;
}
}