/// <summary> /// เรียกดูข้อมูลจากตาราง COURSEGROUP /// </summary> /// <param name="sql">SQL Command</param> /// <returns>ข้อมูลจากตาราง COURSEGROUP</returns> public List <CourseGroup> getCourseGroupManual(string sql) { List <CourseGroup> CourseGroupData = new List <CourseGroup>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { CourseGroup CourseGroupRow = new CourseGroup(); CourseGroupRow.CourseGroupCode = rowData["COURSEGROUPCODE"].ToString(); CourseGroupRow.CourseGroupThName = rowData["COURSEGROUPTHNAME"].ToString(); CourseGroupRow.CourseGroupEnName = rowData["COURSEGROUPENNAME"].ToString(); CourseGroupRow.CourseGroupFlag = rowData["COURSEGROUPFLAG"].ToString(); CourseGroupData.Add(CourseGroupRow); } return(CourseGroupData); }
/// <summary> /// เพิ่มข้อมูลลงตาราง COURSEGROUP /// </summary> /// <param name="dataInsert">CourseGroup Object</param> /// <returns>Success</returns> public string insertCourseGroup(CourseGroup dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into COURSEGROUP (COURSEGROUPCODE, COURSEGROUPTHNAME, COURSEGROUPENNAME, COURSEGROUPFLAG) values ('" + dataInsert.CourseGroupCode + "','" + dataInsert.CourseGroupThName + "','" + dataInsert.CourseGroupEnName + "','" + dataInsert.CourseGroupFlag + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertCourseGroup: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public async Task <bool> CurrentUserIsInSameReviewGroup(CourseGroup courseGroup) { AppUser user = await userManager.GetUserAsync(HttpContext.User); string reviewGroupForAssignment = courseGroup.ReviewGroup; string reviewGroupForUser = ""; List <CourseGroup> courseGroups = courseGroupRepo.GetAll(); foreach (CourseGroup cg in courseGroups) { if (cg.FK_AppUser == user && cg.ID == courseGroup.ID) { reviewGroupForUser = cg.ReviewGroup; } } if (reviewGroupForUser == reviewGroupForAssignment) { return(true); } else { return(false); } }
public JsonResult viewCourseScheduleByDepartmentId(int departmentId) { var Result = classRoomScheduleDAL.AllocateClassRoomGetAll().Select(n => new { CourseId = n.CourseId, RomNo = n.RoomNo, Day = n.Day, ToTime = n.ToTime, FromTime = n.FromTime, Schedule = n.RoomNo + ", " + n.Day + ", " + new DateTime(n.FromTime.Ticks).ToString("%h:mm tt") + " - " + new DateTime(n.ToTime.Ticks).ToString("%h:mm tt") + ";<br />", }); var newResult = (from a in Result.ToList() group a by a.CourseId into CourseGroup select new { CourseId = CourseGroup.FirstOrDefault().CourseId, Schedule = String.Join("\n", (CourseGroup.Select(x => x.Schedule)).ToArray()) }); var ResultFinal = from s in courseTeacherDAL.CourseGetAll() join c in newResult on s.CourseId equals c.CourseId into sGroup from c in sGroup.DefaultIfEmpty() //where s.DepartmentId == departmentId select new { DepartmentId = s.DepartmentId, CourseCode = s.CourseCode, CourseName = s.CourseName, Schedule = c == null ? "Not Scheduled Yet" : c.Schedule, }; var dataList = ResultFinal.Where(c => c.DepartmentId == departmentId).ToList(); var jsonData = dataList.Select(c => new { c.CourseCode, c.CourseName, c.Schedule }); return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public void readWeeklyReportItemsFromDataBase(int stuid) { ObservableCollection <WeeklyReportItem> weeklyReportItems = DatabaseHelper.getWeeklyReportItems(weekNoForDB, selectedClassId, stuid); CourseGroup cg = null; foreach (WeeklyReportItem item in weeklyReportItems) { cg = findCourseGroupById(item.courseid); if (cg != null) { item.category = cg.category; item.coursename = cg.courseName; } if (item.category.Equals("多元智能")) { weeklyReportDuoYuanItems.Add(item); } else if (item.category.Equals("生活")) { weeklyReportLiveItems.Add(item); } else if (item.category.Equals("风险事故")) { weeklyReportRiskItems.Add(item); } else if (item.category.Equals("一周综合评价")) { weeklyReportEvaluationItems.Add(item); } else if (item.category.Equals("家园合作建议")) { weeklyReportFamilyAndSchollEduItems.Add(item); } } }
/// <summary> /// แก้ไขข้อมูลจากตาราง COURSEGROUP /// </summary> /// <param name="updateData">CourseGroup Object</param> /// <returns>Success</returns> public string updateCourseGroup(CourseGroup updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update COURSEGROUP Set COURSEGROUPTHNAME = '" + updateData.CourseGroupThName + "', COURSEGROUPENNAME = '" + updateData.CourseGroupEnName + "', COURSEGROUPFLAG = '" + updateData.CourseGroupFlag + "' Where COURSEGROUPCODE = '" + updateData.CourseGroupCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateAboutLecturer: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public async Task <JsonResult> GetStudentGroup(string studentID, int courseID) { JsonResponse <CourseGroup> response = new JsonResponse <CourseGroup>(); AppUser currentUser = await usrMgr.GetUserAsync(HttpContext.User); CourseGroup courseGroup = null; courseGroupRepository.GetAll().ForEach(cG => { if (cG.FK_Course.ID == courseID && cG.FK_AppUser.Id == studentID) { courseGroup = cG; } }); SetRoles(); if (courseGroup != null) { if (this.isAdmin || this.isInstructor && courseGroup.FK_Course.FK_INSTRUCTOR.Id == currentUser.Id) { response.Data.Add(courseGroup); } else { response.Error.Add(new Error("Forbidden", "You are not allowed here.")); } } else { response.Error.Add(new Error("NotFound", "The course group was not found.")); } return(Json(response)); }
public void OnGet(int?id) { CourseGroups = new CourseGroup() { ParentID = id }; }
/// <summary> /// Generate a dropdown list of courses to pick from based on the list of available courses and course groups within the database. /// Additionally segments the courses into the course groups defined in the database to make courses easier to find. /// </summary> /// <param name="courses">List of courses to include in the drop down</param> /// <param name="groups">List of groups to segment the courses into</param> /// <param name="selectedCourseId">Pre-select a course if it has been selected previously</param> /// <returns>A dropdown list of available courses to apply for.</returns> public static IEnumerable <SelectListItem> ToSelectList(this List <Course> courses, List <CourseGroup> groups, int?selectedCourseId) { // Order the courses into groups in the select list, following the same groups as the overall course groups. List <SelectListGroup> selectGroups = new List <SelectListGroup>(); if (groups != null && groups.Any()) { groups.ForEach(g => selectGroups.Add(new SelectListGroup { Name = g.Name })); } // Convert each course into an item in the select list foreach (Course course in courses) { // Find the group that this course belongs to, if any. CourseGroup courseGroup = groups.FirstOrDefault(g => g.Id == course.Type); SelectListGroup selectGroup = selectGroups.FirstOrDefault(g => courseGroup != null && g.Name == courseGroup.Name); yield return(new SelectListItem { Value = course.Id.ToString(), Text = course.Title, Selected = selectedCourseId.HasValue ? selectedCourseId.Value == course.Id : false, Group = selectGroup }); } }
public static CourseGroup CreateCourseGroup(string group) { CourseGroup courseGroup = new CourseGroup(); courseGroup.Group = group; return(courseGroup); }
public void UpdateCoursesNumOfStudents() { List <int> numOfStudents = new List <int>(); using (Kita1205GradesEntities gradesEntities = new Kita1205GradesEntities()) { var allCoursesGrouped = (from g in gradesEntities.Grades group g by g.Course_ID).ToList(); foreach (var CourseGroup in allCoursesGrouped) { numOfStudents.Add(CourseGroup.Count()); } List <Courses> courses = (from c in gradesEntities.Courses select c).ToList(); for (int i = 0; i < numOfStudents.Count; i++) { courses[i].Num_Of_Students = numOfStudents[i]; gradesEntities.SaveChanges(); } gradesEntities.SaveChanges(); } }
public async Task <JsonResult> ChangeStudentGroup(int courseGroupID, string reviewGroupID) { JsonResponse <CourseGroup> response = new JsonResponse <CourseGroup>(); AppUser currentUser = await usrMgr.GetUserAsync(HttpContext.User); CourseGroup courseGroup = courseGroupRepository.FindByID(courseGroupID); SetRoles(); if (courseGroup != null) { if (this.isAdmin || this.isInstructor && courseGroup.FK_Course.FK_INSTRUCTOR.Id == currentUser.Id) { courseGroup.ReviewGroup = reviewGroupID; if (courseGroupRepository.Edit(courseGroup)) { response.Data.Add(courseGroup); } else { response.Error.Add(new Error("NotSuccessful", "The data was not successfully writen.")); } } else { response.Error.Add(new Error("Forbidden", "You are not allowed here.")); } } else { response.Error.Add(new Error("NotFound", "The Course Group was not found.")); } return(Json(response)); }
/// <summary> /// Validate the object. /// </summary> /// <exception cref="Microsoft.Rest.ValidationException"> /// Thrown if validation fails /// </exception> public virtual void Validate() { if (CourseGroup != null) { CourseGroup.Validate(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["login_data"] == null) { Response.Redirect("../index.aspx"); } else { //ตรวจสอบสิทธิ์ login_data = (UserLoginData)Session["login_data"]; if (autro_obj.CheckGroupUser(login_data, group_var.officer_department) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { // ======== Process =========== code = Request.QueryString["token"]; CourseGroup courseGroupData = new CourseGroup().getCourseGroup(code); if (!Page.IsPostBack) { txtGROUP_THAINAME.Text = courseGroupData.CourseGroupThName; txtGROUP_ENGNAME.Text = courseGroupData.CourseGroupEnName; } //============================= } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
public async Task <IActionResult> Edit(int id, [Bind("CourseId,GroupId")] CourseGroup courseGroup) { if (id != courseGroup.CourseId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(courseGroup); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CourseGroupExists(courseGroup.CourseId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CourseId"] = new SelectList(_context.Courses, "CourseId", "CourseId", courseGroup.CourseId); ViewData["GroupId"] = new SelectList(_context.Groups, "GroupId", "GroupId", courseGroup.GroupId); return(View(courseGroup)); }
public ActionResult DeleteConfirmed(long id) { CourseGroup courseGroup = db.CourseGroups.Find(id); db.CourseGroups.Remove(courseGroup); db.SaveChanges(); return(RedirectToAction("Index")); }
public CourseGroupDTO MapCourseGroup(CourseGroup courseGroup) { return(new CourseGroupDTO { CourseId = courseGroup.CourseId, GroupId = courseGroup.GroupId, Name = courseGroup.Group.Name, }); }
public ActionResult CreateCourseGroup() { CourseGroup courseGroup = new CourseGroup(); ViewBag.groupList = DropDownListHelper.getAppraiseGroupList(false); ViewBag.courseClassList = DropDownListHelper.getCourseClassList(false); return(View(courseGroup)); }
private CourseGroupDTO MapGroupRef(CourseGroup group) { return(new CourseGroupDTO { GroupId = group.GroupId, CourseId = group.CourseId, Name = group.Group.Name }); }
public async Task <ActionResult> DeleteConfirmed(int id) { CourseGroup courseGroup = await _ctx.CourseGroups.FindAsync(id); _ctx.CourseGroups.Remove(courseGroup); await _ctx.SaveChangesAsync(); return(RedirectToAction("Default")); }
protected void btnOK_Click(object sender, EventArgs e) { string courseGroupDelete = new CourseGroup().deleteCourseGroup(code); if (courseGroupDelete == "Success") { Response.Redirect("listGROUP.aspx"); } }
public async Task <ActionResult> Edit(CourseGroup courseGroup) { if (ModelState.IsValid) { _ctx.Entry(courseGroup).State = EntityState.Modified; await _ctx.SaveChangesAsync(); return(RedirectToAction("Default")); } return(View(courseGroup)); }
public async Task <ActionResult> Create(CourseGroup courseGroup) { if (ModelState.IsValid) { _ctx.CourseGroups.Add(courseGroup); await _ctx.SaveChangesAsync(); return(RedirectToAction("Default")); } return(View(courseGroup)); }
public void TestAddCourseGroupToNullDegree() { var newGroup = new CourseGroup() { CourseGroupId = "ABCD123", Name = "Testing Course Group", CreditsRequired = 3, CoursesRequired = 1 }; _service.AddCourseGroupToDegree("GroupNull", newGroup); }
public ActionResult Edit([Bind(Include = "Id,CourseId,GroupId,TeacherId,TeacherId1,TeacherId2,Capacity,StudentCount,ClassId,SectionGroup,DayTimeSlot,Sex")] CourseGroup courseGroup) { if (ModelState.IsValid) { db.Entry(courseGroup).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassId = new SelectList(db.ClassOrYears, "Code", "Name", courseGroup.ClassId); ViewBag.CourseId = new SelectList(db.CourseContents, "CourseId", "CourseName", courseGroup.CourseId); ViewBag.TeacherId = new SelectList(db.EmployeeAccounts, "AccountId", "EmployeeCatagoryId", courseGroup.TeacherId); return(View(courseGroup)); }
public async Task <IActionResult> Create([Bind("CourseId,GroupId")] CourseGroup courseGroup) { if (ModelState.IsValid) { _context.Add(courseGroup); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CourseId"] = new SelectList(_context.Courses, "CourseId", "CourseId", courseGroup.CourseId); ViewData["GroupId"] = new SelectList(_context.Groups, "GroupId", "GroupId", courseGroup.GroupId); return(View(courseGroup)); }
public IActionResult UploadCourseGroup(FileUploadVm vm) { if (!Authenticate()) { return(RedirectToAction("Index", "Home")); } var user = GetCurrentlyLoggedInUser(); if (!user.IsAdmin) { return(RedirectToAction("Index", "Planner")); } if (!ModelState.IsValid) { return(View(vm)); } using (var context = new DegreePlannerContext()) using (var stream = vm.File.OpenReadStream()) using (var reader = new StreamReader(stream)) { string line; while ((line = reader.ReadLine()) != null) { var data = line.Split(','); var name = data[0]; var courseGroup = new CourseGroup() { Name = name, CourseCourseGroupLinks = new List <CourseCourseGroupLink>() }; for (var i = 1; i < data.Length; i++) { var link = new CourseCourseGroupLink(); var department = data[i].Substring(0, 4); var number = data[i].Substring(4); var course = CreateOrFetchCourse(context, department, number, out var gen); link.Course = course; courseGroup.CourseCourseGroupLinks.Add(link); } context.CourseGroups.Add(courseGroup); context.SaveChanges(); } } return(RedirectToAction("Index", "Planner")); }
public void TestAddCourseGroupToDegree() { var newGroup = new CourseGroup() { CourseGroupId = "ABCD123", Name = "Testing Course Group", CreditsRequired = 3, CoursesRequired = 1 }; _service.AddCourseGroupToDegree("CSAI", newGroup); Assert.IsTrue(_reqContext.Degrees.Find("CSAI").CourseGroups.Contains(newGroup)); SeedRequirementsData.reset = true; }
// GET: Admin/CourseGroupManagement/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseGroup courseGroup = await _ctx.CourseGroups.FindAsync(id); if (courseGroup == null) { return(HttpNotFound()); } return(View(courseGroup)); }
// GET: CourseGroup/Details/5 public ActionResult Details(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseGroup courseGroup = db.CourseGroups.Find(id); if (courseGroup == null) { return(HttpNotFound()); } return(View(courseGroup)); }