/// <summary>
/// 新增課程大綱
/// </summary>
/// <param name="circleKey"></param>
/// <param name="name"></param>
/// <param name="note"></param>
/// <param name="syllDate"></param>
/// <param name="sort"></param>
/// <param name="creator"></param>
/// <returns></returns>
public Syllabus InsertSyllabus(string circleKey, string name, string note, string syllDate, int creator)
{
try
{
var db = _uow.DbContext;
var entity = new Syllabus()
{
Name = name,
Enable = true,
Visibility = true,
Created = TimeData.Create(DateTime.UtcNow),
Course_No = circleKey,
CreateUser = creator,
Deleted = TimeData.Create(null),
Updated = TimeData.Create(null),
Note = note,
Syll_Date = Convert.ToDateTime(syllDate).ToUniversalTime(),
Syll_Guid = Guid.NewGuid()
};
db.Syllabus.Add(entity);
db.SaveChanges();
return(entity);
}
catch (Exception ex)
{
return(null);
throw;
}
}
public ActionResult EditSyllabus(Syllabus sylla)
{
if (!ModelState.IsValid)
{
int CurrentAccID = (User as Principal.AuthorizePrincipal).ID;
var Subjects = BUSSubject.GetSubjectByAccountEditor(CurrentAccID)
.Select(s => new
{
ID = s.ID,
Name = s.Name + "(" + s.Faculty.VietNameseName + ")"
}
).ToList();
var Classrooms = BUSClassroom.GetClassroomsExeceptClassOffice()
.Select(s => new
{
ID = s.ID,
Name = s.Name + " (" + s.Facility.Name + ")" + " (" + s.Facility.Address + ")"
}
).ToList();
ViewBag.Subjects = new SelectList(Subjects, "ID", "Name");
ViewBag.Classrooms = new SelectList(Classrooms, "ID", "Name");
return(View(sylla));
}
BUSSyllabus.EditSyllabus(sylla);
return(RedirectToAction("SyllabusesList"));
}
public ActionResult Edit(int id)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
Syllabuses syllabus = new Cateloge().SelectSyllabus(id);
if (syllabus == null)
{
ViewBag.StatusMessage = " No Any Result Founded ! ";
}
else
{
Syllabus Formelements = new Syllabus
{
Name_of_lvl = syllabus.Name_of_lvl,
Detail_of_syllabus = syllabus.Detail_of_syllabus
};
return(PartialView("_CreateNewSyllabus", Formelements));
}
return(RedirectToAction("Index"));
}
}
public bool AddSysllabus(string idprogram, string sysname, string syscode, int type, string idac, int sem, int TC, int LT, string precourse, string content)
{
try
{
Syllabus sys = new Syllabus();
sys.id = CreateID();
sys.name = sysname;
sys.idProgram = idprogram;
sys.CourseCode = syscode;
sys.CourseType = type;
sys.idAccount = idac;
sys.CourseSemester = sem;
sys.CoursePoint = TC;
sys.CourseLT = LT;
sys.PreCourse = precourse;
sys.isLockEdit = false;
sys.CourseContent = content;
db.Syllabus.InsertOnSubmit(sys);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
static void Main(string[] args)
{
// This part is just to see that this code is wworking or not
Syllabus s = new Syllabus("http://dm.ieu.edu.tr/tr/syllabus/type/read/id/CE+223");
s.writenode();
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Semester")] Syllabus syllabus)
{
if (id != syllabus.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(syllabus);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SyllabusExists(syllabus.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(syllabus));
}
public void DeleteClassworkAndGradeTest()
{
string name = "className";
string instructor = "class instructor";
int creditHours = 3;
Uri email = new Uri("mailto:[email protected]");
Uri website = new Uri("https://www.sc.edu");
Syllabus syllabus = null;
int classType = 1;
string notes = "These are some notes for the class";
ObservableCollection <MeetingTime> meetingTimes = new ObservableCollection <USurvive.MeetingTime>();
GradeScale gradeScale = null; //We don't use this
Class tempClass = new Class(name, instructor, creditHours, email, website, syllabus, classType, notes, meetingTimes, gradeScale);
string cl = tempClass.Name;
Globals.cwList = new ClassworkList();
Globals.gradebook = new GradeList();
Globals.clList = new ClassList();
Globals.clList.AddClass(tempClass);
Grade tempGrade = new Grade(cl, dueDate);
Classwork tempClasswork = new Classwork(
name, cl, dueDate, priority, tempGrade.gradeID, (bool)autoInc, autoIncDays, type, notifTime);
Globals.gradebook.AddGrade(tempGrade);
Globals.cwList.AddClasswork(tempClasswork);
Assert.IsTrue(Globals.gradebook.grades.Contains(tempGrade));
Assert.IsTrue(Globals.cwList.classwork.Contains(tempClasswork));
Globals.cwList.DeleteClasswork(tempClasswork);
Assert.IsFalse(Globals.gradebook.grades.Contains(tempGrade));
Assert.IsFalse(Globals.cwList.classwork.Contains(tempClasswork));
}
public void AcceptTest(SyllabusManagerUser user, Syllabus input, Syllabus output, bool expectedResult)
{
// Arrange
var dbSetMock = new Mock <DbSet <Syllabus> >();
dbSetMock
.Setup(r => r.Find(input.Id))
.Returns(input);
var syllabusService = new SyllabusService(SyllabusTestRepository.GetInMemorySyllabusContext(), null, dbSetMock.Object);
// Act
var result = syllabusService.Accept(input.Id, user);
// Assert
Assert.Equal(expectedResult, result);
Assert.Equal(output.StudentGovernmentOpinion, input.StudentGovernmentOpinion);
Assert.Equal(output.State, input.State);
Assert.Equal(output.StudentRepresentativeName, input.StudentRepresentativeName);
if (output.ApprovalDate is null)
{
Assert.Null(input.ApprovalDate);
}
else
{
Assert.NotNull(input.ApprovalDate);
}
if (output.ValidFrom is null)
{
Assert.Null(input.ValidFrom);
}
else
{
Assert.NotNull(input.ValidFrom);
}
}
public async Task <IActionResult> Edit(int id, [Bind("SyllabusId,Level,DanceId")] Syllabus syllabus)
{
if (id != syllabus.SyllabusId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(syllabus);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SyllabusExists(syllabus.SyllabusId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DanceId"] = new SelectList(_context.Dance, "DanceId", "DanceId", syllabus.DanceId);
return(View(syllabus));
}
public ActionResult Index(string Search_key)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
if (!string.IsNullOrEmpty(Search_key))
{
List <Syllabuses> Searched = new Cateloge().SearchSyllabuses(Search_key);
if (Searched == null)
{
ViewBag.StatusMessage = " No Any Data Found ! ";
}
else
{
AllClasses Data = new AllClasses();
Data.Syllabus_s = new List <Syllabus>();
foreach (var gdfc in Searched)
{
Syllabus dbr = new Syllabus();
dbr.Id = gdfc.db_Id;
dbr.Name_of_lvl = gdfc.Name_of_lvl;
dbr.Detail_of_syllabus = gdfc.Detail_of_syllabus;
Data.Syllabus_s.Add(dbr);
}
Data.Syllabus_s.TrimExcess();
return(View(Data));
}
}
else
{
List <Syllabuses> syllabuses = new Cateloge().Syllabuses();
if (syllabuses == null)
{
ViewBag.StatusMessage = " No Any Data Found ! ";
}
else
{
AllClasses Data = new AllClasses();
Data.Syllabus_s = new List <Syllabus>();
foreach (var gdfc in syllabuses)
{
Syllabus dbr = new Syllabus();
dbr.Id = gdfc.db_Id;
dbr.Name_of_lvl = gdfc.Name_of_lvl;
dbr.Detail_of_syllabus = gdfc.Detail_of_syllabus;
Data.Syllabus_s.Add(dbr);
}
Data.Syllabus_s.TrimExcess();
return(View(Data));
}
}
return(View());
}
}
public ActionResult ExportToWord(int ID)
{
Syllabus sylla = BUSSyllabus.GetSyllabusByID(ID);
ViewBag.WordDocumentFilename = sylla.VietnameseName;
return(View("ReviewSyllabus", sylla));
}
/// <summary>
/// 更新Syllabus
/// </summary>
/// <param name="Syllabus">Syllabus</param>
public int UpdateSyllabus(Syllabus syllabus)
{
LogHelper.Info("SyllabusUrl" + syllabus.SyllabusUrl + "");
int i = ExecuteUpdate("JNyulu.UpdateSyllabus", syllabus);
return(i);
}
public ActionResult DeleteConfirmed(int id)
{
Syllabus syllabus = db.Syllabi.Find(id);
syllabus.isActive = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Syllabus syllabus = await db.Syllabi.FindAsync(id);
db.Syllabi.Remove(syllabus);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void Create(Syllabus syllabus, Dictionary <LearningOutcomeCategory, int> lods)
{
using (Document doc = PdfHelper.Document(true))
{
var fieldOfStudy = syllabus.FieldOfStudy;
var description = syllabus.Description;
var subjectDescriptions = syllabus.SubjectDescriptions;
#region setup i nagłówek
syllabusTitle(doc);
doc.SetFontSize(12);
#endregion
#region dane podstawowe
PdfStructures.fieldOfStudyInfo(doc, fieldOfStudy);
#endregion
#region tableka opis programu studiów
generalDescription(doc, description);
#endregion
#region opis szczegółowy
wku(lods, doc, fieldOfStudy);
disciplineEcts50(syllabus.SubjectDescriptions, doc);
accordanceToJobMarket(doc);
directContact(syllabus.SubjectDescriptions, doc);
basicScienceTotallEcts(syllabus.SubjectDescriptions, doc);
generalModulesMinimalEcts(syllabus.PointLimits, doc);
electiveSubjectsTotalEcts(doc, subjectDescriptions);
learningOutcomeProcess(doc);
#endregion
#region lista modułów - tabele z przedmiotami
modulesTable(doc, subjectDescriptions);
#endregion
#region blok praktyk i pracy dyplomowej
// blok praktyk
internAndThesis(syllabus.IntershipType, syllabus.ThesisCourse, doc);
#endregion
#region sposoby weryfikacji
formOfCreditTable(doc);
#endregion
#region zakres egzaminu
examScope(syllabus.ScopeOfDiplomaExam, doc);
#endregion
#region tabela z semestrami do kiedy zaliczyc
semesterCompletitionTable(doc, subjectDescriptions);
#endregion
}
PdfHelper.AddPages();
}
public void AddSyllabus(Syllabus Sylla)
{
pbDB = new ProgramBuilderEntities();
Sylla.CreationTime = DateTime.Now;
pbDB.Syllabuses.Add(Sylla);
pbDB.SaveChanges();
}
public void AreChangesTest(Syllabus previous, Syllabus current, bool expectedResult)
{
// Arrange
// Act
var result = SyllabusService.AreChanges(previous, current);
// Assert
Assert.Equal(expectedResult, result);
}
public DataSet Get(string command, string intSTD_id, string intSubject_id, string intSchool_id)
{
Syllabus syllabus = new Syllabus();
syllabus.intSchool_id = Convert.ToInt32(intSchool_id);
syllabus.intSTD_id = Convert.ToInt32(intSTD_id);
syllabus.intSubject_id = Convert.ToInt32(intSubject_id);
DataSet ds = record.SyllabusDetails(command, syllabus);
return(ds);
}
public void SyllabusVerificationTest(Syllabus syllabus, List <string> exptectedOutput)
{
// Arrange
var syllabusService = new SyllabusService(null, null, null, null);
// Act
var result = syllabusService.Verify(syllabus);
// Assert
Assert.True(exptectedOutput.All(o => result.Any(r => r == o)) && result.All(r => exptectedOutput.Any(o => r == o)));
}
public async Task <IActionResult> Create([Bind("Id,Semester")] Syllabus syllabus)
{
if (ModelState.IsValid)
{
_context.Add(syllabus);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(syllabus));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,AdmissionYear")] Syllabus syllabus)
{
if (ModelState.IsValid)
{
db.Entry(syllabus).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(syllabus));
}
public ActionResult Put(int id, [FromBody] Syllabus model)
{
if (!ModelState.IsValid)
{
return(BadRequest(model));
}
_context.Entry(model).State = EntityState.Modified;
_context.SaveChangesAsync();
return(Ok(model));
}
public async Task <IActionResult> Create([Bind("SyllabusId,Level,DanceId")] Syllabus syllabus)
{
if (ModelState.IsValid)
{
_context.Add(syllabus);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DanceId"] = new SelectList(_context.Dance, "DanceId", "DanceId", syllabus.DanceId);
return(View(syllabus));
}
public async Task <ActionResult> Create(Syllabus syllabus)
{
if (ModelState.IsValid)
{
syllabus.Specialty = db.Specialties.Find(syllabus.Specialty.Id);
db.Syllabi.Add(syllabus);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(syllabus));
}
public ActionResult Post([FromBody] Syllabus model)
{
if (!ModelState.IsValid)
{
return(BadRequest(model));
}
model.Status = "active";
_context.Syllabuses.Add(model);
_context.SaveChangesAsync();
return(Ok(model));
}
public bool UpdateLect(string id, string content)
{
try
{
Syllabus syslect = db.Syllabus.Where(info => info.id == id).Single();
syslect.CourseLecturer = content;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
// GET: Syllabus/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Syllabus syllabus = await db.Syllabi.FindAsync(id);
if (syllabus == null)
{
return(HttpNotFound());
}
return(View(syllabus));
}
public bool UpdateRequest(string id, string content)
{
try
{
Syllabus request = db.Syllabus.Where(info => info.id == id).Single();
request.CourseRequest = content;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public JsonResult UpdateRecord(Syllabus model)
{
using (StudentDBContext db = new StudentDBContext())
{
Syllabus tblSyllabus = db.CourseSyllabus.Where(cs => cs.ID.Equals(model.ID)).FirstOrDefault();
tblSyllabus.CourseId = model.CourseId;
tblSyllabus.SubjectId = model.SubjectId;
db.SaveChanges();
//return "Successfully updated.";
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public bool UpdateDes(string id, string content)
{
try
{
Syllabus sysdocument = db.Syllabus.Where(info => info.id == id).Single();
sysdocument.CourseDescription = content;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
