public void AddMarkToDatabase()
{
// Arrange
var classes = new List <StudentClass>();
var queryable = classes.AsQueryable();
var mockDbSet = new Mock <IDbSet <StudentClass> >();
mockDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Provider).Returns(queryable.Provider);
mockDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Expression).Returns(queryable.Expression);
mockDbSet.As <IQueryable <StudentClass> >().Setup(m => m.ElementType).Returns(queryable.ElementType);
mockDbSet.As <IQueryable <StudentClass> >().Setup(m => m.GetEnumerator()).Returns(() => queryable.GetEnumerator());
mockDbSet.Setup(d => d.Add(It.IsAny <StudentClass>())).Callback <StudentClass>((cl) => classes.Add(cl));
var mockDbContext = new Mock <IDatabaseContext>();
mockDbContext.Setup(c => c.StudentClasses).Returns(mockDbSet.Object);
var studentClassService = new StudentClassService(mockDbContext.Object);
var studentClass = new StudentClass("1A");
// Act
studentClassService.Add(studentClass);
// Assert
Assert.IsTrue(classes.Count() == 1);
Assert.IsTrue(classes.Contains(studentClass));
}
public void ReturnAllClasses()
{
// Arrange
var classes = new List <StudentClass>()
{
new StudentClass("1A"),
new StudentClass("2A"),
new StudentClass("3A")
}.AsQueryable();
var mockedDbSet = new Mock <IDbSet <StudentClass> >();
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Provider).Returns(classes.Provider);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Expression).Returns(classes.Expression);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.ElementType).Returns(classes.ElementType);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.GetEnumerator()).Returns(() => classes.GetEnumerator());
var mockedDbContext = new Mock <IDatabaseContext>();
mockedDbContext.Setup(c => c.StudentClasses).Returns(mockedDbSet.Object);
var studentClassService = new StudentClassService(mockedDbContext.Object);
// Act
var allClasses = studentClassService.GetAll().ToList();
// Assert
CollectionAssert.AreEqual(classes, allClasses);
}
public void ReturnNull_IfIdNotMatched()
{
// Arrange
var classes = this.GetClasses();
var queryable = classes.AsQueryable();
var mockedDbSet = new Mock <IDbSet <StudentClass> >();
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Provider).Returns(queryable.Provider);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Expression).Returns(queryable.Expression);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.ElementType).Returns(queryable.ElementType);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.GetEnumerator()).Returns(() => queryable.GetEnumerator());
var mockedDbContext = new Mock <IDatabaseContext>();
mockedDbContext.Setup(c => c.StudentClasses).Returns(mockedDbSet.Object);
var studentClassService = new StudentClassService(mockedDbContext.Object);
// Act
var id = Guid.NewGuid().ToString();
var cl = studentClassService.FindById(id);
// Assert
Assert.IsNull(cl);
}
public void ShouldReturnClass_IfTeacherIdMatched()
{
// Arrange
var teacherId = Guid.NewGuid().ToString();
var classes = new List <StudentClass>()
{
new StudentClass("1A"),
new StudentClass("2A")
{
FormMasterId = teacherId
},
new StudentClass("3A")
};
var queryable = classes.AsQueryable();
var mockedDbSet = new Mock <IDbSet <StudentClass> >();
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Provider).Returns(queryable.Provider);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.Expression).Returns(queryable.Expression);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.ElementType).Returns(queryable.ElementType);
mockedDbSet.As <IQueryable <StudentClass> >().Setup(m => m.GetEnumerator()).Returns(() => queryable.GetEnumerator());
var mockedDbContext = new Mock <IDatabaseContext>();
mockedDbContext.Setup(c => c.StudentClasses).Returns(mockedDbSet.Object);
var studentClassService = new StudentClassService(mockedDbContext.Object);
// Act
var cl = studentClassService.FindByTeacherId(teacherId);
// Assert
Assert.AreEqual(classes[1], cl);
Assert.AreEqual(classes[1].FormMasterId, teacherId);
}
private DataSet ds = null; //保存全部查询结果的数据集
public FrmScoreQuery()
{
InitializeComponent();
this.dgvScoreList.AutoGenerateColumns = false;
StudentClassService _studentClassService = new StudentClassService();
this.cboClass.DataSource = _studentClassService.GetAllClass();
this.cboClass.DisplayMember = "ClassName";
this.cboClass.ValueMember = "ClassId";
this.cboClass.SelectedIndex = -1;
}
public void CallDbContext_SaveMethod()
{
// Arrange
var mockedDbContext = new Mock <IDatabaseContext>();
mockedDbContext.Setup(c => c.Save()).Returns(1).Verifiable();
var studentClassService = new StudentClassService(mockedDbContext.Object);
// Act
var result = studentClassService.Save();
// Assert
Assert.IsTrue(result == 1);
mockedDbContext.Verify(c => c.Save(), Times.Once);
}
public FrmScoreQuery()
{
InitializeComponent();
//班级下拉列表-获取全部的班级信息
DataTable dt = new StudentClassService().GetAllClass().Tables[0];
//绑定
this.cboClass.DataSource = dt;
this.cboClass.ValueMember = "ClassId";
this.cboClass.DisplayMember = "ClassName";
this.cboClass.SelectedIndex = -1;
//显示全部查询成绩
ds = objListService.GetAllScoreList();
this.dgvScoreList.DataSource = ds.Tables[0];
//调整显示风格
new Common.DataGridViewStyle().DgvStyle3(this.dgvScoreList);
}
private DataSet ds = null;//保存全部查询结果的数据集
public FrmScoreQuery()
{
InitializeComponent();
//显示班级下拉框
DataTable dt = new StudentClassService().GetAllClass().Tables[0];
this.cboClass.DataSource = dt;
this.cboClass.ValueMember = "ClassId";
this.cboClass.DisplayMember = "ClassName";
//显示全部考试成绩
ds = objListService.GetAllScoreList();
this.dgvScoreList.DataSource = ds.Tables[0];
new Common.DataGridViewStyle().DgvStyle3(this.dgvScoreList);
//禁止列排序，保证列标题居中
foreach (DataGridViewColumn item in this.dgvScoreList.Columns)
{
item.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}