예제 #1
0
        public static void Add(LootboxClass lb)
        {
            SqlConnection con    = DBHelper.GetConnection();
            SqlCommand    addCmd = new SqlCommand();

            addCmd.Connection = con;

            addCmd.CommandText = "INSERT INTO Lootboxes (LootboxID,LootboxTheme, LootboxName, LootboxContents, LootboxDescription, LootboxPrice)" +
                                 "VALUES (@id, @theme, @name, @contents, @description, @price)";

            // Add values into the parameters

            addCmd.Parameters.AddWithValue("@id", lb.LootboxID);
            addCmd.Parameters.AddWithValue("@theme", lb.Theme);
            addCmd.Parameters.AddWithValue("@name", lb.Name);
            addCmd.Parameters.AddWithValue("@contents", lb.Contents);
            addCmd.Parameters.AddWithValue("@description", lb.Description);
            addCmd.Parameters.AddWithValue("@price", lb.Price);

            try
            {
                con.Open();
                int rows = addCmd.ExecuteNonQuery();
            }
            finally
            {
                con.Dispose();
            }
        }
예제 #2
0
        public static void Update(LootboxClass lb)
        {
            SqlConnection con       = DBHelper.GetConnection();
            SqlCommand    updateCmd = new SqlCommand();

            updateCmd.Connection = con;



            updateCmd.CommandText = "UPDATE Lootboxes SET LootboxTheme = @theme, LootboxName = @name, LootboxContents = @contents, LootboxDescription = @description, LootboxPrice = @price " +
                                    "WHERE LootboxID = @id";


            updateCmd.Parameters.AddWithValue("@id", lb.LootboxID);
            updateCmd.Parameters.AddWithValue("@theme", lb.Theme);
            updateCmd.Parameters.AddWithValue("@name", lb.Name);
            updateCmd.Parameters.AddWithValue("@contents", lb.Contents);
            updateCmd.Parameters.AddWithValue("@description", lb.Description);
            updateCmd.Parameters.AddWithValue("@price", lb.Price);


            try
            {
                con.Open();
                updateCmd.ExecuteNonQuery();
            }
            finally
            {
                con.Dispose();
            }
        }
예제 #3
0
        private void BtnAdd_Click(object sender, EventArgs e)
        {
            // Add Lootbox into database
            LootboxClass lb = new LootboxClass()
            {
                Theme       = txtTheme.Text,
                Name        = txtName.Text,
                Contents    = txtContents.Text,
                Description = txtDescription.Text,
                Price       = Convert.ToDouble(txtPrice.Text)
            };

            try
            {
                if (existingLootbox != null)
                {
                    lb.LootboxID = existingLootbox.LootboxID;
                    LootboxDB.Update(lb);
                    MessageBox.Show("Lootbox Updated!");
                }
                else
                {
                    LootboxDB.Add(lb);
                    MessageBox.Show("Lootbox added!");
                }
                Close();
            }
            catch (SqlException)
            {
                MessageBox.Show("Error, Try Again.");
            }
        }
예제 #4
0
        private void BtnDeleteBox_Click(object sender, EventArgs e)
        {
            //List<LootboxClass> boxs = LootboxDB.GetAllLootboxes();
            LootboxClass box = lstLootBox.SelectedItem as LootboxClass;

            LootboxDB.Delete(box);
            PopulateForm();
        }
예제 #5
0
        private void BtnEditBox_Click(object sender, EventArgs e)
        {
            LootboxClass ltbx       = lstLootBox.SelectedItem as LootboxClass;
            FrmAddUpdate updateForm = new FrmAddUpdate(ltbx);

            updateForm.ShowDialog();
            PopulateForm();
        }
예제 #6
0
 private void PopulateLootboxTxt()
 {
     if (lstLootBox.SelectedIndex != -1)
     {
         LootboxClass boxs = lstLootBox.SelectedItem as LootboxClass;
         txtLootBox.Text = boxs.Description;
         txtItem.Text    = boxs.Contents;
     }
 }
예제 #7
0
        public FrmAddUpdate(LootboxClass lb = null)
        {
            InitializeComponent();
            existingLootbox = lb;
            if (lb != null)
            {
                btnAdd.Text = "Update lootbox";

                Text = "Updating Lootbox: " + lb.LootboxID;

                txtTheme.Text       = existingLootbox.Theme;
                txtName.Text        = existingLootbox.Name;
                txtContents.Text    = existingLootbox.Contents;
                txtDescription.Text = existingLootbox.Description;
                txtPrice.Text       = existingLootbox.Price.ToString();
            }
        }
예제 #8
0
        public static List <LootboxClass> GetAllLootboxes()
        {
            // Get connection to the database
            SqlConnection con = DBHelper.GetConnection();



            // Get the query set up

            string query = "SELECT LootboxID, LootboxTheme, LootboxName, LootboxContents, LootboxDescription, LootboxPrice FROM Lootboxes";


            SqlCommand selCmd = new SqlCommand
            {
                Connection  = con,
                CommandText = query
            };

            // Open Connection
            con.Open();

            // Execute query
            SqlDataReader rdr = selCmd.ExecuteReader();

            List <LootboxClass> lootboxList = new List <LootboxClass>();

            // Read each row

            while (rdr.Read())
            {
                LootboxClass tempBox = new LootboxClass
                {
                    LootboxID   = Convert.ToInt32(rdr["LootboxID"]),
                    Theme       = Convert.ToString(rdr["LootboxTheme"]),
                    Name        = Convert.ToString(rdr["LootboxName"]),
                    Contents    = Convert.ToString(rdr["LootboxContents"]),
                    Description = Convert.ToString(rdr["LootboxDescription"]),
                    Price       = Convert.ToDouble(rdr["LootboxPrice"])
                };
                lootboxList.Add(tempBox);
            }
            con.Close();
            return(lootboxList);
        }
예제 #9
0
        public static void Delete(LootboxClass Ib)
        {
            SqlConnection con       = DBHelper.GetConnection();
            SqlCommand    deleteCmd = new SqlCommand();

            deleteCmd.Connection = con;

            deleteCmd.CommandText = "DELETE FROM Lootboxes " +
                                    "WHERE LootboxName = " + "'" + Ib.Name + "'";

            try
            {
                con.Open();
                deleteCmd.ExecuteNonQuery();
            }
            finally
            {
                con.Close();
            }
        }