public void SingleTableDoEdit(string code, string name, SchoolTypeEnum schooltype, string remark)
{
SchoolTop s = new SchoolTop();
s.SchoolCode = "000";
s.SchoolName = "default";
s.SchoolType = null;
s.Remark = "default";
_schoolvm.Entity = s;
_schoolvm.DoAdd();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
SchoolTop s2 = new SchoolTop();
s2.SchoolCode = code;
s2.SchoolName = name;
s2.SchoolType = schooltype;
s2.Remark = remark;
s2.ID = s.ID;
_schoolvm.DC = context;
_schoolvm.Entity = s2;
_schoolvm.DoEdit(true);
}
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var rv = context.Set <SchoolTop>().ToList();
Assert.AreEqual(1, rv.Count());
Assert.AreEqual(code, rv[0].SchoolCode);
Assert.AreEqual(name, rv[0].SchoolName);
Assert.AreEqual(schooltype, rv[0].SchoolType);
Assert.AreEqual(remark, rv[0].Remark);
}
}
/// <summary>
/// 取得指定條件下的學校資訊.
/// </summary>
/// <param name="countyId">縣市ID.</param>
/// <param name="districtId">鄉鎮市區ID.</param>
/// <param name="schoolType">學校類別.</param>
/// <returns>List<SchoolInfoDto>.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public List <SchoolInfoDto> GetSchoolInfosByCondition(string countyId,
string districtId,
SchoolTypeEnum schoolType)
{
if (string.IsNullOrWhiteSpace(countyId))
{
throw new ArgumentNullException(nameof(countyId), "please input value");
}
if (string.IsNullOrWhiteSpace(districtId))
{
throw new ArgumentNullException(nameof(districtId), "please input value");
}
var allSchoolInfos = this.GetAllSchoolInfos();
var schools = allSchoolInfos.Where
(
x => x.CountyID == countyId &&
x.DistrictID.HasValue &&
x.DistrictID.Value == Convert.ToInt32(districtId) &&
x.SchoolTypeID == Convert.ToInt32(schoolType)
);
return(schools.ToList());
}
public void SingleTableDoAdd(string code, string name, SchoolTypeEnum schooltype, string remark)
{
SchoolTop s = new SchoolTop();
s.SchoolCode = code;
s.SchoolName = name;
s.SchoolType = schooltype;
s.Remark = remark;
_schoolvm.Entity = s;
_schoolvm.DoAdd();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var rv = context.Set <SchoolTop>().ToList();
Assert.AreEqual(1, rv.Count());
Assert.AreEqual(code, rv[0].SchoolCode);
Assert.AreEqual(name, rv[0].SchoolName);
Assert.AreEqual(schooltype, rv[0].SchoolType);
Assert.AreEqual(remark, rv[0].Remark);
}
Assert.IsTrue(_schoolvm.MSD.Count == 0);
}
public void SingleTableDoEditFields(string code, string name, SchoolTypeEnum schooltype, string remark)
{
School s = new School();
s.SchoolCode = "000";
s.SchoolName = "default";
s.SchoolType = null;
s.Remark = "default";
_schoolvm.Entity = s;
_schoolvm.DoAdd();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
School s2 = new School();
s2.SchoolCode = code;
s2.SchoolName = name;
s2.SchoolType = schooltype;
s2.Remark = remark;
s2.ID = s.ID;
_schoolvm.DC = context;
_schoolvm.Entity = s2;
_schoolvm.FC.Add("Entity.SchoolName", name);
_schoolvm.DoEdit();
}
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var rv = context.Set <School>().ToList();
Assert.AreEqual(1, rv.Count());
Assert.AreEqual("000", rv[0].SchoolCode);
Assert.AreEqual(name, rv[0].SchoolName);
Assert.AreEqual(null, rv[0].SchoolType);
Assert.AreEqual("default", rv[0].Remark);
Assert.AreEqual("schooluser", rv[0].UpdateBy);
Assert.IsTrue(DateTime.Now.Subtract(rv[0].UpdateTime.Value).Seconds < 10);
}
}
public void SingleTableDoAdd(string code, string name, SchoolTypeEnum schooltype, string remark)
{
School s = new School();
s.SchoolCode = code;
s.SchoolName = name;
s.SchoolType = schooltype;
s.Remark = remark;
_schoolvm.Entity = s;
_schoolvm.DoAdd();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var rv = context.Set <School>().ToList();
Assert.AreEqual(1, rv.Count());
Assert.AreEqual(code, rv[0].SchoolCode);
Assert.AreEqual(name, rv[0].SchoolName);
Assert.AreEqual(schooltype, rv[0].SchoolType);
Assert.AreEqual(remark, rv[0].Remark);
Assert.AreEqual("schooluser", rv[0].CreateBy);
Assert.IsTrue(DateTime.Now.Subtract(rv[0].CreateTime.Value).Seconds < 10);
}
Assert.IsTrue(_schoolvm.MSD.Count == 0);
}
