public ActionResult StudentResult(int id)
{
BasExamContext context = new BasExamContext();
List <ExamOfStudent> examstudentlist = context.ExamOfStudents.Where(x => x.ExamID == id).ToList();
return(View(examstudentlist));
}
public ActionResult StudentRigth(int id)
{
context = new BasExamContext();
List <QuestionOfStudent> questions = context.QuestionOfStudents.Where(x => x.ExamOfStudentID == id).ToList();
return(View(questions));
}
public static List <ExamAvg> AverageOfAllExam()
{
BasExamContext context = new BasExamContext();
//List<ExamOfStudent> examOfStudent = context.ExamOfStudents.ToList();
List <ExamAvg> examAvgList = new List <ExamAvg>();
ExamAvg examAvg;
double temp = 0;
int studentCount = 0;
string[] examName = { "1.Sınav", "2.Sınav", "3.Sınav", "4.Sınav" };
for (int i = 0; i < examName.Length; i++)
{
foreach (Exam item in context.Exams.Where(x => x.Name == examName[i]).ToList())
{
foreach (ExamOfStudent exofstudent in item.ExamOfStudents.ToList())
{
temp += exofstudent.Score;
studentCount++;
}
}
examAvg = new ExamAvg();
examAvg.average = temp / studentCount;
examAvg.examName = examName[i];
examAvgList.Add(examAvg);
temp = 0;
studentCount = 0;
}
return(examAvgList);
}
public static List <ExamAvg> AverageExam(long classroomID)
{
BasExamContext context = new BasExamContext();
List <Exam> examList = context.Exams.Where(x => x.ClassroomID == classroomID).ToList();
List <ExamOfStudent> examOfStudents;
ExamAvg examAvg;
List <ExamAvg> examAvgList = new List <ExamAvg>();
int temp = 0;
int studentCount = 0;
foreach (Exam item in examList)
{
examOfStudents = context.ExamOfStudents.Where(x => x.ExamID == item.Id).ToList();
studentCount = examOfStudents.Count;
foreach (ExamOfStudent e in examOfStudents)
{
temp += e.Score;
}
examAvg = new ExamAvg();
examAvg.examName = item.Name;
examAvg.average = temp / studentCount;
examAvgList.Add(examAvg);
}
return(examAvgList);
}
public ActionResult ExamStudentRigth(int id)
{
BasExamContext context = new BasExamContext();
List <QuestionOfStudent> StudentQuestion = context.QuestionOfStudents.Where(x => x.ExamOfStudentID == id).ToList();
return(View(StudentQuestion));
}
public ActionResult Index(int sayfa = 1)
{
//HelperMetots.IsLogin();
BasExamContext db = new BasExamContext();
List <Question> qlist = db.Questions.OrderByDescending(x => x.CreatedDate).ToList();
ViewBag.QuestionCount = qlist.Count;
return(View(qlist.ToPagedList(sayfa, 20)));
}
public Question GetByIDs(long id)
{
Question question = null;
using (context = new BasExamContext())
{
question = context.Questions.Find(id);
}
return(question);
}
public List <QuestionOfStudent> GetAll()
{
List <QuestionOfStudent> quesList = null;
using (context = new BasExamContext())
{
quesList = context.QuestionOfStudents.ToList();
}
return(quesList);
}
public Exam GetById(int id)
{
Exam exam = null;
using (context = new BasExamContext())
{
exam = context.Exams.Find(id);
}
return(exam);
}
public List <Exam> GetAll()
{
List <Exam> examList = null;
using (context = new BasExamContext())
{
examList = context.Exams.ToList();
}
return(examList);
}
public List <Classroom> GetAll()
{
List <Classroom> Classroomlist;
using (context = new BasExamContext())
{
Classroomlist = context.Classrooms.ToList();
}
return(Classroomlist);
}
public List <Section> GetAll()
{
List <Section> Sectionlist;
using (context = new BasExamContext())
{
Sectionlist = context.Sections.ToList();
}
return(Sectionlist);
}
public Section GetById(int id)
{
Section sec = new Section();
using (context = new BasExamContext())
{
sec = context.Sections.Find(id);
}
return(sec);
}
public Trainer GetById(int id)
{
Trainer trn = new Trainer();
using (context = new BasExamContext())
{
trn = context.Trainers.Find(id);
}
return(trn);
}
public List <Question> GetAll()
{
List <Question> questionList = null;
using (context = new BasExamContext())
{
questionList = context.Questions.ToList();
}
return(questionList);
}
public QuestionOfStudent GetById(int id)
{
QuestionOfStudent ques = null;
using (context = new BasExamContext())
{
ques = context.QuestionOfStudents.Find(id);
}
return(ques);
}
public bool Ekle_ReturnSonID(ExamOfStudent c, out int ID)
{
using (context = new BasExamContext())
{
ID = 0;
context.Entry(c).State = EntityState.Added;
context.SaveChanges();
ID = c.Id;
return(true);
}
}
public ExamOfStudent GetById(int id)
{
ExamOfStudent eos = new ExamOfStudent();
using (context = new BasExamContext())
{
eos = context.ExamOfStudents.Find(id);
}
return(eos);
}
public List <ExamOfStudent> GetAll()
{
List <ExamOfStudent> examofstudentlist;
using (context = new BasExamContext())
{
examofstudentlist = context.ExamOfStudents.ToList();
}
return(examofstudentlist);
}
public Student GetById(int id)
{
Student std = new Student();
using (context = new BasExamContext())
{
std = context.Students.Find(id);
}
return(std);
}
public Classroom GetById(int id)
{
Classroom clr = new Classroom();
using (context = new BasExamContext())
{
clr = context.Classrooms.Find(id);
}
return(clr);
}
public List <Trainer> GetAll()
{
List <Trainer> trainerlist;
using (context = new BasExamContext())
{
trainerlist = context.Trainers.ToList();
}
return(trainerlist);
}
public Subject GetById(int id)
{
Subject sub = new Subject();
using (context = new BasExamContext())
{
sub = context.Subjects.Find(id);
}
return(sub);
}
public Presentation GetById(int id)
{
Presentation prn = new Presentation();
using (context = new BasExamContext())
{
prn = context.Presentations.Find(id);
}
return(prn);
}
public List <Presentation> GetAll()
{
List <Presentation> presantationlist;
using (context = new BasExamContext())
{
presantationlist = context.Presentations.ToList();
}
return(presantationlist);
}
public ActionResult PastExam()
{
if (Session["UserId"] != null)
{
int id = Convert.ToInt32(Session["UserId"]);
StudentRepo srepo = new StudentRepo();
Student student = srepo.GetById(id);
BasExamContext context = new BasExamContext();
List <ExamOfStudent> studentexamlist = context.ExamOfStudents.Where(x => x.StudentID == student.Id).ToList();
return(View(studentexamlist));
}
return(View());
}
public bool Edit(Exam item)
{
using (context = new BasExamContext())
{
context.Entry(item).State = EntityState.Modified;
try
{
result = context.SaveChanges() > 0;
}
catch (Exception)
{
result = false;
}
}
return(result);
}
public bool Add(Question item)
{
using (context = new BasExamContext())
{
context.Entry(item).State = EntityState.Added;
try
{
result = context.SaveChanges() > 0;
}
catch
{
return(result);
}
}
return(result);
}
public bool Add(Student item)
{
using (context = new BasExamContext())
{
context.Entry(item).State = EntityState.Added;
//context.StudentS.Add(item);
try
{
result = context.SaveChanges() > 0;
}
catch (Exception)
{
return(result);
}
}
return(result);
}
public List <Subject> GetDropdown()
{
List <Subject> Subjectlist = null;
using (context = new BasExamContext())
{
try
{
Subjectlist = context.Subjects.ToList();
}
catch (Exception)
{
throw;
}
}
return(Subjectlist);
}
