public static ObservableCollection <TipNamestaja> Search(Prikaz p, String s)
{
var tipoviNamestaja = new ObservableCollection <TipNamestaja>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM TipNamestaja WHERE Obrisan=0 and Naziv like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "TipNamestaja"); // Query se izvrsava
foreach (DataRow row in ds.Tables["TipNamestaja"].Rows)
{
var tn = new TipNamestaja();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tipoviNamestaja.Add(tn);
}
}
break;
}
return(tipoviNamestaja);
}
/// <summary>
/// Dretva koja zapravo provodi pravo testiranje
/// </summary>
private void TestThread(object list_att)
{
List <object> att = (List <object>)list_att;
try
{
IVisualView graph = (IVisualView)att[1];
Prikaz newPrikaz = (Prikaz)att[2];
Tester.StartTesting();
foreach (Point i in newPrikaz.getPoints())
{
graph.DrawPoint(i);
}
foreach (Line l in newPrikaz.getLines())
{
graph.DrawLine(l);
}
PrikazRepos.Instance().AddPrikaz(newPrikaz);
graph.ShowView(newPrikaz.Name);
}
catch (CrtajMeException e)
{
IMainForm frm = (IMainForm)att[0];
frm.ShowErrorMessage(e.getMsg());
}
}
public void UbaciPrikazUSkupRazlicitiTipovi()
{
Skup s = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("test", "TipFunkcija", 10);
Prikaz p = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("prikaz", 1, "TipTocke");
s.AddPrikaz(p);
}
public Prikaz GetPrikazi2(String sala, String datum, String vreme, String Bioskop)
{
var query = new CypherQuery("match (n:Prikaz)-[:U_SALI]-(a:Sala)-[:POSEDUJE]-(b:Bioskop) where n.datum='" + datum + "' and n.vreme='" + vreme + "' and a.brojSale='" + sala + "' and b.naziv='" + Bioskop + "' return n", new Dictionary <string, object>(), CypherResultMode.Set);
Prikaz prikaz = ((IRawGraphClient)client).ExecuteGetCypherResults <Prikaz>(query).SingleOrDefault();
return(prikaz);
}
public static ObservableCollection <DodatnaUsluga> Search(Prikaz p, String s)
{
var du = new ObservableCollection <DodatnaUsluga>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM DodatnaUsluga WHERE Obrisan=0 and Naziv like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "DodatnaUsluga"); // Query se izvrsava
foreach (DataRow row in ds.Tables["DodatnaUsluga"].Rows)
{
var d = new DodatnaUsluga();
d.Id = int.Parse(row["Id"].ToString());
d.Naziv = row["Naziv"].ToString();
d.Obrisan = bool.Parse(row["Obrisan"].ToString());
d.Cena = double.Parse(row["Cena"].ToString());
du.Add(d);
}
}
break;
case Prikaz.Cena:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM DodatnaUsluga WHERE Obrisan=0 and Cena like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "DodatnaUsluga"); // Query se izvrsava
foreach (DataRow row in ds.Tables["DodatnaUsluga"].Rows)
{
var d = new DodatnaUsluga();
d.Id = int.Parse(row["Id"].ToString());
d.Naziv = row["Naziv"].ToString();
d.Obrisan = bool.Parse(row["Obrisan"].ToString());
d.Cena = double.Parse(row["Cena"].ToString());
du.Add(d);
}
}
break;
}
return(du);
}
public void IzbrisiPrikazIzSkupa()
{
Skup noviSkup = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("novi", "TipFunkcija", 10);
Prikaz p = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("prikaz", 5, "TipFunkcija");
noviSkup.AddPrikaz(p);
Assert.AreEqual(1, noviSkup.GetListNameOfPrikaz().Count);
noviSkup.DeletePrikaz(p);
Assert.AreEqual(0, noviSkup.GetListNameOfPrikaz().Count);
}
public void UbaciPrikaz()
{
Prikaz noviPrikaz = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("test", 10, "TipFunkcija");
Console.WriteLine(PrikazRepos.Instance().GetListaTipova()[0]);
PrikazRepos.Instance().AddPrikaz(noviPrikaz);
Assert.AreEqual("test", PrikazRepos.Instance().GetPrikazByName("test").Name);
Assert.AreEqual("TipFunkcija", PrikazRepos.Instance().GetPrikazByName("test").Type);
Assert.AreEqual(10, PrikazRepos.Instance().GetPrikazByName("test").Grade);
}
/// <summary>
/// Generiraju se random prikazi u svrhu pokaza rada
/// </summary>
private void GenerateRandomPrikaz()
{
foreach (string name in PrikazRepos.Instance().ListPrikazByName())
{
Prikaz p = PrikazRepos.Instance().GetPrikazByName(name);
for (double i = 0; i < 5; i += 0.1)
{
p.SaveNumber(i);
p.SaveNumber(2 * rnd.NextDouble() * Math.Sin(i) + 2);
}
}
}
public void SavePrikaz(IVisualView frm, string prikazName, double ocjena)
{
try
{
Prikaz p = PrikazRepos.Instance().GetPrikazByName(prikazName);
p.Grade = ocjena;
}
catch (CrtajMeException e)
{
frm.ShowErrorMessage(e.getMsg());
}
}
public void RacunajProsjekIPrihvatljivost()
{
Skup s = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("test", "TipFunkcija", 10);
Prikaz p1 = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("prikaz1", 2, "TipFunkcija");
Prikaz p2 = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("prikaz2", 4, "TipFunkcija");
Prikaz p3 = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("prikaz3", 3, "TipFunkcija");
s.AddPrikaz(p1);
s.AddPrikaz(p2);
s.AddPrikaz(p3);
Assert.AreEqual(3, s.AverageGrade);
}
public void KomunikacijaPrikaz()
{
Prikaz p = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("prikaz", 5, "TipTocke");
p.SaveNumber(1);
p.SaveNumber(2);
p.SaveNumber(3);
p.SaveNumber(4);
Point t1 = p.getPoints()[0];
Point t2 = p.getPoints()[1];
Assert.IsTrue(t1.X == 1 && t1.Y == 2 && t2.X == 3 && t2.Y == 4);
}
public void RemovePrikazFromSkup(IViewResults frm, string prikazName, string skupName)
{
try
{
Skup s = SkupRepos.Instance().GetSkupByName(skupName);
Prikaz p = PrikazRepos.Instance().GetPrikazByName(prikazName);
s.DeletePrikaz(p);
frm.ShowDetails();
}
catch (CrtajMeException e)
{
frm.ShowErrorMessage(e.getMsg());
}
}
public void InsertPrikazInSKup(IViewResults frm, string prikazName, string skupName)
{
try
{
Prikaz p = PrikazRepos.Instance().GetPrikazByName(prikazName);
Skup s = SkupRepos.Instance().GetSkupByName(skupName);
s.AddPrikaz(p);
frm.ShowDetails();
}
catch (CrtajMeException e)
{
frm.ShowErrorMessage(e.getMsg());
}
}
private void etikete_PreviewKeyDown(object sender, System.Windows.Input.KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
SelectedTag = (Model.Tag)etikete.SelectedItem;
Prikaz.SelectedItem = SelectedTag;
Prikaz.ScrollIntoView(Prikaz.SelectedItem);
oznakaTag.Text = SelectedTag.label;
opisTag.Text = SelectedTag.description;
bojaTag.SelectedColor = (Color)ColorConverter.ConvertFromString(SelectedTag.color);
}
else if (e.Key == Key.F1)
{
HelpProvider.ShowHelp("EtiketePretraga", this);
}
}
private void tipoviLokala_PreviewKeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
SelectedType = (Model.LokalType)tipoviLokala.SelectedItem;
Prikaz.SelectedItem = SelectedType;
Prikaz.ScrollIntoView(Prikaz.SelectedItem);
oznakaTip.Text = SelectedType.key;
imeTip.Text = SelectedType.name;
opisTip.Text = SelectedType.description;
BitmapSource i = new BitmapImage(SelectedType.image_uri);
ikonicaTip.Source = i;
}
else if (e.Key == Key.F1)
{
HelpProvider.ShowHelp("TipoviPretraga", this);
}
}
public void ShowPrikaz(IVisualView graph, string prikazName)
{
try
{
Prikaz newPrikaz = PrikazRepos.Instance().GetPrikazByName(prikazName);
foreach (Point i in newPrikaz.getPoints())
{
graph.DrawPoint(i);
}
foreach (Line l in newPrikaz.getLines())
{
graph.DrawLine(l);
}
graph.ShowView(newPrikaz.Name);
}
catch (CrtajMeException e)
{
graph.ShowErrorMessage(e.getMsg());
}
}
public static ObservableCollection <TipNamestaja> Sort(Prikaz p, NacinSortiranja nn)
{
var tipoviNamestaja = new ObservableCollection <TipNamestaja>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM TipNamestaja WHERE Obrisan=0 Order by Naziv ";
}
else
{
cmd.CommandText = "SELECT * FROM TipNamestaja WHERE Obrisan=0 Order by Naziv desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "TipNamestaja"); // Query se izvrsava
foreach (DataRow row in ds.Tables["TipNamestaja"].Rows)
{
var tn = new TipNamestaja();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tipoviNamestaja.Add(tn);
}
}
break;
}
return(tipoviNamestaja);
}
/// <summary>
/// Generiranje primjera
/// </summary>
private void GenerateObjects()
{
/* Pocetak generiranja umjetnih objekata */
Prikaz noviP = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("Sinus", 5, "TipTocke");
PrikazRepos.Instance().AddPrikaz(noviP);
noviP = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("Kosinus", 1, "TipFunkcija");
PrikazRepos.Instance().AddPrikaz(noviP);
noviP = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("Konvergencija", 2, "TipFunkcija");
PrikazRepos.Instance().AddPrikaz(noviP);
noviP = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz("PSO-dinamika", 3, "TipTocke");
PrikazRepos.Instance().AddPrikaz(noviP);
Skup novi;
novi = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("Genetski algoritam", "TipTocke", 2);
SkupRepos.Instance().AddSkup(novi);
novi = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("SWARM", "TipTocke", 3);
SkupRepos.Instance().AddSkup(novi);
novi = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("Iscrtavanje funkcije", "TipFunkcija", 8);
SkupRepos.Instance().AddSkup(novi);
novi = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("Random", "TipTocke", 2.5);
SkupRepos.Instance().AddSkup(novi);
novi = CrtajMeModel.Factories.SkupFactory.CreateNewSkup("Performance", "TipTocke", 3.5);
SkupRepos.Instance().AddSkup(novi);
GenerateRandomPrikaz();
}
public bool AddPrikaz(String nazivFilma, String nazivBioskopa, String brojSale, String datum, String vreme, String projekcija, String cena)
{
var query = new CypherQuery("match (f:Film {naziv:'" + nazivFilma + "'}), (b:Bioskop {naziv:'" + nazivBioskopa + "'}), (s:Sala {brojSale:'" + brojSale + "'}) where (b)-[:POSEDUJE]->(s)" +
"create (p:Prikaz {datum:'" + datum + "', vreme: '" + vreme + "', projekcija: '" + projekcija + "', cena: '" + cena + "'})" +
"create " +
"(p)-[:U_SALI]->(s), " +
"(b)-[:PRIKAZUJE]->(p), " +
"(p)-[:EMITUJE]->(f)" +
"return p;", new Dictionary <string, object>(), CypherResultMode.Set);
var query1 = new CypherQuery("match (f:Film {naziv:\"" + nazivFilma + "\"}), (b:Bioskop {naziv:\"" + nazivBioskopa + "\"}), (s:Sala {brojSale:'" + brojSale + "'}) where (b)-[:POSEDUJE]->(s) return f;", new Dictionary <string, object>(), CypherResultMode.Set);
Film result = ((IRawGraphClient)client).ExecuteGetCypherResults <Film>(query1).SingleOrDefault();
if (result == null)
{
return(false);
}
Prikaz p = ((IRawGraphClient)client).ExecuteGetCypherResults <Prikaz>(query).SingleOrDefault();
if (p == null)
{
return(false);
}
return(true);
}
/// <summary>
/// Glavna metoda koja testira
/// </summary>
/// <param name="ulazniName">Ime ulaznog obrasca</param>
/// <param name="izlazniName">Ime izlazng obrasca</param>
/// <param name="tipName">Tip prikaza</param>
public void RunTest(IMainForm frm, IVisualView graph, string applicationName, string ulazniName, string izlazniName, string tipName, string prikazName)
{
try
{
UlazniObrazac input = UlazniObrazacRepos.Instance().GetObrazac(ulazniName);
IzlazniObrazac output = IzlazniObrazacRepos.Instance().GetObrazac(izlazniName);
Prikaz newPrikaz = CrtajMeModel.Factories.PrikazFactory.CreateNewPrikaz(prikazName, 0, tipName);
Tester.Config(applicationName, newPrikaz, input, output);
List <object> attList = new List <object>();
attList.Add(frm);
attList.Add(graph);
attList.Add(newPrikaz);
Thread thr = new Thread(new ParameterizedThreadStart(this.TestThread));
thr.Start(attList);
while (!thr.IsAlive)
{
;
}
}
catch (CrtajMeException e)
{
frm.ShowErrorMessage(e.getMsg());
}
}
public IHttpActionResult GetFastReservations()
{
List <Prikaz> reservations = new List <Prikaz>();
Prikaz nova = new Prikaz();
using (var context = new AngularEntities4())
{
var flights = from f in context.Flights
where f.Popust == true
select f;
foreach (Flight f in flights)
{
double razlomak = (double)f.CenaEkonomskeKlase / 100;
double umanjilac = (double)f.ProcenatPopusta * razlomak;
double cena = (double)f.CenaEkonomskeKlase - umanjilac;
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = cena,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta,
MestoNaPopustu = f.MestoNaPopustu
};
}
reservations.Add(nova);
}
return(Ok(reservations));
}
public static ObservableCollection <Namestaj> Search(Prikaz p, String s)
{
var Namestaj = new ObservableCollection <Namestaj>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and Naziv like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Cena:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and Cena like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Kolicina:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and Kolicina like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.TipNamestaja:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and (Select Naziv from TipNamestaja where TipNamestajaId = Id ) like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Akcija:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and (Select Popust from Akcija where AkcijaId = Id ) like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
}
return(Namestaj);
}
public static ObservableCollection <AkcijskaProdaja> Sort(Prikaz p, NacinSortiranja nn)
{
var akcija = new ObservableCollection <AkcijskaProdaja>();
switch (p)
{
case Prikaz.DatumKraja:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 Order by Dk";
}
else
{
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 Order by Dk desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Akcija"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Akcija"].Rows)
{
var a = new AkcijskaProdaja();
a.Id = int.Parse(row["Id"].ToString());
a.Obrisan = bool.Parse(row["Obrisan"].ToString());
a.DatumPocetka = DateTime.Parse(row["Dp"].ToString());
a.DatumKraja = DateTime.Parse(row["Dk"].ToString());
a.popust = int.Parse(row["Popust"].ToString());
akcija.Add(a);
}
}
break;
case Prikaz.DatumPocetka:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 Order by Dp";
}
else
{
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 Order by Dp desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Akcija"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Akcija"].Rows)
{
var a = new AkcijskaProdaja();
a.Id = int.Parse(row["Id"].ToString());
a.Obrisan = bool.Parse(row["Obrisan"].ToString());
a.DatumPocetka = DateTime.Parse(row["Dp"].ToString());
a.DatumKraja = DateTime.Parse(row["Dk"].ToString());
a.popust = int.Parse(row["Popust"].ToString());
akcija.Add(a);
}
}
break;
case Prikaz.Popust:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 Order by Popust";
}
else
{
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 Order by Popust desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Akcija"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Akcija"].Rows)
{
var a = new AkcijskaProdaja();
a.Id = int.Parse(row["Id"].ToString());
a.Obrisan = bool.Parse(row["Obrisan"].ToString());
a.DatumPocetka = DateTime.Parse(row["Dp"].ToString());
a.DatumKraja = DateTime.Parse(row["Dk"].ToString());
a.popust = int.Parse(row["Popust"].ToString());
akcija.Add(a);
}
}
break;
}
return(akcija);
}
public static ObservableCollection <AkcijskaProdaja> Search(Prikaz p, String s)
{
var akcija = new ObservableCollection <AkcijskaProdaja>();
switch (p)
{
case Prikaz.DatumKraja:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 and Dk like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Akcija"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Akcija"].Rows)
{
var a = new AkcijskaProdaja();
a.Id = int.Parse(row["Id"].ToString());
a.Obrisan = bool.Parse(row["Obrisan"].ToString());
a.DatumPocetka = DateTime.Parse(row["Dp"].ToString());
a.DatumKraja = DateTime.Parse(row["Dk"].ToString());
a.popust = int.Parse(row["Popust"].ToString());
akcija.Add(a);
}
}
break;
case Prikaz.DatumPocetka:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 and Dp like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Akcija"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Akcija"].Rows)
{
var a = new AkcijskaProdaja();
a.Id = int.Parse(row["Id"].ToString());
a.Obrisan = bool.Parse(row["Obrisan"].ToString());
a.DatumPocetka = DateTime.Parse(row["Dp"].ToString());
a.DatumKraja = DateTime.Parse(row["Dk"].ToString());
a.popust = int.Parse(row["Popust"].ToString());
akcija.Add(a);
}
}
break;
case Prikaz.Popust:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Akcija WHERE Obrisan=0 and Popust like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Akcija"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Akcija"].Rows)
{
var a = new AkcijskaProdaja();
a.Id = int.Parse(row["Id"].ToString());
a.Obrisan = bool.Parse(row["Obrisan"].ToString());
a.DatumPocetka = DateTime.Parse(row["Dp"].ToString());
a.DatumKraja = DateTime.Parse(row["Dk"].ToString());
a.popust = int.Parse(row["Popust"].ToString());
akcija.Add(a);
}
}
break;
}
return(akcija);
}
public static ObservableCollection <Namestaj> Sort(Prikaz p, NacinSortiranja nn)
{
var Namestaj = new ObservableCollection <Namestaj>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Naziv ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Naziv desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Cena:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Cena ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Cena desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Kolicina:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Kolicina ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Kolicina desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.TipNamestaja:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by TipNamestajaId ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by TipNamestajaId desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Akcija:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by AkcijaId ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by AkcijaId desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
}
return(Namestaj);
}
public static ObservableCollection <DodatnaUsluga> Sort(Prikaz p, NacinSortiranja nn)
{
var du = new ObservableCollection <DodatnaUsluga>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM DodatnaUsluga WHERE Obrisan=0 Order by Naziv";
}
else
{
cmd.CommandText = "SELECT * FROM DodatnaUsluga WHERE Obrisan=0 Order by Naziv desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "DodatnaUsluga"); // Query se izvrsava
foreach (DataRow row in ds.Tables["DodatnaUsluga"].Rows)
{
var d = new DodatnaUsluga();
d.Id = int.Parse(row["Id"].ToString());
d.Naziv = row["Naziv"].ToString();
d.Obrisan = bool.Parse(row["Obrisan"].ToString());
d.Cena = double.Parse(row["Cena"].ToString());
du.Add(d);
}
}
break;
case Prikaz.Cena:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM DodatnaUsluga WHERE Obrisan=0 Order by Cena";
}
else
{
cmd.CommandText = "SELECT * FROM DodatnaUsluga WHERE Obrisan=0 Order by Cena desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "DodatnaUsluga"); // Query se izvrsava
foreach (DataRow row in ds.Tables["DodatnaUsluga"].Rows)
{
var d = new DodatnaUsluga();
d.Id = int.Parse(row["Id"].ToString());
d.Naziv = row["Naziv"].ToString();
d.Obrisan = bool.Parse(row["Obrisan"].ToString());
d.Cena = double.Parse(row["Cena"].ToString());
du.Add(d);
}
}
break;
}
return(du);
}
private void cbxSala_SelectedIndexChanged(object sender, EventArgs e)
{
DataProvider dp = new DataProvider();
Sala sala = new Sala();
if (dp.PoveziBazu() > 0)
{
if (cbxSala.SelectedIndex == -1)
{
return;
}
else
{
Size q = new Size();
q.Width = 0;
flowLayoutPanel1.Controls.Clear();
flowLayoutPanel1.MaximumSize = q;
sala = dp.GetSala(cbxSala.Text, cbxBioskop.Text);
int.TryParse(sala.brojRedova, out brojRedova);
int.TryParse(sala.brojSedistaPoRedu, out brojSedisapoRedu);
Size s = new Size();
s.Width = 20;
s.Height = 20;
Size z = new Size();
int j;
Button b = new Button();
for (int i = 0; i < brojRedova; i++)
{
for (j = 0; j < brojSedisapoRedu; j++)
{
b = new Button();
b.Click += (object sender2, EventArgs e2) =>
{
Button button = sender2 as Button;
// MessageBox.Show(button.Name);
if (button.BackColor != Color.Blue)
{
label10.Visible = true;
String[] ime = button.Name.Split(',');
Sediste sed = new Sediste();
sed.red = ime[0];
sed.brojSedista = ime[1];
sed.zauzeto = true;
sedisteSala.Add(sed);
dugmici.Add(button);
button.BackColor = Color.Blue;
label10.Text = (cena * sedisteSala.Count).ToString() + " RSD";
}
else
{
String[] ime = button.Name.Split(',');
Sediste sed = new Sediste();
sed.red = ime[0];
sed.brojSedista = ime[1];
sed.zauzeto = true;
foreach (Sediste sedi in sedisteSala)
{
if (sedi.brojSedista == sed.brojSedista && sedi.red == sed.red)
{
sedisteSala.Remove(sedi);
return;
}
}
dugmici.Remove(button);
button.BackColor = Color.LightGray;
label10.Text = (cena * sedisteSala.Count).ToString() + " RSD";
}
};
b.BackColor = Color.LightGray;
b.Name = i.ToString() + "," + j.ToString();
b.Text = j.ToString();
b.Size = s;
flowLayoutPanel1.Controls.Add(b);
}
z.Width = flowLayoutPanel1.Width;
flowLayoutPanel1.MaximumSize = z;
}
Prikaz p = dp.GetPrikazi2(cbxSala.Text, cbxDatum.Text, cbxVreme.Text, cbxBioskop.Text);
rezervacija.prikaz = p;
double.TryParse(p.cena, out cena);
}
}
//OVDE UBACITI RACUNANJE CENE I SEDISTA
//REDOVI SU VODORAVNO xD
}
public static ObservableCollection <Korisnik> Sort(Prikaz p, NacinSortiranja nn)
{
var korisnik = new ObservableCollection <Korisnik>();
switch (p)
{
case Prikaz.Ime:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by Ime";
}
else
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by Ime desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
case Prikaz.Prezime:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by Prezime";
}
else
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by Prezime desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
case Prikaz.KorisnickoIme:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by KorisnickoIme";
}
else
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by KorisnickoIme desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
case Prikaz.Lozinka:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by Lozinka";
}
else
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by Lozinka desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
case Prikaz.TipKorisnika:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by TipKorisnika";
}
else
{
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 Order by TipKorisnika desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
}
return(korisnik);
}
public IHttpActionResult GetUser(string datumPoletanja, string datumPovratka, string mestoPoletanja, string mestoSletanja, string klasa, string pravac, int brojPutnika)
{
Prikaz nova = new Prikaz();
//var check = new List<Flight>();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
DateTime dt = DateTime.ParseExact(datumPoletanja, "M/dd/yy, h:mm tt", CultureInfo.InvariantCulture);
DateTime dt2 = DateTime.ParseExact(datumPovratka, "M/dd/yy, h:mm tt", CultureInfo.InvariantCulture);
try
{
using (var context = new AngularEntities4())
{
var flights = from f in context.Flights
where f.DatumPoletanja == dt && f.DatumSletanja == dt2 && f.BrojSedista - brojPutnika != 0 && f.MestoPoletanja == mestoPoletanja && f.MestoSletanja == mestoSletanja
select f;
check = flights.ToList();
if (check.Count == 0)
{
nova.Status = 0;
nova.Message = "Nema rezultata za trazeni let";
result.Add(nova);
}
else
{
foreach (var f in check)
{
if (klasa == "Prva klasa")
{
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = f.CenaPrveKlase,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta
};
}
if (klasa == "Ekonomska klasa")
{
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = f.CenaEkonomskeKlase,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta
};
}
if (klasa == "Biznis klasa")
{
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = f.CenaBiznisKlase,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta
};
}
nova.Status = 2;
result.Add(nova);
}
}
}
}
catch (Exception ex)
{
//nova = new Prikaz();
nova.Status = 1;
nova.Message = "Servis je trenutno nedostupan";
result.Add(nova);
}
}
catch (Exception)
{
//nova = new Prikaz();
nova.Status = 1;
nova.Message = "Servis je trenutno nedostupan";
result.Add(nova);
}
return(Ok(result));
}
public static ObservableCollection <Korisnik> Search(Prikaz p, String s)
{
var korisnik = new ObservableCollection <Korisnik>();
switch (p)
{
case Prikaz.Ime:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 and Ime like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
case Prikaz.Prezime:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 and Prezime like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
case Prikaz.KorisnickoIme:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 and KorisnickoIme like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
case Prikaz.Lozinka:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Korisnik WHERE Obrisan=0 and Lozinka like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Korisnik"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.Obrisan = bool.Parse(row["Obrisan"].ToString());
bool b = bool.Parse(row["TipKorisnika"].ToString());
if (b == true)
{
k.TipKorisnika = TipKorisnika.Prodavac;
}
else
{
k.TipKorisnika = TipKorisnika.Administrator;
}
korisnik.Add(k);
}
}
break;
}
return(korisnik);
}
static void ProvestPrikaz(Prikaz prikaz)
{
if (prikaz == Prikaz.Konec)
{
Konec();
}
else if (prikaz == Prikaz.Doleva)
{
if (PoziceHraceX > 1)
PoziceHraceX--;
}
else if (prikaz == Prikaz.Doprava)
{
if (PoziceHraceX < Console.WindowWidth - 2)
PoziceHraceX++;
}
else if (prikaz == Prikaz.Vystrel)
{
HraciPlochaStrel[Console.WindowHeight - 3, PoziceHraceX] = true;
}
}
