public void CreateUser(string sUserCode, string sUserName, string sDefaultEntity, string sDefaultBranchCode, string sDefaultDeptCode, string sPassword, string sLocked, string sDefaultApprovalLevel, string sApprovalScope, string sLanguage) { string sCompany = string.Empty; string sResult = string.Empty; sFuncName = "CreateUser"; try { oLog.WriteToDebugLogFile("Create New User Function", sFuncName); sSQL = string.Format("call \"AE_SP003_CREATEUSER\"('" + sUserCode + "','" + sUserName + "','" + sDefaultEntity + "','" + sDefaultBranchCode + "','" + sDefaultDeptCode + "','" + sPassword + "','" + sLocked + "','" + sDefaultApprovalLevel + "','" + sApprovalScope + "','" + sLanguage + "')"); oLog.WriteToDebugLogFile("Execute SQL" + sSQL, sFuncName); OdbcParameter[] Param = new OdbcParameter[0]; oCommon.ExecuteQuery(sSQL, sCompany, Param); 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)); } }