public static bool UpdateLesson(Model.Lesson lesson, string courseId)
{
try
{
ObjectId id = new ObjectId(courseId);
var dataProvider = new MongoDataProvider();
var db = dataProvider.GetDatabase();
var collection = db.GetCollection <Course>("Course");
var filter = Builders <Course> .Filter.And(
Builders <Course> .Filter.Where(c => c._id == id),
Builders <Course> .Filter.ElemMatch(c => c.Lessons, l => l.Name == lesson.Name));
var update = Builders <Course> .Update.Set(c => c.Lessons[-1], lesson);
var result = collection.UpdateOne(filter, update);
if (result.ModifiedCount == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool insertIntoTableLesson(Model.Lesson lesson)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, DbName)))
{
connection.Insert(lesson);
return(true);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return(false);
}
}
public bool insertIntoTableStudent_lesson(Model.Lesson lesson, Model.Student student)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, DbName)))
{
Model.StudentLesson Student_Lesson = new Model.StudentLesson();
Student_Lesson.LessonId = lesson.id_lesson;
Student_Lesson.StudentCIN = student.CIN;
connection.Insert(Student_Lesson);
return(true);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return(false);
}
}
public static bool AddLessonToCourse(string courseId, Model.Lesson lesson)
{
try
{
var course = new Course();
IDataProvider data = new MongoDataProvider();
course.ModelCourse = data.Get <DAL.Course>("_id", courseId);
// ne smiju biti 2 lekcije istog imena
foreach (var courseLesson in course.ModelCourse.Lessons)
{
if (courseLesson.Name == lesson.Name)
{
throw new Exception("AlreadyExists");
}
}
return(DAL.Course.AddLesson(lesson, courseId));
}
catch (Exception)
{
return(false);
}
}
public void Delete(Model.Lesson entity)
{
entity.IsActive = false;
_lessonDAL.Update(entity);
}
public void Update(Model.Lesson entity)
{
_lessonDAL.Update(entity);
}
public void Add(Model.Lesson entity)
{
_lessonDAL.Add(entity);
}
