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