public int SaveMentorshipRequest(MentorScheduleModel msm) { Mentorship mship = new Mentorship(); mship.active = 1; mship.fk_mentorId = msm._mentorId; mship.fk_studentId = msm.studentId; mship.fk_subject = msm.subject; mship.status = 1;//requested - 1,Accepted - 2,Rejected - 3 mship.comments = msm.comment; context.Mentorships.Add(mship); for (int i = 0; i <= 6; i++) { for (int j = 0; j < msm._schedule[i]._timeandRequest.Count; j++) { MentorScheduleRequest msr = new MentorScheduleRequest(); msr.fk_day_Id = msm._schedule[i].day; msr.fk_mentor_Id = msm._mentorId; msr.fk_student_Id = msm.studentId; msr.Mentorship = mship; msr.isRequested = msm._schedule[i]._timeandRequest[j].isRequested; msr.fk_time_id = msm._schedule[i]._timeandRequest[j].timeId; context.MentorScheduleRequests.Add(msr); } } try { return(context.SaveChanges()); } catch (Exception e) { return(0); } }
public void AcceptScheduleResponse(int mid, int stuid, int subid, int mshipid) { List <MentorScheduleRequest> msrList = (from r in context.MentorScheduleRequests where r.fk_mentor_Id == mid & r.Mentorship.id == mshipid select r).ToList(); List <MentorSchedule> msList = (from r in context.MentorSchedules where r.fk_mentor_Id == mid select r).ToList(); List <StudentSchedule> ssList = (from r in context.StudentSchedules where r.fk_student_Id == stuid select r).ToList(); foreach (MentorScheduleRequest msr in msrList) { Mentorship mship = msr.Mentorship; mship.status = 2;//accepted if (msr.isRequested == 1) { MentorSchedule ms = (from m in msList where m.fk_day_Id == msr.fk_day_Id & m.fk_time_id == msr.fk_time_id select m).FirstOrDefault(); /*if(ms.fk_mentorship_id != null){ * throw new Exception(); * }*/ ms.fk_mentorship_id = msr.fk_mentorship_id; StudentSchedule ss = (from m in ssList where m.fk_day_Id == msr.fk_day_Id & m.fk_time_id == msr.fk_time_id select m).FirstOrDefault(); ss.fk_mentorship_id = msr.fk_mentorship_id; } } context.SaveChanges(); }
private MentorshipVM GetMentorshipVM(Mentorship mentorship) { var dbTopic = TopicService.GetTopic(mentorship.TopicId); var rtnMentorship = new MentorshipVM(mentorship, new TopicVM(dbTopic)); var dbLearner = this.mainContext.Users.Where(u => u.Id == mentorship.LearnerUserId).FirstOrDefault(); if (dbLearner != null) { rtnMentorship.Learner = new UserVM(dbLearner); } if (rtnMentorship.HasMentor) { var dbMentor = this.mainContext.Users.Where(u => u.Id == mentorship.MentorUserId).FirstOrDefault(); if (dbMentor != null) { rtnMentorship.Mentor = new UserVM(dbMentor); } else { rtnMentorship.MentorshipId = Guid.Empty; rtnMentorship.HasMentor = false; } } return(rtnMentorship); }
public MentorScheduleModel FindthisMentorshipSchedule(int mshipID) { Mentorship mship = mr.GetMentorship(mshipID); MentorScheduleModel msm = new MentorScheduleModel(); msm._mentorId = mship.fk_mentorId; msm.subject = mship.fk_subject; msm.subjectName = mship.subject.name; msm.studentId = mship.fk_studentId; msm.mentorShipID = mshipID; List <DaySchedule> schList = new List <DaySchedule>(); List <MentorSchedule> msList = mr.GetMentorSchedule(mship.fk_mentorId); //find all mentor schedule records from the mentorSchedule table for (int i = 1; i <= 7; i++) { DaySchedule ds = new DaySchedule(); ds.day = i; List <TimeandRequest> timeList = new List <TimeandRequest>(); List <MentorSchedule> eachdayschedulelist = (from l in msList where l.fk_day_Id == i select l).ToList(); foreach (MentorSchedule eachSchedule in eachdayschedulelist) { TimeandRequest tnr = new TimeandRequest(); tnr.timeId = eachSchedule.fk_time_id; tnr.isRequested = eachSchedule.fk_mentorship_id == mshipID ? 1 : 0; timeList.Add(tnr); } ds._timeandRequest = timeList; schList.Add(ds); } msm._schedule = schList; return(msm); }
public ActionResult Edit([Bind(Include = "MentorshipID,ThesisTypeID,MentorshipTypeID,PersonID,Student,ThesisTitle,Remarks,Year,Semester")] MentorshipViewModel mentorshipViewModel) { if (ModelState.IsValid) { Mentorship model = db.Mentorships.Find(mentorshipViewModel.MentorshipID); model.ThesisTypeID = mentorshipViewModel.ThesisTypeID; model.MentorshipTypeID = mentorshipViewModel.MentorshipTypeID; model.PersonID = mentorshipViewModel.PersonID; model.Student = mentorshipViewModel.Student; model.ThesisTitle = mentorshipViewModel.ThesisTitle; model.Remarks = mentorshipViewModel.Remarks; model.Year = mentorshipViewModel.Year; model.Semester = mentorshipViewModel.Semester; model.DateModified = DateTime.Now; model.UserModifiedID = Guid.Parse(User.Identity.GetUserId()); db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } PopulateThesisTypesDropDownList(mentorshipViewModel.ThesisTypeID, mentorshipViewModel.MentorshipTypeID); PopulatePersonsDropDownList(mentorshipViewModel.PersonID); return(View(mentorshipViewModel)); }
public Response <Mentorship> Post([FromBody] Mentorship value) { var service = new Services.Relationships.MentorshipService(Context, CurrentUser); // service.SaveMentorship(value); return(new Response <Mentorship>(value)); }
public ActionResult DeleteConfirmed(Guid id) { Mentorship mentorship = db.Mentorships.Find(id); db.Mentorships.Remove(mentorship); db.SaveChanges(); return(RedirectToAction("Index")); }
public void RejectScheduleResponse(int mid, int stuid, int subid, int mshipid) { List <MentorScheduleRequest> msrList = (from r in context.MentorScheduleRequests where r.fk_mentor_Id == mid & r.Mentorship.id == mshipid select r).ToList(); foreach (MentorScheduleRequest msr in msrList) { Mentorship mship = msr.Mentorship; mship.status = 3;//rejected } context.SaveChanges(); }
// GET: Mentorships/Details/5 public ActionResult Details(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Mentorship mentorship = db.Mentorships.Find(id); if (mentorship == null) { return(HttpNotFound()); } return(View(mentorship)); }
public VideoConference GetVideoConference(int mshipID) { VideoConference res = new VideoConference(); res.isMentor = true; Mentorship mship = mr.GetMentorship(mshipID); int mid = mship.fk_mentorId; int sid = mship.fk_studentId; res.mname = mr.GetNameFromID(mid); res.sname = mr.GetNameFromID(sid); res.mshipID = mshipID; return(res); }
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")); }
public void RegisterLearner(Guid UserId, Guid TopicId) { if (UserId == this.Actor.UserId || this.Actor.Roles.Contains("Admin")) { var dbMentorship = this.mainContext.Mentorships.Where(m => m.LearnerUserId == UserId && m.TopicId == TopicId && m.Active).FirstOrDefault(); if (dbMentorship == null) { var newMentorship = new Mentorship(UserId, TopicId); this.mainContext.Mentorships.Add(newMentorship); } SetUserTopic(UserId, TopicId, TopicStatus.Novice); this.mainContext.SaveChanges(); } }
// GET: Mentorships/Edit/5 public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Mentorship mentorship = db.Mentorships.Find(id); if (mentorship == null) { return(HttpNotFound()); } PopulateThesisTypesDropDownList(mentorship.ThesisTypeID, mentorship.MentorshipTypeID); PopulatePersonsDropDownList(mentorship.PersonID); return(View(mentorship)); }
public ActionResult WriteReview(int mshipID) { Mentorship mentorship = ch.GetMentorship(mshipID); UserImage img = mentorship.MentorProfile.User.UserImage; Review rev = mentorship.Review; WriteReviewViewModel model = new WriteReviewViewModel { MentorshipId = mshipID, ImageFilename = img != null ? img.imagePath : "", MentorName = mentorship.MentorProfile.User.fname + " " + mentorship.MentorProfile.User.lname, Email = mentorship.MentorProfile.User.UserID, Subject = mentorship.subject.name, Rating = rev == null ? -1 : (int)rev.rating, Comment = rev == null ? "" : rev.comments }; return(View(model)); }
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 MentorScheduleModel FindthisScheduleRequest(int mshipID) { List <MentorScheduleRequest> reqList = mr.GetMentorScheduleRequests(mshipID); Mentorship mship = mr.GetMentorship(mshipID); MentorScheduleModel msm = new MentorScheduleModel(); msm._mentorId = mship.fk_mentorId; msm.subject = mship.fk_subject; msm.subjectName = mship.subject.name; msm.studentId = mship.fk_studentId; msm.comment = mship.comments; //same mentorship id for all mentorschedulerequest records msm.name = mr.GetNameFromID(mship.fk_studentId); msm.imgpath = mr.GetStuImgPath(mship.fk_studentId); msm.mentorShipID = mshipID; List <DaySchedule> schList = new List <DaySchedule>(); List <MentorSchedule> allMyBusySchedule = mr.GetMentorBusySchedule(mship.fk_mentorId); for (int i = 1; i <= 7; i++) { DaySchedule ds = new DaySchedule(); ds.day = i; List <TimeandRequest> timeList = new List <TimeandRequest>(); List <MentorScheduleRequest> eachdayschedulelist = (from l in reqList where l.fk_day_Id == i select l).ToList(); foreach (MentorScheduleRequest eachSchedule in eachdayschedulelist) { TimeandRequest tnr = new TimeandRequest(); tnr.timeId = eachSchedule.fk_time_id; tnr.isRequested = eachSchedule.isRequested; tnr.isClashing = (tnr.isRequested == 1) && ((from a in allMyBusySchedule where a.fk_day_Id == i && a.fk_time_id == tnr.timeId select a).Count() > 0); timeList.Add(tnr); } ds._timeandRequest = timeList; schList.Add(ds); } msm._schedule = schList; return(msm); }