コード例 #1
0
ファイル: Engine.cs プロジェクト: Ventag/DM556-Database
        public List <object> search(TABLE type, string key)
        {
            switch (type)
            {
            case TABLE.DRINKS:
                var drink_collection = database.GetCollection <DrinkInfo>("drinks");
                var drink_return     = drink_collection.Find(x => x.Id == key).ToList();
                return(new List <object>(drink_return));

            case TABLE.RATING:
                var rating_collection = database.GetCollection <RatingInfo>("ratings");
                var rating_return     = rating_collection.Find(x => x.UserId == key).ToList();
                return(new List <object>(rating_return));

            case TABLE.USER:
                var user_collection = database.GetCollection <UserInfo>("users");
                var user_return     = user_collection.Find(x => x.Id == key).ToList();
                return(new List <object>(user_return));

            default:
                print_error("OBI-WAN");
                break;
            }

            return(new List <object>());
        }
コード例 #2
0
ファイル: Engine.cs プロジェクト: Ventag/DM556-Database
        public async void delete(TABLE type, List <string> keys)
        {
            switch (type)
            {
            case TABLE.DRINKS:
                var drink_collection = database.GetCollection <DrinkInfo>("drinks");
                drink_collection.DeleteOne(x => x.Id == keys.ElementAt(0));
                print_info("deleted drink by id \"" + keys.ElementAt(0) + "\"");
                break;

            case TABLE.RATING:
                var rating_collection = database.GetCollection <RatingInfo>("ratings");
                rating_collection.DeleteOne(x => x.UserId == keys.ElementAt(0) && x.DrinkId == keys.ElementAt(1));
                print_info("deleted rating for drinkid \"" + keys.ElementAt(1) + "\" by \"" + keys.ElementAt(0) + "\"");
                break;

            case TABLE.USER:
                var user_collection = database.GetCollection <UserInfo>("users");
                user_collection.DeleteOne(x => x.Id == keys.ElementAt(0));
                print_info("deleted user \"" + keys.ElementAt(0) + "\"");
                break;

            default:
                print_error("OBI-WAN");
                break;
            }
        }
コード例 #3
0
ファイル: SiapTable.cs プロジェクト: sciserver/SkyServerWS
        public void getJpeg(double ra, double dec, double SIZE)
        {
            rescale(SIZE);
            TABLE x = this.RESOURCE[0].TABLE[0];

            setupFields(x);
            x.DATA      = new DATA();
            x.DATA.Item = new TABLEDATA();

            string[] values = new string[FIELDCOUNT];

            // just checking whether or not inside the footprint
            string[][] vals = setupValuesFits(ra, dec, 0.01, null, "u");
            // now we know if there is any real data here
            if (vals.Length == 0)
            {
                StringBuilder msg = new StringBuilder();
                msg.AppendFormat("POS={0},{1} outside SDSS footprint", ra, dec);
                // put out error message in INFO tag
                this.reportError(msg.ToString());
            }
            else
            {
                int jpg = 0;
                setupValuesJpeg(values, ra, dec, SIZE);
                jpg++;

                TABLEDATA tdata = new TABLEDATA();
                x.DATA.Item = tdata;
                tdata.TR    = new TR[jpg];    // Jpeg
                setupData(x.DATA, 0, values); // for Jpeg
            }
        }
コード例 #4
0
        private void ACTION_OF_TABLE_Load(object sender, EventArgs e)
        {
            TABLE tbParent = frm_ListTable.currentTalbe != null ? frm_ListTable.currentTalbe : NG_UI.frmMain.currentTalbe != null ? NG_UI.frmMain.currentTalbe : null;

            currentTalbe    = BUSTable.Instance.getCurrentTable(tbParent.ID);
            this.Text       = "Bàn " + currentTalbe.TABLE_NAME.ToString();
            lbInfor.Visible = false;
            setDataForStatusCB();
            txtTableName.Text       = currentTalbe.TABLE_NAME.ToString();
            cbStatus.Text           = currentTalbe.STATUS.ToString();
            dtgListOrder.DataSource = BUSOrder.Instance.getListDetailOrderByTableID(currentTalbe.ID);
            for (int i = 0; i < dtgListOrder.Rows.Count; i++)
            {
                dtgListOrder.Rows[i].Cells[0].Value = i + 1;
            }
            this.dtgListOrder.Columns["FOOD_ID"].Visible  = false;
            this.dtgListOrder.Columns["DRINK_ID"].Visible = false;
            this.dtgListOrder.Columns["ID_ORDER"].Visible = false;
            this.dtgListOrder.Columns["ID"].Visible       = false;
            btnTotalMoney.Text = BUSOrder.Instance.TotalMoney(currentTalbe.ID).ToString();
            if (BUSOrder.Instance.TotalMoney(currentTalbe.ID) == 0)
            {
                btnCash.Enabled = false;
            }
        }
