//================================================================================
public List <vmMusicianResult> GetMusiciansByFirstLastNames(vmMusicianSearch vmMS)
{
List <vmMusicianResult> vmMRs = new List <vmMusicianResult>();
List <AppUser> aus = _repo.Query <AppUser>().Where(b => b.LastName == vmMS.LastName &&
b.FirstName == vmMS.FirstName).ToList();
if (aus == null)
{
return(null);
}
else
{
foreach (AppUser au in aus)
{
UserMusician um = _repo.Query <UserMusician>().Where(c => c.AppUserId == au.AppUserId).FirstOrDefault();
if (um != null)
{
Musician m = _repo.Query <Musician>().Where(d => d.MusicianId == um.MusicianId).FirstOrDefault();
MusicianInstrument mi = _repo.Query <MusicianInstrument>().Where(e => e.MusicianId == m.MusicianId && e.IsPrimary == true).FirstOrDefault();
Instrument i = _repo.Query <Instrument>().Where(f => f.InstrumentId == mi.InstrumentId).FirstOrDefault();
vmMusicianResult vmMRtemp = new vmMusicianResult
{
AppUserId = au.AppUserId,
FirstName = au.FirstName,
LastName = au.LastName,
City = au.City,
PrimeInstrument = i.InstrumentName
};
vmMRs.Add(vmMRtemp);
}
}
return(vmMRs);
}
}
//================================================================================
public List <vmMusicianResult> GetMusicianCitiesByInstrument(vmMusicianSearch vmMS)
{
List <vmMusicianResult> vmMRs = new List <vmMusicianResult>();
Instrument i = _repo.Query <Instrument>().Where(n => n.InstrumentName == vmMS.PrimeInstrument).FirstOrDefault();
if (i == null)
{
return(null);
}
else
{
List <MusicianInstrument> mis = _repo.Query <MusicianInstrument>().Where(q => q.InstrumentId == i.InstrumentId && q.IsPrimary == true).ToList();
foreach (MusicianInstrument mitemp in mis)
{
Musician mus = _repo.Query <Musician>().Where(r => r.MusicianId == mitemp.MusicianId).FirstOrDefault();
UserMusician um = _repo.Query <UserMusician>().Where(s => s.MusicianId == mus.MusicianId).FirstOrDefault();
AppUser au = _repo.Query <AppUser>().Where(t => t.AppUserId == um.AppUserId).FirstOrDefault();
vmMusicianResult vmMRtemp = new vmMusicianResult
{
AppUserId = au.AppUserId,
FirstName = au.FirstName,
LastName = au.LastName,
City = au.City,
PrimeInstrument = i.InstrumentName
};
vmMRs.Add(vmMRtemp);
}
return(vmMRs);
}
}
//================================================================================
public List <vmMusicianResult> GetMusiciansByCityInstrument(vmMusicianSearch vmMS)
{
List <vmMusicianResult> vmMRs = new List <vmMusicianResult>();
List <AppUser> aus = _repo.Query <AppUser>().Where(t => t.City == vmMS.City).ToList();
if (aus.Count == 0)
{
return(null);
}
else
{
foreach (AppUser au in aus)
{
UserMusician um = _repo.Query <UserMusician>().Where(s => s.AppUserId == au.AppUserId).FirstOrDefault();
if (um == null)
{
}
else
{
Musician mus = _repo.Query <Musician>().Where(r => r.MusicianId == um.MusicianId).FirstOrDefault();
if (mus == null)
{
}
else
{
MusicianInstrument mi = _repo.Query <MusicianInstrument>().Where(q => q.MusicianId == mus.MusicianId && q.IsPrimary == true).FirstOrDefault();
Instrument inst = _repo.Query <Instrument>().Where(n => n.InstrumentId ==
mi.InstrumentId).FirstOrDefault();
Instrument i = _repo.Query <Instrument>().Where(n => n.InstrumentName ==
vmMS.PrimeInstrument).FirstOrDefault();
if (i == null)
{
return(null);
}
else
{
if (inst.InstrumentId == i.InstrumentId)
{
vmMusicianResult vmMRtemp = new vmMusicianResult
{
AppUserId = au.AppUserId,
FirstName = au.FirstName,
LastName = au.LastName,
City = au.City,
PrimeInstrument = i.InstrumentName
};
vmMRs.Add(vmMRtemp);
}
}
}
}
}
return(vmMRs);
}
}
//================================================================================
public List <vmMusicianResult> GetMusicianInstrumentsByCity(vmMusicianSearch vmMS)
{
List <vmMusicianResult> vmMRs = new List <vmMusicianResult>();
List <AppUser> aus = _repo.Query <AppUser>().Where(g => g.City == vmMS.City).ToList();
if (aus.Count == 0)
{
return(null);
}
else
{
foreach (AppUser au in aus)
{
UserMusician um = _repo.Query <UserMusician>().Where(h => h.AppUserId == au.AppUserId).FirstOrDefault();
if (um == null)
{
}
else
{
Musician m = _repo.Query <Musician>().Where(j => j.MusicianId == um.MusicianId).FirstOrDefault();
MusicianInstrument mi = _repo.Query <MusicianInstrument>().Where(k => k.MusicianId == m.MusicianId && k.IsPrimary == true).FirstOrDefault();
Instrument i = _repo.Query <Instrument>().Where(mm => mm.InstrumentId == mi.InstrumentId).FirstOrDefault();
vmMusicianResult vmMRtemp = new vmMusicianResult
{
AppUserId = au.AppUserId,
LastName = au.LastName,
FirstName = au.FirstName,
City = au.City,
PrimeInstrument = i.InstrumentName
};
vmMRs.Add(vmMRtemp);
}
}
return(vmMRs);
}
}
