public void GetUserInfo(string sCompany) { DataTable dtResult = new DataTable(); string sResult = string.Empty; try { oLog.WriteToDebugLogFile("Starting Function", sFuncName); //sSQL = string.Format("call \"AE_SP001_UFF_Generation\" ('{0}')", sFileId); sSQL = string.Format("call \"AE_SP001_GETALLUSERS\""); oLog.WriteToDebugLogFile("Execute SQL" + sSQL, sFuncName); OdbcParameter[] Param = new OdbcParameter[0]; dtResult = oCommon.ExecuteSQLQuery(sSQL, sCompany, Param); List <Users> lstUsers = new List <Users>(); if (dtResult.Rows.Count > 0) { foreach (DataRow r in dtResult.Rows) { Users _company = new Users(); _company.USERCODE = r["USERCODE"].ToString(); _company.USERNAME = r["USERNAME"].ToString(); _company.DEFAULTENTITY = r["DEFAULTENTITY"].ToString(); _company.DEFAULTBRANCHCODE = r["DEFAULTBRANCHCODE"].ToString(); _company.DEFAULTDEPTCODE = r["DEFAULTDEPTCODE"].ToString(); _company.PASSWORD = r["PASSWORD"].ToString(); _company.LOCKED = r["LOCKED"].ToString(); _company.DEFAULTAPPROVALLEVEL = r["DEFAULTAPPROVALLEVEL"].ToString(); _company.APPROVALSCOPE = r["APPROVAL SCOPE"].ToString(); _company.LANGUAGE = r["LANGUAGE"].ToString(); lstUsers.Add(_company); } oLog.WriteToDebugLogFile("Before Serializing the Company List ", sFuncName); Context.Response.Output.Write(js.Serialize(lstUsers)); oLog.WriteToDebugLogFile("After Serializing the Company List , the Serialized data is ' " + js.Serialize(lstUsers) + " '", sFuncName); } else { Context.Response.Output.Write(js.Serialize(lstUsers)); } oLog.WriteToDebugLogFile("Ending Function", sFuncName); } catch (Exception ex) { sErrDesc = ex.Message.ToString(); oLog.WriteToErrorLogFile(sErrDesc, sFuncName); oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName); result objResult = new result(); objResult.Result = "Error"; objResult.DisplayMessage = sErrDesc; lstResult.Add(objResult); Context.Response.Output.Write(js.Serialize(lstResult)); } }