public async Task <IActionResult> Update(int?id) { if (id == null) { return(NotFound()); } Teacher teacher = await _context.Teachers.FindAsync(id); if (teacher == null) { return(NotFound()); } TeacherDescription teacherDescription = await _context.TeacherDescriptions.Where(t => t.TeacherId == id).FirstOrDefaultAsync(); if (teacherDescription == null) { return(NotFound()); } TeacherVM teacherVM = new TeacherVM() { Teacher = teacher, TeacherDescription = teacherDescription }; return(View(teacherVM)); }
/////////////////////////////////////////////////////// public ActionResult AssignmentTurnIn(int classID, int assignmentID) { if (test(classID) != null) { return(test(classID)); } var urcL = db.UserRoleClasses.Where(i => i.RoleID == 3 && i.ClassID == classID); var list = new List <int>(); foreach (var i in urcL) { list.Add(i.UsersID); } var request = db.Users.Where(i => list.Contains(i.UsersID)).ToList(); var student = new TeacherVM(db.Classes.Where(i => i.ClassID == classID).FirstOrDefault(), request); student.assignment = db.Assignments.Where(i => i.ClassID == classID && i.AssignmentID == assignmentID).ToList(); var idid = User.Identity.GetUserId(); int studentID = db.Users.Where(a => a.IdentityID == idid).FirstOrDefault().UsersID; student.documents = GetFiles(classID, assignmentID, studentID); return(View("AssignmentTurnIn", "_StudentLayout", student)); }
public ActionResult CreateTeacher(TeacherVM tcr) { string str = ""; try { adminService.AddTeachersFromAdmin(tcr.Username, tcr.Email, Server.MapPath(ConfigurationManager.AppSettings["BasePath"])); ViewBag.Success = ""; return(View()); } catch (SqlException ex) { str = "Source:" + ex.Source; str += "\n" + "Number:" + ex.Number.ToString(); str += "\n" + "Message:" + ex.Message; str += "\n" + "Class:" + ex.Class.ToString(); str += "\n" + "Procedure:" + ex.Procedure.ToString(); str += "\n" + "Line Number:" + ex.LineNumber.ToString(); str += "\n" + "Server:" + ex.Server.ToString(); } finally { Response.Write(str); } return(View("Error", (object)"Invalid input for Teacher")); }
private static void FillSem(ExcelWorksheet worksheet, int sem, TeacherVM teacher) { var row = 8; foreach (var entry in teacher.Entries.Where(e => e.Subject.Семестр == sem)) { worksheet.Cells[row, 1].Value = entry.Subject.Название; worksheet.Cells[row, 2].Value = entry.Subject.Курс + ", ИТ"; worksheet.Cells[row, 3].Value = entry.Subject.Поток; worksheet.Cells[row, 4].Value = entry.Subject.Численность; worksheet.Cells[row, 5].Value = "ПЛ"; worksheet.Cells[row + 1, 5].Value = "ВЫП"; worksheet.Cells[row, 6].Value = entry.Lectures; worksheet.Cells[row, 7].Value = entry.Laboratory; worksheet.Cells[row, 8].Value = entry.Practical; worksheet.Cells[row, 9].Value = entry.Consultations; worksheet.Cells[row, 10].Value = entry.Test; worksheet.Cells[row, 11].Value = entry.Exams; worksheet.Cells[row, 12].Value = entry.Nir; worksheet.Cells[row, 14].Value = entry.CourseDesigning; worksheet.Cells[row, 15].Value = entry.Vkr; worksheet.Cells[row, 16].Value = entry.Gek + entry.Gak; worksheet.Cells[row, 17].Value = entry.Rma; worksheet.Cells[row, 20].Value = Math.Round(entry.Amount, 2); row += 2; worksheet.InsertRow(row, 2, row - 1); } }
private void teacherEditButton_Click(object sender, EventArgs e) { var selectedRowIndex = GetSelectedRowIndex(teachersDataGridView); if (selectedRowIndex == null) { return; } var teacher = TeachersRepository.GetAll()[(int)selectedRowIndex]; var teacherVM = new TeacherVM { Teacher = teacher, SubjectIds = TeacherSubjectRepository.GetSubjectsForTeacher(teacher.Id), }; new DetailedTeacherForm ( teacherVM, SubjectsRepository.GetAll(), updatedTeacherVM => { TeachersRepository.Update(updatedTeacherVM.Teacher); TeacherSubjectRepository.UpdateSubjectsForTeacher(updatedTeacherVM.Teacher.Id, updatedTeacherVM.SubjectIds); UpdateTeachersGrid(); return(true); } ).Show(); }
public async Task <IActionResult> Detail(int?id) { if (id == null) { return(NotFound()); } Teacher teacher = await _db.Teachers.FindAsync(id); TeacherContact teacherContact = await _db.TeacherContacts.FirstOrDefaultAsync(c => c.Id == teacher.TeacherContactId); SkillsTeacher skillsTeacher = await _db.SkillsTeachers.FirstOrDefaultAsync(c => c.Id == teacher.SkillsTeacherId); TeacherVM teacherVM = new TeacherVM() { Teacher = teacher, TeacherContact = teacherContact, SkillsTeacher = skillsTeacher }; if (teacherVM == null) { return(NotFound()); } return(View(teacherVM)); }
public async Task <IActionResult> CreateTeacher([FromBody] TeacherVM teacherVM) { var userId = userManager.GetUserId(User); var department = this.departmentRepository.GetAll().Where(d => d.AccountId == userId).FirstOrDefault(); if (department == null) { await signInManager.SignOutAsync(); return(RedirectToPage("Login")); } var accountId = await this.userRepository.CreateUserRole(teacherVM.Code, teacherVM.Code, "Teacher"); if (accountId != null) { var teacher = new Teacher(); teacher.AccountId = accountId; teacher.Code = teacherVM.Code; teacher.Name = teacherVM.Name; teacher.Information = teacherVM.Information; teacher.DepartmentId = department.Id; teacher.Department = department; this.teacherRepository.Insert(teacher); await this.teacherRepository.SaveChangeAsync(); return(Ok()); } return(BadRequest()); }
public async Task <IActionResult> DeletePost(int?id) { if (id == null) { return(NotFound()); } Teacher teacher = await _db.Teachers.FindAsync(id); TeacherContact teacherContact = await _db.TeacherContacts.FirstOrDefaultAsync(c => c.Id == teacher.TeacherContactId); SkillsTeacher skillsTeacher = await _db.SkillsTeachers.FirstOrDefaultAsync(c => c.Id == teacher.SkillsTeacherId); TeacherVM teacherVM = new TeacherVM() { Teacher = teacher, TeacherContact = teacherContact, SkillsTeacher = skillsTeacher }; if (teacherVM == null) { return(NotFound()); } PhotoFileDelete.IsDeletePhoto(_env.WebRootPath, "img/teacher", teacherVM.Teacher.Image); _db.TeacherContacts.Remove(teacherVM.TeacherContact); _db.SkillsTeachers.Remove(teacherVM.SkillsTeacher); _db.Teachers.Remove(teacherVM.Teacher); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
public static void Convert(EntitiesVMRegistry registry, string targetPath, TeacherVM teacher) { try { File.Copy(TemplatePath, targetPath, true); } catch (Exception e) { Console.WriteLine(e); } var newFile = new FileInfo(targetPath); try { using (var package = new ExcelPackage(newFile)) { FillTitle(package.Workbook.Worksheets[1], teacher); FillSem(package.Workbook.Worksheets[2], 1, teacher); FillSem(package.Workbook.Worksheets[3], 2, teacher); FillTotal(package.Workbook.Worksheets[5]); package.Save(); } } catch (Exception e) { Console.WriteLine(e); } }
public async Task <IActionResult> Update(int?id, TeacherVM teacherVM) { if (id == null) { return(NotFound()); } Teacher teacherDb = await _context.Teachers.FindAsync(id); if (teacherDb == null) { return(NotFound()); } TeacherDescription teacherDescriptionDb = await _context.TeacherDescriptions.Where(t => t.TeacherId == id).FirstOrDefaultAsync(); if (teacherDescriptionDb == null) { return(NotFound()); } Teacher teacher = teacherVM.Teacher; TeacherDescription teacherDescription = teacherVM.TeacherDescription; if ((teacher.Email.ToLower() != teacherDb.Email.ToLower()) || (teacher.PhoneNumber.ToLower() != teacherDb.PhoneNumber.ToLower())) { bool isExist = _context.Teachers.Where(t => !t.IsDeleted).Any(t => (t.Email.ToLower() == teacher.Email.ToLower()) || (t.PhoneNumber.ToLower() == teacher.PhoneNumber.ToLower())); if (isExist) { ModelState.AddModelError("Name", "Teacher with this email or number already exist!"); return(View(teacherVM)); } } if (teacher.Photo != null) { if (!teacher.Photo.PhotoValidate(ModelState)) { return(View(teacherVM)); } string folder = Path.Combine("site", "img", "teacher"); string fileName = await teacher.Photo.SaveImage(_env.WebRootPath, folder); teacherDb.Image = fileName; } teacherDb.Name = teacher.Name; teacherDb.Surname = teacher.Surname; teacherDb.Position = teacher.Position; teacherDb.Email = teacher.Email; teacherDb.PhoneNumber = teacher.PhoneNumber; teacherDb.Skype = teacher.Skype; teacherDb.Pinterest = teacher.Pinterest; teacherDb.Facebook = teacher.Facebook; teacherDb.Twitter = teacher.Twitter; teacherDb.Activeted = teacher.Activeted; teacherDescriptionDb = teacherDescription; teacherDb.teacherDescription = teacherDescriptionDb; await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
// GET: Teacher public ActionResult Index() { TeacherVM teacherVM = new TeacherVM(); teacherVM.Teachers = teacherService.GetActiveTeacher(); teacherVM.Branches = branchService.GetActiveBranch(); return(View(teacherVM)); }
public static Teacher ToEntity(this TeacherVM teacher) { return(new Teacher() { Id = teacher.Id, Name = teacher.Name, Degree = teacher.Degree }); }
private EntryVM CreateNewEntry(SubjectVM subject = null, TeacherVM teacher = null) { var newEntry = new EntryVM { Subject = subject, Teacher = teacher }; Context.EntitiesVmRegistry.Entries.Add(newEntry); return(newEntry); }
public Boolean AssignmentTurnInHelper(HttpPostedFileBase postedFile, int classID, int assignmentID, int studentID, byte[] bytes) { var submitted = DateTime.Now; var urcL = db.UserRoleClasses.Where(i => i.RoleID == 3 && i.ClassID == classID); var list = new List <int>(); foreach (var i in urcL) { list.Add(i.UsersID); } var date = DateTime.Now; var request = db.Users.Where(i => list.Contains(i.UsersID)).ToList(); var student = new TeacherVM(db.Classes.Where(i => i.ClassID == classID).FirstOrDefault(), request); student.assignment = db.Assignments.Where(i => i.ClassID == classID && i.AssignmentID == assignmentID).ToList(); if (db.Documents.Where(i => i.ClassID == classID && i.AssignmentID == assignmentID && i.UserID == studentID).ToList().Count() == 0) { var doc = new Document(); doc.Name = Path.GetFileName(postedFile.FileName); doc.ContentType = postedFile.ContentType; doc.Data = bytes; doc.ClassID = classID; doc.AssignmentID = assignmentID; doc.UserID = studentID; doc.submitted = submitted; doc.Grade = -1; doc.Date = date; doc.GradeID = db.Grades.Where(i => i.AssignmentID == assignmentID).FirstOrDefault().GradeID; db.AddDocument(doc); db.SaveChanges(); student.documents = GetFiles(classID, assignmentID, studentID); return(true); } else { var change = db.Documents.Where(i => i.ClassID == classID && i.AssignmentID == assignmentID && i.UserID == studentID).ToList(); change.ForEach(x => x.Name = Path.GetFileName(postedFile.FileName)); change.ForEach(x => x.ContentType = postedFile.ContentType); change.ForEach(x => x.Data = bytes); change.ForEach(x => x.ClassID = classID); change.ForEach(x => x.AssignmentID = assignmentID); change.ForEach(x => x.UserID = studentID); change.ForEach(x => x.submitted = submitted); change.ForEach(x => x.Date = date); db.SaveChanges(); student.documents = GetFiles(classID, assignmentID, studentID); return(false); } }
public ActionResult Edit(string id, TeacherVM teacherVM) { teacherVM.ID = id; if (ModelState.IsValid) { teacherAppService.UpdateTeacher(teacherVM); return(View()); } return(View(teacherVM)); }
public IActionResult Delete(TeacherVM teacherVM) { var data = _teacherService.Delete(teacherVM); if (data > 0) { return(Ok(data)); } return(BadRequest("Failed")); }
public void Test_Get_All_Teacher() { List <TeacherVM> teacher2 = new List <TeacherVM>(); //Act teacher2 = teacher.GetAllTeacher(); //Assert Assert.AreEqual(teacher2.Count, 1); }
public bool UpdateTeacher(TeacherVM teacherVM) { var teacher = Mapper.Map <Teacher>(teacherVM); teacher.user.Id = teacher.ID; TheUnitOfWork.Teacher.Update(teacher); TheUnitOfWork.Commit(); return(true); }
public int Delete(TeacherVM teacherVM) { parameters.Add("schoolId", teacherVM.SchoolId); parameters.Add("email", teacherVM.Email); using (var connection = new SqlConnection(_connectionString.Value)) { var items = connection.Execute("SP_DeleteTeacher", parameters, commandType: CommandType.StoredProcedure); return(items); } }
public bool SaveNewTeacher(TeacherVM teacherVM) { bool result = false; var teacher = Mapper.Map <Teacher>(teacherVM); if (TheUnitOfWork.Teacher.Insert(teacher)) { result = TheUnitOfWork.Commit() > new int(); } return(result); }
public Task <TeacherResource> UpdateTeacher([FromBody] TeacherVM teacher) { if (repository.UpdateTeacher(teacher) == null) { var jsonObject = new { id = teacher.Id, process = "update" }; var jsonString = JsonSerializer.Serialize(jsonObject); var bytesObject = Encoding.UTF8.GetBytes(jsonString); HelperMethods.Producer(bytesObject); } return(repository.GetTeacher((int)teacher.Id)); }
public IActionResult Post(TeacherVM teacherVM) { var data = _teacherService.Create(teacherVM); if (data > 0) { return(Ok(data)); } return(BadRequest("Failed")); //var status = Ok(data); }
public ActionResult Edit([Bind(Include = "TeacherId,FirstName,LastName,TeacherTitle")] TeacherVM teacherVM) { if (ModelState.IsValid) { Teacher teacher = TeacherMap.TeacherVMToTeacher(teacherVM); teachersRepo.Edit(teacher); return(RedirectToAction("Index")); } return(View(teacherVM)); }
public static TeacherVM TeacherToTeacherVM(Teacher teacher) { var teacherVM = new TeacherVM { TeacherId = teacher.TeacherId, FirstName = teacher.FirstName, LastName = teacher.LastName, TeacherTitle = (Title)teacher.Title, }; return(teacherVM); }
public async Task <IActionResult> EditTeacher(TeacherVM teacherVM) { var result = await _schoolClient.UpdateTeacher(teacherVM); if (result.Status == Status.Error) { ViewBag["updateTeacherErrorMessage"] = result.Message; return(RedirectToAction("EditTeacher", new { teacherid = teacherVM.MemberId, schoolid = teacherVM.SchoolId })); } return(RedirectToAction("ShowTeachers", new { schoolid = teacherVM.SchoolId })); }
public static Teacher TeacherVMToTeacher(TeacherVM teacherVM) { var teacher = new Teacher { TeacherId = teacherVM.TeacherId, FirstName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(teacherVM.FirstName.TrimStart().TrimEnd()), LastName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(teacherVM.LastName.TrimStart().TrimEnd()), Title = (int)teacherVM.TeacherTitle, }; return(teacher); }
// GET: Field/Edit/5 public ActionResult Edit(int id) { var teacher = teacherService.GetTeacherById(id); TeacherVM teacherVM = new TeacherVM() { ID = teacher.ID, Name = teacher.Name, BirthDate = teacher.BirthDate }; return(View(teacherVM)); }
public Exception UpdateTeacher(TeacherVM teacher) { try { dBContext.Teachers.Update(mapper.Map <Teacher>(teacher)); dBContext.SaveChanges(); return(null); } catch (Exception ex) { return(ex); } }
public async Task <TeacherVM> GetTeacherInfo(string teacherid) { try { TeacherVM teacher = await HttpMethods <TeacherVM> .GetAsync(Client, "/getTeacherInfo/" + teacherid); return(teacher); } catch (Exception) { return(new TeacherVM { }); } }
public Task <TeacherResource> AddTeacher([FromBody] TeacherVM teacher) { var Id = repository.AddTeacher(teacher); if (Id != 0) { var newTeacher = repository.GetTeacher(Id); var jsonObject = new { id = newTeacher.Result.Id, process = "add" }; var jsonString = JsonSerializer.Serialize(jsonObject); var bytesObject = Encoding.UTF8.GetBytes(jsonString); HelperMethods.Producer(bytesObject); } return(repository.GetTeacher(Id)); }