private void btnDelete_Click(object sender, EventArgs e)
{
try
{
string izabraniKlijentID;
if (MessageBox.Show("Are you sure you want to delete a client?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (dataGridView1.Columns.Count == 0)
{
MessageBox.Show("Choose a client!");
btnRefreshGrid.Focus();
return;
}
if (dataGridView1.SelectedRows[0].Cells[0].Value == null)
{
MessageBox.Show("You didn't choose a client!");
btnRefreshGrid.Focus();
return;
}
else
{
izabraniKlijentID = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
}
ClCRUD.ClsDataAccess x = new ClCRUD.ClsDataAccess();
x.KlijentiDelete(Convert.ToInt32(izabraniKlijentID));
MessageBox.Show("Client is deleted!");
btnRefreshGrid_Click(null, null);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnRefreshGrid_Click(object sender, EventArgs e)
{
try
{
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.MultiSelect = false;
dataGridView1.ReadOnly = true;
ClCRUD.ClsDataAccess x = new ClCRUD.ClsDataAccess();
dataGridView1.DataSource = x.KlijentiSelect();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
ClCRUD.ClsDataAccess x = new ClCRUD.ClsDataAccess();
if (tbId.Text != "" && tbNazivUpdate.Text != "" && tbKontaktUpdate.Text != "" && tbGradUpdate.Text != "" && tbZemljaUpdate.Text != "")
{
x.KlijentiUpdate(Convert.ToInt32(tbId.Text), tbNazivUpdate.Text, tbKontaktUpdate.Text, tbGradUpdate.Text, tbZemljaUpdate.Text);
MessageBox.Show("You added a client!");
this.Close();
}
else
{
MessageBox.Show("Fill all fields!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Something gone wrong... You didn't add a client.");
}
}
private void btnInsertK_Click(object sender, EventArgs e)
{
try
{
if (tbNazivInsert.Text.Trim() != "" && tbkontaktInsert.Text.Trim() != "" && tbGradInsert.Text.Trim() != "" && tbZemljaInsert.Text.Trim() != "")
{
ClCRUD.ClsDataAccess x = new ClCRUD.ClsDataAccess();
x.KlijentiInsert(tbNazivInsert.Text, tbkontaktInsert.Text, tbGradInsert.Text, tbZemljaInsert.Text);
MessageBox.Show("You added a client!");
this.Close();
}
else
{
MessageBox.Show("Fill all fields!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Something gone wrong... You didn't add a client.");
}
}
