public College_Courses GetCollegeDetails(int collegeid)
{
var context = new xPenEntities();
var CollegeDetails = (from c in context.ViewIESColleges
where c.CollegeID == collegeid
select c).First();
var sid = (from s in context.IESCourses
where s.CollegeID == collegeid
select s).ToList();
var listStream = (from i in sid
join st in context.IESStreams
on i.StreamID equals st.StreamID
select new IESStream {
StreamID = (int)i.StreamID, StreamName = st.StreamName, Description = st.Description
}).ToList();
College_Courses collegecourse = new College_Courses();
collegecourse.UnivID = CollegeDetails.UniversityID;
collegecourse.CollegeName = CollegeDetails.CollegeName;
collegecourse.Streams = listStream;
return(collegecourse);
}
public IHttpActionResult AddNewCollegeWithStream([FromBody] College_Courses college_course)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
IESCollege college = new IESCollege
{
CollegeName = college_course.CollegeName,
UniversityID = college_course.UnivID
};
context.IESColleges.Add(college);
context.SaveChanges();
List <IESStream> courses = college_course.Streams;
foreach (IESStream i in courses)
{
context.IESCourses.Add(
new IESCourse
{
CollegeID = college.CollegeID,
StreamID = i.StreamID
}
);
}
context.SaveChanges();
dbContextTransaction.Commit();
}
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
