public static Racun GetRacunByRacun(Int64 brRacuna)
{
Racun racun = null;
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = "SELECT * FROM racun WHERE idracuna = @racun";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@racun", brRacuna);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
racun = new Racun();
racun.Datum = (DateTime)reader["datum"];
racun.IDBanke = (int)reader["idbanke"];
racun.IDFirme = (int)reader["idfirme"];
racun.IDRacuna = (int)reader["idracuna"];
racun.PredhodnoStanje = (double)reader["prethodnostanje"];
racun.TrenutnoStanje = (double)reader["trenutnostanje"];
}
reader.Close();
}
conn.Close();
}
return(racun);
}
public static ObracunskiRacun GetObracunskiRacunByRacun(Int64 racun)
{
ObracunskiRacun obracunskiRacun = null;
using (SqlConnection conn = MySQLUtils.NapraviCBConn())
{
conn.Open();
string sql = "SELECT * FROM obracunskiracun WHERE brojobracunskogracuna = @racun";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@racun", racun);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
obracunskiRacun = new ObracunskiRacun();
obracunskiRacun.BrojObracunskogRacuna = (Int64)(decimal)reader["brojobracunskogracuna"];
obracunskiRacun.IDBanke = (int)reader["idbanke"];
obracunskiRacun.IDCentralneBanke = (int)reader["idcb"];
obracunskiRacun.IDObracunskogRacuna = (int)reader["idobracunskogracuna"];
obracunskiRacun.Stanje = (double)(decimal)reader["stanje"];
}
reader.Close();
}
conn.Close();
}
return(obracunskiRacun);
}
public static Presek GetPresekByZahtev(ZahtevZaDobijanjeIzvoda zahtev)
{
Presek p = null;
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = "SELECT * FROM presek WHERE datumnaloga = @datumnaloga AND brracuna = @brracuna";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@brracuna", zahtev.BrRacuna);
cmd.Parameters.AddWithValue("@datumnaloga", zahtev.Datum);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
p = ReadFromReader(reader);
}
reader.Close();
}
conn.Close();
}
return(p);
}
}//
public static List <NalogZaGrupnoPlacanje> GetAllNalogZaGrupnoPlacanjeByStatus(string status)
{
List <NalogZaGrupnoPlacanje> nalogZaGrupnoPlacanje = new List <NalogZaGrupnoPlacanje>();
using (SqlConnection conn = MySQLUtils.NapraviCBConn())
{
conn.Open();
string sql = @"SELECT * FROM nalogzagp WHERE status = @status";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@status", status);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
NalogZaGrupnoPlacanje nzgp = new NalogZaGrupnoPlacanje();
nzgp = ReadFromReader(reader);
nalogZaGrupnoPlacanje.Add(nzgp);
}
reader.Close();
}
conn.Close();
}
return(nalogZaGrupnoPlacanje);
}
public static Firma GetFirmaByName(string firmName)
{
Firma firma = null;
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = "SELECT * FROM firma WHERE naziv = @naziv";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@naziv", firmName);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
firma = new Firma();
firma.AdresaFirme = (string)reader["adresa"];
firma.IDFirme = (Int32)reader["idfirme"];
firma.Racun = (Int64)(decimal)reader["brojracuna"];
firma.NazivFirme = (string)reader["naziv"];
firma.PIB = (string)reader["pib"];
}
reader.Close();
}
conn.Close();
}
return(firma);
}
public static StavkeGrupnogPlacanja GetStavkaByNalogZaGrupnoPlacanjeId(int nalogId)
{
StavkeGrupnogPlacanja stavke = new StavkeGrupnogPlacanja();
using (SqlConnection conn = MySQLUtils.NapraviCBConn())
{
conn.Open();
string sql = @"SELECT * FROM sgp WHERE nalogzagp_idnalogazagp = @idNaloga";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idNaloga", nalogId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StavkaGrupnogPlacanja ret = new StavkaGrupnogPlacanja();
ret = ReadFromReader(reader);
stavke.Add(ret);
}
reader.Close();
}
conn.Close();
}
return(stavke);
}
public static List <NalogZaPlacanje> GetNalogZaPlacanjeByStatusAndBanka(string status, long idBanke)
{
List <NalogZaPlacanje> nalozi = new List <NalogZaPlacanje>();
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = "SELECT * FROM nalogzaplacanje nzp left join racun r on nzp.racunduznika=r.idracuna WHERE status = @status and r.idbanke = @idBanke";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@status", status);
cmd.Parameters.AddWithValue("@idBanke", idBanke);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
NalogZaPlacanje naloug = GetFromReader(reader);
nalozi.Add(naloug);
}
reader.Close();
}
conn.Close();
}
return(nalozi);
}
public static List <Banka> getAllBanks(int idBanke)
{
List <Banka> banke = new List <Banka>();
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = @"SELECT * FROM banka WHERE idbanke != @idBanke";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idBanke", idBanke);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Banka banka;
banka = GetBankaFromReader(reader);
banke.Add(banka);
}
reader.Close();
}
conn.Close();
}
return(banke);
}
public static ListaStavkiFakture GetStavkaByFakturaId(int fakturaId)
{
List <StavkaFakture> stavke = new List <StavkaFakture>();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = @"SELECT * FROM stavkafakture WHERE faktura_idfakture = @idFakture";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idFakture", fakturaId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StavkaFakture ret = new StavkaFakture();
ret = ReadFromReader(reader);
stavke.Add(ret);
}
reader.Close();
}
conn.Close();
}
ListaStavkiFakture lst = new ListaStavkiFakture();
foreach (var st in stavke)
{
lst.Add(st);
}
return(lst);
}
public static ListaStavkiPreseka GetAllStavkaPresekaByPresekId(int idPreseka)
{
ListaStavkiPreseka stavke = new ListaStavkiPreseka();
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = "SELECT * FROM stavkapreseka WHERE presek_idpreseka = @idPreseka";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idPreseka", idPreseka);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StavkaPreseka stavka = GetStavkaPresekaFromReader(reader);
stavke.Add(stavka);
}
reader.Close();
}
conn.Close();
}
return(stavke);
}
//
public static void InsertIntoStavkaZaGrupnoPlacanje(StavkaGrupnogPlacanja sgp)
{
using (SqlConnection conn = MySQLUtils.NapraviCBConn())
{
string sql = @"INSERT INTO [dbo].[sgp]
([idnalogazaplacanje]
,[duznik]
,[svrhaplacanja]
,[primalac]
,[datumnaloga]
,[racunduznika]
,[modelzaduzenja]
,[pozivnabrzaduzenja]
,[racunpoverioca]
,[modelodobrenja]
,[pozivnabrodobrenja]
,[iznos]
,[sifravalute]
,[nalogzagp_idnalogazagp])
VALUES
(@idnalogazaplacanje
,@duznik
,@svrhaplacanja
,@primalac
,@datumnaloga
,@racunduznika
,@modelzaduzenja
,@pozivnabrzaduzenja
,@racunpoverioca
,@modelodobrenja
,@pozivnabrodobrenja
,@iznos
,@sifravalute
,@nalogzagp_idnalogazagp )" ;
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idnalogazaplacanje", sgp.IDNalogaZaPlacanje);
cmd.Parameters.AddWithValue("@duznik", sgp.Duznik);
cmd.Parameters.AddWithValue("@svrhaplacanja", sgp.SvrhaPlacanja);
cmd.Parameters.AddWithValue("@primalac", sgp.Primalac);
cmd.Parameters.AddWithValue("@datumnaloga", sgp.DatumNaloga);
cmd.Parameters.AddWithValue("@racunduznika", sgp.RacunDuznika);
cmd.Parameters.AddWithValue("@modelzaduzenja", sgp.ModelZaduzenja);
cmd.Parameters.AddWithValue("@pozivnabrzaduzenja", sgp.PozivNaBrZaduzenja);
cmd.Parameters.AddWithValue("@racunpoverioca", sgp.RacunPoverioca);
cmd.Parameters.AddWithValue("@modelodobrenja", sgp.ModelOdobrenja);
cmd.Parameters.AddWithValue("@pozivnabrodobrenja", sgp.PozivNaBrOdobrenja);
cmd.Parameters.AddWithValue("@iznos", sgp.Iznos);
cmd.Parameters.AddWithValue("@sifravalute", sgp.SifraValute);
cmd.Parameters.AddWithValue("@nalogzagp_idnalogazagp", sgp.IDNalogaZaGrupnoPlacanje);
cmd.ExecuteNonQuery();
}
conn.Close();
}
} //
public static void InsertStavkaPreseka(StavkaPreseka stavka)
{
using (SqlConnection conn = MySQLUtils.NapraviBankaConn()){
conn.Open();
string sql = @"INSERT INTO [dbo].[stavkapreseka]
([duznik]
,[svrhaplacanja]
,[primalac]
,[datumnaloga]
,[datumvalute]
,[racunduznika]
,[modelzaduzenja]
,[pozivnabrzaduzenja]
,[racunpoverioca]
,[modelodobrenja]
,[pozivnabrodobrenja]
,[iznos]
,[smer]
,[presek_idpreseka])
VALUES
(@duznik
,@svrhaPlacanja
,@primalac
,@datumNaloga
,@datumvalute
,@racunduznika
,@modelzaduzenja
,@pozivnabrzaduzenja
,@racunpoverioca
,@modelodobrenja
,@pozivnabrodobrenja
,@iznos
,@smer
,@presek_idpreseka )" ;
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@duznik", stavka.Duznik);
cmd.Parameters.AddWithValue("@svrhaPlacanja", stavka.SvrhaPlacanja);
cmd.Parameters.AddWithValue("@primalac", stavka.Primalac);
cmd.Parameters.AddWithValue("@datumNaloga", stavka.DatumNaloga);
cmd.Parameters.AddWithValue("@datumvalute", stavka.DatumValute);
cmd.Parameters.AddWithValue("@racunduznika", stavka.RacunDuznika);
cmd.Parameters.AddWithValue("@modelzaduzenja", stavka.ModelZaduzenja);
cmd.Parameters.AddWithValue("@pozivnabrzaduzenja", stavka.PozivNaBrZaduzenja);
cmd.Parameters.AddWithValue("@racunpoverioca", stavka.RacunPoverioca);
cmd.Parameters.AddWithValue("@modelodobrenja", stavka.ModelOdobrenja);
cmd.Parameters.AddWithValue("@pozivnabrodobrenja", stavka.PozivNaBrojOdobrenja);
cmd.Parameters.AddWithValue("@iznos", stavka.Iznos);
cmd.Parameters.AddWithValue("@smer", stavka.Smer);
cmd.Parameters.AddWithValue("@presek_idpreseka", stavka.IDPreseka);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public static void checkConfirmationHandler(string username, string email, string password, ClientObject client)
{
bool isCreated = MySQLUtils.createNewUserServer(username, email, password);
if (isCreated)
{
sendRegistrationPacketsAllow(client);
}
else
{
sendRegistrationPacketsDeny(client);
}
}
public static void checkLoginHandler(string username, string password, ClientObject client)
{
bool checkLogin = MySQLUtils.checkLogin(username, password);
if (checkLogin)
{
sendLoginPacketsAllow(client);
}
else
{
sendLoginPacketsDeny(client);
}
}
}//
//
public static void InsertIntoNalogZaGrupnoPlacanje(NalogZaGrupnoPlacanje f)
{
using (SqlConnection conn = MySQLUtils.NapraviCBConn())
{
string sql = @"INSERT INTO [dbo].[nalogzagp]
([idporuke]
,[swiftbankeduznika]
,[obracunskiracunbankeduznika]
,[swiftbankepoverioca]
,[obracunskiracunbankepoverioca]
,[ukupaniznos]
,[sifravalute]
,[datumvalute]
,[datum]
,[status]) output inserted.idnzgp
VALUES
(@idporuke
,@swiftbankeduznika
,@obracunskiracunbankeduznika
,@swiftbankepoverioca
,@obracunskiracunbankepoverioca
,@ukupaniznos
,@sifravalute
,@datumvalute
,@datum
,@status) SELECT SCOPE_IDENTITY()";
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idporuke", f.IDPoruke);
cmd.Parameters.AddWithValue("@swiftbankeduznika", f.SWIFTBankeDuznika);
cmd.Parameters.AddWithValue("@obracunskiracunbankeduznika", f.ObracunskiRacunBankeDuznika);
cmd.Parameters.AddWithValue("@swiftbankepoverioca", f.SWIFTBankePoverioca);
cmd.Parameters.AddWithValue("@obracunskiracunbankepoverioca", f.ObracunskiRacunBankePoverioca);
cmd.Parameters.AddWithValue("@ukupaniznos", f.UkupanIznos);
cmd.Parameters.AddWithValue("@sifravalute", f.SifraValute);
cmd.Parameters.AddWithValue("@datumvalute", f.DatumValute);
cmd.Parameters.AddWithValue("@datum", f.Datum);
cmd.Parameters.AddWithValue("@status", f.Status);
Int32 idf = (Int32)cmd.ExecuteScalar();
foreach (var stavka in f.StavkeGrupnogPlacanja)
{
stavka.IDNalogaZaGrupnoPlacanje = idf;
StavkaGrupnogPlacanjaDB.InsertIntoStavkaZaGrupnoPlacanje(stavka);
}
}
conn.Close();
}
}//
public static void UpdateRacunaStanje(long id, double stanje)
{
string sql = "UPDATE racun SET trenutnostanje = @stanje WHERE idracuna = @id";
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@stanje", stanje);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public static void UpdateNalogZaGrupnoPlacanjeStatus(int nalogId, string status)
{
string sql = "UPDATE nalogzagp SET status = @status WHERE idnzgp = @id";
using (SqlConnection conn = MySQLUtils.NapraviCBConn())
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@status", status);
cmd.Parameters.AddWithValue("@id", nalogId);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public static void MakeInvoiceProfile(int idFakture)
{
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = @"UPDATE [dbo].[faktura]
SET [status] = '2'
WHERE [dbo].[faktura].[idfakture] = @idFakture" ;
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idFakture", idFakture);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
//
public static void InsertIntoStavkaFakture(StavkaFakture sf)
{
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
string sql = @"INSERT INTO [dbo].[stavkafakture]
([rednibr]
,[nazivrobeiliusluge]
,[kolicina]
,[jedinicamere]
,[jedinicnacena]
,[vrednost]
,[procenatrabata]
,[iznosrabata]
,[umanjenozarabat]
,[ukupanporez]
,[faktura_idfakture])
VALUES
(@redniBr
,@nazivrobeiliusuge
,@kolicina
,@jedinicaMere
,@jedinicnacena
,@vrednost
,@procenatRabata
,@iznosRabata
,@umanjenostZaRabat
,@ukupanPorez
,@faktura_idFakture)" ;
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@redniBr", sf.RedniBr);
cmd.Parameters.AddWithValue("@nazivrobeiliusuge", sf.NazivRobeIliUsluge);
cmd.Parameters.AddWithValue("@kolicina", sf.Kolicina);
cmd.Parameters.AddWithValue("@jedinicaMere", sf.JedinicaMere);
cmd.Parameters.AddWithValue("@jedinicnacena", sf.JedinicnaCena);
cmd.Parameters.AddWithValue("@vrednost", sf.Vrednost);
cmd.Parameters.AddWithValue("@procenatRabata", sf.ProcenatRabata);
cmd.Parameters.AddWithValue("@iznosRabata", sf.IznosRabata);
cmd.Parameters.AddWithValue("@umanjenostZaRabat", sf.UmanjenoZaRabat);
cmd.Parameters.AddWithValue("@ukupanPorez", sf.UkupanPorez);
cmd.Parameters.AddWithValue("@faktura_idFakture", sf.IDFakture);
cmd.ExecuteNonQuery();
}
conn.Close();
}
} //
static void Main(string[] args)
{
try
{
server = new TcpListener(IPAddress.Any, 1337);
server.Start();
Console.WriteLine("Сервер запущен");
MySQLUtils.createTable();
checkAnswersThread = new Thread(new ThreadStart(Network.AnswerHandler.checkAnswers));
checkAnswersThread.Start();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
/// <summary>
/// broj racuna je racun na koji se vrsi tranzakcija
/// novac + za dodavanje - za oduzimanje
/// timestamp se generise unutar metojode
/// </summary>
/// <param name="brojRacuna"></param>
/// <param name="novac"></param>
/// <returns></returns>
public static Racun PromeniStanjeRacunaFirme(long brojRacuna, double novac)
{
Racun r = new Racun();
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = @"UPDATE racun SET
predhodnostanje = trenutnostanje,
trenutnostanje = trenutnostanje + @novac,
datum = @datum WHERE brojracuna = @brojracuna; " ;
string sqlNadji = @"SELECT * from racun WHERE brojracuna = @brojracuna";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@novac", novac);
cmd.Parameters.AddWithValue("@datum", DateTime.Now);
cmd.Parameters.AddWithValue("@brojracuna", brojRacuna);
cmd.ExecuteNonQuery();
}
//za trazenje racuna
using (SqlCommand cmd = new SqlCommand(sqlNadji, conn))
{
cmd.Parameters.AddWithValue("@brojracuna", brojRacuna);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
r.IDRacuna = (int)reader["idracuna"];
r.PredhodnoStanje = (double)(decimal)reader["predhodnostanje"];
r.TrenutnoStanje = (double)(decimal)reader["trenutnostanje"];
r.IDBanke = (int)reader["idbanke"];
r.IDFirme = (int)reader["idfirme"];
r.BrojRacuna = (long)(decimal)reader["brojracuna"];
r.Datum = (DateTime)reader["datum"];
reader.Close();
}
conn.Close();
}
return(r);
}
public static List <Faktura> GetInvoiceByStatusAndId(Firma firma, string tip)
{
List <Faktura> fakture = new List <Faktura>();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = "";
string naziv = "";
if (tip == GlobalConst.STATUS_FAKTURE_KREIRANA)
{
sql = @"SELECT * FROM faktura WHERE nazivdobavljaca = @naziv AND status = '0'";
}
else if (tip == GlobalConst.STATUS_FAKTURE_POSLATA)
{
sql = @"SELECT * FROM faktura WHERE nazivkupca = @naziv AND status = '1'";
}
else if (tip == GlobalConst.STATUS_FAKTURE_PLACENA)
{
sql = @"SELECT * FROM faktura WHERE nazivkupca = @naziv AND status = '2'";
}
else
{
sql = @"SELECT * FROM faktura WHERE nazivkupca = @naziv";
}
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@naziv", firma.NazivFirme);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Faktura ret = new Faktura();
ret = ReadFromReader(reader);
fakture.Add(ret);
}
reader.Close();
}
conn.Close();
}
return(fakture);
}
public static NalogZaPlacanje GetNalogZaPlacanjeById(int idNaloga)
{
NalogZaPlacanje stavka = new NalogZaPlacanje();
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = "SELECT * FROM nalogzaplacanje WHERE idnalogazaplacanje = @idnalogazaplacanje";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idnalogazaplacanje", idNaloga);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
stavka = GetFromReader(reader);
reader.Close();
}
conn.Close();
}
return(stavka);
}
public static ZahtevZaDobijanjeIzvoda GetZahtevZaDobijanjeIzvodaById(int idZahteva)
{
ZahtevZaDobijanjeIzvoda zahtev = new ZahtevZaDobijanjeIzvoda();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = "SELECT * FROM zahtevzadobijanjeizvoda WHERE idzzdi = @idzzdi";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idzzdi", idZahteva);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
zahtev = GetFromReader(reader);
reader.Close();
}
conn.Close();
}
return(zahtev);
}
public static StavkaPreseka GetStavkaPresekaById(int idStavkaPreseka)
{
StavkaPreseka stavka = new StavkaPreseka();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = "SELECT * FROM stavkapreseka WHERE idstavkepreseka = @idstavkepreseka ";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idstavkepreseka", idStavkaPreseka);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
stavka = GetStavkaPresekaFromReader(reader);
reader.Close();
}
conn.Close();
}
return(stavka);
}
} //
//
public static void InsertIntoPresek(Presek f)
{
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
string sql = @"INSERT INTO [dbo].[presek]
([brracuna]
,[datumnaloga]
,[brpreseka]
,[prethodnostanje]
,[brpromenaukorist]
,[ukupnoukorist]
,[brpromenanateret]
,[ukupnonateret]
,[novostanje])
VALUES
(@brracuna
,@datumnaloga
,@brpreseka
,@prethodnostanje
,@brpromenaukorist
,@ukupnoukorist
,@brpromenanateret
,@ukupnonateret
,@novostanje )" ;
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@brracuna", f.BrRacuna);
cmd.Parameters.AddWithValue("@datumnaloga", f.DatumNaloga);
cmd.Parameters.AddWithValue("@brpreseka", f.BrPreseka);
cmd.Parameters.AddWithValue("@prethodnostanje", f.PrethodnoStanje);
cmd.Parameters.AddWithValue("@brpromenaukorist", f.BrPromenaUKorist);
cmd.Parameters.AddWithValue("@ukupnoukorist", f.UkupnoUKorist);
cmd.Parameters.AddWithValue("@brpromenanateret", f.BrPromenaNaTeret);
cmd.Parameters.AddWithValue("@ukupnonateret", f.UkupnoNaTeret);
cmd.Parameters.AddWithValue("@novostanje", f.NovoStanje);
cmd.ExecuteNonQuery();
}
conn.Close();
}
} //
public static List <ZahtevZaDobijanjeIzvoda> GetAllZahtevZaDobijanjeIzvoda()
{
List <ZahtevZaDobijanjeIzvoda> zahtevi = new List <ZahtevZaDobijanjeIzvoda>();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = "SELECT * FROM zahtevzadobijanjeizvoda";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ZahtevZaDobijanjeIzvoda zahtev = GetFromReader(reader);
zahtevi.Add(zahtev);
}
reader.Close();
}
conn.Close();
}
return(zahtevi);
}
public static List <NalogZaPlacanje> GetAllNalogZaPlacanje()
{
List <NalogZaPlacanje> nalozi = new List <NalogZaPlacanje>();
using (SqlConnection conn = MySQLUtils.NapraviBankaConn())
{
conn.Open();
string sql = "SELECT * FROM nalogzaplacanje";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
NalogZaPlacanje nalog = GetFromReader(reader);
nalozi.Add(nalog);
}
reader.Close();
}
conn.Close();
}
return(nalozi);
}
public static StavkaFakture GetStavkaById(int stavkaId)
{
StavkaFakture stavka = new StavkaFakture();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = @"SELECT * FROM stavkafakture WHERE idstavke = @idstavke";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@idstavke", stavkaId);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
stavka = ReadFromReader(reader);
reader.Close();
}
conn.Close();
}
return(stavka);
}
public static List <StavkaPreseka> GetAllStavkaPreseka()
{
List <StavkaPreseka> stavke = new List <StavkaPreseka>();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = "SELECT * FROM stavkapreseka";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StavkaPreseka stavka = GetStavkaPresekaFromReader(reader);
stavke.Add(stavka);
}
reader.Close();
}
conn.Close();
}
return(stavke);
}
