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