public ActionResult Create([Bind(Include = "StudentId,StudentName,CNIC,ContactNo,Email")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,Age")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public void AddSubject(string subjectName, int subjectYear, string observations)
{
Subject subject = new Subject()
{
SubjectName = subjectName,
SubjectYear = subjectYear,
Observations = observations
};
ctx.Subjects.Add(subject);
ctx.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();
}
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 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
});
}
}
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 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 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 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 AddUserProfile(string identityId, string username, int studentCurrentYear, string studentIdNumber,
string lastName, string firstName)
{
User user = new User()
{
Id = identityId,
UserName = username,
StudentCurrentYear = studentCurrentYear,
StudentIdNumber = studentIdNumber,
LastName = lastName,
FirstName = firstName
};
ctx.Users.Add(user);
ctx.SaveChanges();
}
public ActionResult SignUp(Student s, HttpPostedFileBase ImagePath)
{
if (ModelState.IsValid == true)
{
try
{
if (ImagePath != null)
{
string path = Path.Combine(Server.MapPath("~/UploadedFiles/"), Path.GetFileName(ImagePath.FileName));
ImagePath.SaveAs(path);
s.ImagePath = path;
}
db.Students.Add(s);
int i = db.SaveChanges();
if (i > 0)
{
ViewBag.InsertMessage = "<script>alert('Registered Successfully !')</script>";
ModelState.Clear();
}
}
catch (Exception)
{
ViewBag.InsertMessage = "<script>alert('Registered Failed !')</script>";
}
}
return(View());
}
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 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 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 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 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 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 DeleteExam(int examId)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var findExam = dbContext.tblExams.Find(examId);
if (findExam != null)
{
dbContext.tblExams.Remove(findExam);
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 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));
}
public void EditExam(Exam editedExam)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbExam = dbContext.tblExams.Find(editedExam.ExamId);
dbExam.ExamPeriodId = editedExam.ExamPeriodId;
dbExam.CourseId = editedExam.CourseId;
dbExam.DateAndTime = editedExam.DateAndTime;
dbExam.Place = editedExam.Place;
dbExam.Price = editedExam.Price;
dbExam.IsPassed = editedExam.IsPassed;
dbContext.SaveChanges();
}
}
public void EditExamPeriod(ExamPeriod editedExamPeriod)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbExamPeriod = dbContext.tblExamPeriods.Find(editedExamPeriod.ExamPeriodId);
dbExamPeriod.Name = editedExamPeriod.Name;
dbExamPeriod.StartDate = editedExamPeriod.StartDate;
dbExamPeriod.EndDate = editedExamPeriod.EndDate;
dbExamPeriod.SchoolYear = editedExamPeriod.SchoolYear;
dbExamPeriod.IsActive = editedExamPeriod.IsActive;
dbExamPeriod.IsApsolvent = editedExamPeriod.IsApsolvent;
dbContext.SaveChanges();
}
}
private void button3_Click(object sender, EventArgs e)
{
StudentDbEntities context = new StudentDbEntities();
Student std = new Student();
std.StudentId = Int16.Parse(tbStdID.Text);
std.Name = tbStdName.Text;
std.Address = tbStdAddress.Text;
std.Age = Int16.Parse(tbStdAge.Text);
std.Gender = tbStdGender.Text;
std.Phone = tbStdPhone.Text;
context.Students.Add(std);
context.SaveChanges();
MessageBox.Show("Record is successfully inserted");
ViewUpdate();
Reset();
}
public void EditProfessor(Professor editedProfessor)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var dbProfessor = dbContext.tblProfessors.Find(editedProfessor.ProfessorId);
dbProfessor.NameAndSurname = editedProfessor.NameAndSurname;
dbProfessor.Address = editedProfessor.Address;
dbProfessor.BirthDate = editedProfessor.BirthDate;
dbProfessor.BirthPlace = editedProfessor.BirthPlace;
dbProfessor.Education = editedProfessor.Education;
dbProfessor.IsAdmin = editedProfessor.IsAdmin;
dbProfessor.Phone = editedProfessor.Phone;
dbProfessor.Username = editedProfessor.Username;
dbProfessor.Password = editedProfessor.Password;
dbContext.SaveChanges();
}
}
public Student AddStudent(Student newStudent)
{
using (StudentDbEntities dbContext = new StudentDbEntities())
{
var addStudnet = new tblStudents()
{
NameAndSurname = newStudent.NameAndSurname,
StudyProgramId = newStudent.StudyProgramId,
Address = newStudent.Address,
BirthDate = newStudent.BirthDate,
Balance = newStudent.Balance,
BirthPlace = newStudent.BirthPlace,
Phone = newStudent.Phone,
StudyYear = newStudent.StudyYear,
Username = newStudent.Username,
Password = newStudent.Password
};
dbContext.tblStudents.Add(addStudnet);
dbContext.SaveChanges();
var newStudentId = dbContext.StudentView.SingleOrDefault(x => x.StudentId == addStudnet.StudentId);
return(new Student()
{
StudentId = newStudentId.StudentId,
NameAndSurname = newStudentId.NameAndSurname,
StudyProgramId = newStudentId.StudyProgramId,
StudyProgramName = newStudentId.StudyProgramName,
DepartmentId = newStudentId.DepartmentId,
DepartmentName = newStudentId.DepartmantName,
Address = newStudentId.Address,
Balance = newStudentId.Balance,
BirthDate = newStudentId.BirthDate,
BirthPlace = newStudentId.BirthPlace,
StudyYear = newStudentId.StudyYear,
Phone = newStudentId.Phone,
Username = newStudentId.Username,
Password = newStudentId.Password
});
}
}
