private void dgvEvents_RowLeave(object sender, DataGridViewCellEventArgs e) { dgvEvents.EndEdit(); if (editingRow) { //save row if (newRow) { //new row events newEvent = (events)dgvEvents.Rows[e.RowIndex].DataBoundItem; newEvent.deleted = 0; SQL.EventAdmin.InsertEvent(newEvent); newRow = false; } else { //edit row SQL.EventAdmin.UpdateEvent((events)dgvEvents.Rows[e.RowIndex].DataBoundItem); } editingRow = false; } else { //changing row } }
/// <summary> /// selecting the event to alter and filling in controls with info /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnStart_Click(object sender, EventArgs e) { if (cbxEvents.SelectedIndex > -1) { //gets the active event from the combobox activeEvent = (events)cbxEvents.SelectedItem; //enables the form tbcEventManage.Enabled = true; //clears the list box lbxUsers.Items.Clear(); //grabs a list of all the users not attending the event userlist = SQL.RunEvent.SelectUsersNotAttending(activeEvent); //adds a list of users lbxUsers.Items.AddRange(userlist); } }
/// <summary> /// adjust events /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tabAdjustEvent_Enter(object sender, EventArgs e) { //if no event has been selected do nothing if (cbxEvents.SelectedIndex > -1) { //make the active event the combobo's event activeEvent = (events)cbxEvents.SelectedItem; //enable the tab tbcEventManage.Enabled = true; //clear the list box of admited users lbxAdmitedUsers.Items.Clear(); //refil list from query admitedList = SQL.RunEvent.SelectAttendingUsers(activeEvent); //fill the list box lbxAdmitedUsers.Items.AddRange(admitedList); } }
partial void Deleteevents(events instance);
partial void Updateevents(events instance);
partial void Insertevents(events instance);