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