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;
}
