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