public static DataReservation ToDataReservation(this Reservation reservation, bool exists)
{
var result = new DataReservation
{
ReservationNumber = reservation.ReservationNumber,
Start = reservation.Start,
NuberOfPersons = reservation.NuberOfPersons,
BookerReference = reservation.BookerReference,
BookingNumber = reservation.BookingNumber,
FloorLevel = reservation.FloorLevel,
Active = reservation.Active,
RestautantId = reservation.RestautantId,
ShowPrice = reservation.ShowPrice,
Deleted = reservation.Deleted
};
if (exists)
{
result.AlteredBy = Guid.Empty;
result.Altered = DateTimeOffset.Now;
}
else
{
result.CreatedBy = Guid.Empty;
result.Created = DateTimeOffset.Now;
}
return(result);
}
public static Reservation ToReservation(this DataReservation reservation)
{
return(new Reservation
{
ReservationNumber = reservation.ReservationNumber,
Start = reservation.Start,
NuberOfPersons = reservation.NuberOfPersons,
BookerReference = reservation.BookerReference,
BookingNumber = reservation.BookingNumber,
FloorLevel = reservation.FloorLevel,
Active = reservation.Active,
RestautantId = reservation.RestautantId,
ShowPrice = reservation.ShowPrice,
Deleted = reservation.Deleted
});
}
public WorkStation readWorkStationBusy(int id, string startTime, string date)
{
DataReservation dataReservation = new DataReservation();
WorkStation workStation = new WorkStation();
SqlConnection con = DatabaseConnection("open");
SqlCommand cmd = new SqlCommand("readWorkStationEDIT", con);
cmd.Parameters.AddWithValue("@id", id);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
workStation.Id = reader.GetInt32(reader.GetOrdinal("id"));
workStation.Description = reader.GetString(reader.GetOrdinal("description"));
workStation.IdLab = reader.GetInt32(reader.GetOrdinal("idLab"));
workStation.Busy = dataReservation.SelectAvailabilityStation(id, startTime, date);
}
cmd.Dispose();
DatabaseConnection("close");
return(workStation);
}