コード例 #5
0
        public static List <TABLE> getLista(int id)
        {
            string sql = "SELECT ao.idOrder, ao.createDate, pr.name, au.fullname, ad.address " +
                         "FROM APPORDER ao, ADDRESS ad, PRODUCT pr, APPUSER au " +
                         "WHERE ao.idProduct = pr.idProduct " +
                         "AND ao.idAddress = ad.idAddress " +
                         "AND ad.idUser = au.idUser " +
                         "AND au.idUser = " + id;

            DataTable    dt   = ConnectionDB.ExecuteQuery(sql);
            List <TABLE> list = new List <TABLE>();

            foreach (DataRow row in dt.Rows)
            {
                TABLE ad = new TABLE();
                ad.idOrder    = Convert.ToInt32(row[0].ToString());
                ad.createDate = row[1].ToString();
                ad.name       = row[2].ToString();
                ad.fullname   = row[3].ToString();
                ad.address    = row[4].ToString();

                list.Add(ad);
            }

            return(list);
        }
コード例 #6
0
ファイル: ScrollList.cs プロジェクト: stevenpark88/PokerGame
    void CreateList(TABLE table)
    {
//		//int count = rumManager.tables.Count;
//		int count = GameObject.FindGameObjectWithTag ("RoomListPanel").GetComponent<RoomListScript> ().tablesList.Count;
//		Debug.Log ("create list " + count + "... " + table.minChips + "... " + table.roomId);
//
//		string sbChips = table.minChips;
//
//		string bbChips = "";			// = (int.Parse(sbChips)*2).ToString();
//		string userMinChips = "";		// = (int.Parse(sbChips)*20).ToString();
//		string userMaxChips = "";       // = (int.Parse(userMinChips)*20).ToString();
//
//		if (sbChips != null) {
//			bbChips = (int.Parse (sbChips) * 2).ToString ();
//			userMinChips = (int.Parse (sbChips) * 20).ToString ();
//			userMaxChips = (int.Parse (userMinChips) * 20).ToString ();
//		}
//
//
//		GameObject g = Instantiate(itemPrefab) as GameObject;
//		g.transform.SetParent(transform);
//		g.transform.localScale = Vector3.one;
//		g.transform.localPosition = Vector3.zero;
//
//		item.Add(g.transform);
//		g.SetActive(true);
//
//		layoutElement(g).minHeight = itemHeight;
//		JoinRoomRow row = g.GetComponent<JoinRoomRow>();
//		row.roomNameText.text = table.roomName;
//		row.blindText.text = sbChips+" / "+bbChips;
//		row.chipsText.text = userMinChips+" / "+userMaxChips;
//		row.totalPlayersText.text = table.totalUsers + "/" + table.maxUsers;
//		row.roomid = table.roomId;
    }
