private void button1_Click(object sender, EventArgs e) {
if(textBox1.Text == String.Empty || textBox2.Text == String.Empty) {
MessageBox.Show("Please, fill all fields");
return;
}
try {
using(var objProvider = new MailProvider()) {
Group objReceiverGroup = objProvider.GetGroupById(iNodeId);
if(objReceiverGroup == null) {
throw new ArgumentException("Cant find group with current ID: " + iNodeId);
}
var objReciever = new Receiver();
objReciever.Name = textBox1.Text;
objReciever.Email = textBox2.Text;
objReciever.Group = objReceiverGroup;
objProvider.AddReceiver(objReciever);
}
this.Close();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// send Email method
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
//create Email
if(textBox8.Text == String.Empty || richTextBox2.Text == String.Empty) {
throw new ArgumentNullException("Fill all fields!");
}
//if selected node is Group
Group objGroup = objProvider.GetGroup((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
Receiver objReceiver = objProvider.GetReceiver((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
if(objGroup != null) {
foreach(var receiver in objGroup.Receivers) {
var objEmail = new Email() {
Receiver = receiver,
Text = richTextBox2.Text,
Header = textBox8.Text,
SendingTime = DateTime.Now
};
objProvider.AddEmail(objEmail);
SendEmail(objEmail);
}
}
//if receiver
if(objReceiver != null) {
var objEmail = new Email() {
Receiver = objReceiver,
Text = richTextBox2.Text,
Header = textBox8.Text,
SendingTime = DateTime.Now
};
objProvider.AddEmail(objEmail);
SendEmail(objEmail);
}
}
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Get Receiver object by Id and Name
/// </summary>
/// <param name="iId"></param>
/// <param name="strName"></param>
/// <returns></returns>
/// <summary>
/// Get Group object by Id and Name
/// </summary>
/// <returns></returns>
/// <summary>
/// redrawable TreeView
/// </summary>
private void UpdateTree() {
//create TreeView
using(var objProvider = new MailProvider()) {
Group objRootNode = objProvider.Base.Groups.OrderBy(c => c.Id).FirstOrDefault();
if(objRootNode == null) {
return;
}
treeView1.Nodes.Clear();
var objVisualRootNode = new TreeNode {
Tag = objRootNode.Id,
Name = objRootNode.Name,
Text = objRootNode.Name
};
treeView1.Nodes.Add(objVisualRootNode);
CreateTreeView(objRootNode, objVisualRootNode);
treeView1.ExpandAll();
treeView1.SelectedNode = objVisualRootNode;
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) {
try {
using(var objProvider = new MailProvider()) {
List<Email> objEmails = objProvider.Base.Emails.Where(em => em.SendingTime <= DateTime.Now && em.Sended == false).ToList();
foreach(var email in objEmails) {
SendEmail(email);
}
}
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void UpdateListBox1() {
using(var objProvider = new MailProvider()) {
listBox1.Items.Clear();
Receiver objReceiver = objProvider.GetReceiver((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
List<Email> objEmails = objProvider.GetEmailsByReceiverId(objReceiver.Id);
if(objEmails.Count != 0) {
listBox1.Items.AddRange(objEmails.ToArray());
listBox1.SelectedIndex = 0;
}
}
}
/// <summary>
/// Show info about selected email
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
var objTempEmail = (Email)listBox1.SelectedItem;
Email objEmail = objProvider.GetEmailById(objTempEmail.Id);
if(objEmail == null) {
return;
}
textBox10.Text = objEmail.SendingTime.ToString("dd-MM-yyyy ddd HH:mm");
richTextBox3.Text = objEmail.Text;
textBox9.Text = objEmail.Header;
if(objEmail.Sended) {
label18.ForeColor = Color.DarkGreen;
label18.Text = "Sended";
}
else {
label18.ForeColor = Color.DarkOrange;
label18.Text = "Awaits for sending";
}
}
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Sort Emails by sended flag
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
Receiver objReceiver = objProvider.GetReceiver((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
if(objReceiver == null) {
return;
}
List<Email> objEmails = objProvider.GetEmailsByReceiverId(objReceiver.Id);
listBox1.Items.Clear();
if(objEmails.Count != 0) {
listBox1.Items.AddRange(objEmails.ToArray());
}
}
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// delete group and all child nodes
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ToolStripMenuItem3_Click(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
//get parent group node
Group objParentGroup = objProvider.GetGroup((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
//get receiver node
Receiver objReceiver = objProvider.GetReceiver((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
//if selected is receiver node
if(objReceiver != null) {
objProvider.RemoveReceiver(objReceiver);
}
//if selected is group parent node
if(objParentGroup != null) {
//get all childs Recievers
List<Group> objChildsToDeleteList = objProvider.Base.Groups.
Where(gr => gr.LeftKey >= objParentGroup.LeftKey && gr.RightKey <= objParentGroup.RightKey).ToList();
//delete all childs
foreach(var node in objChildsToDeleteList) {
List<Receiver> objReceiversList = objProvider.Base.Receivers.Where(r => r.Group.Id == node.Id).ToList();
for(int iJ = 0; iJ < objReceiversList.Count; ++iJ) {
objProvider.RemoveReceiver(objReceiversList[iJ]);
}
objProvider.RemoveGroup(node);
}
//update parent branch
List<Group> objParentsList = objProvider.Base.Groups.Where(gr => gr.RightKey > objParentGroup.RightKey && gr.LeftKey < objParentGroup.LeftKey).ToList();
foreach(var node in objParentsList) {
node.RightKey = node.RightKey - (objParentGroup.RightKey - objParentGroup.LeftKey + 1);
}
//update other childs
List<Group> objChildList = objProvider.Base.Groups.Where(gr => gr.LeftKey > objParentGroup.RightKey).ToList();
foreach(var node in objChildList) {
node.LeftKey = node.LeftKey - (objParentGroup.RightKey - objParentGroup.LeftKey + 1);
node.RightKey = node.RightKey - (objParentGroup.RightKey - objParentGroup.LeftKey + 1);
}
}
}
UpdateTree();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// get info about node
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) {
try {
treeView1.SelectedNode = e.Node;
if(e.Button == MouseButtons.Right) {
contextMenuStrip1.Show();
}
using(var objProvider = new MailProvider()) {
Receiver objReceiver = objProvider.GetReceiver((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
Group objGroup = objProvider.GetGroup((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
comboBox2.Items.Clear();
comboBox2.Items.AddRange(objProvider.GetAllGroups().ToArray());
listBox1.Items.Clear();
richTextBox1.Clear();
//clear MailList fields
textBox10.Clear();
textBox9.Clear();
richTextBox3.Clear();
label18.Text = String.Empty;
//if node is receiver
if(objReceiver != null) {
comboBox2.SelectedItem = objReceiver.Group;
textBox1.Text = objReceiver.Name;
textBox2.Text = objReceiver.Email;
richTextBox1.Text = String.Format("{0}: {1}\n", objReceiver.Name, objReceiver.Email);
UpdateListBox1();
textBox1.Enabled = true;
textBox2.Enabled = true;
textBox3.Enabled = false;
textBox3.Clear();
button4.Enabled = false;
}
//if group
if(objGroup != null) {
comboBox2.SelectedItem = objGroup;
textBox3.Text = objGroup.Name;
List<Receiver> objrReceivers = objProvider.GetReceiversByGroupId(objGroup.Id);
foreach (var receiver in objrReceivers)
{
richTextBox1.Text += String.Format("{0}: {1}\n", receiver.Name, receiver.Email);
}
textBox3.Enabled = true;
textBox1.Clear();
textBox1.Enabled = false;
textBox2.Clear();
textBox2.Enabled = false;
button4.Enabled = true;
}
}
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Delete Email from listBox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button7_Click(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
var objTempEmail = (Email)listBox1.SelectedItem;
objProvider.RemoveEmailById(objTempEmail.Id);
label18.Text = String.Empty;
textBox10.Clear();
textBox9.Clear();
richTextBox3.Clear();
}
UpdateListBox1();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// this method create TreeView from NestedSetsTree
/// </summary>
/// <param name="objLogicNode">node of NestedSetsTree</param>
/// <param name="objVisualNode">node of TreeView</param>
private void CreateTreeView(Group objLogicNode, TreeNode objVisualNode) {
using(var objProvider = new MailProvider()) {
//выборка всех recievers котоыре принадлежат к текущей группе
List<Receiver> objReceivers = objProvider.GetReceiversByGroupId(objLogicNode.Id);
foreach(var reciever in objReceivers) {
var objNewTreeNode = new TreeNode() {
Tag = reciever.Id,
Name = reciever.Name,
Text = reciever.Name
};
objVisualNode.Nodes.Add(objNewTreeNode);
}
//выбор подчиненных узлов на первом уровне, т.е на всех непосредсвенных детей родительского узла
//SELECT id, name, level FROM my_tree WHERE left_key >= $left_key AND right_key <= $right_key ORDER BY left_key
var objChildNodes = objProvider.Base.Groups.
Where(gr => gr.LeftKey > objLogicNode.LeftKey && gr.RightKey < objLogicNode.RightKey && gr.Level == objLogicNode.Level + 1).
OrderBy(b => b.LeftKey).
ToList();
//add all childs on one level
foreach(var node in objChildNodes) {
var objNewTreeNode = new TreeNode() {
Tag = node.Id,
Name = node.Name,
Text = node.Name,
};
objVisualNode.Nodes.Add(objNewTreeNode);
CreateTreeView(node, objNewTreeNode);
}
}
}
/// <summary>
/// Update current Email info
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button6_Click(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
var objTempEmail = (Email)listBox1.SelectedItem;
Email objEmail = objProvider.GetEmailById(objTempEmail.Id);
if(objEmail == null) {
throw new ArgumentNullException("Cant find email with Id=" + objTempEmail.Id);
}
objEmail.Text = richTextBox3.Text;
objEmail.Header = textBox9.Text;
}
UpdateListBox1();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// add email to schedule
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button5_Click(object sender, EventArgs e) {
try {
if(textBox8.Text == String.Empty || richTextBox2.Text == String.Empty) {
throw new ArgumentNullException("Fill all fileds");
}
using(var objProvider = new MailProvider()) {
var objEmail = new Email() {
Header = textBox8.Text,
Text = richTextBox2.Text,
SendingTime = GetTime(),
Sended = false,
Receiver = objProvider.GetReceiver((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name)
};
objProvider.AddEmail(objEmail);
}
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
/// <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);
}
}
/// <summary>
/// change receiver info
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e) {
try {
using(var objProvider = new MailProvider()) {
Receiver objReceiver = objProvider.GetReceiver((int)treeView1.SelectedNode.Tag, treeView1.SelectedNode.Name);
if(objReceiver != null) {
if(textBox1.Text == String.Empty || textBox2.Text == String.Empty) {
throw new ArgumentNullException("Receiver.Name or Receiver.Email");
}
objReceiver.Name = textBox1.Text;
objReceiver.Email = textBox2.Text;
objReceiver.Group = objProvider.GetGroupByName(comboBox2.SelectedItem.ToString());
//clear fileds
textBox1.Clear();
textBox2.Clear();
}
}
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);
}
}