private void ocitajImeITIp(long id, out string ime, out TipoviPodataka.TipoviKupaca tip) { c = new MySqlCommand(string.Format("SELECT * FROM kupcikarti WHERE id='{0}' AND tipKupca<>'{1}';", id, (int)(TipoviPodataka.TipoviKupaca.BEZ_POPUSTA)), con); MySqlDataReader r = c.ExecuteReader(); if (r.Read()) { ime = r.GetString("imeIPrezime"); tip = (TipoviPodataka.TipoviKupaca)(r.GetInt32("tipKupca")); r.Close(); } else { r.Close(); throw new Exception("nije nadjen nijedan element"); } }
private double ocitajPopust(TipoviPodataka.TipoviKupaca tip) { double popust; c = new MySqlCommand(string.Format("SELECT * FROM tipovikupacakarte WHERE id='{0}';", (int)(tip)), con); MySqlDataReader r = c.ExecuteReader(); if (r.Read()) { popust = r.GetDouble("popust"); r.Close(); } else { r.Close(); throw new Exception("nije nadjen nijedan element"); } return(popust); }