private void btnDeleteUser_Click(object sender, EventArgs e) { string userType = this.dgvUsersGrid.CurrentRow.Cells["user_type"].Value.ToString(); if (userType == "Admin") { MessageBox.Show("Can not delete admin"); return; } if (this.dgvUsersGrid.SelectedRows.Count < 1) { MessageBox.Show("No row selected"); return; } string appId = this.dgvUsersGrid.CurrentRow.Cells["appid"].Value.ToString(); string name = this.dgvUsersGrid.CurrentRow.Cells["full_name"].Value.ToString(); if (MessageBox.Show($"Do you want to delete {name}?", "Confirmation", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No) { return; } try { if (EmployeeRepo.Delete(appId) && LoginRepo.Delete(appId) && UserRepo.Delete(appId)) { MessageBox.Show(name + " has been deleted successfully"); this.PopulateGridView(); this.dgvUsersGrid.ClearSelection(); this.dgvUsersGrid.Refresh(); this.ClearUserInput(); } } catch (Exception a) { MessageBox.Show("Error!" + a.Message); } }
public static void SqlTrigger() { using (var connection = new SqlConnection(@"context connection=true")) { connection.Open(); switch (SqlContext.TriggerContext.TriggerAction) { case TriggerAction.Insert: { var command = new SqlCommand(@"SELECT * FROM INSERTED;", connection); var reader = command.ExecuteReader(); while (reader.Read()) { var inserted = new Login.Sqlserver.Login(reader); repo.Apply(inserted, "POST", false); } reader.Close(); } break; case TriggerAction.Update: { var command = new SqlCommand(@"SELECT * FROM INSERTED;", connection); var reader = command.ExecuteReader(); while (reader.Read()) { var inserted = new Login.Sqlserver.Login(reader); repo.Apply(inserted, "PUT", false); } reader.Close(); } break; case TriggerAction.Delete: { var commandDeleted = new SqlCommand(@"SELECT * FROM DELETED;", connection); var reader = commandDeleted.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { var deleted = new Login.Sqlserver.Login(reader); repo.Delete(deleted, false); } reader.Close(); } else { SqlContext.Pipe.Send("No rows affected."); } } break; default: break; } } }