public ActionResult CreateTeacherForIdari(User user, Teacher teacher) { TempData["EventResult"] = TeacherManager.addTeacher(user, teacher); if (((SG_BLL.Tools.Result)TempData["EventResult"]).Status.Equals("error")) { var schools = SchoolManager.GetSchools(); var list = new SelectList(schools, "SchoolId", "Ad"); ViewBag.SchoolList = list; var items = new List<UnvanHelper>(); ResourceManager rm = new ResourceManager("SinavGorevlendirme.Resources.Genel", typeof(TeacherController).Assembly); foreach (var unv in Enum.GetValues(typeof(EnumUnvan))) { items.Add(new UnvanHelper((int)unv, rm.GetString(unv.ToString()))); } var unvanList = new SelectList(items, "UnvanId", "Unvan"); ViewBag.UnvanList = unvanList; return View(); } return RedirectToAction("CreateTeacherForIdari"); }
public static Result addTeacher(User newUser, Teacher teacher) { using (SGContext db = new SGContext()) { try { var userRepository = new Repository<User>(db); var user = userRepository.Find(d => d.TCKimlik == newUser.TCKimlik); if (user.Count() > 0) { result = new Result(SystemRess.Messages.hata_ayniTcSistemdeMevcut.ToString(), SystemRess.Messages.hatali_durum.ToString()); return result; } else if (string.IsNullOrEmpty(newUser.Sifre)) { newUser.Sifre = newUser.TCKimlik.ToString(); } var okulRepo = new Repository<School>(db); int okulID = teacher.Okul.SchoolId; var okul = okulRepo.Find(d => d.SchoolId == okulID); teacher.Okul = okul.First(); if (teacher.Unvan == 1) newUser.Rol = (int)SG_DAL.Enums.EnumRol.ogretmen; else if (teacher.Unvan == 2 || teacher.Unvan == 3) newUser.Rol = (int)SG_DAL.Enums.EnumRol.idareci; teacher.User = newUser; teacher.GorevSayisi = 0; var teacherRepo = new Repository<Teacher>(db); teacherRepo.Add(teacher); result = new Result(SystemRess.Messages.basarili_kayit.ToString(), SystemRess.Messages.basarili_durum.ToString()); return result; } catch (Exception) { result = new Result(SystemRess.Messages.hatali_kayit.ToString(), SystemRess.Messages.hatali_durum.ToString()); return result; } } }
public CreateTeacherWrapperModel(Teacher teacher, List<Teacher> teachers) { this.teachers = teachers; this.teacher = teacher; }
public static Result updateTeacher(User newUser, Teacher teacher) { using (SGContext db = new SGContext()) { try { var userRepository = new Repository<User>(db); var tchRepo = new Repository<Teacher>(db); var user = userRepository.First(d => d.UserId == newUser.UserId); var tch = tchRepo.First(d => d.TeacherId == teacher.TeacherId); user.Ad = newUser.Ad; user.Email = newUser.Email; user.Soyad = newUser.Soyad; user.TCKimlik = newUser.TCKimlik; user.Tel = newUser.Tel; tch.GenelBasvuru = teacher.GenelBasvuru; tch.Kidem = teacher.Kidem; tch.SchoolId = teacher.SchoolId; tch.Unvan = teacher.Unvan; db.SaveChanges(); result = new Result(SystemRess.Messages.basarili_kayit.ToString(), SystemRess.Messages.basarili_durum.ToString()); return result; } catch (Exception) { result = new Result(SystemRess.Messages.hatali_kayit.ToString(), SystemRess.Messages.hatali_durum.ToString()); return result; } } }
public static List<Teacher> ReadTeachersFromExcel(string filePath) { var data = new StringBuilder(); try { Net.SourceForge.Koogra.IWorkbook wb = null; string fileExt = Path.GetExtension(filePath); if (string.IsNullOrEmpty(fileExt)) { throw new Exception("File extension not found"); } if (fileExt.Equals(".xlsx", StringComparison.OrdinalIgnoreCase)) { wb = Net.SourceForge.Koogra.WorkbookFactory.GetExcel2007Reader(filePath); } else if (fileExt.Equals(".xls", StringComparison.OrdinalIgnoreCase)) { wb = Net.SourceForge.Koogra.WorkbookFactory.GetExcelBIFFReader(filePath); } Net.SourceForge.Koogra.IWorksheet ws = wb.Worksheets.GetWorksheetByIndex(0); List<Teacher> list = new List<Teacher>(); for (uint r = ws.FirstRow + 1; r <= ws.LastRow; ++r) { Net.SourceForge.Koogra.IRow row = ws.Rows.GetRow(r); if (row != null) { Teacher teacher = new Teacher(); teacher.User = new User(); teacher.Unvan = (int)SG_DAL.Enums.EnumUnvan.Ogretmen; teacher.GenelBasvuru = true; teacher.User.Rol = (int)SG_DAL.Enums.EnumRol.ogretmen; teacher.GorevSayisi = 0; for (uint colCount = ws.FirstCol; colCount <= ws.LastCol; ++colCount) { string cellData = string.Empty; if (row.GetCell(colCount) != null && row.GetCell(colCount).Value != null) { cellData = row.GetCell(colCount).Value.ToString(); switch (colCount) { case 0: teacher.User.Ad = cellData; break; case 1: teacher.User.Soyad = cellData; break; case 2: teacher.User.TCKimlik = Convert.ToInt64(cellData); teacher.User.Sifre = cellData; break; case 3: teacher.User.Email = cellData; break; case 4: teacher.User.Tel = cellData; break; case 5: teacher.Kidem = cellData; break; case 6: using (SGContext db = new SGContext()) { var schoolRepo = new Repository<School>(db); int mebkodu = Convert.ToInt32(cellData); School sch = schoolRepo.First(d => d.MebKodu == mebkodu); teacher.SchoolId = sch.SchoolId; } break; default: break; } } } list.Add(teacher); } } return list; } catch (Exception) { return new List<Teacher>(); } }
public ActionResult TeacherUpdate(User user, Teacher teacher) { TempData["EventResult"] = TeacherManager.updateTeacher(user, teacher); if (((FormsIdentity)User.Identity).Ticket.UserData == "idareci") { return RedirectToAction("TeacherEditForIdari", "Teacher", new { OgretmenId = teacher.TeacherId }); } else if (((FormsIdentity)User.Identity).Ticket.UserData == "ogretmen") { return RedirectToAction("PersonelBilgi", "Teacher", new { OgretmenId = teacher.TeacherId }); }else { return RedirectToAction("TeacherEdit", "Teacher", new { OgretmenId = teacher.TeacherId }); } }
public TeacherWrapperModel(User user, Teacher teacher, School okul) { this.user = user; this.teacher = teacher; this.okul = okul; }