public void loadForm(bool isDeleteMU)
{
numbTotalBefore = 0m;
shouldRemoveRow = isDeleteMU;
btnUpdateMu.Enabled = false;
dgvMiniUnits.Rows.Clear();
string cmdtyCode;
string gradeCode;
string custName;
{
var withBlock = My.MyProject.Forms.FrmEditAddRailList;
if (isDeleteMU == false)
{
tempDt = withBlock.miniUnitDT;
}
else
{
tempDt = tempDeletedMUDT;
}
// Populate dgv
string totalbStr;
foreach (var mu in tempDt)
{
if (withBlock.cboCargoType.Text.Equals("BULK"))
{
mu.TotalBilled = Convert.ToDecimal(mu.TotalBilled);
}
// totalbStr = FormatNumber(mu.TotalBilled.ToString, 3)
else
{
mu.TotalBilled = Convert.ToInt32(mu.TotalBilled);
// totalbStr = FormatNumber(mu.TotalBilled.ToString, 0)
}
cmdtyCode = CommodityService.GetById(mu.CommodityId).CommodityCode;
gradeCode = GradeService.GetById(mu.GradeId).GradeCode;
custName = CompanyService.GetVWById(mu.CustomerId).CompanyName;
dgvMiniUnits.Rows.Add(withBlock.txtUnitNumber.Text + "(" + MdlBookingManagement.digitToLetter((object)mu.MiniUnitOrder).ToUpper() + ")", custName, cmdtyCode + " " + gradeCode, (object)mu.TotalBilled);
numbTotalBefore = (decimal)(numbTotalBefore + mu.TotalBilled);
}
// Set texts.
if (withBlock.cboCargoType.Text.Equals("BULK"))
{
labelTotalSomething.Text = "Total Weight:";
lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("0.###");
numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore;
lblTotaltoBeAsgn.Text = numbToReassign.ToString("0.###");
nucTotal.DecimalPlaces = 3;
}
else
{
labelTotalSomething.Text = "Total Pieces:";
lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("#");
numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore;
lblTotaltoBeAsgn.Text = numbToReassign.ToString("#");
nucTotal.DecimalPlaces = 0;
}
}
}
/// <summary>
/// 学生的课程
/// </summary>
/// <param name="StuNo">学生编号</param>
/// <returns></returns>
public List <Course> GetStudentCourse(string StuNo)
{
List <Course> courseList = new List <Course>();
try
{
//得到该学生的信息
Z_Student student = StudentService.GetEntity(u => u.F_StuNo == StuNo).FirstOrDefault();
//得到该学生所在的班级
Z_Class cClass = ClassService.GetEntity(c => c.F_Id == student.Z_C_F_Id).FirstOrDefault();
//查询到该学生所在的年级
Z_Grade grade = GradeService.GetEntity(g => g.F_ID == cClass.Z_G_F_ID).FirstOrDefault();
//得到该学生所在的专业
Z_Profession profession = ProfessionService.GetEntity(u => u.F_ID == cClass.Z_P_F_ID).FirstOrDefault();
//得到当前是第几周
SchollTime schollTime = GetSchollTime();
//查询到该专业的所有课程
IQueryable <Z_Course> courses = GetEntity(u => u.F_Major == profession.F_ProName).Where(u => u.F_Grade == grade.F_GradeName).Where(u => u.F_Class.Contains(cClass.F_ClassName)).Where(u => u.F_SchoolYear.Contains(schollTime.SearchYear)).Where(u => u.F_Term == schollTime.Term.ToString());
var cl = courses.OrderBy(u => u.F_Week).ThenBy(u => u.F_CourseTimeType).ToList();
cl.ForEach(u => u.F_CourseTimeType = u.F_CourseTimeType.Substring(0, u.F_CourseTimeType.Length - 1));
courseList = AutoMapperConfig.MapList(cl, courseList);
ComputedTimeLength(courseList);
}
catch (Exception e)
{
throw e;
}
return(courseList);
}
public ActionResult Edit(GradeViewModel model)
{
try
{
// TODO: Add update logic here
if (string.IsNullOrEmpty(model.GradeName))
{
return(View());
}
var result = GradeService.Update(model);
//var result = list.Where(e => e.GradeId == model.GradeId).FirstOrDefault();
if (result == null)
{
return(RedirectToAction("Index", new { ErrorMsg = "班级不存在" }));
}
//var index = list.IndexOf(result);
//result.GradeName = model.GradeName;
//list[index] = result;
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
/// <summary>
/// 修改年级名称
/// </summary>
/// <param name="id"></param>
/// <param name="name"></param>
/// <returns></returns>
public static async Task ChangeName(Guid id, string name)
{
using (var gradeSvc = new GradeService())
{
await gradeSvc.ChangeName(id, name);
}
}
// GET: Student/Details/5
public ActionResult Details(int?id)
{
if (id == null || !id.HasValue)
{
return(RedirectToAction("Index", "Student"));
}
studentSubjectService = new StudentSubjectService();
gradeService = new GradeService();
studentService = new StudentService();
Student student = studentService.GetStudentByID((int)id);
if (student == null)
{
return(RedirectToAction("Index"));
}
ICollection <StudentSubject> studentSubjects = studentSubjectService
.GetStudentSubjectsByStudentId((int)id);
Grade?averageGrade = studentSubjectService.GetStudentAverageGrade((int)id);
Course course = studentService.GetStudentCourse((int)id);
StudentAverageGradeViewModel viewModel = studentService
.CreateStudentAverageGradeViewModel(student, course, averageGrade);
return(View(viewModel));
}
private void btnSaveGrade_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtGradeCode.Text) | string.IsNullOrEmpty(txtGrade.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Fields Empty", "The Grade or Grade Code fields cannot be empty.", this);
}
else if (GradeService.VerifyByGradeCode(txtGradeCode.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Warning!", "This registration code already exists!", this);
}
else if (GradeId == 0)
{
if (GradeService.Insert(txtGradeCode.Text, txtGrade.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success", "Grade inserted successfully.", this);
My.MyProject.Forms.frmCommodityGrainMain.LoadGrade();
Close();
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Error!", "There was an error when changing the Grade, please contact the IT department. Error # 0122", this);
}
}
else if (GradeService.Update(GradeId, txtGradeCode.Text, txtGrade.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success", "Grade updated successfully.", this);
My.MyProject.Forms.frmCommodityGrainMain.LoadGrade();
Close();
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Error!", "There was an error when changing the Grade, please contact the IT department. Error # 0122", this);
}
}
public void Init()
{
_user = UserSession();
_repository = new UowRepository();
_gradeService = new GradeService(_user, _repository);
_sbError = new StringBuilder("");
}
static SchoolLogic()
{
_schoolService = ObjectBuilder <SchoolService> .Build();
_gradeService = ObjectBuilder <GradeService> .Build();
_mapper = MapBuilder.Build();
}
// public readonly FileService _fileService;
public GradesController(GradeService gradeservice, AnnouncementService announcementService, CourseService courseService, IWebHostEnvironment webHostEnvironment /*, FileService fileService*/)
{
_gradeservice = gradeservice;
_announcementService = announcementService;
_courseService = courseService;
_webHostEnvironment = webHostEnvironment;
//_fileService = fileService;
}
private void frmEditGrade_Load(object sender, EventArgs e)
{
if (GradeId != 0)
{
var L = GradeService.GetById(GradeId);
txtGrade.Text = L.GradeName;
txtGradeCode.Text = L.GradeCode;
}
}
public AttestationController(DbContext context, IWebHostEnvironment env)
{
_context = context;
_env = env;
_workerService = new WorkerService(context);
_gradeService = new GradeService(context);
_questionService = new QuestionService(context);
_attestationService = new AttestationService(context);
_answerService = new AnswerService(context);
}
public void LoadGrade()
{
listGrade = GradeService.GetAll();
var Lg = from b in listGrade
where b.GradeId != 0
select b;
GradeBindingSource.DataSource = Lg.ToList();
listGradeByColumn = Lg.ToList();
}
private static void TestGradeService()
{
Mapper.CreateMap <Grade, GradeDto>();
Mapper.CreateMap <GradeSubTopic, GradeSubTopicDto>();
Mapper.CreateMap <SubTopic, SubTopicDto>();
GradeService serv = new GradeService();
var dto = serv.GetSubTopicsByGradeId(2);
Console.WriteLine("testing titleServcie");
}
// GET: Grade/Edit/5
public ActionResult Edit(int id)
{
var result = GradeService.Get(id);
//var result = list.Where(e => e.GradeId == id).FirstOrDefault();
if (result == null)
{
return(RedirectToAction("Index", new { ErrorMsg = "班级不存在" }));
}
return(View(result));
}
// GET: Grade
public ActionResult Index(QueryGradeViewModel model)
{
var result = GradeService.Query(model);
//result = list;
//if (!string.IsNullOrEmpty(model.KeyWords))
//{
// result = list.Where(e => e.GradeName.Contains(model.KeyWords)).ToList();
//}
return(View(result));
}
public async Task EssayGradedWithoutGrade()
{
var context = EssayCompetitionContextInMemoryFactory.InitializeContext();
var essay = await this.seeder.SeedEssayAsync(context);
var gradeRepository = new EfRepository <Grade>(context);
var service = new GradeService(gradeRepository);
var result = service.EssayGradet(essay.Id);
Assert.True(result == false, "EssayGraded method does not work correctly");
}
static AccountLogic()
{
userService = ObjectBuilder <UserService> .Build();
userGradesService = ObjectBuilder <UserGradesService> .Build();
gradeService = ObjectBuilder <GradeService> .Build();
studentInfoService = ObjectBuilder <StudentInfoService> .Build();
mapper = MapBuilder.Build();
}
/// <summary>
/// 创建年级
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public static async Task CreateGrade(string name)
{
using (var gradeSvc = new GradeService())
{
var maxOrder = await gradeSvc.GetAll().MaxAsync(m => m.Order);
await gradeSvc.CreateAsync(new Grade()
{
Name = name
});
}
}
/// <summary>
/// 根据课程获取该课程下的所有学生
/// </summary>
/// <returns></returns>
public List <Z_Student> GetStudentsByCourseId(Course course)
{
// 获取学年
var grade = GradeService.GetEntity(gra => gra.F_GradeName == course.Grade).FirstOrDefault();
// 获取该课程所属专业
var profession = ProfessionService.GetEntity(u => u.F_ProName == course.Major).FirstOrDefault();
// 获取该课程下的班级
var classes = ClassService.GetEntity(u => u.Z_Grade.F_ID == grade.F_ID && u.Z_Profession.F_ID == profession.F_ID && course.Classes.Contains(u.F_ClassName));
// 获取班级下的所有学生
var stus = StudentService.GetEntity(stu => classes.Any(c => c.F_Id == stu.Z_Class.F_Id)).AsQueryable().ToList();
return(stus);
}
private void FrmGrainInvList_Load(object sender, EventArgs e)
{
firstLoad = true;
var giService = new GrainInventoryService();
dgvInventory.DataSource = GrainInventoryService.GetAllGrainInventory();
using (var db = new WTCCeresEntities())
{
{
var withBlock = cboCustomer;
var categories = new List <int>();
categories.Add((int)MdlEnum.CompanyCategory.CUSTOMER);
categories.Add((int)MdlEnum.CompanyCategory.CUSTOMER_VENDOR);
withBlock.DataSource = CompanyService.GetByCompanyCategoryId(categories, db);
withBlock.DisplayMember = "CompanyName";
withBlock.ValueMember = "CompanyId";
}
var exclusionList = new List <string>();
exclusionList.Add("RELEASED");
{
var withBlock1 = cboUnitNumber;
var newUs = new VW_UnitSourceMiniUnit();
newUs.MiniunitNumber = "";
newUs.MiniUnitId = 0;
var uslist = MiniUnitService.GetAll(exclusionList, db);
uslist.Insert(0, newUs);
withBlock1.DataSource = uslist;
withBlock1.DisplayMember = "MiniUnitNumber";
withBlock1.ValueMember = "MiniUnitId";
withBlock1.SelectedIndex = -1;
}
{
var withBlock2 = cboCommodity;
withBlock2.DataSource = CommodityService.GetAll(db);
withBlock2.DisplayMember = "CommodityCode";
withBlock2.ValueMember = "CommodityId";
}
{
var withBlock3 = cboGrade;
withBlock3.DataSource = GradeService.GetAll(db);
withBlock3.DisplayMember = "GradeCode";
withBlock3.ValueMember = "GradeId";
}
}
firstLoad = false;
}
public ActionResult Create(GradeViewModel model)
{
try
{
// TODO: Add insert logic here
GradeService.Create(model);
//list.Add(model);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public async Task GetEssayPointsTest()
{
var context = EssayCompetitionContextInMemoryFactory.InitializeContext();
var essay = await this.seeder.SeedEssayAsync(context);
var grade = await this.seeder.AddGradeAsync(context, essay.Id);
var gradeRepository = new EfRepository <Grade>(context);
var service = new GradeService(gradeRepository);
var resultedPoints = service.GetEssayPoints(essay.Id);
Assert.True(resultedPoints == grade.Points, "GetEssayPoints method does not work correctly");
}
public void GetAll_ShouldCallRepository()
{
var repository = new Mock <IGradeRepository>();
repository.Setup(x => x.GetAll())
.Returns(new List <Grade>())
.Verifiable();
var service = new GradeService(repository.Object);
var result = service.GetAll();
Assert.IsNotNull(result);
repository.Verify(x => x.GetAll(), Times.Once);
}
public void Setup()
{
SetUpContextOptions();
SetUpJwtOptions();
SetUpServices();
SetUpMapper();
SetUpLogger();
SetUpContext();
GradeService = new GradeService(Context, Mapper, Logger);
}
public void Setup()
{
this.initialStateGrade = GradeTestUtils.GetInitialStateGrade();
this.initialStateGradeDto = GradeTestUtils.GetInitialGradeDto(initialStateGrade.Id);
this.gradeCreationDto = GradeTestUtils.GetGradeCreationDto();
this.gradeEditingDto = GradeTestUtils.GetGradeEditingDto();
this._mockReadRepository = new Mock <IReadRepository>();
this._mockWriteRepository = new Mock <IWriteRepository>();
this._mockGradeMapper = new Mock <IGradeMapper>();
this._mockStudentService = new Mock <IStudentService>();
this._mockExamService = new Mock <IExamService>();
this._mockEmailService = new Mock <IEmailService>();
_gradeService = new GradeService(_mockReadRepository.Object, _mockWriteRepository.Object,
_mockGradeMapper.Object, _mockStudentService.Object, _mockExamService.Object, _mockEmailService.Object);
}
/// <summary>
/// 所有年级
/// </summary>
/// <returns></returns>
public static IEnumerable <SelectListItem> getAllGrades()
{
var grades = new List <SelectListItem> ();
var service = new GradeService();
var g = service.GetAll().GetEnumerator();
while (g.MoveNext())
{
var sli = new SelectListItem();
sli.Text = g.Current.Name;
sli.Value = g.Current.MyId.ToString();
//if (select != null && select.Id == g.Current.Id)
// sli.Selected = true;
grades.Add(sli);
}
return(grades);
}
/// <summary>
/// 年级下移
/// </summary>
/// <param name="gradeid"></param>
/// <returns></returns>
public static async Task GradeDown(Guid gradeid)
{
using (var gradeSvc = new GradeService())
{
var grade = await gradeSvc.GetOne(gradeid);
var beforeGrade = await gradeSvc.GetAll
(m => m.Order > grade.Order).FirstOrDefaultAsync();
if (beforeGrade == null)
{
return;
}
await gradeSvc.ChangeOrder(gradeid, beforeGrade.Order, false);
await gradeSvc.ChangeOrder(beforeGrade.Id, grade.Order);
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
// TODO: Add delete logic here
var result = GradeService.Delete(id);
//var result = list.Where(e => e.GradeId == id).FirstOrDefault();
if (result == null)
{
return(RedirectToAction("Index", new { ErrorMsg = "班级不存在" }));
}
//list.Remove(result);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult GetStuGradeByPro(int pageIndex = 1, int pageSize = 3)
{
BaseDal <Grade> based = new BaseDal <Grade>();
GradeService gradeser = new GradeService();
ChoseThemeDal c = new ChoseThemeDal();
GradeDal g = new GradeDal();
StudentDal studal = new StudentDal();
int total;
if (Request["action"] == "gettotal")
{
string pro = Request["pro"];
IQueryable <Grade> iq = gradeser.GetAllGradeByPro(pro, true);
IQueryable <Student> stuiq = studal.GetEntities(u => u.Profession.Pro_Name == pro);
total = iq.Count();
int prototal = stuiq.Count();
int[] arr = { pageIndex, pageSize, total, prototal };
string str = js.Serialize(arr);
Response.Write(str);
}
if (Request["action"] == "getgrade")
{
string pro = Request["pro"];
IQueryable <Grade> iq = gradeser.GetAllGradeByPro(pro, true);
total = iq.Count();
int pgindex = Convert.ToInt32(Request["pgindex"]);
iq = based.GetPageEntities <int?>(pageSize, pgindex, out total, u => u.Student.Profession.Pro_Name == pro, u => u.Score, true);
IList <string> strl = new List <string>();
foreach (var item in iq)
{
string s = item.Student.Stu_Name + "-" + item.Theme.Theme_Name + "-" + item.Teacher.Tea_Name + "-" + item.Score;
strl.Add(s);
}
string str = js.Serialize(strl);
Response.Write(str);
}
Response.End();
return(View());
}
public GradeController(GradeService gradeService)
{
_gradeService = gradeService;
//if (!_context.GradeItems.Any())
//{
// _context.GradeItems.Add(new GradeItem
// {
// Order = 1,
// Uiaa = "1",
// French = "1",
// Swiss = "I",
// BritishTech = "1",
// BritishAdj = "M",
// Usa = "5.0",
// Nordic = "1",
// Fb = "1",
// Vgrade = "VB-"
// });
// _context.SaveChanges();
//}
}
