// ================================================================================
public string GetCprFromLoginname(string context, string loginName, ref string aux)
{
//CREATE PROCEDURE spGK_PMU_GetCPRFromLoginName
// @context VARCHAR(120),
// @loginName VARCHAR(30),
// @cprNo VARCHAR(10) OUTPUT,
// @aux VARCHAR(1020) OUTPUT
// Init params
StoredProcedureCallContext.ClearStandardParams(ref context, ref aux);
StoredProcedureCallContext spContext = new StoredProcedureCallContext("CPRMapperDB", "spGK_PMU_GetCPRFromLoginName");
spContext.AddInParameter("loginName", DbType.String, loginName.Trim());
spContext.AddOutParameter("cprNo", DbType.String, 10);
spContext.ExecuteNonQueryWithReturnValue();
aux = spContext.Aux;
return(spContext.GetParameterStringValue("cprNo"));
}
// ================================================================================
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 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");
}