private void btnPrikaziLicniMeni_Click(object sender, EventArgs e) { LicniMeni meni = DataProvider.GetLicniMeni(izabranRestoranID, this.txtKorisnikBroj.Text); if (meni.licniMeniID == null) { MessageBox.Show("Nemate kreiran licni meni."); } else { LicniMeniPrikaziForma forma = new LicniMeniPrikaziForma(izabranRestoranID, this.txtKorisnikBroj.Text); forma.ShowDialog(); } }
public static LicniMeni GetLicniMeni(string restoranID, string korisnikID) { ISession session = SessionManager.GetSession(); LicniMeni meni = new LicniMeni(); if (session == null) { return(null); } Row meniData = session.Execute("select * from \"LicniMeni\" where \"restoranID\" = '" + restoranID + "' AND \"korisnikID\"= '" + korisnikID + "'").FirstOrDefault(); if (meniData != null) { List <string> lista = new List <string>(); meni.restoranID = meniData["restoranID"] != null ? meniData["restoranID"].ToString() : string.Empty; meni.korisnikID = meniData["korisnikID"] != null ? meniData["korisnikID"].ToString() : string.Empty; meni.licniMeniID = meniData["licniMeniID"] != null ? meniData["licniMeniID"].ToString() : string.Empty; meni.spisak = meniData["spisak"] != null ? (IEnumerable <string>)meniData["spisak"]: null; } return(meni); }
public static List <LicniMeni> GetLicniMeniji(string r, string k) { ISession session = SessionManager.GetSession(); List <LicniMeni> meniji = new List <LicniMeni>(); if (session == null) { return(null); } var menijiData = session.Execute("select * from \"LicniMeni\" where \"restoranID\" = '" + r + "' AND \"korisnikID\"= '" + k + "'"); foreach (var meniData in menijiData) { LicniMeni meni = new LicniMeni(); meni.restoranID = meniData["restoranID"] != null ? meniData["restoranID"].ToString() : string.Empty; meni.korisnikID = meniData["korisnikID"] != null ? meniData["korisnikID"].ToString() : string.Empty; meni.licniMeniID = meniData["licniMeniID"] != null ? meniData["licniMeniID"].ToString() : string.Empty; meni.spisak = meniData["spisak"] != null ? (IEnumerable <string>)meniData["spisak"] : null; meniji.Add(meni); } return(meniji); }