static void Main(string[] args) { int studentId = 3; StudentDAL studentDAL = new StudentDAL(); DepartmentDAL departmentDAL = new DepartmentDAL(); CoueseTeacherDAL courseTeacherDAL = new CoueseTeacherDAL(); var StudentEnroll = from s in studentDAL.StudentEnrollListGetAll() join c in courseTeacherDAL.CourseGetAll() on s.CourseId equals c.CourseId select new { StudentId = s.StudentId, StudentName = s.StudentName, StudentEmail = s.StudentEmail, DepartmentName = s.DepartmentName, CourseCode = c.CourseCode, CourseName = c.CourseName, CourseId = c.CourseId, }; var StudentEnrollByStudentId = StudentEnroll.Where(c => c.StudentId == studentId).ToList(); var StudentResulByStudentId = studentDAL.SaveStudentResultGetAll().Where(c => c.StudentId == studentId).ToList(); var result = from e in StudentEnrollByStudentId join d in StudentResulByStudentId on e.CourseId equals d.CourseId into eGroup from d in eGroup.DefaultIfEmpty() select new { StudentId = e.StudentId, StudentName = e.StudentName, StudentEmail = e.StudentEmail, DepartmentName = e.DepartmentName, CourseId = e.CourseId, CourseCode = e.CourseCode, CourseName = e.CourseName, GradeLatter = d == null ? "Not Graded Yet" : d.GradeLetter }; foreach (var c in result) { Console.WriteLine(c.StudentId + "\t" + c.StudentName + "\t" + c.StudentEmail + "\t" + c.DepartmentName + "\t" + c.CourseId + "\t" + c.CourseCode + "\t" + c.CourseName + "\t" + c.GradeLatter ); } Console.ReadKey(); //foreach (var c in result) //{ // Console.WriteLine(c.StudentId + "\t" + c.StudentName + "\t" // + c.StudentEmail + "\t" + c.DepartmentName + "\t" // + c.CourseCode + "\t" + c.CourseName + "\t" + c.GradeLatter // ); //} //Console.ReadKey(); }
public JsonResult GetTeacherInfoByTeacherId(int teacherTd) { //var dataList = courseTeacherDAL.TeacherGetAll().Where(c => c.TeacherId == teacherTd).ToList(); CoueseTeacherDAL courseTeacherDAL = new CoueseTeacherDAL(); var teacherGetAll = courseTeacherDAL.TeacherGetAll(); var AssignCourseCreditresult = courseTeacherDAL.AssingTeacherGetAll(); var gropbySum = AssignCourseCreditresult .GroupBy(s => new { s.TeacherId }) .Select(g => new { TeacherId = g.Key.TeacherId, AssignCourseCredit = g.Sum(x => x.AssignCourseCredit) }); var result = from e in teacherGetAll join d in gropbySum on e.TeacherId equals d.TeacherId into eGroup from d in eGroup.DefaultIfEmpty() select new { TeacherId = e.TeacherId, TeacherName = e.TeacherName, CreditTeken = e.CreditTaken, AssignCreditTeken = d == null ? 0 : d.AssignCourseCredit, }; var newResult = result.Select(n => new { TeacherId = n.TeacherId, TeacherName = n.TeacherName, CreditTeken = n.CreditTeken, AssignCredit = n.AssignCreditTeken, RemainingCredit = n.CreditTeken - n.AssignCreditTeken, }); var finalResult = newResult.Where(c => c.TeacherId == teacherTd).ToList(); var jsonData = finalResult.Select(c => new { c.CreditTeken, c.RemainingCredit }); return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public UnassignUnallocateController() { classRoomSechudelDAL = new ClassRoomScheduleDAL(); coueseTeacherDAL = new CoueseTeacherDAL(); }
static void Main(string[] args) { int id = 4; //var today = DateTime.Now; //var dd = today.Day; //var mm = today.Month; //var yyyy = today.Year; //Console.WriteLine(yyyy); //Console.ReadKey(); CoueseTeacherDAL courseTeacherDAL = new CoueseTeacherDAL(); ClassRoomScheduleDAL classRoomScheduleDAL = new ClassRoomScheduleDAL(); var Result = classRoomScheduleDAL.AllocateClassRoomGetAll().Select(n => new { CourseId = n.CourseId, //RomNo = n.RoomNo, //Day = n.Day, //ToTime = n.ToTime, //FromTime = n.FromTime, Schedule = n.RoomNo + ", - " + n.Day + ", - " + new DateTime(n.FromTime.Ticks).ToString("%h:mm tt") + " - " + new DateTime(n.ToTime.Ticks).ToString("%h:mm tt") + ";", }); var newResult = (from a in Result.ToList() group a by a.CourseId into CourseGroup select new { CourseId = CourseGroup.FirstOrDefault().CourseId, Schedule = String.Join("\n", (CourseGroup.Select(x => x.Schedule)).ToArray()) }); var ResultFinal = from s in courseTeacherDAL.CourseGetAll() join c in newResult on s.CourseId equals c.CourseId into sGroup from c in sGroup.DefaultIfEmpty() //where s.DepartmentId == departmentId select new { DepartmentId = s.DepartmentId, DepartmentName = s.Department.DepartmentName, CourseId = s.CourseId, CourseCode = s.CourseCode, CourseName = s.CourseName, CourseIDC = c == null ? 0 : c.CourseId, Schedule = c == null ? "Not Schedule Yet" : c.Schedule, }; foreach (var v in ResultFinal) { Console.WriteLine(v.DepartmentId + "\t" + v.DepartmentName + "\t" + v.CourseId + "\t" + v.CourseCode + "\t" + v.CourseName + "\t" + v.CourseIDC + "\t" + v.Schedule ); } Console.ReadKey(); //var Result = classRoomScheduleDAL.AllocateClassRoomGetAll().Select(n => new // { // CourseId = n.CourseId, // RomNo = n.RoomNo, // ToTime = n.ToTime, // FromTime = n.FromTime, // Schedule = n.RoomNo + "-" + new DateTime(n.FromTime.Ticks).ToString("%h:mm tt") + "-" + new DateTime(n.ToTime.Ticks).ToString("%h:mm tt"), // }); //var newResult = (from a in Result.ToList() // group a by a.CourseId into CourseGroup // select new // { // CourseId = CourseGroup.FirstOrDefault().CourseId, // Schedule = String.Join("\n", (CourseGroup.Select(x => x.Schedule)).ToArray()) // }); // foreach (var v in newResult) // { // Console.WriteLine(v.CourseId + "\t" + v.Schedule); // } // Console.ReadKey(); // var query = from s in courseTeacherDAL.CourseGetAll() // join c in newResult // on s.CourseId equals c.CourseId into sGroup // from c in sGroup.DefaultIfEmpty() // where s.CourseId == id // select new // { // DepartmentId = s.DepartmentId, // DepartmentName = s.Department.DepartmentName, // CourseId = s.CourseId, // CourseCode = s.CourseCode, // CourseName = s.CourseName, // CourseIDC = c == null ? 0 : c.CourseId, // Schedule = c == null ? "Not Schedule Yet" : c.Schedule, // }; // foreach (var v in query) // { // Console.WriteLine(v.DepartmentId + "\t" + v.DepartmentName + "\t" // + v.CourseId + "\t" + v.CourseCode + "\t" // + v.CourseName + "\t" + v.CourseIDC + "\t" // + v.Schedule // ); // } // Console.ReadKey(); //foreach (var v in newResult) //{ // Console.WriteLine(v.CourseId + "\t" + v.RomNo + "\t" // + v.ToTime + "\t" + v.FromTime // ); //} //Console.ReadKey(); //var result = from e in teacherGetAll // join d in gropbySum // on e.TeacherId equals d.TeacherId into eGroup // from d in eGroup.DefaultIfEmpty() // select new // { // TeacherId = e.TeacherId, // TeacherName = e.TeacherName, // CreditTeken = e.CreditTaken, // AssignCreditTeken = d == null ? 0 : d.AssignCourseCredit, // //AssignTo = d == null ? "Not Assigned Yet" : d.Teacher.TeacherName // }; //CoueseTeacherDAL courseTeacherDAL = new CoueseTeacherDAL(); //StudentDAL studentDAL = new StudentDAL(); //var query = from s in studentDAL.SaveStudentResultGetAll() // join c in courseTeacherDAL.CourseGetAll() on s.CourseId equals c.CourseId // //where s.StudentId == id // select new // { // StudentId = s.StudentId, // RegistrationNumber = s.Student.RegistrationNumber, // StudentName = s.StudentName, // StudentEmail = s.StudentEmail, // DepartmentName = s.DepartmentName, // CourseCode = c.CourseCode, // CourseName =c.CourseName, // GradeLatter = s.GradeLetter, // }; //foreach (var v in query) //{ // Console.WriteLine(v.StudentId + "\t" + v.RegistrationNumber + "\t" // + v.StudentName + "\t" + v.StudentEmail + "\t" // + v.DepartmentName + "\t" + v.CourseCode + "\t" // + v.CourseName + "\t" + v.GradeLatter + "\t" // ); //} //Console.ReadKey(); //var query = from s in studentDAL.StudentEnrollListGetAll() // join c in courseTeacherDAL.CourseGetAll() on s.CourseId equals c.CourseId // //where s.StudentId == id // select new // { // StudentId = s.StudentId, // StudentName = s.StudentName, // DepartmentName = s.DepartmentName, // CourseId = s.CourseId, // CourseIdC = c.CourseId, // CourseNameC = c.CourseName, // DepartmentNameC = c.Department.DepartmentName, // }; //foreach (var v in query) //{ // Console.WriteLine(v.StudentId + "\t" + v.StudentName + "\t" + v.DepartmentName + "\t" + v.CourseId + "\t" + v.CourseIdC + "\t" + v.CourseNameC + "\t" + v.DepartmentNameC); //} //Console.ReadKey(); //var result = studentDAL.StudentEnrollListGetAll() // .Select(n => new // { // studentId= n.StudentId, // studentName = n.Student.StudentName, // registretionNo = n.Student.RegistrationNumber // }); //foreach (var v in result) //{ // Console.WriteLine(v.studentId + "\t" + v.studentName +"\t"+ v.registretionNo); //} //Console.ReadKey(); //var query = from s in studentDAL.StudentGetAll() // join c in courseTeacherDAL.CourseGetAll() on s.DepartmentId equals c.DepartmentId // where s.StudentId == id // select new { StudentId = s.StudentId, StudentName = s.StudentName, // DepartmentName= s.Department.DepartmentName, // DepartmentNameC = c.Department.DepartmentName, // CourseNameC= c.CourseName}; //foreach (var v in query) //{ // Console.WriteLine(v.StudentId + "\t" + v.StudentName + "\t" + v.DepartmentName + "\t" + v.DepartmentNameC + "\t" + v.CourseNameC); //} //Console.ReadKey(); //CoueseTeacherDAL courseTeacherDAL = new CoueseTeacherDAL(); //var teacherGetAll = courseTeacherDAL.TeacherGetAll(); //foreach (var v in teacherGetAll) //{ // Console.WriteLine(v.TeacherId + "\t" + v.TeacherName +"\t"+ v.CreditTaken); //} //Console.ReadKey(); //var AssignCourseCreditresult = courseTeacherDAL.AssingTeacherGetAll(); //var gropbySum = AssignCourseCreditresult // .GroupBy(s => new { s.TeacherId}) // .Select(g => new // { // TeacherId = g.Key.TeacherId, // AssignCourseCredit = g.Sum(x=> x.AssignCourseCredit) // }); //foreach (var v in gropbySum) //{ // Console.WriteLine(v.TeacherId + "\t" + v.AssignCourseCredit ); //} //Console.ReadKey(); //var result = from e in teacherGetAll // join d in gropbySum // on e.TeacherId equals d.TeacherId into eGroup // from d in eGroup.DefaultIfEmpty() // select new // { // TeacherId = e.TeacherId, // TeacherName = e.TeacherName, // CreditTeken = e.CreditTaken, // AssignCreditTeken = d == null ? 0 : d.AssignCourseCredit, // //AssignTo = d == null ? "Not Assigned Yet" : d.Teacher.TeacherName // }; //foreach (var v in result) //{ // Console.WriteLine(v.TeacherId + "\t" + v.TeacherName + "\t" + v.CreditTeken + "\t" + v.AssignCreditTeken); //} //Console.ReadKey(); //var newResult = result.Select(n => new // { // TeacherId = n.TeacherId, // TeacherName = n.TeacherName, // CreditTeken = n.CreditTeken, // AssignCredit = n.AssignCreditTeken, // RemainingCredit = n.CreditTeken - n.AssignCreditTeken, // }); //var finalresult = newResult.Where(c => c.TeacherId == teacherTd).ToList(); //foreach (var v in finalresult) //{ // Console.WriteLine(v.TeacherId + "\t" + v.TeacherName + "\t" + v.CreditTeken + "\t" + v.AssignCredit + "\t" + v.RemainingCredit); //} //Console.ReadKey(); // var result = from e in courseTeacherDAL.CourseGetAll() // join d in courseTeacherDAL.AssingTeacherGetAll() // on e.CourseId equals d.CourseId into eGroup // from d in eGroup.DefaultIfEmpty() // select new // { // DepartmentId = e.DepartmentId, // DepartmentName = e.Department.DepartmentName, // CourseCode = e.CourseCode, // CourseName = e.CourseName, // Semester = e.Semester, // AssignTo = d == null ? "Not Assigned Yet" : d.Teacher.TeacherName // }; //var dataList = result.Where(c => c.DepartmentId == departmentId).ToList(); //var jsonData = dataList.Select(c => new { c.CourseCode, c.CourseName, c.Semester, c.AssignTo }); //var result = courseTeacherDAL.CourseGetAll() // .GroupJoin(courseTeacherDAL.AssingTeacherGetAll(), // e => e.CourseId, // d => d.CourseId, // (emp, dept) => new // { // emp, // dept // }) // .Select(z => z.dept.DefaultIfEmpty(), // (a, b) => new // { // CourseCode = a.emp.CourseName, // }); }