// Functionality private void B_Submit_Click(object sender, EventArgs e) { // Updates the lesson object _lesson.Comments = RTB_Today.Text; _lesson.Attended = CB_Attended.Checked; DBAccess.LessonAccessLayer LAL = new DBAccess.LessonAccessLayer(Core.Session.Database); LAL.TutorUpdateLesson(_lesson); // Updates lesson in DB }
public bool DeleteBlock(Block block) { LessonAccessLayer LAL = new LessonAccessLayer(_db); LAL.DeleteLessonsByBlock(block); _db.Cmd = _db.Conn.CreateCommand(); _db.Cmd.CommandText = "DELETE FROM Block WHERE Id = @Id"; _db.Cmd.Parameters.AddWithValue("@Id", block.Id); if (_db.Cmd.ExecuteNonQuery() > 0) { return(true); } else { return(false); } }
public void CreateBlock(int studentId, Instrument instrument, Term term, Room room, Period masterBlock, Tutor tutor, DayOfWeek day, DateTime customDate) { _db.Cmd = _db.Conn.CreateCommand(); _db.Cmd.CommandText = "INSERT INTO Block (Student, Instrument, Room, Tutor, MasterBlock, Term, Day) VALUES (@student, @instrument, @room, @tutor, @masterBlock, @term, @day); SELECT Scope_Identity()"; _db.Cmd.Parameters.AddWithValue("@student", studentId); _db.Cmd.Parameters.AddWithValue("@instrument", instrument.Id); _db.Cmd.Parameters.AddWithValue("@room", room.Id); _db.Cmd.Parameters.AddWithValue("@tutor", tutor.Id); _db.Cmd.Parameters.AddWithValue("@masterBlock", masterBlock.Id); _db.Cmd.Parameters.AddWithValue("@term", term.Id); _db.Cmd.Parameters.AddWithValue("@day", (int)day); // Scope_Idenity in SQL cmd allows retrieval of the block ID int blockId = Convert.ToInt32(_db.Cmd.ExecuteScalar().ToString()); LessonAccessLayer LAL = new LessonAccessLayer(_db); // Creates lessons until the term is finished while (customDate.CompareTo(term.EndDate) < 0) { LAL.CreateLesson(blockId, customDate); customDate = customDate.AddDays(7); } }