public IEnumerable <BibleVerse> GetAllVerses(VerseSearch passSearchCriteria)
{
BibleData PassToDataLayer = new BibleData();
IEnumerable <BibleVerse> allVerses = PassToDataLayer.getBibleVerses(passSearchCriteria);
return(allVerses);
}
private PothiShabad GetPothiShabadFromVerseSearch(VerseSearch vs)
{
PothiShabad pothiShabad = new PothiShabad();
pothiShabad.ShabadId = vs.ShabadId.Value;
pothiShabad.VerseId = vs.VerseID;
pothiShabad.PothiId = _pothi.PothiId.Value;
pothiShabad.SortOrder = vs.SortOrder;
pothiShabad.Notes = vs.Notes;
return(pothiShabad);
}
public async Task <IActionResult> Search(SearchViewModel search)
{
VerseSearch result = null;
if (ModelState.IsValid)
{
result = await _service.GetVerses(search.StartDate, search.TotalVerses);
}
return(View(result));
}
private void lstVerse_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
if (e.SelectedItem == null)
{
return;
}
VerseSearch verse = e.SelectedItem as VerseSearch;
InvokeBookmarkSelectedChanged(verse.VerseID);
Navigation.PopPopupAsync();
}
private async void lstVerse_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
if (e.SelectedItem == null)
{
return;
}
VerseSearch verse = e.SelectedItem as VerseSearch;
Shabad shabad = await _con.Table <Shabad>().FirstOrDefaultAsync(a => a.VerseID == verse.VerseID);
await Navigation.PushAsync(new ShabadDetails(shabad.ShabadID, verse.VerseID));
lstVerse.SelectedItem = null;
}
public IActionResult Index([Bind] VerseSearch objSearch)
{
List <BibleVerse> searchResults = new List <BibleVerse>();
//make SURE DATA IS VALUD
if (ModelState.IsValid)
{
BibleBusiness sendSearchCrit = new BibleBusiness();
searchResults = sendSearchCrit.GetAllVerses(objSearch).ToList();
return(View(searchResults));
}
return(View(searchResults));
}
private async void UpdateShabadMove(VerseSearch shabadUp, VerseSearch shabadDown)
{
try
{
string query = Queries.UpdateSortOrder(_pothi.PothiId.Value, shabadUp.ShabadId.Value, shabadUp.SortOrder.Value);
int updated = await _con.ExecuteAsync(query);
if (updated > 0)
{
query = Queries.UpdateSortOrder(_pothi.PothiId.Value, shabadDown.ShabadId.Value, shabadDown.SortOrder.Value);
updated = await _con.ExecuteAsync(query);
}
}
catch { }
}
private void MoveDown_Clicked(object sender, EventArgs e)
{
VerseSearch search = (sender as ImageButton).CommandParameter as VerseSearch;
int index = VerseObs.IndexOf(search);
if (index < VerseObs.Count - 1)
{
VerseSearch next = VerseObs[index + 1];
VerseObs.Remove(next);
VerseObs.Insert(index, next);
VerseObs[index].SortOrder = index + 1;
VerseObs[index + 1].SortOrder = index + 2;
UpdateShabadMove(VerseObs[index], VerseObs[index + 1]);
}
}
private void MoveUp_Clicked(object sender, EventArgs e)
{
VerseSearch search = (sender as ImageButton).CommandParameter as VerseSearch;
int index = VerseObs.IndexOf(search);
if (index > 0)
{
VerseSearch prior = VerseObs[index - 1];
VerseObs.Remove(prior);
VerseObs.Insert(index, prior);
VerseObs[index].SortOrder = index + 1;
VerseObs[index - 1].SortOrder = index;
UpdateShabadMove(VerseObs[index], VerseObs[index - 1]);
}
}
public async Task <bool> Add(SearchViewModel search)
{
if (!ModelState.IsValid)
{
return(false);
}
VerseSearch result = await _service.GetVerses(search.StartDate, search.TotalVerses);
if (result == null)
{
throw new Exception("No verses found.");
}
if (_context.FavoriteVerses.Where(i => i.Id == search.Id).FirstOrDefault() == null)
{
var favorite = _service.GetVerseById(result.Verses, search.Id);
await _context.AddAsync(favorite);
await _context.SaveChangesAsync();
}
return(true);
}
//iemurable in c# is an interface that defines one method
//this allows readonly accessto a collection than a collection that
//implements IEmurable can be used witha= a for-each loop
public IEnumerable <BibleVerse> getBibleVerses(VerseSearch searchCriteria)
{
string testamentSearch = "";
//create the transpot
List <BibleVerse> searchResults = new List <BibleVerse>();
using (SqlConnection connection = new SqlConnection(connString))
{
connection.Open();
if (searchCriteria.Testament == "OT")
{
testamentSearch = " AND key_english.t = 'OT'";
}
else if (searchCriteria.Testament == "NT")
{
testamentSearch = " AND key_english.t= 'NT'";
}
else
{
testamentSearch = "";
}
//define the query
string query = string.Format(@"SELECT bible.t AS Text, bible.b, bible.c AS Chapter, bible.v AS Verse, key_english.n AS Book, key_english.t AS Testament, key_english.g, key_genre_english.g, key_genre_english.n AS Genre
FROM {0} Bible
JOIN key_english
ON bible.b = key_english.b
JOIN key_genre_English
ON key_english.g = key_genre_english.g
WHERE bible.t LIKE '%{1}%' {2}
ORDER BY bible.b, Chapter, Verse", searchCriteria.BibleVersion, searchCriteria.Text, testamentSearch);
using (SqlCommand command = new SqlCommand(query, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
//INSTIATE our bibleverse class creating an object
//called verse
BibleVerse verse = new BibleVerse();
//populate this object with a verse that was found
verse.BookName = reader["Book"].ToString();
verse.Chapter = Convert.ToInt32(reader["Chapter"].ToString());
verse.Verse = Convert.ToInt32(reader["Verse"].ToString());
verse.Genre = reader["Genre"].ToString();
if (reader["Testament"].ToString() == "OT")
{
verse.OT_NT = "Old Testament";
}
else
{
verse.OT_NT = "New Testament";
}
verse.Text = reader["Text"].ToString();
searchResults.Add(verse);
}
}
}
}
return(searchResults);
}
