public JsonResult GetSubject() { SUBJECT subject = new SUBJECT(); var results = subject.Select(); return(Json(results)); }
private void button4_Click(object sender, EventArgs e) { SUBJECT s = new SUBJECT(); this.Hide(); s.ShowDialog(); }
private void GetAndDisplaySubjects() { ListSubjects.Clear(); SqlConnection con = GeneralMethods.ConnectToDatabase(); SqlDataAdapter sda2 = new SqlDataAdapter("SELECT * From [SUBJECT] WHERE SemID='" + ViewModelLocator.SemesterSelectViewModel.SelectedSemester.SemID + "'", con); DataTable dt = new DataTable(); sda2.Fill(dt); con.Close(); for (int x = 0; x < dt.Rows.Count; x++) { SUBJECT newSubject = new SUBJECT(); newSubject.Description = dt.Rows[x]["Description"].ToString(); newSubject.PrelimPercent = Convert.ToDouble(dt.Rows[x]["PrelimPercent"]); newSubject.MidtermPercent = Convert.ToDouble(dt.Rows[x]["MidtermPercent"]); newSubject.PrefiPercent = Convert.ToDouble(dt.Rows[x]["PrefiPercent"]); newSubject.Schedule = dt.Rows[x]["Schedule"].ToString(); newSubject.Units = Convert.ToInt16(dt.Rows[x]["Units"]); newSubject.SubjectCode = dt.Rows[x]["Subject_Code"].ToString(); newSubject.SubjectID = Convert.ToInt16(dt.Rows[x]["Subject_ID"]); newSubject.SemID = Convert.ToInt16(dt.Rows[x]["SemID"]); newSubject.Base = Convert.ToDouble(dt.Rows[x]["Base"]); ListSubjects.Add(newSubject); } UsedUnits = ComputeMaxUnits(); MaxUnits = ViewModelLocator.SemesterSelectViewModel.SelectedSemester.MaxUnits; }
private void pictureBox6_Click(object sender, EventArgs e) { SUBJECT s = new SUBJECT(); this.Hide(); s.ShowDialog(); }
public ActionResult DeleteConfirmed(string id) { SUBJECT sUBJECT = db.SUBJECTs.Find(id); db.SUBJECTs.Remove(sUBJECT); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult InsertSubject(SubjectViewModel ViewModel) { checkLogin(); ModelState.Clear(); ViewModel.TermList = CP.termSelectList; ViewModel.SubjectList = Session["subjectSelectList"] != null ? (SelectList)Session["subjectSelectList"] : SubjectService.GetSelectList(ViewModel.SelectedTerm); foreach (var key in ModelState.Keys) { if (!key.Contains("NewSubject")) { ModelState[key].Errors.Clear(); // only need to check new subject fields } } if (!ModelState.IsValid) { return(View("Subject", ViewModel)); } ViewModel.NewSubject.ADD_BY = CP.userID; ViewModel.NewSubject.ADD_DATE = DateTime.Now; ViewModel.NewSubject.ACTIVE = true; if (ViewModel.SelectedSubject == 0) { SUBJECT subject = SubjectService.SubjectAdapter(ViewModel.NewSubject); // convert ssubject to subject type subject.TERM = ViewModel.SelectedTerm; subject.ID = GS.getNewID(); SubjectAndSSubjects sAndss = new SubjectAndSSubjects(); sAndss.MainSubject = subject; ViewModel.SubjectAndSSubjects.Add(sAndss); } else { ViewModel.NewSubject.ID = GS.getNewID(); ViewModel.NewSubject.SUBJECT = ViewModel.SelectedSubject; ViewModel.SubjectAndSSubjects.FindAll(s => s.MainSubject.ID == ViewModel.SelectedSubject).FirstOrDefault().SSubjects.Add(ViewModel.NewSubject); int totalMark = 0; ViewModel.SubjectAndSSubjects.FindAll(s => s.MainSubject.ID == ViewModel.SelectedSubject).FirstOrDefault().SSubjects.ForEach(s => totalMark += s.FULL_MARK); ViewModel.SubjectAndSSubjects.FindAll(s => s.MainSubject.ID == ViewModel.SelectedSubject).FirstOrDefault().MainSubject.FULL_MARK = totalMark; } //update params and list after changes ViewModel.SubjectList = SubjectService.GetSelectList(ViewModel.SubjectAndSSubjects); Session["subjectSelectList"] = ViewModel.SubjectList; ViewModel.NewSubject = new SSUBJECT(); ModelState.Clear(); TempData["showForm"] = true; return(View("Subject", ViewModel)); }
public ActionResult Edit([Bind(Include = "SubjectID,SubjectName")] SUBJECT sUBJECT) { if (ModelState.IsValid) { db.Entry(sUBJECT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sUBJECT)); }
public bool update(SUBJECT subject) { var model = db.SUBJECTs.Find(subject.ID); model.NAME = subject.NAME; model.DESCRIPTION = subject.DESCRIPTION; model.FACULTY_ID = subject.FACULTY_ID; db.SaveChanges(); return(true); }
public JsonResult Save(SUBJECT subjects) { bool status = false; string message = string.Empty; int sub = new SubjectsDAO().CheckSubjects(subjects.NAME); if (subjects.ID != "0") { try { var model = new SubjectsDAO().update(subjects); status = true; } catch (Exception ex) { status = false; message = ex.Message; } } else { try { if (sub == 0) { subjects.ID = createID("SUBJ"); db.SUBJECTs.Add(subjects); db.SaveChanges(); status = true; } else { status = false; } } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } } return(Json(new { status = status, message = message })); }
public ActionResult Create([Bind(Include = "SubjectID,SubjectName")] SUBJECT sUBJECT) { if (ModelState.IsValid) { db.SUBJECTs.Add(sUBJECT); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sUBJECT)); }
public ActionResult Edit([Bind(Include = "Subject_ID,SubjectName,Class_ID,Teacher_ID,Admin_ID")] SUBJECT sUBJECT) { if (ModelState.IsValid) { db.Entry(sUBJECT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Admin_ID = new SelectList(db.ADMINs, "Admin_ID", "AdminName", sUBJECT.Admin_ID); ViewBag.Class_ID = new SelectList(db.CLASSes, "Class_ID", "ClassName", sUBJECT.Class_ID); ViewBag.Teacher_ID = new SelectList(db.TEACHERs, "Teacher_ID", "TeacherName", sUBJECT.Teacher_ID); return(View(sUBJECT)); }
// GET: SUBJECTs/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SUBJECT sUBJECT = db.SUBJECTs.Find(id); if (sUBJECT == null) { return(HttpNotFound()); } return(View(sUBJECT)); }
public static SUBJECT SubjectAdapter(SSUBJECT ss) { SUBJECT s = new SUBJECT(); s.EDB_CODE = ss.EDB_CODE; s.NAME = ss.NAME; s.NAME_CHI = ss.NAME_CHI; s.FULL_MARK = ss.FULL_MARK; s.ADD_BY = ss.ADD_BY; s.ADD_DATE = ss.ADD_DATE; s.MODIFY_BY = ss.MODIFY_BY; s.MODIFY_DATE = ss.MODIFY_DATE; s.ACTIVE = ss.ACTIVE; return(s); }
public void EditSubject(SUBJECT changedSubject) { SqlConnection con = GeneralMethods.ConnectToDatabase(); SqlCommand command = new SqlCommand("UPDATE [SUBJECT] SET Subject_Code=@Subject_Code, Description=@Description, Schedule=@Schedule, Units=@Units, Base=@Base WHERE Subject_ID=@Subject_ID", con); command.Parameters.AddWithValue("@Subject_Code", changedSubject.SubjectCode); command.Parameters.AddWithValue("@Description", changedSubject.Description); command.Parameters.AddWithValue("@Schedule", changedSubject.Schedule); command.Parameters.AddWithValue("@Units", changedSubject.Units); command.Parameters.AddWithValue("@Base", changedSubject.Base); command.Parameters.AddWithValue("@Subject_ID", ViewModelLocator.SubjectsListViewModel.SelectedSubject.SubjectID); command.ExecuteNonQuery(); con.Close(); GetAndDisplaySubjects(); }
// GET: SUBJECTs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SUBJECT sUBJECT = db.SUBJECTs.Find(id); if (sUBJECT == null) { return(HttpNotFound()); } ViewBag.Admin_ID = new SelectList(db.ADMINs, "Admin_ID", "AdminName", sUBJECT.Admin_ID); ViewBag.Class_ID = new SelectList(db.CLASSes, "Class_ID", "ClassName", sUBJECT.Class_ID); ViewBag.Teacher_ID = new SelectList(db.TEACHERs, "Teacher_ID", "TeacherName", sUBJECT.Teacher_ID); return(View(sUBJECT)); }
private void BtnAddClass_Click(object sender, RoutedEventArgs e) { var window = new AddSubjectWindow(); window.Owner = this; window.WindowStartupLocation = WindowStartupLocation.CenterOwner; SUBJECT newSubject = new SUBJECT(); window.DataContext = newSubject; var result = window.ShowDialog(); if (result == true) { ViewModelLocator.SubjectsListViewModel.AddNewSubject(newSubject); } }
public ActionResult Create([Bind(Include = "Subject_ID,SubjectName,Class_ID,Teacher_ID,Admin_ID")] SUBJECT sUBJECT) { if (ModelState.IsValid) { db.SUBJECTs.Add(sUBJECT); db.SaveChanges(); // return RedirectToAction("Index"); } ViewBag.Admin_ID = new SelectList(db.ADMINs, "Admin_ID", "AdminName", sUBJECT.Admin_ID); ViewBag.Class_ID = new SelectList(db.CLASSes, "Class_ID", "ClassName", sUBJECT.Class_ID); ViewBag.Teacher_ID = new SelectList(db.TEACHERs, "Teacher_ID", "TeacherName", sUBJECT.Teacher_ID); ModelState.Clear(); ViewBag.Message = "successfully created"; return(View()); // return View(sUBJECT); }
private void BtnEditClass_Click(object sender, RoutedEventArgs e) { var window = new AddSubjectWindow(); window.Owner = this; window.WindowStartupLocation = WindowStartupLocation.CenterOwner; SUBJECT changedSubject = ViewModelLocator.SubjectsListViewModel.SelectedSubject as SUBJECT; window.DataContext = changedSubject; var result = window.ShowDialog(); if (result == true) { ViewModelLocator.SubjectsListViewModel.EditSubject(changedSubject); } }
public void AddNewSubject(SUBJECT newSubject) { SqlConnection con = GeneralMethods.ConnectToDatabase(); SqlCommand command = new SqlCommand("INSERT INTO [SUBJECT] (Subject_Code, Description, Schedule, Units, SemID, PrelimPercent, MidtermPercent, PrefiPercent, Base, Grade, PrelimLetterGrade, MidtermLetterGrade, PrefiLetterGrade) VALUES (@Subject_Code, @Description, @Schedule, @Units, @SemID, @PrelimPercent, @MidtermPercent, @PrefiPercent, @Base, @Grade, @PrelimLetterGrade, @MidtermLetterGrade, @PrefiLetterGrade)", con); command.Parameters.AddWithValue("@Subject_Code", newSubject.SubjectCode); command.Parameters.AddWithValue("@Description", newSubject.Description); command.Parameters.AddWithValue("@Schedule", newSubject.Schedule); command.Parameters.AddWithValue("@Units", newSubject.Units); command.Parameters.AddWithValue("@SemID", ViewModelLocator.SemesterSelectViewModel.SelectedSemester.SemID); command.Parameters.AddWithValue("@PrelimPercent", 0); command.Parameters.AddWithValue("@MidtermPercent", 0); command.Parameters.AddWithValue("@PrefiPercent", 0); command.Parameters.AddWithValue("@Grade", 0); command.Parameters.AddWithValue("@PrelimLetterGrade", "-"); command.Parameters.AddWithValue("@MidtermLetterGrade", "-"); command.Parameters.AddWithValue("@PrefiLetterGrade", "-"); command.Parameters.AddWithValue("@Base", newSubject.Base); command.ExecuteNonQuery(); con.Close(); GetAndDisplaySubjects(); }
public ActionResult InsertSubject(List <string> Subjects) { Subjects = Subjects.Where(s => !string.IsNullOrWhiteSpace(s)).ToList(); SUBJECT sbj = new SUBJECT(); var result = 0; foreach (var subject in Subjects) { if (!string.IsNullOrWhiteSpace(subject)) { result = sbj.Insert(subject); } } if (result > 0) { TempData["return"] = "Insert subject successfully"; } else { TempData["return"] = "Insert subject fail"; } return(RedirectToAction("Index", "Manage")); }
public IHttpActionResult Put(MarkTotalViewModel mt) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new EMSEntities()) { try { var existingMarkTotal = ctx.MARKTOTALs.Where(s => s.TRNNO == mt.TRNNO) .FirstOrDefault <MARKTOTAL>(); if (existingMarkTotal != null) { existingMarkTotal.CLASS_TRNNO = mt.CLASS_TRNNO; existingMarkTotal.EXAM_TRNNO = mt.EXAM_TRNNO; existingMarkTotal.GRPMST_TRNNO = mt.GRPMST_TRNNO; existingMarkTotal.MDT = mt.MDT; foreach (var dtl in mt.MARKTOTALDTLs) { var mkdetail = new MARKTOTALDTL { TRNNO = dtl.MKTOTAL_TRNNO, SR = dtl.SR, SUBJECT_TRNNO = dtl.TRNNO, TOTMARKS = dtl.TOTMARKS }; var subject = new SUBJECT { TRNNO = dtl.TRNNO, SNAME = dtl.SNAME, SCODE = dtl.SCODE }; ctx.Entry(mkdetail).State = System.Data.Entity.EntityState.Modified; ctx.Entry(subject).State = System.Data.Entity.EntityState.Modified; //ctx.MARKTOTALDTLs.Add(mkdetail); //ctx.SUBJECTs.Add(subject); } ctx.SaveChanges(); } else { return(NotFound()); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } return(Ok()); }
public void GetAndDisplayGrades() { ListSubjects.Clear(); SqlConnection con = GeneralMethods.ConnectToDatabase(); SqlDataAdapter sda2 = new SqlDataAdapter("SELECT * From [SUBJECT] WHERE SemID='" + ViewModelLocator.SemesterSelectViewModel.SelectedSemester.SemID + "'", con); DataTable dt = new DataTable(); sda2.Fill(dt); con.Close(); for (int x = 0; x < dt.Rows.Count; x++) { SUBJECT newSubject = new SUBJECT(); newSubject.Description = dt.Rows[x]["Description"].ToString(); newSubject.Grade = Convert.ToDouble(dt.Rows[x]["Grade"]); newSubject.PrelimLetterGrade = dt.Rows[x]["PrelimLetterGrade"].ToString(); newSubject.MidtermLetterGrade = dt.Rows[x]["MidtermLetterGrade"].ToString(); newSubject.PrefiLetterGrade = dt.Rows[x]["PrefiLetterGrade"].ToString(); newSubject.Units = Convert.ToInt16(dt.Rows[x]["Units"]); if (newSubject.Grade <= 71.49) { newSubject.FinalLetterGrade = "F"; } else if (newSubject.Grade > 71.49 && newSubject.Grade <= 75.49) { newSubject.FinalLetterGrade = "D"; } else if (newSubject.Grade > 75.49 && newSubject.Grade <= 79.49) { newSubject.FinalLetterGrade = "C"; } else if (newSubject.Grade > 79.49 && newSubject.Grade <= 83.49) { newSubject.FinalLetterGrade = "C+"; } else if (newSubject.Grade > 83.49 && newSubject.Grade <= 87.49) { newSubject.FinalLetterGrade = "B"; } else if (newSubject.Grade > 87.49 && newSubject.Grade <= 91.49) { newSubject.FinalLetterGrade = "B+"; } else if (newSubject.Grade > 91.49) { newSubject.FinalLetterGrade = "A"; } ListSubjects.Add(newSubject); } ComputeQPI(); }
public bool add(SUBJECT subject) { db.SUBJECTs.Add(subject); db.SaveChanges(); return(true); }