public IHttpActionResult Get([FromUri] int id)
{
CourseStudentModel courseStudent = courseStudentBll.GetCourseStudentById(id);
if (courseStudent != null)
{
return(Ok(courseStudent));
}
return(NotFound());
}
public IHttpActionResult Put([FromUri] int id, [FromBody] CourseStudentModel value)
{
if (ModelState.IsValid)
{
bool succsess = courseStudentBll.UpdateCourseStudent(id, value);
if (succsess)
{
return(Ok());
}
}
return(BadRequest());
}
public IHttpActionResult post([FromBody] CourseStudentModel value)
{
if (ModelState.IsValid)
{
bool succsess = courseStudentBll.AddCourseStudent(value);
if (succsess)
{
return(Ok());
}
return(BadRequest());
}
else
{
return(BadRequest(ModelState));
}
}
public CourseStudentModel GetCourseStudentById(int id)
{
CourseStudentModel courseStudents = null;
using (AttenderEntities ef = new AttenderEntities())
{
CourseStudent item = ef.CourseStudents.FirstOrDefault(a => a.Id == id);
if (item != null)
{
courseStudents = new CourseStudentModel()
{
Id = item.Id,
StudentId = item.StudentId,
CourseId = item.CourseId
};
}
}
return(courseStudents);
}
// Create;
public bool AddCourseStudent(CourseStudentModel newCourseStudent)
{
using (AttenderEntities ef = new AttenderEntities())
{
CourseStudent courseStudents = new CourseStudent()
{
//Id = newCourseStudent.Id,
StudentId = newCourseStudent.StudentId,
CourseId = newCourseStudent.CourseId
};
//ef.CourseStudents.Add(courseStudents);
try
{
ef.Database.ExecuteSqlCommand($"INSERT INTO [dbo].[CourseStudents] ([StudentId],[CourseId]) VALUES ({courseStudents.StudentId} , {courseStudents.CourseId})");
//ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// update
public bool UpdateCourseStudent(int id, CourseStudentModel courseStudents)
{
using (AttenderEntities ef = new AttenderEntities())
{
CourseStudent updateCourseStudents = ef.CourseStudents.FirstOrDefault(a => a.Id == id);
if (updateCourseStudents == null)
{
return(false);
}
updateCourseStudents.StudentId = courseStudents.StudentId;
updateCourseStudents.CourseId = courseStudents.CourseId;
try
{
ef.Database.ExecuteSqlCommand($"UPDATE [dbo].[CourseStudents] SET [StudentId] = {updateCourseStudents.StudentId},[CourseId] = {updateCourseStudents.CourseId} WHERE [Id] = {id}");
//ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}