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