public static List<menuItem> getAllItems() {
List<menuItem> items = null;
using (SqlConnection con = connectionManager.getConnection()) {
SqlCommand com = new SqlCommand("getAllItems", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
try {
con.Open();
SqlDataReader reader = com.ExecuteReader();
if (reader.HasRows) {
items = new List<menuItem>();
while (reader.Read()) {
menuItem item = new menuItem();
item.id = Convert.ToInt32(reader["id"]);
item.pageName = reader["pageName"].ToString();
item.orderNrInParent = Convert.ToInt32(reader["orderNrInParent"]);
item.text = reader["itemText"].ToString();
item.parentID = Convert.ToInt32(reader["parentID"]);
items.Add(item);
};
};
} catch { throw; };
}
return items;
}
public static List<menuItem> getItemsForGroup(int groupID) {
List<menuItem> items = null;
using (SqlConnection con = connectionManager.getConnection()) {
SqlCommand com = new SqlCommand("getItemsForGroup", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@groupID", groupID);
try {
con.Open();
SqlDataReader reader = com.ExecuteReader();
if (reader.HasRows) {
items = new List<menuItem>();
while (reader.Read()) {
menuItem item = new menuItem();
item.id = Convert.ToInt32(reader["id"]);
item.pageName = reader["pageName"].ToString();
item.orderNrInParent = Convert.ToInt32(reader["orderNrInParent"]);
item.text = reader["itemText"].ToString();
item.color = "Black";
item.parentID = Convert.ToInt32(reader["parentID"]);
item.rights = new menuItemRights(reader["rights"].ToString());
items.Add(item);
};
};
} catch { throw; };
}
return items;
}
private void init(object sender,RoutedEventArgs e) {
List<bo.menuItem> parentList = dbItems.getAllItems();
bo.menuItem dummyTopItem = new bo.menuItem() { id = 0, text = "is top item" };
parentList.Insert(0, dummyTopItem);
cmbParents.DataContext = parentList;
txtText.DataContext = menuItem;
txtOrderInParent.DataContext = menuItem;
txtPageName.DataContext = menuItem;
}
// helpers
private void clearItem() {
menuItem = new bo.menuItem();
init(this, new RoutedEventArgs());
}
private string getItemPath(menuItem item, string path = "") {
if (string.IsNullOrEmpty(path)) {
path = item.text;
} else {
path = item.text + " -> " + path;
};
if (item.parentID > 0) {
menuItem parent = getMenuItemWithID(currentTreeviewItems, item.parentID);
path = getItemPath(parent, path);
};
return path;
}
private void handleParents(menuItem checkedItem, CheckBox checkbox, RoutedEventArgs e) {
if (checkedItem.parentID > 0) {
menuItem parent = getMenuItemWithID(currentTreeviewItems, checkedItem.parentID);
parent.rights.isVisible = true;
e.Source = checkedItem.parentID;
checkboxClickHandler(checkbox, e);
};
}
private void handleItemChanges(menuItem item, menuItem originalItem) {
if (item.Equals(originalItem))
itemsThatWereAdapted.Remove(item);
else
if (itemsThatWereAdapted.IndexOf(item) > -1) { itemsThatWereAdapted.Remove(item); };
itemsThatWereAdapted.Add(item);
}
