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 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; }