public IActionResult AssignASubjectToATeacher([FromBody] Teacher_Subject teacher_Subject)
{
using (SqlConnection Connection = new SqlConnection(ConnectionInformation))
{
string InsertCommand = "INSERT INTO Teacher_Subject (Teacher_Id,Subject_Id) VALUES(@Teacher_Id,@Subject_Id)";
try
{
Connection.Open();
SqlCommand insertCommand = new SqlCommand(InsertCommand, Connection);
insertCommand.Parameters.AddWithValue("@Teacher_Id", teacher_Subject.Teacher_Id);
insertCommand.Parameters.AddWithValue("@Subject_Id", teacher_Subject.Subject_Id);
var result = insertCommand.ExecuteNonQuery();
if (result > 0)
{
return(Ok());
}
else
{
return(BadRequest());
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(BadRequest());
}
finally
{
Connection.Close();
}
}
}
public async Task <IActionResult> AssignTeacherSubject([FromBody] Teacher_Subject teacher_Subject)
{
if (teacher_Subject.id == 0)
{
_context.teacher_Subjects.Add(teacher_Subject);
_context.SaveChanges();
}
else
{
var d = _context.teacher_Subjects.FirstOrDefault(o => o.id == teacher_Subject.id);
d.teacher_Id = teacher_Subject.teacher_Id;
d.class_Id = teacher_Subject.class_Id;
d.section_Id = teacher_Subject.section_Id;
d.subject_Id = teacher_Subject.subject_Id;
d.class_section = teacher_Subject.class_section;
_context.Entry(d).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
}
return(new JsonResult("Data Saved "));
}
public ActionResult DeleteConfirmed(int id)
{
Teacher_Subject teacher_Subject = db.Teacher_Subject.Find(id);
db.Teacher_Subject.Remove(teacher_Subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id_teacher,id_subject")] Teacher_Subject teacher_Subject)
{
if (ModelState.IsValid)
{
db.Entry(teacher_Subject).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(teacher_Subject));
}
public ActionResult Create([Bind(Include = "id_teacher,id_subject")] Teacher_Subject teacher_Subject)
{
if (ModelState.IsValid)
{
db.Teacher_Subject.Add(teacher_Subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(teacher_Subject));
}
// GET: Teacher_Subject/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Teacher_Subject teacher_Subject = db.Teacher_Subject.Find(id);
if (teacher_Subject == null)
{
return(HttpNotFound());
}
return(View(teacher_Subject));
}
public ActionResult Create([Bind(Include = "id,name")] Subject subject, int teacher)
{
if (ModelState.IsValid)
{
db.Subject.Add(subject);
db.SaveChanges();
Teacher_Subject _Subject = new Teacher_Subject();
_Subject.id_subject = subject.id;
_Subject.id_teacher = teacher;
db.Teacher_Subject.Add(_Subject);
return(RedirectToAction("Index"));
}
return(View(subject));
}
