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