//Возвращает распарсенный список организаций
public List<SubjectDetail> GetDetailSubjects(string filePatch)
{
var detailedSubjectList = new List<SubjectDetail>();
var table = GetTable(filePatch);
foreach (DataRow row in table.Rows)
{
var data = row.ItemArray[0].ToString();
var splitterIndex = data.IndexOf('_');
var lenght = data.Length;
var subjectNumber = data.Substring(0, splitterIndex);
var classNumber = "";
var classDetail = "";
if (splitterIndex != lenght-1)
{
var classString = data.Substring(splitterIndex + 1, lenght - splitterIndex);
var codeLenght = classString.Length;
classNumber = classString.Remove(codeLenght - 2, 1);
classDetail = classString.Remove(0, codeLenght - 1);
}
var newDetailedSubject = new SubjectDetail
{
SubjectNumber = subjectNumber,
ClassNumber = classNumber,
ClassDetail = classDetail
};
if (!detailedSubjectList.Contains(newDetailedSubject))
{
detailedSubjectList.Add(newDetailedSubject);
}
}
return detailedSubjectList;
}
public ActionResult CreateNew([Bind(Include = "ID,ID_Subject,SubjectName,Contents,Description,ID_Teacher,DateBegin,isActive,IDSubjectType")] Subject subject)
{
if (subject.ID_Teacher != 0 && subject.SubjectName != null)
{
if (!IsSubjectNameinSubject(subject.SubjectName) && !IsSubjectNameinTSubject(subject.SubjectName))
{
String ID_Student = GetCurrentStudent().MSSV;
subject.DateBegin = month + "/" + day + "/" + year;
subject.ID_Subject = "DTTC";
subject.isActive = true;
subject.IDSubjectType = 1;
if (ModelState.IsValid)
{
db.Subjects.Add(subject);
db.SaveChanges();
subject.ID_Subject += string.Format("{0:0000}", subject.ID);
db.SaveChanges();
}
}
SubjectDetail Detail = new SubjectDetail();
Detail.ID_Subject = db.Subjects.FirstOrDefault(s => s.ID_Subject == subject.ID_Subject).ID;
Detail.ID_Student = db.Students.FirstOrDefault(student => student.ID_Account == CurrentUser.ID).ID;
Detail.PrecentComplete = 0;
Student CurrentStudent = GetCurrentStudent();
CurrentStudent.ID_Subject = subject.ID;
if (ModelState.IsValid)
{
db.SubjectDetails.Add(Detail);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(RedirectToAction("CreateNew"));
}
public IActionResult UpdateInactiveSubject([FromBody] SubjectDetail request)
{
var inActiveSubject = repoQ.GetInActiveSubject(request.id);
repoQ.UpdateSubjectCodeAndNameAndContentLanguage(request.id, request.SubjectCode, request.SubjectName, request.ContentLanguage);
return(Ok(new { Message = $"Updated!", SubjectId = request.id }));
}
public ActionResult CreateExist([Bind(Include = "ID,ID_Subject,SubjectName,Contents,Description,ID_Teacher,DateBegin,isActive,IDSubjectType")] Subject subject)
{
if (subject.ID_Subject != null)
{
Subject findsubject = db.Subjects.FirstOrDefault(s => s.ID_Subject == subject.ID_Subject);
SubjectDetail Detail = new SubjectDetail();
Student CurrentStudent = db.Students.FirstOrDefault(s => s.ID_Account == CurrentUser.ID);
T_Subject TSubject = db.T_Subject.FirstOrDefault(s => s.ID_Subject == subject.ID_Subject);
if (SubjectAvaiable(findsubject)) /* Tạo mới subject nếu nó đã bị xóa */
{
subject.SubjectName = TSubject.T_SubjectName;
subject.DateBegin = month + "/" + day + "/" + year;
subject.ID_Teacher = int.Parse(TSubject.ID_Teacher.ToString());
subject.IDSubjectType = 1;
subject.isActive = true;
TSubject.isActive = false;
if (ModelState.IsValid)
{
db.Subjects.Add(subject);
db.SaveChanges();
CurrentStudent.ID_Subject = subject.ID;
db.SaveChanges();
}
Detail.ID_Student = CurrentStudent.ID;
Detail.ID_Subject = subject.ID;
Detail.PrecentComplete = 0;
if (ModelState.IsValid)
{
db.SubjectDetails.Add(Detail);
db.SaveChanges();
}
}
else if (findsubject.isSubmit != true) /* Nếu đề tài đã được người khác đăng ký nhưng chưa submit thì có thể đăng ký chung nhóm */
{
Detail.ID_Subject = findsubject.ID;
Detail.ID_Student = CurrentStudent.ID;
Detail.PrecentComplete = 0;
CurrentStudent.ID_Subject = subject.ID;
if (ModelState.IsValid)
{
db.SubjectDetails.Add(Detail);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
return(RedirectToAction("CreateExist"));
}
public ActionResult CreateTimetable(Project.Models.Timetable timetable)
{
try
{
using (DBmodel tution = new DBmodel())
{
ViewBag.IsError = false;
try
{
if (ModelState.IsValid)
{
SubjectDetail subject = new SubjectDetail();
var subje = tution.SubjectTBs.Where(m => m.SubjectName == timetable.Subject).Select(u => new { sub = u.SubjectCode }).Single();
tution.Timetables.Add(timetable);
tution.SaveChanges();
subject.Hall = timetable.Hall;
subject.StartTime = timetable.StartTime;
subject.EndTime = timetable.EndTime;
subject.Day = timetable.Day;
subject.SubjectID = subje.sub;
tution.SubjectDetails.Add(subject);
tution.SaveChanges();
return(RedirectToAction("TimetableList"));
}
}
catch
{
}
}
}
catch
{
DBmodel db = new DBmodel();
List <TeacherList> list = db.TeacherLists.ToList();
List <GradeList> grades = db.GradeLists.ToList();
List <subject> subjects = db.subjects.ToList();
ViewBag.teacherlist = new SelectList(list, "teacher_name", "teacher_name");
ViewBag.Grades = new SelectList(grades, "Grade", "Grade");
ViewBag.Subjects = new SelectList(subjects, "subject1", "subject1");
return(View());
}
return(RedirectToAction("TimetableList"));
}
public CFIDetailDialog(object selectedItem)
{
this.InitializeComponent();
detail = selectedItem as SubjectDetail;
binding(richEBCRN, detail.CRN);
binding(richEBSubjectCode, detail.SubjectCode);
binding(richEBCompetencyName, detail.CompetencyName);
binding(richEBStartDate, detail.StartDate);
binding(richEBEndDate, detail.EndDate);
binding(richEBDayOfWeek, detail.DayOfWeek);
binding(richEBTime, detail.Time);
binding(richEBRoom, detail.Room);
binding(richEBLecturer, detail.Lecturer);
binding(richEBCampus, detail.Campus);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
SubjectDetail = await _context.subjectDetails
.Include(s => s.Subject).FirstOrDefaultAsync(m => m.SubjectDetailId == id);
if (SubjectDetail == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
SubjectDetail = await _context.subjectDetails.FindAsync(id);
if (SubjectDetail != null)
{
_context.subjectDetails.Remove(SubjectDetail);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
SubjectDetail = await _context.subjectDetails
.Include(s => s.Subject).FirstOrDefaultAsync(m => m.SubjectDetailId == id);
if (SubjectDetail == null)
{
return(NotFound());
}
ViewData["SubjectId"] = new SelectList(_context.subjects, "SubjectId", "Title");
return(Page());
}
public ActionResult Delete(int?id)
{
if (id != null)
{
Subject CurrentSubject = db.Subjects.Find(id);
if (CanDelete(CurrentSubject))
{
Student student = GetCurrentStudent();
student.ID_Subject = null;
SubjectDetail Detail = db.SubjectDetails.FirstOrDefault(detail => detail.ID_Student == student.ID && detail.ID_Subject == CurrentSubject.ID);
db.SubjectDetails.Remove(Detail);
if (!IsCurSubjectInStuList(CurrentSubject.ID))
{
CurrentSubject.isDelete = true;
}
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id, SubjectTB subject)
{
try
{
using (DBmodel DBmodel = new DBmodel())
{
subject model_subject = DBmodel.subjects.Find(id);
teacher_grade model_grade = DBmodel.teacher_grade.Find(id);
teacher_subject model_teacher = DBmodel.teacher_subject.Find(id);
SubjectDetail subDetail = new SubjectDetail();
subject = DBmodel.SubjectTBs.Where(x => x.SubjectCode == id).FirstOrDefault();
if (DBmodel.SubjectDetails.Any(x => x.SubjectID == id))
{
subDetail = DBmodel.SubjectDetails.Where(x => x.SubjectID == id).FirstOrDefault();
DBmodel.SubjectDetails.Remove(subDetail);
}
DBmodel.SubjectTBs.Remove(subject);
DBmodel.SaveChanges();
string grade = model_grade.grade;
int grade2 = model_grade.grade_id;
int grade3 = model_grade.subjectCode;
int grade4 = model_grade.teacher_id;
DBmodel.teacher_grade.Remove(model_grade);
// DBmodel.subjects.Remove(model_subject);
// DBmodel.teacher_subject.Remove(model_teacher);
DBmodel.SaveChanges();
}
return(RedirectToAction("SubjectList"));
}
catch
{
return(View());
}
}
public IActionResult CreateInactiveSubject([FromBody] SubjectDetail examSuite)
{
//var subjectId = $"{examSuite.SubjectCode}{examSuite.ContentLanguage}";
var subjectId = Guid.NewGuid().ToString();
var newSubject = new ViewModels.ExamBankModelsBack.InActiveSubject.InactiveSubject
{
_id = subjectId,
SubjectCode = examSuite.SubjectCode,
SubjectName = examSuite.SubjectName,
CreateDateTime = DateTime.Now,
IsEReadiness = false, //Hack
ContentLanguage = examSuite.ContentLanguage,
SiteId = HomeController._centerdata.SiteId,
QuestionCount = 0,
ExamSuiteCount = 0,
ExamSuiteAcceptCount = 0,
ExamSuiteRejectCount = 0,
};
repoQ.InsertInActiveSubject(newSubject);
return(Ok(new { Message = $"Created!", SubjectId = subjectId }));
}