public IActionResult DeleteCourse([FromBody] int CID)
{
try
{
using (StudentManagementSystemContext db = new StudentManagementSystemContext())
{
var c = db.CourseMsts.Where(cu => cu.Cid == CID).FirstOrDefault();
if (c != null)
{
db.CourseMsts.Remove(c);
db.SaveChanges();
var ret = new ObjectResult(new { Value = 0, Err = "" });
return(ret);
}
else
{
var ret = new ObjectResult(new { Value = 0, Err = "Course couldnt found!" });
return(ret);
}
}
}
catch (System.Exception ex)
{
if (ex.InnerException != null && ex.InnerException.Message.ToLowerInvariant().Contains("reference constraint"))
{
var ret = new ObjectResult(new { Value = 0, Err = "Error! This course is referenced to other records!" });
return(ret);
}
else
{
var ret = new ObjectResult(new { Value = 0, Err = "Error! " + ex.Message });
return(ret);
}
}
}
public IActionResult SaveCourse([FromBody] CourseMst c)
{
try
{
using (StudentManagementSystemContext db = new StudentManagementSystemContext())
{
db.CourseMsts.Add(c);
db.SaveChanges();
}
var ret = new ObjectResult(new { Value = 0, Err = "" });
return(ret);
}
catch (System.Exception ex)
{
var ret = new ObjectResult(new { Value = 0, Err = "Error! " + ex.Message });
return(ret);
}
}
public IActionResult GetCourses()
{
List <CourseMst> lst = new List <CourseMst>();
try
{
using (StudentManagementSystemContext db = new StudentManagementSystemContext())
{
lst = db.CourseMsts.ToList();
}
var ret = new ObjectResult(new { Value = lst, Err = "" });
return(ret);
}
catch (System.Exception ex)
{
var ret = new ObjectResult(new { Value = lst, Err = "Bir hata oluştu! " + ex.Message });
return(ret);
}
}
public IActionResult DeleteCourse([FromBody] TeacherCourse tc)
{
try
{
using (StudentManagementSystemContext db = new StudentManagementSystemContext())
{
var lst = db.TeacherCourses.Where(d => d.Tid == tc.Tid && d.Cid == tc.Cid).ToList();
db.TeacherCourses.RemoveRange(lst.ToArray());
db.SaveChanges();
lst.Clear();
lst = null;
}
var ret = new ObjectResult(new { Value = 0, Err = "" });
return(ret);
}
catch (System.Exception ex)
{
var ret = new ObjectResult(new { Value = 0, Err = "Error! " + ex.Message });
return(ret);
}
}
public IActionResult GetCoursesExcept(int TID)
{
List <CourseMst> lst = new List <CourseMst>();
try
{
using (StudentManagementSystemContext db = new StudentManagementSystemContext())
{
var teacherCourses = db.TeacherCourses.Where(tc => tc.Tid == TID).Select(tc => tc.Cid).Distinct().ToList();
lst = db.CourseMsts.Where(c => !teacherCourses.Contains(c.Cid)).ToList();
teacherCourses.Clear();
teacherCourses = null;
}
var ret = new ObjectResult(new { Value = lst, Err = "" });
return(ret);
}
catch (System.Exception ex)
{
var ret = new ObjectResult(new { Value = lst, Err = "Bir hata oluştu! " + ex.Message });
return(ret);
}
}
public StudentController(StudentManagementSystemContext _ORM)
{
ORM = _ORM;
}
public HomeController(StudentManagementSystemContext context)
{
_context = context;
}