コード例 #7
0
ファイル: DataBase.cs プロジェクト: steiiin/rw_cos_mei
        //################################################################################

        private string SQL_BUILDER_TABLE(TABLE type)
        {
            return(type switch
            {
                TABLE.FEED => "CREATE TABLE " + FEED_TABLE +
                "(" + FEED_TABLE_COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                FEED_TABLE_COL_KEY + " TEXT NOT NULL, " +
                FEED_TABLE_COL_TITLE + " TEXT NOT NULL, " +
                FEED_TABLE_COL_DATE + " INTEGER NOT NULL, " +
                FEED_TABLE_COL_AUTHOR + " TEXT NOT NULL, " +
                FEED_TABLE_COL_BODY + " TEXT NOT NULL, " +
                FEED_TABLE_COL_READ + " TEXT NOT NULL);",
                TABLE.SHIFTS => "CREATE TABLE " + SHIFT_TABLE +
                "(" + SHIFT_TABLE_COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                SHIFT_TABLE_COL_KEY + " TEXT NOT NULL, " +
                SHIFT_TABLE_COL_TITLE + " TEXT NOT NULL, " +
                SHIFT_TABLE_COL_MONTH + " INTEGER NOT NULL, " +
                SHIFT_TABLE_COL_YEAR + " INTEGER NOT NULL, " +
                SHIFT_TABLE_COL_UPDATE + " INTEGER NOT NULL, " +
                SHIFT_TABLE_COL_VERSION + " TEXT NOT NULL, " +
                SHIFT_TABLE_COL_READ + " TEXT NOT NULL);",
                TABLE.ATTACHMENT => "CREATE TABLE " + ATTACH_TABLE +
                "(" + ATTACH_TABLE_COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                ATTACH_TABLE_COL_KEY + " TEXT NOT NULL, " +
                ATTACH_TABLE_COL_OWNER + " INTEGER NOT NULL, " +
                ATTACH_TABLE_COL_OWNERID + " TEXT NOT NULL, " +
                ATTACH_TABLE_COL_FILENAME + " TEXT NOT NULL, " +
                ATTACH_TABLE_COL_REMOTE + " TEXT NOT NULL, " +
                ATTACH_TABLE_COL_LOCAL + " TEXT);",
                _ => string.Empty,
            });
コード例 #8
0
ファイル: Engine.cs プロジェクト: Ventag/DM556-Database
        public List <object> search(TABLE type, string key, string subkey)
        {
            switch (type)
            {
            case TABLE.DRINKS:
                var drink_collection          = database.GetCollection <DrinkInfo>("drinks");
                List <DrinkInfo> drink_return = null;

                if (key == "gin")
                {
                    drink_return = drink_collection.Find(x => x.Gin == subkey).ToList();
                }
                else if (key == "tonic")
                {
                    drink_return = drink_collection.Find(x => x.Tonic == subkey).ToList();
                }
                else if (key == "garnish")
                {
                    drink_return = drink_collection.Find(x => x.Garnish == subkey).ToList();
                }
                else if (key == "user")
                {
                    drink_return = drink_collection.Find(x => x.UserId == subkey).ToList();
                }
                return(new List <object>(drink_return));

            default:
                print_error("OBI-WAN");
                break;
            }

            return(new List <object>());
        }
コード例 #9
0
ファイル: SiapTable.cs プロジェクト: sciserver/SkyServerWS
        /// <summary>
        /// This sets up metadata for the votable
        /// </summary>
        public void getMetadata()
        {
            this.INFO[0].value = "METADATA";
            TABLE x = this.RESOURCE[0].TABLE[0];

            // add the fields with UCDs etc
            setupFields(x);
        }
コード例 #10
0
 public void UpdateTable(TABLE table)
 {
     using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext()) {
         TABLE tb = (from t in db.TABLEs where t.ID == table.ID select t).FirstOrDefault();
         tb.STATUS     = table.STATUS;
         tb.TABLE_NAME = table.TABLE_NAME;
         db.SubmitChanges();
     }
 }
コード例 #11
0
        public UserMoviedataRepository(string tableName)
        {
            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(Config.conn_string);
            CloudTableClient    tableClient    = storageAccount.CreateCloudTableClient(new TableClientConfiguration());

            TABLE_NAME = tableName;
            TABLE      = tableClient.GetTableReference(TABLE_NAME);
            TABLE.CreateIfNotExists();
        }
コード例 #12
0
        public CatalogRepository()
        {
            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(Config.conn_string);
            CloudTableClient    tableClient    = storageAccount.CreateCloudTableClient(new TableClientConfiguration());

            TABLE_NAME = Config.GENREDATATABLE_NAME;
            TABLE      = tableClient.GetTableReference(TABLE_NAME);
            TABLE.CreateIfNotExists();
        }
コード例 #13
0
 public void DeleteTable(TABLE table)
 {
     using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
     {
         TABLE tb = (from t in db.TABLEs where t.ID == table.ID select t).FirstOrDefault();
         db.TABLEs.DeleteOnSubmit(tb);
         db.SubmitChanges();
     }
 }
コード例 #14
0
 public TABLE getCurrentTable(int tableID)
 {
     using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
     {
         TABLE table = new TABLE();
         table = (from tb in db.TABLEs where tb.ID == tableID select tb).FirstOrDefault();
         return(table);
     }
 }
