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); }