public JsonResult GetTakenCredit(int teachrId)
{
TeacherViewModel takenCredit = assignCourseToTeacherManager.GetTakenCredit(teachrId);
JsonResult jsonResult = Json(takenCredit);
return(jsonResult);
}
public TeacherViewModel GetStudentsList()
{
TeacherViewModel teacherViewModel = new TeacherViewModel();
using (SqlConnection connection =
new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
var command = new SqlCommand("GetStudentsList", connection)
{
CommandType = CommandType.StoredProcedure
};
connection.Open();
var adapter = new SqlDataAdapter(command);
var dataSet = new DataSet();
adapter.Fill(dataSet);
var studentsDataSetTable = dataSet.Tables[0];
var students = new List <Student>();
foreach (var row in studentsDataSetTable.Rows)
{
var student = new Student
{
Id = int.Parse(((DataRow)row).ItemArray[0].ToString()),
Name = ((DataRow)row).ItemArray[1].ToString()
};
students.Add(student);
}
connection.Close();
teacherViewModel.Students = students;
}
return(teacherViewModel);
}
public bool AddTeacher(TeacherViewModel teacherViewModel)
{
int rowsAffected;
iDALTeacher.AddTeacher(teacherViewModel, out rowsAffected);
return(rowsAffected > 0 ? true : false);
}
public async Task <bool> InsertOrUpdate(TeacherViewModel teacher)
{
using (_repository = new TeacherRepository())
{
return(await _repository.InsertOrUpdate(Mapper.MapingTeacher(teacher)));
}
}
public IActionResult Create()
{
TeacherViewModel viewModel = new TeacherViewModel();
viewModel.Sections = _schoolServices.ListOfSections().ToList();
return(View(viewModel));
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (Entities db = new Entities())
{
ViewBag.Action = "New Teachers";
return(View(new TeacherViewModel()));
}
}
else
{
using (Entities db = new Entities())
{
TeacherViewModel sub = new TeacherViewModel();
var menu = db.tblTeachers.Where(x => x.TeacherId == id).FirstOrDefault();
sub.TeacherId = menu.TeacherId;
sub.TeacherName = menu.TeacherName;
ViewBag.Action = "Edit Teacher";
return(View(sub));
}
}
}
public IActionResult Details(int id)
{
TeacherViewModel teacher = _mapper.Map <TeacherViewModel>(_userRepository
.GetById(id, includeCourses: true));
return(View(teacher));
}
public IActionResult Index()
{
if (!storedUserIdInSessionExists())
{
return(RedirectToAction("Index", "Home"));
}
Teacher teacher = storeDB.GetTeacherById((int)HttpContext.Session.GetInt32("userId"));
if (teacher == null)
{
return(RedirectToAction("Index", "Home"));
}
TeacherViewModel viewModel = new TeacherViewModel(teacher);
viewModel.TeachingSchools = storeDB.Teachersperschool.Where(x => x.Teacher.Id == viewModel.Teacher.Id).Select(x => x.School).ToList();
viewModel.TeachersPerSchoolDict = new Dictionary <int, List <Teacher> >();
foreach (School school in viewModel.TeachingSchools)
{
viewModel.TeachersPerSchoolDict.Add(school.Id, storeDB.Teachersperschool.Where(x => x.SchoolId == school.Id).Select(x => x.Teacher).ToList());
}
return(View(viewModel));
}
public ActionResult TeacherEdit(TeacherViewModel model)
{
try
{
//驗證授權：管理員
var pass = roleAuth.AdminAuth();
if (pass == true)
{
ViewBag.UserName = roleAuth.UserName();
ViewBag.RoleName = "Admin";
}
else
{
TempData["Msg"] = "無權限瀏覽該網頁，請登入會員瀏覽，謝謝！";
return(RedirectToAction("Login", "Home"));
}
TeacherOperation operation = new TeacherOperation();
operation.Update(model);
return(RedirectToAction(nameof(Teacher)));
}
catch (Exception ex)
{
TempData["Msg"] = ex.ToString();
return(RedirectToAction("Logout", "Home"));
}
}
public JsonResult Add([Bind(Prefix = "Item1")] TeacherViewModel viewModel)
{
try
{
var teacher = new Teacher()
{
Name = viewModel.Name,
SurName = viewModel.SurName,
PhoneNumber = viewModel.PhoneNumber,
IdentityNumber = viewModel.IdentityNumber,
LessonId = viewModel.LessonId,
Age = viewModel.Age,
DayOffId = viewModel.DayOffId,
Email = viewModel.Email,
CreateDate = DateTime.Now,
IsDeleted = false
};
context.Teachers.Add(teacher);
context.SaveChanges();
return(Json(new { result = "İşlem başarılı", resultType = true }));
}
catch
{
return(Json(new { result = "Beklenmedik bir hata oluştu", resultType = false }));
}
}
public ActionResult Create(TeacherViewModel teacherViewModel)
{
if (!ModelState.IsValid)
{
return(View(teacherViewModel));
}
UserRepository userRepository = new UserRepository();
List <Person> list = userRepository.GetAll();
if (list.Where(u => u.Email == teacherViewModel.Email).Any())
{
ModelState.AddModelError("error_email", "This email is already taken!");
return(View());
}
else if (list.Where(u => u.Username == teacherViewModel.Username).Any())
{
ModelState.AddModelError("error_username", "This username is already taken!");
return(View());
}
else
{
Teacher teacher = new Teacher();
teacher.FirstName = teacherViewModel.FirstName.First().ToString().ToUpper() + String.Join("", teacherViewModel.FirstName.Skip(1));
teacher.LastName = teacherViewModel.LastName.First().ToString().ToUpper() + String.Join("", teacherViewModel.LastName.Skip(1));
teacher.QualificationDegree = teacherViewModel.QualificationDegree;
teacher.Username = teacherViewModel.Username;
teacher.Password = teacherViewModel.Password;
teacher.Email = teacherViewModel.Email;
repository.Insert(teacher);
}
return(RedirectToAction("Index"));
}
public JsonResult Update(TeacherViewModel viewModel)
{
try
{
var teacher = context.Teachers.FirstOrDefault(x => x.Id == viewModel.Id);
if (teacher != null)
{
teacher.IdentityNumber = viewModel.IdentityNumber;
teacher.Id = viewModel.Id;
teacher.LessonId = viewModel.LessonId;
teacher.Age = viewModel.Age;
teacher.Email = viewModel.Email;
teacher.SurName = viewModel.SurName;
teacher.Name = viewModel.Name;
teacher.DayOffId = viewModel.DayOffId;
teacher.PhoneNumber = viewModel.PhoneNumber;
teacher.IsDeleted = false;
teacher.CreateDate = DateTime.Now;
context.SaveChanges();
return(Json(new { result = "Güncelleme başarılı", resultType = true }));
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
return(Json(new { result = "Beklenmedik bir hata oluştu", resultType = false }));
}
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
var teacher = await _context.Teachers.FindAsync(id);
if (teacher == null)
{
return(NotFound());
}
var model = new TeacherViewModel
{
Id = teacher.Id,
//TODO: Corregir con usuario
//FirstName = teacher.FirstName,
//LastName = teacher.LastName,
ImageUrl = teacher.ImageUrl
};
return(View(model));
}
public async Task <IActionResult> Edit(TeacherViewModel model)
{
if (ModelState.IsValid)
{
var teacher = await _context.Teachers.FindAsync(model.Id);
if (teacher == null)
{
return(NotFound());
}
//TODO: Corregir con usuario
//teacher.FirstName = model.FirstName;
//teacher.LastName = model.LastName;
//if (model.ImageFile != null)
//{
// teacher.ImageUrl = await _imageHelper.UploadImageAsync(
// model.ImageFile,
// model.FullName,
// "Teacher");
//}
_context.Update(teacher);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(model));
}
public static TeacherViewModel GetOne(string id)
{
using (var context = new FinalSchool())
{
var teacher = context.Teachers.Find(id);
var courses = (from course in context.Courses
join techcourse in context.TeacherCourses
on course.CourseId equals techcourse.CourseId
join teach in context.Teachers
on techcourse.TeacherId equals teach.TeacherId
where teach.TeacherId == id
select course.Name).ToList();
var teacherModel = new TeacherViewModel()
{
TeacherSNN = teacher.TeacherId,
FName = teacher.FName,
Age = teacher.Age,
City = teacher.City,
Street = teacher.Street,
LName = teacher.LName,
Email = teacher.Email,
Gender = teacher.Gender,
Password = teacher.Password,
Phone = teacher.Phone,
CourseName = courses,
};
return(teacherModel);
}
}
public ActionResult TeacherAdd(TeacherViewModel vm)
{
try
{
//驗證授權：管理員
var pass = roleAuth.AdminAuth();
if (pass == true)
{
ViewBag.UserName = roleAuth.UserName();
ViewBag.RoleName = "Admin";
}
else
{
TempData["Msg"] = "無權限瀏覽該網頁，請登入會員瀏覽，謝謝！";
return(RedirectToAction("Login", "Home"));
}
//vm.CreateTime = DateTime.Now.ToString();
TeacherOperation op = new TeacherOperation();
var result = op.Add(vm);
TempData["result"] = result;
return(RedirectToAction(nameof(Teacher)));
}
catch (Exception ex)
{
TempData["Msg"] = ex.ToString();
return(RedirectToAction("Logout", "Home"));
}
}
public static void PutOne(TeacherViewModel teacherModel)
{
using (var context = new FinalSchool())
{
var id = teacherModel.TeacherSNN;
foreach (var item in teacherModel.CourseName)
{
var CourseId = context.Courses.FirstOrDefault(w => w.Name == item).CourseId;
var teacherCourse = context.TeacherCourses.Find(id);
teacherCourse.TeacherId = id;
teacherCourse.CourseId = CourseId;
}
var teacher = context.Teachers.FirstOrDefault(x => x.TeacherId == teacherModel.TeacherSNN);
teacher.TeacherId = teacherModel.TeacherSNN;
teacher.FName = teacherModel.FName;
teacher.Email = teacherModel.Email;
teacher.Password = teacherModel.Password;
teacher.LName = teacherModel.LName;
teacher.Gender = teacherModel.Gender;
teacher.Street = teacherModel.Street;
teacher.City = teacherModel.City;
teacher.Phone = teacherModel.Phone;
teacher.Age = teacherModel.Age;
context.SaveChanges();
}
}
public async Task <IActionResult> Edit(int id, TeacherViewModel model)
{
if (ModelState.IsValid)
{
var teacher = await db.Teachers.FindAsync(model.Id);
teacher.TeacherName = model.TeacherName;
teacher.Designation = model.Designation;
teacher.Address = model.Address;
teacher.ContactNo = model.ContactNo;
teacher.Email = model.Email;
teacher.JoiningDate = model.JoiningDate;
if (model.TeacherPicture != null)
{
if (model.ExistingImage != null)
{
string filePath = Path.Combine(webHostEnvironment.WebRootPath, "Uploads", model.ExistingImage);
System.IO.File.Delete(filePath);
}
teacher.ProfilePicture = ProcessUploadedFile(model);
}
db.Update(teacher);
await db.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View());
}
public ActionResult CreateComment([Bind(Include = "Id,TeacherId,AuthorName,CommentText")] Comment comment)
{
if (ModelState.IsValid)
{
try
{
comment.Date = DateTime.Now;
Teacher teacher = Db.Teachers.Find(comment.TeacherId);
teacher.Comments.Add(comment);
Db.SaveChanges();
string to = teacher.User.UserName;
Email.Send(to, comment.AuthorName, "", comment.CommentText, EmailTemplate.Comment);
}
catch (Exception)
{
}
return(RedirectToAction("Index", new { id = comment.TeacherId }));
}
//ModelState.AddModelError("", "Some Error.");
var tvm = new TeacherViewModel();
tvm.Teacher = Db.Teachers.Find(comment.TeacherId);
tvm.Comment = comment;
return(View("Index", tvm));
}
public async Task <IActionResult> Delete(int?id)
{
if (id == null)
{
return(NotFound());
}
var employee = await db.Teachers
.FirstOrDefaultAsync(m => m.Id == id);
var teacherViewModel = new TeacherViewModel()
{
Id = employee.Id,
TeacherName = employee.TeacherName,
Designation = employee.Designation,
Address = employee.Address,
ContactNo = employee.ContactNo,
Email = employee.Email,
JoiningDate = employee.JoiningDate,
ExistingImage = employee.ProfilePicture
};
if (employee == null)
{
return(NotFound());
}
return(View(teacherViewModel));
}
public HttpResponseMessage Put(int id, [FromBody] TeacherViewModel teacherViewModel)
{
try
{
var userId = this.User.FindFirstValue(ClaimTypes.Name);
var tempUsers = AutoMapper.Mapper.Map <Users>(teacherViewModel);
tempUsers.CreatedDate = DateTime.Now;
tempUsers.Createdby = Convert.ToInt32(userId);
tempUsers.Password = EncryptLib.EncryptText(teacherViewModel.Password);
_users.UpdateUsers(tempUsers);
var tempTeacher = AutoMapper.Mapper.Map <Teacher>(teacherViewModel);
_teacher.UpdateTeacher(tempTeacher);
var response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.OK
};
return(response);
}
catch (Exception)
{
var response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.InternalServerError
};
return(response);
}
}
//public async Task<IActionResult> Index()
//{
// return View(await db.Teachers.ToListAsync());
//}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var teacher = await db.Teachers
.FirstOrDefaultAsync(m => m.Id == id);
var teacherViewModel = new TeacherViewModel()
{
Id = teacher.Id,
TeacherName = teacher.TeacherName,
Designation = teacher.Designation,
Address = teacher.Address,
ContactNo = teacher.ContactNo,
Email = teacher.Email,
JoiningDate = teacher.JoiningDate,
ExistingImage = teacher.ProfilePicture
};
if (teacher == null)
{
return(NotFound());
}
return(View(teacher));
}
public TeacherViewModel Create(TeacherPostModel model)
{
if (model.FirstName.Contains(" "))
{
return(new TeacherViewModel {
FirstName = "validation PL error", LastName = "Errorovich"
});
}
var teacherModel = new TeacherModel
{
FirstName = model.FirstName,
LastName = model.LastName,
LicenseNum = model.LicenseNum
};
var createResult = _teachersService.Create(teacherModel);
var result = new TeacherViewModel
{
Id = createResult.Id,
FirstName = createResult.FirstName,
LastName = createResult.LastName
};
return(result);
}
public IActionResult Index(int teacherId)
{
//Вывод инфо по одному преподавателю
TeacherViewModel _tch = _servicesmanager.Teachers.TeacherDBToViewModelById(teacherId);
return(View(_tch));
}
public IActionResult Create(TeacherViewModel viewModel)
{
if (!ModelState.IsValid)
{
viewModel.Sections = _schoolServices.ListOfSections().ToList();
return(View(viewModel));
}
string uniqueFileName = null;
if (viewModel.Photo != null)
{
string uploadsFolder = Path.Combine(_hostingEnviroment.WebRootPath, "images", "teachers");
uniqueFileName = Guid.NewGuid().ToString() + "_" + viewModel.Photo.FileName;
string filePath = Path.Combine(uploadsFolder, uniqueFileName);
viewModel.Photo.CopyTo(new FileStream(filePath, FileMode.Create));
}
IPositionStrategy strategy = new PositionStrategy();
string name = strategy.CreatePosition(viewModel.SectionId);
var sectionName = _schoolServices.GetSection((int)viewModel.SectionId).Name;
Teacher teacher = _factory.Create(viewModel);
Position position = _positionFactory.GetPosition(name);
teacher.Position = position;
teacher.PhotoPath = uniqueFileName;
_repository.Add(teacher);
return(RedirectToAction("Index"));
}
public static void ReadTeacherClasss(ObservableCollection <TeacherViewModel> teachers, ObservableCollection <ClassViewModel> classes, int year)
{
using (SqlConnection connection = new SqlConnection(Settings.Default.SQLConnection))
{
connection.Open();
using (SqlCommand command = new SqlCommand($"SELECT * FROM [TeacherClass] WHERE Year = {year}", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
int idTeacher = (int)reader["IdTeacher"];
TeacherViewModel teacher = teachers.FirstOrDefault(t => t.Id == idTeacher);
if (teacher != null)
{
int idClass = (int)reader["IdClass"];
ClassViewModel _class = classes.FirstOrDefault(c => c.Id == idClass);
if (_class != null)
{
teacher.Classes.Add(_class);
_class.Teachers.Add(teacher);
}
}
}
}
}
}
}
public void Remove(TeacherViewModel model)
{
if (model == null)
{
throw new ArgumentNullException("teacher");
}
}
public static void PostOne(TeacherViewModel teacherModel)
{
using (var context = new FinalSchool())
{
var teacher = new Teacher()
{
TeacherId = teacherModel.TeacherSNN,
FName = teacherModel.FName,
Age = teacherModel.Age,
City = teacherModel.City,
Street = teacherModel.Street,
LName = teacherModel.LName,
Email = teacherModel.Email,
Gender = teacherModel.Gender,
Password = teacherModel.Password,
Phone = teacherModel.Phone,
};
context.Teachers.Add(teacher);
foreach (var item in teacherModel.CourseName)
{
var CourseId = context.Courses.FirstOrDefault(w => w.Name == item).CourseId;
var teacherCourse = new TeacherCourse()
{
TeacherId = teacher.TeacherId,
CourseId = CourseId
};
context.TeacherCourses.Add(teacherCourse);
}
context.SaveChanges();
}
}
public async Task <IActionResult> Index(int page = 1)
{
double totalCount = await _context.Teachers.CountAsync();
int pageCount = (int)Math.Ceiling(totalCount / 5);
if (page < 1)
{
page = 1;
}
else if (page > pageCount)
{
page = pageCount;
}
ViewBag.PageCount = pageCount;
ViewBag.SelectedPage = page;
TeacherViewModel teacherViewModel = new TeacherViewModel
{
Teachers = _context.Teachers.Skip((page - 1) * 5).Take(5).ToList()
};
return(View(teacherViewModel));
}
public TeacherViewModel getStudentByID(int studentID)
{
var student = (from u in _db.users
join ut in _db.userTypes on u.userTypeID equals ut.ID
where u.ID == studentID &&
ut.type == "student"
select u).SingleOrDefault();
var group = (from g in _db.groups
join u in _db.users on g.userID equals u.ID
where u.ID == studentID
select g.name).SingleOrDefault();
var submissionCount = (from uas in _db.userAssignmentStats
join u in _db.users on uas.userID equals u.ID
where u.ID == studentID
select uas.submissionCount).SingleOrDefault();
var viewModel = new TeacherViewModel
{
Name = student.name,
Username = student.username,
Group = group,
Submission = submissionCount
};
return(viewModel);
}