コード例 #15
0
ファイル: ScrollList.cs プロジェクト: stevenpark88/PokerGame
    public void Init(TABLE t1)
    {
        CreateList(t1);
        layout         = GetComponent <VerticalLayoutGroup>();
        layout.padding = margins;
        layout.spacing = spacing;

        SetScrollViewHeight();
    }
コード例 #16
0
        private void table_button_click(object sender, EventArgs e)
        {
            Button btn   = sender as Button;
            char   index = btn.Name[btn.Name.Length - 1];

            currentTalbe = tables[int.Parse(index.ToString())];
            TABLE_UI.btnMoney ob = new TABLE_UI.btnMoney();
            ob.FormClosed += new FormClosedEventHandler(ob_FormClosed);
            ob.ShowDialog();
        }
コード例 #17
0
        public TABLE GetTableByName(int tableName)
        {
            TABLE tb = null;

            using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
            {
                tb = (from t in db.TABLEs where t.TABLE_NAME == tableName select t).FirstOrDefault();
                return(tb);
            }
        }
コード例 #18
0
 public bool updateStatusTableNotAvailable(int idTable)
 {
     using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
     {
         TABLE tb = db.TABLEs.Single(p => p.ID == idTable);
         tb.STATUS = 1;
         db.SubmitChanges();
         return(true);
     }
 }
コード例 #19
0
    public void loadAvailableRoomsOnZone(LiveRoomInfoEvent liveRoomInfoEvent)
    {
        appwarp.currentRoomId = liveRoomInfoEvent.getData().getId();
        TABLE table = new TABLE();

        Dictionary <string, object> rumData = liveRoomInfoEvent.getProperties();

        if (rumData.ContainsKey("ROOM_NAME"))
        {
            table.roomName = rumData ["ROOM_NAME"].ToString();
        }

        if (rumData.ContainsKey("MINCHIPS"))
        {
            table.minChips = rumData ["MINCHIPS"].ToString();
        }

        if (liveRoomInfoEvent.getJoinedUsers() != null)
        {
            table.totalUsers = liveRoomInfoEvent.getJoinedUsers().Length;
        }
        table.maxUsers = 9;

        Debug.Log(">>> " + liveRoomInfoEvent.getJoinedUsers() + "... " + liveRoomInfoEvent.getData().getId());

        table.roomId = liveRoomInfoEvent.getData().getId();
        //tablesList.Add (table);

        GameObject.FindGameObjectWithTag("RoomListPanel").GetComponentInChildren <ScrollList> ().Init(table);

//		Dictionary<string, object> data = eventObj.getProperties();
//		tabl = new TABLE();
//		if(data.ContainsKey("MINCHIPS"))
//		{
//			tabl.minChips = data["MINCHIPS"].ToString();
//
//		}
//		if(data.ContainsKey("ROOMNAME"))
//		{
//			tabl.roomName = data["ROOMNAME"].ToString();
//		}
//		tabl.roomId = eventObj.getData().getId();
//		rumManager.tables.Add(tabl);



//		if(txtAllRooms.text.Contains("Loading")){
//			txtAllRooms.text = "";
//		}
//		appwarp.currentRoomId = liveRoomInfoEvent.getData ().getId ();
//		txtSelectedRoom.text = "Selected Room : "+liveRoomInfoEvent.getData ().getName ();
//
//		txtAllRooms.text= txtAllRooms.text + "\n"+liveRoomInfoEvent.getData().getName();
    }
コード例 #20
0
ファイル: RoomManager.cs プロジェクト: stevenpark88/PokerGame
    public void OnGetLiveRoomInfo(bool result, TABLE tbl)
    {
        Debug.Log("info " + tbl.roomId + ".. " + tbl.minChips + ".. " + tbl.roomName + ".. " + tables.Count);
        if (result)
        {
//			menuHandler.LoginPanel.SetActive(false);
//			menuHandler.RoomeMenuPanel.SetActive(true);
//
//			menuHandler.RoomeMenuPanel.GetComponentInChildren<ScrollList>().Init(tbl);
        }
    }
コード例 #21
0
        public void AddNewTable(int tableName)
        {
            TABLE tb = new TABLE();

            using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
            {
                tb.TABLE_NAME = tableName;
                tb.STATUS     = 0;
                db.TABLEs.InsertOnSubmit(tb);
                db.SubmitChanges();
            }
        }
