internal Note GetNote(int NoteId)
{
string sSQL = "Select Id, SyncTime, Description, SessionId," +
" IsDefault, Created" +
" FROM tblNotes WHERE Id = " + NoteId;
DataSet DS = RF.GetDataSet(sSQL);
DataTable DT = DS.Tables[0];
Note X = new Note();
if(DT.Rows.Count == 0)
return X;
foreach(DataRow r in DT.Rows)
{
X.mvarID = Convert.ToInt32(r[0]);
X.mvarDescription = Convert.ToString(r[2]);
X.mvarSyncTime = Convert.ToString(r[1]);
X.mvarSessionID = Convert.ToInt32(r[3]);
//X.mvarUserId = Convert.ToInt32(r[4]);
X.mvarIsDefault = Convert.ToBoolean(r[4]);
X.mvarCreated = Convert.ToDateTime(r[5]);
}
return X;
}
/// <summary>
/// Get all Notes associated with this RecordingId ordered by SyncTime
/// </summary>
/// <param name="RecordingId"></param>
/// <returns></returns>
internal Notes GetNotes(int RecordingId)
{
string sSQL = "Select Id,SyncTime,Description,SessionId,UserId,IsDefault, Created FROM tblNotes WHERE RecordingId = " + RecordingId.ToString() +
" ORDER BY SyncTime";
DataSet DS = RF.GetDataSet(sSQL);
DataTable DT = DS.Tables[0];
Notes TheseNotes = new Notes();
if(DT.Rows.Count == 0)
return TheseNotes;
foreach(DataRow r in DT.Rows)
{
Note X = new Note();
X.mvarID = Convert.ToInt32(r[0]);
X.mvarDescription = Convert.ToString(r[2]);
X.mvarSyncTime = Convert.ToString(r[1]);
X.mvarSessionID = Convert.ToInt32(r[3]);
//X.mvarUserId = Convert.ToInt32(r[4]);
X.mvarIsDefault = Convert.ToBoolean(r[4]);
X.mvarCreated = Convert.ToDateTime(r[5]);
TheseNotes.Add(X);
}
return TheseNotes;
}
public void Add(Note X)
{
List.Add(X);
}
