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);
}