コード例 #22
0
 public void PayMent(int tableID)
 {
     using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
     {
         ORDER order = new ORDER();
         TABLE table = new TABLE();
         order        = (from o in db.ORDERs where o.ID_TABLE == tableID && o.PAY == 0 select o).FirstOrDefault();
         order.PAY    = 1;
         table        = (from tb in db.TABLEs where tb.ID == tableID select tb).FirstOrDefault();
         table.STATUS = 0;
         db.SubmitChanges();
     }
 }
コード例 #23
0
ファイル: UserManager.cs プロジェクト: stevenpark88/PokerGame
    public void OnCreateRoomCallback(bool result, string room_id)
    {
        if (result)
        {
            TABLE tbl = new TABLE();
            Debug.Log("create rooom done");

            tbl.roomId   = room_id;
            tbl.roomName = UserManager.instance.roomName;
            tbl.minChips = UserManager.instance.minChips;

//			menuHandler.CreateRoomPanel.SetActive(false);
//			menuHandler.RoomeMenuPanel.SetActive(true);
//			menuHandler.RoomeMenuPanel.GetComponentInChildren<ScrollList>().Init(tbl);
        }
    }
コード例 #24
0
ファイル: Engine.cs プロジェクト: Ventag/DM556-Database
        public async Task list_one_type(TABLE type, List <object> objects)
        {
            switch (type)
            {
            case TABLE.DRINKS:
                foreach (var obj in objects)
                {
                    var drink = (DrinkInfo)obj;
                    Console.WriteLine();
                    Console.WriteLine("User:        "******"Gin:         " + drink.Gin);
                    Console.WriteLine("Tonic:       " + drink.Tonic);
                    Console.WriteLine("Garnish:     " + drink.Garnish);
                    Console.WriteLine("Description: " + drink.Description);
                }
                break;

            case TABLE.RATING:
                foreach (var obj in objects)
                {
                    var rating = (RatingInfo)obj;
                    Console.WriteLine();
                    Console.WriteLine("User:      "******"DrinkID:   " + rating.DrinkId);
                    Console.WriteLine("Comment:   " + rating.Comment);
                    Console.WriteLine("Helpful:   " + rating.Helpfull);
                    Console.WriteLine("Unhelpful: " + rating.Unhelpfull);
                }
                break;

            case TABLE.USER:
                foreach (var obj in objects)
                {
                    var user = (UserInfo)obj;
                    Console.WriteLine();
                    Console.WriteLine("User: " + user.Id);
                }
                break;

            default:
                break;
            }
        }
コード例 #25
0
ファイル: MainWindow.xaml.cs プロジェクト: wcarlo99/BI5
        private void BTN_nuova_partita_Click(object sender, RoutedEventArgs e)
        {
            #region INIZIALIZZAZIONE

            TABLE.NuovaPartita();
            TABLE.partita.DistribuisciCarte();

            LV.Children.Clear();

            for (int i = 0; i < 5; i++)
            {
                var g = TABLE.giocatori[i];
                g.OrdinaCarte();
                g.UC       = new UCgiocatore(g);
                g.Compagno = null;
                Grid.SetRow(g.UC, i);
                LV.Children.Add(g.UC);
            }

            #endregion
        }
コード例 #26
0
        public int GetNumberOfRecords(TABLE t)
        {
            int count = -1;

            try
            {
                // Open connection
                conn.Open();

                // Instantiate a new command
                SqlCommand cmd = new SqlCommand("select count(*) from " + (t == TABLE.Person ? "Person" : (t == TABLE.Adresse ? "Adresse" : "TelefonNr")), conn);

                // Send command
                count = (int)cmd.ExecuteScalar();
            }
            finally
            {
                // Close connection
                conn?.Close();
            }
            return(count);
        }
