public string InsertInstructor(string name, string email, string title, string pwd, int d_id, string country, double size) { lecturer l = new lecturer { name_surname = name, email = email, title = title, password = pwd, department_id = d_id, }; db.lecturers.InsertOnSubmit(l); try { db.SubmitChanges(); return("sucess"); } catch (Exception ex) { return(ex.Message); } }
// Creates a new course from user input public void CreateCourse() { try { // at first check if all inputs filled if (InputLecturerFirstName == null || InputLecturerLastName == null || InputLecturerEmail == null || InputLecturerSalutation == null || InputCourseName == null || InputCourseSemester == null) { throw new FormatException(); } // create a lecturer for the new course lecturer newLecturer = new lecturer(); // add a new course to the db course newCourse = new course { semester = InputCourseSemester, name = InputCourseName, }; access.addCourse(newCourse); // check if lecturer already exist List <lecturer> listOfLecturers = new List <lecturer>(); listOfLecturers = access.LecturerContext.GetAll().Where(s => s.firstName == InputLecturerFirstName && s.lastName == InputLecturerLastName).ToList(); if (listOfLecturers != null) { // if no lecturer exist create a new one newLecturer = new lecturer { email = InputLecturerEmail, firstName = InputLecturerFirstName, lastName = InputLecturerLastName, salutation = InputLecturerSalutation }; access.LecturerContext.AddOne(newLecturer); access.LecturerContext.AddLecToCourse(newLecturer, newCourse); } else { // if lecturer exist fill the fields without add a new lecturer to the db foreach (lecturer existingLecturer in listOfLecturers) { newLecturer.firstName = existingLecturer.firstName; newLecturer.lastName = existingLecturer.lastName; newLecturer.email = existingLecturer.email; newLecturer.salutation = existingLecturer.salutation; } access.LecturerContext.AddOne(newLecturer); access.LecturerContext.AddLecToCourse(newLecturer, newCourse); } // update courseOverview Courses = access.GetAllCourses(); // close popup CreateCourseViewVisible = false; } catch (FormatException e) { InputFeedback = "Der Kurs konnte nicht erstellt werden. Bitte überprüfen Sie die Eingaben."; InputFeedbackPopup(); Console.WriteLine(e); } }
public ActionResult DeleteConfirmed(int id) { lecturer lecturer = db.lecturers.Find(id); db.lecturers.Remove(lecturer); db.SaveChanges(); return(RedirectToAction("Index")); }
public List <course> GetCoursesOfLectruer(int id) { using (se02team06 context = new se02team06()) { DbSet <lecturer> dbsetLectruer = context.Set <lecturer>(); lecturer lecturerTmp = dbsetLectruer.Find(id); context.Entry(lecturerTmp).Collection(s => s.courses).Load(); // loads Courses collection context.SaveChanges(); return(lecturerTmp.courses.ToList()); } }
public ActionResult Index(string txtStudent, string lecId) { lecturer _lect = db.lecturers.Find((string)Session["lecturerId"]); if (txtStudent == "") { return(RedirectToAction("Index", "SRVLogin", new { notFound = false })); } return(RedirectToAction("Index", "SRVLogin", new { value = txtStudent + "/" })); }
public ActionResult Edit([Bind(Include = "lecturer_Id,lecturer_Name,univercity_Id,College_Institute_Center")] lecturer lecturer) { if (ModelState.IsValid) { db.Entry(lecturer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.univercity_Id = new SelectList(db.univercities, "univercity_Id", "univercity_name", lecturer.univercity_Id); return(View(lecturer)); }
public void AddLecToCourse(lecturer lecturer, course course) { using (se02team06 context = new se02team06()) { DbSet <lecturer> dbsetLecturer = context.Set <lecturer>(); DbSet <course> dbsetCourse = context.Set <course>(); var tmpLec = dbsetLecturer.Find(lecturer.lecturerID); var tmpCourse = dbsetCourse.Find(course.courseID); tmpLec.courses.Add(tmpCourse); context.SaveChanges(); } }
private void FillLecturer() { firstNameLecturer.ForEach(firstname => { lecturer tmplec = new lecturer { salutation = salutationLecturer[firstNameLecturer.IndexOf(firstname)], firstName = firstname, lastName = lastNameLecturer[firstNameLecturer.IndexOf(firstname)], email = emailLecturer[firstNameLecturer.IndexOf(firstname)] }; lecDbSet.AddLecToCourse(lecDbSet.AddOne(tmplec), courseDbSet.GetById(firstNameLecturer.IndexOf(firstname) + 1)); }); }
public Lecturer ConvertLecturer(lecturer l) { Lecturer lecturer = new Lecturer { LecturerID = l.lecturerID, FirstName = l.firstName, LastName = l.lastName, Salutation = l.salutation, Email = l.email, Courses = new List <Course>() }; return(lecturer); }
// GET: lecturers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } lecturer lecturer = db.lecturers.Find(id); if (lecturer == null) { return(HttpNotFound()); } return(View(lecturer)); }
private void FillLecturer() { firstNameLecturer.ForEach(firstname => { lecturer tmplec = new lecturer { salutation = salutationLecturer[firstNameLecturer.IndexOf(firstname)], firstName = firstname, lastName = lastNameLecturer[firstNameLecturer.IndexOf(firstname)], email = emailLecturer[firstNameLecturer.IndexOf(firstname)] }; lecDbSet.AddLecToCourse(lecDbSet.AddOne(tmplec), courseDbSet.GetById(firstNameLecturer.IndexOf(firstname) + 1)); Console.WriteLine($"fill lecturer {tmplec.firstName}{tmplec.lastName} and add to course"); }); Console.WriteLine("- - - - - - - Finished - - - - -"); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } lecturer lecturer = db.lecturers.Find(id); if (lecturer == null) { return(HttpNotFound()); } ViewBag.univercity_Id = new SelectList(db.univercities, "univercity_Id", "univercity_name", lecturer.univercity_Id); return(View(lecturer)); }
public List <User> GetListUser <T> (List <T> list) { List <User> users = new List <User>(); // list type is student if (list.GetType().GetGenericArguments()[0].Name.Equals("student")) { list.ForEach(a => { student _s = a as student; users.Add(new User() { LecturerID = _s.StudentID, EmailAddress = _s.EmailAddress, GivenName = _s.GivenName, LastName = _s.LastName, UserType = "student" }); }); } // list type is lecturer else if (list.GetType().GetGenericArguments()[0].Name.Equals("lecturer")) { list.ForEach(a => { lecturer _s = a as lecturer; users.Add(new User() { LecturerID = _s.LecturerID, EmailAddress = _s.EmailAddress, GivenName = _s.GivenName, LastName = _s.LastName, UserType = "lecturer" }); }); } return(users); }
public ActionResult Index(string value, int?year, int?term) { lecturer _lect = new lecturer(); bool isStudent = true; var _listStudent = db.students.ToList(); // convert list of student to list of User List <User> _listUser = findUser.GetListUser(_listStudent); // find if input value existing in the list of user User _user = findUser.FindUserByInputValue(_listUser, value); // if user is null then try to find out if the input value is the lecturer if (_user == null) { var _listLecturer = db.lecturers.ToList(); // convert the list of lectuer to list of user _listUser = findUser.GetListUser(_listLecturer); // find out if the input value existing in the list of user _lect = findUser.FindUserByInputValue(_listUser, value); // if can't find lecturer, then redirect to Home controller if (_lect == null) { return(RedirectToAction("Index", "Home", new { notFound = false })); } else { Session["user"] = _lect; //Session["lecturer"] = _lect; //Session["lecturerId"] = _lect.LecturerID; isStudent = false; } } else { if (Session["user"] == null) { Session["user"] = _user; } isStudent = true; } if (isStudent) { if (Session["lecturerId"] != null) { _lect = db.lecturers.Find((string)Session["lecturerId"]); ViewBag.lecturer = _lect; } student _student = db.students.Find(_user.LecturerID); List <student_studyplan> studyPlans = _student.student_studyplan.ToList(); List <SelectListItem> quals = new List <SelectListItem>(); List <SelectListItem> studyPlanYear = new List <SelectListItem>(); List <SelectListItem> terms = new List <SelectListItem>(); foreach (var item in studyPlans) { quals.Add(new SelectListItem { Text = item.qualification.QualName, Value = item.QualCode }); } foreach (var item in studyPlans) { studyPlanYear.Add(new SelectListItem { Text = item.TermYearStart.ToString(), Value = item.TermYearStart.ToString() }); } for (int i = 1; i < 5; i++) { terms.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); } ViewBag.quals = quals; ViewBag.studyPlanYear = studyPlanYear; ViewBag.terms = terms; ViewBag.year = year; ViewBag.term = term; return(View("Student", _student)); } else { List <SelectListItem> listDept = new List <SelectListItem>(); List <crn_detail> listCrn = new List <crn_detail>(); listCrn = db.lecturers.Find(_lect.LecturerID).crn_detail.ToList(); //_lect.crn_detail.ToList(); HashSet <string> dept = new HashSet <string>(); foreach (var item in listCrn) { dept.Add(item.department.Department1); } foreach (var item in dept) { listDept.Add(new SelectListItem { Text = item, Value = item }); } ViewBag.dept = listDept; return(View("Lecturer", _lect)); } }
static void Main(string[] args) { using (var ctx = new tect_CodeFirstContext()) { try { try { ctx.lecturers.Remove(ctx.lecturers.ToList <lecturer>().ElementAt(0)); // ctx.lecturers.Remove(ctx.lecturers.ToList<lecturer>().ElementAt(1)); ctx.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } var lectureList = ctx.lecturers.ToList <lecturer>(); //Perform create operation Console.WriteLine("Perform create operation"); ctx.lecturers.Add(new lecturer() { lc_id = "L_1", lc_fname = "New lecturer" }); //Execute Insert, Update & Delete queries in the database ctx.SaveChanges(); var lects1 = ctx.lecturers.ToList <lecturer>(); Lecturers_print(lects1); //Perform Update operation Console.WriteLine("Perform Update operation"); var lecturerList1 = ctx.lecturers.ToList <lecturer>(); lecturer lecturerToUpdate = lecturerList1.Where(s => s.lc_fname == "New lecturer").FirstOrDefault <lecturer>(); lecturerToUpdate.lc_fname = "Edited lecturer"; //Execute Insert, Update & Delete queries in the database ctx.SaveChanges(); lects1 = ctx.lecturers.ToList <lecturer>(); Lecturers_print(lects1); Console.WriteLine(); SQL_qry(ctx); Console.WriteLine(); Console.WriteLine("Transaction example"); Transaction_test tr = new Transaction_test(); tr.StartOwnTransactionWithinContext(); lects1 = ctx.lecturers.ToList <lecturer>(); Lecturers_print(lects1); //Perform delete operation, re-read lecturers list Console.WriteLine("Perform delete operation"); lecturerList1 = ctx.lecturers.ToList <lecturer>(); ctx.lecturers.Remove(lecturerList1.ElementAt <lecturer>(0)); ctx.lecturers.Remove(lecturerList1.Where(s => s.lc_fname == "Edited second lecturer").FirstOrDefault <lecturer>()); //Execute Insert, Update & Delete queries in the database ctx.SaveChanges(); lects1 = ctx.lecturers.ToList <lecturer>(); Lecturers_print(lects1); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.ReadKey(); } }