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));
}
}
