public ActionResult AddLesson(int subjectId, string topic, string content, string imglink, string videolink, string extraslink)
{
Lesson newLesson = new Lesson
{
SubjectId = subjectId,
Topic = topic,
Content = content,
LinkToImg = imglink.Length > 0 ? imglink : null,
LinkToMovie = videolink.Length > 0 ? videolink : null,
LinkToExtras = extraslink.Length > 0 ? extraslink : null,
Date = DateTime.Now.ToShortDateString()
};
Context.Lessons.Add(newLesson);
Context.SaveChanges();
Teacher teacher = Context.Teachers.Single(t => t.Email == Email);
Subject subject = Context.Subjects.Single(s => s.Id == subjectId);
AddLessonViewModel alvm = new AddLessonViewModel
{
FirstName = teacher.FirstName,
LastName = teacher.LastName,
Subject = subject,
Lessons = Context.Lessons.Where(l => l.SubjectId == subject.Id).ToList()
};
return(View("AddLesson", alvm));
}
public AddNewLessonScreen()
{
InitializeComponent();
addLessonView = new AddLessonViewModel();
lessonService = new LessonService();
BindingContext = addLessonView;
}
public ActionResult Save(AddLessonViewModel model, HttpPostedFileBase file)
{
ViewBag.Faculty = ListFaculty((int)EnumParamaterGroup.Faculty);
ViewBag.Departman = ListFaculty((int)EnumParamaterGroup.Departman);
ViewBag.Class = ListFaculty((int)EnumParamaterGroup.Class);
if (ModelState.IsValid)
{
var loginUser = GetLoginUser();
using (SduEntities ent = new SduEntities())
{
if (file != null)
{
string path = HttpContext.Server.MapPath("~/Content/docs/") + file.FileName;
file.SaveAs(path);
List <string> dt = new List <string>();
IWorkbook workbook;
IWorksheet sheet;
uint lastRow;
workbook = new Excel2007.Workbook(path);
sheet = workbook.Worksheets.GetWorksheetByIndex(0);
lastRow = sheet.LastRow;
for (uint i = 1; i <= lastRow; i++)
{
IRow row = sheet.Rows.GetRow(i);
string studentNo = "";
studentNo = GetCellValue(row, 0);
dt.Add(studentNo);
}
System.IO.File.Delete(path);
foreach (var item in dt)
{
Lesson lesson = new Lesson();
lesson.FacultyID = model.FacultyID;
lesson.DepartmanID = model.DepartmanID;
lesson.EducatorID = loginUser.ID;
lesson.LessonName = model.LessonName;
lesson.ClassID = model.ClassID;
lesson.LessonCode = model.LessonCode;
lesson.MaxContinuity = model.MaxContinuity;
lesson.StudentNo = item.ToString();
ent.Lesson.Add(lesson);
ent.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
}
else
{
return(View("Index", model));
}
}
// GET: DersEkle
public ActionResult Index()
{
ViewBag.Faculty = ListFaculty((int)EnumParamaterGroup.Faculty);
ViewBag.Departman = ListFaculty((int)EnumParamaterGroup.Departman);
ViewBag.Class = ListFaculty((int)EnumParamaterGroup.Class);
AddLessonViewModel model = new AddLessonViewModel();
model.FacultyID = GetLoginUser().FacultyID;
model.DepartmanID = GetLoginUser().DepartmanID;
return(View(model));
}
public ActionResult AddLesson(int subjectId)
{
Teacher teacher = Context.Teachers.Single(t => t.Email == Email);
Subject subject = Context.Subjects.Single(s => s.Id == subjectId);
AddLessonViewModel alvm = new AddLessonViewModel
{
FirstName = teacher.FirstName,
LastName = teacher.LastName,
Subject = subject,
Lessons = Context.Lessons.Where(l => l.SubjectId == subject.Id).ToList()
};
return(View("AddLesson", alvm));
}
public ActionResult GoToLessons(int subjectId)
{
Student student = Context.Students.Single(s => s.Email == Email);
Subject subject = Context.Subjects.Single(s => s.Id == subjectId);
List <Lesson> lessons = Context.Lessons.Where(l => l.SubjectId == subject.Id).ToList();
AddLessonViewModel alvm = new AddLessonViewModel
{
FirstName = student.FirstName,
LastName = student.LastName,
Subject = subject,
Lessons = lessons
};
return(View("GoToLessons", alvm));
}
public ActionResult AddLesson(int studentId)
{
var student = db.Students.Find(studentId);
if (student == null)
{
return(HttpNotFound());
}
var lessons = db.Lessons
//.Where(l => !l.StudentLessons.Any(sl => sl.Student.Id == studentId))
.ToList();
var response = new AddLessonViewModel
{
StudentId = student.Id,
StudentName = student.Name,
Lessons = lessons
};
return(View(response));
}
public AddLessonDialog(AddLessonViewModel viewModel)
{
InitializeComponent();
DataContext = viewModel;
}
public AddLessonPage(Student student)
{
InitializeComponent();
studentValue = student;
BindingContext = viewModel = new AddLessonViewModel(Student);
}
