public IEnumerable <Course> GetAllCourses()
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbCourses = dbContext.CourseView.ToList();
List <Course> courses = new List <Course>(dbCourses.Count);
foreach (var dbCourse in dbCourses)
{
Course course = new Course()
{
CourseId = dbCourse.CourseId,
Name = dbCourse.Name,
StudyProgramId = dbCourse.StudyProgramId,
StudyProgramName = dbCourse.StudyProgramName,
ProfessorId = dbCourse.ProfessorId,
ProfessorName = dbCourse.ProfessorName,
Assistant = dbCourse.Assistant,
ETCS = dbCourse.ETCS
};
courses.Add(course);
}
return(courses);
}
}
public IHttpActionResult UpdateStudentDetail(Student student)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
Student stud = new Student();
using (var database = new StudentDbEntities())
{
stud = database.Students.Find(student.StudentId);
if (stud != null)
{
stud.Name = student.Name;
stud.MobileNumber = student.MobileNumber;
stud.EmailId = student.EmailId;
stud.CourseEnrolled = student.CourseEnrolled;
stud.FeesStatus = student.FeesStatus;
var update = database.spUpdate(student.StudentId, student.Name, student.MobileNumber, student.EmailId, student.CourseEnrolled, student.FeesStatus);
database.SaveChanges();
}
}
}
catch (Exception)
{
throw;
}
return(Ok(student));
}
public UserViewModelsController()
{
this.db = new StudentDbEntities();
repositoryFactory = new ServiceFactory(db);
this.userRepository = repositoryFactory.GetUserRepository();
this.subjectRepo = repositoryFactory.GetSubjectRepository();
}
public Course AddCourse(Course newCourse)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var addCourse = new tblCourses()
{
Name = newCourse.Name,
StudyProgramId = newCourse.StudyProgramId,
ProfessorId = newCourse.ProfessorId,
Assistant = newCourse.Assistant,
ETCS = newCourse.ETCS
};
dbContext.tblCourses.Add(addCourse);
dbContext.SaveChanges();
var newCourseId = dbContext.CourseView.SingleOrDefault(x => x.CourseId == addCourse.CourseId);
return(new Course()
{
CourseId = newCourseId.CourseId,
Name = newCourseId.Name,
StudyProgramId = newCourseId.StudyProgramId,
StudyProgramName = newCourseId.StudyProgramName,
ProfessorId = newCourseId.ProfessorId,
ProfessorName = newCourseId.ProfessorName,
Assistant = newCourseId.Assistant,
ETCS = newCourseId.ETCS
});
}
}
private void ViewUpdate()
{
StudentDbEntities context = new StudentDbEntities();
var qry = context.Students.ToList();
dataGridView1.DataSource = qry;
}
public ExamPeriod AddExamPeriod(ExamPeriod newExamPeriod)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var addExamPeriod = new tblExamPeriods()
{
Name = newExamPeriod.Name,
StartDate = newExamPeriod.StartDate,
EndDate = newExamPeriod.EndDate,
SchoolYear = newExamPeriod.SchoolYear,
IsActive = newExamPeriod.IsActive,
IsApsolvent = newExamPeriod.IsApsolvent
};
dbContext.tblExamPeriods.Add(addExamPeriod);
dbContext.SaveChanges();
var newExamPeriodId = dbContext.tblExamPeriods.SingleOrDefault(x => x.ExamPeriodId == addExamPeriod.ExamPeriodId);
return(new ExamPeriod()
{
ExamPeriodId = newExamPeriodId.ExamPeriodId,
Name = newExamPeriodId.Name,
StartDate = newExamPeriodId.StartDate,
EndDate = newExamPeriodId.EndDate,
SchoolYear = newExamPeriodId.SchoolYear,
IsActive = newExamPeriodId.IsActive,
IsApsolvent = newExamPeriodId.IsApsolvent
});
}
}
public HomeController()
{
this.ctx = new StudentDbEntities();
this.repositoryFactory = new ServiceFactory(ctx);
this.userRepository = repositoryFactory.GetUserRepository();
this.reportsRepository = repositoryFactory.GetReportsRepository();
}
public IEnumerable <ExamPeriod> GetAllExamPeriods()
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbExamPeriods = dbContext.tblExamPeriods.ToList();
List <ExamPeriod> examPeriods = new List <ExamPeriod>(dbExamPeriods.Count);
foreach (var dbExamPeriod in dbExamPeriods)
{
ExamPeriod examPeriod = new ExamPeriod()
{
ExamPeriodId = dbExamPeriod.ExamPeriodId,
Name = dbExamPeriod.Name,
StartDate = dbExamPeriod.StartDate,
EndDate = dbExamPeriod.EndDate,
SchoolYear = dbExamPeriod.SchoolYear,
IsActive = dbExamPeriod.IsActive,
IsApsolvent = dbExamPeriod.IsApsolvent
};
examPeriods.Add(examPeriod);
}
return(examPeriods);
}
}
public IEnumerable <Student> GetAllStudents()
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbStudents = dbContext.StudentView.ToList();
List <Student> students = new List <Student>(dbStudents.Count);
foreach (var dbStudent in dbStudents)
{
Student student = new Student();
student.StudentId = dbStudent.StudentId;
student.DepartmentId = dbStudent.DepartmentId;
student.StudyProgramId = dbStudent.StudyProgramId;
student.NameAndSurname = dbStudent.NameAndSurname;
student.Address = dbStudent.Address;
student.Balance = dbStudent.Balance;
student.BirthDate = dbStudent.BirthDate;
student.BirthPlace = dbStudent.BirthPlace;
student.StudyProgramName = dbStudent.StudyProgramName;
student.DepartmentName = dbStudent.DepartmantName;
student.Username = dbStudent.Username;
student.Password = dbStudent.Password;
student.Phone = dbStudent.Phone;
student.StudyYear = dbStudent.StudyYear;
students.Add(student);
}
return(students);
}
}
public void DeleteProfessor(int professorId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findProfessor = dbContext.tblProfessors.Find(professorId);
if (dbContext.tblCourses.Any(x => x.ProfessorId == professorId))
{
DeleteFault fault = new DeleteFault()
{
Result = false,
Message = "Unable to delete!",
Description = "Professor is referenced in Course."
};
throw new FaultException <DeleteFault>(fault);
}
if (findProfessor != null)
{
dbContext.tblProfessors.Remove(findProfessor);
dbContext.SaveChanges();
}
}
}
public IEnumerable <Exam> GetAllExams()
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbExams = dbContext.ExamView.ToList();
List <Exam> exams = new List <Exam>(dbExams.Count);
foreach (var dbExam in dbExams)
{
Exam exam = new Exam()
{
ExamId = dbExam.ExamId,
ExamPeriodId = dbExam.ExamPeriodId,
ExamPeriodName = dbExam.ExamPeriodName,
CourseId = dbExam.CourseId,
CourseName = dbExam.CourseName,
DateAndTime = dbExam.DateAndTime,
Place = dbExam.Place,
Price = dbExam.Price,
IsPassed = dbExam.IsPassed
};
exams.Add(exam);
}
return(exams);
}
}
public void DeleteDepartment(int departmentId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findDepartment = dbContext.tblDepartments.Find(departmentId);
if (dbContext.tblStudyPrograms.Any(x => x.DepartmentId == departmentId))
{
DeleteFault fault = new DeleteFault()
{
Result = false,
Message = "Unable to delete!",
Description = "Department is referenced in Study Program."
};
throw new FaultException <DeleteFault>(fault);
}
if (findDepartment != null)
{
dbContext.tblDepartments.Remove(findDepartment);
dbContext.SaveChanges();
}
}
}
public IEnumerable <Professor> GetAllProfessors()
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbProfessors = dbContext.tblProfessors.ToList();
List <Professor> professors = new List <Professor>(dbProfessors.Count);
foreach (var dbProfessor in dbProfessors)
{
Professor prof = new Professor()
{
ProfessorId = dbProfessor.ProfessorId,
NameAndSurname = dbProfessor.NameAndSurname,
Address = dbProfessor.Address,
BirthDate = dbProfessor.BirthDate,
BirthPlace = dbProfessor.BirthPlace,
Education = dbProfessor.Education,
Phone = dbProfessor.Phone,
IsAdmin = dbProfessor.IsAdmin,
Username = dbProfessor.Username,
Password = dbProfessor.Password
};
professors.Add(prof);
}
return(professors);
}
}
public Department AddDepartment(Department newDepartment)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var addDepartment = new tblDepartments()
{
Name = newDepartment.Name,
FoundationYear = newDepartment.FoundationYear,
DepartmentHead = newDepartment.DepartmentHead,
Website = newDepartment.Website
};
dbContext.tblDepartments.Add(addDepartment);
dbContext.SaveChanges();
var newDepartmentId = dbContext.tblDepartments.SingleOrDefault(x => x.DepartmentId == addDepartment.DepartmentId);
return(new Department()
{
DepartmentId = newDepartmentId.DepartmentId,
Name = newDepartmentId.Name,
FoundationYear = newDepartmentId.FoundationYear,
DepartmentHead = newDepartmentId.DepartmentHead,
Website = newDepartmentId.Website
});
}
}
public Exam AddExam(Exam newExam)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var addExam = new tblExams()
{
ExamPeriodId = newExam.ExamPeriodId,
CourseId = newExam.CourseId,
DateAndTime = newExam.DateAndTime,
Place = newExam.Place,
Price = newExam.Price,
IsPassed = newExam.IsPassed
};
dbContext.tblExams.Add(addExam);
dbContext.SaveChanges();
var newExamId = dbContext.ExamView.SingleOrDefault(x => x.ExamId == addExam.ExamId);
return(new Exam()
{
ExamId = newExamId.ExamId,
ExamPeriodId = newExamId.ExamPeriodId,
ExamPeriodName = newExamId.ExamPeriodName,
CourseId = newExamId.CourseId,
CourseName = newExamId.CourseName,
DateAndTime = newExamId.DateAndTime,
Place = newExamId.Place,
Price = newExamId.Price,
IsPassed = newExamId.IsPassed
});
}
}
public void DeleteStudyProgram(int studyProgramId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findStudyProgram = dbContext.tblStudyPrograms.Find(studyProgramId);
if (dbContext.tblStudents.Any(x => x.StudyProgramId == studyProgramId))
{
DeleteFault fault = new DeleteFault()
{
Result = false,
Message = "Unable to delete!",
Description = "Study Program is referenced in Student."
};
throw new FaultException <DeleteFault>(fault);
}
if (findStudyProgram != null)
{
dbContext.tblStudyPrograms.Remove(findStudyProgram);
dbContext.SaveChanges();
}
}
}
public IEnumerable <ExamPeriod> GetActiveExamPeriods()
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
List <ExamPeriod> examPeriods = new List <ExamPeriod>();
var activeExamPeriods = dbContext.tblExamPeriods.Where(x => x.IsActive == true);
var date = DateTime.Now.ToLocalTime();
foreach (var activeExamPeriod in activeExamPeriods)
{
ExamPeriod ep = new ExamPeriod()
{
ExamPeriodId = activeExamPeriod.ExamPeriodId,
Name = activeExamPeriod.Name,
StartDate = activeExamPeriod.StartDate,
EndDate = activeExamPeriod.EndDate
};
examPeriods.Add(ep);
}
return(examPeriods);
}
}
public StudyProgram AddStudyProgram(StudyProgram newStudyProgram)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var addStudyProgram = new tblStudyPrograms()
{
Name = newStudyProgram.Name,
DepartmentId = newStudyProgram.DepartmentId,
BudgetPlaces = newStudyProgram.BudgetPlaces,
SelffinancedPlaces = newStudyProgram.SelffinancedPlaces,
Tuition = newStudyProgram.Tuition
};
dbContext.tblStudyPrograms.Add(addStudyProgram);
dbContext.SaveChanges();
var newSPId = dbContext.StudyProgramView.SingleOrDefault(x => x.StudyProgramId == addStudyProgram.StudyProgramId);
return(new StudyProgram()
{
StudyProgramId = newSPId.StudyProgramId,
Name = newSPId.Name,
DepartmentId = newSPId.DepartmentId,
DepartmentName = newSPId.DepartmentName,
BudgetPlaces = newSPId.BudgetPlaces,
SelffinancedPlaces = newSPId.SelffinancedPlaces,
Tuition = newSPId.Tuition
});
}
}
public void DeleteExamPeriod(int examPeriodId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findExamPeriod = dbContext.tblExamPeriods.Find(examPeriodId);
if (dbContext.tblExams.Any(x => x.ExamPeriodId == examPeriodId))
{
DeleteFault fault = new DeleteFault()
{
Result = false,
Message = "Unable to delete!",
Description = "Exam Period is referenced in Exam."
};
throw new FaultException <DeleteFault>(fault);
}
if (findExamPeriod != null)
{
dbContext.tblExamPeriods.Remove(findExamPeriod);
dbContext.SaveChanges();
}
}
}
public bool SetExamResults(List <ExamResult> examResults)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
try
{
foreach (var examResult in examResults)
{
var examResultForInsert = new tblExamResults()
{
ExamRegistrationId = examResult.ExamRegistrationId,
FirstTest = examResult.FirstTest,
SecondTest = examResult.SecondTest,
TermPaper = examResult.TermPaper,
WritenExam = examResult.WritenExam,
Total = examResult.Total,
Evaluation = examResult.Evaluation
};
dbContext.tblExamResults.Add(examResultForInsert);
}
dbContext.SaveChanges();
return(true);
}
catch (Exception e)
{
e.StackTrace.ToString();
return(false);
}
}
}
public void DeleteCourse(int courseId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findCourse = dbContext.tblCourses.Find(courseId);
if (findCourse != null)
{
dbContext.tblCourses.Remove(findCourse);
dbContext.SaveChanges();
}
}
}
public void DeleteStudent(int studentId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findStudent = dbContext.tblStudents.Find(studentId);
if (findStudent != null)
{
dbContext.tblStudents.Remove(findStudent);
dbContext.SaveChanges();
}
}
}
public void DeleteExam(int examId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findExam = dbContext.tblExams.Find(examId);
if (findExam != null)
{
dbContext.tblExams.Remove(findExam);
dbContext.SaveChanges();
}
}
}
private void button2_Click(object sender, EventArgs e)
{
int id = Int16.Parse(tbStdID.Text);
StudentDbEntities context = new StudentDbEntities();
Student std = context.Students.Where(x => x.StudentId == id).First();
context.Students.Remove(std);
context.SaveChanges();
context.SaveChanges();
MessageBox.Show("Successfully Deleted");
ViewUpdate();
Reset();
}
private void btnFind_Click(object sender, EventArgs e)
{
int id = Int16.Parse(tbStdID.Text);
StudentDbEntities context = new StudentDbEntities();
Student std = context.Students.Where(x => x.StudentId == id).First();
tbStdID.Text = std.StudentId.ToString();
tbStdName.Text = std.Name;
tbStdAddress.Text = std.Address;
tbStdAge.Text = std.Age.ToString();
tbStdGender.Text = std.Gender;
tbStdPhone.Text = std.Phone;
ViewUpdate();
}
public void EditDepartment(Department editedDepartment)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbDepartment = dbContext.tblDepartments.Find(editedDepartment.DepartmentId);
dbDepartment.Name = editedDepartment.Name;
dbDepartment.DepartmentHead = editedDepartment.DepartmentHead;
dbDepartment.FoundationYear = editedDepartment.FoundationYear;
dbDepartment.Website = editedDepartment.Website;
dbContext.SaveChanges();
}
}
public void EditStudyProgram(StudyProgram editedStudyProgram)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbStudyProgram = dbContext.tblStudyPrograms.SingleOrDefault(x => x.StudyProgramId == editedStudyProgram.StudyProgramId);
dbStudyProgram.Name = editedStudyProgram.Name;
dbStudyProgram.DepartmentId = editedStudyProgram.DepartmentId;
dbStudyProgram.BudgetPlaces = editedStudyProgram.BudgetPlaces;
dbStudyProgram.SelffinancedPlaces = editedStudyProgram.SelffinancedPlaces;
dbStudyProgram.Tuition = editedStudyProgram.Tuition;
dbContext.SaveChanges();
}
}
private void button1_Click(object sender, EventArgs e)
{
int id = Int16.Parse(tbStdID.Text);
StudentDbEntities context = new StudentDbEntities();
Student std = context.Students.Where(x => x.StudentId == id).First();
std.Name = tbStdName.Text;
std.Address = tbStdAddress.Text;
std.Age = Int16.Parse(tbStdAge.Text);
std.Gender = tbStdGender.Text;
std.Phone = tbStdPhone.Text;
context.SaveChanges();
MessageBox.Show("Update is successful");
ViewUpdate();
}
public void EditCourse(Course editedCourse)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbCourse = dbContext.tblCourses.SingleOrDefault(x => x.CourseId == editedCourse.CourseId);
dbCourse.Name = editedCourse.Name;
dbCourse.StudyProgramId = editedCourse.StudyProgramId;
dbCourse.ProfessorId = editedCourse.ProfessorId;
dbCourse.Assistant = editedCourse.Assistant;
dbCourse.ETCS = editedCourse.ETCS;
dbContext.SaveChanges();
}
}
public IHttpActionResult DeleteStudentDetail(int studentId)
{
using (var database = new StudentDbEntities())
{
Student stud = new Student();
stud = student.Students.Find(studentId);
if (stud == null)
{
return(NotFound());
}
var delete = database.spDelete(studentId);
database.SaveChanges();
}
return(Ok(student));
}
