public CCourse GetCourse(int courseId)
{
Assignment2Entities db = new Assignment2Entities();
Course course = db.Courses.Where(x => x.CourseId == courseId).FirstOrDefault();
List <Enroll> enrolls = course.Enrolls.ToList();
List <CStudent> classStudents = new List <CStudent>();
StudentWebService studentWebService = new StudentWebService();
foreach (Enroll e in enrolls)
{
classStudents.Add(studentWebService.ConvertToCStudent(e.Student));
}
CCourse cCourse = new CCourse();
db.Dispose();
cCourse = ConvertToCCourse(course);
cCourse.Students = classStudents;
return(cCourse);
}
public bool Save(CCourse value)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string sp = string.Format("sp_Course_Save @Id = {0}, @Name = '{1}'", value.Id, value.Name);
command = new SqlCommand(sp, connection);
int result = command.ExecuteNonQuery();
connection.Close();
return(result > 0);
}
}
public CCourse ConvertToCCourse(Course course)
{
CCourse cCourse = new CCourse();
cCourse.CourseId = course.CourseId;
cCourse.CourseCode = course.CourseCode;
cCourse.CourseName = course.CourseName;
cCourse.CourseCredits = course.CourseCredits;
cCourse.SemesterNumber = course.SemesterNumber;
return(cCourse);
}
public bool Save(CCourse value)
{
var row = Context.Courses.FirstOrDefault(x => x.Id == value.Id);
if (row != null)
{
Context.Entry(row).CurrentValues.SetValues(value);
}
else
{
Context.Courses.Add(value);
}
return(Context.SaveChanges() > 0);
}
public Boolean AddCourse(CCourse cCourse)
{
Assignment2Entities db = new Assignment2Entities();
Course course = new Course();
course = ConvertToCourse(cCourse);
db.Courses.Add(course);
db.SaveChanges();
db.Dispose();
return(true);
}
public Boolean SaveCourse(CCourse cCourse)
{
Assignment2Entities db = new Assignment2Entities();
Course course = db.Courses.Where(x => x.CourseId == cCourse.CourseId).FirstOrDefault();
Course studentTemp = ConvertToCourse(cCourse);
db.Entry(course).CurrentValues.SetValues(studentTemp);
db.SaveChanges();
db.Dispose();
return(true);
}
public List <CCourse> List()
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string sp = "sp_Course_List";
command = new SqlCommand(sp, connection);
dataReader = command.ExecuteReader();
List <CCourse> result = new List <CCourse>();
while (dataReader.Read())
{
int id = dataReader.GetFieldValue <int>(0);
string name = dataReader.GetFieldValue <string>(1);
CCourse item = new CCourse(id, name);
result.Add(item);
}
connection.Close();
return(result);
}
}
