public Kartica(VrstaKartice vrstaKatice, String datumIstekaKartice, String brojK, double cscBroj)
{
id = Globalna.idSvihKartica++;
Vrsta = vrstaKatice;
DatumIsteka = datumIstekaKartice;
Broj = brojK;
Csc = cscBroj;
}
public void UcitajKartice()
{
try
{
string query = "SELECT * FROM KarticaAzure";
ConnectionStringAzure s = new ConnectionStringAzure();
using (SqlConnection c = new SqlConnection(s.konekcija))
{
c.Open();
if (c.State == System.Data.ConnectionState.Open)
{
SqlCommand sc = c.CreateCommand();
sc.CommandText = query;
SqlDataReader reader = sc.ExecuteReader();
while (reader.Read())
{
VrstaKartice vrsta = (VrstaKartice)Enum.Parse(typeof(VrstaKartice), reader.GetString(5));
Kartica k = new Kartica(vrsta, reader.GetString(6), reader.GetString(7), reader.GetDouble(8));
Globalna.nasaAgencija.Kartice.Add(k);
}
if (Globalna.nasaAgencija.Kartice.Count == 0)
{
Globalna.idSvihKartica = 0;
}
else if (Globalna.nasaAgencija.Kartice.Count != 0)
{
Globalna.idSvihKartica = Globalna.nasaAgencija.Kartice.Count;
}
}
c.Close();
}
}
catch (Exception e)
{
Debug.WriteLine("Exception KarticaAzure1: " + e.Message);
}
}
