[WebMethod] public string InitBPMobile(string strStaffCode) { string strXML = ""; strXML += "<bp>" + Environment.NewLine; #region Classes string strClassQuery = ""; string strUserQuery = "SELECT * FROM usersmaster WHERE userCode IN (SELECT userCode FROM staff WHERE staffCode ='{0}' )"; strUserQuery = string.Format(strUserQuery, strStaffCode); DataTable dtUser = _dalObj.getSqlQuery(strUserQuery); string _userName = "", _userPwd = ""; if (dtUser.Rows.Count > 0) { _userName = dtUser.Rows[0]["username"].ToString(); _userPwd = dtUser.Rows[0]["password"].ToString(); } strClassQuery = "SELECT DISTINCT ClassCode, (SELECT ClassName FROM classmaster innr WHERE innr.ClassCode = v.ClassCode) ClassName FROM v_staffclass v WHERE staffCode = '{0}' ORDER BY ClassCode"; strClassQuery = string.Format(strClassQuery, strStaffCode); string strClasses = ""; DataTable dtClass = _dalObj.getSqlQuery(strClassQuery); if (dtClass.Rows.Count > 0) { strXML += "<username>" + _userName + "</username><password>" + _userPwd + "</password>" + Environment.NewLine; strXML += "<classes>" + Environment.NewLine; foreach (DataRow dr in dtClass.Rows) { if (strClasses == "") strClasses = "'" + dr["ClassCode"].ToString() + "'"; else strClasses += ",'" + dr["ClassCode"].ToString() + "'"; strXML += "<class>" + Environment.NewLine; strXML += "<classcode>" + dr["ClassCode"].ToString() + "</classcode>" + Environment.NewLine; strXML += "<classname>" + dr["ClassName"].ToString() + "</classname>" + Environment.NewLine; strXML += "</class>" + Environment.NewLine; } strXML += "</classes>" + Environment.NewLine; } else { strXML += "<result>Invalid Staff Code</result>" + Environment.NewLine; strXML += "</bp>" + Environment.NewLine; return strXML; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)