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;
}
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 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));
}
public IdendtityNode(TblOrganizations org)
: this(org.Title, org.ID)
{
Type = NodeType.Organization;
}
