// ================================================================================ 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"); }