/// <summary> /// method of event of insert button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InsertButton_Click(object sender, EventArgs e) { //assertion of text boxes if (InsertNameTextButton.Text != "" && InsertSurnameTextBox.Text != "" && InsertCriminalIdTextBox.Text != "") { //variables needed to insert new data var agentFirstName = InsertNameTextButton.Text; var agentLastName = InsertSurnameTextBox.Text; var TypeId = InsertCriminalIdTextBox.Text; var selectedCriminalIndex = Int32.Parse(InsertCriminalIdTextBox.Text); var findCriminal = _criminalsUndercover.GetById(selectedCriminalIndex); //new object FBIagentsUndercover newAgent = new FBIagentsUndercover() { FirstName = agentFirstName, LastName = agentLastName, AgentCriminalId = Int32.Parse(TypeId) }; //assertion of non existing foreign key if (findCriminal != null) { _agentsUndercover.Create(newAgent); _agentsUndercover.Save(); LoadAgents(); LoadCriminals(); } else { MessageBox.Show("Criminal ID doesn't exist in data Base. Make sure to input proper data"); } } else { MessageBox.Show("Insert All Data"); } //clear text boxes InsertNameTextButton.Text = ""; InsertSurnameTextBox.Text = ""; InsertCriminalIdTextBox.Text = ""; }
/// <summary> /// event method of update button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UpdateButton_Click(object sender, EventArgs e) { //assertion of text boxes if (CriminalIdTextBox.Text != "" && NameTextBox.Text != "" && SurnameTextBox.Text != "" && RankTextBox.Text != "") { //variables needed to update criminal var criminalId = Int32.Parse(CriminalIdTextBox.Text); var updateCriminal = _criminals.GetById(criminalId); //assertion of non existing key if (updateCriminal != null) { if (Int32.Parse(RankTextBox.Text) <= 3) { updateCriminal.FirstName = NameTextBox.Text; updateCriminal.LastName = SurnameTextBox.Text; updateCriminal.CriminalTypeId = Int32.Parse(RankTextBox.Text); //add criminal to data base _criminals.Update(updateCriminal); _criminals.Save(); LoadCriminals(); } else { MessageBox.Show("Insert proper Rank"); } } else { MessageBox.Show("Insert proper ID"); } } else { MessageBox.Show("Insert All Data"); } //clear text boxes CriminalIdTextBox.Text = ""; NameTextBox.Text = ""; SurnameTextBox.Text = ""; RankTextBox.Text = ""; }
/// <summary> /// method of event of update button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UpdateButton_Click(object sender, EventArgs e) { //assertion of text boxes if (AgentIdTextBox.Text != "" && NameTextBox.Text != "" && SurnameTextBox.Text != "" && RankTextBox.Text != "") { //variabble needed to update table var agentId = Int32.Parse(AgentIdTextBox.Text); var updateAgent = _agents.GetById(agentId); if (updateAgent != null) { if (Int32.Parse(RankTextBox.Text) <= 3) { updateAgent.FirstName = NameTextBox.Text; updateAgent.LastName = SurnameTextBox.Text; updateAgent.AgentTypeId = Int32.Parse(RankTextBox.Text); _agents.Update(updateAgent); _agents.Save(); LoadAgents(); } else { MessageBox.Show("Insert proper Rank"); } } else { MessageBox.Show("Insert proper ID"); } } else { MessageBox.Show("Insert All Data"); } //clearing text boxes AgentIdTextBox.Text = ""; NameTextBox.Text = ""; SurnameTextBox.Text = ""; RankTextBox.Text = ""; }
/// <summary> /// event method of update button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UpdateButton_Click(object sender, EventArgs e) { //assertion of text boxes if (AgentIdTextBox.Text != "" && NameTextBox.Text != "" && SurnameTextBox.Text != "") { //variables needed to update table var agentId = Int32.Parse(AgentIdTextBox.Text); var updateAgent = _agentsUndercover.GetById(agentId); //assertion of non existing ID if (updateAgent != null) { updateAgent.FirstName = NameTextBox.Text; updateAgent.LastName = SurnameTextBox.Text; _agentsUndercover.Update(updateAgent); _agentsUndercover.Save(); LoadAgents(); LoadCriminals(); } else { MessageBox.Show("Insert proper ID"); } } else { MessageBox.Show("Insert All Data"); } //clear text box AgentIdTextBox.Text = ""; NameTextBox.Text = ""; SurnameTextBox.Text = ""; }