public List <usp_GetEntityNotes_Result> GetEntityNotes(string userCode, string entityURI)
{
using (var context = new EntityNotesEntities())
{
var tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
var result = new ObjectParameter("Result", typeof(int?));
var debugMsg = new ObjectParameter("DebugMsg", typeof(string));
return(context.usp_GetEntityNotes(userCode, entityURI, tranDT, result, 0, debugMsg).ToList());
}
}
public void ModifyEntityNote(string userCode, string entityURI, int rowID, string subjectLine, string body,
string referencedURI, string categoryName, int?importanceFlag, int?privacyFlag)
{
using (var context = new EntityNotesEntities())
{
var tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
var result = new ObjectParameter("Result", typeof(int?));
var debugMsg = new ObjectParameter("DebugMsg", typeof(string));
context.usp_ModifyEntityNote(userCode, entityURI, rowID, subjectLine, body,
referencedURI, categoryName, importanceFlag, privacyFlag, tranDT, result, 0, debugMsg);
}
}
public void AddEntityNote(string userCode, string entityURI, string subjectLine, string body,
string referencedURI, string categoryName, int?importanceFlag, int?privacyFlag, int?parentNote)
{
using (var context = new EntityNotesEntities())
{
var newNoteID = new ObjectParameter("NewNoteID", typeof(int));
var newNoteGUID = new ObjectParameter("NewNoteGUID", typeof(UniqueId));
var tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
var result = new ObjectParameter("Result", typeof(int?));
var debugMsg = new ObjectParameter("DebugMsg", typeof(string));
context.usp_AddEntityNote(userCode, entityURI, subjectLine, body, referencedURI,
categoryName, importanceFlag, privacyFlag, parentNote, newNoteID, newNoteGUID, tranDT, result, 0,
debugMsg);
}
}