コード例 #27
0
    public static void Main(string[] args)
    {
        int i, num, tab = 0;

        do
        {
            Console.WriteLine("\n\t\t\t PLEASE ENTER A
		NUMBER FOR PRINT TABLE"        );
            num = Convert.ToInt32(Console.ReadLine());

            i = 1;

            do
            {
                tab = num * i;
                Console.WriteLine(tab);
                i++;
            }while(i <= 10);
            Console.WriteLine("\n\t\t\t DO YOU WANT TO CONTINUE [0-> 
		EXIT 1-> CONTINUE]"        );
            num = Convert.ToInt32(Console.ReadLine());
        }while(num != 0);
    }
コード例 #28
0
ファイル: SiapTable.cs プロジェクト: sciserver/SkyServerWS
        /// <summary>
        /// This sets up the resource and table data for the votable
        /// </summary>
        /// <param name="ra"></param>
        /// <param name="dec"></param>
        /// <param name="size"></param>
        public void populate(double ra, double dec, double size1, double?size2, string format, string bandpass)
        {
            if (size1 == 0)
            {
                size1 = 512.0 * this.scale / 3600.0;             // Set up 512 pixels ~ 0.05 degree
            }
            // as default when size = 0
            try
            {
                this.dobandpass       = bandpass != null && !bandpass.Equals("*") && (bandpass.Length > 0);
                this.RESOURCE         = new RESOURCE[1];
                this.RESOURCE[0]      = new RESOURCE();
                this.RESOURCE[0].type = RESOURCEType.results;
                INFO info = new INFO();

                int ind = 0;
                this.INFO        = new INFO[3];
                this.INFO[ind++] = info;
                info.name        = "QUERY_STATUS";
                info.value       = "OK";
                ind = addUrlInfo(ind);

                TABLEDATA theData = new TABLEDATA();

                this.RESOURCE[0].TABLE = new TABLE[1];
                TABLE x = new TABLE();
                this.RESOURCE[0].TABLE[0] = x;;

                x.DATA      = new DATA();
                x.DATA.Item = theData;

                // add the fields with UCDs etc
                setupFields(this.RESOURCE[0].TABLE[0]);

                string[] values = new string[FIELDCOUNT];

                // go off and get the fits entries
                string[][] vals = setupValuesFits(ra, dec, size1, size2, bandpass);
                // now we know if there is any real data here
                if (vals.Length == 0)
                {
                    // put out error message in INFO tag
                    StringBuilder msg = new StringBuilder();
                    msg.AppendFormat("POS={0},{1} outside SDSS footprint", ra, dec);
                    this.reportError(msg.ToString());
                }
                else
                {
                    // create the Jpeg Entry
                    int    jpg    = 0;
                    string form   = format.ToUpper();
                    bool   dojpg  = (form.IndexOf("JP") >= 0 || form.IndexOf("ALL") >= 0 || form.IndexOf("GRAPHIC") >= 0) && !dobandpass;
                    bool   dofits = (form.IndexOf("FITS") >= 0 || form.IndexOf("ALL") >= 0);

                    double size = size1;
                    if (size2.HasValue)
                    {
                        size = Math.Sqrt(size1 * size1 + size2.Value * size2.Value);
                    }

                    if (dojpg)
                    {
                        rescale(size);
                        setupValuesJpeg(values, ra, dec, size);
                        jpg++;
                    }
                    int nr = jpg;
                    if (dofits)
                    {
                        nr += vals.Length;
                    }

                    theData.TR = new TR[nr];// all fits (if required) + Jpeg(if its there)

                    if (dojpg)
                    {
                        setupData(x.DATA, 0, values);// for Jpeg
                    }
                    // add all fits info
                    if (dofits)
                    {
                        for (int s = 0; s < vals.Length; s++)
                        {
                            setupData(x.DATA, s + jpg, vals[s]);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                this.reportError(e.ToString());
            }
        }
コード例 #29
0
ファイル: Engine.cs プロジェクト: Ventag/DM556-Database
        public async Task insert(TABLE type, List <string> data)
        {
            print_info("inserting data into database");
            switch (type)
            {
            case TABLE.DRINKS:
                DrinkInfo drink = new DrinkInfo
                {
                    UserId      = data.ElementAt(0),
                    Gin         = data.ElementAt(1),
                    Tonic       = data.ElementAt(2),
                    Garnish     = data.ElementAt(3),
                    Description = data.ElementAt(4),
                    Id          = data.ElementAt(1) + data.ElementAt(2) + data.ElementAt(3)
                };

                var drink_collection = database.GetCollection <DrinkInfo>("drinks");

                if (search(TABLE.DRINKS, drink.Id).Count() > 0)
                {
                    print_error("drink already exists");
                    return;
                }

                print_info("adding drink to database");
                drink_collection.InsertOne(drink);
                break;

            case TABLE.RATING:
                RatingInfo rating = new RatingInfo
                {
                    Id         = ObjectId.GenerateNewId(),
                    UserId     = data.ElementAt(0),
                    DrinkId    = data.ElementAt(1),
                    Rating     = int.Parse(data.ElementAt(2)),
                    Comment    = data.ElementAt(3),
                    Helpfull   = 0,
                    Unhelpfull = 0
                };

                var rating_collection = database.GetCollection <RatingInfo>("ratings");
                var rating_result     = search(TABLE.RATING, rating.UserId);

                foreach (var r in rating_result)
                {
                    var res = (RatingInfo)r;
                    if (res.DrinkId == rating.DrinkId)
                    {
                        print_error("rating for drink by user already exists");
                        return;
                    }
                }

                print_info("adding rating to database");

                rating_collection.InsertOne(rating);
                break;

            case TABLE.USER:
                UserInfo user = new UserInfo
                {
                    Id = data.ElementAt(0)
                };

                var user_collection = database.GetCollection <UserInfo>("users");
                if (search(TABLE.USER, user.Id).Count() > 0)
                {
                    print_error("user already exists");
                    return;
                }

                print_info("adding user to database");
                user_collection.InsertOne(user);
                break;

            default:
                print_error("OBI-WAN");
                break;
            }
        }
コード例 #30
0
ファイル: SiapTable.cs プロジェクト: sciserver/SkyServerWS
        /// <summary>
        /// Inserts all the Field ucds for the table
        /// </summary>
        /// <param name="t"></param>
        public void setupFields(TABLE t)
        {
            int n = FIELDCOUNT;

            t.Items = new object[n];
            n       = 0;

            FIELD f = new FIELD();

            t.Items[n]  = f;
            f.datatype  = dataType.@char;
            f.ID        = "Title";
            f.ucd       = "VOX:Image_Title";
            f.arraysize = "*";
            n++;

            f          = new FIELD();
            t.Items[n] = f;
            f.datatype = dataType.@int;
            f.ID       = "width";
            f.ucd      = "VOX:Image_Pix_Width";
            n++;

            f          = new FIELD();
            t.Items[n] = f;
            f.datatype = dataType.@int;
            f.ID       = "height";
            f.ucd      = "VOX:Image_Pix_Height";
            n++;

            f          = new FIELD();
            t.Items[n] = f;
            f.datatype = dataType.@double;
            f.ID       = "size";
            f.ucd      = "VOX:Image_Size";
            n++;

            f          = new FIELD();
            t.Items[n] = f;
            f.datatype = dataType.@double;
            f.ID       = "RA";
            f.ucd      = "POS_EQ_RA_MAIN";
            n++;

            f          = new FIELD();
            t.Items[n] = f;
            f.datatype = dataType.@double;
            f.ID       = "DEC";
            f.ucd      = "POS_EQ_DEC_MAIN";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@double;
            f.ID        = "scale";
            f.ucd       = "VOX:Image_Scale";
            f.arraysize = "*";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@char;
            f.ID        = "format";
            f.ucd       = "VOX:Image_Format";
            f.arraysize = "*";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@char;
            f.ID        = "url";
            f.ucd       = "VOX:Image_AccessReference";
            f.arraysize = "*";
            n++;

            f          = new FIELD();
            t.Items[n] = f;
            f.datatype = dataType.@double;
            f.ID       = "equinox";
            f.ucd      = "VOX:Image_Equinox";
            n++;

            f          = new FIELD();
            t.Items[n] = f;
            f.datatype = dataType.@int;
            f.ID       = "naxes";
            f.ucd      = "VOX:Image_Naxes";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@int;
            f.ID        = "naxis";
            f.ucd       = "VOX:Image_Naxis";
            f.arraysize = "*";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@char;
            f.ID        = "crtype";
            f.ucd       = "VOX:WCS_CoordProjection";
            f.arraysize = "*";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@double;
            f.ID        = "crpix";
            f.ucd       = "VOX:WCS_CoordRefPixel";
            f.arraysize = "*";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@double;
            f.ID        = "crval";
            f.ucd       = "VOX:WCS_CoordRefValue";
            f.arraysize = "*";
            n++;

            f           = new FIELD();
            t.Items[n]  = f;
            f.datatype  = dataType.@double;
            f.ID        = "cdval";
            f.ucd       = "VOX:WCS_CDMatrix";
            f.arraysize = "*";
            n++;
        }