Пример #1
0
 public static void CheckUniqueOznaka(Stol st, string NewOznaka)
 {
     if (stoloviList.Find(s => s.Oznaka == NewOznaka && s.ID != st.ID) != null)
     {
         throw new ArgumentException("Oznaka stola mora biti jedinstvena.");
     }
 }
Пример #2
0
 public Narudzba(string broj, DateTime datum, OznakaPotvrde oznaka, Stol stol = null)
 {
     Broj         = broj;
     Datum        = datum;
     Oznaka       = oznaka;
     StolNarudzbe = stol;
     Stavke       = new List <StavkaNarudzbe>();
 }
Пример #3
0
        public static void UpdateStol(Stol s)
        {
            SqliteCommand com = DB.con.CreateCommand();

            com.CommandText = String.Format(@"UPDATE Stol SET oznaka = '{0}', broj_stolica = {1} WHERE id = {2} ",
                                            s.Oznaka, s.BrojStolica, s.ID);

            com.ExecuteNonQuery();
            com.Dispose();
        }
Пример #4
0
        public static void DeleteStol(Stol s)
        {
            SqliteCommand com = DB.con.CreateCommand();

            System.Runtime.CompilerServices.RuntimeHelpers.RunClassConstructor(typeof(DBNarudzba).TypeHandle);

            com.CommandText = String.Format(@"UPDATE Narudzba SET id_stol = NULL WHERE id_stol = {0}", s.ID);
            com.ExecuteNonQuery();

            com.CommandText = String.Format(@"DELETE FROM Stol WHERE id = {0}", s.ID);
            com.ExecuteNonQuery();
            com.Dispose();
        }
Пример #5
0
        public static void SaveStol(ref Stol s)
        {
            SqliteCommand com = DB.con.CreateCommand();

            com.CommandText = String.Format(@"INSERT INTO Stol (oznaka, broj_stolica)
				VALUES ('{0}', {1})"                , s.Oznaka, s.BrojStolica);

            com.ExecuteNonQuery();
            com.Dispose();

            SqliteCommand getId = DB.con.CreateCommand();

            getId.CommandText = "SELECT last_insert_rowid()";
            s.ID = (long)getId.ExecuteScalar();
            getId.Dispose();
        }
Пример #6
0
        public static List <Stol> GetStolove()
        {
            List <Stol>   stolovi = new List <Stol>();
            SqliteCommand c       = DB.con.CreateCommand();

            c.CommandText = String.Format(@"SELECT * FROM Stol");

            SqliteDataReader reader = c.ExecuteReader();

            while (reader.Read())
            {
                Stol s = new Stol((long)reader["id"], (string)reader["oznaka"], (int)reader.GetInt64(2));
                stolovi.Add(s);
            }
            c.Dispose();
            return(stolovi);
        }
Пример #7
0
 public static void Delete(Stol s)
 {
     stoloviList.Remove(s);
     DBStol.DeleteStol(s);
     MainWindow.stolChanged();
 }
Пример #8
0
 public static void Add(Stol s)
 {
     stoloviList.Add(s);
     DBStol.SaveStol(ref s);
     MainWindow.stolChanged();
 }
Пример #9
0
        protected void Data_Received(object o, DragDataReceivedArgs args)
        {
            bool success = false;

            Gtk.Widget source = Gtk.Drag.GetSourceWidget(args.Context);
            string     data   = System.Text.Encoding.UTF8.GetString(args.SelectionData.Data);

            switch (args.Info)
            {
            case 0:              // uri-list
                string[] uri_list = Regex.Split(data, "\r\n");
                foreach (string u in uri_list)
                {
                    //if(u.Length > 0)
                    //System.Console.WriteLine("Got URI {0}", u);
                }
                success = true;
                break;

            case 1:             // table
                success = true;
                string name = "NewTable";
                if (source is Button)                  // Samo razmještaj stola
                {
                    name = (source as Button).Name;
                }
                else                      //Drag&Drop novog stola - INSERT
                {
                    int brojStolica;
                    switch (data)
                    {
                    case "Table2Chair": brojStolica = 2; break;

                    case "Table4Chair": brojStolica = 4; break;

                    case "Table6Chair": brojStolica = 6; break;

                    case "Table8Chair": brojStolica = 8; break;

                    default: brojStolica = 2; break;
                    }

                    bool notUnique = true;
                    for (int i = 1; notUnique; i++)
                    {
                        name = "NewTable" + i;
                        Stol s = new Stol(name, brojStolica);
                        try {
                            StoloviPresenter.CheckUniqueOznaka(s, name);
                            StoloviPresenter.Add(s);
                            notUnique = false;
                        } catch (ArgumentException) {}
                    }
                    entryOznaka.Text = "";
                }

                AddNewTableButtonImage(name, data, args.X, args.Y, size);
                SaveToXml();
                break;
            }
            Gtk.Drag.Finish(args.Context, success, true, args.Time);
        }
Пример #10
0
 public Narudzba(long id, string broj, DateTime datum, OznakaPotvrde oznaka, Stol stol = null) : this(broj, datum, oznaka, stol)
 {
     ID = id;
 }