public ActionResult <StudentData> AddStudentData(StudentData student)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var existingPesel = _dbContext.Students.SingleOrDefault(x => x.pesel == student.pesel);
var existingIndexNumber = _dbContext.Students.SingleOrDefault(x => x.indexNumber == student.indexNumber);
var existingEmail = _dbContext.Students.SingleOrDefault(x => x.email == student.email);
if (existingPesel != null || existingIndexNumber != null || existingEmail != null)
{
return(StatusCode(StatusCodes.Status409Conflict, "Student's data with the same pesel / index number or email already exists."));
}
_dbContext.Students.Add(student);
_dbContext.SaveChanges();
return(CreatedAtAction(nameof(GetStudentData), new { id = student.Id }, student));
}
catch (Exception exc)
{
while (exc.InnerException != null)
{
exc = exc.InnerException;
}
return(StatusCode(StatusCodes.Status500InternalServerError, exc.Message));
}
}
public ActionResult SaveStudent(StudentVM Model)
{
using (StudentDataContext dc = new StudentDataContext())
{
var student = dc.Student.Where(s => s.ID == Model.ID).FirstOrDefault();
var subject = dc.Subject.Where(s => s.SubjectName.ToLower() == Model.SubjectName.ToLower()).FirstOrDefault();
if (subject == null)
{
subject = new Subject();
subject.SubjectName = Model.SubjectName;
dc.Subject.Add(subject);
dc.SaveChanges();
}
if (student == null)
{
student = new Student();
dc.Student.Add(student);
}
student.FirstName = Model.FirstName;
student.LastName = Model.LastName;
student.Class = Model.Class;
student.SubjectID = subject.ID;
student.Marks = Model.Marks;
dc.SaveChanges();
}
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "Id,Room,Title,CourseName")] Subject subject)
{
if (ModelState.IsValid)
{
db.Subjects.Add(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(subject));
}
public ActionResult Create([Bind(Include = "Id,Name,LastName,Mark")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "Id,Title,Price,Duration")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(course));
}
public ActionResult Create(Student model)
{
model.Status = "Disactivated";
dbc.Students.Add(model);
dbc.SaveChanges();
var data = new
{
message = "Thanh Cong"
};
return(Json(data));
}
public ActionResult Update(Student model)
{
var data = dbc.Students.Single(a => a.Id == model.Id);
data.Name = model.Name;
data.Number = model.Number;
data.Sta = model.Sta;
dbc.SaveChanges();
return(Json(new
{
message = "Cap Nhat Thanh Cong"
}));
}
public ActionResult DeleteStudent(int ID)
{
using (StudentDataContext dc = new StudentDataContext())
{
var student = dc.Student.Where(s => s.ID == ID).FirstOrDefault();
dc.Student.Remove(student);
dc.SaveChanges();
}
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
public IActionResult AddGrade(CourseGrade courseGrade)
{
if (!ModelState.IsValid)
{
return(View());
}
courseGrade.CreatedDate = DateTime.Now;
_db.Grades.Add(courseGrade);
_db.SaveChanges();
return(RedirectToAction(nameof(StudentController.Index), "Student"));
}
