public void Remove(Object anObject)
{
Subject toDelete = anObject as Subject;
SubjectAccess context = new SubjectAccess();
context.Remove(toDelete);
}
public void Modify(Object oldObject, Object newObject)
{
if (CanIModify(oldObject, newObject))
{
SubjectAccess context = new SubjectAccess();
Subject newSubject = newObject as Subject;
context.Modify(newSubject);
}
}
// Special constructor for tests
public Admin(string FirstName, string LastName, string ID, TeacherAccess TeacherAccess, GroupAccess GroupAccess, SubjectAccess SubjectAccess) : base(FirstName, LastName)
{
adminID = ID;
IoC.RegisterObject <ISubject, Subject>();
IoC.RegisterObject <IGroup, Group>();
teacherAccess = TeacherAccess;
groupAccess = GroupAccess;
subjectAccess = SubjectAccess;
}
private void AddPermission(Role role, SubjectAccess subject, PartAccess part, AccessRight right)
{
var permission = new Permission(Guid.NewGuid());
permission.Role.Value = role;
permission.Subject.Value = subject;
permission.Part.Value = part;
permission.Right.Value = right;
_db.Save(permission);
}
/// <summary>
/// 添加科目
/// </summary>
/// <param name="diary"></param>
/// <returns></returns>
public Boolean AddSubject(Subject subject)
{
try
{
return(SubjectAccess.Insert(subject));
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
///删除科目
/// </summary>
/// <param name="diaryID"></param>
/// <returns></returns>
public Boolean DeleteSubject(int subjectID)
{
try
{
return(SubjectAccess.Delete(subjectID));
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 显示科目的名称
/// </summary>
/// <returns></returns>
public string ShowSubjectName()
{
try
{
return(SubjectAccess.SelectSubjectName());
}
catch (Exception ex)
{
return(null);
}
}
public StudentController(Student Student)
{
IoC.RegisterObject <IGroup, Group>();
IoC.RegisterObject <IExam, Exam>();
IoC.RegisterObject <IDBAccess, DBAccess>();
dbAccess = new DBAccess();
resultAccess = new ResultAccess(dbAccess);
examAccess = new ExamAccess(dbAccess);
subjectAccess = new SubjectAccess(dbAccess);
student = Student;
}
/// <summary>
/// 查看过时科目
/// </summary>
/// <returns></returns>
public List <Subject> FindOldSubject()
{
try
{
List <Subject> list = SubjectAccess.SelectAdminSubjectName();
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 查看单个科目报名结束时间（根据ID）
/// </summary>
/// <returns></returns>
public string ShowSignEndTime(int subjectID)
{
try
{
string sqlWhere = string.Format(" and subjectID= {0}", subjectID);
string time = SubjectAccess.SelectSignEndTime(sqlWhere);
return(time);
}
catch (Exception ex)
{
return(null);
}
}
public Admin(string FirstName, string LastName, string ID) : base(FirstName, LastName)
{
adminID = ID;
IoC.RegisterObject <IDBAccess, DBAccess>();
IoC.RegisterObject <ISubject, Subject>();
IoC.RegisterObject <IGroup, Group>();
dbAccess = new DBAccess();
teacherAccess = new TeacherAccess(dbAccess);
groupAccess = new GroupAccess(dbAccess);
subjectAccess = new SubjectAccess(dbAccess);
accountAccess = new AccountAccess(dbAccess);
studentAccess = new StudentAccess(dbAccess);
}
public TeacherController(Teacher Teacher)
{
IoC.RegisterObject <IGroup, Group>();
IoC.RegisterObject <IExam, Exam>();
IoC.RegisterObject <IResult, Result>();
IoC.RegisterObject <IDBAccess, DBAccess>();
dbAccess = new DBAccess();
examAccess = new ExamAccess(dbAccess);
resultAccess = new ResultAccess(dbAccess);
studentAccess = new StudentAccess(dbAccess);
groupAccess = new GroupAccess(dbAccess);
subjectAccess = new SubjectAccess(dbAccess);
teacher = Teacher;
}
/// <summary>
/// 查看单个科目（根据ID）
/// </summary>
/// <returns></returns>
public Subject ShowSingleSubject(int subjectID)
{
try
{
string sqlWhere = string.Format(" and subjectID= {0}", subjectID);
List <Subject> list = SubjectAccess.SelectSingleSubject(sqlWhere);
if (list != null && list.Count > 0)
{
return(list[0]);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 查看单个科目(根据科目名称)
/// </summary>
/// <returns></returns>
public List <Subject> FindSingleSubject(string subjectName)
{
try
{
string sqlWhere = string.Format(" and subjectName= '{0}'", subjectName);
List <Subject> list = SubjectAccess.SelectSignSubject(sqlWhere);
if (list != null && list.Count > 0)
{
return(list);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
public void AdminCreateTeacherTest()
{
//Arrange
bool isTeacherCreated = false;
var teacherAccess = new Mock <TeacherAccess>(new DBAccess());
teacherAccess.Setup(t => t.InsertTeacherToDB(It.IsAny <Teacher>())).Callback(() => isTeacherCreated = true);
GroupAccess groupAccess = new GroupAccess(new DBAccess());
SubjectAccess subjectAccess = new SubjectAccess(new DBAccess());
Admin admin = new Admin("Admin", "Adminov", "adminId", teacherAccess.Object, groupAccess, subjectAccess);
//Act
admin.CreateTeacher("Petro", "Petrov", "ID", "petrov", "abc123");
//Assert
Assert.IsTrue(isTeacherCreated);
}
public void AdminCreateGroupTest()
{
//Arrange
bool isGroupCreated = false;
var groupAccess = new Mock <GroupAccess>(new DBAccess());
groupAccess.Setup(t => t.InsertGroupToDB(It.IsAny <Group>())).Callback(() => isGroupCreated = true);
SubjectAccess subjectAccess = new SubjectAccess(new DBAccess());
TeacherAccess teacherAccess = new TeacherAccess(new DBAccess());
Admin admin = new Admin("Admin", "Adminov", "adminId", teacherAccess, groupAccess.Object, subjectAccess);
//Act
admin.CreateGroup("TEST");
//Assert
Assert.IsTrue(isGroupCreated);
}
public void AdminCreateStudentTest()
{
//Arrange
bool isStudentCreated = false;
var groupMock = new Mock <Group>("TEST");
groupMock.Setup(t => t.AddStudent(It.IsAny <Student>())).Callback(() => isStudentCreated = true);
SubjectAccess subjectAccess = new SubjectAccess(new DBAccess());
TeacherAccess teacherAccess = new TeacherAccess(new DBAccess());
GroupAccess groupAccess = new GroupAccess(new DBAccess());
Admin admin = new Admin("Admin", "Adminov", "adminId", teacherAccess, groupAccess, subjectAccess);
//Act
admin.CreateStudent("Ivan", "Ivanov", "Studak", "Zachotka", "Group", "ivanov", "ivanov");
//Assert
Assert.IsTrue(isStudentCreated);
}
public void AdminAssignSubjectToGroupTest()
{
//Arrange
bool isSubjectAssigned = false;
var groupMock = new Mock <Group>("TEST");
groupMock.Setup(t => t.AssignSubject(It.IsAny <Subject>())).Callback(() => isSubjectAssigned = true);
SubjectAccess subjectAccess = new SubjectAccess(new DBAccess());
TeacherAccess teacherAccess = new TeacherAccess(new DBAccess());
GroupAccess groupAccess = new GroupAccess(new DBAccess());
Admin admin = new Admin("Admin", "Adminov", "adminId", teacherAccess, groupAccess, subjectAccess);
Subject subject = new Subject("Subject");
//Act
admin.AssignSubjectToGroup(subject, groupMock.Object);
//Assert
Assert.IsTrue(isSubjectAssigned);
}
/// <summary>
/// 分页显示(管理员)
/// </summary>
/// <param name="pageIndex">几页</param>
/// <param name="pageSize">每页的数量</param>
/// <returns></returns>
public Pager <Subject> ShowPagerAdminMessageList(int pageIndex, int pageSize)
{
List <Subject> rows = new List <Subject>();
rows = SubjectAccess.SelectManageSubject();
for (int i = 0; i < pageSize; i++)
{
if (pageIndex * pageSize + i < rows.Count)
{
rows.Add(rows[pageIndex * pageSize + i]);
}
}
try
{
return(SubjectAccess.Select("", pageIndex, pageSize, "subjectSignEndTime DESC"));
}
catch (Exception ex)
{
return(null);
}
}
public static string Translate(this SubjectAccess member, Translator translator)
{
switch (member)
{
case SubjectAccess.None:
return(translator.Get("Enum.SubjectAccess.None", "Value 'None' in MemberAccess enum", "None"));
case SubjectAccess.Group:
return(translator.Get("Enum.SubjectAccess.Group", "Value 'Group' in MemberAccess enum", "Group"));
case SubjectAccess.Feed:
return(translator.Get("Enum.SubjectAccess.Feed", "Value 'Feed' in MemberAccess enum", "Feed"));
case SubjectAccess.SubFeed:
return(translator.Get("Enum.SubjectAccess.SubFeed", "Value 'SubFeed' in MemberAccess enum", "Feed and below"));
case SubjectAccess.SystemWide:
return(translator.Get("Enum.SubjectAccess.SystemWide", "Value 'SystemWide' in MemberAccess enum", "Whole system"));
default:
throw new NotSupportedException();
}
}
public NamedIntViewModel(Translator translator, SubjectAccess subject, bool selected)
: this((int)subject, subject.Translate(translator), selected)
{
}
public void Insert(Subject aSubject)
{
SubjectAccess context = new SubjectAccess();
context.Add(aSubject);
}
public List <Subject> GetAllSubjects()
{
SubjectAccess context = new SubjectAccess();
return(context.GetAll());
}
public void Empty()
{
SubjectAccess context = new SubjectAccess();
context.Empty();
}
/// <summary>
/// 更新科目信息
/// </summary>
/// <param name="id"></param>
/// <param name="diary"></param>
/// <returns></returns>
public Boolean UpdateSubject(int subjectID, Subject sub)
{
SubjectAccess.UpdateInfo(subjectID, sub);
return(true);
}
