public ActionResult DeleteConfirmed(int id, audit_trail audit)
{
var check = db.training_course_instance.Where(s => s.Instructor_ID == id).FirstOrDefault();
if (check == null)
{
instructor instructor = db.instructors.Find(id);
var userId = System.Web.HttpContext.Current.Session["UserID"] as String;
int IntID = Convert.ToInt32(userId);
audit.Employee_ID = IntID;
audit.Trail_DateTime = DateTime.Now.Date;
audit.Deleted_Record = "Instructor ID" + instructor.Instructor_ID.ToString() + " " + instructor.Instructor_Name + " " + instructor.Instructor_Surname + " " + instructor.Instructor_Cellphone + " " + instructor.Instructor_Email + " Type ID: " + instructor.Instructor_Type_ID.ToString();
audit.Trail_Description = "Deleted a Instructor";
db.audit_trail.Add(audit);
db.instructors.Remove(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
instructor instructor = db.instructors.Find(id);
ViewBag.Error = "Can't delete a instructor that has given a training course, keep it as a record for historic purposes.";
return(View(instructor));
}
}
public int Remove(int id)
{
instructor i = ctx.instructor.FirstOrDefault(ins => ins.id == id);
ctx.instructor.Remove(i);
return(ctx.SaveChanges());
}
public async Task <IActionResult> Edit(string id, [Bind("instructor_code,confirm_date,contactor,contactor_detail,id,instructor_desc,ref_doc,x_log,x_note,x_status")] instructor instructor)
{
if (new Guid(id) != instructor.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(instructor);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!instructorExists(instructor.instructor_code))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public IHttpActionResult Putinstructor(int id, instructor instructor)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != instructor.id)
{
return(BadRequest());
}
db.Entry(instructor).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!instructorExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Login(student model)
{
if (ModelState.IsValid)
{
var Username = db.students.FirstOrDefault(x => x.username == model.username && x.password == model.password);
if (Username != null)
{
faculty faculty = db.faculties.SingleOrDefault(f => f.facultyID == Username.facultyID);
department department = db.departments.SingleOrDefault(d => d.departmentID == Username.departmentID);
instructor instructor = db.instructors.SingleOrDefault(d => d.instructorID == Username.instructorID);
Session["StudentName"] = Username.stufullname;
Session["StudentNumber"] = Username.number;
Session["StudentDep"] = department.depname;
Session["StudentFac"] = faculty.facultyname;
Session["studepid"] = Username.departmentID;
Session["studentid"] = Username.studentID;
Session["stufoto"] = Username.image;
Session["stuinst"] = instructor.instfullname;
Session["curriculum"] = department.curriculum;
Session["Username"] = Username;
ViewBag.curriculum = department.curriculum;
return RedirectToAction("Index", "Home");
}
else
{
ViewBag.Message = "Username or password wrong!!!";
}
}
return View(model);
}
public ActionResult Create([Bind(Include = "Instructor_ID,Instructor_Name,Instructor_Surname,Instructor_Email,Instructor_Cellphone,Employee_ID,Instructor_Type_ID,Title_ID,Gender_ID")] instructor instructor)
{
bool val = Validate(instructor.Instructor_Email);
if (ModelState.IsValid && val == false)
{
db.instructors.Add(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
ViewBag.StatusMessage = "There is already an instructor with email: " + instructor.Instructor_Email + " in the database.";
ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", instructor.Employee_ID);
ViewBag.Gender_ID = new SelectList(db.genders, "Gender_ID", "Gender1", instructor.Gender_ID);
ViewBag.Title_ID = new SelectList(db.titles, "Title_ID", "Title1", instructor.Title_ID);
ViewBag.Instructor_Type_ID = new SelectList(db.instructor_type, "Instructor_Type_ID", "Instructor_Type_Name", instructor.Instructor_Type_ID);
return(View());
}
ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", instructor.Employee_ID);
ViewBag.Gender_ID = new SelectList(db.genders, "Gender_ID", "Gender1", instructor.Gender_ID);
ViewBag.Title_ID = new SelectList(db.titles, "Title_ID", "Title1", instructor.Title_ID);
ViewBag.Instructor_Type_ID = new SelectList(db.instructor_type, "Instructor_Type_ID", "Instructor_Type_Name", instructor.Instructor_Type_ID);
return(View(instructor));
}
public void instructorLogin()
{
instructor instructor = new instructor(id);
teachingStaffMenu instructorMenu = new teachingStaffMenu(instructor);
Assert.IsTrue(instructor is instructor && instructorMenu is teachingStaffMenu);
}
public ActionResult DeleteConfirmed(int id)
{
instructor instructor = db.instructors.Find(id);
db.instructors.Remove(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void instructorLogoff()
{
instructor instructor = new instructor(id);
teachingStaffMenu instructorMenu = new teachingStaffMenu(instructor);
instructorMenu.Close();
Assert.IsNotNull(instructorMenu);
}
public static instructor getInstructorByID(int id)
{
using (MCenterDBContext db = new MCenterDBContext())
{
instructor instructor = db.instructors.Where(x => x.instructor_id == id).SingleOrDefault();
return(instructor);
}
}
public static void DeleteInstructor(int id)
{
MCenterDBContext db = new MCenterDBContext();
instructor deletedIns = getInstructorByID(id);
//delete from qualification instructor
//delete from phone instructor
DeletePhoneInstructor(id);
}
public static void UpdateInstructor(instructorQualificationPhoneViewModel instructorvm)
{
MCenterDBContext db = new MCenterDBContext();
instructor updataedInstructor = getInstructorByID(instructorvm.instructor_id);
updataedInstructor.instructor_name = instructorvm.instructor_name;
updataedInstructor.NameOf_ItsUnit = instructorvm.NameOf_ItsUnit;
updataedInstructor.TrainningTopic = instructorvm.TrainningTopic;
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "inst_id,inst_name,inst_charge,inst_speciality,inst_car,inst_gender")] instructor instructor)
{
if (ModelState.IsValid)
{
db.Entry(instructor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public ActionResult Edit([Bind(Include = "instructorID,instfullname,instmail,instroom,instofficehours,instusername,instpassword")] instructor instructor)
{
if (ModelState.IsValid)
{
db.Entry(instructor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public static void DeleteInstructor(int id)
{
using (MCenterDBContext db = new MCenterDBContext())
{
instructor deletedIns = getInstructorByID(id);
// db.instructors.Remove(deletedIns);
db.Entry(deletedIns).State = EntityState.Deleted;
db.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "instructorId,firstName,lastName,internship,pathPic")] instructor instructor)
{
if (ModelState.IsValid)
{
db.Entry(instructor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public ActionResult Edit([Bind(Include = "instructorID,firstName,lastName,officePhoneNumber,email")] instructor instructor)
{
if (ModelState.IsValid)
{
db.Entry(instructor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public ActionResult Create([Bind(Include = "instructorID,instfullname,instmail,instroom,instofficehours,instusername,instpassword")] instructor instructor)
{
if (ModelState.IsValid)
{
db.instructors.Add(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public ActionResult Create([Bind(Include = "instructorID,firstName,lastName,officePhoneNumber,email")] instructor instructor)
{
if (ModelState.IsValid)
{
db.Instructor.Add(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public async Task <IActionResult> Create([Bind("instructor_code,confirm_date,contactor,contactor_detail,id,instructor_desc,ref_doc,x_log,x_note,x_status")] instructor instructor)
{
if (ModelState.IsValid)
{
_context.Add(instructor);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public ActionResult Create([Bind(Include = "instructorId,firstName,lastName,internship,pathPic")] instructor instructor)
{
if (ModelState.IsValid)
{
db.instructors.Add(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public IHttpActionResult Getinstructor(int id)
{
instructor instructor = db.instructor.Find(id);
if (instructor == null)
{
return(NotFound());
}
return(Ok(instructor));
}
public ActionResult Create([Bind(Include = "inst_id,inst_name,inst_charge,inst_speciality,inst_car,inst_gender")] instructor instructor)
{
if (ModelState.IsValid)
{
db.instructors.Add(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(instructor));
}
public IHttpActionResult Postinstructor(instructor instructor)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.instructor.Add(instructor);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = instructor.id }, instructor));
}
public IHttpActionResult Deleteinstructor(int id)
{
instructor instructor = db.instructor.Find(id);
if (instructor == null)
{
return(NotFound());
}
db.instructor.Remove(instructor);
db.SaveChanges();
return(Ok(instructor));
}
static void Main(string[] args)
{
instructor john = new instructor("john", "English");
instructor mike = new instructor("john", "Math");
student jane = new student ("jane", 0, john );
student joe = new student("joe", 0, john);
student Melissa = new student("Melissa", 0, mike);
student Matt = new student("Matt", 0, mike);
john.SetStudentGrade(jane, 95);
john.SetStudentGrade(joe, 85);
mike.SetStudentGrade(Melissa, 90);
mike.SetStudentGrade(Matt, 92);
}
// GET: instructors/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
instructor instructor = db.instructors.Find(id);
if (instructor == null)
{
return(HttpNotFound());
}
return(View(instructor));
}
public ActionResult Edit(int id)
{
instructor instructor = InstructorBll.getInstructorByID(id);
instructorQualificationPhoneViewModel insvm = new instructorQualificationPhoneViewModel();
insvm.instructor_id = instructor.instructor_id;
insvm.instructor_name = instructor.instructor_name;
insvm.NameOf_ItsUnit = instructor.NameOf_ItsUnit;
insvm.TrainningTopic = instructor.TrainningTopic;
return(View(insvm));
}
//public ActionResult Edit(int? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// Course course = db.course.Find(id);
// if (course == null)
// {
// return HttpNotFound();
// }
// return View(course);
//}
public ActionResult edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
instructor instructor = db.instructor.Find(id);
if (instructor == null)
{
return(HttpNotFound());
}
return(View(instructor));
}
}
public static void UpdateInstructor(instructorVM instructorvm)
{
using (MCenterDBContext db = new MCenterDBContext())
{
instructor updataedInstructor = getInstructorByID(instructorvm.instructor_id);
updataedInstructor.instructor_name = instructorvm.instructor_name;
updataedInstructor.NameOf_ItsUnit = instructorvm.NameOf_ItsUnit;
updataedInstructor.TrainningTopic = instructorvm.TrainningTopic;
updataedInstructor.Current_JobTitle = instructorvm.Current_JobTitle;
updataedInstructor.Mobile = instructorvm.Mobile;
updataedInstructor.phone = instructorvm.phone;
updataedInstructor.Email = instructorvm.Email;
updataedInstructor.QualificationsName = instructorvm.QualificationsName;
db.Entry(updataedInstructor).State = EntityState.Modified;
db.SaveChanges();
}
}
// GET: instructors/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
instructor instructor = db.instructors.Find(id);
if (instructor == null)
{
return(HttpNotFound());
}
ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", instructor.Employee_ID);
ViewBag.Gender_ID = new SelectList(db.genders, "Gender_ID", "Gender1", instructor.Gender_ID);
ViewBag.Title_ID = new SelectList(db.titles, "Title_ID", "Title1", instructor.Title_ID);
ViewBag.Instructor_Type_ID = new SelectList(db.instructor_type, "Instructor_Type_ID", "Instructor_Type_Name", instructor.Instructor_Type_ID);
return(View(instructor));
}
public student(string studentName, int grade, instructor teacher)
{
this.studentName = studentName;
this.grade = grade;
this.teacher = teacher;
}
