private void btnDodajStavke_Click(object sender, EventArgs e)
{
OtpremnicaDTO otpremnica = new OtpremnicaDTO();
fillObject(otpremnica);
VeleprodajaUtil.getDAOFactory().getOtpremnicaDAO().insert(otpremnica);
fillOtpremnice();
}
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);
}
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;
}
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;
}