public int AddMessage(int moduleId, int fatherId, String userName, String title, String body, String face) {

if (userName.Length < 1) {

userName = "unknown";

}

// Create Instance of Connection and Command Object

SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);

SqlCommand myCommand = new SqlCommand("up_PostTopic", myConnection);

// Mark the Command as a SPROC

myCommand.CommandType = CommandType.StoredProcedure;

// Add Parameters to SPROC

SqlParameter parameterItemID = new SqlParameter("@ItemID", SqlDbType.Int, 4);

parameterItemID.Direction = ParameterDirection.Output;

myCommand.Parameters.Add(parameterItemID);

SqlParameter parameterFatherId = new SqlParameter("@FatherID", SqlDbType.Int, 4);

parameterFatherId.Value = fatherId;

myCommand.Parameters.Add(parameterFatherId);

SqlParameter parameterModuleID = new SqlParameter("@ModuleID", SqlDbType.Int, 4);

parameterModuleID.Value = moduleId;

myCommand.Parameters.Add(parameterModuleID);

SqlParameter parameterUserName = new SqlParameter("@CreatedByUser", SqlDbType.NVarChar, 100);

parameterUserName.Value = userName;

myCommand.Parameters.Add(parameterUserName);

SqlParameter parameterTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 100);

parameterTitle.Value = title;

myCommand.Parameters.Add(parameterTitle);

SqlParameter parameterBody = new SqlParameter("@Content", SqlDbType.NVarChar, 4000);

parameterBody.Value = body;

myCommand.Parameters.Add(parameterBody);

SqlParameter parameterFace = new SqlParameter("@Face", SqlDbType.NVarChar, 100);

parameterFace.Value = face;

myCommand.Parameters.Add(parameterFace);

myConnection.Open();

myCommand.ExecuteNonQuery();

myConnection.Close();

return (int) parameterItemID.Value;

}