//UserType
public void insertUpdateUserType(string DataTitle, VD_USERSTYPE userType, ref string outputMsg, ref long outputResult)
{
SqlCommand command = this.DataManager.CreateCommand(DataTitle, CommandType.StoredProcedure);
DataManager.AddParameterWithValue(command, "@UserTypeID", userType.UserTypeID);
DataManager.AddParameterWithValue(command, "@UserTypeName", userType.UserTypeName);
DataManager.AddParameterWithValue(command, "@IsActive", userType.IsActive);
DataManager.AddParameterWithValue(command, "@zIndex", userType.zIndex);
SqlParameter paramOutputMsg = new SqlParameter("@outputMsg", SqlDbType.NVarChar, 1000);
paramOutputMsg.Direction = ParameterDirection.Output;
DataManager.AddParameter(command, paramOutputMsg);
SqlParameter paramOutputResult = new SqlParameter("@outputResult", SqlDbType.BigInt);
paramOutputResult.Direction = ParameterDirection.Output;
DataManager.AddParameter(command, paramOutputResult);
DataManager.ExecuteNonQuery(command);
if (paramOutputResult.Value != null)
{
outputResult = (long)paramOutputResult.Value;
outputMsg = paramOutputMsg.Value.ToString();
}
else
{
outputResult = -1;
outputMsg = string.Empty;
}
}
public void insertUpdateUserType(string DataTitle, VD_USERSTYPE userType, ref string outputMsg, ref long outputResult)
{
_DB.insertUpdateUserType(DataTitle, userType, ref outputMsg, ref outputResult);
}
