public void DeleteGuestFromAllEvents(DTO.Guest selectedGuest) { if (DeleteConfirmation("ALL EVENTS")) { _guestRepository.DeleteGuestFromAllEvents(selectedGuest); } }
public void AddGuest(DTO.Guest newDTOGuest) { Guest newModelGuest = new Guest(); convertToModelGuest(newDTOGuest, newModelGuest); try { using (var db = new GuestAppContext()) { var existingGuest = db.Guests.Find(newDTOGuest.Id); if (existingGuest != null) { db.EventsGuests.Add(new EventGuest { EventId = _currentEvent.Id, GuestId = newDTOGuest.Id }); } else { db.EventsGuests.Add(new EventGuest { EventId = _currentEvent.Id, Guest = newModelGuest }); } db.SaveChanges(); } } catch (Exception ex) { MessageBoxError(ex.Message); } }
public void RemoveGuestFromCurrentEvent(DTO.Guest selectedGuest) { if (DeleteConfirmation(_currentEvent.Name)) { _guestRepository.RemoveGuestFromCurrentEvent(selectedGuest); } }
public async Task <GuestChecker> SearchListAsync(DTO.Guest searchGuest) { var fullList = await _guestRepository.GetGuestListAsync(); var searchList = Search(searchGuest, fullList).ToList(); searchList = Counter.AddCounterToGuestList(searchList); return(guestChecker(fullList, searchList)); }
public void EditGuest(DTO.Guest usersSelectedGuestToEdit) { _guestRepository.UsersSelectedGuestToEdit = usersSelectedGuestToEdit; Model.Guest modelGuestToEdit = _guestRepository.ModelGuestToEdit; var listOfChanges = ListOfChanges(usersSelectedGuestToEdit, modelGuestToEdit); bool canEdit = (listOfChanges.Count > 0) ? UsersConfirmation(listOfChanges) : false; if (canEdit) { _guestRepository.EditGuestDetails(); } }
private void convertToModelGuest(DTO.Guest DTOGuest, Guest modelGuest) { modelGuest.GuestTitle = DTOGuest.GuestTitle; modelGuest.FirstNames = DTOGuest.FirstNames; modelGuest.LastName = DTOGuest.LastName; modelGuest.FullName = DTOGuest.FullName; modelGuest.HouseNumber = DTOGuest.HouseNumber; modelGuest.Street = DTOGuest.Street; modelGuest.RegionId = GetRegionId(DTOGuest.Region); modelGuest.CityId = (int)GetCityId(DTOGuest.City); modelGuest.Zip = DTOGuest.Zip; modelGuest.IsFamily = DTOGuest.IsFamily; }
private bool GuestExist(DTO.Guest newGuest) { var allGuests = _guestRepository.GetEventGuests(); if (allGuests.Any(g => g.Zip.ToUpper().Replace(" ", string.Empty).Equals(newGuest.Zip.ToUpper().Replace(" ", string.Empty)) && g.HouseNumber == newGuest.HouseNumber) == true) { return(true); } else { return(false); } }
public List <DTO.Guest> SPSearch(DTO.Guest SearchGuest) { try { using (var db = new GuestAppContext()) { return(db.Guests.FromSqlRaw(String.Format("EXECUTE GuestFinder {0},{1},{2},{3},{4},{5};", _userId, _currentEvent.Id, SearchGuest.FullName, SearchGuest.Street, SearchGuest.City, SearchGuest.Region)).ToList().ToDTOGuestList()); } } catch (Exception ex) { MessageBoxError(ex.Message); } return(null); }
public void AddGuest(DTO.Guest newGuest) { if (EmptyFields(newGuest) == true) { return; } if (GuestExist(newGuest) == false) { _guestRepository.AddGuest(newGuest); } else { _usersMessageService.GuestExistsElert(); } }
public void DeleteGuestFromAllEvents(DTO.Guest SelectedGuest) { try { using (var db = new GuestAppContext()) { var guestToDelete = db.Guests.Find(SelectedGuest.Id); db.Guests.Remove(guestToDelete); db.SaveChanges(); } } catch (Exception ex) { MessageBoxError(ex.InnerException.Message); } }
public void RemoveGuestFromCurrentEvent(DTO.Guest selectedGuest) { try { using (var db = new GuestAppContext()) { var guestToDelete = db.EventsGuests.SingleOrDefault(eg => eg.EventId == _currentEvent.Id && eg.GuestId == selectedGuest.Id); db.EventsGuests.Remove(guestToDelete); db.SaveChanges(); } } catch (Exception ex) { MessageBoxError(ex.InnerException.Message); } }
public static ObservableCollection <DTO.Guest> CustomizedList(object obj) { var selectedGuests = (IEnumerable <object>)obj; foreach (var guest in selectedGuests) { DTO.Guest selectedGuest = guest as DTO.Guest; if (selectedGuest != null) { if (_customizedList.Any(c => c.Id == selectedGuest.Id) != true && selectedGuest.Id != 0) { _customizedList.Add(selectedGuest); } } } return(Counter.AddCounterToGuestList(_customizedList.ToList()).ToObservableCollection()); }
private bool EmptyFields(DTO.Guest newGuest) { if (string.IsNullOrEmpty(newGuest.FirstNames) || string.IsNullOrEmpty(newGuest.LastName) || string.IsNullOrEmpty(newGuest.HouseNumber) || string.IsNullOrEmpty(newGuest.Street) || string.IsNullOrEmpty(newGuest.City) || string.IsNullOrEmpty(newGuest.Zip)) { _usersMessageService.EmptyFieldsAlert(); return(true); } else if (string.IsNullOrEmpty(newGuest.Region)) { newGuest.Region = "NA"; } return(false); }
private List <string> ListOfChanges(DTO.Guest selectedDTOGuest, Model.Guest modelGuestToEdit) { List <string> changes = new List <string>(); if (modelGuestToEdit.GuestTitle != selectedDTOGuest.GuestTitle) { changes.Add(" Title"); } if (modelGuestToEdit.FirstNames != selectedDTOGuest.FirstNames) { changes.Add(" First names"); } if (modelGuestToEdit.LastName != selectedDTOGuest.LastName) { changes.Add(" Family name"); } if (modelGuestToEdit.HouseNumber != selectedDTOGuest.HouseNumber) { changes.Add(" House Number"); } if (modelGuestToEdit.Street != selectedDTOGuest.Street) { changes.Add(" Street Name"); } if (modelGuestToEdit.RegionId.GetValueOrDefault() != _guestRepository.GetRegionId(selectedDTOGuest.Region)) { changes.Add(" Region"); } if (modelGuestToEdit.CityId != _guestRepository.GetCityId(selectedDTOGuest.City)) { changes.Add(" City Name"); } if (modelGuestToEdit.Zip != selectedDTOGuest.Zip) { changes.Add(" Zip"); } if (modelGuestToEdit.IsFamily != selectedDTOGuest.IsFamily) { changes.Add(" the family Check Box"); } return(changes); }
public static List <DTO.Guest> ToDTOGuestList(this List <Model.Guest> modelGuestList) { List <DTO.Guest> DTOList = new List <DTO.Guest>(); foreach (var modelGuest in modelGuestList) { DTO.Guest dtoGuest = new DTO.Guest(); dtoGuest.Id = modelGuest.Id; dtoGuest.FirstNames = modelGuest.FirstNames; dtoGuest.LastName = modelGuest.LastName; dtoGuest.GuestTitle = modelGuest.GuestTitle; dtoGuest.HouseNumber = modelGuest.HouseNumber; dtoGuest.Street = modelGuest.Street; dtoGuest.Region = modelGuest.Region.Name; dtoGuest.City = modelGuest.City.Name; dtoGuest.Zip = modelGuest.Zip; dtoGuest.IsFamily = modelGuest.IsFamily; DTOList.Add(dtoGuest); } return(DTOList); }