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()); } } }