public IActionResult AddNewStudent(Student S)
{
ORM.Student.Add(S);
ORM.SaveChanges();
return(RedirectToAction(nameof(StudentController.ShowAllStudents)));
}
public ActionResult Create([Bind(Include = "Id,Name,Code,CreditHours,Discription")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(course));
}
public ActionResult Create([Bind(Include = "StudentId,CourseId")] AssignCourse assignCourse)
{
if (ModelState.IsValid)
{
db.AssignCourses.Add(assignCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(assignCourse));
}
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 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);
}
}
