private void LoadCourseDetail() { using (var helper = new DbHelper.Subject()) { var course = helper.Find(CourseId); //lblTitle.Text = course.Name; //lblSummary.Text = course.Summary; if (course != null) { var sections = course.SubjectSections; if (sections != null) { var unVoidedSections = sections.Where(x => !(x.Void ?? false)); foreach (var subjectSection in unVoidedSections) { SectionUc sectionuc = (SectionUc)Page.LoadControl("~/Views/Course/Section/SectionUc.ascx"); sectionuc.SummaryVisible = subjectSection.ShowSummary ?? false; sectionuc.SubjectId = subjectSection.SubjectId; sectionuc.SectionId = subjectSection.Id; pnlSections.Controls.Add(sectionuc); } } } } //CreateSectionUc uc = (CreateSectionUc)Page.LoadControl("~/Views/Course/Section/CreateSectionUc.ascx"); //uc.ID = "createSection"; //uc.Visible = false; //uc.SubjectId = CourseId; //uc.OnSaveEvent += uc_OnSaveEvent; //pnlSections.Controls.Add(uc); }
void LoadCourses(int categoryId) { var catId = categoryId.ToString(); var selected = new List <int>(); foreach (ListItem i in lstAssignedCourses.Items) { //value has two fields -- '0'=courseId, '1'=categoryId, '2'- earlier credit, //'3'-elective , '4'-currently assigned credit var cat = i.Value.Split(new char[] { '_' }); //only select those which are in same category if (catId == cat[1]) { selected.Add(Convert.ToInt32(cat[0])); } } using (var helper = new DbHelper.Subject()) { var unAssignedCourses = helper.ListCourses(ProgramId, categoryId, selected); foreach (var subject in unAssignedCourses) { lstUnAssignedCourses.Items.Add(new ListItem() { Value = subject.Id + "_" + subject.SubjectCategoryId + "_" + subject.Credit //+(false).ToString(), , Text = subject.FullName }); } } }
void GetSubCategory(DbHelper.Subject helper, int schoolId, int categoryId , int paddingPosition) { paddingPosition++; var subCategories = helper.ListSubCategories(schoolId, categoryId); foreach (var cat in subCategories) { var spaces = " "; for (int j = 0; j < paddingPosition * 4; j++) { spaces += " "; } var litem = new ListItem() { Text = spaces + cat.Name }; litem.Attributes.Add("style", "padding-left:" + (paddingPosition * 4) + "px"); var catLink = new LinkButton() { Text = cat.Name , ID = "category_" + cat.Id }; catLink.Click += catLink_Click; catLink.Style.Add("padding-left", ((paddingPosition) * 16) + "px"); pnlCategories.Controls.Add(catLink); GetSubCategory(helper, schoolId, cat.Id, paddingPosition); } }
private void CourseCategoryDelete() { var user = Page.User as CustomPrincipal; if (user != null) { if (user.IsInRole("manager") || user.IsInRole(DbHelper.StaticValues.Roles.CourseEditor)) { //var courseId = Request.QueryString["crsId"]; var categoryId = Request.QueryString["catId"]; if (categoryId != null) { var catId = Convert.ToInt32(categoryId); using (var courseHelper = new DbHelper.Subject()) { var deleted = courseHelper.DeleteCategory(catId); if (deleted) { Response.Redirect("~/Views/Course/", false); } else { lblError.Visible = true; } } } } else { Response.Redirect("~/Views/All_Resusable_Codes/Error/ErrorPage.aspx?error=" + DbHelper.StaticValues.GetEncodedError(1) ); } } }
void GetSubCats(Category.ListUC parentUc, DbHelper.Subject helper, int schoolId, int categoryId, int paddingCount) { #region Function all var edit = Manager; var subcats = helper.ListSubCategories(schoolId, categoryId); var selectedCat = SelectedCategory; for (var s = 0; s < subcats.Count; s++) { var catUc = (Category.ListUC)Page.LoadControl("~/Views/Course/Category/ListUC.ascx"); catUc.Deselect(); catUc.SetNameAndIdOfCategory(subcats[s].Id, subcats[s].Name, paddingCount, edit);//list paddingCount += 1; catUc.NameClicked += catUc_NameClicked; catUc.ID = "category_" + subcats[s].Id; //parentUc.AddSubCategories(catUc); pnlCategories.Controls.Add(catUc); if ((selectedCat == subcats[s].Id && !IsPostBack) || selectedCat == 0) { catUc_NameClicked(catUc, new DataEventArgs() { Id = subcats[s].Id, Name = subcats[s].Name }); catUc.Select(); selectedCat = subcats[s].Id; } GetSubCats(catUc, helper, schoolId, subcats[s].Id, paddingCount); } #endregion }
void LoadCourses(int categoryId) { using (var helper = new DbHelper.Subject()) { //dlistCourses.DataSource = null; dlistCourses.DataSource = helper.ListCourses(categoryId); dlistCourses.DataBind(); } }
private void BindData() { using (var helper = new DbHelper.Subject()) { var levelId = Convert.ToInt32(cmbLevel.SelectedValue == ""?"0":cmbLevel.SelectedValue); var subjects = helper.ListSubjects(levelId); grdView.DataSource = subjects; grdView.DataBind(); //grdView.Columns.Add(new datacontrolfie); = ""; } }
private void LoadCourse(int courseId) { using (var helper = new DbHelper.Subject()) { var sub = helper.Find(courseId); if (sub != null) { txtSubjectName.Text = sub.FullName; CourseDetailUc1.CourseId = Id; } //CourseDetailUc1. } }
private void LoadData() { using (var helper = new DbHelper.Subject()) { var subClss = helper.ListEarlierSubjectClasses(UserId); var againCurrent = subClss.Where(x => !(x.SessionComplete ?? false)).ToList(); var againCurrentSubs = againCurrent.Where(x => x.IsRegular).Select(x => x.SubjectStructure.Subject).Distinct() .Select(x => x.Id).ToList(); //var reg = var run = subClss.Where(x => x.IsRegular && (x.SessionComplete ?? false)).GroupBy(x => x.RunningClass).ToList(); foreach (var r in run) { var nodeuc = (EarlierUc_NodesUc)Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx"); //key is used to display year/subyear var subjects = r.Select(x => x.SubjectStructure.Subject) .Distinct() .Where(x => !againCurrentSubs.Contains(x.Id)) .Distinct().OrderBy(x => x.FullName).ToList(); nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects); pnlRegularCourses.Controls.Add(nodeuc); } againCurrentSubs = againCurrent.Where(x => !x.IsRegular).Select(x => x.Subject).Distinct() .Select(x => x.Id).ToList(); var irrRun = subClss.Where(x => !x.IsRegular && (x.SessionComplete ?? false)) .Select(x => x.Subject).Distinct().Where(x => !againCurrentSubs.Contains(x.Id)) .Distinct().OrderBy(x => x.FullName).ToList(); if (irrRun.Any()) { divNonRegular.Visible = true; dListNonRegularSubjects.DataSource = irrRun; dListNonRegularSubjects.DataBind(); } else { if (!run.Any()) { if (EmptyData != null) { EmptyData(this, new EventArgs()); } } divNonRegular.Visible = false; dListNonRegularSubjects.DataSource = null; dListNonRegularSubjects.DataBind(); } } }
//earlier code:::: works // Note :: ├ ==>1 , └ ==> 2 . ┌ ==> 3 , │ ==> 4 , empty ==> 0 void GetSubCats(Category.ListUC parentUc, DbHelper.Subject helper, int schoolId, int categoryId, List <int> parentPaddingList) { #region Function all var subcats = helper.ListSubCategories(schoolId, categoryId); var list = new List <int>(); if (subcats.Count > 0) { foreach (var i in parentPaddingList) { list.Add(0); } } var selectedCat = SelectedCategory; for (var s = 0; s < subcats.Count; s++) { var catUc = (Category.ListUC)Page.LoadControl("~/Views/Course/Category/ListUC.ascx"); catUc.Deselect(); list.Add((parentPaddingList[parentPaddingList.Count - 1] == 1) ? 2 : 1); catUc.SetNameAndIdOfCategory(subcats[s].Id, subcats[s].Name, list, false);//list catUc.NameClicked += catUc_NameClicked; catUc.ID = "category_" + subcats[s].Id; //parentUc.AddSubCategories(catUc); pnlCategories.Controls.Add(catUc); if ((selectedCat == subcats[s].Id && !IsPostBack) || selectedCat == 0) { catUc_NameClicked(catUc, new DataEventArgs() { Id = subcats[s].Id, Name = subcats[s].Name }); catUc.Select(); selectedCat = subcats[s].Id; } GetSubCats(catUc, helper, schoolId, subcats[s].Id, list); list.RemoveAt(list.Count - 1); } #endregion }
public void LoadCourseList(string edit, int yearId, int subYearId = 0) { hidYearId.Value = yearId.ToString(); hidSubYearId.Value = subYearId.ToString(); hidEdit.Value = edit; //AddCourses1.YearId = yearId; //AddCourses1.SubYearId = subYearId; using (var helper = new DbHelper.Subject()) { var courseList = helper.ListCoursesOfStructure(yearId, subYearId); dlistCourses.DataSource = courseList; dlistCourses.DataBind(); } }
private void PopulateCourseData(int courseId) { using (var helper = new DbHelper.Subject()) { var course = helper.GetCourse(courseId); if (course != null) { if (SiteMap.CurrentNode != null) { var list = new List <IdAndName>() { new IdAndName() { Name = SiteMap.RootNode.Title , Value = SiteMap.RootNode.Url , Void = true }, new IdAndName() { Name = SiteMap.CurrentNode.ParentNode.Title , Value = SiteMap.CurrentNode.ParentNode.Url , Void = true } , new IdAndName() { Name = course.FullName , Value = "~/Views/Course/CourseDetail.aspx?cId=" + course.Id , Void = true } , new IdAndName() { Name = "Edit" } }; SiteMapUc.SetData(list); } txtName.Text = course.FullName; txtShortName.Text = course.ShortName; txtCode.Text = course.Code; txtCredit.Text = course.Credit.ToString(); CKEditor1.Text = course.Summary; CategoryId = CategoryId; } } }
protected void btnSave_Click(object sender, EventArgs e) { var user = Page.User as CustomPrincipal; if (user != null) { if (Page.IsValid) { Subject subject = new Subject() { Id = CourseId, FullName = txtName.Text, ShortName = txtShortName.Text, Code = txtCode.Text, Credit = Convert.ToInt32(string.IsNullOrEmpty(txtCredit.Text) ? "0" : txtCredit.Text), SubjectCategoryId = CategoryId, Summary = CKEditor1.Text }; if (CourseId == 0) { subject.CreatedDate = DateTime.Now.Date; subject.CreatedById = user.Id; } using (var helper = new DbHelper.Subject()) { var saved = helper.AddOrUpdateSubject(subject); if (saved) { if (CourseId > 0) { Response.Redirect("~/Views/Course/CourseDetail.aspx?cId=" + CourseId); } else { Response.Redirect("~/Views/Course/?catId=" + CategoryId); } } else { lblError.Visible = true; } } } } }
private void LoadAssignedList() { using (var helper = new DbHelper.Subject()) { var assignedCourses = helper.ListCoursesOfStructure(YearId, SubYearId); //ViewState["SavedCourses"] = assignedCourses; foreach (var subject in assignedCourses) { lstAssignedCourses.Items.Add(new ListItem() { Value = subject.Id + "_" + subject.CategoryId + "_" + subject.Credit + "_" + subject.IsElective.ToString(), Text = subject.Name }); } } }
protected void Page_Load(object sender, EventArgs e) { //AddCourses1.CancelClicked += AddCourses_ReturnClicked; //AddCourses1.SaveClicked += AddCourses_ReturnClicked; var user = Page.User as CustomPrincipal; if (user != null) { if (!IsPostBack) { if (user.IsInRole("manager")) { var edit = (Session["editMode"] as string) ?? "0"; var showBtn = Request.QueryString["swMgBt"]; var show = showBtn != null && showBtn == "1"; btnManageSubject.Visible = edit == "1" || show; } else { btnManageSubject.Visible = false; } using (var helper = new DbHelper.Subject()) { var courses = helper.ListCoursesOfStructure(YearId, SubYearId); dlistCourses.DataSource = courses; dlistCourses.DataBind(); //courses.ForEach(x => //{ // savedCourses.Add(new Subject() // { // Id = x.Id // , // Name = x.Name // , // CategoryId = x.SubjectCategoryId // , // Checked = false // }); //}); //ViewState["SavedCourses"] = savedCourses; } } } }
void LoadCategories(int schoolId) { var selectedCat = SelectedCategory; using (var helper = new DbHelper.Subject()) { var cats = helper.ListAllCategories(schoolId); var list = new List <int>(); if (!cats.Any()) { lnkCoursCreate.Visible = false; } var edit = Manager; for (var c = 0; c < cats.Count; c++) { var catUc = (Category.ListUC)Page.LoadControl("~/Views/Course/Category/ListUC.ascx"); catUc.Deselect(); list.Add(1); catUc.SetNameAndIdOfCategory(cats[c].Id, cats[c].Name, 0, edit);//list catUc.NameClicked += catUc_NameClicked; catUc.ID = "category_" + cats[c].Id; pnlCategories.Controls.Add(catUc); if ((selectedCat == cats[c].Id && !IsPostBack) || selectedCat == 0) { catUc_NameClicked(catUc, new DataEventArgs() { Id = cats[c].Id, Name = cats[c].Name }); catUc.Select(); selectedCat = cats[c].Id; } //GetSubCats(catUc, helper, schoolId, cats[c].Id, list); GetSubCats(catUc, helper, schoolId, cats[c].Id, 1); list.RemoveAt(list.Count - 1); } } }
private void LoadData() { var catId = Request.QueryString["catId"]; if (catId != null) { var categoryId = Convert.ToInt32(catId); using (var helper = new DbHelper.Subject()) { var category = helper.GetCategory(categoryId); if (category != null) { CategoryId = categoryId; txtName.Text = category.Name; txtDescription.Text = category.Description; ParentCategoryId = category.ParentId ?? 0; } } } }
public static List <DbEntities.Subjects.SubjectCategory> LoadSubjectCategory(ref DropDownList cmbCategory, int schoolId, bool includeTopAlso = false, bool includeEmptyField = false, int selectedValue = 0) { cmbCategory.DataTextField = "Name"; cmbCategory.DataValueField = "Id"; using (var helper = new DbHelper.Subject()) { var cats = helper.GetCategories(schoolId); if (includeTopAlso) { cats.Insert(0, new DbEntities.Subjects.SubjectCategory() { Id = 0, Name = " Top " }); } if (includeEmptyField) { cats.Insert(0, new DbEntities.Subjects.SubjectCategory() { Id = -1, Name = "" }); } cmbCategory.DataSource = cats; cmbCategory.DataBind(); if (selectedValue > 0) { var index = cats.IndexOf(cats.First(x => x.Id == selectedValue)); if (index >= 0) { cmbCategory.SelectedIndex = index; } } return(cats.ToList()); } }
private void CourseSectionDelete() { var user = Page.User as CustomPrincipal; if (user != null) { if (user.IsInRole("manager") || user.IsInRole(DbHelper.StaticValues.Roles.CourseEditor) || user.IsInRole("teacher")) { var courseId = Request.QueryString["crsId"]; var sectionId = Request.QueryString["secId"]; if (courseId != null && sectionId != null) { var secId = Convert.ToInt32(sectionId); using (var courseHelper = new DbHelper.Subject()) { var deleted = courseHelper.DeleteSection(secId); if (deleted) { Response.Redirect("~/Views/Course/Section/default.aspx?SubId=" + courseId + "&edit=1", false); } else { lblError.Visible = true; } } } } else { Response.Redirect("~/Views/All_Resusable_Codes/Error/ErrorPage.aspx?error=" + DbHelper.StaticValues.GetEncodedError(1) ); } } }
} //Earlier /*var regularincomplete = subSession.Where(x => x.IsRegular) * .Select(x => x.SubjectStructure.Subject).ToList(); * var notregularincomplete = subSession.Where(x => !x.IsRegular) * .Select(x => x.Subject).ToList(); * regularincomplete.AddRange(notregularincomplete);*/ private void LoadData() { using (var helper = new DbHelper.Subject()) { #region Using Subject Class but its not complete var subClss = helper.ListCurrentSubjectClasses(UserId); var run = subClss.Where(x => x.IsRegular).GroupBy(x => x.RunningClass); foreach (var r in run) { var nodeuc = (EarlierUc_NodesUc) Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx"); //key is used to display year/subyear var subjects = r.Select(x => x.SubjectStructure.Subject).Distinct().OrderBy(x => x.FullName).ToList(); nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects); pnlRegularCourses.Controls.Add(nodeuc); //lbltitle.ToolTip = r.Key.ProgramBatch.NameFromBatch; } var irrRun = subClss.Where(x => !x.IsRegular) .Select(x => x.Subject).Distinct().OrderBy(x => x.FullName).ToList(); if (irrRun.Any()) { divNonRegular.Visible = true; dListNonRegularSubjects.DataSource = irrRun; dListNonRegularSubjects.DataBind(); } else { divNonRegular.Visible = false; dListNonRegularSubjects.DataSource = null; dListNonRegularSubjects.DataBind(); } #endregion } }
public static List <DbEntities.Subjects.Subject> LoadSubject(ref DropDownList cmbSubject, int schoolId) { cmbSubject.DataTextField = "Name"; cmbSubject.DataValueField = "Id"; using (var helper = new DbHelper.Subject()) { var cats = helper.GetSubjectList(schoolId); //if (includeEmptyField) { cats.Insert(0, new DbEntities.Subjects.Subject() { Id = 0, FullName = "" }); } cmbSubject.DataSource = cats; cmbSubject.DataBind(); return(cats.ToList()); } }
//public String ReturnUrl //{ // set // { // btnCancel.Visible = true; // hidRetUrl.Value = value; // } //} protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { var cat = new Academic.DbEntities.Subjects.SubjectCategory() { Id = CategoryId , SchoolId = SchoolId , CreatedDate = DateTime.Now.Date , Description = txtDescription.Text , IsActive = chkIsActive.Checked , Name = txtName.Text }; if (!(cmbCategory.SelectedValue == "" || cmbCategory.SelectedValue == "0" || cmbCategory.SelectedValue == "-1")) { cat.ParentId = Convert.ToInt32(cmbCategory.SelectedValue); } using (var helper = new DbHelper.Subject()) { var save = helper.AddOrUpdateSubjectCategory(cat); if (save != null) { Response.Redirect("~/Views/Course/?catId=" + save.Id); } else { lblError.Visible = true; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //examOfClass var eoc = Request.QueryString["eocId"]; if (eoc != null) { try { hidExamOfClassId.Value = eoc; using (var ehelper = new DbHelper.Exam()) using (var shelper = new DbHelper.Subject()) using (var bhelper = new DbHelper.Batch()) { var examClass = ehelper.GetExamOfClass(ExamOfClassId); if (examClass != null) { //UI title and other controls lblExamName.Text = examClass.Exam.Name; lblClassName.Text = examClass.RunningClass.ProgramBatch.NameFromBatch; //Courses in this exam var lst = shelper.ListExamCourses(examClass.Id); var i = 1; foreach (var es in lst) { pnlSubjects.Controls.Add(new HyperLink() { Text = i + ". " + es.SubjectClass.SubjectStructure.Subject.FullName + "<br/>" , CssClass = "margin-top-bottom-little" }); i++; } //students in the exam i = 1; var stds = bhelper.ListStudentsOfProgramBatch(examClass.RunningClass.ProgramBatch.Id); foreach (var s in stds) { pnlStudents.Controls.Add(new HiddenField() { Value = s.UserId.ToString() }); pnlStudents.Controls.Add(new Label() { Text = i + ". " }); pnlStudents.Controls.Add(new Image() { ImageUrl = s.ImageUrl , Width = 40 , Height = 40 , BorderColor = Color.LightSlateGray , BorderWidth = 1 , BorderStyle = BorderStyle.Solid , //CssClass = "margin-top-bottom-little" }); pnlStudents.Controls.Add(new HyperLink() { Text = " " + s.CRN + " " + s.Name + "<br/>" , CssClass = "margin-top-bottom-little" }); i++; } } } } catch { } } } }
List <IdAndName> GetCourse() { var subId = Request.QueryString["SubId"]; var fromCls = Request.QueryString["from"]; var yId = Request.QueryString["yId"]; var sId = Request.QueryString["sId"]; using (var helper = new DbHelper.Subject()) { var list = new List <IdAndName>(); var sub = helper.Find(Convert.ToInt32(subId)); // if (SiteMap.CurrentNode != null) // { list.Add(new IdAndName() { Name = "Home", //SiteMap.RootNode.Title, Value = "~/", //SiteMap.RootNode.Url, Void = true }); if (sId != null && yId != null) { //lnkEdit.NavigateUrl += "&yId=" + yId + "&sId=" + sId; list.Add(new IdAndName() { Name = "Manage Programs", Value = "~/Views/Structure/", Void = true }); using (var strHelper = new DbHelper.Structure()) { list.Add(new IdAndName() { Name = strHelper.GetSructureDirectory(Convert.ToInt32(yId), Convert.ToInt32(sId)), Value = "~/Views/Structure/CourseListing.aspx?yId=" + yId + "&sId=" + sId, Void = true }); } list.Add(new IdAndName() { Name = sub.FullName }); } else if (fromCls != null) { //lnkEdit.NavigateUrl += "&frmDetailView=" + fromCls; list.Add(new IdAndName() { Name = "Courses", //SiteMap.CurrentNode.ParentNode.Title, Value = "~/Views/Course/Default.aspx", //SiteMap.CurrentNode.ParentNode.Url, Void = true }); list.Add(new IdAndName() { Name = sub.FullName, Value = "~/Views/Course/CourseDetail.aspx?cId=" + sub.Id, Void = true }); list.Add(new IdAndName() { Name = "View" }); } else { list.Add(new IdAndName() { Name = sub.FullName, Value = "~/Views/Course/Section/?SubId=" + subId, //"~/Views/Course/CourseDetail.aspx?cId=" + sub.Id Void = true }); } //} return(list); } }
private void LoadCourseDetail() { var courseId = CourseId; using (var helper = new DbHelper.Subject()) { lnkAddSection1.NavigateUrl = "~/Views/Course/Section/CreateSection.aspx?SubId=" + courseId; var course = helper.Find(courseId); //lblTitle.Text = course.Name; //lblSummary.Text = course.Summary; if (course != null) { var sections = course.SubjectSections; if (sections != null) { var user = Page.User as CustomPrincipal; var elligible = false; if (user != null) { using (var chelper = new DbHelper.Classes()) { var roles = user.GetRoles(); //Context.UserClass.Any(x=>x.subje) // var roles = user.GetRoles().Select(x => x.Role.RoleName).ToList(); if (roles.Contains(DbHelper.StaticValues.Roles.CourseEditor.ToString()) || roles.Contains(DbHelper.StaticValues.Roles.Manager.ToString()) || roles.Contains(DbHelper.StaticValues.Roles.Admin) || roles.Contains("teacher")) { elligible = true; } //else //{ // //teacher // elligible = (chelper.IsUserElligibleToViewSubjectSection(SubjectId, UserId)); //} var unVoidedSections = sections.Where(x => !(x.Void ?? false)).OrderBy(x => x.Position); using (var ahelper = new DbHelper.ActAndRes()) foreach (var subjectSection in unVoidedSections) { var canView = elligible; if (!canView) { canView = ahelper.EvaluateRestriction(null, subjectSection.Restriction, user.Id); } if (canView) // { SectionUc sectionuc = (SectionUc)Page.LoadControl("~/Views/Course/Section/SectionUc.ascx"); sectionuc.AddActResClicked += sectionuc_AddActResClicked; //sectionuc.EditEnabled = EditEnabled; //sectionuc.SummaryVisible = subjectSection.ShowSummary ?? false; //sectionuc.SubjectId = subjectSection.SubjectId; //sectionuc.SectionId = subjectSection.Id; //sectionuc.SectionName = subjectSection.Name; sectionuc.SetData(EditEnabled, subjectSection.ShowSummary ?? false , subjectSection.SubjectId, subjectSection.Id , subjectSection.Name, UserId, elligible); var sectionlbl = new Literal() { Text = "<a name='section_" + subjectSection.Id + "'></a>" }; pnlSections.Controls.Add(sectionlbl); pnlSections.Controls.Add(sectionuc); } } } } } } } //CreateSectionUc uc = (CreateSectionUc)Page.LoadControl("~/Views/Course/Section/CreateSectionUc.ascx"); //uc.ID = "createSection"; //uc.Visible = false; //uc.SubjectId = CourseId; //uc.OnSaveEvent += uc_OnSaveEvent; //pnlSections.Controls.Add(uc); }
private void LoadData2() { using (var helper = new DbHelper.Subject()) { var userClasses = helper.ListCurrentUserClasses(UserId); #region Manager Classes var managerClasses = userClasses.Where(x => x.Role.RoleName == "manager" || x.Role.RoleName == "teacher"); var managerSubjects = managerClasses.GroupBy( x => x.SubjectClass.IsRegular ? x.SubjectClass.SubjectStructure.Subject : x.SubjectClass.Subject); foreach (var subjGroup in managerSubjects) { //key is subject var mngUc = (Course.ManagerCourseUc) Page.LoadControl("~/ViewsSite/User/ModulesUc/Course/ManagerCourseUc.ascx"); mngUc.SetData(subjGroup.Key.Id, subjGroup.Key.ShortName, subjGroup.Key.FullName, subjGroup.ToList()); foreach (var uclass in subjGroup) { // var mngUcClass = (Course.ManagerCourseUc) //Page.LoadControl("~/ViewsSite/User/ModulesUc/Course/ManagerCourseUc.ascx"); // mngUc.SetData(subjGroup.Key.Id, subjGroup.Key.ShortName, subjGroup.Key.FullName, subjGroup.ToList()); } pnlRegularCourses.Controls.Add(mngUc); } #endregion #region Student Classes var studentClasses = userClasses.Where(x => x.Role.RoleName == "student"); var run = studentClasses.Select(x => x.SubjectClass).GroupBy(x => x.RunningClass); foreach (var r in run) { if (r.Key != null) { var nodeuc = (EarlierUc_NodesUc)Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx"); //key is used to display year/subyear var subjects = r.Select(x => x.IsRegular ? x.SubjectStructure.Subject : x.Subject) .Distinct().OrderBy(x => x.ShortName).ToList(); nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects); //lbltitle.ToolTip = r.Key.ProgramBatch.NameFromBatch; pnlRegularCourses.Controls.Add(nodeuc); } else { //key is used to display year/subyear var nodeuc = (EarlierUc_NodesUc) Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx"); var subjects = r.Select(x => x.IsRegular ? x.SubjectStructure.Subject : x.Subject) .Distinct().OrderBy(x => x.ShortName).ToList(); nodeuc.SetStructureData(null, null, subjects); //foreach (var s in r) //{ // var name = s.GetName; // var nodeuc = (EarlierUc_NodesUc) // Page.LoadControl("~/ViewsSite/User/ModulesUc/EarlierUc_NodesUc.ascx"); // //nodeuc.SetStructureData(r.Key.Year, r.Key.SubYear, subjects); // nodeuc.SetStructureData(new Year(){Name=s.GetName}, null, subjects); // pnlRegularCourses.Controls.Add(nodeuc); //} } } #endregion //var runClass = userClasses.GroupBy(x => x.SubjectClass.RunningClass); //var subClss = userClasses.Select(x => x.SubjectClass);//helper.ListCurrentSubjectClasses(UserId); //var irrRun = subClss.Where(x => !x.IsRegular) // .Select(x => x.Subject).Distinct().OrderBy(x => x.FullName).ToList(); //if (irrRun.Any()) //{ // divNonRegular.Visible = true; // dListNonRegularSubjects.DataSource = irrRun; // dListNonRegularSubjects.DataBind(); //} //else //{ // divNonRegular.Visible = false; // dListNonRegularSubjects.DataSource = null; // dListNonRegularSubjects.DataBind(); //} } }
private void LoadCategories(int schoolId) { using (var helper = new DbHelper.Subject()) { var categories = helper.ListAllCategories(schoolId); var i = 0; var list = new List <int>(); foreach (var cat in categories) { list.Add(1); var catLink = new LinkButton() { Text = cat.Name , ID = "category_" + cat.Id }; catLink.Click += catLink_Click; //catUc.ID = "category" + cat.Id.ToString() + cat.Name; //catUc.Deselect(); //catUc.SetNameAndIdOfCategory(cat.Id, cat.Name, list, false); if (i == 0) { if (hidSelectedCategoryId.Value == "0") { //catUc.Select(); hidSelectedCategoryId.Value = cat.Id.ToString(); lblSelectedCategoryName.Text = cat.Name; if (CategorySelected != null) { CategorySelected(catLink, new IdAndNameEventArgs() { Id = cat.Id }); } } //else if (hidSelectedCategoryId.Value == cat.Id.ToString()) //{ // //InitialUpdateOfCourses(cat.Id, cat.Name); // //selectedAlready = true; //} } //else if (!selectedAlready) //{ // if (hidSelectedCategory.Value == cat.Id.ToString()) // { // InitialUpdateOfCourses(cat.Id, cat.Name); // selectedAlready = true; // } //} //catUc.NameClicked += catUc_NameClicked; //pnlCategories.Controls.Add(catUc); pnlCategories.Controls.Add(catLink); GetSubCategory(helper, schoolId, cat.Id, 1); list.RemoveAt(list.Count - 1); //var spaces = ""; //for (int j = 0; j < list.Count * 4; j++) //{ // spaces += " "; //} //var litem = new ListItem() { Text = cat.Name }; //litem.Attributes.Add("style", "background-color:#41f111");//"padding-left:"+(list.Count*4)+"px"); //ddlCategories.Items.Add(litem); i++; } } }
private void LoadCustomText() { try { #region Activity Resource var actResId = Request.QueryString["actResId"]; //var actOrRes = Request.QueryString["actOrRes"]; //var actOrResId = Request.QueryString["actOrResId"]; //var actResType = Request.QueryString["actResType"]; if (actResId != null)//actOrRes != null && actOrResId != null && actResType != null) { var displayType = ""; //var type = Convert.ToByte(actResType); //var aOrRId = Convert.ToInt32(actOrResId); using (var helper = new DbHelper.ActAndRes()) { var actRes = helper.GetActivityResource(Convert.ToInt32(actResId)); if (actRes != null) { if (Convert.ToBoolean(actRes.ActivityOrResource)) //activity { switch (actRes.ActivityResourceType - 1) { case (int)Enums.Activities.Assignment: //Assignment displayType = Enums.Activities.Assignment.ToString().ToLower(); break; case (int)Enums.Activities.Chat: //chat displayType = Enums.Activities.Chat.ToString().ToLower(); break; case (int)Enums.Activities.Forum: //forum displayType = Enums.Activities.Forum.ToString().ToLower(); break; case (int)Enums.Activities.Choice: displayType = Enums.Activities.Choice.ToString().ToLower(); break; case (int)Enums.Activities.Lession: //lession displayType = Enums.Activities.Lession.ToString().ToLower(); break; case (int)Enums.Activities.Wiki: //wiki displayType = Enums.Activities.Wiki.ToString().ToLower(); break; case (int)Enums.Activities.Workshop: //Workshop displayType = Enums.Activities.Workshop.ToString().ToLower(); break; } } else //resource { switch (actRes.ActivityResourceType - 1) { case (int)Enums.Resources.Book: //Book displayType = Enums.Resources.Book.ToString().ToLower(); break; case (int)Enums.Resources.File: //file displayType = Enums.Resources.File.ToString().ToLower(); break; case (int)Enums.Resources.Folder: displayType = Enums.Resources.Folder.ToString().ToLower(); break; case (int)(Enums.Resources.Label): displayType = Enums.Resources.Label.ToString().ToLower(); break; case (int)(Enums.Resources.Page): displayType = Enums.Resources.Page.ToString().ToLower(); break; case (int)(Enums.Resources.Url): displayType = Enums.Resources.Url.ToString().ToLower(); break; } } lblInfoText.Text = ("Are you sure to delete the " + displayType + ", " + actRes.Name + "?"); //DbHelper.StaticValues.Decode } } return; } #endregion #region Book chapter var chapterId = Request.QueryString["bcId"]; if (chapterId != null) { using (var helper = new DbHelper.ActAndRes()) { var chapter = helper.GetChapter(Convert.ToInt32(chapterId)); if (chapter != null) { lblInfoText.Text = "Are you sure to delete the chapter, " + chapter.Title + "?"; } return; } } #endregion #region Grade var gradeId = Request.QueryString["grdId"]; if (gradeId != null) { using (var helper = new DbHelper.Grade()) { var grade = helper.GetGrade(Convert.ToInt32(gradeId)); if (grade != null) { lblInfoText.Text = "Are you sure to delete the grade, " + grade.Name + "?"; } return; } } #endregion #region Notice var noticeId = Request.QueryString["nId"]; if (noticeId != null) { using (var helper = new DbHelper.Notice()) { var notice = helper.GetNotice(Convert.ToInt32(noticeId)); if (notice != null) { lblInfoText.Text = "Are you sure to delete the notice, " + notice.Title + "?"; } } return; } #endregion #region Academic year and SEssion var acaId = Request.QueryString["acaId"]; if (acaId != null) { using (var helper = new DbHelper.AcademicYear()) { var academic = helper.GetAcademicYear(Convert.ToInt32(acaId)); if (academic != null) { lblInfoText.Text = "Are you sure to delete the academic year, " + academic.Name + "?"; } return; } } var sessId = Request.QueryString["sessId"]; if (sessId != null) { using (var helper = new DbHelper.AcademicYear()) { var session = helper.GetSession(Convert.ToInt32(sessId)); if (session != null) { lblInfoText.Text = "Are you sure to delete the session, " + session.Name + "?"; } return; } } #endregion #region SubjectClass var subclsId = Request.QueryString["subclsId"]; if (subclsId != null) { using (var helper = new DbHelper.Classes()) { var cls = helper.GetSubjectSession(Convert.ToInt32(subclsId)); if (cls != null) { lblInfoText.Text = "Are you sure to delete the class, " + (cls.IsRegular ? cls.GetName : cls.Name) + "?"; } } return; } #endregion #region Course and Category var catId = Request.QueryString["catId"]; var crsId = Request.QueryString["crsId"]; //crsId should be null so it means that its category only if (catId != null && crsId == null) { using (var helper = new DbHelper.Subject()) { var category = helper.GetCategory(Convert.ToInt32(catId)); if (category != null) { lblInfoText.Text = "Are you sure to delete the category, " + category.Name + "?"; } } return; } #endregion } catch { } }
protected void btnSave_Click(object sender, EventArgs e) { //if (cmbCategory.SelectedValue == "" || cmbCategory.SelectedValue == "0" || cmbCategory.SelectedValue == "-1") //{ // RequiredFieldValidator1.IsValid = false; //} var user = Page.User as CustomPrincipal; if (user != null) { if (Page.IsValid) { var credit = txtCredit.Text; Subject subject = new Subject() { Id = SubjectId, FullName = txtName.Text, ShortName = txtShortName.Text, Code = txtCode.Text, //HasTheory = chkListHas.Items[0].Selected, //HasLab = chkListHas.Items[1].Selected, //HasTutorial = chkListHas.Items[2].Selected, //HasProject = chkListHas.Items[3].Selected, //IsElective = chkListIs.Items[0].Selected, //IsOutOfSyllabus = chkListIs.Items[1].Selected, CreatedDate = DateTime.Now.Date, CreatedById = user.Id, //IsActive = ckhIsActive.Checked //, //SubjectCategoryId = Convert.ToInt32(cmbCategory.SelectedValue) SubjectCategoryId = CategoryId }; //if (string.IsNullOrEmpty(txtCredit.Text)) //{ // subject.Credit = Convert.ToByte(txtCode.Text == "" ? "0" : txtCode.Text); //} //if (!String.IsNullOrEmpty(txtFullMarks.Text)) //{ // subject.FullMarks = Convert.ToInt32(txtFullMarks.Text); //} //if (!string.IsNullOrEmpty(txtPassPercent.Text)) //{ // subject.PassPercentage = Convert.ToByte(txtPassPercent.Text); //} //if (!string.IsNullOrEmpty(txtCompletionHours.Text)) //{ // subject.CompletionHours = Convert.ToInt16(txtCompletionHours.Text); //} using (var helper = new DbHelper.Subject()) { var saved = helper.AddOrUpdateSubject(subject); //Response.Redirect("~/Views/Course/"); if (SaveClicked != null) { if (saved) { SaveClicked(this, DbHelper.StaticValues.SuccessSaveMessageEventArgs); } else { SaveClicked(this, DbHelper.StaticValues.ErrorSaveMessageEventArgs); } } } } } }
public void LoadCourses() { var date = DateTime.Now; var count = 0; using (var aHelper = new DbHelper.ActAndRes()) using (var helper = new DbHelper.Subject()) using (var clsHelper = new DbHelper.Classes()) { try { //aHelper.ListActivitiesAndResourcesOfSection() var fromDashboard = FromDashboard; var user = Page.User as CustomPrincipal; if (user != null) { //var subjects = helper.GetCurrentRegularSubjectsOfUser(user.Id); //var subjectsArray = helper.ListCurrentAndEarlierCoursesOfUser(user.Id); List <Academic.DbEntities.Subjects.Subject> subjectsArray; bool earlier = false; if (hidLoadType.Value == "earlier") { earlier = true; var subArray = helper.GetEarlierAndCurrentCourseAndClassesForManagerAndTeacherV3(user.Id, false); subjectsArray = subArray[1];//.Keys.ToList(); //subjectsArray = helper.ListEarlierSubjectClasses(user.Id) // .Select(x => (x.IsRegular) ? x.SubjectStructure.Subject : x.Subject).ToList(); } else { var subArray = helper.GetEarlierAndCurrentCourseAndClassesForManagerAndTeacherV3(user.Id, true); subjectsArray = subArray[0];//.Keys.ToList(); //subjectsArray = helper.ListCurrentSubjectClasses(user.Id) // .Select(x => (x.IsRegular) ? x.SubjectStructure.Subject : x.Subject).ToList(); } //foreach (var c in subjects[loadType]) //foreach (var c in subjectsArray[loadType]) foreach (var c in subjectsArray.Distinct()) { //if (!lblHeading.Visible && fromDashboard) //{ // lblHeading.Visible = true; //} CourseUc uc = (CourseUc)Page.LoadControl("~/ViewsSite/DashBoard/Student/CourseOverView/CourseUc.ascx"); var navigationUrl = "~/Views/Course/Section/?SubId=" + c.Id; uc.TitleNavigationTarget = navigationUrl; uc.Id = c.FullName + "_" + c.Id; uc.Title = c.FullName; //classes calculation var userclasses = clsHelper.GetCurrentUserClassesOfUser(c.Id, user.Id); //var clsIds = classes.Select(x => x.SubjectClass.Id).ToList(); var roles = user.GetRoles(); var elligible = false; //Context.UserClass.Any(x=>x.subje) // var roles = user.GetRoles().Select(x => x.Role.RoleName).ToList(); //if () { elligible = user.IsElligibleForManagement; //roles.Contains(DbHelper.StaticValues.Roles.CourseEditor.ToString()) // || roles.Contains(DbHelper.StaticValues.Roles.Manager.ToString()) // || roles.Contains(DbHelper.StaticValues.Roles.Admin.ToString()) // || roles.Contains("teacher"); } var enterSubject = false; //Messages //Restriction calculation is not done yet if (!earlier) { foreach (var sec in c.SubjectSections.AsEnumerable().Where(x => !(x.Void ?? false))) { var canView = elligible; if (!canView) { canView = aHelper.EvaluateRestriction(null, sec.Restriction, user.Id); } if (canView) // { foreach (var act in sec.ActivityResources.AsEnumerable() .Where(x => x.ActivityOrResource && !(x.Void ?? false)))//only activity { if (!elligible) { canView = aHelper.EvaluateRestriction(null, act.Restriction, user.Id); } if (canView) // { foreach (var ac in act.ActivityClasses) { //ac.ActivityResourceViews.Where(x=>x.) var usrCls = userclasses.FirstOrDefault(x => x.SubjectClassId == ac.SubjectClassId); if (usrCls != null) { //check for activity view var viewed = ac.ActivityResourceViews.FirstOrDefault(a => a.UserClassId == usrCls.Id); //!cls.ActivityResourceViews.ToList().Exists(x => x.UserClassId == classMatch.Id) if (!(user.IsInRole("manager") || user.IsInRole("teacher"))) { if (viewed != null) { if ((date - viewed.ViewedDate).TotalDays < 1) { enterSubject = true; var cuc = (CourseMessageUC) Page.LoadControl("~/ViewsSite/DashBoard/Student/CourseOverView/CourseMessageUC.ascx"); var thisIcon = ActivityResourceValues.RetriveMethod(actOrRes: true, actResType: (byte)(act.ActivityResourceType)); if (thisIcon != null) { cuc.ImageLink = thisIcon.IconPath; cuc.Text = @"You have new """ + (thisIcon.Name) + @""""; cuc.NavigateUrl = navigationUrl + "#section_" + sec.Id; cuc.ToolTip = act.Name; uc.AddMessages(cuc); //if (fromDashboard) //{ // if (!pnlCourseList.Visible) // { // pnlCourseList.Visible = true; // } //} } break; } } else //(!ac.ActivityResourceViews.ToList().Exists(x => x.UserClassId == usrCls.Id))// && x.ActivityClassId == ac.Id) { //then don't display enterSubject = true; var cuc = (CourseMessageUC) Page.LoadControl("~/ViewsSite/DashBoard/Student/CourseOverView/CourseMessageUC.ascx"); //var thisType = Enum.GetNames(typeof(Enums.Activities))[act.ActivityResourceType-1]; var thisIcon = ActivityResourceValues.RetriveMethod(actOrRes: true, actResType: (byte)(act.ActivityResourceType)); if (thisIcon != null) { cuc.ImageLink = thisIcon.IconPath; cuc.Text = "You have new \"" + (thisIcon.Name) + "\""; //cuc.NavigateUrl = thisIcon.ViewUrl // + "?SubId=" + c.Id + // "&arId=" + act.ActivityResourceId + // "&secId=" + sec.Id + // "&edit=0"; cuc.NavigateUrl = navigationUrl + "#section_" + sec.Id; cuc.ToolTip = act.Name; uc.AddMessages(cuc); } break; } } #region Submission //var actres = ahelper.GetActivityResource(true // , (byte)(Enums.Activities.Assignment + 1), AssignmentId); if (usrCls.Role.RoleName == "teacher" || usrCls.Role.RoleName == "manager") { if (act.ActivityOrResource && act.ActivityResourceType == (byte)(Enums.Activities.Assignment + 1) && !(act.Void ?? false)) { //then its assignment .. check for new submission var ass = aHelper.GetAssignment(act.ActivityResourceId); if (ass != null) { //its definitely assignment var users = ass.Submissions.Count; //.OrderByDescending(x => x.SubmittedDate).Select(x => x.UserClassId).ToList(); var gradings = act.ActivityGradings.Count; //.Select(x=>x.UserClassId).ToList(); //var anyUnGraded = act.ActivityGradings.Any(x => // !users.Contains(x.UserClassId)); if (users > gradings) { enterSubject = true; var cuc = (CourseMessageUC)Page.LoadControl ("~/ViewsSite/DashBoard/Student/CourseOverView/CourseMessageUC.ascx"); var thisIcon = ActivityResourceValues.AssignmentActivity(); //ActivityResourceValues.RetriveMethod(actOrRes: true, actResType: (byte)(act.ActivityResourceType)); if (thisIcon != null) { cuc.ImageLink = "~/Content/Icons/ActivityResource/Assignment/document_submit_icon.png"; //thisIcon.IconPath; cuc.Text = "You have new Submission"; //+ (thisIcon.Name); cuc.NavigateUrl = navigationUrl + "#section_" + sec.Id; cuc.ToolTip = act.Name; uc.AddMessages(cuc); } break; } } } } #endregion } } } } } //Messages list } } if (!fromDashboard) { this.pnlCourseList.Controls.Add(uc); count++; } else { if (enterSubject) { if (!lblHeading.Visible) { lblHeading.Visible = fromDashboard; } this.pnlCourseList.Controls.Add(uc); count++; } } } } } catch (Exception e) { } } this.Visible = count != 0; }