private void btnEnter_Click(object sender, EventArgs e)
{
decimal dec_parse;
if (Decimal.TryParse(txtkol.Text, out dec_parse))
{
txtkol.Text = dec_parse.ToString();
if (dec_parse == 0)
{
MessageBox.Show("Količina ne smije biti nula!", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
else
{
this.Close();
return;
}
if (_type == "K")
{
MainForm.dgw.CurrentRow.Cells[1].Value = txtkol.Text;
}
else if (_type == "C")
{
double PDV = Convert.ToDouble(MainForm.dgw.CurrentRow.Cells["porez"].FormattedValue.ToString());
double PP = Convert.ToDouble(MainForm.dgw.CurrentRow.Cells["porez_potrosnja"].FormattedValue.ToString());
double mpc = Convert.ToDouble(txtkol.Text);
double pdv_stavka = 0;
double pnp_stavka = 0;
//Ovaj kod dobiva PDV
double PreracunataStopaPDV = Convert.ToDouble((100 * PDV) / (100 + PDV + PP));
pdv_stavka = (mpc * PreracunataStopaPDV) / 100;
//Ovaj kod dobiva porez na potrošnju
double PreracunataStopaPorezNaPotrosnju = Convert.ToDouble((100 * PP) / (100 + PDV + PP));
pnp_stavka = (mpc * PreracunataStopaPorezNaPotrosnju) / 100;
MainForm.dgw.CurrentRow.Cells["vpc"].Value = (mpc - pdv_stavka - pnp_stavka);
MainForm.dgw.CurrentRow.Cells["mpc"].Value = mpc.ToString("#0.00");
}
MainForm.IzracunUkupno();
this.Close();
}
private void SetRoba(string sifra, double kol)
{
DataTable DT = new DataTable();
string sql = "SELECT " +
" roba.naziv," +
" roba.mpc," +
" roba.nbc," +
" roba.porez," +
" roba.sifra," +
" roba.porez_potrosnja" +
" FROM roba" +
" WHERE roba.sifra='" + sifra + "'";
DT = classSQL.select(sql, "roba").Tables[0];
if (DT.Rows.Count > 0)
{
double kolicina = kol;
double mpc = Convert.ToDouble(DT.Rows[0]["mpc"].ToString());
double porez = Convert.ToDouble(DT.Rows[0]["porez"].ToString());
double pnp = Convert.ToDouble(DT.Rows[0]["porez_potrosnja"].ToString());
double pdv_stavka;
double Porez_potrosnja_stavka;
double PreracunataStopaPDV = Convert.ToDouble((100 * porez) / (100 + porez + pnp));
pdv_stavka = (mpc * PreracunataStopaPDV) / 100;
double PreracunataStopaPorezNaPotrosnju = Convert.ToDouble((100 * pnp) / (100 + porez + pnp));
Porez_potrosnja_stavka = (mpc * PreracunataStopaPorezNaPotrosnju) / 100;
decimal nbc;
decimal.TryParse(DT.Rows[0]["nbc"].ToString(), out nbc);
MainForm.dgw.Rows.Add(
DT.Rows[0]["naziv"].ToString(),
kolicina.ToString(),
(mpc).ToString("#0.00"),
DT.Rows[0]["sifra"].ToString(),
MainForm.DSpostavke.Tables[0].Rows[0]["default_skladiste"].ToString(),
DT.Rows[0]["porez"].ToString(),
"0",
mpc - (pdv_stavka + Porez_potrosnja_stavka),
//DT.Rows[0]["nbc"].ToString(),
DT.Rows[0]["porez_potrosnja"].ToString(),
"",
"",
nbc.ToString("#0.00000"),
"0",
""
);
MainForm.dgw.ClearSelection();
MainForm.dgw.Rows[MainForm.dgw.Rows.Count - 1].Selected = true;
MainForm.ProvjeraPromocije(DT.Rows[0]["sifra"].ToString(), MainForm.dgw.Rows.Count - 1);
MainForm.IzracunUkupno();
MainForm.PaintRows(MainForm.dgw);
if (DSpostavke.Tables[0].Rows[0]["obavjeti_ako_nema_repromaterijala"].ToString() == "1")
{
RobnoFunkcije.ObavjestiAkoNaSkladistuImaManjeOdNule(DT.Rows[0]["sifra"].ToString(), DSpostavke.Tables[0].Rows[0]["default_skladiste"].ToString());
}
}
}
