protected void SaveButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("data source=.; database=HolmenRoboticsClub; integrated security=SSPI");
try
{
//insert an event record into the database along with the attendees for the event
Int32 newProdID = 0;
SqlCommand cmd = new SqlCommand("insert into Event (Title,Description,StartTime,EndTime,StartDate,EndDate) Values(@Title, @Description, @StartTime, @EndTime, @StartDate,@EndDate)" + "SELECT CAST(scope_identity() AS int)", con);
cmd.Parameters.AddWithValue("@Title", TitleTextBox.Text);
cmd.Parameters.AddWithValue("@Description", DescriptionTextBox.Text);
cmd.Parameters.AddWithValue("@StartTime", StartTime.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@EndTime", EndTime.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@StartDate", StartDayTextBox.Text);
cmd.Parameters.AddWithValue("@EndDate", EndDayTextBox.Text);
con.Open();
newProdID = (Int32)cmd.ExecuteScalar(); //get the new id for the event
attendees = (List <string>)Session["Attendees"]; //get the attendees from session state variable
foreach (string name in attendees)
{
SqlCommand cmd2 = new SqlCommand("insert into Attendees(Name,EventID) Values(@Name,@EventID)", con);
cmd2.Parameters.AddWithValue("@Name", name);
cmd2.Parameters.AddWithValue("@EventID", newProdID);
cmd2.ExecuteNonQuery();
}
EventsGridView.DataBind();
}
catch (Exception error)
{
Response.Write(error.Message);
}
finally
{
con.Close();
}
}
private void EventsGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
EventsGridView.ClearSelection();
}
