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,
// });
}
