Пример #1
0
        private void button_save_Click(object sender, EventArgs e)
        {
            log.Debug("Save button clicked");

            SQLiteConnection conn = SQLiteConnectionFactory.GetPrimaryDBConnection();
            GroupDAO dao = new GroupDAO();
            Group group = new Group();

            try
            {
                label_message.ForeColor = Color.Blue;
                group.GroupName = textBox_groupName.Text;

                if (isUpdate)
                {
                    group.GroupId = Convert.ToInt32(label_groupId.Text);
                    log.Debug("Attempting to update group " +  group.GroupId + ": " + group.GroupName);
                    dao.Update(group, conn);
                    label_message.Text = "Updated group: " + group.GroupName;
                    log.Debug("Updated group successful");
                }
                else
                {
                    log.Debug("Attempting to save new group: " + group.GroupName);
                    dao.Create(group, conn);
                    label_message.Text = "Created New group: " + group.GroupName;
                    log.Debug("Create new group successful");
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                log.Error("Error saving/updating group ", ex);
                label_message.ForeColor = Color.Red;
                label_message.Text = ex.Message;
            }
        }
Пример #2
0
 private Group InsertTestGroup(SQLiteConnection conn, int i)
 {
     GroupDAO groupDAO = new GroupDAO();
     string name = lastNames[rand.Next(0, lastNames.Length - 1)] + " Group" + i;
     Group g = new Group() { GroupName = name };
     groupDAO.Create(g, conn);
     g.GroupId = groupDAO.Read("SELECT * FROM groups WHERE group_id = (SELECT max(group_id) FROM groups)", conn)[0].GroupId;
     return g;
 }
Пример #3
0
 private Group InsertTestGroup(SQLiteConnection conn)
 {
     GroupDAO groupDAO = new GroupDAO();
     Group g = new Group() { GroupName = "HuntTestGroup" };
     groupDAO.Create(g, conn);
     g.GroupId = groupDAO.Read("SELECT * FROM groups WHERE group_name = 'HuntTestGroup'", conn)[0].GroupId;
     return g;
 }