protected void btnTaskLast_Click(object sender, EventArgs e)
{
if (queryResultTask.size > 0)
{
nCurrentIndexTask = queryResultTask.size - 1;
SForce.Task task = (SForce.Task)queryResultTask.records[nCurrentIndexTask];
txtTaskName.Text = task.Id;
txtTaskComment.Text = task.Description;
Session["TaskIndex"] = nCurrentIndexTask;
Session["CurrentTaskId"] = task.Id;
}
}
protected void btnUpdateComment_Click(object sender, EventArgs e)
{
//string strId = (string)Session["CurrentId"];
SForce.Task task_update = new SForce.Task();
string Id = (string)Session["CurrentTaskId"];
task_update.Id = Id;
task_update.Description = txtTaskComment.Text;
//contact_update.Id = strId;
//contact_update.FirstName = txtFirstName.Text;
//contact_update.LastName = txtLastName.Text;
//contact_update.MailingStreet = txtStreetAddress.Text;
//contact_update.MailingCity = txtCity.Text;
//contact_update.MailingState = txtState.Text;
//contact_update.MailingPostalCode = txtZip.Text;
//contact_update.MobilePhone = txtMobilePhone.Text;
//contact_update.Phone = txtPhone.Text;
//contact_update.Email = txtEmail.Text;
SForce.SforceService sfdcbinding = new SForce.SforceService();
SForce.LoginResult login_result = null;
login_result = sfdcbinding.login(strUserName, strPasswd);
sfdcbinding.Url = login_result.serverUrl;
sfdcbinding.SessionHeaderValue = new SForce.SessionHeader();
sfdcbinding.SessionHeaderValue.sessionId = login_result.sessionId;
SForce.SaveResult[] saveResults = sfdcbinding.update(new SForce.sObject[] { task_update });
if (saveResults[0].success)
{
lblTaskCommentUpdateResult.Text = "Success!";
}
else
{
lblTaskCommentUpdateResult.Text = saveResults[0].errors[0].message;
}
}
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;
}
}
