/// <summary>
/// Gets the learned lessons in course by customer identifier.
/// </summary>
/// <param name="customer_id">The customer_id.</param>
/// <param name="course_id">The course_id.</param>
/// <param name="onComplete">The on complete.</param>
public void GetLearnedLessonsInCourseByCustomerId(int customer_id, int course_id, OnQueryComplete onComplete)
{
//lessonDsq = (DataServiceQuery<LESSON>(from les in ctx.LESSON where les.COURSE_ID == customer_id and les))
}
/// <summary>
/// Gets the lessons by course identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetLessonsByCourseId(int id, OnQueryComplete onComplete)
{
lessonDsq = (DataServiceQuery <LESSON>)(from les in ctx.LESSON where les.COURSE_ID == id select les);
this.onUQC = onComplete;
lessonDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the note by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetNoteByID(int id, OnQueryComplete onComplete)
{
noteDsq = (DataServiceQuery <NOTE>)(ctx.NOTE.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onResComplete, null);
}
/// <summary>
/// Gets the course by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetCourseByID(int id, OnQueryComplete onComplete)
{
courseDsq = (DataServiceQuery <COURSE>)(ctx.COURSE.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onResComplete, null);
}
/// <summary>
/// Inserts the note.
/// </summary>
/// <param name="note">The note.</param>
/// <param name="onComplete">The on complete.</param>
public void InsertNote(NOTE note, OnQueryComplete onComplete)
{
ctx.AddToNOTE(note);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Edits the course.
/// </summary>
/// <param name="course">The course.</param>
/// <param name="onComplete">The on complete.</param>
public void EditCourse(COURSE course, OnQueryComplete onComplete)
{
ctx.UpdateObject(course);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Edits the course.
/// </summary>
/// <param name="course">The course.</param>
/// <param name="onComplete">The on complete.</param>
public void EditCourse(COURSE course, OnQueryComplete onComplete)
{
ctx.UpdateObject(course);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Gets the note by lesson identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetNoteByLessonId(int id, OnQueryComplete onComplete)
{
noteDsq = (DataServiceQuery <NOTE>)(from note in ctx.NOTE where note.LESSON_ID == id select note);
this.onUQC = onComplete;
noteDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Inserts the note.
/// </summary>
/// <param name="note">The note.</param>
/// <param name="onComplete">The on complete.</param>
public void InsertNote(NOTE note, OnQueryComplete onComplete)
{
ctx.AddToNOTE(note);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Edits the lesson.
/// </summary>
/// <param name="lesson">The lesson.</param>
/// <param name="onComplete">The on complete.</param>
public void EditLesson(LESSON lesson, OnQueryComplete onComplete)
{
ctx.UpdateObject(lesson);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Gets the resource by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetResourceByID(int id, OnQueryComplete onComplete)
{
resourceDsq = (DataServiceQuery<RESOURCE>)(ctx.RESOURCE.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the note by lesson identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetNoteByLessonId(int id, OnQueryComplete onComplete)
{
noteDsq = (DataServiceQuery<NOTE>)(from note in ctx.NOTE where note.LESSON_ID == id select note);
this.onUQC = onComplete;
noteDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the note by customer identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetNoteByCustomerID(int id, OnQueryComplete onComplete)
{
noteDsq = (DataServiceQuery<NOTE>)(ctx.NOTE.Where(n => n.CUSTOMER_ID == id));
this.onUQC = onComplete;
noteDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the learned lessons in course by customer identifier.
/// </summary>
/// <param name="customer_id">The customer_id.</param>
/// <param name="course_id">The course_id.</param>
/// <param name="onComplete">The on complete.</param>
public void GetLearnedLessonsInCourseByCustomerId(int customer_id, int course_id, OnQueryComplete onComplete)
{
//lessonDsq = (DataServiceQuery<LESSON>(from les in ctx.LESSON where les.COURSE_ID == customer_id and les))
}
/// <summary>
/// Deletes the note.
/// </summary>
/// <param name="note">The note.</param>
/// <param name="onComplete">The on complete.</param>
public void DeleteNote(NOTE note, OnQueryComplete onComplete)
{
ctx.DeleteObject(note);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Gets the note by customer identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetNoteByCustomerID(int id, OnQueryComplete onComplete)
{
noteDsq = (DataServiceQuery <NOTE>)(ctx.NOTE.Where(n => n.CUSTOMER_ID == id));
this.onUQC = onComplete;
noteDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the note by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetNoteByID(int id, OnQueryComplete onComplete)
{
noteDsq = (DataServiceQuery<NOTE>)(ctx.NOTE.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onResComplete, null);
}
/// <summary>
/// Gets the resource by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetResourceByID(int id, OnQueryComplete onComplete)
{
resourceDsq = (DataServiceQuery <RESOURCE>)(ctx.RESOURCE.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the lesson by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetLessonByID(int id, OnQueryComplete onComplete)
{
lessonDsq = (DataServiceQuery<LESSON>)(ctx.LESSON.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onResComplete, null);
}
/// <summary>
/// Edits the lesson.
/// </summary>
/// <param name="lesson">The lesson.</param>
/// <param name="onComplete">The on complete.</param>
public void EditLesson(LESSON lesson, OnQueryComplete onComplete)
{
ctx.UpdateObject(lesson);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Gets the course by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetCourseByID(int id, OnQueryComplete onComplete)
{
courseDsq = (DataServiceQuery<COURSE>)(ctx.COURSE.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onResComplete, null);
}
/// <summary>
/// Deletes the note.
/// </summary>
/// <param name="note">The note.</param>
/// <param name="onComplete">The on complete.</param>
public void DeleteNote(NOTE note, OnQueryComplete onComplete)
{
ctx.DeleteObject(note);
this.onUQC = onComplete;
ctx.BeginSaveChanges(onQueryComplete2, null);
}
/// <summary>
/// Gets the user by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void getUserById(int id, OnQueryComplete onComplete)
{
customerDsq = (DataServiceQuery<CUSTOMER>)(from cus in ctx.CUSTOMER where cus.ID == Constants.User.ID select cus);
this.onUQC = onComplete;
customerDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the lesson by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetLessonByID(int id, OnQueryComplete onComplete)
{
lessonDsq = (DataServiceQuery <LESSON>)(ctx.LESSON.Where(r => r.ID == id));
this.onUQC = onComplete;
resourceDsq.BeginExecute(onResComplete, null);
}
protected virtual void RaiseOnQueryComplete(IStoredProc sp, long time, Exception error) => OnQueryComplete?.Invoke(this, new QueryCompleteEventArgs(sp, time, error));
/// <summary>
/// Gets the user by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void getUserById(int id, OnQueryComplete onComplete)
{
customerDsq = (DataServiceQuery <CUSTOMER>)(from cus in ctx.CUSTOMER where cus.ID == Constants.User.ID select cus);
this.onUQC = onComplete;
customerDsq.BeginExecute(onQueryComplete2, null);
}
/// <summary>
/// Gets the lessons by course identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="onComplete">The on complete.</param>
public void GetLessonsByCourseId(int id, OnQueryComplete onComplete)
{
lessonDsq = (DataServiceQuery<LESSON>)(from les in ctx.LESSON where les.COURSE_ID == id select les);
this.onUQC = onComplete;
lessonDsq.BeginExecute(onQueryComplete2, null);
}