public void AddRecieverGroup(ReceiverGroup _group)
{
//groups.Add(_group);
string query = "Insert into groups (group_name , description, root_group_id) VALUES ('" + _group.title + "', '" + _group.description + "', " + _group.root + ")";
Database.con.Insert(query);
}
public List <ReceiverGroup> getReceiverGroups()
{
string query = "Select * from groups";
List <List <string> > l = con.Select(query);
List <ReceiverGroup> groupList = new List <ReceiverGroup>();
for (int i = 0; i < l.Count; i++)
{
ReceiverGroup nextGroup = new ReceiverGroup(Convert.ToInt32(l[i][0]), l[i][1], l[i][2], Convert.ToInt32(l[i][3]));
groupList.Add(nextGroup);
}
return(groupList);
}
private void GroupsDropDown_SelectedIndexChanged(object sender, EventArgs e)
{
selectedGroup = groups[GroupsDropDown.SelectedIndex];
receivers = Database.getDatabase().GetReceiversOfGroup(selectedGroup.id);
if (ReceiversDropDown.Items.Count > 0)
{
ReceiversDropDown.Items.Clear();
}
for (int i = 0; i < receivers.Count; i++)
{
ReceiversDropDown.Items.Add(receivers[i].FName + " " + receivers[i].LName);
}
}
private void btnMakeGroup_Click(object sender, EventArgs e)
{
string title = txtTitle.Text;
string description = txtDescription.Text;
if (string.IsNullOrEmpty(title) ||
string.IsNullOrEmpty(description))
{
MessageBox.Show("خطا: تمام قسمت ها را پر کنید.");
}
else
{
int root_index = 0;
if (root_group.SelectedIndex != -1)
{
root_index = groups[root_group.SelectedIndex].id;
}
_group = new ReceiverGroup(1, title, description, root_index);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
Database.getDatabase().AddRecieverGroup(_group);
MessageBox.Show("گروه اضافه شد!");
}
}
private void btnMakeGroup_Click(object sender, EventArgs e)
{
string title = txtTitle.Text;
string description = txtDescription.Text;
if (string.IsNullOrEmpty(title) ||
string.IsNullOrEmpty(description) )
{
MessageBox.Show("خطا: تمام قسمت ها را پر کنید.");
}
else
{
int root_index = 0;
if (root_group.SelectedIndex != -1)
{
root_index = groups[root_group.SelectedIndex].id;
}
_group = new ReceiverGroup(1,title, description, root_index);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
Database.getDatabase().AddRecieverGroup(_group);
MessageBox.Show("گروه اضافه شد!");
}
}
private void GroupsDropDown_SelectedIndexChanged(object sender, EventArgs e)
{
selectedGroup = groups[GroupsDropDown.SelectedIndex];
receivers = Database.getDatabase().GetReceiversOfGroup(selectedGroup.id);
if (ReceiversDropDown.Items.Count > 0)
ReceiversDropDown.Items.Clear();
for (int i = 0; i < receivers.Count; i++)
{
ReceiversDropDown.Items.Add(receivers[i].FName + " " + receivers[i].LName);
}
}
public void AddRecieverGroup(ReceiverGroup _group)
{
//groups.Add(_group);
string query = "Insert into groups (group_name , description, root_group_id) VALUES ('" + _group.title + "', '" + _group.description + "', " + _group.root + ")";
Database.con.Insert(query);
}
public List<ReceiverGroup> getReceiverGroups()
{
string query = "Select * from groups";
List<List <string> > l = con.Select(query);
List<ReceiverGroup> groupList = new List<ReceiverGroup>();
for (int i = 0; i < l.Count; i++)
{
ReceiverGroup nextGroup = new ReceiverGroup(Convert.ToInt32(l[i][0]), l[i][1], l[i][2], Convert.ToInt32(l[i][3]));
groupList.Add(nextGroup);
}
return groupList;
}
