private void BtnInsert_Click(object sender, EventArgs e)
{
KlijentiMiddleLayer.ClsDataAccess KlijentiInsert = new KlijentiMiddleLayer.ClsDataAccess();
try
{
if (txtIme.Text == string.Empty || txtKontakt.Text == string.Empty ||
txtGrad.Text == string.Empty || txtZemlja.Text == string.Empty)
{
MessageBox.Show("Molimo popunite sva polja.");
}
else
{
KlijentiInsert.Dbo_KlijentiInsert(txtIme.Text,
txtKontakt.Text,
txtGrad.Text,
txtZemlja.Text);
var result = MessageBox.Show("Uspešno ste dodali klijenta.",
"Dodavanje klijenta",
MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
this.Close();
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
KlijentiMiddleLayer.ClsDataAccess KlijentiUpdate = new KlijentiMiddleLayer.ClsDataAccess();
try
{
KlijentiUpdate.Dbo_KlijentiUpdate(Convert.ToInt32(txtID.Text),
txtIme.Text,
txtKontakt.Text,
txtGrad.Text,
txtZemlja.Text);
var result = MessageBox.Show("Uspešno ste izmenili informacije o klijentu.",
"Ažuriranje klijenta",
MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
if (result == DialogResult.OK)
{
fMain.BtnRefresh_Click(null, null);
this.Close();
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
//DELETE
private void BtnDelete_Click(object sender, EventArgs e)
{
KlijentiMiddleLayer.ClsDataAccess KlijentiDelete = new KlijentiMiddleLayer.ClsDataAccess();
try
{
if (GridKlijenti.Rows.Count == 0) // Prebrojava redove u gridu
{
MessageBox.Show("Niste odabrali klijenta za brisanje.",
"Ažuriranje klijenta",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
var gridSlog = GridKlijenti.SelectedRows[0].Cells[0].Value;
var result = MessageBox.Show("Da li ste sigurni da želite obrisati klijenta?",
"Brisanje klijenta",
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
KlijentiDelete.Dbo_KlijentiDelete(Convert.ToInt32(gridSlog));
BtnRefresh_Click(null, null);
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
//READ
public void BtnRefresh_Click(object sender, EventArgs e)
{
KlijentiMiddleLayer.ClsDataAccess KlijentiRead = new KlijentiMiddleLayer.ClsDataAccess();
try
{
GridKlijenti.DataSource = KlijentiRead.Dbo_KlijentiRead();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private void BtnClear_Click(object sender, EventArgs e)
{
KlijentiMiddleLayer.ClsDataAccess Clear = new KlijentiMiddleLayer.ClsDataAccess();
GridKlijenti.DataSource = Clear.Clear();
}
