public async Task <ActionResult <BaseRespone> > GetAllCourses()
{
List <Course> list = await _context.Courses
.AsNoTracking()
.Select(x => new Course
{
CourseId = x.CourseId,
Name = x.Name,
STARTDATE = x.STARTDATE,
ENDDATE = x.ENDDATE,
NOTE = x.NOTE
})
.ToListAsync();
BaseRespone result = new BaseRespone();
if (list != null)
{
result.ErrorCode = 0;
result.Data = list;
}
else
{
result.ErrorCode = 1;
result.Message = "Data is not available!";
}
return(result);
}
public async Task <ActionResult <BaseRespone> > GetTrainingSubjects()
{
List <TrainingSubject> list = await _context.TrainingSubject
.AsNoTracking()
.Select(x => new TrainingSubject
{
TrainingSubjectId = x.TrainingSubjectId,
TrainingId = x.TrainingId,
SubjectId = x.SubjectId
})
.ToListAsync();
BaseRespone result = new BaseRespone();
if (list != null)
{
result.ErrorCode = 0;
result.Data = list;
}
else
{
result.ErrorCode = 1;
result.Message = "Data is not available!";
}
return(result);
}
public void Handle(T Data, BaseRespone respone)
{
ContentType = "application/json";
StatusCode = respone.Success ? StatusCodes.Status200OK : StatusCodes.Status400BadRequest;
var baseContent = new BaseContentRespone <T>
{
Data = Data,
Sucess = respone.Success,
Status = respone.Success ? StatusCodes.Status200OK : StatusCodes.Status400BadRequest,
Errors = respone.Errors,
Message = HandleMessage(respone.Errors)
};
Content = JsonConvert.SerializeObject(baseContent);
}
public async Task <ActionResult <BaseRespone> > GetWithSubject()
{
List <SpecTrainingInfo> list = await _context.SpecializedTrainings
.AsNoTracking()
.Select(x => new SpecTrainingInfo
{
TrainingId = x.TrainingId,
Name = x.Name,
NumberofWeeks = x.NumberofWeeks
})
.ToListAsync();
foreach (SpecTrainingInfo item in list)
{
item.listSubjects = await _context.TrainingSubject
.AsNoTracking()
.Where(x => x.TrainingId == item.TrainingId)
.Select(x => new Subject
{
SubjectId = x.SubjectId,
Subjectname = x.SUBJECTS.Subjectname,
NUMBERLESSON = x.SUBJECTS.NUMBERLESSON
})
.ToListAsync();
}
BaseRespone result = new BaseRespone();
if (list != null)
{
result.ErrorCode = 0;
result.Data = list;
}
else
{
result.ErrorCode = 1;
result.Message = "Data is not available!";
}
return(result);
}
public async Task <ActionResult <BaseRespone> > GetSpecializedTraining(int id)
{
BaseRespone result = new BaseRespone();
var item = await _context.SpecializedTrainings
.AsNoTracking()
.Select(x => new SpecTrainingInfo
{
TrainingId = x.TrainingId,
Name = x.Name,
NumberofWeeks = x.NumberofWeeks
})
.FirstOrDefaultAsync(x => x.TrainingId == id);
item.listSubjects = await _context.TrainingSubject
.AsNoTracking()
.Where(x => x.TrainingId == item.TrainingId)
.Select(x => new Subject
{
SubjectId = x.SubjectId,
Subjectname = x.SUBJECTS.Subjectname,
NUMBERLESSON = x.SUBJECTS.NUMBERLESSON
})
.ToListAsync();
if (item == null)
{
result.ErrorCode = 404;
result.Message = "Not found";
}
else
{
result.ErrorCode = 0;
result.Data = item;
}
return(result);
}
public JsonContentResult(T Data, BaseRespone respone)
{
Handle(Data, respone);
}
