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