private void fillForma(long avans, int godina)
{
string sql = string.Format(@"SELECT * from avansi where broj_avansa = '{0}' AND godina_avansa = '{1}';", avans, godina);
DSAvansi = RemoteDB.select(sql, "avansi").Tables[0];
if (DSAvansi.Rows.Count < 1)
{
MessageBox.Show("Ne postoji avans!");
deleteFields();
EnableDisable(false);
txtBrojAvans.Focus();
txtBrojAvans.SelectAll();
return;
}
ControlDisableEnable(true, true, true, true, true, true);
DSAvansi.Rows[0][0].ToString();
storno = DSAvansi.Rows[0]["storno"].ToString();
txtBrojAvans.Text = avans.ToString();
numGodina.Value = Convert.ToInt16(DSAvansi.Rows[0][10].ToString());
dateTimePicker1.Value = Convert.ToDateTime(DSAvansi.Rows[0][1].ToString());
dateTimePicker2.Value = Convert.ToDateTime(DSAvansi.Rows[0][2].ToString());
cbPDV.SelectedIndex = 1;
txtIzradio.Text = RemoteDB.select(string.Format(@"SELECT concat(ime, ' ', prezime) as Ime FROM zaposlenici WHERE id_zaposlenik = '{0}';", Properties.Settings.Default.id_zaposlenik), "zaposlenici").
Tables[0].Rows[0][0].ToString();
txtModel.Text = DSAvansi.Rows[0][5].ToString();
cbZiroRacun.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][19].ToString()) - 1;
cbValuta.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][7].ToString()) - 1;
cbNacinPlacanja.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][6].ToString()) - 1;
rtbOpis.Text = DSAvansi.Rows[0][8].ToString();
cbPDV.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][17].ToString()) - 1;
txtAvansirati.Text = DSAvansi.Rows[0][18].ToString();
DataTable DSpar = RemoteDB.select(string.Format(@"SELECT ime_tvrtke FROM partners WHERE id_partner = '{0}';", txtAvansirati.Text), "partners").Tables[0];
if (DSpar.Rows.Count > 0)
{
txtPartner.Text = DSpar.Rows[0][0].ToString();
}
c = new Cijene(Convert.ToDouble(DSAvansi.Rows[0][11].ToString()),
Convert.ToDouble(DSAvansi.Rows[0][14].ToString()),
Convert.ToDouble(DSAvansi.Rows[0][15].ToString()),
Convert.ToDouble(DSAvansi.Rows[0][12].ToString()),
Convert.ToDouble(DSAvansi.Rows[0][13].ToString()),
Convert.ToDouble(DSAvansi.Rows[0][16].ToString()));
CijeneUTextBox(c);
promjeniLabelePorezOsnovica();
//System.Windows.Forms.SendKeys.Send("{TAB}");
this.SelectNextControl(this, true, true, true, true);
EnableDisable(true);
}
private void CijeneUTextBox(Cijene c)
{
textUkupno.Text = Math.Round(c.ukupno, 2).ToString("#0.00");
textPorez10.Text = Math.Round(c.porez10, 2).ToString("#0.00");
textPorez25.Text = Math.Round(c.porezVar, 2).ToString("#0.00");
textOsnov25.Text = Math.Round(c.osnovicaVar, 2).ToString("#0.00");
textOsnov10.Text = Math.Round(c.osnovica10, 2).ToString("#0.00");
textNeoporezivo.Text = Math.Round(c.neoporezivo, 2).ToString("#0.00");
textNultaStp.Text = Math.Round(c.nultaStp, 2).ToString("#0.00");
}
private void button1_Click(object sender, EventArgs e)
{
edit = false;
EnableDisable(true);
txtBrojAvans.Text = brojAvansa();
numGodina.Value = DateTime.Now.Year;
ControlDisableEnable(false, true, true, false, false, false);
c = new Cijene();
CijeneUTextBox(c);
}
private void textUkupno_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.OemPeriod)
{
e.SuppressKeyPress = true;
}
else if (e.KeyCode == Keys.Oemcomma || e.KeyCode == (Keys)110)
{
if (textUkupno.Text.Count(x => x == ',') > 0)
{
e.SuppressKeyPress = true;
}
}
else if (e.KeyCode == Keys.Enter)
{
e.SuppressKeyPress = true;
try
{
string vr = textUkupno.Text; //.Replace(",", ".");
double p = Convert.ToDouble(vr);
string post = cbPDV.Text; //.Replace(",", ".");
double p1 = Convert.ToDouble(post);
if (p != c.ukupno)
{
c = new Cijene();
c.SrediCijeneUkupno(p, p1 / 100);
CijeneUTextBox(c);
}
System.Windows.Forms.SendKeys.Send("{TAB}");
}
catch
{
MessageBox.Show("Unesi numeričku vrijednost!");
}
}
}
private void frmAvans_Load(object sender, EventArgs e)
{
kreirajTablice();
Paint += new PaintEventHandler(Funkcije.Form1_Paint);
DTBojeForme = classDBlite.LiteSelect("SELECT * FROM FormColors", "FormColors").Tables[0];
MyDataGrid.MainForm = this;
txtBrojAvans.Text = brojAvansa();
numeric();
fillComboBox();
EnableDisable(false);
ControlDisableEnable(true, true, true, true, true, true);
if (broj_avansa_edit != 0 && godina != 0)
{
fillForma(broj_avansa_edit, godina);
}
else
{
c = new Cijene();
}
}
private void cijeneToolStripMenuItem_Click(object sender, EventArgs e)
{
Cijene cijene = new Cijene();
cijene.ShowDialog();
}
