public void updateObjectIznos(OtpremnicaDTO otpremnica)
{
MySqlConnection connection = ConnectionPool.checkOutConnection();
MySqlCommand command = new MySqlCommand("iznosOtpremnice", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("rb", otpremnica.RedniBroj);
command.Parameters["rb"].Direction = System.Data.ParameterDirection.Input;
command.Parameters.AddWithValue("@velIznos", otpremnica.VeleprodajniIznos);
command.Parameters["@velIznos"].Direction = System.Data.ParameterDirection.Output;
command.Parameters.AddWithValue("@izSaRabatom", otpremnica.IznosSaRabatom);
command.Parameters["@izSaRabatom"].Direction = System.Data.ParameterDirection.Output;
command.Parameters.AddWithValue("@iznosRabata", otpremnica.IznosRabata);
command.Parameters["@iznosRabata"].Direction = System.Data.ParameterDirection.Output;
command.ExecuteNonQuery();
try
{
otpremnica.IznosRabata = Convert.ToDouble(command.Parameters["@iznosRabata"].Value.ToString());
otpremnica.IznosSaRabatom = Convert.ToDouble(command.Parameters["@izSaRabatom"].Value.ToString());
otpremnica.VeleprodajniIznos = Convert.ToDouble(command.Parameters["@velIznos"].Value.ToString());
}
catch (Exception)
{
}
ConnectionPool.checkInConnection(connection);
}
private void btnDodajStavke_Click(object sender, EventArgs e)
{
OtpremnicaDTO otpremnica = new OtpremnicaDTO();
fillObject(otpremnica);
VeleprodajaUtil.getDAOFactory().getOtpremnicaDAO().insert(otpremnica);
fillOtpremnice();
}
public StavkaOtpremniceDodajForm(OtpremnicaDTO otpremnica)
{
InitializeComponent();
this.otpremnica = otpremnica;
fillStavke();
gbIzabranaRoba.Hide();
fillOtpremnicaData();
fillOtpremnicaValues();
}
public List <StavkaOtpremniceDTO> getByOtpremnica(OtpremnicaDTO otpremnica)
{
MySqlConnection connection = ConnectionPool.checkOutConnection();
MySqlCommand command = connection.CreateCommand();
command.CommandText = qGetByKalkulacija;
command.Parameters.AddWithValue("RedniBroj", otpremnica.RedniBroj);
MySqlDataReader reader = command.ExecuteReader();
List <StavkaOtpremniceDTO> lista = new List <StavkaOtpremniceDTO>();
while (reader.Read())
{
StavkaOtpremniceDTO stavka = readerToStavkaOtpremniceDTO(reader);
stavka.Otpremnica = otpremnica;
stavka.Roba = MySqlRobaDAO.readerToRobaDTO(reader);
stavka.Roba.JedinicaMjere = MySqlJedinicaMjereDAO.readerToJedinicaMjereDTO(reader);
lista.Add(stavka);
}
reader.Close();
ConnectionPool.checkInConnection(connection);
return(lista);
}
public List <OtpremnicaDTO> getAll()
{
MySqlConnection connection = ConnectionPool.checkOutConnection();
MySqlCommand command = connection.CreateCommand();
command.CommandText = qGetAll;
command.Parameters.AddWithValue("PoslovnaGodina", VeleprodajaUtil.PoslovnaGodina);
MySqlDataReader reader = command.ExecuteReader();
List <OtpremnicaDTO> lista = new List <OtpremnicaDTO>();
while (reader.Read())
{
OtpremnicaDTO otpremnica = readerToOtpremnicaDTO(reader);
otpremnica.Partner = MySqlPartnerDAO.readerToPartnerDTO(reader);
otpremnica.Partner.Mjesto = MySqlMjestoDAO.readerToMjestoDTO(reader);
updateObjectIznos(otpremnica);
lista.Add(otpremnica);
}
reader.Close();
ConnectionPool.checkInConnection(connection);
return(lista);
}
private void fillObject(OtpremnicaDTO otpremnica)
{
otpremnica.Partner = (PartnerDTO)cbKupac.Items[cbKupac.SelectedIndex];
otpremnica.Datum = dtpDatumOtpremnice.Value;
otpremnica.PoslovnaGodina = VeleprodajaUtil.PoslovnaGodina;
}
private OtpremnicaDTO readerToOtpremnicaDTO(MySqlDataReader reader)
{
OtpremnicaDTO otpremnica = new OtpremnicaDTO(MySqlStavkaKnjigeTrgovineNaVeliko.readerToStavkaKnjigeTrgovineNaVeliko(reader));
return(otpremnica);
}
