public static IList<TblItems> ItemsOfOrganization(TblOrganizations org) { return ServerModel.DB.Query<TblItems>(new CompareCondition<int>( DataObject.Schema.OrganizationRef, new ValueCondition<int>(org.ID), COMPARE_KIND.EQUAL)); }
public static IList <TblPermissions> AllPermissionsForOrganization(TblOrganizations organization) { return(ServerModel.DB.Query <TblPermissions>( new CompareCondition <int>( DataObject.Schema.OrganizationRef, new ValueCondition <int>(organization.ID), COMPARE_KIND.EQUAL))); }
private void AddOrganizationToTable(TblOrganizations org, int i) { var row = new TableRow { ID = org.ID.ToString() }; var number = new TableCell { Text = i.ToString(), HorizontalAlign = HorizontalAlign.Center }; var name = new TableCell { Text = org.Title, HorizontalAlign = HorizontalAlign.Center }; //var type = new TableCell { Text = theme.IsControl.ToString(), HorizontalAlign = HorizontalAlign.Center }; //var pageOrder = new TableCell { HorizontalAlign = HorizontalAlign.Center }; //pageOrder.Controls.Add(GetPageOrderDropDownList(theme.PageOrderRef)); //var pageCountToShow = new TableCell { HorizontalAlign = HorizontalAlign.Center }; //pageCountToShow.Controls.Add(GetPageCountToShowDropDownList(theme)); //var maxCountToSubmit = new TableCell { HorizontalAlign = HorizontalAlign.Center }; //maxCountToSubmit.Controls.Add(GetMaxCountToSubmitDropDownList(theme.MaxCountToSubmit)); /* var themePages = new TableCell(); themePages.Controls.Add(new HyperLink { Text = "Pages", NavigateUrl = ServerModel.Forms.BuildRedirectUrl(new ThemePagesController { BackUrl = string.Empty, ThemeId = theme.ID }) }); */ //row.Cells.AddRange(new[] { number, name, type, pageOrder, pageCountToShow, maxCountToSubmit, themePages }); row.Cells.AddRange(new[] { number, name }); CourseBehaviorTable.Rows.Add(row); }
void Initialize() { TblCourses course = new TblCourses { Name = "course" }; ServerModel.DB.Insert(course); TblOrganizations organisation = new TblOrganizations { CourseRef = course.ID, Title = "organisation" }; ServerModel.DB.Insert(organisation); TblResources resource = new TblResources { CourseRef = course.ID, Type = "bob", Identifier = "resource" }; ServerModel.DB.Insert(resource); TblItems item = new TblItems { OrganizationRef = organisation.ID, ResourceRef = resource.ID, Title = "item" }; ServerModel.DB.Insert(item); TblLearnerAttempts attempt = new TblLearnerAttempts { //bug with foreign keys! }; ServerModel.DB.Insert(attempt); TblLearnerSessions session = new TblLearnerSessions { ItemRef = item.ID, LearnerAttemptRef = attempt.ID }; ServerModel.DB.Insert(session); currentSession = session; TblUsers user = GetUniqueUserForTesting(); ServerModel.DB.Insert(user); sessionID = session.ID; userID = user.ID; }
public void AddThemeButton_Click() { if (CourseTree.CheckedNodes.Count == 0) { Message.Value = noThemesSelected; return; } IdendtityNode stageNode = CurriculumTree.SelectedNode as IdendtityNode; Message.Value = alreadyHaveTheme.Replace("{0}", stageNode.Text); bool alreadyHaveSomeTheme = false; for (int i = 0; i < CourseTree.CheckedNodes.Count; i++) { IdendtityNode orgNode = CourseTree.CheckedNodes[i] as IdendtityNode; if (TeacherHelper.StageContainsTheme(stageNode.ID, orgNode.ID)) { Message.Value += orgNode.Text + ", "; alreadyHaveSomeTheme = true; } else { TblOrganizations org = ServerModel.DB.Load <TblOrganizations>(orgNode.ID); TblThemes t = new TblThemes { Name = org.Title, CourseRef = org.CourseRef, OrganizationRef = org.ID, StageRef = stageNode.ID }; ServerModel.DB.Insert(t); /*ServerModel.DB.Link( * ServerModel.DB.Load<TblStages>(stageNode.ID), * ServerModel.DB.Load<TblThemes>(t.ID));*/ stageNode.ChildNodes.Add(new IdendtityNode(ServerModel.DB.Load <TblThemes>(t.ID))); } CourseTree.CheckedNodes[i].Checked = false; i--; } if (alreadyHaveSomeTheme) { Message.Value = Message.Value.Remove(Message.Value.Length - 2) + "."; } else { Message.Value = string.Empty; } }
public static IList <TblItems> LeafItemsOfOrganization(TblOrganizations org) { return(ServerModel.DB.Query <TblItems>( new AndCondition( new CompareCondition <int>( DataObject.Schema.OrganizationRef, new ValueCondition <int>(org.ID), COMPARE_KIND.EQUAL), new CompareCondition <bool>( DataObject.Schema.IsLeaf, new ValueCondition <bool>(true), COMPARE_KIND.EQUAL)))); }
private static int Store(int courseID, string title) { TblOrganizations t = new TblOrganizations { CourseRef = courseID, Title = title }; ServerModel.DB.Insert(t); return(t.ID); }
private static int Store(int courseID, string title) { TblOrganizations t = new TblOrganizations { CourseRef = courseID, Title = title }; ServerModel.DB.Insert(t); return t.ID; }
public static bool StageContainsTheme(int stageID, int orgID) { TblStages stage = ServerModel.DB.Load <TblStages>(stageID); TblOrganizations org = ServerModel.DB.Load <TblOrganizations>(orgID); foreach (TblThemes childThemes in TeacherHelper.ThemesOfStage(stage)) { if (childThemes.OrganizationRef == org.ID) { return(true); } } return(false); }
private void AddOrganizationToTable(TblOrganizations org, int i) { var row = new TableRow { ID = org.ID.ToString() }; var number = new TableCell { Text = i.ToString(), HorizontalAlign = HorizontalAlign.Center }; var name = new TableCell { Text = org.Title, HorizontalAlign = HorizontalAlign.Center }; //var type = new TableCell { Text = theme.IsControl.ToString(), HorizontalAlign = HorizontalAlign.Center }; //var pageOrder = new TableCell { HorizontalAlign = HorizontalAlign.Center }; //pageOrder.Controls.Add(GetPageOrderDropDownList(theme.PageOrderRef)); //var pageCountToShow = new TableCell { HorizontalAlign = HorizontalAlign.Center }; //pageCountToShow.Controls.Add(GetPageCountToShowDropDownList(theme)); //var maxCountToSubmit = new TableCell { HorizontalAlign = HorizontalAlign.Center }; //maxCountToSubmit.Controls.Add(GetMaxCountToSubmitDropDownList(theme.MaxCountToSubmit)); /* * var themePages = new TableCell(); * themePages.Controls.Add(new HyperLink * { * Text = "Pages", * NavigateUrl = ServerModel.Forms.BuildRedirectUrl(new ThemePagesController * { * BackUrl = string.Empty, * ThemeId = theme.ID * }) * }); */ //row.Cells.AddRange(new[] { number, name, type, pageOrder, pageCountToShow, maxCountToSubmit, themePages }); row.Cells.AddRange(new[] { number, name }); CourseBehaviorTable.Rows.Add(row); }
public void PageLoad(object sender, EventArgs e) { if (HttpContext.Current.Session["CurrentLearnerAttemptId"] == null) { throw new Exception(Translations.OpenTestController_PageLoad_Wrong_request__LearnerAttempt_ID_not_specified_); } learnerAttemptId = Convert.ToInt32(HttpContext.Current.Session["CurrentLearnerAttemptId"].ToString()); attempt = ServerModel.DB.Load <TblLearnerAttempts>(learnerAttemptId); theme = ServerModel.DB.Load <TblThemes>(attempt.ThemeRef); org = ServerModel.DB.Load <TblOrganizations>(theme.OrganizationRef); if (isNew) { items = TeacherHelper.LeafItemsOfOrganization(org).ToList(); items = MixList <TblItems>(items); isNew = false; } items = items.GetRange(0, items.Count > 20 ? 20 : items.Count); ShowCurrent(); }
public IdendtityNode(TblOrganizations org) : this(org.Title, org.ID) { Type = NodeType.Organization; }
public static IList<TblPermissions> AllPermissionsForOrganization(TblOrganizations organization) { return ServerModel.DB.Query<TblPermissions>( new CompareCondition<int>( DataObject.Schema.OrganizationRef, new ValueCondition<int>(organization.ID), COMPARE_KIND.EQUAL)); }