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