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();
}
}
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();
}
}
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.");
}
}
private void BtnDeleteBox_Click(object sender, EventArgs e)
{
//List<LootboxClass> boxs = LootboxDB.GetAllLootboxes();
LootboxClass box = lstLootBox.SelectedItem as LootboxClass;
LootboxDB.Delete(box);
PopulateForm();
}
private void BtnEditBox_Click(object sender, EventArgs e)
{
LootboxClass ltbx = lstLootBox.SelectedItem as LootboxClass;
FrmAddUpdate updateForm = new FrmAddUpdate(ltbx);
updateForm.ShowDialog();
PopulateForm();
}
private void PopulateLootboxTxt()
{
if (lstLootBox.SelectedIndex != -1)
{
LootboxClass boxs = lstLootBox.SelectedItem as LootboxClass;
txtLootBox.Text = boxs.Description;
txtItem.Text = boxs.Contents;
}
}
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();
}
}
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);
}
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();
}
}