/// <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 = "";
}