/// <summary> /// Inserts the new rented room in the table designated them /// </summary> /// <param name="renter"></param> public static void InsertRenter(Entities.Rent_Rooms renter, Entities.RentCars car) { using (OracleConnection conn = DatabaseConection.GetOracleConnection()) { using (OracleCommand OA = new OracleCommand("Make_Reservation", conn)) { OA.CommandType = CommandType.StoredProcedure; OracleParameter OP1 = new OracleParameter(); OP1.ParameterName = "RoomID"; OP1.OracleDbType = OracleDbType.Int32; OP1.Direction = System.Data.ParameterDirection.Input; OP1.Value = renter.ROOM_ID; OracleParameter OP2 = new OracleParameter(); OP2.ParameterName = "dateS"; OP2.OracleDbType = OracleDbType.Date; OP2.Direction = System.Data.ParameterDirection.Input; OP2.Value = renter.START_DATE; OracleParameter OP3 = new OracleParameter(); OP3.ParameterName = "dateE"; OP3.OracleDbType = OracleDbType.Date; OP3.Direction = System.Data.ParameterDirection.Input; OP3.Value = renter.END_DATE; OracleParameter OP4 = new OracleParameter(); OP4.ParameterName = "ReservID"; OP4.OracleDbType = OracleDbType.Varchar2; OP4.Direction = System.Data.ParameterDirection.Input; OP4.Value = renter.ReservationID; OracleParameter OP5 = new OracleParameter(); OP5.ParameterName = "Car"; if (car != null) { OP5.OracleDbType = OracleDbType.Int32; OP5.Direction = System.Data.ParameterDirection.Input; OP5.Value = car.RENT_CARS_TYPE_ID.ToString(); } else { OP5.OracleDbType = OracleDbType.Int32; OP5.Direction = System.Data.ParameterDirection.Input; OP5.Value = DBNull.Value; } OA.Parameters.Add(OP2); OA.Parameters.Add(OP3); OA.Parameters.Add(OP1); OA.Parameters.Add(OP4); OA.Parameters.Add(OP5); OA.ExecuteNonQuery(); } } }
public static void WriteCSV(Entities.Rent_Rooms rent_Rooms, Entities.Rooms rooms) { string path = @"Rents.csv"; if (File.Exists(path)) { using (var csv = new StreamWriter(path, true)) { csv.WriteLine(String.Format("{0},{1},{2},{3},{4},{5}", rooms.Hotel_ID, rooms.Room_ID, rooms.Room_Name, rent_Rooms.ReservationID, rent_Rooms.START_DATE, rent_Rooms.END_DATE)); } } else { using (var csv = new StreamWriter(path, true)) { csv.WriteLine("Hotel,Room,Room type,Boocking ID,Boovking start date, boovking end date"); } WriteCSV(rent_Rooms, rooms); } }