// ================================================================================
public void GetDBRuntimeInfo(string context, ref string aux)
{
//CREATE PROCEDURE spGK_CORE_GetRuntimeInfo
// @context VARCHAR(120),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_CORE_GetRuntimeInfo");
int retVal = spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
}
// ================================================================================
public string Probe(string context, ref string aux)
{
//CREATE PROCEDURE spGK_PM_Probe
// @context VARCHAR(120),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
try
{
string result = "";
IPrincipal threadPrincipal = Thread.CurrentPrincipal;
IIdentity principalIdentity = threadPrincipal.Identity;
result += "Probe execution context=[" + principalIdentity.Name + "], principal is authenticated=[" + principalIdentity.IsAuthenticated.ToString() + "] with authenticationtype=[" + principalIdentity.AuthenticationType + "].";
result += "\n\nRuntime info=[" + Info.GetRuntimeInfo() + "].";
result += "\nGK framework runtime info=[" + Info.GetGKAppRuntimeInfo() + "].";
DateTime then = DateTime.Now;
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PM_Probe");
int recCount = spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
TimeSpan dbQueryTime = DateTime.Now - then;
result += "\n\nPersonmaster DB=[" + aux + "], no of personmaster records=[" + recCount.ToString() + "], querytime (ms)=[" + dbQueryTime.Milliseconds.ToString("000000") + "], SP return value=[" + spContext.ReturnValue.ToString() + "].";
return(result);
}
catch (Exception ex)
{
string innerMsg = "null";
if (ex.InnerException != null)
{
innerMsg = ex.InnerException.Message;
}
throw new Exception("Probe() call failed, message=[" + ex.Message + "], inner exception message=[" + innerMsg + "]");
}
}
// ================================================================================
public void DeleteLoginname(string context, string loginName, ref string aux)
{
//CREATE PROCEDURE spGK_PMU_DeleteLoginName
// @context VARCHAR(120),
// @loginName VARCHAR(30),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PMU_DeleteLoginName");
spContext.AddInParameter("loginName", DbType.String, loginName.Trim());
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
}
// ================================================================================
private void SetRegisterNonAdminUser(string context, string cprNo, bool value, ref string aux)
{
//CREATE PROCEDURE spGK_N2L_RegisterNonAdminUser
// @context VARCHAR(120),
// @cprNo VARCHAR(10),
// @register INTEGER,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_N2L_RegisterNonAdminUser");
spContext.AddInParameter("cprNo", DbType.String, cprNo.Trim());
spContext.AddInParameter("register", DbType.Int32, (value ? 1 : 0));
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
}
// ================================================================================
public Guid GetObjectOwnerIDFromNamespace(string context, string nameSpace, ref string aux)
{
//CREATE PROCEDURE spGK_PM_GetOwnerIDFromNamespace
// @context VARCHAR(120),
// @objectOwnerID uniqueidentifier OUTPUT,
// @objectOwnerNamespace VARCHAR(510),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PM_GetOwnerIDFromNamespace");
spContext.AddInParameter("objectOwnerNamespace", DbType.String, nameSpace.Trim());
spContext.AddOutParameter("objectOwnerID", DbType.Guid);
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return(spContext.GetParameterGuidValue("objectOwnerID"));
}
// ================================================================================
public bool IsRegisteredNonAdminUser(string context, string cprNo, ref string aux)
{
//CREATE PROCEDURE spGK_N2L_IsRegisteredNonAdminUser
// @context VARCHAR(120),
// @cprNo VARCHAR(10),
// @registered INTEGER OUTPUT,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_N2L_IsRegisteredNonAdminUser");
spContext.AddInParameter("cprNo", DbType.String, cprNo.Trim());
spContext.AddOutParameter("registered", DbType.Int32);
int registered = spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return(registered == 1);
}
// ================================================================================
//public string GetPrimaryLoginnameFromCpr(string context, string cprNo, ref string aux)
//{
// string result = "";
// result = GetPreferredLoginnameFromCpr(context, cprNo, ref aux);
// aux += "This operation is deprecated (as of 20110106). Use operation GetPreferredLoginnameFromCpr() instead! ";
// return result;
//}
// ================================================================================
public string GetPreferredLoginnameFromCpr(string context, string cprNo, ref string aux)
{
//CREATE PROCEDURE spGK_PMU_GetLoginNameFromCPR
// @context VARCHAR(120),
// @cprNo VARCHAR(10),
// @loginName VARCHAR(30) OUTPUT,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PMU_GetLoginNameFromCPR");
spContext.AddInParameter("cprNo", DbType.String, cprNo.Trim());
spContext.AddOutParameter("loginName", DbType.String, 30);
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return(spContext.GetParameterStringValue("loginName"));
}
// ================================================================================
public string GetCprFromObjectID(string context, Guid objectID, ref string aux)
{
//CREATE PROCEDURE spGK_PM_GetCPRFromObjectID
// @context VARCHAR(120),
// @objectID uniqueidentifier,
// @cprNo VARCHAR(10) OUTPUT,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PM_GetCPRFromObjectID");
spContext.AddInParameter("objectID", DbType.Guid, objectID);
spContext.AddOutParameter("cprNo", DbType.String, 10);
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return(spContext.GetParameterStringValue("cprNo"));
}
// ================================================================================
public void DeleteLoginname(string context, string loginName, ref string aux)
{
//CREATE PROCEDURE spGK_PMU_DeleteLoginName
// @context VARCHAR(120),
// @loginName VARCHAR(30),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PMU_DeleteLoginName");
spContext.AddInParameter("loginName", DbType.String, loginName.Trim());
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
}
// ================================================================================
private void SetRegisterNonAdminUser(string context, string cprNo, bool value, ref string aux)
{
//CREATE PROCEDURE spGK_N2L_RegisterNonAdminUser
// @context VARCHAR(120),
// @cprNo VARCHAR(10),
// @register INTEGER,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_N2L_RegisterNonAdminUser");
spContext.AddInParameter("cprNo", DbType.String, cprNo.Trim());
spContext.AddInParameter("register", DbType.Int32, (value ? 1 : 0));
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
}
// ================================================================================
public Guid CreateObjectOwner(string context, string nameSpace, Guid objectOwnerID, ref string aux)
{
//CREATE PROCEDURE spGK_PM_GetOwnerIDFromNamespace
// @context VARCHAR(120),
// @objectOwnerID uniqueidentifier OUTPUT,
// @objectOwnerNamespace VARCHAR(510),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
aux = "CREATE-ON-NON-EXISTENCE";
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PM_GetOwnerIDFromNamespace", context, aux);
spContext.AddInParameter("objectOwnerNamespace", DbType.String, nameSpace.Trim());
spContext.AddInOutParameter("objectOwnerID", DbType.Guid, null);
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return spContext.GetParameterGuidValue("objectOwnerID");
}
// ================================================================================
public string Probe(string context, ref string aux)
{
//CREATE PROCEDURE spGK_PM_Probe
// @context VARCHAR(120),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
try
{
string result = "";
IPrincipal threadPrincipal = Thread.CurrentPrincipal;
IIdentity principalIdentity = threadPrincipal.Identity;
result += "Probe execution context=[" + principalIdentity.Name + "], principal is authenticated=[" + principalIdentity.IsAuthenticated.ToString() + "] with authenticationtype=[" + principalIdentity.AuthenticationType + "].";
result += "\n\nRuntime info=[" + Info.GetRuntimeInfo() + "].";
result += "\nGK framework runtime info=[" + Info.GetGKAppRuntimeInfo() + "].";
DateTime then = DateTime.Now;
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PM_Probe");
int recCount = spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
TimeSpan dbQueryTime = DateTime.Now - then;
result += "\n\nPersonmaster DB=[" + aux + "], no of personmaster records=[" + recCount.ToString() + "], querytime (ms)=[" + dbQueryTime.Milliseconds.ToString("000000") + "], SP return value=[" + spContext.ReturnValue.ToString() + "].";
return result;
}
catch (Exception ex)
{
string innerMsg = "null";
if (ex.InnerException != null)
{
innerMsg = ex.InnerException.Message;
}
throw new Exception("Probe() call failed, message=[" + ex.Message + "], inner exception message=[" + innerMsg + "]");
}
}
// ================================================================================
public bool IsRegisteredNonAdminUser(string context, string cprNo, ref string aux)
{
//CREATE PROCEDURE spGK_N2L_IsRegisteredNonAdminUser
// @context VARCHAR(120),
// @cprNo VARCHAR(10),
// @registered INTEGER OUTPUT,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_N2L_IsRegisteredNonAdminUser");
spContext.AddInParameter("cprNo", DbType.String, cprNo.Trim());
spContext.AddOutParameter("registered", DbType.Int32);
int registered = spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return (registered == 1);
}
// ================================================================================
//public string GetPrimaryLoginnameFromCpr(string context, string cprNo, ref string aux)
//{
// string result = "";
// result = GetPreferredLoginnameFromCpr(context, cprNo, ref aux);
// aux += "This operation is deprecated (as of 20110106). Use operation GetPreferredLoginnameFromCpr() instead! ";
// return result;
//}
// ================================================================================
public string GetPreferredLoginnameFromCpr(string context, string cprNo, ref string aux)
{
//CREATE PROCEDURE spGK_PMU_GetLoginNameFromCPR
// @context VARCHAR(120),
// @cprNo VARCHAR(10),
// @loginName VARCHAR(30) OUTPUT,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PMU_GetLoginNameFromCPR");
spContext.AddInParameter("cprNo", DbType.String, cprNo.Trim());
spContext.AddOutParameter("loginName", DbType.String, 30);
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return spContext.GetParameterStringValue("loginName");
}
// ================================================================================
public void GetDBRuntimeInfo(string context, ref string aux)
{
//CREATE PROCEDURE spGK_CORE_GetRuntimeInfo
// @context VARCHAR(120),
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_CORE_GetRuntimeInfo");
int retVal = spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
}
// ================================================================================
public string GetCprFromObjectID(string context, Guid objectID, ref string aux)
{
//CREATE PROCEDURE spGK_PM_GetCPRFromObjectID
// @context VARCHAR(120),
// @objectID uniqueidentifier,
// @cprNo VARCHAR(10) OUTPUT,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PM_GetCPRFromObjectID");
spContext.AddInParameter("objectID", DbType.Guid, objectID);
spContext.AddOutParameter("cprNo", DbType.String, 10);
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return spContext.GetParameterStringValue("cprNo");
}
