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