private void btnSave_Click(object sender, EventArgs e)
{
var olympic = new Olympic();
olympic.Name = txtName.Text.ToString();
olympic.Sponsors = txtSponsors.Text.ToString();
olympic.Website = txtWebsite.Text.ToString();
olympic.Twitter = txtTwitter.Text.ToString();
olympic.Facebook = txtFacebook.Text.ToString();
olympic.Logo = txtLogo.Text.ToString();
olympic.Country = txtCountry.Text.ToString();
if (!int.TryParse(txtYear.Text.ToString(), out int year))
{
MessageBox.Show("Invalid Year");
return;
}
olympic.Year = year;
olympic.TorchImage = txtTourchImage.Text.ToString();
if (!int.TryParse(txtTourchCost.Text.ToString(), out int cost))
{
MessageBox.Show("Invalid cost");
return;
}
olympic.TorchCost = cost;
olympic.TorchDescription = txtTourchDescription.Text.ToString();
olympic.TorchDesigner = txtTourchDesigner.Text.ToString();
repository.InsertOlympic(olympic);
MessageBox.Show("Olympic inserted");
this.Close();
}
public void UpdateOlympic(Olympic olympic)
{
if (olympic == null)
{
return;
}
using (var cmd = new SqlCommand("update En_Olympic set" +
" olympic_sponsors=@sponsors," +
" olympic_website=@website," +
" olympic_twitter=@twitter," +
" olympic_facebook=@facebook," +
" olympic_logo=@logo," +
" olympic_year=@year" +
" where olympic_name=@name", con)) {
OpenConnection();
cmd.Parameters.AddWithValue("@name", olympic.Name);
cmd.Parameters.AddWithValue("@sponsors", olympic.Sponsors);
cmd.Parameters.AddWithValue("@website", olympic.Website);
cmd.Parameters.AddWithValue("@twitter", olympic.Twitter);
cmd.Parameters.AddWithValue("@facebook", olympic.Facebook);
cmd.Parameters.AddWithValue("@logo", olympic.Logo);
cmd.Parameters.AddWithValue("@year", olympic.Year);
cmd.ExecuteNonQuery();
}
}
// Add this event handler to the DataGridView
private void dgvOlympics_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (dgvOlympics.RowCount - e.RowIndex == 2)
{
return;
}
var row = dgvOlympics.Rows[e.RowIndex];
olympic = ExtractOlympicFromRow(row);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (tabControl1.SelectedTab.Name == "tabOlympics")
{
repository.UpdateOlympic(olympic);
olympic = null;
}
else if (tabControl1.SelectedTab.Name == "tabAthletes")
{
repository.UpdateAthlete(athlete);
athlete = null;
}
MessageBox.Show("Record Updated Successfully");
}
private Olympic ExtractOlympicFromRow(DataGridViewRow row)
{
var olympic = new Olympic();
olympic.Name = row.Cells[0].Value.ToString();
olympic.Sponsors = row.Cells[1].Value.ToString();
olympic.Website = row.Cells[2].Value.ToString();
olympic.Twitter = row.Cells[3].Value.ToString();
olympic.Facebook = row.Cells[4].Value.ToString();
olympic.Logo = row.Cells[5].Value.ToString();
if (!int.TryParse(row.Cells[6].Value.ToString(), out int year))
{
MessageBox.Show("Invalid year");
return(olympic);
}
olympic.Year = year;
return(olympic);
}
public void InsertOlympic(Olympic olympic)
{
cmd = new SqlCommand("insert into" +
" En_Olympic(olympic_name,olympic_sponsors,olympic_website,olympic_twitter,olympic_facebook,olympic_logo,olympic_year" +
",happen_country,olympic_torch_image,olympic_torch_cost,olympic_torch_description,olympic_torch_designer)" +
" values(@name,@sponsors,@website,@twitter,@facebook,@logo,@year,@country,@tImage,@tCost,@tDescription,@tDesigner)", con);
OpenConnection();
cmd.Parameters.AddWithValue("@name", olympic.Name);
cmd.Parameters.AddWithValue("@sponsors", olympic.Sponsors);
cmd.Parameters.AddWithValue("@website", olympic.Website);
cmd.Parameters.AddWithValue("@twitter", olympic.Twitter);
cmd.Parameters.AddWithValue("@facebook", olympic.Facebook);
cmd.Parameters.AddWithValue("@logo", olympic.Logo);
cmd.Parameters.AddWithValue("@year", olympic.Year);
cmd.Parameters.AddWithValue("@country", olympic.Country);
cmd.Parameters.AddWithValue("@tImage", olympic.TorchImage);
cmd.Parameters.AddWithValue("@tCost", olympic.TorchCost);
cmd.Parameters.AddWithValue("@tDescription", olympic.TorchDescription);
cmd.Parameters.AddWithValue("@tDesigner", olympic.TorchDesigner);
cmd.ExecuteNonQuery();
}
