private void GetRobaProdaja()
{
NpgsqlConnection remoteConnection = new NpgsqlConnection(classSQL.remoteConnectionString.Replace(UzmiTrenutnuGodinu().ToString(), (UzmiTrenutnuGodinu() - 1).ToString()));
string sql = "SELECT * FROM roba_prodaja";
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, remoteConnection);
DataSet DS = new DataSet();
da.Fill(DS);
DataTable DTrp = DS.Tables[0];
classSQL.insert("DELETE FROM roba_prodaja");
RobaProdaja rp = new RobaProdaja();
for (int i = 0; i < DTrp.Rows.Count; i++)
{
//*************************************************PROVJERA ROBE I SPREMANJE U STRUCT***************************************************
decimal kol = 0;
rp.id_roba_prodaja = DTrp.Rows[i]["id_roba_prodaja"].ToString() == "" ? "1" : DTrp.Rows[i]["id_roba_prodaja"].ToString();
rp.id_skladiste = DTrp.Rows[i]["id_skladiste"].ToString() == "" ? "1" : DTrp.Rows[i]["id_skladiste"].ToString();
rp.kolicina = decimal.TryParse(DTrp.Rows[i]["kolicina"].ToString(), out kol) ? DTrp.Rows[i]["kolicina"].ToString() : "0";
rp.nc = DTrp.Rows[i]["nc"].ToString() == "" ? "0" : DTrp.Rows[i]["nc"].ToString().Replace(".", ",");
rp.vpc = DTrp.Rows[i]["vpc"].ToString() == "" ? "0" : DTrp.Rows[i]["vpc"].ToString().Replace(",", ".");
rp.porez = DTrp.Rows[i]["porez"].ToString() == "" ? "0" : DTrp.Rows[i]["porez"].ToString();
rp.sifra = DTrp.Rows[i]["sifra"].ToString() == "" ? "1" : DTrp.Rows[i]["sifra"].ToString();
rp.porez_potrosnja = DTrp.Rows[i]["porez_potrosnja"].ToString() == "" ? "0" : DTrp.Rows[i]["porez_potrosnja"].ToString();
//**************************************************************************************************************************************
sql = "INSERT INTO roba_prodaja (id_roba_prodaja,id_skladiste,kolicina,nc,vpc,porez,sifra,porez_potrosnja" +
") VALUES (" +
"'" + rp.id_roba_prodaja + "'," +
"'" + rp.id_skladiste + "'," +
"'" + rp.kolicina + "'," +
"'" + rp.nc + "'," +
"'" + rp.vpc + "'," +
"'" + rp.porez + "'," +
"'" + rp.sifra + "'," +
"'" + rp.porez_potrosnja + "'" +
")";
classSQL.insert(sql);
}
classSQL.insert("SELECT setval('roba_prodaja_id_roba_prodaja_seq', (SELECT MAX(id_roba_prodaja) FROM roba_prodaja)+1);");
}
private void GetRobaProdaja()
{
//classSQL.remoteConnectionString.Replace(UzmiTrenutnuGodinu().ToString(), (UzmiTrenutnuGodinu() - 1).ToString())
NpgsqlConnection remoteConnection = new NpgsqlConnection(classSQL.remoteConnectionString);
string sql = "SELECT * FROM roba_prodaja";
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, remoteConnection);
DataSet DS = new DataSet();
da.Fill(DS);
DataTable DTrp = DS.Tables[0];
classSQL.insert("DELETE FROM roba_prodaja");
PoravnavanjeIdSerialBazi();
RobaProdaja rp = new RobaProdaja();
for (int i = 0; i < DTrp.Rows.Count; i++)
{
//*************************************************PROVJERA ROBE I SPREMANJE U STRUCT***************************************************
decimal kol = 0;
rp.id_roba_prodaja = DTrp.Rows[i]["id_roba_prodaja"].ToString() == "" ? "1" : DTrp.Rows[i]["id_roba_prodaja"].ToString();
rp.id_skladiste = DTrp.Rows[i]["id_skladiste"].ToString() == "" ? "1" : DTrp.Rows[i]["id_skladiste"].ToString();
rp.kolicina = decimal.TryParse(DTrp.Rows[i]["kolicina"].ToString(), out kol) ? DTrp.Rows[i]["kolicina"].ToString() : "0";
rp.nc = DTrp.Rows[i]["nc"].ToString() == "" ? "0" : DTrp.Rows[i]["nc"].ToString().Replace(",", ".");
rp.vpc = DTrp.Rows[i]["vpc"].ToString() == "" ? "0" : DTrp.Rows[i]["vpc"].ToString().Replace(",", ".");
rp.sifra = DTrp.Rows[i]["sifra"].ToString() == "" ? "greska" : DTrp.Rows[i]["sifra"].ToString();
rp.porez_potrosnja = DTrp.Rows[i]["porez_potrosnja"].ToString() == "" ? "0" : DTrp.Rows[i]["porez_potrosnja"].ToString();
rp.id_grupa = DTrp.Rows[i]["id_grupa"].ToString() == "" ? "0" : DTrp.Rows[i]["id_grupa"].ToString();
rp.id_podgrupa = DTrp.Rows[i]["id_podgrupa"].ToString() == "" ? "0" : DTrp.Rows[i]["id_podgrupa"].ToString();
rp.mjera = DTrp.Rows[i]["mjera"].ToString() == "" ? "0" : DTrp.Rows[i]["mjera"].ToString();
rp.aktivnost = DTrp.Rows[i]["aktivnost"].ToString() == "" ? "0" : DTrp.Rows[i]["aktivnost"].ToString();
rp.povratna_naknada = DTrp.Rows[i]["povratna_naknada"].ToString() == "" ? "0" : DTrp.Rows[i]["povratna_naknada"].ToString();
rp.poticajna_naknada = DTrp.Rows[i]["poticajna_naknada"].ToString() == "" ? "0" : DTrp.Rows[i]["poticajna_naknada"].ToString();
rp.ulazni_porez = DTrp.Rows[i]["ulazni_porez"].ToString() == "" ? "0" : DTrp.Rows[i]["ulazni_porez"].ToString();
rp.izlazni_porez = DTrp.Rows[i]["izlazni_porez"].ToString() == "" ? "0" : DTrp.Rows[i]["izlazni_porez"].ToString();
rp.naziv = DTrp.Rows[i]["naziv"].ToString() == "" ? "0" : DTrp.Rows[i]["naziv"].ToString();
rp.mpc = DTrp.Rows[i]["mpc"].ToString() == "" ? "0" : DTrp.Rows[i]["mpc"].ToString().Replace(",", ".");
rp.id_partner = DTrp.Rows[i]["id_partner"].ToString() == "" ? "0" : DTrp.Rows[i]["id_partner"].ToString();
rp.kolicina_predracun = DTrp.Rows[i]["kolicina_predracun"].ToString() == "" ? "0" : DTrp.Rows[i]["kolicina_predracun"].ToString().Replace(",", ".");
rp.brojcanik = DTrp.Rows[i]["brojcanik"].ToString() == "" ? "0" : DTrp.Rows[i]["brojcanik"].ToString().Replace(",", ".");
rp.editirano = DTrp.Rows[i]["editirano"].ToString() == "" ? "0" : DTrp.Rows[i]["editirano"].ToString();
rp.novo = DTrp.Rows[i]["brojcanik"].ToString() == "" ? "0" : DTrp.Rows[i]["novo"].ToString();
rp.cijena2 = DTrp.Rows[i]["cijena2"].ToString() == "" ? "0" : DTrp.Rows[i]["cijena2"].ToString().Replace(",", ".");
rp.u_pakiranju = DTrp.Rows[i]["u_pakiranju"].ToString() == "" ? "0" : DTrp.Rows[i]["u_pakiranju"].ToString().Replace(",", ".");
//**************************************************************************************************************************************
sql = "INSERT INTO roba_prodaja (id_roba_prodaja,id_skladiste,kolicina,nc,vpc,sifra,porez_potrosnja,id_grupa,id_podgrupa,mjera,aktivnost" +
",povratna_naknada,poticajna_naknada,ulazni_porez,izlazni_porez,naziv,mpc,id_partner,kolicina_predracun,brojcanik,editirano, novo,cijena2,u_pakiranju" +
") VALUES (" +
"'" + rp.id_roba_prodaja + "'," +
"'" + rp.id_skladiste + "'," +
"'" + rp.kolicina + "'," +
"'" + rp.nc + "'," +
"'" + rp.vpc + "'," +
"'" + rp.sifra + "'," +
"'" + rp.porez_potrosnja + "'," +
"'" + rp.id_grupa + "'," +
"'" + rp.id_podgrupa + "'," +
"'" + rp.mjera + "'," +
"'" + rp.aktivnost + "'," +
"'" + rp.povratna_naknada + "'," +
"'" + rp.poticajna_naknada + "'," +
"'" + rp.ulazni_porez + "'," +
"'" + rp.izlazni_porez + "'," +
"'" + rp.naziv + "'," +
"'" + rp.mpc + "'," +
"'" + rp.id_partner + "'," +
"'" + rp.kolicina_predracun + "'," +
"'" + rp.brojcanik + "'," +
"'" + rp.editirano + "'," +
"'" + rp.novo + "'," +
"'" + rp.cijena2 + "'," +
"'" + rp.u_pakiranju + "'" +
")";
classSQL.insert(sql);
}
}
