public Model.StaffClass GetStaffAllClassesByStaffId(long staffInfoId)
{
try
{
Model.StaffClass staffClassModel = new Model.StaffClass();
staffClassModel.StaffInfoId = staffInfoId;
//var config = new MapperConfiguration(cfg => {
// cfg.CreateMap<Entity.StaffClasses, Model.StaffClasses>();
//});
//IMapper mapper = config.CreateMapper();
//return _schoolContext.StaffClasses.Where(s => s.StaffInfoId == staffInfoId)
//.AsEnumerable().Select(s => mapper.Map<Entity.StaffClasses, Model.StaffClasses>(s)).ToList();
staffClassModel.ClassIds = _schoolContext.StaffClasses.Where(s => s.StaffInfoId == staffInfoId).Select(c => c.ClassId).ToList();
return(staffClassModel);
}
catch (Exception ex)
{
throw;
}
}
public bool InsertUpdatedStaffClass(Model.StaffClass staffClass)
{
try
{
foreach (long classId in staffClass.ClassIds)
{
Entity.StaffClasses staffClassEntity = new Entity.StaffClasses
{
ClassId = classId,
StaffInfoId = staffClass.StaffInfoId,
UpdateDate = DateTime.Now,
UpdatedEmail = staffClass.UpdatedEmail
};
_schoolContext.StaffClasses.Add(staffClassEntity);
}
var staffExistClassList = _schoolContext.StaffClasses.Where(s => s.StaffInfoId == staffClass.StaffInfoId).ToList();
if (staffExistClassList.Count > 0)
{
_schoolContext.StaffClasses.RemoveRange(staffExistClassList);
}
var result = _schoolContext.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw;
}
}
