Exemple #1
0
        // Submit knappen i drop-in skjemaet
        private void dropInConfirm_Click(object sender, EventArgs e)
        {
            bool validOrder = ValidateForm();

            if (!validOrder)
            {
                return;
            }

            string  roomType  = dropInComboBox.Text;
            string  fromDate  = dropInFromDate.Value.ToString("yyyy-MM-dd");
            string  toDate    = dropInToDate.Value.ToString("yyyy-MM-dd");
            string  tlf       = dropInPhoneNumber.Text;
            string  firstName = dropInFirstname.Text;
            string  lastName  = dropInLastname.Text;
            DataRow row       = DatabaseManager.GetRowWithSchema("bestillinger");

            row["romtype"]   = roomType;
            row["fradato"]   = fromDate;
            row["tildato"]   = toDate;
            row["tildelt"]   = false;
            row["tlf"]       = tlf;
            row["fornavn"]   = firstName;
            row["etternavn"] = lastName;
            DatabaseManager.InsertRow("bestillinger", row);
            //DatabaseManager.Query("INSERT INTO bestillinger (romtype, fradato, tildato, tlf, fornavn, etternavn)" +
            //"VALUES ('" + roomType + "', '" + fromDate + "', '" + toDate + "', " + tlf + ", '" + foreName + "', '" + afterName + "');");
            DropInMessage.Text      = "Bestillingen har nå blitt registrert!";
            DropInMessage.Visible   = true;
            DropInMessage.ForeColor = Color.FromArgb(0, 0, 0, 255);
            GetOrderData();
            ShowOrderData();
        }
Exemple #2
0
        // DragDrop handler for romrutene
        private void labels_DragDrop(object sender, DragEventArgs e)
        {
            if (e.Data.GetDataPresent(DataFormats.StringFormat))
            {
                string   labelString      = (sender as Label).Text;
                string[] splitLabelString = labelString.Split('\n'); //Splitter opp de tre linjene stringFromLabel hadde
                string   roomInfo         = splitLabelString[0];     //Henter første linje fra stringFromLabel, dette er rom X
                string[] splitRoomInfo    = roomInfo.Split(' ');     //Splitter opp stringen romInfo
                string   roomIDString     = splitRoomInfo[1];        //Henter det andre tegnet i stringen som er tallet
                int      roomID           = Int32.Parse(roomIDString) - 1;

                if (roomDataList.ElementAtOrDefault(roomID) == null)
                {
                    return;
                }

                Console.WriteLine(roomID);
                Console.WriteLine(roomDataList[roomID].assigned + "Dette er roomdata is assigned");

                if (roomDataList[roomID].wrongRoomType == false)
                {
                    if (roomDataList[roomID].assigned == false)
                    {
                        listBoxOrders.Items.RemoveAt(index);
                        DataRow row = DatabaseManager.GetRowWithSchema("booking");
                        row["romID"]        = roomID;
                        row["bestillingID"] = orderID;
                        row["fradato"]      = flippedFromDate;
                        row["tildato"]      = flippedToDate;
                        DatabaseManager.InsertRow("booking", row);

                        row            = DatabaseManager.FindRowInTable("bestillinger", orderID);
                        row["tildelt"] = "true";
                        DatabaseManager.UpdateRow("bestillinger", orderID.ToString(), row);

                        roomDataList[roomID].assigned = true;
                        ShowRoomData(selectedFloor);
                    }
                }
            }
        }