public IList <T> GetByForeignKey(string key, Int64 value, string sortKey, MPRController.Direction direction)
{
MPRSession session = MPRController.StartSession();
IList <T> items = MPRController.RetrieveByForeignKey <T>(session, key, value, sortKey, direction);
MPRController.EndSession(session, true);
return(items);
}
public void TestForeignKey()
{
MPRSession session = MPRController.StartSession();
IList <MPItemVersion> versions =
MPRController.RetrieveByForeignKey <MPItemVersion>(session, "Item", 11);
foreach (MPItemVersion version in versions)
{
System.Console.WriteLine("{0} : {1}", version.Version, version.UpdateDate);
}
MPRController.EndSession(session, true);
}
public void GetCategoriesForType()
{
Int64 typeId = 4;
MPRSession session = MPRController.StartSession();
IList <MPCategory> categories = MPRController.RetrieveByForeignKey <MPCategory>(session, "Type", typeId);
foreach (MPCategory category in categories)
{
System.Console.WriteLine("{0}:{1}:{2};", category.Id, category.Name, category.Description);
}
MPRController.EndSession(session, true);
}
public string GetCategories(Int64 typeId)
{
MPRSession session = MPRController.StartSession();
IList <MPCategory> categories = MPRController.RetrieveByForeignKey <MPCategory>(session, "Type", typeId);
string result = "";
foreach (MPCategory category in categories)
{
result += System.String.Format("{0}:{1}:{2};", category.Id, category.Name, category.Type);
}
MPRController.EndSession(session, true);
return(result);
}
protected void FillCategoriesForSelectedItemType(MPRSession session)
{
if (typesList.SelectedValue == null)
{
return;
}
// Remove the previous categories
categoriesList.Items.Clear();
// Fill the categories for the selected type
Int64 typeId;
Int64.TryParse(typesList.SelectedValue, out typeId);
IList <MPCategory> categories = MPRController.RetrieveByForeignKey <MPCategory>(session, "Type", typeId);
foreach (MPCategory category in categories)
{
categoriesList.Items.Add(new ListItem(category.Name, category.Id.ToString()));
}
}