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