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