public ActionResult Create([Bind(Include = "ThesisTypeID,MentorshipTypeID,PersonID,Student,ThesisTitle,Remarks,Year,Semester")] Mentorship mentorship) { if (ModelState.IsValid) { mentorship.MentorshipID = Guid.NewGuid(); mentorship.DateCreated = DateTime.Now; mentorship.DateModified = mentorship.DateCreated; mentorship.UserCreatedID = Guid.Parse(User.Identity.GetUserId()); mentorship.UserModifiedID = mentorship.UserCreatedID; db.Mentorships.Add(mentorship); db.SaveChanges(); return(RedirectToAction("Index")); } PopulateThesisTypesDropDownList(); PopulatePersonsDropDownList(); return(View(mentorship)); }
public ActionResult InsertMentors() { ViewBag.Message = "Insert Mentors"; //string path = "c:/MACA/mentors.txt"; string path = ""; //string path = ""; // To prevent bad actions! StreamReader srMentors = new StreamReader(path); List <Mentorship> lstMentors = new List <Mentorship>(); MentorshipsDbContext dbMentors = new MentorshipsDbContext(); PersonsDbContext dbPersons = new PersonsDbContext(); MentorshipTypeDbContext dbMentorshipType = new MentorshipTypeDbContext(); ThesisTypeDbContext dbThesisType = new ThesisTypeDbContext(); while (!srMentors.EndOfStream) { string[] lineArr = srMentors.ReadLine().Split(new char[] { '\t' }, StringSplitOptions.RemoveEmptyEntries); Mentorship mentor = new Mentorship(); mentor.MentorshipID = Guid.NewGuid(); string personCode = lineArr[0].Trim(); mentor.PersonID = dbPersons.Persons.Where(x => x.AISID == personCode).First().PersonID; int mentortype = int.Parse(lineArr[1].Trim()); mentor.MentorshipTypeID = dbMentorshipType.MentorshipTypes.Where(x => x.AISCode == mentortype).First().MentorshipTypeID; mentor.Year = lineArr[2].Trim(); int thesistype = int.Parse(lineArr[3].Trim()); mentor.ThesisTypeID = dbThesisType.ThesisTypes.Where(x => x.AISCode == thesistype).First().ThesisTypeID; mentor.Student = lineArr[4].Trim() + " " + lineArr[5].Trim(); mentor.ThesisTitle = lineArr[6].Trim(); lstMentors.Add(mentor); } srMentors.Close(); // Insert Persons foreach (Mentorship mentor in lstMentors) { mentor.DateCreated = DateTime.Now; mentor.DateModified = DateTime.Now; mentor.UserCreatedID = new Guid(User.Identity.GetUserId()); mentor.UserModifiedID = mentor.UserCreatedID; dbMentors.Mentorships.Add(mentor); dbMentors.SaveChanges(); } return(RedirectToAction("Administration")); }