public void ShowNote(DateTime selectedDate) { NotesBLL notes = new NotesBLL(); TimeKeeper.NotesDataTable note = notes.GetNoteByUserID((int)Session["UserID"]); string noteTitle = "Your Notes:"; if (note.Count > 0) { NotesLabel.Visible = true; TimeKeeper.NotesRow row = note[0]; Session["NoteID"] = row.NotesId; if (note.NoteTextColumn.ToString().Length > 0) { NotesLabel.Text = "<div id=\"notebox\"><h4>" + noteTitle + "</h4>" + row.NoteText.Replace("\n", "<br />") + "</div>"; } } else { NotesLabel.Visible = false; } }
public bool AddNote(int userID, string noteText) { //Create a new NoteRow instance TimeKeeper.NotesDataTable Notes = new TimeKeeper.NotesDataTable(); TimeKeeper.NotesRow note = Notes.NewNotesRow(); note.UserId = userID; note.NoteText = noteText; //Add the new note Notes.AddNotesRow(note); int rowsAffected = Adaptor.Update(Notes); //Return true if precisely one row was inserted, otherwise false return rowsAffected == 1; }
public bool UpdateNote(int userID, string noteText, int noteID) { TimeKeeper.NotesDataTable notes = Adaptor.GetNoteByNoteID(noteID); if (notes.Count == 0) return false; TimeKeeper.NotesRow note = notes[0]; note.UserId = userID; note.NoteText = noteText; //Add the new note int rowsAffected = Adaptor.Update(note); //Return true if precisely one row was inserted, otherwise false return rowsAffected == 1; }
public void ShowNote() { NotesBLL notes = new NotesBLL(); TimeKeeper.NotesDataTable note = notes.GetNoteByUserID((int)Session["UserID"]); if (note.Count > 0) { TimeKeeper.NotesRow row = note[0]; Session["NoteID"] = row.NotesId; if (note.NoteTextColumn.ToString().Length > 0) { NotesTextBox.Text = row.NoteText.ToString(); } } else { NotesTextBox.Text = String.Empty; NoteLabel.Text = "Empty"; } }