//================================================================================
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 vmMusicianSearch testvmMSInput(vmMusicianSearch vmMStoTest)
{
//Test for last name.
AppUser testLastName = _repo.Query <AppUser>().Where(a => a.LastName == vmMStoTest.LastName).FirstOrDefault();
if (testLastName == null)
{
vmMStoTest.LastName = null;
}
AppUser testFirstName = _repo.Query <AppUser>().Where(b => b.FirstName == vmMStoTest.FirstName).FirstOrDefault();
if (testFirstName == null)
{
vmMStoTest.FirstName = null;
}
AppUser testCity = _repo.Query <AppUser>().Where(c => c.City == vmMStoTest.City).FirstOrDefault();
if (testCity == null)
{
vmMStoTest.City = null;
}
Instrument testInst = _repo.Query <Instrument>().Where(d => d.InstrumentName == vmMStoTest.PrimeInstrument).FirstOrDefault();
if (testInst == null)
{
vmMStoTest.PrimeInstrument = null;
}
return(vmMStoTest);
}
//================================================================================
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);
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.SearchResults);
mListView = FindViewById <ListView>(Resource.Id.SearchResultListView);
vmMusicianSearch mSearchParam = JsonConvert.DeserializeObject <vmMusicianSearch>(Intent.GetStringExtra("searchParam"));
vmMusicianProfile mRegisteredUser = JsonConvert.DeserializeObject <vmMusicianProfile>(Intent.GetStringExtra("regUser"));
//Perform Search
GetMusicianSearch(mSearchParam);
}
//=================================================================
//Get a list of musicians. Use the post method to pass an object to the servier side from the client side. Return either a single vmMusicianSearch object (Last name, first name, city, and primary instrument) if the last name is described or a list of vmMusicianSearch objects if either the the city or prime instrument is described.
// POST: api/MusicianSearch
public List <vmMusicianResult> Post([FromBody] vmMusicianSearch vmMS)
{
List <vmMusicianResult> vmMusicianResults = new List <vmMusicianResult>();
if (ModelState.IsValid)
{
vmMusicianResults = service.GetMusicians(vmMS);
return(vmMusicianResults);
}
else
{
BadRequest("No data found to match the request.");
}
return(null);
}
void mSearchResults_Click(object sender, EventArgs r)
{
//Build musician search object
vmMusicianSearch searchParam = new vmMusicianSearch
{
FirstName = mFirtName.Text.Trim(),
LastName = MLastName.Text.Trim(),
City = mCity.SelectedItem.ToString(),
PrimeInstrument = MPrimeInst.SelectedItem.ToString()
};
ProgressDialog progressBar = new ProgressDialog(this);
progressBar.SetCancelable(true);
//progressBar.SetMessage("Page is Loading...");
progressBar.SetProgressStyle(ProgressDialogStyle.Horizontal);
progressBar.Progress = 0;
progressBar.Max = 100;
progressBar.Show();
progressBarStatus = 0;
//Run Thread and increase preogress value
new Thread(new ThreadStart(delegate {
while (progressBarStatus < 100)
{
progressBarStatus += 10;
progressBar.Progress += progressBarStatus;
Thread.Sleep(100);
}
// RunOnUiThread(() => { progressBar.SetMessage("File is downloaded..."); });
// //progressBar.SetMessage("File is downloaded...");
// //Toast.MakeText(this, "File is downloaded", ToastLength.Long).Show();
})).Start();
Intent intent = new Intent(this, typeof(searchResults));
//Send the search package
intent.PutExtra("searchParam", JsonConvert.SerializeObject(searchParam));
intent.PutExtra("regUser", JsonConvert.SerializeObject(mRegisteredUser));
this.StartActivity(intent);
this.OverridePendingTransition(Resource.Animation.slide_in_top, Resource.Animation.slide_out_bottom);
}
//Get vmMusicianSearch results into adapter ==================Method not working yet. =================================
private async void GetMusicianSearch(vmMusicianSearch searchParam)
{
mUserInfo = await userdata.GetMusicianSearch(searchParam);
//Test for results
if (mUserInfo.Count > 0)
{
SearchListAdapter adapter = new SearchListAdapter(this, mUserInfo);
mListView.Adapter = adapter;
mListView.ItemClick += MListView_ItemClick;
}
else
{
SearchListAdapter adapter = new SearchListAdapter(this, mUserInfo);
mListView.Adapter = adapter;
mListView.ItemClick += MListView_ItemClick;
}
}
//=========================================================
//Methods().
//=========================================================
//If the StageName is provided query the data base by StageName.
public List <vmMusicianResult> GetMusicians(vmMusicianSearch vmMStoTest)
{
vmMusicianSearch vmMS = testvmMSInput(vmMStoTest);
List <vmMusicianResult> vmMRs = new List <vmMusicianResult>();
//1. LastName and FirstName provided.
//2. LastName only.
//3. FirstName only.
if (!string.IsNullOrEmpty(vmMS.LastName) && !string.IsNullOrEmpty(vmMS.FirstName))
{
vmMRs = GetMusiciansByFirstLastNames(vmMS);
}
else if (!string.IsNullOrEmpty(vmMS.LastName))
{
vmMRs = GetMusicianByLastName(vmMS);
}
else if (!string.IsNullOrEmpty(vmMS.FirstName))
{
vmMRs = GetMusicianByFirstName(vmMS);
}
else
{
//1. Last name and first name are null or empty. City is described.
//2. Last name and first name are null or empty. City is null. Prime instrument is described.
//3. Last name and first name are null or empty. City and prime instrument are described.
if (!string.IsNullOrEmpty(vmMS.City) && !string.IsNullOrEmpty(vmMS.PrimeInstrument))
{
vmMRs = GetMusiciansByCityInstrument(vmMS);
}
else if (!string.IsNullOrEmpty(vmMS.City))
{
vmMRs = GetMusicianInstrumentsByCity(vmMS);
}
else if (!string.IsNullOrEmpty(vmMS.PrimeInstrument))
{
vmMRs = GetMusicianCitiesByInstrument(vmMS);
}
}
return(vmMRs);
}
// Get Musician Search
public async Task <List <vmMusicianResult> > GetMusicianSearch(vmMusicianSearch mSearchParam)
{
// Create http client
HttpClient client = await GetClient();
//Serialize object to JSON
var data = JsonConvert.SerializeObject(mSearchParam);
//Convert it to a formated stringcontent byte array
var content = new StringContent(data, Encoding.UTF8, "application/json");
//Send the data
var response = await client.PostAsync(string.Concat(applicationURL, "musiciansearch/"), content);
//return the response as a vmMusicianSearch object
var userMusicians = JsonConvert.DeserializeObject <List <vmMusicianResult> >(
await response.Content.ReadAsStringAsync());
//Console.WriteLine(userMusicians.Count);
return(userMusicians);
}
//================================================================================
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);
}
}
