/// <summary> Gets the reservation event. </summary> /// <param name="itemId"> The item identifier. </param> private void GetReservationEvent(int itemId) { using (var reader = DBReservations.GetReservation(itemId)) if (reader.Read()) { ItemId = Convert.ToInt32(reader["ItemID"], CultureInfo.InvariantCulture); ModuleId = Convert.ToInt32(reader["ModuleID"], CultureInfo.InvariantCulture); Title = reader["Title"].ToString(); Description = reader["Description"].ToString(); ImageName = reader["ImageName"].ToString(); StartDate = Convert.ToDateTime(reader["StartDate"], CultureInfo.CurrentCulture); EndDate = Convert.ToDateTime(reader["StartDate"], CultureInfo.CurrentCulture); CreatedDate = Convert.ToDateTime(reader["CreatedDate"], CultureInfo.CurrentCulture); UserId = Convert.ToInt32(reader["UserID"], CultureInfo.InvariantCulture); UserGuid = new Guid(reader["UserGuid"].ToString()); Location = reader["Location"].ToString(); Latitude = reader["Latitude"].ToString(); Longitude = reader["Longitude"].ToString(); LastModUserId = Convert.ToInt32(reader["LastModUserId"], CultureInfo.InvariantCulture); var u = reader["ItemGuid"].ToString(); if (u.Length == 36) { ItemGuid = new Guid(u); } u = reader["UserGuid"].ToString(); if (u.Length == 36) { UserGuid = new Guid(u); } u = reader["LastModUserGuid"].ToString(); if (u.Length == 36) { LastModUserGuid = new Guid(u); } u = reader["ModuleGuid"].ToString(); if (u.Length == 36) { ModuleGuid = new Guid(u); } if (reader["LastModUtc"] != DBNull.Value) { LastModUtc = Convert.ToDateTime(reader["LastModUtc"], CultureInfo.CurrentCulture); } } }