NEWS

Monday, March 22, 2010

Core AJAX example using XMLDOM and XMLHttpRequest ActiveX Objects

Javascript:

function GetEmpDetails(obj)
{
if(obj.value!='')
{
var xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
var xmlHttp=new ActiveXObject('Msxml2.XMLHTTP')
xmlHttp.open('GET','ServerPage.aspx?empid=' + obj.value ,false);
xmlHttp.send(null)
//alert(xmlHttp.responseText);
xmlDoc.loadXML(xmlHttp.responseText)
var result = xmlDoc.getElementsByTagName('result');

if(result[0].text==1)
{
var EmpFirstName = xmlDoc.getElementsByTagName('EmpFirstName');
var EmpPreferredFirstName = xmlDoc.getElementsByTagName('EmpPreferredFirstName');
var EmpLastName = xmlDoc.getElementsByTagName('EmpLastName');
var EmpPhoneNum = xmlDoc.getElementsByTagName('EmpPhoneNum');

document.getElementById('ctl00_MainContent_txtHLCName').value = EmpFirstName[0].text + ' ' + EmpLastName[0].text;
document.getElementById('ctl00_MainContent_hdnEmpPreferredFirstName').value = EmpPreferredFirstName[0].text;
document.getElementById('ctl00_MainContent_txtHLCPhone').value = EmpPhoneNum[0].text;
}
else if(result[0].text==0)
{
document.getElementById('ctl00_MainContent_txtHLCName').value = '';
document.getElementById('ctl00_MainContent_hdnEmpPreferredFirstName').value = '';
document.getElementById('ctl00_MainContent_txtHLCPhone').value = '';
alert("Employee # does not exist in PeopleMart. Please enter a valid employee number");
obj.focus();
}
}
return false;
}
function GetLSDetails(obj)
{
if(obj.value!='')
{
var xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
var xmlHttp=new ActiveXObject('Msxml2.XMLHTTP')
xmlHttp.open('GET','ServerPage.aspx?lsid=' + obj.value ,false);
xmlHttp.send(null)
//alert(xmlHttp.responseText);

xmlDoc.loadXML(xmlHttp.responseText)
var result = xmlDoc.getElementsByTagName('result');

if(result[0].text==1)
{
var EmpFirstName = xmlDoc.getElementsByTagName('EmpFirstName');
var EmpPreferredFirstName = xmlDoc.getElementsByTagName('EmpPreferredFirstName');
var EmpLastName = xmlDoc.getElementsByTagName('EmpLastName');
var EmpPhoneNum = xmlDoc.getElementsByTagName('EmpPhoneNum');

document.getElementById('ctl00_MainContent_txtLSName').value = EmpFirstName[0].text + ' ' + EmpLastName[0].text;
document.getElementById('ctl00_MainContent_hdnLSPreferredFirstName').value = EmpPreferredFirstName[0].text;
document.getElementById('ctl00_MainContent_txtLSPhone').value = EmpPhoneNum[0].text;
}
else if(result[0].text==0)
{
document.getElementById('ctl00_MainContent_txtLSName').value = '';
document.getElementById('ctl00_MainContent_hdnLSPreferredFirstName').value = '';
document.getElementById('ctl00_MainContent_txtLSPhone').value = '';
alert("Loan Specialist # does not exist in PeopleMart. Please enter a valid Loan Specialist number");
obj.focus();
}
}
return false;
}


C# code:

protected void Page_Load(object sender, EventArgs e)
{
try
{
DataTable dtResult = new DataTable();
DataTable dtBranchResult = new DataTable();
DataTable dtHlcResult = new DataTable();

Response.Write("");
if (Request.QueryString["empid"] != null)
{
string empid = Request.QueryString["empid"].ToString();
dtResult = KonaAccess.GetEmpDetails(empid);
}

else if (Request.QueryString["lsid"] != null)
{
string lsid = Request.QueryString["lsid"].ToString();
dtResult = KonaAccess.GetLSDetails(lsid);
}
else if (Request.QueryString["BrNum"] != null)
{
int BrNum = Convert.ToInt32(Request.QueryString["BrNum"].ToString());
dtBranchResult = JVPortalAccess.GetBranchDetails(BrNum);
}
else if (Request.QueryString["HlcId"] != null)
{
string HlcId = Request.QueryString["HlcId"].ToString();
dtHlcResult = KonaAccess.GetHLC(HlcId);
}

if (dtResult.Rows.Count > 0)
{
string EmpPhone = string.Empty;
if (Utils.Safetext(dtResult.Rows[0][3].ToString().Trim()).Length == 12)
{
EmpPhone = Utils.Safetext(dtResult.Rows[0][3].ToString().Trim());
EmpPhone = "(" + EmpPhone.Substring(0, 3) + ")" + "" + EmpPhone.Substring(4, 3) + "-" + EmpPhone.Substring(8, 4);
}
else
{
EmpPhone = dtResult.Rows[0][3].ToString().Trim();
}
Response.Write("1");
Response.Write("" + dtResult.Rows[0][0].ToString() + "");
Response.Write("" + dtResult.Rows[0][1].ToString() + "");
Response.Write("" + dtResult.Rows[0][2].ToString() + "");
Response.Write("" + EmpPhone + "");
}
else if (dtBranchResult.Rows.Count > 0)
{
string BranchPhone = string.Empty;
string BranchFax = string.Empty;
if (dtBranchResult.Rows[0]["BranchPhone"].ToString().Trim().Length == 10)
{
BranchPhone = dtBranchResult.Rows[0]["BranchPhone"].ToString().Trim();
BranchPhone = "(" + BranchPhone.Substring(0, 3) + ")" + "" + BranchPhone.Substring(3, 3) + "-" + BranchPhone.Substring(6, 4);
}
else
{
BranchPhone = dtBranchResult.Rows[0]["BranchPhone"].ToString().Trim();
}
if (dtBranchResult.Rows[0]["BranchFax"].ToString().Trim().Length == 10)
{
BranchFax = dtBranchResult.Rows[0]["BranchFax"].ToString().Trim();
BranchFax = "(" + BranchFax.Substring(0, 3) + ")" + "" + BranchFax.Substring(3, 3) + "-" + BranchFax.Substring(6, 4);
}
else
{
BranchFax = dtBranchResult.Rows[0]["BranchFax"].ToString().Trim();
}

Response.Write("1");
Response.Write("" + dtBranchResult.Rows[0]["BranchAddress"].ToString().Trim() + "");
Response.Write("" + dtBranchResult.Rows[0]["BranchCity"].ToString().Trim() + "");
Response.Write("" + dtBranchResult.Rows[0]["BranchState"].ToString().Trim() + "");
Response.Write("" + dtBranchResult.Rows[0]["BranchZip"].ToString().Trim() + "");
Response.Write("" + BranchPhone + "");
Response.Write("" + BranchFax + "");
}
else if (dtHlcResult.Rows.Count > 0)
{
Response.Write("1");
}
else
{
Response.Write("0");
}
}
catch (Exception Ex)
{
Response.Write("2");
Response.Write("" + Ex.Message + "");

//throw;
}
Response.Write("
");

}

No comments:

Post a Comment