public Response<GetSettingsModel> GetEligibleCourses(UserIdModel objReq)
{
Response<GetSettingsModel> response = new Response<GetSettingsModel>();
List<GetSettingsModel> objResp = new List<GetSettingsModel>();
try
{
if (ModelState.IsValid)
{
objDbMethodV2 = new wizz.Dal.DbMethodsV2();
if (CheckRequestIsvalidornot(this.Request))
{
objResp.Add(objDbMethodV2.GetEligibleCourses(objReq));
response.Create(true, " Eligiblie courses", Messages.AppVersion, objResp);
}
else
{
response.Create(false, Messages.FormatMessage(Messages.InvalidReq), Messages.AppVersion, objResp);
}
}
else
response.Create(false, ModelState.Values.FirstOrDefault().Errors.FirstOrDefault().ErrorMessage, Messages.AppVersion, objResp);
}
catch (Exception ex)
{
object session = new JavaScriptSerializer().Serialize(objReq);
LogManager.Error("Error occured while Processing Webservice request :{0}", ex, session, ex.Message);
response.Create(false, Messages.FormatMessage(Messages.ErrorOccure), Messages.AppVersion, objResp);
}
return response;
}
internal GetSettingsModel GetEligibleCourses(UserIdModel objReq)
{
using (var db = new WizzDataContext())
{
GetSettingsModel objResponse = new GetSettingsModel();
//List<AcademicCoursesModel academic = new AcademicCoursesModel();
// List<tblTutorSubject> tutorSubList = new List<tblTutorSubject>();
// var userInfo = db.tblStudentRequests.Where(x => x.uniqueStudentRequestId == objReq.uniqueRequestId).FirstOrDefault();
var tutorSubList = db.usp_GetEligibleSubjects(Convert.ToInt32(objReq.userId)).ToList();
//foreach (var n in tutorSubList)
//{
// switch (n.subjectType)
// {
// case 1:
// // objResponse.listAcademicCourse.Add(n.fkSubjectId)
// break;
// case 2:
// break;
// case 3:
// break;
// default:
// break;
// }
//}
var courseData = db.tblCourses.Where(a => a.isDelete == false && a.isActive == true).ToList();
var classes = db.tblClasses.Where(a => a.isActive == true && a.isDelete != true).ToList();
var subjects = db.tblSubjects.Where(a => a.isActive == true && a.isDelete != true).ToList();
//foreach (var n in courseData) {
// AcademicCoursesModel acModel = new AcademicCoursesModel();
// foreach (var c in classes)
// {
// ClassesModel clasModel = new ClassesModel();
// acModel.listClasses.Add(clasModel);
// foreach (var s in subjects)
// {
// SubjectsNewModel subModel = new SubjectsNewModel();
// var temp = tutorSubList.Where(z => z.fkSubjectId == s.fkClassId).FirstOrDefault();
// if (temp != null)
// {
// clasModel.listSubejcts.Add(subModel);
// objResponse.listAcademicCourse.Add(acModel);
// }
// }
// }
//}
objResponse.listAcademicCourse = (from c in courseData.Where(a => a.isExtraCurricular == false)
select new AcademicCoursesModel
{
courseId = Convert.ToString(c.pkId),
courseName = c.courseName,
isApproved = tutorSubList.Any(x => x.fkSubjectId == c.pkId && x.subjectType == 1).ToString(),
listClasses = (from cl in classes.Where(a => a.fkCourseId == c.pkId)
select new ClassesModel
{
classId = Convert.ToString(cl.pkId),
className = cl.className,
isApproved = tutorSubList.Any(x => x.fkSubjectId == cl.pkId && x.subjectType == 2).ToString(),
listSubejcts = (from sub in subjects.Where(a => a.fkClassId == cl.pkId)
select new SubjectsNewModel
{
subjectId = Convert.ToString(sub.pkId),
isApproved = tutorSubList.Any(x => x.fkSubjectId == sub.pkId && x.subjectType == 3).ToString(),
subjectName = sub.subjectName,
}).ToList()
}).ToList()
}).ToList();
objResponse.listCurricularCourses = (from c in courseData.Where(a => a.isExtraCurricular == true)
select new CurricularCoursesModel
{
courseId = Convert.ToString(c.pkId),
courseName = c.courseName,
isApproved = tutorSubList.Any(x => x.fkSubjectId == c.pkId && x.subjectType == 1).ToString(),
listClasses = (from cl in classes.Where(a => a.fkCourseId == c.pkId)
select new ClassesModel
{
classId = Convert.ToString(cl.pkId),
className = cl.className,
isApproved = tutorSubList.Any(x => x.fkSubjectId == cl.pkId && x.subjectType == 2).ToString(),
listSubejcts = (from sub in subjects.Where(a => a.fkClassId == cl.pkId)
select new SubjectsNewModel
{
subjectId = Convert.ToString(sub.pkId),
isApproved = tutorSubList.Any(x => x.fkSubjectId == sub.pkId && x.subjectType == 3).ToString(),
subjectName = sub.subjectName,
}).ToList()
}).ToList()
}).ToList();
//objResponse.tutorList = tutorSubList;
return objResponse;
}
// throw new NotImplementedException();
}