private void btnKupac_Click(object sender, EventArgs e)
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = classSQL.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
R1 = partner.Tables[0].Rows[0]["id_partner"].ToString();
lblKupac.Text = "Partner R1: " + partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
}
else
{
R1 = "";
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
else
{
R1 = "";
}
}
private void txtSifraPartnera_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
e.SuppressKeyPress = true;
if (txtSifraPartnera.Text == "")
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = classSQL.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtSifraPartnera.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
txtPartnerIme.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
rtbNapomena.Select();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
txtSifraPartnera.Select();
return;
}
}
else
{
txtSifraPartnera.Select();
return;
}
}
string Str = txtSifraPartnera.Text.Trim();
double Num;
bool isNum = double.TryParse(Str, out Num);
if (!isNum)
{
txtSifraPartnera.Text = "0";
}
DataTable DSpar = classSQL.select("SELECT ime_tvrtke FROM partners WHERE id_partner='" + txtSifraPartnera.Text + "'", "partners").Tables[0];
if (DSpar.Rows.Count > 0)
{
txtPartnerIme.Text = DSpar.Rows[0][0].ToString();
//txtSifraFakturirati.Text = txtSifraOdrediste.Text;
//txtSifraFakturirati_KeyDown(txtSifraOdrediste, e);
System.Windows.Forms.SendKeys.Send("{TAB}");
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void btnSrchPartners_Click(object sender, EventArgs e)
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
srchPartner(Convert.ToInt32(Properties.Settings.Default.id_partner));
traziPocetnoDugovanje();
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
frmPartnerTrazi partner = new frmPartnerTrazi();
partner.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
FillPartner(Properties.Settings.Default.id_partner);
edit = true;
EnableDisable(true);
}
}
/// <summary>
///
/// </summary>
private void SelectPartner()
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet DSpartner = classSQL.select("SELECT * FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (DSpartner.Tables[0].Rows.Count > 0)
{
tbSifraPartner.Text = DSpartner.Tables[0].Rows[0]["id_partner"].ToString();
}
}
}
private void btnTraziPartnera_Click(object sender, EventArgs e)
{
if (txtSifraPartnera.Text == "")
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = classSQL.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtSifraPartnera.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
txtNazivPartnera.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
btnDodaj.Select();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
txtSifraPartnera.Select();
}
}
else
{
txtSifraPartnera.Select();
return;
}
}
string Str = txtSifraPartnera.Text.Trim();
double Num;
bool isNum = double.TryParse(Str, out Num);
if (!isNum)
{
txtSifraPartnera.Text = "0";
}
DataTable DSpar = classSQL.select("SELECT ime_tvrtke FROM partners WHERE id_partner='" + txtSifraPartnera.Text + "'", "partners").Tables[0];
if (DSpar.Rows.Count > 0)
{
txtNazivPartnera.Text = DSpar.Rows[0][0].ToString();
btnDodaj.Select();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
private void txtSifra_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
e.SuppressKeyPress = true;
if (txtSifra.Text == "")
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DSpartner = classSQL.select("SELECT * FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (DSpartner.Tables[0].Rows.Count > 0)
{
txtSifra.Text = DSpartner.Tables[0].Rows[0]["id_partner"].ToString();
txtNaziv.Text = DSpartner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
txtSifra.Select();
}
}
else
{
txtSifra.Select();
return;
}
}
string Str = txtSifra.Text.Trim();
double Num;
bool isNum = double.TryParse(Str, out Num);
if (!isNum)
{
txtSifra.Text = "0";
}
DSpartner = classSQL.select("SELECT * FROM partners WHERE id_partner='" + txtSifra.Text + "'", "partners");
if (DSpartner.Tables[0].Rows.Count > 0)
{
txtNaziv.Text = DSpartner.Tables[0].Rows[0][0].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void btnPartner_Click(object sender, EventArgs e)
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
txtSifraOdrediste.Text = Properties.Settings.Default.id_partner.Trim();
string sifraPartnera = txtSifraOdrediste.Text.Trim();
if (sifraPartnera.Length > 0)
{
findPartner(sifraPartnera);
}
}
}
/// <summary>
/// Opens form to select partner
/// </summary>
private void SelectPartner()
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataTable DTpartner = classSQL.select($"SELECT * FROM partners WHERE id_partner ='{Properties.Settings.Default.id_partner}'", "partners").Tables[0];
if (DTpartner?.Rows.Count > 0)
{
tbPartnerBroj.Text = DTpartner.Rows[0]["id_partner"].ToString();
tbPartnerNaziv.Text = DTpartner.Rows[0]["ime_tvrtke"].ToString();
}
}
}
private void btnDodajPartneraNaRacun_Click(object sender, EventArgs e)
{
try
{
if (dgv.Rows.Count == 0 || dgv.CurrentRow == null)
{
return;
}
string mesageBoxQuestion = "Želite dodati partnera na odabrani račun?";
if (dgv.CurrentRow.Cells["Partner"].Value.ToString().Length > 0)
{
mesageBoxQuestion = "Želite promjeniti partnera na odabranom računu?";
}
if (MessageBox.Show(mesageBoxQuestion, "Račun", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
frmPartnerTrazi partner = new frmPartnerTrazi();
partner.ShowDialog();
string sql = string.Format(@"update racuni
set
id_kupac = {0}
where broj_racuna = '{1}' and id_ducan = {2} and id_kasa = {3};",
(Properties.Settings.Default.id_partner.Length > 0 ? Properties.Settings.Default.id_partner : "0"),
dgv.CurrentRow.Cells["Broj računa"].FormattedValue.ToString(),
dgv.CurrentRow.Cells["id_ducan"].FormattedValue.ToString(),
dgv.CurrentRow.Cells["id_kasa"].FormattedValue.ToString());
classSQL.update(sql);
string partnerName = "";
if (Properties.Settings.Default.id_partner.Length > 0)
{
sql = string.Format("select case when vrsta_korisnika = 1 then ime_tvrtke else concat(ime, ' ', prezime) end as naziv from partners where id_partner = {0};", Properties.Settings.Default.id_partner);
DataSet ds = classSQL.select(sql, "partners");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
partnerName = ds.Tables[0].Rows[0]["naziv"].ToString();
}
}
dgv.CurrentRow.Cells["Partner"].Value = partnerName;
}
}
catch (Exception)
{
throw;
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
try
{
frmPartnerTrazi partner = new frmPartnerTrazi();
partner.ShowDialog();
if (Properties.Settings.Default.id_partner != null && Properties.Settings.Default.id_partner.ToString().Length > 0)
{
string sql = string.Format("select * from partners where id_partner = '{0}';", Properties.Settings.Default.id_partner);
txtPartnerNaziv.Text = classSQL.select(sql, "partners").Tables[0].Rows[0]["ime_tvrtke"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnNaknadnoDodavanjePartnera_Click(object sender, EventArgs e)
{
try
{
string partner;
int broj_racuna = 0;
if (!int.TryParse(txtBrojRacuna.Text, out broj_racuna))
{
MessageBox.Show("Neispravni broj računa.");
return;
}
partner = classSQL.select("select coalesce(id_kupac, 0) as id_partner from racuni where broj_racuna = '" + broj_racuna + "' and id_ducan = '" + id_ducan + "' and id_kasa = '" + id_kasa + "'", "racuni").Tables[0].Rows[0]["id_partner"].ToString();
if (partner.Length > 0 && partner != "0")
{
MessageBox.Show("Dodavanje partnera na R1 račun nije dozvoljeno.");
return;
}
if (MessageBox.Show("Želite naknadno dodati partnera na odabrani račun?", "R1 račun", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
frmPartnerTrazi f = new frmPartnerTrazi();
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
partner = classSQL.select("select ime_tvrtke from partners where id_partner = '" + Properties.Settings.Default.id_partner + "';", "partners").Tables[0].Rows[0]["ime_tvrtke"].ToString();
if (MessageBox.Show("Sigurno želite dodati partnera " + partner + " na račun broj " + broj_racuna, "R1 račun", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
string sql = "update racuni set id_kupac = '" + Properties.Settings.Default.id_partner + "' where broj_racuna = '" + broj_racuna + "' and id_ducan = '" + id_ducan + "' and id_kasa = '" + id_kasa + "';";
classSQL.update(sql);
MessageBox.Show("Izvršeno");
DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Opens partner selection menu
/// </summary>
private void SelectPartner()
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = classSQL.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
tbPartnerSifra.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
tbPartnerNaziv.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void btnPartnerSrch_Click(object sender, EventArgs e)
{
try
{
frmPartnerTrazi f = new frmPartnerTrazi();
f.ShowDialog();
int id = 0;
if (int.TryParse(Properties.Settings.Default.id_partner, out id))
{
getPartner(id);
}
Properties.Settings.Default.id_partner = null;
Properties.Settings.Default.Save();
}
catch (Exception)
{
throw;
}
}
private void btnNaknadnoDodavanjePartnera_Click(object sender, EventArgs e)
{
try
{
if (dgv.Rows.Count == 0)
{
return;
}
int rowIndex = dgv.CurrentCell.RowIndex;
int broj_racuna = Convert.ToInt32(dgv.Rows[rowIndex].Cells["Broj računa"].Value);
int id_ducan = Convert.ToInt32(dgv.Rows[rowIndex].Cells["id_ducan"].Value);
int id_kasa = Convert.ToInt32(dgv.Rows[rowIndex].Cells["id_kasa"].Value);
string partner = dgv.Rows[rowIndex].Cells["Partner"].Value.ToString();
if (partner.Length != 0)
{
MessageBox.Show("Dodavanje partnera na R1 račun nije dozvoljeno.");
return;
}
if (MessageBox.Show("Želite naknadno dodati partnera na odabrani račun?", "R1 račun", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
frmPartnerTrazi f = new frmPartnerTrazi();
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
partner = classSQL.select("select ime_tvrtke from partners where id_partner = '" + Properties.Settings.Default.id_partner + "';", "partners").Tables[0].Rows[0]["ime_tvrtke"].ToString();
if (MessageBox.Show("Sigurno želite dodati partnera " + partner + " na račun broj " + dgv.Rows[rowIndex].Cells["Broj računa"].Value, "R1 račun", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
string sql = "update racuni set id_kupac = '" + Properties.Settings.Default.id_partner + "' where broj_racuna = '" + broj_racuna + "' and id_ducan = '" + id_ducan + "' and id_kasa = '" + id_kasa + "';";
classSQL.update(sql);
dgv.Rows[rowIndex].Cells["Partner"].Value = partner;
MessageBox.Show("Izvršeno");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnPartner_Click(object sender, EventArgs e)
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DSpartner = new DataSet();
DSpartner = classSQL.select("SELECT * FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (DSpartner.Tables[0].Rows.Count > 0)
{
txtPartnerSifra.Text = DSpartner.Tables[0].Rows[0]["id_partner"].ToString();
txtPartnerNaziv.Text = DSpartner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void button2_Click(object sender, EventArgs e)
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = RemoteDB.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtAvansirati.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
txtPartner.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = classSQL.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtSifraPartnera.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
txtPartnerIme.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
//txtSifraFakturirati.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
//txtPartnerNaziv1.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString(); cbVD.Select();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = classSQL.select("SELECT id_partner,ime_tvrtke,oib,adresa FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtSifraPartner.Enabled = false;
txtSifraPartner.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
txtImePartner.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
txtOIB.Text = partner.Tables[0].Rows[0]["OIB"].ToString();
txtAdresa.Text = partner.Tables[0].Rows[0]["adresa"].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void txtPartner_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
e.SuppressKeyPress = true;
if (txtPartner.Text == "")
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = classSQL.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtPartner.Text = partner.Tables[0].Rows[0]["ime_tvrtke"].ToString();
System.Windows.Forms.SendKeys.Send("{TAB}");
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
txtPartner.Select();
txtPartner.SelectAll();
return;
}
}
else
{
txtPartner.Select();
txtPartner.SelectAll();
return;
}
}
string Str = txtPartner.Text.Trim().ToLower();
double Num;
bool isNum = double.TryParse(Str, out Num);
if (isNum)
{
DataTable DSpar = classSQL.select("SELECT ime_tvrtke FROM partners WHERE id_partner='" + Str + "'", "partners").Tables[0];
if (DSpar.Rows.Count > 0)
{
txtPartner.Text = DSpar.Rows[0][0].ToString();
System.Windows.Forms.SendKeys.Send("{TAB}");
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
txtPartner.Select();
txtPartner.SelectAll();
}
}
else
{
DataTable DSpar = classSQL.select("SELECT ime_tvrtke FROM partners WHERE LOWER(ime_tvrtke) = '" +
Str + "'", "partners").Tables[0];
if (DSpar.Rows.Count > 0)
{
txtPartner.Text = DSpar.Rows[0][0].ToString();
System.Windows.Forms.SendKeys.Send("{TAB}");
}
else
{
DSpar = classSQL.select("SELECT ime_tvrtke FROM partners WHERE LOWER(ime_tvrtke) like '%" +
Str + "%'", "partners").Tables[0];
if (DSpar.Rows.Count > 0)
{
txtPartner.Text = DSpar.Rows[0][0].ToString();
System.Windows.Forms.SendKeys.Send("{TAB}");
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
txtPartner.Select();
txtPartner.SelectAll();
}
}
}
}
}
private void txtSifraPartnera_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
e.SuppressKeyPress = true;
string Str = txtSifraPartnera.Text.Trim();
if (Str == "")
{
frmPartnerTrazi partnerTrazi = new frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = classSQL.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtSifraPartnera.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
txtSifraPartnera.Select();
}
}
else
{
txtSifraPartnera.Select();
return;
}
}
Str = txtSifraPartnera.Text.Trim();
double Num;
bool isNum = double.TryParse(Str, out Num);
if (!isNum)
{
txtSifraPartnera.Text = "0";
}
DataTable DT = classSQL.select("SELECT ime_tvrtke FROM partners WHERE id_partner='" + Str + "'", "partners").Tables[0];
if (DT.Rows.Count > 0)
{
textBox1.Text = DT.Rows[0][0].ToString();
}
else
{
MessageBox.Show("Traženi dobavljač ne postoji.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSifraPartnera.Select();
return;
}
txtSifra_robe.Select();
}
else if (e.KeyCode == Keys.Insert)
{
txtSifra_robe.Select();
}
}