public ActionResult SubmitEntry(BibleDisplayObject displayObject)
{
//Dependency Injection for Logger
UnityContainer container = new UnityContainer();
container.RegisterType <ILogger, Logger>();
var logger = container.Resolve <ILogger>();
logger = LogManager.GetLogger("bibleAppLoggerRules");
logger.Info("Entered SubmitEntry in Controller");
try
{
entryService entry = new entryService();
displayObject = entry.entry(displayObject);
logger.Info("Successfully exiting SubmitEntry in Controller");
return(View("VerseEntryView", displayObject));
}
catch (Exception e)
{
logger.Error("Exception: " + e.Message);
return(Content(e.Message));
}
}
public void convertToData(BibleDisplayObject displayObject, BibleDataObject dataObject)
{
BooksInBible books = new BooksInBible();
foreach (Book b in books.booksOfBible)
{
if (b.Name == displayObject.Book)
{
dataObject.BookSelection = b.referenceNum;
}
}
dataObject.ChapterNumber = displayObject.Chapter;
dataObject.VerseNumber = displayObject.Verse;
}
public BibleDisplayObject entry(BibleDisplayObject displayObject)
{
BibleDataObject dataObject = new BibleDataObject();
convertToData(displayObject, dataObject);
string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Bible Database;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
string query = "select * from dbo.t_asv where b = @book and c = @chapter and v = @verse";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@book", System.Data.SqlDbType.Int).Value = dataObject.BookSelection;
command.Parameters.Add("@chapter", System.Data.SqlDbType.Int).Value = dataObject.ChapterNumber;
command.Parameters.Add("@verse", System.Data.SqlDbType.Int).Value = dataObject.VerseNumber;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dataObject.VerseText = reader.GetString(4);
}
}
reader.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
displayObject.VerseText = dataObject.VerseText != null ? dataObject.VerseText : "An error has occurred. The database could not find your entry.";
return(displayObject);
}
