public int Update(GroupSyncModel ge)
{
var profRepo = new ProfessorRepository(DatabaseFactory);
var collegeRepo = new CollegeRepository(DatabaseFactory);
var g = DataContext.EducationalGroups
.FirstOrDefault(x => x.EducationalGroupCode == ge.EducationalGroupCode &&
x.Term.TermCode == ge.Term);
if (g != null)
{
g.Name = ge.Name;
g.IsActive = ge.IsActive;
g.GroupManger = profRepo.GetMany(x => x.ProfessorCode == ge.GroupMangerId && x.Term.TermCode == ge.Term).FirstOrDefault();
g.OnlinePresenceTime = ge.OnlinePresenceTime != 0 ? ge.OnlinePresenceTime : null;
// g.PhysicalPresenceTime = ge.PhysicalPresenceTime != 0 ? ge.PhysicalPresenceTime : null;
g.TotalStudentsCount = ge.TotalStudentsCount != 0 ? ge.TotalStudentsCount : null;
g.CancellationStudentsCount = ge.CancellationStudentsCount != 0 ? ge.CancellationStudentsCount : null;
g.DismissedstudentsCount = ge.DismissedstudentsCount != 0 ? ge.DismissedstudentsCount : null;
g.TotalStudentScoresAverage = ge.TotlalStudentAverageScores != 0 ? ge.TotlalStudentAverageScores : null;
g.TotalProfessorsCount = ge.TotalProfessorsCount != 0 ? ge.TotalProfessorsCount : null;
g.DoctoralProfessorsCount = ge.DoctoralProfessorsCount != 0 ? ge.DoctoralProfessorsCount : null;
g.MaProfessorsCount = ge.MaProfessorsCount != 0 ? ge.MaProfessorsCount : null;
g.BachelorProfessorsCount = ge.BachelorProfessorsCount != 0 ? ge.BachelorProfessorsCount : null;
g.TotalProposals = ge.TotalProposals != 0 ? ge.TotalProposals : null;
g.ApprovedProposals = ge.ApprovedProposals != 0 ? ge.ApprovedProposals : null;
g.College = collegeRepo.GetMany(x => x.CollegeCode == ge.CollegeId).FirstOrDefault();
g.AverageBachelorStudentGrades = ge.BachelorStudentAverageScores != 0 ? ge.BachelorStudentAverageScores : null;
g.AverageMaStudentGrades = ge.MaStudentAverageScores != 0 ? ge.MaStudentAverageScores : null;
g.AverageDoctoralStudentGrades = ge.DoctoralStudentAverageScores != 0 ? ge.DoctoralStudentAverageScores : null;
g.LastModifiedDate = DateTime.Now;
//Calculatepr
g.ExpelledStudentsPercentage = ge.TotalStudentsCount != 0
? (ge.DismissedstudentsCount * 100) / ge.TotalStudentsCount
: null;
g.StudentCancellationPercentage = ge.TotalStudentsCount != 0
? (ge.CancellationStudentsCount * 100) / ge.TotalStudentsCount
: null;
g.TeacherToBachelorStudentRatio = ge.BachelorProfessorsCount != 0
? (ge.BachelorStudentCount / ge.BachelorProfessorsCount)
: null;
g.TeacherToMaStudentRatio = ge.MaProfessorsCount != 0
? (ge.MaStudentCount / ge.MaProfessorsCount)
: null;
g.TeacherToDoctoralStudentRatio = ge.DoctoralProfessorsCount != 0
? (ge.DoctoralStudentCount / ge.DoctoralProfessorsCount)
: null;
g.ApproveProposalsPercentage = ge.TotalProposals != 0
? (ge.ApprovedProposals * 100) / ge.TotalProposals
: null;
}
return(DataContext.SaveChanges());
}
public int Add(GroupSyncModel ge)
{
var profRepo = new ProfessorRepository(DatabaseFactory);
var termRepo = new TermRepository(DatabaseFactory);
var collegeRepo = new CollegeRepository(DatabaseFactory);
var c = new EducationalGroup
{
Name = ge.Name,
IsActive = ge.IsActive,
GroupManger = profRepo
.GetMany(x => x.ProfessorCode == ge.GroupMangerId && x.Term.TermCode == ge.Term).FirstOrDefault(),
OnlinePresenceTime = ge.OnlinePresenceTime != 0 ? ge.OnlinePresenceTime : null,
PhysicalPresenceTime = ge.PhysicalPresenceTime != 0 ? ge.PhysicalPresenceTime : null,
TotalStudentsCount = ge.TotalStudentsCount != 0 ? ge.TotalStudentsCount : null,
CancellationStudentsCount = ge.CancellationStudentsCount != 0 ? ge.CancellationStudentsCount : null,
DismissedstudentsCount = ge.DismissedstudentsCount != 0 ? ge.DismissedstudentsCount : null,
TotalStudentScoresAverage = ge.TotlalStudentAverageScores != 0 ? ge.TotlalStudentAverageScores : null,
TotalProfessorsCount = ge.TotalProfessorsCount != 0 ? ge.TotalProfessorsCount : null,
DoctoralProfessorsCount = ge.DoctoralProfessorsCount != 0 ? ge.DoctoralProfessorsCount : null,
MaProfessorsCount = ge.MaProfessorsCount != 0 ? ge.MaProfessorsCount : null,
BachelorProfessorsCount = ge.BachelorProfessorsCount != 0 ? ge.BachelorProfessorsCount : null,
TotalProposals = ge.TotalProposals != 0 ? ge.TotalProposals : null,
ApprovedProposals = ge.ApprovedProposals != 0 ? ge.ApprovedProposals : null,
College = collegeRepo.GetMany(x => x.CollegeCode == ge.CollegeId).FirstOrDefault(),
AverageBachelorStudentGrades = ge.BachelorStudentAverageScores != 0 ? ge.BachelorStudentAverageScores : null,
AverageMaStudentGrades = ge.MaStudentAverageScores != 0 ? ge.MaStudentAverageScores : null,
AverageDoctoralStudentGrades = ge.DoctoralStudentAverageScores != 0 ? ge.DoctoralStudentAverageScores : null,
Term = termRepo.GetMany(x => x.TermCode == ge.Term).FirstOrDefault(),
EducationalGroupCode = ge.EducationalGroupCode != 0 ? ge.EducationalGroupCode : null,
CreationDate = DateTime.Now,
//Calculatepr
ExpelledStudentsPercentage = ge.TotalStudentsCount != 0
? (ge.DismissedstudentsCount * 100) / ge.TotalStudentsCount : null,
StudentCancellationPercentage = ge.TotalStudentsCount != 0
? (ge.CancellationStudentsCount * 100) / ge.TotalStudentsCount : null,
TeacherToBachelorStudentRatio = ge.BachelorProfessorsCount != 0
? (ge.BachelorStudentCount / ge.BachelorProfessorsCount) : null,
TeacherToMaStudentRatio = ge.MaProfessorsCount != 0
? (ge.MaStudentCount / ge.MaProfessorsCount) : null,
TeacherToDoctoralStudentRatio = ge.DoctoralProfessorsCount != 0
? (ge.DoctoralStudentCount / ge.DoctoralProfessorsCount) : null,
ApproveProposalsPercentage = ge.TotalProposals != 0
? (ge.ApprovedProposals * 100) / ge.TotalProposals : null,
};
DataContext.EducationalGroups.Add(c);
return(DataContext.SaveChanges());
}
public int AddOrUpdate(GroupSyncModel educationalGroup)
{
var termRepo = new TermRepository(DatabaseFactory);
if (!termRepo.IsExist(y => y.TermCode == educationalGroup.Term))
{
return((int)Enums.AddOrUpdateRenurnValue.ترم_موجود_نمی_باشد);
}
var collegeRepo = new CollegeRepository(DatabaseFactory);
if (!collegeRepo.IsExist(y => y.CollegeCode == educationalGroup.CollegeId))
{
return((int)Enums.AddOrUpdateRenurnValue.دانشکده_موجود_نمی_باشد);
}
if (IsExist(x => x.EducationalGroupCode == educationalGroup.EducationalGroupCode && x.Term.TermCode == educationalGroup.Term))
{
//ToDO Update
var r = Update(educationalGroup);
if (r != 0)
{
return((int)Enums.AddOrUpdateRenurnValue.آپدیت_گردید);
}
return((int)Enums.AddOrUpdateRenurnValue.عملیات_ناموفق);
}
else
{
//ToDo Add
var r = Add(educationalGroup);
if (r != 0)
{
return((int)Enums.AddOrUpdateRenurnValue.اضافه_گردید);
}
;
return((int)Enums.AddOrUpdateRenurnValue.عملیات_ناموفق);
}
}
public int AddOrUpdate(GroupSyncModel educationalGroup)
{
var rep = new EducationalGroupRepository(new DatabaseFactory());
return(rep.AddOrUpdate(educationalGroup));
}