//Henter alle registrerte bookinger i databasen som ikke har utgått (før dags dato) public List <Booking> GetData() { DataRow[] result = DatabaseManager.SelectFromTable("booking", "tildato >= #" + DateTime.Now.ToString(dateFormat) + "#"); //DatabaseManager.Query("SELECT * FROM booking WHERE tildato >= CURDATE();"); if (result == null) { Console.WriteLine("BookingData.GetData: Datasettet er tomt"); return(null); } List <Booking> bookings = new List <Booking>(); int bookingID; int roomID; int orderID; string fromDate; string toDate; foreach (DataRow row in result) { bookingID = (int)row["bookingID"]; roomID = (int)row["romID"]; orderID = (int)row["bestillingID"]; fromDate = ((DateTime)row["fradato"]).ToShortDateString(); toDate = ((DateTime)row["tildato"]).ToShortDateString(); bookings.Add(new Booking(bookingID, roomID, orderID, fromDate, toDate)); } return(bookings); }
// Finn alle rom som er ledige for en periode public static List <Room> GetAvailableRoomsForPeriod(string fromDate, string toDate) { //DataSet result = DatabaseManager.Query // ( // "SELECT romID FROM rom WHERE romID NOT IN (SELECT romID FROM booking WHERE tildato >= CURDATE() AND (fradato <= '" + toDate + "') AND ('" + fromDate + "' <= tildato));" // ); string fromDateCorrect = (DateTime.Parse(fromDate)).ToString(dateFormat); string toDateCorrect = (DateTime.Parse(toDate)).ToString(dateFormat); string curDate = DateTime.Now.ToString(dateFormat); string subString = ""; DataRow[] sub = DatabaseManager.SelectFromTable ( "booking", "tildato >= #" + curDate + "# AND (fradato <= #" + toDateCorrect + "#) AND (#" + fromDateCorrect + "# <= tildato)" ); int roomID; foreach (DataRow row in sub) { roomID = (int)row["romID"]; subString += roomID + ","; } if (subString.Length > 0) { subString = subString.Remove(subString.Length - 1); } else { subString = "-999"; } DataRow[] result = DatabaseManager.SelectFromTable ( "rom", "romID NOT IN (" + subString + ")" ); if (result == null) { Console.WriteLine("BookingData.GetAvailableRoomsForPeriod: Datasettet er tomt"); return(new List <Room>()); } List <Room> availableRooms = new List <Room>(); foreach (DataRow row in result) { roomID = (int)row["romID"]; availableRooms.Add(new Room(roomID, "Ukjent", false, false)); } return(availableRooms); }
// Fyll inn nødvendig data i drop-in skjemaet private void GetDropInData() { DataRow[] result = DatabaseManager.SelectFromTable("romtyper", "romtype <> 'xdxdxdxd'"); //DatabaseManager.Query("SELECT romtype FROM romtyper;"); // TODO: må fikse han karen her, funker ikke i offline modus string roomType; if (result == null) { return; } foreach (DataRow row in result) { roomType = (string)row["romtype"]; dropInComboBox.Items.Add(CultureInfo.CurrentCulture.TextInfo.ToTitleCase(roomType.ToLower())); } dropInComboBox.SelectedIndex = 0; }
// Hent data som vi trenger om bestillinger public List <Order> GetData() { DataTable result = null; try { result = DatabaseManager.SelectFromTable("bestillinger", "tildelt = false").CopyToDataTable(); } catch (InvalidOperationException) { } if (result == null) { Console.WriteLine("OrderData.GetData: Datasettet er tomt"); return(null); } List <Order> OrderList = new List <Order>(); int orderID; string roomType; DateTime fromDate; DateTime toDate; string assigned; int phoneNumber; string firstName; string lastName; foreach (DataRow row in result.Rows) { orderID = (int)row["bestillingID"]; roomType = (string)row["romtype"]; fromDate = (DateTime)row["fradato"]; toDate = (DateTime)row["tildato"]; assigned = (string)row["tildelt"]; // == "false") ? false : true; marius bøll phoneNumber = (int)row["tlf"]; firstName = (string)row["fornavn"]; lastName = (string)row["etternavn"]; string fromDateString = fromDate.ToShortDateString(); string toDateString = toDate.ToShortDateString(); Order order = new Order(orderID, roomType, fromDateString, toDateString, assigned, phoneNumber, firstName, lastName); OrderList.Add(order); } return(OrderList); }
// Sjekk om et angitt rom er ledig for en gitt periode public static bool IsRoomOccupiedForPeriod(int roomID, string fromDate, string toDate) { //DataSet result = DatabaseManager.Query //( //"SELECT romID FROM booking WHERE tildato >= CURDATE() AND romID = " + roomID + " AND (fradato <= '" + toDate + "') AND ('" + fromDate + "' <= tildato);" //); string fromDateCorrect = (DateTime.Parse(fromDate)).ToString(dateFormat); string toDateCorrect = (DateTime.Parse(toDate)).ToString(dateFormat); string curDate = DateTime.Now.ToString(dateFormat); int count = DatabaseManager.SelectFromTable ( "booking", "tildato >= #" + curDate + "#" + " AND romID = " + roomID + " AND (fradato <= #" + toDateCorrect + "#)" + " AND (#" + fromDateCorrect + "# <= tildato);" ).Length; return((count == 0) ? false : true); }