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(); }
public int UpdateMentorProfile(MentorScheduleModel msm) { List <subject> sl = new List <subject>(); subject s = (from us in context.subjects where us.id == msm.subject select us).FirstOrDefault(); sl.Add(s); User u = (from us in context.Users where us.ID == msm._mentorId select us).FirstOrDefault(); MentorProfile mp = (from us in context.MentorProfiles where us.fk_mentor_ID == msm._mentorId select us).FirstOrDefault(); mp.description = msm.description; mp.imgPath = msm.imgpath; mp.major = msm.major; foreach (subject st in u.subjects) { sl.Remove(st); } if (sl.Count > 0) { u.subjects = sl; } List <MentorSchedule> msList = (from r in context.MentorSchedules where r.fk_mentor_Id == msm._mentorId select r).ToList(); for (int i = 0; i <= 6; i++) { for (int j = 0; j < msm._schedule[i]._timeandRequest.Count; j++) { MentorSchedule msr = (from so in msList where so.fk_day_Id == msm._schedule[i].day & so.fk_time_id == msm._schedule[i]._timeandRequest[j].timeId select so).FirstOrDefault(); msr.isMentoring = msm._schedule[i]._timeandRequest[j].isMentorAvailable; } } try { return(context.SaveChanges()); } catch (Exception e) { return(0); } }
public void RegisterNewUser(RegisterModel regMod) { User user = new User(); user.fname = regMod.FirstName; user.lname = regMod.LastName; user.UserID = regMod.UserName; user.Password = regMod.Password; user.addr1 = regMod.Address1; user.addr2 = regMod.Address2; user.city = regMod.City; user.state = regMod.State; user.zip = regMod.ZipCode; user.phNo = regMod.PhoneNumber; user.user_type = regMod.EnrollAs; context.Users.Add(user); if (regMod.EnrollAs == 1) { MentorProfile mp = new MentorProfile(); mp.description = null; mp.imgPath = "/Uploads/UserImage/m1.jpeg"; mp.major = null; mp.User = user; context.MentorProfiles.Add(mp); List <weekday> weekdays = context.weekdays.Select(w => w).ToList(); List <time> times = context.times.Select(w => w).ToList(); foreach (weekday w in weekdays) { foreach (time t in times) { MentorSchedule ms = new MentorSchedule(); ms.fk_day_Id = w.dayid; ms.fk_time_id = t.timeid; ms.MentorProfile = mp; ms.fk_mentorship_id = null; ms.isMentoring = 0; context.MentorSchedules.Add(ms); } } } else if (regMod.EnrollAs == 2) { StudentProfile mp = new StudentProfile(); mp.description = null; mp.imgPath = "/Uploads/UserImage/m2.jpeg"; mp.clas = null; mp.User = user; context.StudentProfiles.Add(mp); List <weekday> weekdays = context.weekdays.Select(w => w).ToList(); List <time> times = context.times.Select(w => w).ToList(); foreach (weekday w in weekdays) { foreach (time t in times) { StudentSchedule ms = new StudentSchedule(); ms.fk_day_Id = w.dayid; ms.fk_time_id = t.timeid; ms.StudentProfile = mp; ms.fk_mentorship_id = null; context.StudentSchedules.Add(ms); } } } context.SaveChanges(); }