/// <summary>
/// change group info
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button4_Click(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
Group objGroup = objProvider.GetGroupByName(comboBox2.SelectedItem.ToString());
if(objGroup != null) {
if(textBox3.Text == String.Empty) {
throw new ArgumentNullException("Group Name");
}
objGroup.Name = textBox3.Text;
objProvider.SaveChanges();
comboBox2.Items.Clear();
comboBox2.Items.AddRange(objProvider.GetAllGroups().ToArray());
}
}
UpdateTree();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e) {
if(textBox1.Text == String.Empty) {
MessageBox.Show("Please, fill all fields");
return;
}
try {
using(var objProvider = new MailProvider()) {
Group objFirstGroup = objProvider.Base.Groups.OrderBy(c => c.Id).FirstOrDefault();
//if no one nodes in base
if(objFirstGroup == null) {
objFirstGroup = new Group() {
Name = textBox1.Text,
LeftKey = 1,
RightKey = 2,
Level = 0
};
objProvider.Base.Groups.Add(objFirstGroup);
objProvider.SaveChanges();
}
else {
Group objParentNode = objProvider.GetGroupById(iNodeId);
//Обновляем ключи существующего дерева, узлы стоящие за родительским узлом:
//UPDATE my_tree SET left_key = left_key + 2, right_ key = right_ key + 2 WHERE left_key > $right_ key
var objResultList = objProvider.Base.Groups.Where(group => group.LeftKey > objParentNode.RightKey).
ToList();
foreach(var gr in objResultList) {
gr.LeftKey += 2;
gr.RightKey += 2;
}
objProvider.SaveChanges();
//Обновляем родительскую ветку:
//UPDATE my_tree SET right_key = right_key + 2 WHERE right_key >= $right_key AND left_key < $right_key
objResultList = objProvider.Base.Groups.Where(group => group.RightKey >= objParentNode.RightKey && group.LeftKey < objParentNode.RightKey).ToList();
foreach(var gr in objResultList) {
gr.RightKey += 2;
}
objProvider.SaveChanges();
//Теперь добавляем новый узел :
//INSERT INTO my_tree SET left_key = $right_key, right_key = $right_key + 1, level = $level + 1[дополнительные параметры]
var objNewNode = new Group() {
Name = textBox1.Text,
LeftKey = objParentNode.RightKey - 2,
RightKey = objParentNode.RightKey - 1,
Level = objParentNode.Level + 1
};
objProvider.AddGroup(objNewNode);
objProvider.SaveChanges();
}
}
this.Close();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}