private void SaveNewZone_Click(object sender, EventArgs e)
{
if (!ValidateNewZone())
{
return;
}
if (MessageBox.Show("Save this new zone?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
long i = 1;
foreach (byte b in Guid.NewGuid().ToByteArray())
{
i *= ((int)b + 1);
}
i -= DateTime.Now.Ticks;
string str = "Dol_Server_Editor_" + i.ToString();
DataRow datarow = ZonesDatatable.NewRow();
datarow["Zones_ID"] = str;
datarow["ZoneID"] = ZoneIDtextBox.Text;
datarow["RegionID"] = RegionIDtextBox.Text;
datarow["Name"] = NametextBox.Text;
datarow["IsLava"] = Util.Find_Bool_Value(IsLavacomboBox.Text);
datarow["WaterLevel"] = WaterLeveltextBox.Text;
datarow["OffsetY"] = OffSetYtextBox.Text;
datarow["OffsetX"] = OffSetXtextBox.Text;
datarow["Width"] = WidthtextBox.Text;
datarow["Height"] = HeighttextBox.Text;
datarow["Experience"] = ExperiencetextBox.Text;
datarow["Realmpoints"] = RealmPointstextBox.Text;
datarow["Bountypoints"] = BountyPointstextBox.Text;
datarow["Coin"] = CointextBox.Text;
datarow["DivingFlag"] = Util.Find_Bool_Value(DivingFlagcomboBox.Text);
datarow["Realm"] = Util.Find_Realm_Value(RealmcomboBox.Text);
datarow["TranslationId"] = TranslationIDtextBox.Text;
ZonesDatatable.Rows.Add(datarow);
this.Validate();
this.ZonebindingSource.EndEdit();
try
{
ZonesdataAdapter.Update(ZonesDatatable);
}
catch (MySqlException s)
{
MessageBox.Show(s.Message);
}
this.EditZoneControl.Hide();
this.ZonedataGridView.Show();
this.ControlMenu.Visible = true;
this.AddZoneButton.Visible = true;
this.ZoneListingButton.Visible = false;
this.SaveNewbutton.Hide();
}
}
private void GetData(string selectCommand)
{
try
{
// Create a new data adapter based on the specified query.
ZonesdataAdapter = new MySqlDataAdapter(selectCommand, Util.Connection);
// Create a command builder to generate SQL update, insert, and
// delete commands based on selectCommand. These are used to
// update the database.
commandBuilder = new MySqlCommandBuilder(ZonesdataAdapter);
ZonesDatatable.Clear();
// Populate a new data table and bind it to the BindingSource.
ZonesDatatable.Locale = System.Globalization.CultureInfo.InvariantCulture;
ZonesdataAdapter.Fill(ZonesDatatable);
ZonebindingSource.DataSource = ZonesDatatable;
}
catch (MySqlException ex)
{
MessageBox.Show("Error " + ex.Message);
}
}
